Statement of Account Generator
Build an account statement from dated debit and credit lines, with an opening and closing balance, on a print-ready A4 page.
Every movement, in date order
An account statement is a list of transactions with a balance at the end. This page gives you one row per movement: a date, a reference, a description, a debit, a credit and a balance column, with opening, closing and amount-due totals underneath.
How the totals are worked out
The opening balance starts at zero because the page cannot know what came before. The closing balance is the credits you entered minus the debits you entered, and the amount due is that closing figure when it is positive, or zero when it is not. If you need a carried-forward opening balance, enter the earlier movements as rows instead of trying to type a total: the page derives its totals from the rows rather than accepting a figure it cannot check.
Account details
The account number and the account manager are optional header fields. The statement period is the secondary date field, so the reader can see exactly which window the rows cover.
Printing
The preview is A4. Print it or save it as PDF; the editor and the site navigation are not part of the output.
What it does not do
It does not connect to a bank, import transactions, or reconcile anything. There is no upload and no account, so the figures stay in this tab.
An account statement is a list of movements with a balance at the end. Each row carries a date, a reference, a description, a debit, a credit and a balance column, with opening, closing and amount-due totals underneath.
The opening balance starts at zero because the page cannot know what came before. Closing is the credits entered minus the debits entered, and the amount due is that closing figure when it is positive, or zero when it is not.
If a balance must carry forward, enter the earlier movements as rows rather than typing a total: the page derives its totals from the rows and will not accept an opening figure it cannot check.
Reading the columns
Debit and credit are separate money columns, so a movement belongs in one or the other rather than being signed. The balance column is yours to fill row by row; the page does not recompute a running balance down the table.
The statement period is the secondary date field, so a reader can see which window the rows cover. The account number and account manager are optional header extras.
- Date, reference, description, debit, credit and balance
- Opening, closing and amount due
- A statement period as the second date
What it does not reconcile
It does not connect to a bank, import transactions or match a payment to an invoice. A statement built from typed rows is a presentation of figures you already hold, not a reconciliation.
A negative closing balance shows amount due as zero rather than a credit owed to the customer. That is a deliberate simplification, and a statement that must express a credit balance needs a different document.
How to use the movement rows
Name the account, the statement number and the period the rows cover, then add one row per movement with its date, reference, description and the amount in the debit or the credit column, filling the balance column by hand. Carry a balance forward by entering the earlier movements as rows, since the opening always starts at zero.
Press Print document once the closing reads credits minus debits and the amount due matches what is owed. Put each movement in exactly one of the two money columns, or the closing answers a question the ledger never asked.
What to Expect
Best for
- A simple ledger extract for a customer
- A list of movements over one period
- A printable balance summary
Not ideal for
- Reconciling a bank account
- A carried-forward opening balance typed as a total
- A statement that must show a credit owed to the customer
What this tool keeps
- Every row as typed
- A closing balance of credits minus debits
- An amount due only when closing is positive
What may need cleanup
- The opening balance, which always starts at zero
- The running balance, which is not recomputed per row
- A negative closing, which is shown as zero due
Common errors
- Typing an opening balance and expecting the closing to include it
- Putting a movement in both debit and credit
- Reading a zero amount due as a settled account
Example use cases
- A customer account summary
- A rent ledger extract
- A simple supplier statement
Sample input
A statement for an account, number ST-31, covering October, with four movements and a positive closing balance.
Sample output
An A4 statement with four rows, an opening of zero, a closing equal to credits minus debits and the same figure as amount due.
Who this is for
- Bookkeepers preparing a statement
- Landlords summarising rent
- Small businesses reporting an account
Frequently asked questions
What does an account statement contain?
Rows with a date, a reference, a description, a debit, a credit and a balance, with opening, closing and amount-due totals underneath.
Does it reconcile a bank account?
No. It lays out the movements; reconciliation is a separate job.
Why does the opening balance start at zero?
The opening balance always starts at zero, so a carried-forward figure must be added as a row or by hand.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.