To repair an accounts receivable (AR) aging report after a lump-sum deposit, identify the payments within the bank deposit, verify the customer and invoice for each payment, apply the payments through the customer subledger, and then reconcile the resulting deposit to the bank. Do not assume that a bank entry alone closes an invoice or that every correction has the same revenue or tax effect.
Why a correct bank balance can coexist with incorrect AR aging
AR aging is a report of unpaid customer balances, usually grouped by how long invoices have been outstanding. It depends on the customer subledger: the detail records that connect customers, invoices, credit memos, and payments. The general ledger and bank balance may show cash received even when that receipt was not applied to the related customer invoice.
For example, a business might deposit several customer checks as one bank amount. If the entry is recorded only as a bank-feed categorization or a general-ledger posting, the cash may appear in the books while the individual invoices remain open. The result is an aging report that overstates amounts due and can lead staff to contact a customer who has already paid.
A lump-sum deposit is not inherently an error. The issue is whether the accounting system retains a defensible link between the banked amount, the individual payments, and the customer documents those payments settle.
Start with evidence, not a journal-entry shortcut
Before changing a transaction, collect the records needed to explain it. The goal is to establish a payment trail that another reviewer can follow.
- Bank statement detail, deposit slip, lockbox file, or payment-processor settlement report
- Customer remittance advice, check image, ACH addenda, wire reference, or card-settlement detail
- The open-invoice list as of the deposit date and the current AR aging report
- The existing bank-feed, deposit, receipt, or journal-entry record that may have been posted incorrectly
Compare the total of the identified payments with the bank deposit. Investigate rather than force a match when there is a difference. Common explanations include fees, merchant reserves, short payments, credit memos, foreign-exchange differences, timing, or a payment that belongs in another deposit.
A controlled cleanup process
1. Define the exception
Record the deposit date, bank amount, accounting-system transaction ID, affected customers, and affected invoices. Note whether the original posting reached income, AR, a clearing account, or an unapplied-cash account. This makes it possible to distinguish a missing invoice application from a broader posting error.
2. Build a payment-to-invoice map
For each component payment, document the payer, amount, date, payment reference, and invoice or approved allocation. A customer payment may legitimately cover several invoices; conversely, a single invoice may be paid in installments. Do not apply an amount to an invoice merely because the amounts are similar.
3. Apply confirmed receipts in the customer subledger
Use the accounting system's customer-payment process to apply each verified payment to the intended invoice or invoices. If the payer or allocation cannot be verified, hold it as unapplied cash or in the system's approved suspense workflow, with an owner and follow-up date. This is more informative than closing an invoice on an assumption.
4. Correct the original posting with an audit trail
After the intended receipt entries are understood, determine whether the original bank or general-ledger entry must be reversed, reclassified, or matched to the corrected deposit. Follow the organization's close policy and preserve the original reference, rationale, approver, and date. For a closed period, audited financial statements, or a material correction, involve the controller, CPA, or other authorized reviewer before changing posted records.
5. Reconcile and re-run the reports
Confirm that the corrected deposit equals the bank activity, that the intended invoices no longer appear as open, and that the AR subledger agrees with its related general-ledger control balance. Review the revised aging for remaining unapplied cash, credits, disputed items, and unusual negative balances.
Using an Undeposited Funds or clearing-account workflow
Many accounting systems offer a temporary account for receipts that have been recorded by customer but have not yet been grouped into a bank deposit. In QuickBooks, Intuit describes Undeposited Funds as a temporary account for invoice payments and sales receipts; its workflow combines individual payments into the amount shown by the bank.
That structure can be useful when one physical or electronic bank deposit includes multiple payments. It permits the customer-level receipt to close the appropriate invoice while the subsequent deposit entry matches the single bank amount. However, it is a workflow feature, not a universal accounting requirement. Intuit also notes that the intermediate account may not be needed in every direct bank-download workflow. Other ERP systems use different names and controls, so follow the documentation and configuration of the system in use.
Revenue and tax: avoid automatic conclusions
A miscoded deposit does not, by itself, prove that revenue was duplicated or that a tax bill should fall after a cleanup. The effect depends on how the original invoice, receipt, deposit, and any adjusting entry were recorded, as well as the entity's accounting method and tax facts.
The IRS explains that cash-method taxpayers generally report income when received, while accrual-method taxpayers generally report income when earned; it also requires records that support a correct return and a consistent accounting method. See IRS Publication 538, Accounting Periods and Methods. Use the reconciliation to improve record accuracy, then have a qualified tax adviser assess any tax-return, revenue-recognition, or period-close consequence.
Controls that reduce repeat exceptions
- Require remittance information or a documented allocation for payments applied across multiple invoices.
- Reconcile bank deposits to customer receipts on a defined cadence, with an exception queue for unmatched items.
- Review unapplied cash, clearing-account balances, and old credits before collections activity begins.
- Restrict and log changes to prior-period transactions, including who approved the correction and why.
- Give collection staff a current aging report and a way to flag a claimed prior payment for research before further contact.
These controls support accurate customer communication, cleaner cash application, and a more reliable aging report. They do not replace the organization's accounting policies or professional advice on material reporting and tax matters.
Frequently asked questions
Which measure can improve accounts receivable management?
A practical measure is a recurring reconciliation of the customer AR subledger, unapplied-cash or clearing balances, and bank deposits. Track the count and dollar value of unmatched receipts, the age of those exceptions, and the time required to resolve them; then investigate items before the aging report is used for collection outreach.