Undeposited funds won’t clear — and the obvious fix doubles your income

Undeposited Funds has a real job. It is a holding account: you record a customer payment into it, then group several payments into one bank deposit so QuickBooks shows the same single lump sum your bank does. That is what lets a $4,000 deposit made up of eight cheques reconcile cleanly instead of as eight lines that don't exist on the statement.

It goes wrong when payments go in and never come out. And the fix people reach for first — create a deposit, clear the balance, done — is the one that quietly doubles your revenue.

Why the balance is stuck

There is essentially one cause with two faces, and both come from the bank feed.

The money arrived by a different route. A customer payment was recorded properly, landing in Undeposited Funds. Then the bank feed downloaded the actual deposit, and somebody added it as income rather than matching it to the deposit built from those payments.

The result:

• The bank balance is correct — the deposit is there once.
• Income is recorded twice — once from the customer payment, once from the added bank line.
• The original payments are stranded in Undeposited Funds with nothing to clear them.

The second face is the same mistake in a different order: the bank-feed deposit was matched before the actual deposit was created in QuickBooks. The money shows as banked and the payments never left the holding account.

Either way the account fills up, and none of it is a problem with the account.

Why creating a deposit to clear it is the wrong move

Because the money is already in the bank in QuickBooks, via the entry someone added.

Create another deposit to clear the balance and you have recorded the same income a third time and put your bank balance out by the amount of the deposit. You have converted a reporting problem into a reconciliation problem, and now both need fixing.

This is worth stating plainly because it is exactly what the balance seems to be asking you to do.

Diagnose it in three steps

1. See what is actually sitting there. Open the Undeposited Funds account and run a report of its transactions, filtered to items that have not cleared. You want dates and amounts — particularly how old the oldest items are.

2. For a sample of the stranded payments, ask: did this money reach the bank? Take an amount and a date, and look for it in the bank register. Nearly always, you will find it — recorded as a deposit that was added rather than matched.

3. Establish which case you have.

• Money in the bank via an added deposit → the added entry is the duplicate. This is the common case.
• Money genuinely not in the bank → the payment was recorded but never banked, or was banked into a different account. Rarer, and a different fix.

That third step is the one that decides everything, and it takes a minute.

Fixing it correctly

For a deposit that was matched or added incorrectly: go to the bank transactions, open the Categorized or Reviewed tab, find the deposit, and select Undo. It returns to for-review. Now create the deposit properly from the payments in Undeposited Funds, and match the bank-feed line to that deposit.

Undo first, then rebuild. Doing it the other way round leaves two deposits in the register for a moment and it is easy to lose track of which is which.

For payments genuinely never banked: those are not a data problem. Find out what happened to the money before adjusting anything.

For very old items with no corresponding bank activity at all — payments recorded years ago against customers who may or may not have paid — do not simply delete them. Each one is a customer invoice marked paid. Deleting the payment re-opens the invoice. That is a decision about your receivables, not a tidy-up.

What a stuck balance does to your numbers

Both errors run the same direction, which is why this matters more than it looks:

• Revenue is overstated by the duplicated income. That flows into the profit your CPA files on.
• Assets are overstated — Undeposited Funds is an asset, and the balance represents money that is either already banked or never existed.
• Reconciliations get harder every month, because the register carries deposits that don't correspond to how the payments were recorded.

If the pattern has been running for a year, the duplicated income is not a rounding issue.

When this stops being a DIY job

Do it yourself when there are a handful of items, they are recent, and you can trace each to an added bank deposit and undo it.

Get help when:

• The balance goes back more than a few months — every duplicate is an overstatement of income in a period that may already be filed.
• There are dozens of stranded items, which means the add-don't-match habit is systemic rather than occasional.
• Some payments cannot be traced to the bank at all, so it is no longer only a bookkeeping question.
• Correcting it would change a filed year — raise that with your CPA before touching it.
• Reconciliations have been forced to close around the mess, in which case the register no longer reflects reality either.

That is QuickBooks cleanup work: identifying the duplicated income, correcting it without breaking reconciliations that were done correctly, and re-establishing the match-don't-add habit so the balance stops rebuilding. It is a one-time fixed fee, quoted in writing after a free file review.

If your ongoing bookkeeping is where this originated — payments recorded but deposits never grouped — that is what a monthly bookkeeping engagement is for: the account gets cleared every month, so it never becomes a year's worth of untangling.