Why payments show as received in QuickBooks but won't clear in your bank reconciliation

A home renovation contractor we work with had been doing his own QuickBooks for two years. Revenue was up. Every client payment was recorded. The Profit and Loss report (P&L) looked healthy.

Then he sat down to reconcile April and found a $12,300 difference between his QuickBooks balance and his bank statement. He had checked off every payment. Nothing was missing from the client side. The bank showed the deposits. QuickBooks showed the payments received.

The reconciliation would not close.

The problem was not a missing payment. It was a missing step.

What the Undeposited Funds account is

QuickBooks has a built-in holding account called Undeposited Funds. When you record a payment against an invoice, QuickBooks moves the money there by default before it reaches your bank account register.

The account exists because real banks and QuickBooks track money differently. You might collect three client checks in one day and deposit them together as a single bank transaction. The bank statement shows one $7,800 deposit. QuickBooks recorded three separate payments. Without a middle step, those two views of the same money cannot match.

That middle step is the Make Deposit entry. You create it in QuickBooks to group individual payments into a deposit total that matches what the bank actually received. When you do, the reconciliation closes cleanly.

If you skip that step, the payments sit in Undeposited Funds indefinitely. The account grows. The reconciliation difference grows with it.

Four reasons the balance builds up

Payments recorded, deposit step skipped. The most common pattern. An owner records a client payment, marks the invoice paid, and considers the work done. The Make Deposit step is a separate workflow in QuickBooks, and it gets overlooked. One month of skipped deposits is manageable. A year of them becomes a cleanup project.

Checks deposited in groups at the bank. You took three checks to the bank on a Thursday and deposited them as one transaction. The bank shows $5,200. QuickBooks shows three individual payments: $1,800, $2,100, and $1,300. Until you create a single deposit entry grouping those three payments, QuickBooks cannot match $5,200 to any of them.

Credit card batch deposits not matched. Payment processors batch card transactions and deposit a net amount after fees. That net deposit does not equal the individual card payments recorded in QuickBooks. Without a clearing account or a proper deposit entry, the difference accumulates in Undeposited Funds.

Old entries left from a prior workflow. Some owners discover the problem, fix the current month, and leave prior months alone. Old Undeposited Funds entries remain on the books and make every future reconciliation harder to interpret.

What April actually looked like

Here is how the contractor’s April payments appeared when we mapped them out.

The bank statement for April showed three deposits: $3,800 on April 8, $4,000 on April 9 (Clients B and C deposited together), and $4,500 on April 15. Total: $12,300. The money was all there. But no deposit entries existed in QuickBooks, so the reconciliation could not match any of it.

Why this matters beyond the reconciliation

The QuickBooks bank balance overstates what is available. Undeposited Funds appears under current assets. A growing balance there inflates the QuickBooks total relative to the actual bank account. An owner checking their QuickBooks balance to decide whether to cover a vendor bill is looking at a number that includes money sitting in a holding account, not confirmed cleared funds.

Month-end reports are harder to rely on. A P&L or balance sheet is difficult to interpret when Undeposited Funds holds entries from several months ago. When an outside bookkeeper or accountant reviews the file, a stale balance there is one of the first things flagged as a sign of an incomplete workflow.

The cleanup takes longer than prevention. Clearing a two-year-old Undeposited Funds balance requires tracing each old payment to its actual bank deposit, matching amounts that may have been combined or split, and correcting each entry. That work takes hours. Staying current each month takes minutes.

What the correct workflow looks like

For clients on QuickBooks, the payment process has two steps, not one.

First, record the payment against the invoice. This marks the invoice paid and moves the amount to Undeposited Funds. Second, navigate to Bank Deposit in QuickBooks, select the payments that were taken to the bank in a single trip, and post the deposit to the correct bank account. QuickBooks groups the selected payments into one deposit total and clears them from Undeposited Funds.

For card payments processed through Stripe, Square, or a similar service, a clearing account works more cleanly. Card transactions post to the clearing account. When the processor’s net deposit arrives, it also posts to the clearing account. The two sides offset and the account zeroes out for that batch.

For clients processing more than a few payments per week, the Make Deposit step takes about 10 minutes at the end of each week. It prevents every reconciliation problem described here.

Best practices for small business owners

Practices that keep Undeposited Funds from becoming a problem:

• Check the Undeposited Funds balance every week. It should hold only payments from the current week that have not yet been deposited at the bank. Anything older than seven days is worth investigating.
• Create the Make Deposit entry on the same day you physically take checks to the bank. The two actions are connected, and handling them together takes no additional time.
• If you accept card payments, confirm whether your processor deposits gross or net, and set up the matching clearing workflow before the first deposit posts to your bank feed.
• Do not post income directly to Undeposited Funds. Payments should come through invoices or sales receipts. Undeposited Funds should contain only items waiting for a deposit entry.
• At month-end, Undeposited Funds should show a near-zero balance or represent only the last few days of the month. Any entry older than that should be resolved before the period is closed.

Three questions worth asking

If your Undeposited Funds account has a balance today, three questions to understand what is there:

1. What is the current balance in Undeposited Funds, and how far back do the oldest entries go?
2. Is the Make Deposit step part of the current payment workflow, or are payments going straight to the bank account register?
3. Does the QuickBooks bank balance match the actual bank statement balance within a day or two of transactions?

If the answers point to a gap, the fix is a workflow correction. Setting up the deposit step for current payments takes about 15 minutes. Clearing the backlog takes longer depending on how far back it goes.

If you would like a second set of eyes on the Undeposited Funds balance in your QuickBooks file, share a screenshot of the account register. We will identify what is sitting there and explain the most direct path to clearing it.