At a Glance

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

• The Key Benefit: Get a flat database file showing each credit memo's total value, remaining balance, and customer—ideal for identifying unapplied credits that distort your Accounts Receivable.

• Quick Steps: Quick Access Dashboard > Download (Export) > Select Credit Memos > 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 Memos 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 Memos.​

3. Select Date Strategy

Choose the Date Type that matches your goal:​

• Search By Transaction Date: Exports based on the date on the credit memo itself. This is the accounting date used for AR aging reports and period-end reporting. Use this when you need to match credits to the period they were issued.

• Search By Created Date: Exports based on when the credit memo was entered into QuickBooks. Use this to audit when your bookkeeper recorded the entries, independent of the credit date.

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

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 reporting workflow using 'Add new template' option.

6. Configure Filters & Search

Use the advanced filters to isolate specific credit memos:​

• Total Amount Range: Enter a From Amount and To Amount to find credit memos within a specific value range.

• Balance Range: Filter by the remaining unapplied balance on the credit memo. This is the fastest way to identify unapplied credits distorting your AR.

• Customer: Enter a customer name to export all credit memos for a single customer account.

• Reference No: Input a specific credit memo number to locate a single transaction.

• 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 results.​

7. Review & Download

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

• Verify Customers: Confirm that the Customer column matches the accounts you intended to pull.

• Total Records: Check the "Total records found" count at the top of the grid 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 memos for month-end AR review, 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 Memos with SaasAnt?

• Unapplied Credit Review: Use the Balance Range filter to pull all open credit memos at period-end. Unapplied credits inflate AR balances and must be cleared before financial close.

• Customer Account Reconciliation: Export all credit memos for a specific customer alongside their invoices and payments to build a complete AR statement.

• Migration: Move credit memo history to a new QBO company file, ensuring customer credits carry over and are not lost during the transition.

FAQ

What is the difference between a Credit Memo and a Refund Receipt?

A Credit Memo issues a credit to the customer's account that can be applied to a future or existing invoice—no money changes hands. A Refund Receipt is used when you are returning money directly to the customer via cash, check, or card.​

Can I use this file to migrate credit memos to another QBO company?

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