At a Glance

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

• The Key Benefit: Get a flat database file of all customer payments, including the invoices they were applied to—essential for cash flow analysis, AR reconciliation, and identifying unapplied payments causing P&L distortions.

• Quick Steps: Quick Access > Download (Export) > Select Received Payments > 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 Received Payments Step-by-Step

1. Navigate to Download (Export)

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

2. Select Entity

In the Transaction/List dropdown, select Received Payments.​

3. Select Date Strategy

Choose the date type that matches your goal:​

• Search By Transaction Date: Exports based on the date the payment was received. Use this for cash flow reporting, bank deposit matching, and month-end AR reconciliation.

• Search By Created Date: Exports based on when the payment was entered into QuickBooks. Use this to audit data entry timing—for example, identifying payments recorded after period-end that are backdated to a prior period, which can distort cash basis P&L reports.

• Search By Last Updated Date: Exports based on when the payment record was last modified. Use this to catch payments that were edited after being recorded—such as a payment that was unapplied from one invoice and reapplied to another.​

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 the Add new template option.

6. Configure Filters & Search

Use the available filters to isolate specific payments:​

• Total Amount: Enter a From Amount and To Amount to find payments within a specific value range (e.g., payments over $10,000 for high-value cash application review).

• Customer: Enter a customer name to pull the complete payment history for a specific account—ideal for resolving disputes or preparing customer statements.

• 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 Search button to preview results.​

7. Review & Download

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

• Verify Customer Names: Confirm payments are linked to the correct customer accounts.

• Check Applied Invoices: Payments without a linked invoice indicate unapplied cash that may be causing reporting issues.​

• Total Records: Check "Total records found" 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 cash flow snapshot or weekly AR update, 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 received payments with SaasAnt?

• Unapplied Payment Cleanup: Export all received payments and cross-reference them against open invoices to identify payments sitting in the "Unapplied Cash Payment Income" account—a common source of P&L inaccuracies, especially on cash basis reports.

• Bank Deposit Reconciliation: Match each payment in the export against your bank deposit records to ensure every customer payment has been correctly deposited and recorded.​

• Cash Flow Analysis: Download payments by date range to build a detailed cash inflow model by customer, payment method, or period—outside the limitations of QBO's standard cash flow report.​

FAQ

Why do I see "Unapplied Cash Payment Income" on my P& L?

This appears when a payment is recorded but not applied to a corresponding invoice, or when a payment is dated before the invoice it should cover. Export received payments and check for rows with no linked invoice in the export—these are your unapplied payments.

Can I filter received payments by payment method (e.g., check, credit card)?

There is no direct payment method filter on the export screen. Export all payments for the period, then filter the "Payment Method" column in Excel to separate by type.

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

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