September 29, 2026

Undeposited Funds Cleanup Before You Migrate

The short answer

Before you migrate QuickBooks, get the Undeposited Funds account to zero, or to a short list of receipts that genuinely have not reached the bank. Whatever sits in it on the cutoff date is carried into the new system as an asset, and if that asset is not real cash, your opening balance sheet starts out wrong.

Why this account drifts

Undeposited Funds is a holding account. When you record a customer payment, QuickBooks can park it there until you group it into a bank deposit that matches the slip or the card processor payout. It should be a few days of activity, not a running total.

It drifts when the same money is recorded twice. A common pattern: the payment is received into Undeposited Funds, and then the bank feed or a manual entry books the same cash again as a direct deposit or as income. The bank account looks right, but Undeposited Funds keeps the first copy forever and accounts receivable or income is overstated by the same amount. The other pattern is old receipts that were banked long ago but never linked to a deposit.

Buyer math: what a stale balance costs

Take an illustrative file with 214 payments left in Undeposited Funds, totalling 48,300 in your currency. You check the last 30 days of bank statements and find only 3 receipts genuinely in transit, worth 2,150. The other 46,150 is old double-counted or unlinked cash. If you migrate as-is, the new file opens with a 48,300 asset that no bank statement supports, and your first reconciliation, your first VAT or GST report and your accountant's year-end review each have to explain it. Fixing it later, in a new system with a new audit trail, costs more than fixing it once in the file you already understand.

Five steps to clear it

1. Freeze a cutoff date and run the Undeposited Funds detail report as of that date, sorted by age. Export it to a spreadsheet.
2. Split the list into three piles: receipts genuinely in transit at the cutoff, receipts already banked but never linked to a deposit, and receipts that were entered twice.
3. For banked-but-unlinked receipts, create or edit the bank deposit so it includes them, dated to match the bank statement. The receipt then leaves the account without touching income or receivables.
4. For double entries, find the duplicate cash line, usually a direct deposit or a sales receipt, and correct it so income is counted once. Note each change in your working file.
5. Reconcile the bank account to the statement at the cutoff, then re-run the Undeposited Funds report. What remains should match your in-transit list line for line. If the reconciliation refuses to start cleanly, read our guide on a wrong reconciliation beginning balance first.

Tax and multi-currency traps

If you account for VAT, GST or sales tax on a cash basis, tax usually follows the date of payment, not the date of the bank deposit. Keep the original payment date on the receipt when you link it, and change only the deposit date. If your file uses several currencies or bank accounts, check each one separately: a deposit made in the wrong account leaves a balance behind in another. For the related clearing account that gets left behind in the same way, see Opening Balance Equity cleanup. If the file is multi-currency, also settle the open foreign balances first: see multi-currency cleanup before migration.

What we do on a conversion

We review Undeposited Funds, Opening Balance Equity and open receivables in the scoping step and send you a written list of items that need a decision. You approve the fixes, we make them in a copy of the file, and we reconcile the converted result to the cent against your bank statements. You can also ask for cleanup on its own, without a conversion.

FAQ

What should the Undeposited Funds balance be at cutoff?

Zero, or only the payments that really have not reached the bank yet, such as a card batch or cheque in transit. Every one of those should be listed with its date, customer and amount.

Can I just delete the old items?

No. Deleting or voiding a payment changes accounts receivable and income. Match it to the deposit that already banked it, or correct the double entry, and keep an audit trail of what you changed.

Does this apply to QuickBooks Online as well as Desktop?

Yes. Both versions park customer payments in an Undeposited Funds account until you group them into a bank deposit, so the same drift and the same cleanup apply. Menu names differ by version and region.

Will a converter fix it for me?

A converter copies what is in the file. A stale Undeposited Funds balance arrives as a stale asset, so it is far cheaper to clear it in the source file first.

How long does the cleanup take?

A small file with a few months of drift is often an afternoon. Years of unmatched receipts across several bank accounts can take a few days, which is why we scope it before quoting.

Related cleanup: payments recorded but never linked to an invoice leave paid invoices open — see unapplied payments and credits before you migrate.

Related service: QuickBooks support & file cleanup