Undeposited Funds piling up in QuickBooks

What Undeposited Funds is actually for

Undeposited Funds is a holding account, not a bank account. It exists because QuickBooks Online separates the moment a payment is received from the moment it is physically deposited. A restaurant depositing three days of cash receipts in one trip to the bank, or a business batching five customer checks into a single deposit slip, needs somewhere to hold those payments in between. Receive Payment and Sales Receipt both post to Undeposited Funds by default. The Bank Deposit screen is the second half of the transaction: it pulls one or more payments out of Undeposited Funds and groups them into the single line that actually shows up on the bank statement.

The account is supposed to be temporary. A payment should sit in it for days, not quarters. When it grows instead of clearing, the second half of the transaction, the Bank Deposit, either is not happening or is happening in a way that does not match what Undeposited Funds is holding.

The three ways this account stops clearing

The most common cause is a payment recorded correctly with Receive Payment, but the actual bank deposit was then entered as a fresh transaction in the bank feed, categorized straight to Sales or Income, instead of matched back to the waiting payment in Undeposited Funds. QuickBooks Online now has two records of the same money: one sitting untouched in Undeposited Funds, and one freshly categorized as income in the bank feed. Income is overstated by the exact amount of the stuck payment, and it stays stuck because nothing ever pulled it out.

The second cause is a Sales Receipt or invoice payment entered for a sale that never actually got deposited: a check that bounced, a cash sale voided in the point-of-sale system but not in QuickBooks, or a duplicate entry from a double-keyed invoice. These sit in Undeposited Funds because there is genuinely no deposit to match them to; they need to be identified and removed, not matched.

The third is simpler: nobody ran the Bank Deposit screen for the past several weeks. Payments accumulate correctly, matching deposits exist in the bank feed, and the fix is mechanical instead of diagnostic. Someone just has to sit down and group them.

Clearing it without duplicating income

Start with the Bank Deposit screen itself (+ New, then Bank Deposit). Every payment currently sitting in Undeposited Funds appears there as a selectable line. Cross-reference against the bank feed: for each real deposit on the bank statement, check the boxes for exactly the payments that summed to that deposit amount, and save. That single deposit transaction now clears every payment it includes out of Undeposited Funds at once.

For the bank feed side, search “For Review” and the register for any transaction categorized straight to an income account on a date that matches a deposit already handled through the Bank Deposit screen above. If one turns up, it is very likely the duplicate-income case described above. The categorization needs to change from an income account to “Undeposited Funds” or, better, get matched directly to the waiting payment using QuickBooks Online’s Match feature rather than Add.

For anything left in Undeposited Funds after that pass, meaning payments with no corresponding bank deposit anywhere close to their amount or date, the payment itself needs tracing back to whether the underlying sale was real. A voided point-of-sale sale or a bounced check needs the original Receive Payment or Sales Receipt corrected or deleted, not matched to a deposit that will never exist.

A quick way to tell how bad it is

Run the Balance Sheet report and look at the Undeposited Funds line as of today. Then run it again as of the end of last month, and the month before that. An account that grows every single month without ever dropping back down close to zero in between deposits means the sweep step is not happening at all, on any regular basis. That is the “nobody ran the Bank Deposit screen” case, and it is the easiest of the three to fix, because none of the underlying payments need investigating, only grouping. An account that spikes and drops back toward zero but never quite reaches it points instead to a handful of individual stuck payments, the duplicate-income or voided-sale case, which need finding and correcting one at a time instead of sweeping in bulk.

Undeposited Funds and sales tax

For businesses that collect sales tax, a stuck Undeposited Funds balance can also distort the sales tax liability report, because QuickBooks Online calculates tax owed from invoices and sales receipts as recorded, regardless of whether the corresponding deposit ever cleared. A voided sale that was never removed from Undeposited Funds can leave tax booked as collected on a sale that never happened, which shows up as a mismatch the next time a sales tax return is filed against what QuickBooks reports as owed.

Why this matters beyond the balance sheet

An Undeposited Funds account that never clears does more than look untidy. It inflates reported revenue for as long as it sits there, which is the number a lender, a landlord requiring financials, or a buyer’s due-diligence review will pull first. It also means Accounts Receivable aging reports can show invoices as paid while the deposit trail that should back that up does not exist, which is exactly the kind of inconsistency a CPA flags at year end and sends back with questions.

What this costs to fix

An Undeposited Funds account that has been accumulating for several months is a cleanup job. Every stuck payment has to be traced individually against the bank feed for the period it covers, which is priced by the month of backlog involved.

$199 per month of backlog

If the account has been growing since the books were last properly closed, meaning not just messy but months behind, that is catch-up territory instead. Both offers, and everything else, are on the pricing page.