How to Fix a Large Undeposited Funds Balance in QuickBooks

Undeposited Funds, also called Payments to Deposit, is a temporary account for customer payments that have been recorded but not yet grouped into a bank deposit in QuickBooks. A large old balance means you need to identify the payments behind it. The balance alone does not tell you which entry is wrong.

How the account should work

When you invoice a customer, QuickBooks records receivable and income. Receiving the payment moves the amount from Accounts Receivable to Undeposited Funds. Creating a bank deposit moves it from Undeposited Funds to the bank account. Intuit’s bank deposit guide explains this workflow. If you deposited a payment directly to the bank account when recording it, the Undeposited Funds step may not apply.

Example: A $1,000 invoice records $1,000 of income. Receiving payment moves $1,000 from receivables to Undeposited Funds without recording income again. The bank deposit moves $1,000 from Undeposited Funds to checking. If you then add the downloaded bank transaction as new sales income instead of matching the recorded deposit, you may record income a second time while leaving the payment in Undeposited Funds.

Five checks before changing anything

1. Save the starting reports. Export the Balance Sheet, Profit and Loss, bank reconciliation reports, and a detail report for Undeposited Funds as of the same date.
2. Review the open payments. Compare each old item with customer receipts, actual bank deposits, processor payouts, and refunds. Grouped deposits may combine several payments and deduct fees.
3. Find duplicate bank entries. Check whether a bank feed item was added as new income even though an invoice, payment, and deposit already exist.
4. Correct the underlying workflow. For genuine payments waiting to be deposited, create the appropriate bank deposit and match it to the downloaded bank line. For duplicates, determine which transaction can be removed or corrected without disturbing a filed return or a reconciled period.
5. Reconcile again. Confirm the bank statement, open customer balances, income, and remaining Undeposited Funds items. Each remaining item should have a documented reason.

Do not clear an unexplained balance with a single entry to equity or expense. That makes the account look clean while leaving the duplicate or missing transaction unresolved. A zero-dollar deposit is only appropriate when specific positive and negative items genuinely offset and the documentation supports that treatment.

When to get help

Stop before editing reconciled years, deposits tied to payment processors, or periods already used for tax returns. Our bookkeeping cleanup service traces the entries and documents the corrections. You can book a free consultation or request a $500 diagnostic to define the scope.

This article is general bookkeeping information. The correct entry depends on the original transactions and the reporting periods affected.