To clear undeposited funds, match every payment sitting in the account to the bank deposit that actually carried it, then record those deposits so the payments leave the holding account. Payments that never reached the bank are usually duplicates of income already recorded another way. Remove those, and only genuinely undeposited money should remain.
What does an undeposited funds balance actually mean?
An undeposited funds balance is the total of customer payments recorded in the books but not yet assigned to a bank deposit. It is meant to be small and short-lived: the checks in the drawer waiting for tomorrow's trip to the bank. A balance that is large, old or growing almost always means bookkeeping errors, not money in a drawer.
Intuit's help article on what the Undeposited Funds account is calls it a temporary lockbox for payments, used because several payments are often deposited at once. The payments wait in the account until they are combined into a deposit that matches the real one. The same article notes that a business downloading transactions directly from its bank does not need the account at all.
Ask one question of the balance: could this money physically be waiting to go to the bank today? If the balance is 312.00 and there are two checks in the office, the account is working. If the balance is 48,000.00 and the oldest payment is three years old, the account is a record of payments that were received, deposited and then counted again when the deposit was recorded by another route.
Before touching anything, run a report of the open items in the account, sorted by date, with the customer, the payment method and the amount. That list is the working paper for the whole cleanup.
Grouping undeposited funds payments into the real bank deposits
Grouping undeposited funds payments means rebuilding each real bank deposit from the bank statement, then selecting the payments that make it up. Start from the bank side: each deposit on the statement is a fixed total, and the job is to find which open payments add up to it. Work one statement month at a time.
The method for one month:
- List every deposit on the bank statement for the month, with its date and amount.
- For each deposit, check whether the ledger already holds a matching deposit. If it does, skip it.
- For an unmatched deposit, look at the open payments dated in the days before it and find the set that adds up to the deposit total.
- Record a bank deposit that combines those payments, dated on the bank's date.
- Mark the deposit as cleared when you next reconcile.
Intuit's article on recording and making bank deposits in QuickBooks Online describes the same mechanics: select the checkbox for each payment to combine, and confirm the total matches the actual deposit slip. If a fee was taken from the deposit, it says to enter the fee as a negative line item on the deposit rather than editing the original payments.
Deposit slips, remittance advices and customer payment details make the grouping much faster when deposits contain many small payments. A remittance tells you which invoices a check paid, which tells you which payment record it is. Remittance advice reconciliation covers reading those documents, and matching bank deposits to invoices covers the case where no payment was recorded at all.
Why do payments get recorded twice when undeposited funds never clears?
Payments get recorded twice when the customer payment goes to undeposited funds and the bank deposit for the same money is later added from the bank feed as new income. The bank then agrees with the statement, but income is counted on the payment and again on the added deposit, and the payment sits in undeposited funds forever.
The sequence usually looks like this:
- Someone receives a check and records the customer payment, with undeposited funds as the account.
- The check is deposited, but nobody records a bank deposit in the books.
- The bank feed downloads the deposit. A different person, or the same person weeks later, categorizes it as sales income instead of matching it to the waiting payment.
- The bank reconciles. The invoice shows paid. Income is overstated by the amount of the check, and undeposited funds still holds it.
Because the bank account reconciles, nothing looks wrong on the usual monthly check. The error shows only in the undeposited funds balance, in an income figure that runs higher than the sales the business really made, and sometimes in a customer account that shows paid twice if the deposit was applied to the customer as well.
The fix for each pair is to remove the duplicate income line from the bank deposit and replace it with the waiting payment, so that the bank deposit is made up of the customer payment and nothing else. The bank total does not change, the income drops by the duplicate, and the payment leaves undeposited funds.
Clearing undeposited funds that built up over several years
An undeposited funds balance that built up over several years should be cleared oldest year first, one bank statement at a time. Old years carry the most risk, because they may already be reconciled, filed in a tax return and closed. Work forward so each year's correction is known before the next year starts.
A plan for a multi-year cleanup:
- Get every bank statement. You cannot match old payments without the deposits they belong to.
- Split the open items by year. Each year becomes its own working paper.
- For each year, classify every item as one of three things: part of a real deposit not yet recorded, a duplicate of income already recorded, or a genuine open item still waiting.
- Total the duplicates by year. That total is the income overstatement for the year, which matters for any filed return.
- Agree a cut-off date with the client or their tax adviser before changing anything in a closed period.
A summary that lists each year's opening balance, items cleared to deposits, duplicates removed and closing balance gives the reviewer a single page to follow. The format used for a summary exhibit of bank records is a good model, because it ties every figure back to a specific statement.
Worked example: clearing undeposited funds for one quarter
The example below is invented, for an illustrative contractor whose undeposited funds account held 9,450.00 at the start of a cleanup. Each item was traced to the bank statements for the quarter and given one of three results.
| Payment date (example) | Customer | Amount | Bank evidence | Result |
|---|---|---|---|---|
| 3 Jan | Hale Builders | 2,400.00 | Deposit of 3,150.00 on 5 Jan, uncategorized | Grouped with next item into one deposit |
| 4 Jan | R. Ortiz | 750.00 | Same 3,150.00 deposit | Grouped with item above |
| 18 Jan | Lane Property | 1,800.00 | Deposit of 1,800.00 on 19 Jan, booked as sales | Duplicate: replace the sales line with this payment |
| 9 Feb | Hale Builders | 2,400.00 | Deposit of 2,400.00 on 10 Feb, booked as sales | Duplicate: replace the sales line with this payment |
| 2 Mar | Pine Dental | 1,250.00 | No deposit found | Ask the client |
| 30 Mar | R. Ortiz | 850.00 | Deposit of 850.00 on 1 Apr | Deposit in transit at quarter end |
Totals for the example quarter:
- Grouped into a real deposit: 3,150.00.
- Duplicates found: 4,200.00, which is the amount income was overstated.
- Still open, with a reason: 2,100.00, of which 850.00 cleared in April and 1,250.00 needs an answer.
The 1,250.00 item is the interesting one. It could be a check that was lost, a check cashed rather than deposited, or a payment recorded against the wrong customer. It is not cleared until someone finds out which.
When writing off old undeposited funds is the wrong fix
Writing off old undeposited funds with one adjusting entry is the wrong fix whenever the balance contains duplicates or missing money. A single entry to an equity or expense account makes the account read zero, but it buries an income overstatement, hides payments that never reached the bank, and changes figures in periods that may already be closed and reported.
A write-off can look harmless because the bank already reconciles. The problem is what it conceals:
- Duplicates mean prior income was overstated. A write-off to expense offsets the income in the wrong year and leaves the earlier return wrong.
- Missing payments mean money was received and never banked. A write-off removes the evidence that would show where it went.
- Closed periods may be locked for a reason, such as a filed return or an issued financial statement. Changing them without the owner and adviser agreeing creates new problems.
There is a narrow case for a small residual write-off: after every item has been traced, a handful of tiny, very old amounts remain that cannot be supported either way. Document each one, get the owner's approval, and book it in the current period with a memo that names the items.
Keeping undeposited funds at zero after the cleanup
Keeping undeposited funds at zero after the cleanup takes one rule and one monthly check. The rule: every customer payment is either deposited through a recorded bank deposit or matched to the bank feed line that carried it, never both. The check: at each month end, the account holds only payments received in the last day or two.
Add a line to the month-end close: run the open items report for undeposited funds and look at the oldest item. If it is older than the last statement date, find out why before closing. Teach whoever categorizes bank feed lines to look for a waiting payment before adding any deposit as new income.
PreciseBankFlow reads the client's bank statements, confirms each one foots, and matches deposits to the ledger, which gives you the list of real deposits to rebuild from when an old balance needs clearing. You can request a spot in the early access group.