At a Glance

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

• The Key Benefit: Get a flat database file showing the movement of funds between your bank, credit card, and liability accounts. This is essential for auditing inter-company transfers, reconciling clearing accounts, and ensuring every outbound transfer has a matching inbound receipt.

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

1. Navigate to Download (Export)

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

2. Select Entity

In the Transaction/List dropdown, select Transfers.​

3. Select Date Strategy

Choose the date type that matches your goal:​

• Search By Transaction Date: Exports based on the date the transfer was initiated or cleared by the bank. Use this for bank reconciliation and verifying inter-account movements during period-end close.​

• Search By Created Date: Exports based on when the transfer was entered into QuickBooks. Use this for audit testing to identify transfers recorded late or backdated to prior periods.

• Search By Last Updated Date: Exports based on when the record was last modified. Use this to identify transfers that were altered (e.g., changing the destination account) after being recorded.

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 transfers:​

• Reference No: Input a specific bank confirmation number or internal reference code 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 Accounts: Check the columns to ensure you see both the source account (Transfer From) and destination account (Transfer To) for each transaction.​

• Check Amounts: Scan the amounts to ensure they match your expected cash flow movements.

• 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 audit trail of internal cash movements, 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 transfers with SaasAnt?

• Inter-Account Reconciliation: When moving money between operating and payroll accounts, or paying down a credit card from checking, export transfers to ensure that every withdrawal from one account has a perfectly matched deposit in the other.​

• Clearing Account Audits: If you use a clearing or holding account for payment processors (like Stripe or PayPal), export transfers to verify that the balance zeros out correctly at period-end.

• Migration: Move your complete transfer history to a new QuickBooks company file. (Note: Native QBO-to-Desktop migrations sometimes incorrectly convert Transfers into Journal Entries. Exporting flat data via SaasAnt allows you to migrate them accurately.)​