Practical guide
Account statement reconciliation
An account statement is the one-page answer to "where do we stand?" for a single customer over a period. It rolls every invoice, credit note, debit note, and payment receipt into a dated list with a running balance: an opening balance, the period's activity in order, and a closing balance that says exactly what is owed today. Reconciliation is the act of checking that this statement and the customer's own records tell the same story - and chasing down the difference when they do not.
Who needs this workflow
Any business that invoices the same customers repeatedly on credit terms: wholesalers, trades with account customers, agencies, landlords, and freelancers with retainer clients. One-off, pay-on-the-spot sales do not need statements. The moment a customer can have three unpaid invoices and a part-payment in flight at once, a monthly statement stops being optional - it is how both sides stay agreed on the balance, and it is the standard polite first step before chasing overdue amounts.
How a statement is built
- Fix the period. A start and end date, commonly a calendar month. Every document dated inside the period appears; everything earlier is compressed into the opening balance.
- Compute the opening balance. The amount the customer owed at the period start: all earlier invoices and debit notes, minus all earlier payments and credit notes. It must equal the closing balance of the previous statement - if it does not, resolve that first.
- List the period's activity in date order. Each line carries the document date, type, and number. Invoices and debit notes are debits (they increase what is owed); payments and credit notes are credits (they decrease it).
- Carry a running balance. Every line shows the balance after that transaction, so any point-in-time question ("what did they owe on the 15th?") reads straight off the statement.
- Close: opening balance + total debits − total credits. The result is the closing balance - the single number the statement exists to establish.
- Age the unpaid amounts. Group what remains unpaid by how overdue it is: current (not yet due), 1–30, 31–60, 61–90, and over 90 days past due. Payments are applied to the oldest open invoices first unless the customer directed otherwise, so the aging shows which invoices are actually still open.
Worked example: one customer, one month
Opening balance on June 1 is 1,250.00 (invoice INV-1041 from May, still unpaid).
| Date | Document | Debit | Credit | Balance |
|---|---|---|---|---|
| Jun 1 | Opening balance | 1,250.00 | ||
| Jun 3 | Invoice INV-1052 | 830.00 | 2,080.00 | |
| Jun 10 | Payment receipt PR-217 | 1,250.00 | 830.00 | |
| Jun 18 | Credit note CN-31 | 120.00 | 710.00 | |
| Jun 24 | Invoice INV-1060 | 415.00 | 1,125.00 |
Check the arithmetic: debits total 830.00 + 415.00 = 1,245.00; credits total 1,250.00 + 120.00 = 1,370.00; closing balance is 1,250.00 + 1,245.00 − 1,370.00 =1,125.00. Applying payments oldest-first, PR-217 clears INV-1041 exactly, and CN-31 reduces INV-1052 to 710.00. If INV-1052 was due June 17 and INV-1060 is due July 8, the June 30 aging reads: current 415.00, 1–30 days overdue 710.00, nothing older. The customer sees at a glance that one invoice needs attention and the other is simply not due yet.
Reconciling when the numbers disagree
If the customer says the balance is wrong, compare statements line by line and look for the four classic causes, in order of likelihood:
- Timing. A payment sent near period end appears in their records but not yet in yours. Note it as reconciled-in-transit; it resolves itself next period.
- Missing documents. An invoice they never received, or a credit note you issued that they never recorded. Re-send the document, not just the number.
- Misapplied payments. A payment applied to the wrong invoice on one side. The totals may even agree while the aging disagrees - fix the allocation.
- Amount discrepancies. A keyed typo or a disputed line. This is the only case that needs a correcting document: a credit note if you overbilled, or a debit note if you underbilled, on the next statement.
Never "fix" a disagreement by editing history. Issued documents stay as they are; every correction is a new document that itself appears on the statement.
How the statement differs from adjacent documents
- Statement vs invoice. An invoice bills one sale; a statement summarizes all open activity. A statement is not a demand to pay twice - invoices already billed are simply listed on it.
- Credit note vs debit note. On a statement, a credit note reduces the customer's balance and a debit note increases it. Seecredit note vs debit note.
- Invoice vs payment receipt. The invoice asks; the receipt confirms. Both appear on the statement, on opposite sides of the balance. Seeinvoice vs payment receipt.
- Statement vs payment reminder. A statement is neutral bookkeeping sent on a schedule; a reminder targets specific overdue invoices and asks for action. The aging section of a statement is usually what triggers a reminder.
Frequently asked questions
How often should I send customer statements?
Monthly is the norm for credit accounts - same day each month, to every customer with a non-zero balance or any activity in the period. Regularity does most of the work: customers who expect a statement pay faster, and discrepancies surface after one month instead of six.
Is an account statement a demand for payment?
No. It is a summary of the account's position; the demands were the invoices on it. In practice a statement often prompts payment anyway, and its aging section is the natural basis for a separate payment reminder when something is genuinely overdue.
Can a statement balance be negative?
Yes - a negative closing balance means you owe the customer, usually after an overpayment or a credit note issued when nothing was outstanding. Show it clearly as a credit balance and either refund it or carry it forward against future invoices.
What is an aging report and how does it relate to a statement?
Aging is the breakdown of unpaid amounts by how far past due they are - current, 1–30, 31–60, 61–90, and 90+ days. A statement ages one customer's balance; an aging report does the same across all customers to show where collection effort should go.
Should paid invoices appear on the statement?
Invoices paid during the period appear together with their payments, so the customer can see the loop close. Invoices paid before the period started are inside the opening balance and are not restated.
How long should I keep statements and their source documents?
Retention periods for business records are set by each jurisdiction and commonly run to several years - check the requirements for yours on thecountry pages. Keep the statement together with the invoices, credit notes, and receipts it lists, since a statement is only as good as the documents behind it.
Doing this in Formnivo
The account statement generator builds the statement for you, and the workspace can aggregate it from the source documents themselves: invoices, credit notes,debit notes, andpayment receipts for a customer roll up into one statement that keeps a reference to every source document it includes. The running balance, debit and credit totals, closing balance, and the aging buckets (current, 1–30, 31–60, 61–90, 90+ by due date, with payments applied oldest-first) are all calculated for you. From a finished statement you can create apayment reminder that references the statement number for anything overdue. Everything is free and needs no account. The editor saves this workspace in this browser on your device.