Customer statement of account template

Everything on one customer's account for a period, and the balance after each line. The closing balance is what is owed. Sent monthly or when chasing.

Excel, Word and PDF, free, in Arabic and English.

Preview with sample figures

The preview is the file as it downloads in this language; the figures are samples to replace with your own.

Statement of Account

Customer
Golden Customer Co.
Period
1 – 31 October 2026
Opening balance
12,000.00
Company name
Al Noor Trading Est.
Address
King Fahd Road, Riyadh 12345
VAT number
310122393500003
DateReferenceDescriptionDebitCreditBalance
2026-10-03INV-2026-0001Tax invoice11,385.0023,385.00
2026-10-13RV-0215Payment received — thank you7,665.0015,720.00
2026-10-20CN-2026-0004Credit note1,725.0013,995.00
Total11,385.009,390.00

Every invoice, credit note and payment on the customer's account for the period, and the balance after each. The closing balance is what is owed.

What the customer owes, and how it got there

A statement of account (كشف حساب) lists everything on one customer's account for a period: the opening balance, each invoice as a debit, each payment and credit note as a credit, and the balance after every line. The closing balance is what is owed today. It is sent monthly, or when chasing, and it is the paper a customer reconciles against their own purchase ledger before paying.

  • Your details and the customer's, and the period covered.
  • The opening balance, which equals the previous statement's closing balance.
  • Date, reference, description, debit, credit and running balance per line.
  • Totals of debits and credits, and the closing balance.
  • Optionally an ageing: how much of the balance is current, 30, 60 and 90 days past due.

The sample

An opening balance of 12,000.00, a tax invoice for 11,385.00, a payment of 7,665.00 and a credit note of 1,725.00. The running balance closes at 13,995.00. The statement is informative, not a tax document: it charges nothing and carries no QR code, and every figure on it points to an invoice, a voucher or a note that does.

Opening balance12,000.00
+ Tax invoice INV-2026-000111,385.00
− Receipt RV-02157,665.00
− Credit note CN-2026-00041,725.00
Closing balance13,995.00

Questions

Is a statement of account a tax invoice?

No. It summarises invoices that were issued separately. It must not be used to charge VAT, and the customer cannot recover VAT from it; they recover from the invoices it lists.

How often should I send statements?

Monthly to every customer with a balance, and immediately when a payment is overdue. Customers who reconcile supplier statements pay faster when the statement arrives on the same day each month.

What if the customer disputes a line?

The line points to a document: an invoice, a receipt, a credit note. Send that document. If the invoice was wrong, the fix is a credit note, which then appears on the next statement.

Should the statement show an ageing?

It helps. Splitting the balance into current, 30, 60 and 90+ days shows the customer which invoices are late and shows you where to chase. Aqid ERP prints the ageing on every statement.

Your first compliant invoice is minutes away

Start now for free No credit card needed — invoice in minutes