QuickBooks & systemsUndeposited Funds in QuickBooks: Why Your Bank Balance and Your Books Disagree

Your P&L says you had a record year. Your bank account would like a word.

This mismatch has a few possible causes, but a frequent one lives in a single account with a sleepy name: Undeposited Funds. (Newer versions of QuickBooks Online call it Payments to deposit. Same account, new name tag.)

When it's used correctly, nobody thinks about it. When it isn't, it inflates revenue, confuses your CPA, and makes the balance sheet show cash that isn't in any bank. This guide explains what undeposited funds in QuickBooks are for, how they get stuck, and a careful way to clean them up.

What undeposited funds in QuickBooks is supposed to do

Think of Undeposited Funds as the envelope on your desk where checks sit before you walk them to the bank.

When a customer pays an invoice and you record it with Receive payment, QuickBooks closes the invoice and, by default, puts the money in Undeposited Funds. That's because you might deposit several payments together. Three checks of $1,200, $800 and $2,500 often show up on the bank statement as one $4,500 deposit.

The next step is Bank deposit (under the + New menu). You select those three payments, and QuickBooks moves them out of the envelope into your checking account as one $4,500 deposit. When the bank feed shows that $4,500, you match it to the deposit you created.

Envelope in, envelope out, balance back to zero. That's the whole design.

How payments to deposit in QuickBooks gets stuck

The trouble starts when the second half never happens.

Here's the usual pattern. Someone records customer payments with Receive payment, which sends them to Undeposited Funds. Later, someone else (or the same person on a busier day) sees the $4,500 deposit in the bank feed, doesn't notice the existing payments, and clicks Add with a category like Sales.

Now QuickBooks has:

• $4,500 of income from the original invoices, sitting in Undeposited Funds.
• Another $4,500 of income from the bank feed deposit, sitting in checking.

The bank account still reconciles, because checking only shows one $4,500 deposit. The duplicate hides in Undeposited Funds, which no bank statement ever checks. Repeat that for a year and you've got a large balance in an envelope that doesn't exist and income that never happened.

Other ways the account fills up:

• Payment processors (Stripe, Square, Shopify) pay out net of fees, so the deposit never matches the gross payments exactly.
• Customer payments are recorded twice, once manually and once by an app.
• Deposits were created but the wrong payments were selected.

A worked example: the $38,600 envelope

Here is a made-up case. You run a commercial cleaning company. Your balance sheet shows $38,600 in Undeposited Funds, and some of it dates back 14 months. Your P&L shows $1.21 million in revenue for last year.

A cleanup would look something like this:

1. Run the Undeposited Funds account register (or a Transaction Detail by Account report) and sort by date.
2. For each old payment, search the bank feed history around that date for a deposit of the same amount, or a deposit that includes it.
3. Where a matching deposit was added as income, the payment and the deposit are describing the same money. You fix it by editing that bank deposit to include the payment from Undeposited Funds and removing the duplicate income line, so the deposit total stays the same.
4. For processor payouts, record the fees as an expense line on the deposit so the total equals the actual payout.
5. Investigate anything that doesn't match. Some payments may have been entered by mistake and should be voided. Some may be real checks that were never deposited (check the desk drawer, seriously).

In this example, say $34,100 turns out to be duplicate income, $3,200 is processor fees that were never recorded, and $1,300 is a check that went missing and needs to be reissued by the customer. After cleanup, last year's revenue is about $34,100 lower than reported. That's a big deal if the tax return was already filed on the old number. Which brings us to the next point.

Fixing duplicate income in QuickBooks without breaking closed years

Duplicate income in QuickBooks that crosses into a year your CPA already filed shouldn't be changed casually. Editing old transactions changes prior-year reports, which then won't match the return.

Before touching anything in a closed year:

• Talk to your CPA. They decide how a prior-year correction should be handled for tax purposes.
• Check whether the books have a closing date set, and don't override it without agreement.
• Keep a written list of every change, with amounts and dates.

Often the cleanest approach is to fix the current year directly and handle prior-year differences through an adjusting entry your CPA agrees with. The accounting fix and the tax decision are two separate steps, and the second one belongs to the CPA.

How to keep Undeposited Funds near zero

1. Use Receive payment only for invoiced customers, then create a bank deposit when the money lands.
2. In the bank feed, always look for a match before clicking Add.
3. Record processor fees on the deposit so totals tie to the payout.
4. Review the Undeposited Funds balance as part of every month-end close. Anything older than a few days needs an explanation.
5. Reconcile every bank account monthly, using a steady bank reconciliation process.

If you sell online, payouts are where this gets tricky fastest. Our guide to Shopify payouts reconciliation walks through matching deposits to gross sales, refunds and fees. And if Undeposited Funds is only one of several surprises in the file, our list of common QuickBooks cleanup messes shows what usually travels with it.