Undeposited funds in QuickBooks: what it is and how to clear it
Undeposited Funds is one of the most misunderstood accounts in QuickBooks — and one of the most common places a file quietly goes wrong. Used correctly it’s genuinely useful; ignored, it becomes a ballooning balance that won’t reconcile and makes the balance sheet lie. Here’s what it’s actually for and how to clean it up.
What Undeposited Funds is for
When you receive several customer payments and then take them to the bank as one deposit, your bank statement shows a single lump sum, not the individual payments. Undeposited Funds bridges that gap: QuickBooks holds each received payment there temporarily, then lets you group them into a deposit that matches exactly what the bank recorded. Done right, your books mirror the bank precisely.
Why the balance grows and breaks things
The problem starts when payments go into Undeposited Funds but never get grouped into a deposit. Each recorded payment sits there, and the balance climbs with money that has, in reality, already reached the bank. Two things break:
- Reconciliation. The bank deposit exists but there’s no matching QuickBooks deposit — so the rec won’t balance.
- The balance sheet. Undeposited Funds shows cash that isn’t really uncollected, overstating assets.
How to clear it
- Open the list of payments sitting in Undeposited Funds.
- Use Make Deposits (or the deposit workflow) to group the payments exactly as they hit the bank — one QuickBooks deposit per real bank deposit.
- Match each grouped deposit to the corresponding line on the bank statement.
- Investigate anything left behind — a payment stuck for months usually means it was recorded twice, or the deposit was entered directly to the bank (double-counting).
The double-counting trap
A frequent cause of a stubborn Undeposited Funds balance is recording the customer payment and entering the bank deposit separately as its own income transaction. The income gets counted twice and the payment never clears the holding account. If you find this, the fix is to route deposits through Undeposited Funds consistently rather than entering them two different ways.
After a migration
Undeposited Funds is a classic conversion casualty — a carried-over balance that doesn’t correspond to any real uncollected payment. When you convert a file, the opening position should reflect only genuinely undeposited receipts; anything else is noise to resolve before go-live (see entering opening balances correctly).
Start from clean data
Data Prep maps, validates and reconciles your data before it’s written to QuickBooks — so balances like undeposited funds and control accounts land right the first time.
See Data Prep