Your accounts receivable report says a customer owes you $14,200. The customer says they paid last week. Both can be right: the money may have arrived but never been matched to an invoice. Regular reconciliation is how you find these gaps before they turn into awkward collection calls. This guide answers the common questions about reconciling customer accounts and catching unapplied payments.
What does it mean to reconcile a customer account?
Reconciling a customer account means comparing what your books say the customer owes with independent evidence, and explaining every difference. The evidence usually comes from two places: your bank records, which show what was actually received, and the customer’s own view, such as their statement or remittance advice. When all three agree, the balance is reliable. When they do not, something needs investigating.
Why do balances drift apart?
- Payments not yet matched. Money is in the bank but sits unallocated.
- Short payments. The customer deducts a bank fee, a disputed line or a discount you did not record.
- Bulk payments. One transfer covers several invoices, and the remittance detail is missing.
- Wrong customer or wrong invoice. A payment is posted against a similarly named account or a mistyped number.
- Unissued credit notes. You agreed a credit, the customer deducted it, and your system never recorded it.
- Timing. The customer paid on the 30th and the funds cleared on the 2nd.
What is an unapplied payment?
An unapplied payment is money you have received but not yet matched to specific invoices. It is usually recorded as a credit on the customer’s account or parked in a holding account. The invoices stay open and look overdue, while the credit sits quietly elsewhere. The result is a distorted aging report, needless reminders and an irritated customer.
How do you reconcile an account step by step?
1. Choose a cut-off date
Pick one date, usually month end, and work with everything up to it. Comparing figures from different days is the most common source of false differences.
2. Gather both sides
Export the customer ledger from your system: invoices, credit notes and payments. Then collect the bank lines for the same period and the customer’s statement or remittance advice if you have it.
3. Match line by line
Tick off each payment against the invoices it settles. Match on reference number first, then on exact amount, then on date and payer name.
4. List every difference
Write down each item that does not match, with its amount and date. Group them by cause: unapplied, short paid, disputed, timing or error.
5. Investigate and correct
Apply the unapplied payments, record missing credit notes, fix mispostings and send disputed items to whoever can resolve them. Note the reason for each adjustment.
6. Confirm the final balance
Check that the corrected ledger balance equals the bank evidence plus any explained timing items. If you still have a gap, it is not finished.
How do you spot unapplied payments?
- Credit balances. Run a report of customers with a negative or credit balance. Each one is a candidate.
- Customers with both credits and overdue invoices. This combination is the classic sign of a payment that never found its invoice.
- Bank lines with no match. Filter your bank feed for receipts that are not linked to any invoice.
- Suspense or holding accounts. Review anything sitting there for more than a few days.
- Customer complaints. “We already paid this” deserves a search of the bank first, not an argument.
- Round or odd amounts. A payment that equals two invoices minus a fee often points to a bulk, short-paid transfer.
A short example
A customer has five open invoices totalling $14,200, and your aging report shows $6,800 of it as 30 days overdue. In the bank feed you find a $3,000 transfer from the customer dated October 5, referenced only with the company name. It was posted as an on-account credit. You apply it to the two oldest invoices, which removes $3,000 of apparent overdue debt. The true net balance is $11,200, and the reminder you were about to send would have been wrong.
How often should you reconcile?
Match incoming payments daily or weekly, before they pile up. Review credit balances and unmatched receipts weekly. Do a fuller reconciliation of your largest accounts monthly, and send statements so customers can flag differences. Smaller accounts can be sampled quarterly.
Habits that prevent most problems
- Ask customers to quote the invoice number on every payment.
- Request remittance advice for bulk transfers.
- Record credit notes the day they are agreed.
- Clear the holding account as a rule, not as a clean-up project.
- Keep the person who receives cash separate from the person who applies it where you can.
Reconciliation is routine bookkeeping, not detective work. Done steadily, it keeps your receivables report honest and your collection conversations accurate.
Frequently asked questions
What is the difference between reconciliation and cash application?
Cash application matches a received payment to invoices. Reconciliation is wider: it compares your ledger, the bank and the customer's records and explains every difference, including unapplied cash.
How long should an unapplied payment stay unapplied?
Ideally a few days. Anything older than a month signals a missing reference or a process gap, and should be investigated and cleared before the next statement goes out.
Should I send a reminder before reconciling an account?
No. First check for credits and unmatched receipts. Chasing a customer who has already paid damages trust and wastes your collection effort.
What if the customer's figures never match mine?
Send a statement listing open items and ask them to compare it line by line. Most differences come down to a few specific invoices, credits or timing items, not the whole balance.
FulcrumGrid Collection
Follow up on the right invoices only
FulcrumGrid Collection helps you track overdue invoices and follow-ups in one place, so reminders go out for what is genuinely unpaid once your payments are matched.