Home / Resources / Technical
Technical

Undeposited funds in QuickBooks: what it is and how to clear it

8 min read · Keepsync Systems

Undeposited Funds is one of the most misunderstood accounts in QuickBooks — and one of the most common places a file quietly goes wrong. Used correctly it’s genuinely useful; ignored, it becomes a ballooning balance that won’t reconcile and makes the balance sheet lie. Here’s what it’s actually for and how to clean it up.

What Undeposited Funds is for

When you receive several customer payments and then take them to the bank as one deposit, your bank statement shows a single lump sum, not the individual payments. Undeposited Funds bridges that gap: QuickBooks holds each received payment there temporarily, then lets you group them into a deposit that matches exactly what the bank recorded. Done right, your books mirror the bank precisely.

Why the balance grows and breaks things

The problem starts when payments go into Undeposited Funds but never get grouped into a deposit. Each recorded payment sits there, and the balance climbs with money that has, in reality, already reached the bank. Two things break:

  • Reconciliation. The bank deposit exists but there’s no matching QuickBooks deposit — so the rec won’t balance.
  • The balance sheet. Undeposited Funds shows cash that isn’t really uncollected, overstating assets.

How to clear it

  1. Open the list of payments sitting in Undeposited Funds.
  2. Use Make Deposits (or the deposit workflow) to group the payments exactly as they hit the bank — one QuickBooks deposit per real bank deposit.
  3. Match each grouped deposit to the corresponding line on the bank statement.
  4. Investigate anything left behind — a payment stuck for months usually means it was recorded twice, or the deposit was entered directly to the bank (double-counting).

The double-counting trap

A frequent cause of a stubborn Undeposited Funds balance is recording the customer payment and entering the bank deposit separately as its own income transaction. The income gets counted twice and the payment never clears the holding account. If you find this, the fix is to route deposits through Undeposited Funds consistently rather than entering them two different ways.

After a migration

Undeposited Funds is a classic conversion casualty — a carried-over balance that doesn’t correspond to any real uncollected payment. When you convert a file, the opening position should reflect only genuinely undeposited receipts; anything else is noise to resolve before go-live (see entering opening balances correctly).

The habit that keeps it clean: route every customer payment through Undeposited Funds, then group deposits to match the bank exactly — and never enter a deposit twice. Do that and the account does its job silently; ignore it and it’s the first thing that breaks your reconciliation.
Keepsync Data Prep

Start from clean data

Data Prep maps, validates and reconciles your data before it’s written to QuickBooks — so balances like undeposited funds and control accounts land right the first time.

See Data Prep