Undeposited Funds Not Matching Your Bank Deposit in QuickBooks Online? Here's the Fix

Published September 16, 2026 · LedgerMedic

If you've ever tried to reconcile a bank deposit in QuickBooks Online and found that the amount sitting in Undeposited Funds doesn't line up with what actually landed in the bank, you're looking at one of the most common, and most avoidable, data problems in QBO. It's rarely a QuickBooks bug. It's almost always a sequence of transactions that didn't happen in the order the software expects.

Why the numbers don't match

Undeposited Funds is a holding account. A customer payment sits there the moment it's recorded, and it's supposed to leave the moment you group it into a deposit that mirrors what the bank actually received. The mismatch shows up when that grouping goes wrong in one of a few specific ways:

• A deposit was created directly from the Banking feed ("Add" instead of "Match"), which records a brand-new deposit instead of pulling the existing payment out of Undeposited Funds, so now both exist.
• Two payments were combined into one bank deposit, but only one was selected when the deposit was recorded in QuickBooks, leaving the other stranded.
• The deposit amount was edited after the fact (a partial refund, a bank fee netted out) without updating which payments it draws from.
• A payment was entered against the wrong customer or the wrong amount, so it never matched the real deposit it was meant to represent.

How to fix it

1. Open the bank register for the account in question and find the deposit that doesn't reconcile.
2. Compare it against your actual bank statement for that date. Confirm the real amount and which payments the bank grouped together (most processors show this in their own settlement report).
3. In QuickBooks, delete the incorrect deposit only if it was created directly from the bank feed rather than pulled from Undeposited Funds. Deleting a deposit that already includes real Undeposited Funds payments will just re-orphan them, not fix anything.
4. Go to + New → Bank Deposit, select the correct payment(s) from the Undeposited Funds list, and confirm the total matches the real bank deposit exactly.
5. If a payment amount itself is wrong (not just the deposit), correct the payment first, then rebuild the deposit.
6. Re-run your bank reconciliation for the period. It should now tie out to the cent.

Why this is worth doing carefully, not quickly

A journal entry can make the numbers on the balance sheet look reconciled without actually reconnecting the payment to the deposit that happened at the bank. That's a real risk: the next person to touch the file (an auditor, a new bookkeeper, the client's CPA) inherits a set of books that don't reflect what actually occurred, and untangling a journal-entry fix months later takes far longer than doing it right the first time.

If this is a one-time cleanup on a single file, the steps above are usually a 15–30 minute job. If it's a recurring pattern (new mismatches every month, or the same issue across several client files), it's worth checking whether it traces back to a duplicate deposit being created from the bank feed, which is the single most common root cause.