Bank Statement Conversion for Small Business Bookkeeping
A practical monthly routine for turning business bank statements into books, and the checks that keep it honest.
For a small business without a bookkeeper, the monthly routine matters more than the tool. Here is one that holds up.
The monthly routine
- Download the statement on the first working day of the month Making it a fixed date stops it slipping.
- Convert and check it reconciles Before doing anything else with it.
- Match credits against invoices raised Using the reference column. Unmatched credits need explaining.
- Match debits against bills received Anything unmatched is either a missing bill or a personal transaction.
- Categorise the remainder A lookup table handles recurring spend; only the long tail needs judgement.
- File the PDF and the export together Named by period, in one place.
The unmatched rows are the point
It is tempting to treat categorisation as the work and matching as a formality. It is the other way round.
An unmatched credit is unbilled revenue, a duplicate payment, or money that is not yours. An unmatched debit is a bill you did not record, a subscription you forgot about, or a personal expense in the business account. All six are worth finding, and none of them show up in a categorised summary.
Why monthly beats annually
The same work costs far more in January than in the month it happened. A £400 credit you cannot identify is answerable in March and guesswork in January.
The conversion step is identical either way. The difference is entirely in how much you remember.
A minimal spreadsheet setup
If you are running this without accounting software, a workable structure is three sheets in one workbook:
| Sheet | Contains |
|---|---|
| Transactions | Every converted row, stacked month after month, with added category and matched-invoice columns |
| Lookup | Merchant fragments and their categories — built once, reused monthly |
| Summary | Pivots: monthly in and out, spend by category, unmatched rows |
That handles a small business perfectly adequately. The point at which software earns its cost is usually VAT, payroll, or needing more than one person in the books.
The audit trail
Whatever you use, keep the source PDFs. The spreadsheet is derived data — if a figure is ever queried by a tax authority or an accountant, the statement is what answers the question and the spreadsheet is not.
Frequently asked questions
Do I need accounting software?
For a simple business, a spreadsheet with a clear routine is workable. Software helps most with VAT, payroll and several people working in the same books.
When is accounting software worth it over a spreadsheet?
Usually at the point you need VAT returns, payroll, or more than one person working in the books. Below that a disciplined spreadsheet is adequate.
How long should I keep records?
Typically five to seven years depending on jurisdiction. Keep the PDFs, not just the spreadsheets — they are the source documents.
Related posts
- Bank Statement Conversion for Accountants and Bookkeepers
- Bank Statement Conversion for Freelancers and Contractors
- Bank Statement Conversion for Landlords
Convert a statement now
Bank Statement PDF to Excel, or see every format. More in the guides.