How does a statement of account differ from an invoice?
An invoice bills a customer for a single order or milestone, whereas a customer statement summarizes all invoices, credit notes, and payments across a chosen period. Using a browser-based account statement template avoids manual spreadsheet formulas while showing the opening balance, each transaction in date order, and the closing balance due.
When to send a periodic customer statement
B2B suppliers, agencies, and wholesalers typically issue statements monthly or quarterly to clients with recurring orders or net-30 payment terms. Consolidating multiple open bills into one summary helps accounts payable teams spot missing invoices or unapplied credits quickly.
Under GOV.UK Company and Accounting Records Guidance, businesses must keep accurate records of all money owed by customers and money received. Sending a clean statement reduces disputes before balances become severely overdue.
Loading saved invoices and credit notes from browser storage
If you previously created documents in this browser using our billing tools, your client list populates the Client autocomplete dropdown automatically. Clicking Load saved invoices for this client imports matching invoices and credit notes straight from local IndexedDB.
When you issue a refund or billing adjustment, issuing an itemized credit adjustment PDF on the same device lets the statement pull that credit into the client’s running balance automatically. Manual entries you add afterward stay preserved alongside loaded records.
Running balance math and 5-bucket overdue ageing
Transactions sort chronologically by date, with invoices ordered before credit notes and payments on the same day. Invoices add to the running balance, while credit notes and payments subtract from it, rounded to the selected currency’s decimal precision.
For ageing analysis, the calculator applies First-In, First-Out (FIFO) settlement against a positive opening balance first, followed by invoices sorted by due date. As noted in GOV.UK Late Commercial Payments and Debt Recovery, tracking exact days past due establishes a clear timeline for commercial follow-up.
| Ageing bucket | Days past due on statement date | Calculation behavior | Typical follow-up action |
|---|---|---|---|
| Current | 0 days or not yet due | Unpaid balance with future or same-day due date | Routine monthly statement |
| 1–30 days late | 1 to 30 days overdue | Remaining debt after FIFO credit allocation | Polite reminder notice |
| 31–60 days late | 31 to 60 days overdue | Middle-tier overdue receivable balance | Firm account follow-up |
| 61–90 days late | 61 to 90 days overdue | High-risk overdue invoice balance | Final notice or hold on credit |
| Over 90 days late | 91+ days or positive opening balance | Long-overdue debt or unallocated prior balance | Escalation or formal recovery |
If an invoice has no separate due date, the calculator treats its issue date as the due date. Once an account enters the 31-day or 61-day tiers, you can create overdue payment reminder letters with automatic days-late counts to escalate collection.
Opening balance rollovers, manual entries, and currency rules
By default, the From field starts two months earlier on the first day of the month, while To and Statement date default to today. Adjusting those dates controls which transactions print as line items and which roll into the prior balance.
Rolling pre-period activity into the opening balance
Any saved invoice or credit note dated strictly before the From date is summed into the Opening balance field when you load client records. A positive opening balance enters the Over 90 days late bucket unless offset by later payments.
If a customer overpaid in a prior period, a negative opening balance acts as available credit that automatically reduces the oldest new invoices in the ageing table. You can also edit Opening balance by hand at any time.
Adding external payments, credit notes, and multi-currency accounts
Because bank transfers and checks arrive outside an invoicing app, click Add a payment to record remittance dates, check numbers, and amounts. Use Add an invoice or Add a credit note for documents created in external software.
Every statement enforces a single currency so running totals remain valid. If a client has saved invoices in multiple currencies, the loader skips mismatched currencies and reports the exact count in the status notice. When an earlier invoice undercharged a buyer, you can issue a formal debit note for underbilled balances before generating the period summary.
Live PDF preview, local privacy, and recordkeeping scope
As you edit fields, the live preview panel refreshes after a 240 ms debounce and your working draft saves to browser IndexedDB every 500 ms. Zero bytes of client names, addresses, or receivable totals ever leave your device.
Choosing A4 or US Letter paper and downloading PDFs
The Paper selector defaults to US Letter for North American browser locales (en-US and en-CA) and A4 everywhere else, though you can switch formats before exporting. Clicking Download statement generates the final PDF in a local Web Worker named statement-<client>-<date>.pdf.
Tip: Enter your bank account, IBAN, or payment link inside Payment details so clients can settle their closing balance directly from the statement PDF without emailing for wire instructions.
Audit retention and non-accounting-advice boundaries
According to the IRS Small Business Recordkeeping Retention Guide, businesses must retain supporting sales ledgers and receivable documentation for at least 3 to 7 years depending on the tax filing scenario. For recurring property billing, you can track multi-month tenant charges locally without spreadsheets in a dedicated charge-and-receipt view.
This tool and guide provide operational formatting for accounts receivable summaries and do not constitute certified accounting, tax, or legal advice. Always reconcile statements against your bank feed and consult a qualified accountant regarding bad-debt write-offs or statutory retention rules.