Bookkeeping · Cleanups & Fixes · Brief · Intro level
The Undeposited Funds pileup: payments recorded but never deposited
Why the Undeposited Funds account balloons — payments received in the software but never grouped into deposits — and how to match the pile out against real bank deposits.
Symptom
The balance sheet shows an asset called Undeposited Funds (or "Payments to deposit") at 23,700, growing every month. The bank account is fine; customers show paid. Nobody remembers deciding to have this account at all.
Why it happens
Undeposited Funds is the software's answer to a real-world workflow: you receive three checks, then take them to the bank as one deposit of 1,850. Recording each payment to Undeposited Funds first, then grouping them into one deposit, lets the books show a single 1,850 line that matches the statement. The pileup happens when only half the workflow runs — payments get recorded (customers show paid, income is recognized) but the grouping-into-deposits step never does. The money reached the bank; the ledger left it in a drawer that never empties.
The compounding version: someone sees bank deposits in the feed with nothing to match, and records them directly as income. Now revenue is counted twice — once via the invoice, once via the deposit — while Undeposited Funds still bulges.
The fix
- Print the open items. Run the Undeposited Funds account register or the open payments list, oldest first, with dates, customers, and amounts.
- Pull bank statements for the same span. You are going to match piles of payments to real deposit lines.
- Build the deposits. In the software's deposit screen, group payments so each deposit equals a statement line — three payments of 500, 850, 500 into the 1,850 deposit of March 4. Date the deposit as the bank shows it.
- Hunt the double-counted deposits. For any bank deposit that was also entered directly to income, delete the direct entry and use the grouped payments instead. Check the income account for the symmetric drop — this is where the fix changes the P&L. (If the direct entries sit in prior filed years, stop and involve the preparer before deleting; the pattern is the same closed-period problem as /bookkeeping/cleanups-fixes/retained-earnings-changed.)
- Deal with the orphans. Items with no matching bank deposit ever are usually duplicate payment records or payments that bounced. Reverse duplicates; re-invoice bounced payments.
- Reconcile. The affected months should now reconcile cleanly, and Undeposited Funds should hold only the last day or two of genuinely in-transit payments.
If the account contains an old stub that maps to no real event, clear it deliberately rather than leaving it to age:
| Account | Debit | Credit |
|---|---|---|
| Accounts receivable — Customer | 500 | |
| Undeposited Funds | 500 |
Only after confirming the payment was recorded twice; this restores the customer balance so the extra payment record can be applied or removed properly. Random write-offs to income hide the real error.
How to prevent it
- Finish the workflow. Whoever records payments also records the deposit, same day. A payment left in Undeposited Funds overnight is in transit; one left a month is a defect.
- Match feed deposits, never add them. When a deposit appears in the bank feed, match it to the grouped payments; adding it as new income creates the double-count.
- Review the account at every close. A healthy Undeposited Funds balance equals the payments physically in transit and nothing else — it belongs on the monthly checklist next to the reconciliation itself (/bookkeeping/cleanups-fixes/uncleared-transactions-cleanup covers its sibling problem on the outflow side).
- Consider bypassing the account if you never batch deposits — some platforms let payments post straight to the bank account, which removes the drawer entirely.
Frequently asked questions
- What is the Undeposited Funds account and why does it have a huge balance?
- Undeposited Funds is a clearing account: when you record a customer payment, most small-business ledgers park it there until you group payments into a deposit that matches the bank. The balance balloons when payments are recorded but the deposit step never happens — the money reached the bank, but in the books it is still sitting in the drawer.
- How do I clear out old items in Undeposited Funds?
- Match, don't delete. Pull the account's open items and the bank statements for the same months, then build deposits in the software that group payments to equal each real bank deposit. Items that were also recorded a second time directly to the bank account are duplicates — remove the direct entry and keep the payment, or the customer's balance will go wrong.
- Does a balance in Undeposited Funds mean my income is understated?
- Usually not — income was recognized when the invoice or sales receipt was recorded. What is misstated is cash (understated) and Undeposited Funds (overstated). But if someone also recorded the bank deposits separately as income, revenue is double-counted, which is the more expensive version of this problem.