On this page Jump to section
BLUF: A persistent Undeposited Funds balance means the payment records and the bank deposits disagree. The fix is to match them, not to post a journal entry that clears the account.
The account exists so that individual customer payments can be grouped into one bank deposit. It should return to zero when every payment has been included in a deposit that actually cleared.
Read the account before changing it
Open the register for Undeposited Funds and sort by date. For each payment, note the customer, the amount, the payment method, and whether it has been deposited.
Then open the bank register and list deposits of the same amounts, dates, and references. Work from both lists at once.
Do not start with the balance. A balance of $4,312.19 could be one payment, twelve payments, or a payment plus an unrelated refund. The number alone tells you nothing.
Classify the balance
Most balances fall into a few cases:
- Payments received but never deposited in QuickBooks
- Deposits recorded directly to the bank account, bypassing Undeposited Funds
- A deposit recorded twice
- A payment applied to the wrong customer
- A refund or chargeback that never cleared the clearing account
Record the case for each open item. Guessing at a single cause produces a journal entry that makes the balance zero and the records wrong.
Match payments to the bank statement
Start with the bank statement. For each deposit, find the payments that make up the total. Use the date, amount, and customer references.
When the total matches, record the deposit in QuickBooks from the payments. When it does not, look for a missing payment, a fee, or a payment recorded to a different account.
For card deposits, the bank amount is often net of fees. Match the gross payments and record the fee, rather than forcing the net amount to match.
Handle the direct-to-bank entries
A payment recorded straight to the bank account instead of Undeposited Funds leaves the clearing account untouched and looks fine in the bank register. Reconcile that separately: the payment exists twice or the deposit is missing from the clearing side.
Correct by receiving the payment through Undeposited Funds and making the deposit, then removing the duplicate entry with owner approval. Document the original entries so the change is reviewable.
Avoid the quiet journal entry
A journal entry between Undeposited Funds and the bank account will zero the balance and tell you nothing about which payment was lost. It also breaks the audit trail between the customer payment and the bank deposit.
Use a journal entry only when the underlying records cannot be reconstructed, and attach the owner's written approval plus the supporting statement.
Set a weekly routine
Review the account weekly, not at month end. The older the items, the harder the matching.
Keep a small log: date reviewed, open items, value, matched this week, and unresolved items with owners. A balance that trends down is healthy; a balance that resets to the same number every month is a process defect.
Prevent the next balance
Agree on one intake path for payments. If some arrive through an invoicing app, some through a payment processor, and some by check, write down how each one enters QuickBooks and who deposits it.
Check the deposit workflow after any change to the payment processor, because the mapping is where most new imbalances start.
QuickBooks VA workflow table
| Workflow area | What the VA prepares |
|---|---|
| Daily queue | Invoices, receipts, bank feeds, and open QuickBooks questions |
| Weekly review | Owner approvals, exception list, and unresolved transaction notes |
| Monthly packet | Reports, missing documents, and accountant-ready source material |
Related resources
Compare the service fit on the QuickBooks VA services page, then use the free consultation form to map the first handoff. For platform context, review QuickBooks Online.
