Accounts receivable
-
3
 min read

Statement of account template

Copy a statement of account template to reconcile customer invoices, payments and credits. See a worked example and show what is overdue.

By Lars Holdgaard, Founder & CEO of Debitura

Statement of account template

A statement of account summarizes what one customer owes as of a specific date. Use this template to show the opening balance, new invoices, applied payments and credits, and the closing balance. List overdue amounts separately so the customer can see what needs attention.

Copy the statement of account template

Select the rows below and paste them into a spreadsheet. Replace the fictional entities and references. Keep one currency per statement and list each invoice, payment and credit on its own row.

Statement datePeriod startPeriod endSupplierCustomerCurrencyTransaction dateTypeReferenceApplied to invoiceInvoice due dateEntry amountRunning balance
2026-11-192026-11-012026-11-19Copper Quay Components LtdNorth Weir Parts BVEUR2026-11-01Opening balanceOPEN-NOVNW-1012026-10-231500
2026-11-192026-11-012026-11-19Copper Quay Components LtdNorth Weir Parts BVEUR2026-11-02InvoiceNW-1142026-11-1628004300
2026-11-192026-11-012026-11-19Copper Quay Components LtdNorth Weir Parts BVEUR2026-11-08PaymentPMT-448NW-114-12003100
2026-11-192026-11-012026-11-19Copper Quay Components LtdNorth Weir Parts BVEUR2026-11-12CreditCN-039NW-114-3002800
2026-11-192026-11-012026-11-19Copper Quay Components LtdNorth Weir Parts BVEUR2026-11-16InvoiceNW-1262026-12-169003700

Worked example with invoices, a payment and a credit

Fictional example. Copper Quay Components Ltd sends this EUR statement to North Weir Parts BV for 1 to 19 November 2026. A prior-period invoice, NW-101, accounts for the EUR 1,500 opening balance.

Account activity in EUR
Date and referenceLedger entryChange in EURRunning balance in EUR
1 Nov 2026 · openingPrior-period invoice NW-101, due 23 OctNone1,500
2 Nov 2026 · NW-114New invoice, due 16 Nov+2,8004,300
8 Nov 2026 · PMT-448Payment applied to NW-114-1,2003,100
12 Nov 2026 · CN-039Credit note applied to NW-114-3002,800
16 Nov 2026 · NW-126New invoice, due 16 Dec+9003,700

Closing balance = EUR 1,500 + EUR 2,800 - EUR 1,200 - EUR 300 + EUR 900 = EUR 3,700.

Overdue on 19 November: EUR 2,800. NW-101 is overdue by EUR 1,500. NW-114 has EUR 1,300 overdue after the payment and credit. Not yet due: EUR 900 for NW-126, due 16 December.

Reconcile the statement before sending it

  1. Check the customer’s legal name, account reference, period and currency. Start from the opening balance for that account and currency.
  2. Use your ledgers and remittance records to match payments and credit notes to the right invoices. Show an unallocated receipt separately and flag its status if you cannot match it.
  3. Check that the closing balance agrees with the account ledger. Show the due dates and remaining balances for open invoices. An open amount becomes overdue after its due date.
  4. Share the statement with your accounts payable contact, include the relevant invoice references and ask them to identify any differences. Use the original invoices for the underlying charges and payment terms.

When you have reconciled an overdue B2B balance

Keep the statement, original invoices and the records supporting any payments or credits. Start a collection case with Debitura.

Reference

Microsoft Business Central customer statement report

Subscription

Sign up to our newsletter

Get updated on best practices, tips and tricks about international debt collection and accounts receivable management.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.