Identify the receipts behind the balance
Run the account detail and list each payment still awaiting a deposit record. Include the customer, receipt date, amount, payment method and invoice application. Separate recent receipts genuinely waiting to be banked from items that have survived several closes. A total alone cannot show whether the business still holds the money or the accounting workflow stopped halfway through.
Intuit describes Undeposited Funds as a place to hold receipts before combining them into a bank deposit. The exact workflow depends on the product and payment integration. Confirm how the company's system handles its receipts before moving entries manually; some integrated payment flows already create the required deposit records.
References: Intuit: Recording payments in Undeposited Funds
Find the actual deposit for each old receipt
Compare deposit slips, bank credits and detailed payment reports. Several customer payments may form one bank deposit, so search by the component amounts as well as the total. Preserve the batch reference that connects the receipts to the bank. A receipt may also have been split across deposits or reduced by an evidenced charge.
Intuit's grouped-deposit guidance explains matching combined receipts to the bank's deposit total. Use the actual deposit evidence to reconstruct the grouping. Do not combine unrelated old items solely because their sum matches a convenient bank credit.
For a returned or failed customer payment, trace the return and restore the appropriate receivable under the accountant's review. The item should not remain labeled undeposited indefinitely if the money was never successfully collected.
References: Intuit: Recording grouped bank deposits
Look for deposits recorded as new income
A common investigation question is whether someone added the bank credit as a new sales transaction instead of matching it to receipts already recorded. That can leave the original payments in the clearing account while income is recorded again. Confirm the full chain before correcting it, including the customer's invoice status and any tax or reporting effect.
Check for manual deposit entries created during a feed outage or software transition. A later automatic deposit may duplicate them. Use references, dates and component payments to establish which record represents the real event. Preserve the correction history instead of deleting a whole batch without examining its invoice applications.
Where old periods are involved, ask the accountant to decide the correction process. A journal that empties the account may leave customer balances or duplicate revenue untouched. The goal is to repair the receipt-to-deposit relationship, with the affected statements reviewed as necessary. Identify conversion entries separately when the balance originated in a migration rather than a current customer receipt.
Leave a clear balance and a repeatable monthly check
After corrections, reconcile the remaining items with money actually awaiting deposit or settlement. Each item should have a location, expected next event and responsible person. Compare the resulting deposit records with the bank reconciliation and confirm that the same receipt is recognized only once.
Set a review frequency that fits the collection process. Recent undeposited checks, daily cash deposits and processor payouts may have different expected timelines. Escalate items that exceed the relevant timeline rather than applying one arbitrary aging rule to every payment method.
Give the collection and bookkeeping teams a shared instruction for recording receipts, forming deposits and matching bank credits. Test it on a real completed batch. A documented example from the company's own workflow can prevent the next employee from recreating the old balance through a different route.
Sources
Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.
Related reading
Need help with this work?
General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.