Reconcile Payments Before Sending Overdue Invoice Reminders
10/06/2026
By Talia. E
An overdue-invoice list is only useful when it reflects payments that have actually arrived. Before sending reminders, compare recent bank deposits, processor payouts, checks, and transfer confirmations with open invoices. This short control can help you avoid asking a customer for money they have already paid while keeping the accounts-receivable balance ready for month-end review.
The IRS notes that a small-business recordkeeping system should clearly show income and expenses, and that invoices, deposit information, account statements, and other supporting documents help substantiate entries in the books. IRS: What kind of records should I keep This is a bookkeeping workflow, not legal, tax, or investment advice.
Make “paid” a verified status, not an assumption
An invoice should not move to paid simply because a customer says payment was sent, an automated feed suggests a match, or a payment processor reports a pending payout. Mark it paid when you can connect the invoice to an actual payment record: a cleared bank deposit, card-processor transaction, check image, ACH confirmation, or other documented receipt.
Create a separate review status for payments that are received but not yet confidently matched. This prevents two common errors: leaving a paid invoice in the overdue list and applying a customer’s payment to the wrong invoice.
- Open: invoice sent; no payment identified.
- Payment received—match needed: money appears in the bank or processor, but the customer, invoice number, or amount needs review.
- Paid and applied: payment has been matched and recorded against the invoice.
- Exception: short payment, duplicate payment, combined payment, unapplied credit, dispute, refund, or unidentified deposit.
Use a five-step payment-to-invoice review
Run this review before your scheduled overdue reminders and again as part of the monthly close. The goal is not to force every deposit into a match immediately; it is to identify what is known, isolate what needs follow-up, and keep reminders from relying on stale information.
A good system may be accounting software, an invoicing platform, or a spreadsheet. What matters is a complete trail from the customer invoice to the payment record and the bank or processor evidence behind it. The IRS says electronic records are subject to the same recordkeeping principles as paper records and should provide a complete, accurate, accessible record. IRS: How should I record my business transactions
- 1. Export or review open invoices, including invoice number, customer, issue date, due date, original amount, balance, and payment terms.
- 2. Gather payments received since the last review from the business bank account, card processor, payment app, lockbox, and undeposited-check list.
- 3. Match by invoice number first. If it is missing, compare customer name, amount, payment date, remittance message, and supporting correspondence.
- 4. Record the payment against the invoice and preserve the source reference, such as deposit date, processor transaction ID, or check number.
- 5. Place anything uncertain in an exception list. Do not send an automatic reminder until the exception is resolved or reviewed by the person responsible.
Work exceptions before treating an invoice as overdue
Exceptions are normal, especially for service businesses that receive partial payments, deposits, combined payments, retainers, or payments through several channels. Give each exception an owner and a next action date so it does not remain in suspense indefinitely.
For example, a $1,500 deposit may represent one $1,500 invoice, three smaller invoices, or a customer payment net of a processing fee. The bank confirms cash arrived, but the receivables record is not complete until the payment is correctly applied. Record any processor fee separately rather than reducing invoice revenue merely to make the deposit match.
- Unidentified deposit: check the payer name, payment memo, processor detail, email remittance, and recent invoice amounts.
- Short payment: apply the amount received, leave the remaining balance open, and document whether the difference is a discount, fee, dispute, or error.
- One payment for several invoices: apply the payment using the customer’s remittance advice; if none exists, contact the customer before guessing.
- Duplicate payment: leave the second amount as an unapplied customer credit or a refund item until it is resolved.
- Payment in transit: retain the customer confirmation, but keep the invoice open or clearly flagged until payment is verifiable under your established policy.
Send reminders from a clean, prioritized list
After recent payments and exceptions are reviewed, produce an overdue list that shows only verified open balances. Include the invoice number, due date, outstanding amount, contact, last contact date, and next follow-up action. A fixed schedule is easier to manage than relying on memory.
Keep the message factual and easy to resolve. State the invoice number, amount due, due date, payment options, and a contact point if the customer believes the balance is wrong. Before escalating a reminder or pausing additional work, review the customer record for documented disputes, promised payment dates, deposits, or credits.
- Before due date: send a courtesy copy or payment link when appropriate.
- On or shortly after the due date: send a neutral reminder only after the payment review is complete.
- Later follow-up: use the escalation steps stated in the customer agreement and your business policy.
- Document each contact attempt and any payment commitment in the customer record.
Build the review into monthly close
Bank reconciliation and accounts receivable should inform each other, but they answer different questions. Bank reconciliation asks whether book cash agrees with the bank after timing items are identified. Accounts receivable review asks which customers still owe valid, collectible invoice balances. Completing both gives owners a more reliable view of available cash and expected collections.
The Small Business Administration lists accounts receivable, available cash, and bank reconciliation among the functions a business needs someone to manage. SBA: Manage your business Use a brief reconciliation sign-off to show what was reviewed, what remains unresolved, and who will address it.
- Reconcile each business bank and credit-card account through the statement end date.
- Match or classify customer receipts received through that date.
- Review the accounts-receivable aging for invoices marked paid, credit balances, old unapplied cash, and past-due balances.
- Compare total open receivables with the customer-detail report; investigate differences before finalizing reports.
- Save the bank reconciliation, aging report, exception list, and key supporting documents together for the period.
- Set the next review date and assign each unresolved item to a named person.
Frequently asked questions
Should I wait for a bank deposit to clear before marking an invoice paid?
Use a consistent policy based on your payment method and risk tolerance. A cleared or otherwise verifiable payment record provides stronger support than an unverified customer message. If you record an earlier status, label it clearly as pending or received so it is not confused with final payment.
What if one bank deposit covers several customer invoices?
Use the customer’s remittance advice or obtain confirmation before applying the payment. Record each allocation against the related invoice, retain the payment reference, and keep any remainder as unapplied cash or a customer credit until resolved.
Why does my bank balance reconcile while invoices still look unpaid?
A bank reconciliation can confirm that cash activity in the books agrees with the bank, while customer payments may still be sitting in an unapplied-cash, clearing, or suspense account. Review those accounts alongside the accounts-receivable aging to finish the customer-level matching.
Can I use a spreadsheet instead of accounting software?
Yes, if it creates a complete and orderly record. Track invoice details, payment references, application dates, exceptions, and links to supporting documents. The IRS allows recordkeeping systems that fit the business as long as they clearly show income and expenses and are supported by records. IRS: What kind of records should I keep
How often should I review customer payments?
Set a frequency that matches payment volume and reminder timing. A low-volume professional service firm may review weekly, while a home-service business or retailer receiving frequent card and processor payments may need a short daily review. Always run the review before overdue reminders and during monthly close.
Sources and further reading
This article provides general educational information and is not tax, legal, accounting, or investment advice. Rules and individual circumstances can change; consult an appropriately qualified professional for advice about your situation.