Notes from the ledger
Practical guides to bank statements, reconciliation and the bookkeeping around them, with free templates to download.
The best bank statement converters in 2026, compared
We compared the leading bank statement converters on the things that decide the job — accuracy verification, export formats, per-page price, and what happens to your files. Here's how they stack up.
- 14 Oct 2026 · 3 minHow to avoid double-counting credit card payments in bookkeeping
- 11 Oct 2026 · 3 minNew bookkeeping client checklist: bank statements and opening balances
- 10 Oct 2026 · 8 minHow to convert bank statements without a subscription
- 9 Oct 2026 · 3 minBAS preparation checklist: reconcile July–September bank transactions
Free templates
Spreadsheets and checklists to download, each with a guide to using it.
More from the blog
34 articlesHow to categorise bank transactions in Excel
Use a reviewed payee lookup, an exceptions queue and a category summary to organise converted bank transactions without changing the source evidence.
Schedule C expense spreadsheet: organise bank transactions for your accountant
A free workbook for grouping US business transactions, tracking receipts and preparing a 2025 records handover before the October extension deadline.
How to separate business and personal transactions in Excel
Sort a mixed bank account into business, personal, transfer and review rows without losing the statement balance or guessing tax deductibility.
Quarter-end bank reconciliation checklist for small businesses
Close July–September with an account inventory, statement checks, outstanding-item list and a clear handover to your bookkeeper.
How to combine multiple bank statements into one Excel file
Merge monthly statement PDFs into one spreadsheet, retain the source of every row, and check accounts, currencies and overlaps before importing.
Self Assessment records checklist 2025/26: bank statements and supporting documents
Gather the records for your 2025/26 UK return: account-by-account statements, income evidence, expense receipts and a clear list of missing documents.
Revolut, Wise and multi-currency statements: a bookkeeper's guide
One account, five currencies, a statement per balance, and every conversion showing up twice. How to set up the books for a multi-currency account, what the two legs of an exchange actually are, which rate to use when, and the traps that turn a simple transfer into phantom income.
Year-end bank reconciliation in TallyPrime before the audit deadline
The tax audit report falls due on 30 September and the auditor's first question is whether the bank reconciles. A year-end BRS routine for TallyPrime — statements in, unreconciled entries cleared, bank charges and interest booked, closing balance agreed to the bank — that takes an afternoon per account instead of a week.
The treasurer's guide: bookkeeping for clubs, charities and societies
You said yes at the AGM and inherited a shoebox, a spreadsheet and a bank account. A volunteer treasurer's system built on the bank statement — receipts and payments headings, restricted funds, Gift Aid, the thresholds that decide whether anyone has to examine the accounts, and the handover pack that makes the next treasurer's life easy.
Statements in, clean books out.
Convert a bank statement PDF to CSV, Excel, OFX or QFX, balance-checked against the statement's own totals. Your first one is free, no account needed.