Why Your Undeposited Funds Account Keeps Growing (and How to Actually Clear It)

When I open a client's file and find a few thousand dollars sitting in Undeposited Funds, it is never a mystery. Somewhere along the way, a payment got recorded and the deposit that was supposed to sweep it into the bank never got made. Undeposited Funds is meant to hold a payment for a day or two, until you group it with others into one bank deposit. A balance that keeps climbing for months means a step in that process is getting skipped, not that QuickBooks is broken.

Why it happens

Every payment adds to the balance before anything clears it back out. Record a check or cash payment through Receive Payment or a Sales Receipt and choose Undeposited Funds as where it's going, and that amount lands in the account right away. The only thing that clears it is a Bank Deposit: you group those waiting payments together, save the deposit, and match it to the real deposit that shows up in your bank feed. Do that every time and the balance runs up and back down to zero in a day or two. A few things break that cycle, and they tend to stack on top of each other over time.

• The deposit step never got done. You collect a few payments during the week, each one sending money to Undeposited Funds, and plan to combine them into one deposit on your next trip to the bank. If that deposit screen never gets opened, every one of those payments just sits there, waiting on a deposit that never gets built.
• A bank feed transaction got added instead of matched. This doesn't put anything new into Undeposited Funds. It's about what happens to the balance that's already there. When the real deposit shows up in your bank feed, the right move is to match it against the Bank Deposit you built from Undeposited Funds. Add the feed line straight to an income account instead, and two things go wrong: the original payment in Undeposited Funds never clears, because the deposit that was supposed to absorb it never existed, and the sale gets counted twice, once when the invoice or sales receipt was created and again from the feed.
• A payment got recorded with nothing to apply it to. A Receive Payment entered without an invoice behind it has nothing pulling it toward a deposit, so it stays in Undeposited Funds indefinitely.
• QuickBooks Payments deposits got entered twice. Money processed through QuickBooks Payments deposits itself automatically, so you don't need to route it through Undeposited Funds. A matching payment entered by hand on top of that duplicates the same funds.

See what is stuck in there

Before fixing anything, find out what is sitting in the account and how old it is. Open Chart of Accounts, find Undeposited Funds, and choose Run report from the dropdown in the Action column. The report defaults to the last 90 days, so change the report period to cover the full time you've used QuickBooks if the balance has been building for longer than that. Each line carries a date, so you can see roughly when the gap started.

Clear it without doubling your income

For each item on that list, check whether the same money already shows up as its own deposit in your bank feed's Categorized tab. If it does, that's the duplicate. The payment was added on its own instead of matched to Undeposited Funds.

1. Find the duplicate deposit in the Categorized tab and click Undo. This sends it back to For Review without deleting it.
2. Build the deposit that should have been made. Go to + New, choose Bank deposit, and check the Undeposited Funds payments that match that day's actual bank total. Save it.
3. Return to For Review. The bank feed line should now offer Find match instead of Add. Match it to the deposit you just built.
4. For anything with no matching bank activity at all, a payment entered by mistake, a test entry, or a sale later voided outside QuickBooks, delete it directly from Undeposited Funds instead of forcing it into a deposit that never happened.

It's tempting to make one journal entry moving the whole balance to Retained Earnings and call it done. That clears the number on the balance sheet, but it doesn't tell you which of those old payments were duplicated into income and which were never deposited at all. Work through the report first. A journal entry might still be the right closing move for a few stale cents left over, but not for the whole balance.

So if a $450 customer payment has been sitting in Undeposited Funds since March, and your bank feed already shows a separate $450 deposit from March 12 categorized to Sales, that $450 got counted twice: once when the invoice was created, and again when the feed line was added instead of matched. Undo the March 12 entry, build a $450 deposit from the Undeposited Funds payment, and match the feed to it. Income drops back down by $450, and the balance in Undeposited Funds clears.

Keeping it from recurring

Build the bank deposit before you look at the bank feed. When the feed offers a choice between Add and Find match, check for a match first if you know a payment already went in somewhere else. Run the Undeposited Funds report once a month, the same way you'd check a reconciliation. Anything sitting there for more than a few days is worth a look before it turns into a bigger cleanup.