At a Glance

• The Solution: Use SaasAnt's Download (Export) feature to extract Credit Card Credit transactions into a clean Excel/CSV format.

• The Key Benefit: Get a flat database file of all vendor refunds and returns posted to your credit cards—ready for statement reconciliation or net expense reporting.

• Quick Steps: Quick Access Dashboard > Download (Export) > Select Credit Card Credits > Search > Download.

Getting Started

• Install: Get SaasAnt Transactions from the QuickBooks App Store and start a free trial.

• Connect: Securely authorize the connection to your QuickBooks Online company. We do not store your customer data; we simply process the transfer.

How to Export Credit Card Credits Step-by-Step

1. Navigate to Download (Export)

From the Quick Access dashboard (your default home screen), click the Download (Export) button listed in the main menu.​

2. Select Entity

In the Transaction/List dropdown, select Credit Card Credits.​

3. Select Date Strategy

Choose the date type that matches your goal:​

• Search By Transaction Date: Exports based on the date the credit was posted. Use this for statement reconciliation and net expense reporting.

• Search By Created Date: Exports based on when the record was entered into QuickBooks. Use this to review recent data entry by your bookkeeper.

• Search By Last Updated Date: Exports based on when the record was last modified. Use this to identify any corrections made to existing credits.

4. Set Date Range & Format

• Range: Enter your start and end dates.

• Format: Use the dropdown inside the date box to pick your preferred format (e.g., MM/DD/YYYY).

5. Select Template

In the Use Saved Template dropdown, leave it as Simple Mapping for a standard export.

• Tip: Create a custom template if you need it for your reconciliation workflow.

6. Configure Filters & Search

Use the advanced filters to isolate specific credits:​

• Total Amount: Enter a From Amount and To Amount to find credits within a specific value range (e.g., credits over $500 for high-value return tracking).

• Reference No: Input a specific reference number to locate a single credit transaction for audit purposes.

• Show Records From (Start At): Use this to chunk large exports. If you need to export 5,000 records, run 1–2,500 first, then run a second search starting at 2,501.

Click the blue Search button to preview the results.​

7. Review & Download

After clicking Search, the data preview grid will load:​

• Verify Payees: Confirm the vendor names match the vendors who issued the refund, not the original purchaser.

• Check Accounts: Scan the Category column to ensure the credit was posted back to the same expense account as the original purchase.

• Total Records: Check the "Total records found" count to confirm the expected volume.

• Select Format: Click the Download button at the bottom right, choose .xlsx (Excel) or .csv, and the file will download.​

Automate with Backup

The steps above are for manual exports. If you need a regular archive of credit card credits for monthly reconciliation, use the Backup module.

• Set it and forget it: Schedule daily, weekly, or monthly exports.

• Delivery: Have files automatically sent to email, FTP, or storage integrations without logging in.

Why export credit card credits with SaasAnt?

• Statement Reconciliation: Match each credit in your export against the corresponding line on your bank feed to ensure no refunds are missing or miscategorized.

• Net Expense Reporting: Combine this export with your Expenses export for the same period to calculate the true net spend per category (Expenses minus Credits).

• Audit Trails: Verify that every credit is posted to the same expense account as the original purchase, which is a common bookkeeping error that distorts P&L reports.

FAQ

What is the difference between a credit card credit and a vendor credit in QuickBooks?

A credit card credit records a refund that comes back directly to your credit card (reducing the card balance). A vendor credit records money owed to you by a vendor that can be applied against a future bill—it does not affect your credit card balance directly.

Can I use this export to reconcile my credit card statement?

Yes. Export all credits for the statement period using Search By Transaction Date and compare them line by line against the credits shown on your credit card statement.

Can I use this file to migrate data to another QBO company?

Yes. The export format is natively compatible with SaasAnt's Import feature for migration purposes.