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 80% of the matching, but the remaining 20% is where most errors hide.
Why reconcile so often
The bank reconciliation is the foundation of every other report you produce:
- VAT returns rely on reconciled income and expenses
- 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
| 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 via open banking integrations. This is the recommended approach for any business with more than a handful of monthly transactions.
The reconciliation routine
A weekly cycle works for most small businesses:
- 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 (use matching bank feed entries for tips)
- Investigate any unidentified payments through suspense
- Lock the period and run a bank reconciliation report
- Confirm the closing balance equals the bank statement
Common reconciliation breaks
| 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 |
For uncleared cheques, see our existing guide on unidentified payments and clearing entries .
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 the foreign exchange gains and losses account.
Software features that help
- 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
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. Pair this with our bank reconciliation principles page and the bank feeds setup walkthrough. The HMRC record-keeping guidance is a useful overview of the underlying obligation. See pricing for software with native UK bank feeds and rules.