Key takeaways
What this article covers, in order:
- The spreadsheet that worked until it didn't
- What a spreadsheet does well
- Where spreadsheets start to hurt
- Side by side
- What software actually costs (as of Oct 2026)
- So when should you switch?
A bank reconciliation spreadsheet works perfectly well if you have a few dozen transactions a month, one bank account, and the discipline to keep it tidy. Once you add more accounts, more people or more volume, the spreadsheet stops saving money and starts costing time and accuracy. This post walks through where that line sits, honestly, including what the main UK software options cost as of Oct 2026.
The spreadsheet that worked until it didn't
Dan runs a small IT support business in Reading. For three years his books lived in one Excel workbook: a tab per month, bank lines pasted in from the CSV download, a column for category, and a SUMIF at the bottom. It worked. He was proud of it.
Then he took on a second bank account for savings, a part-time admin started helping, and in Jul 2026 someone sorted the Jun 2026 tab by amount without selecting the whole range. The categories stayed put while the amounts moved. The totals still added up, so nobody noticed for six weeks.
That's the honest story of most spreadsheet bookkeeping. It doesn't fail loudly. It fails quietly, and the formulas keep giving you a confident-looking number.
What a spreadsheet does well
Let's be fair to Excel, because plenty of businesses are right to use it.
- It's free or nearly free. Most people already have it.
- You understand every cell. Nothing is hidden behind a screen you don't control.
- It's flexible. Any layout, any extra column, any report you can think of.
- It's fine at low volume. Twenty transactions a month on one account is easily manageable.
If that's you, and you reconcile every month against the statement closing balance, a spreadsheet is a perfectly respectable choice.
Where spreadsheets start to hurt
The problems aren't about Excel being "bad". They're about what bank reconciliation actually needs.
Matching. Reconciliation means pairing each bank line with a record in your books. In a spreadsheet, that's you, a highlighter colour and some VLOOKUPs. Duplicates and part payments break lookups easily.
Typed numbers. If anyone types an amount instead of pasting it, a transposed figure (£1,254.00 for £1,524.00) creates a £270.00 hole that can take an hour to find.
No locked periods. Anyone can change the Mar 2026 tab months later without anyone knowing. A reconciled month should stay reconciled.
Version sprawl. "Books_2026_FINAL_v3_Dan_edits.xlsx". Need we say more.
Invoices and bills live elsewhere. Matching a customer payment to an invoice means flicking between files, and your debtors list is only as current as the last time someone updated it.
Sharing with your accountant. You email a file, they adjust it, you're now working on different copies.
Side by side
| Task | Spreadsheet | Accounting software |
|---|---|---|
| Getting bank lines in | Download CSV, paste in | Bank feed or CSV import |
| Categorising | Typed or dropdown, by hand | Suggested categories you confirm |
| Matching payments to invoices | Manual lookups | Built-in matching against open invoices and bills |
| Spotting duplicates | By eye or formula | Usually flagged during review |
| Reconciliation report | You build it | Generated |
| Locking a finished month | Not really possible | Available in many products |
| Audit trail of changes | None, unless you build one | Varies by product and plan |
| Working with your accountant | Emailing files | Same books, separate logins |
| Cost | Usually already paid for | From £0 to a monthly fee |
What software actually costs (as of Oct 2026)
If cost is what's keeping you in Excel, here's what the main UK options list on their own pricing pages, checked in Oct 2026. Prices change, and introductory offers come and go, so always check the vendor's page before deciding.
| Product | Entry option | Listed price | Notes |
|---|---|---|---|
| HelloBooks | Free | £0, no card, no expiry | 1 live bank feed, 2 users, up to 200 transactions per year. Pro is £14.99/month |
| Xero | Ignite | £18/month excl. VAT after an intro offer | Includes reconciling transactions; Ignite lists 20 invoices and 10 bills |
| QuickBooks Online | Sole Trader Plus / Simple Start | £10/month and £16/month after an intro offer | Both list automated bank feeds and 1 user |
| Sage Accounting | Start | £20/month excl. VAT after an intro offer | 1 user; reconciling transactions listed |
| FreeAgent | Sole traders | £19/month after an intro offer | Free with a NatWest, RBS or Ulster Bank business current account, or a Mettle account with at least one transaction a month |
| Zoho Books | Free | £0 | 1 user plus an accountant; bank feed connections start on the Standard plan (£12/month billed monthly) |
Who each suits, broadly:
- Xero suits growing small businesses that work closely with an accountant and want room to move up through several plan tiers.
- QuickBooks Online suits businesses wanting a tiered path from a sole trader plan up to multi-user plans with more automation.
- Sage Accounting suits businesses that want accounting and payroll together, as Sage now includes payroll in its plans.
- FreeAgent suits sole traders, contractors and small limited companies, and is especially good value if you already bank with one of its partner banks.
- Zoho Books suits businesses that want a free plan for invoicing and can live without live bank feeds until they upgrade.
- HelloBooks suits small businesses that want a genuinely free plan with a live bank feed and reconciliation, and an inexpensive step up when they need more.
Sources, all checked Oct 2026: Xero UK pricing, QuickBooks UK pricing, Sage Accounting UK, FreeAgent pricing, Zoho Books UK pricing.
So when should you switch?
Use this as a gut check. If you tick three or more, a spreadsheet is probably costing you more than software would.
- [ ] More than 50 bank transactions a month
- [ ] More than one bank account, card or payment platform
- [ ] More than one person touching the books
- [ ] You regularly match payments to invoices or bills
- [ ] You've found a formula or sorting error in the last year
- [ ] Your accountant spends time "tidying up" your file each year
- [ ] You can't say, within a minute, who owes you money right now
If you tick none, stay with your spreadsheet and reconcile it monthly. Honestly. Software doesn't make bad habits good; it just makes good habits easier.
If you stay with a spreadsheet, do these things
- Paste bank lines from the CSV; never type amounts.
- Keep one tab per month and protect finished months.
- Put the statement closing balance at the top of every tab and a check cell that shows the difference.
- Keep one master file in one place, with dates in the file history rather than the filename.
- Reconcile monthly, not annually.
How HelloBooks helps
If you decide to move, HelloBooks Free costs £0 with no card and no expiry. You can connect one live bank feed through Open Banking (most UK banks and cards), or import CSV statements just like you do for your spreadsheet. Transactions land in a review list where you confirm or change categories. The reconcile screen lines the statement up against your ledger with an AI match suggestion on each line, showing a confidence score and why it chose that match, so you work through only the exceptions, and you can unmatch in one click.
When you're done, a reconciliation report (opening balance, cleared items, outstanding items, closing balance) exports as PDF or CSV, and reconciled periods can be locked, with any reopening logged. That's the bit a spreadsheet can't really give you. See bank reconciliation software and pricing.
FAQs
Is Excel bank reconciliation "proper" bookkeeping?
It can be. What matters is that every bank line is recorded and the balance is reconciled to the statement regularly. The tool matters less than the habit.
Can I import my spreadsheet history into software?
Usually, yes, through a CSV import of transactions or opening balances. Plan a clean cut-over date so you're not reconciling the same month in two places.
Will software get rid of all manual work?
No. Software suggests matches and categories; you still review them, especially for odd or one-off transactions. It removes the typing and lookups, not the thinking.
Are free plans really free?
Some are free with limits on users, transactions or bank feeds; others are only free for a trial or with a particular bank. Read the limits, not just the headline.
Should I ask my accountant before switching?
It's worth a quick chat. They may already work with one product and can help set up opening balances so your first reconciliation in the new system starts clean.
Spreadsheets aren't the enemy. Silent errors are, and they love a busy workbook.
Start free, no card needed. Try HelloBooks Free
