QuickBooks Online Undeposited Funds Cleanup Checklist
Published September 27, 2026 · LedgerMedic
If the Undeposited Funds account on your QuickBooks Online balance sheet has grown into a number that makes you wince, the good news is that clearing it is a mechanical process, not a mystery. The bad news is that a mechanical process across dozens or hundreds of old entries takes real time by hand. This is the checklist we use to work through it in order, oldest and highest-risk first.
Step 1: Pull the account and sort by age
Open the Undeposited Funds account from the Chart of Accounts and run its Quick Report (or Account QuickReport), sorted oldest to newest. Age matters more than amount here: a payment sitting for two years is far more likely to be an orphaned or duplicated entry than one from last week that simply hasn't been swept into a deposit yet.
Step 2: Separate "waiting to be deposited" from "actually stuck"
Not every entry is a problem. A payment received in the last few days that just hasn't been physically deposited at the bank yet is working exactly as designed. The ones worth investigating are entries older than your normal deposit cycle, typically anything past 5–7 business days for most businesses.
Step 3: For each stuck entry, check three things
- Does a matching bank deposit exist? Search the bank register for the amount and date range. If a deposit exists but was recorded separately (not built from this Undeposited Funds entry), you likely have a duplicate, see fixing a duplicate deposit.
- Was the deposit made at the bank but never recorded in QuickBooks? If money genuinely never arrived, don't just delete the entry, that's covered separately in why QuickBooks won't let you delete a deposit and usually needs a void, not a delete.
- Is it tied to a bank feed match that went to the wrong place? See bank feed matches that create unapplied payments for the specific fix.
Step 4: Work oldest-first, not largest-first
It's tempting to chase the biggest dollar amount first. Don't. The oldest entries are the ones most likely to have a bank statement that's aged out of easy access, and the ones most likely to be genuinely wrong rather than just unswept. Clear those while the trail is still followable.
Step 5: Check whether the same clients or payment sources keep reappearing
If the same customer, payment processor, or bank feed rule keeps generating new stuck entries every month, the cleanup will never finish, because you're refilling the bucket as fast as you empty it. That's a process fix (a bank rule, a payment processor sync setting, or how a specific client pays), not another round of manual cleanup.
A gut check on scale
A handful of stuck entries is a 15-minute job. A backlog that's been building for a year, across dozens of entries with no clear pattern by eye, is a multi-hour project done manually, and it's easy to miss an entry that quietly moves from Undeposited Funds into Unapplied Cash Payment Income instead, which distorts your P&L rather than your balance sheet.
LedgerMedic's free scan runs this exact checklist against a connected QuickBooks Online company automatically, sorting every stuck Undeposited Funds entry by age and flagging which ones look like duplicates, unrecorded deposits, or bank feed mismatches, so you start step 3 already knowing where to look instead of scrolling a Quick Report by hand. It connects read-only, takes about two minutes, and the free tier covers your first 6 fixes at no cost.