At a Glance

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

• The Key Benefit: Native QBO transaction reports often hide customer names or line-item details on multi-check deposits. SaasAnt exports the line items of a deposit (showing exactly which payments made up that lump sum) into a flat database file, making bank reconciliation and "Undeposited Funds" audits much easier.

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

1. Navigate to Download (Export)

In Quick Access, click the Download (Export) button in the main menu.

2. Select Entity

In the Transaction/List dropdown, select Bank Deposits.

3. Select Date Strategy

Choose the date type that matches your goal:

• Search By Transaction Date: Exports based on the date the deposit was recorded at the bank. Use this for standard month-end bank reconciliation.

• Search By Created Date: Exports based on when the deposit was entered into QuickBooks. Use this to audit data entry timing and catch deposits that were recorded late.

• Search By Last Updated Date: Exports based on when the record was last modified. Use this to identify deposits that were altered after being reconciled, which can throw off your beginning balances.

4. Set Date Range & Format

• Range: Enter your start and end dates (usually matching your bank statement period).

• 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 bank deposits:

• 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 Line Items: Confirm that multiple rows appear for single deposits, showing the individual customer names and payment amounts that cleared "Undeposited Funds."

• Check Accounts: Ensure the deposit is mapped to the correct checking or savings account.

• 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 your cash receipts for fraud prevention or 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 bank deposits with SaasAnt?

• Undeposited Funds Reconciliation: Grouping multiple received payments into one bank deposit via "Undeposited Funds" is best practice in QBO, but native reports often obscure which specific payments are in that deposit. Exporting with SaasAnt solves this by showing the exact breakdown of every deposit in a flat file.

• Finding Discrepancies: When your QBO bank register doesn't match your physical bank statement, exporting deposits to Excel allows you to easily sort, sum, and identify the exact day a deposit was missed, duplicated, or entered for the wrong amount.

• Migration: Move your complete deposit history—including the line-item links to the original customer payments—to a new QuickBooks company file.

FAQ

How do I filter deposits for a specific bank account?

Export all deposits using SaasAnt, and then use Excel to filter the "Bank/CC/Cash Account" column to isolate the specific checking or savings account you are reconciling.

Can I use this file to migrate bank deposits to another QBO company?

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