A clear statement of account that reconciles every charge and payment
When a client has several open invoices, a statement of account is the cleanest way to remind them of the total owing. This builder turns a list of charges and payments into a running ledger, carries the balance forward line by line, and produces a tidy statement you can email or attach for your monthly dispatch.
How it works
The statement starts from the opening balance brought forward. The builder processes each transaction in order: it adds any charge and subtracts any payment, then carries the new running balance to the next line — so every row shows exactly what was owed at that point. At the end it sums all charges and all payments and computes the closing balance owing, which equals the opening balance plus total charges minus total payments. Amounts are formatted in your chosen currency with the matching symbol, and the output is an aligned, copy-ready statement with a polite settlement note.
Tips and example
Use the reference column for invoice numbers on charges and payment references on receipts, so the client can match each line to their own records. Start from a non-zero opening balance when you are carrying forward last month’s unpaid amount. For example, an opening balance of 0, a 1,200 charge, a 1,200 payment, then two new charges of 850 and 640 produces a closing balance owing of 1,490. Send statements on a consistent day each month — predictable reminders get paid faster than ad-hoc ones.