How to Clear Old Undeposited Funds in QuickBooks Online
Published September 16, 2026 · LedgerMedic
A handful of stuck payments in Undeposited Funds is a quick fix. A balance that's been quietly growing for a year or more is a different problem. By the time someone notices, the account can hold dozens or hundreds of entries, many tied to closed books or customers who've since been merged or made inactive. Clearing it takes a more careful process than clearing a fresh mismatch, because the goal is to fix it without disturbing financials that have already been reported to a lender, a tax preparer, or an owner.
Why the backlog builds
Old Undeposited Funds balances almost always come from the same root cause repeated many times: payments recorded but never grouped into a matching deposit. What makes an old backlog different is usually one of these compounding factors:
- Nobody has reconciled the account itself (as opposed to the bank account) in a long time, QuickBooks doesn't force you to, so it goes unnoticed.
- A bookkeeper transition happened, and incoming and outgoing staff each handled deposits differently for a stretch.
- The file was migrated from another platform and some payments came over without their matching deposits.
A safe process for working through it
- Set a cutoff. Decide how far back you're willing to correct without reopening a closed period (talk to whoever prepared prior tax filings first if the backlog crosses a filed year).
- Export the full Undeposited Funds register to a spreadsheet (date, customer, amount) so you have a working list outside of QuickBooks.
- Sort by age, oldest first, and work forward. Older entries are more likely to represent genuine errors (payments that were never really received, or duplicated) rather than simple grouping mistakes.
- For each entry, determine one of three outcomes: it matches a real deposit that was never recorded (create the deposit correctly, matching the bank), it was already captured in a deposit under a different combination (safe to move once identified, since the money already cleared), or it was never actually received (void it).
- Batch the deposits you can verify against bank statements rather than doing it item by item against memory. Pull the actual monthly statements for the period you're correcting.
- Leave a note in each corrected transaction (QuickBooks allows a memo) explaining what was done and why, so the next person who opens the file understands the history instead of re-investigating it.
- Once cleared, put a monthly reconciliation of the Undeposited Funds account itself on the checklist (not just the bank account) so a backlog this size doesn't rebuild silently.
What not to do
Don't zero out the balance with a single journal entry against retained earnings or a suspense account. It's fast, but it permanently severs the connection between the payments and whatever actually happened at the bank, and if the file is ever audited or reviewed, there's no way to reconstruct what the entry was covering for.
If the backlog is large enough that working through it by hand across a full year feels daunting, it's worth first confirming how big the actual problem is rather than guessing. LedgerMedic's free scan reads a connected QuickBooks Online company and lists every stuck Undeposited Funds entry with its age and amount in about two minutes, turning "there's a backlog somewhere" into an exact, sortable list you can work from, whether you fix it by hand or use the guided one-click fix. If you manage this same situation across several client files, the same scan runs on every connected company under one login, which is usually where an old backlog like this actually lives, quietly, in more than one place at once.
For a related and often co-occurring issue, see how a duplicate deposit gets created in the first place, it's one of the most common sources of exactly this kind of long-running backlog.