How to clear Undeposited Funds 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.

Why do I have a balance in Undeposited Funds?

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.

Cause	What the balance does	How it clears
Deposit categorized straight to income	Stuck payment, income overstated by the same amount	Match the deposit to the waiting payment
A sale that was never deposited	Payment with no deposit anywhere near its amount or date	Correct or delete the original payment or receipt
Bank Deposit screen not run	Grows every month, never near zero	Group payments into the deposits on the statement

How to clear Undeposited Funds without duplicating income

This is how you get money out of Undeposited Funds and into the bank account it actually reached. Do the bank feed check first. Grouping payments into a deposit when the same money was already added to income through the feed creates a second copy of the sale.

1. Look for deposits added straight to income. In Transactions > Bank transactions, open the Categorized tab (Posted in some layouts) and look for deposits categorized to Sales or another income account on dates near payments still waiting in Undeposited Funds. Each one is the duplicate-income case above. Select Undo on it so it returns to For review. The full pattern is on sales counted twice from one deposit.
2. Match feed deposits to the waiting payments. For each deposit in For review, use Find match and tick the payments that made it up. The total has to equal the bank line. QuickBooks records the deposit for you and clears those payments out of Undeposited Funds.
3. Group anything the feed does not cover on the Bank deposit screen. Select + Create (+ New in older layouts), then Bank deposit. Choose the bank account and the date on the statement, tick exactly the payments that made up that deposit, check that the total matches the statement, and select Save and close. Then match the feed line to that deposit, never Add it.
4. Trace what is left. Payments with no deposit anywhere near their amount or date need tracing back to whether the 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.

Before deleting or undoing anything in step 1 or 4, check the register for an R: a reconciled deposit changes the next reconciliation’s beginning balance if you touch it.

Should Undeposited Funds be zero?

At each month end, it should be at or close to zero. The only balance that belongs there is money received in the last day or two of the month that genuinely had not reached the bank yet, and that should be gone within the first days of the next month. A balance carried from one quarter to the next is not money waiting to be deposited. If the balance is below zero rather than above it, the causes are different: see negative Undeposited Funds.

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, one of the items every cleanup covers. 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.

$99per month of backlog20% off 6+ months

If the balance has not been near zero for more than a quarter, send the file for a free review before grouping anything.

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.