QuickBooks Accounting Bookkeeping Cleanup Guide

QuickBooks Undeposited Funds: Why It Keeps Growing & How to Fix It

A practical guide for small businesses that see old customer payments sitting in Undeposited Funds, duplicate deposits, or a balance that no longer matches the bank.

High-intent QuickBooks issue Cleanup + prevention
1

The simple answer

Undeposited Funds is a holding area—not a second bank account.

When customer payments are recorded before they are grouped into a real bank deposit, QuickBooks can hold them in Undeposited Funds. The account should generally clear as those payments are included in the deposits that appear in your bank account.

When the balance keeps growing, the problem is usually in the payment → deposit → reconciliation workflow, not in the account itself.

Where the problem starts

7 reasons your Undeposited Funds balance may be wrong

01

Payments never added to a deposit

The payment exists, but nobody created the matching bank deposit transaction.

02

Bank deposit was entered separately

A deposit may have been recorded directly to income or another account instead of using the customer payments.

03

Duplicate payment or deposit

The same cash movement can be recorded more than once, leaving confusing balances and reconciliation differences.

04

Partial or grouped deposits

Several customer payments may hit one bank deposit, so the grouping has to match the actual deposit composition.

05

Old unreconciled transactions

Historical items can remain in the account for months or years when the original workflow was never completed.

06

Incorrect historical cleanup

Prior adjustments can make the account appear cleared while shifting the underlying accounting to another account.

07

The bank feed is masking the workflow problem

Matching and categorizing bank transactions can make the ledger look active while old customer-payment deposits remain unresolved.

Clean it safely

A practical cleanup workflow

Do not simply journal the Undeposited Funds balance to zero. Trace the underlying transactions first so the bank, customer balances, and financial statements stay connected.

Golden rule

Every material cleanup entry should have a clear explanation tied to an actual customer payment, bank deposit, refund, correction, or documented historical issue.

01

Run the Undeposited Funds detail

Sort by date and identify the oldest outstanding payments. Start with the items creating the largest balances.

02

Compare each item to the bank

Look for the real deposit date, amount, and grouping. A single bank deposit may contain several customer payments.

03

Fix the original transaction path

Where possible, correct the payment or deposit workflow instead of creating an unrelated plug entry.

04

Reconcile the bank again

Confirm that the deposit now matches the bank activity and that the reconciliation difference has not moved elsewhere.

05

Document unresolved history

For old transactions that cannot be traced, document the issue and use a controlled cleanup approach approved by the person responsible for the books.

Fast diagnosis

What the balance may be telling you

What you see Likely area to inspect First action
Large old balanceHistorical deposits or missing groupingTrace the oldest items to bank statements
Balance changes after bank-feed workMatching/categorization workflowReview related deposits and duplicate entries
Bank reconciles but UDF stays highBooks may contain offsetting or duplicate transactionsReview the full transaction path, not just the reconciliation
Negative or unusual balanceIncorrect edits, refunds, or historical adjustmentsInspect transaction history before correcting

Prevention system

Keep Undeposited Funds from becoming a monthly cleanup project

The strongest bookkeeping process treats deposit matching as part of the normal workflow—not as a year-end cleanup task.

Daily / frequent

Record customer payments consistently and match grouped deposits to actual bank activity.

Weekly

Review unusual or aged Undeposited Funds items before they become historical clutter.

Monthly

Confirm the ending balance is explainable and investigate stale items before month-end close.

During handoffs

Document how your business records payments, deposits, refunds, and merchant settlements.

Quick checklist

Before you clear Undeposited Funds

FAQ

QuickBooks Undeposited Funds questions

Should Undeposited Funds have a balance?

It can have a balance temporarily when customer payments have been recorded but not yet included in the corresponding bank deposit. A persistent or unexplained balance deserves investigation.

Why does my QuickBooks Undeposited Funds balance not match my bank?

The two balances measure different things. Undeposited Funds is based on how customer payments are recorded in the books, while the bank reflects actual deposits. The key is to trace the payments into the matching deposits.

Can I make a journal entry to clear Undeposited Funds?

A journal entry may be appropriate in specific historical cleanup situations, but it should not be the default shortcut. First determine why the balance exists and whether the original payment or deposit transaction can be corrected.

What if the balance is very old?

Treat old items as a bookkeeping investigation. Review bank statements, customer records, prior reconciliations, and transaction history before making adjustments.

Need help cleaning up your books?

Get your QuickBooks records back to a clean, explainable workflow.

Accountrise provides remote bookkeeping and accounting support for US businesses, including QuickBooks cleanup, reconciliations, month-end close, and ongoing bookkeeping.

Bookkeeping support starts at $10/hour. Final pricing depends on scope, transaction volume, complexity, and engagement requirements.