Bank reconciliation in UK accounting software
A practical guide to bank reconciliation in UK accounting software, from bank feed setup to investigating breaks.
Bank reconciliation is the routine of agreeing what your accounting software says you have to what your bank statement actually shows. Done weekly it takes minutes; left until year end it can swallow a working week. Modern UK accounting software automates around 80% of the matching, but the remaining 20% is where most errors hide. This guide sits alongside the rest of our bookkeeping guides and explains how to keep your bank ledger clean, accurate and audit-ready.
Why reconcile so often
The bank reconciliation is the foundation of every other report you produce. Skip it and every downstream figure inherits the error:
- VAT returns rely on reconciled income and expenses, so accurate VAT bookkeeping depends on a reconciled bank account
- Management accounts are only as good as the bank ledger they sit on
- HMRC enquiries start with bank statements and trace into the ledger
- Making Tax Digital audits expect a digital link from bank to return
- A clean bank ledger lets you spot fraud or duplicate payments quickly
Bank feeds vs CSV import
The biggest single time-saver is getting transactions into the software automatically. Bank feeds pull each transaction in daily, so reconciliation becomes a matter of confirming matches rather than typing entries.
| Method | Pros | Cons |
|---|---|---|
| Open Banking feed | Daily, secure, no manual download | Re-authentication every 90 days |
| Yodlee or screen-scraping feed | Wide bank coverage | Less reliable, occasional gaps |
| CSV import | Universal fallback | Manual, error-prone for date formats |
| Manual entry | Total control | Only viable for very low volume |
Most UK banks now support PSD2-regulated Open Banking feeds. This is the recommended approach for any business with more than a handful of monthly transactions. For a fuller walkthrough of setting these up, see our guide to bank feeds in accounting software.
The reconciliation routine
A weekly cycle works for most small businesses and keeps the workload to a few minutes at a time:
- Confirm the bank feed has imported up to yesterday
- Run the auto-match function in your software
- Review and approve suggested matches
- Categorise unmatched receipts against the correct income or expense account
- Investigate any unidentified payments through a suspense account
- Lock the period and run a bank reconciliation report
- Confirm the closing balance equals the bank statement
Categorising as you go also feeds your expense tracking, so allowable deductions are captured the moment the payment clears rather than reconstructed at year end.
Common reconciliation breaks
When the closing balance in your software does not match the statement, the difference is a break. Most fall into a small number of predictable categories:
| Break | Likely cause | Fix |
|---|---|---|
| Statement higher than ledger | Missed customer receipt | Post invoice receipt |
| Ledger higher than statement | Cheque issued but not yet cleared | Leave on the unreconciled list |
| Single transaction missing | Bank feed gap | Manual entry or CSV top-up |
| Round-sum difference | Currency translation on FX account | Post FX gain/loss |
| Repeated small differences | Bank charges not posted | Set up a recurring journal |
| Stale uncleared items | Cheques older than 6 months | Write back to suspense |
The golden rule is to investigate, never override. Forcing a reconciliation to balance hides the underlying error and corrupts every report built on top of it.
Multi-currency considerations
If you hold a foreign currency bank account, you reconcile in the foreign currency first, then revalue at month end using the closing rate. The revaluation gain or loss posts to a foreign exchange gains and losses account. Holding the source currency separately keeps the underlying reconciliation clean and isolates exchange movements as a distinct, explainable figure.
Software features that help
The right software turns reconciliation from a chore into a quick weekly check:
- Rules engine that auto-categorises recurring counterparties
- Receipt-to-bank matching from photos uploaded via mobile app
- Split-transaction support for combined customer payments
- Built-in reconciliation report with timestamp and signoff
- Multi-bank consolidation in a single dashboard
- Audit trail showing who approved each match
Pairing receipt capture with reconciliation means the evidence is attached at the moment of matching, which dovetails with good receipt management and keeps you ready for the HMRC retention rules covered in our guide on how long to keep accounting records.
Wrap-up
Reconciliation is one of those tasks where habit beats skill. Set the routine, lock the period when complete, and treat any break as a reason to investigate rather than override. The HMRC record-keeping guidance is a useful overview of the underlying obligation. Explore the wider accounting guides for related topics, and see pricing for software with native UK bank feeds and rules.