Bank Feed Reconciliation: A Practical Guide for UK Businesses
Bank feed reconciliation means checking that the transactions flowing into your accounting software from your bank match your own records, and that your closing balance agrees with the bank statement. The feed does the importing. You still have to confirm that every line is coded correctly, matched to the right invoice or bill, and counted once. This guide shows how to do that in QuickBooks, how to fix mismatches, and how often to do it.
TL;DR
A bank feed imports transactions automatically; reconciliation is the check that they agree with your records and the bank statement.
In QuickBooks, review each imported line, then Add, Match or Transfer it, and finish a reconciliation only when the difference is zero.
Most mismatches come from wrong opening balances, missing or duplicate transactions, and timing differences.
Limited companies must keep accounting records for at least six years, so a clean monthly routine pays for itself.
A weekly 15-minute review beats a year-end clear-up.
Table of Contents
What bank feed reconciliation actually is
Two things get confused here. A bank feed is a secure connection that pulls transactions from your business account into your software, which cuts manual data entry. QuickBooks describes bank feeds in exactly those terms.
Reconciliation is the control that sits on top. You compare the opening balance, each transaction and the closing balance in your books against the bank statement for the same dates. If they agree, your records are complete. If they do not, something is missing, duplicated or wrongly entered.
The feed makes the job faster, but it does not make it automatic. A feed can import a personal payment, a refund you have not recorded, or a transaction twice. Software cannot know your intent. You can.
Why it matters for a UK business
Three practical reasons:
Accurate profit and tax. If a cost never reaches your books, profit looks higher than it is and so does the tax calculated on it. The same logic applies when costs land in the wrong category, as this explanation of expense management versus payroll shows for a different country.
Legal record-keeping. A limited company must keep accounting records covering all money received and spent. GOV.UK sets out what those records include and how long to keep them: at least six years from the end of the financial year they relate to.
Spotting problems early. Duplicate payments, unfamiliar direct debits and bank charges you did not expect show up when you look line by line.
If you are preparing for digital tax reporting, tidy bank records matter even more. We cover the timeline in our piece on MTD for Income Tax quarterly submissions.
How to reconcile a bank feed in QuickBooks
The routine has two layers: reviewing the feed, then reconciling to the statement.
Step 1: Review imported transactions
Open Banking, select the right account and look at the imported lines. QuickBooks suggests an action for each one: Add, Match or Transfer. You can accept the suggestion if it is right, change it, or exclude a line that should not be part of the business finances, such as a personal purchase.
Before you accept anything, check four things:
Is this the correct bank account?
Is the payee and category right, not just plausible?
Is VAT treated correctly for this line?
Has this transaction already been entered manually?
Step 2: Match to invoices and bills
Where money in or out relates to something already recorded, match it rather than adding a new entry. QuickBooks shows possible matches, such as customer payments and supplier purchases. Select the correct one, search for another or several if a payment covers multiple invoices, adjust any small difference caused by a discount or fee, then click Match.
Adding instead of matching is the most common cause of double-counted income. If a customer payment is added as new income while the invoice is still open, you will overstate revenue and the invoice will look unpaid.
Step 3: Reconcile to the statement
Once the feed is clear, run the reconciliation. QuickBooks’ guidance is to compare the statement’s beginning balance and each transaction with what is in QuickBooks, and to finish only when the difference is zero. If you have missed periods, start with the oldest unreconciled statement and work forward.
A zero difference is the goal, not a number to force. Never add a plug entry to make it balance. Find the cause.
Why your balance does not match the statement
When the difference is not zero, the cause is almost always one of a short list.
Symptom | Likely cause | What to do |
Difference equals one round figure | A transaction missing or entered twice | Scan the period for that amount |
Difference from the very first reconciliation | Wrong or missing opening balance | Check the opening balance against the first statement |
Small difference, grows each month | Bank charges or interest not recorded | Add them in the software |
Bank shows less than books | Payments not yet cleared | Timing difference, expected |
Feed shows lines you do not recognise | Personal spend or fraud | Query with the bank or exclude |
QuickBooks lists incorrect or missing opening balances and missing or duplicate transactions as the common problems. The same page explains that a transaction reconciled by mistake can be undone from the Bank transactions page by toggling its tick-column status to remove the R mark.
Timing differences are normal. QuickBooks notes that uncleared cheques and deposits not yet processed by the bank should be accounted for during reconciliation, and that adjustments such as bank charges belong in the accounting software, not on the statement.
A worked example
Say your statement closes at £8,420.50 and QuickBooks shows £8,570.50. The difference is £150.00. You look for exactly £150: a supplier payment recorded in the books but not yet cleared would explain it as a timing item. If instead you find a £75.00 payment imported twice, that is the same £150 gap, and you delete the duplicate. Always check the whole list before deciding it is timing.
How often to reconcile
There is no single rule in law that says weekly or monthly. What matters is that your records are complete and kept for the required period. Our practical advice:
Weekly for businesses with daily card sales, multiple team cards or many suppliers.
Monthly at the very minimum, as soon as the statement closes, and before any VAT return.
Never leave it to year end. Twelve months of unmatched lines turn a quick job into a forensic one, and that costs more in accountant time.
Keep the statement PDF, any notes on queried items and a short list of adjustments you made. If HMRC or an auditor asks how a balance was reached, you can show the trail.
Our perspective
We see the same pattern with founders: the feed is switched on, the dashboard looks busy, and nobody has actually checked it. Then the VAT return or year-end arrives and the clean-up takes days.
Our view is that bank feed reconciliation should be treated as a habit, not a project. Set up your rules once, keep categories few and meaningful, and reconcile on a fixed day. Software handles the repetitive matching; a person with accounting judgement handles the exceptions. That blend of digital tools and traditional checking is how we work with clients, and it is what keeps year-end reporting and audit readiness checks quick rather than painful.
If you are moving between platforms, reconcile before and after the move. Our QuickBooks migration guide for UK small businesses and the piece on HMRC-ready accounting software setup explain why opening balances are where most errors begin.
— Shoaib
Getting help with your bookkeeping
If reconciliation keeps slipping down your to-do list, that is a sign to hand it over. We provide day-to-day bookkeeping, VAT filing, accounts preparation and year-end reporting for UK founders and small businesses, using modern digital tools alongside experienced accountants. Our flexible accounting packages are published at £99 to £199 per month, and you can see what is included on our accounting services page.
[
](www.keystonefa.co.uk)
If you also want to understand how reconciled records feed into tax, read our guides on the VAT registration threshold and the cash accounting VAT scheme.
FAQ
What does it mean to reconcile books?
It means checking that your accounting records agree with your bank account: the opening balance, each transaction and the closing balance. Differences are investigated and corrected, not ignored. The result is a set of books you can rely on for VAT, tax and year-end accounts.
Is a bank feed the same as bank reconciliation?
No. A bank feed imports transactions into your software. Reconciliation is the check that those transactions are complete, correctly coded and agree with the statement. You need both, and the feed does not replace the check.
What if my QuickBooks balance never matches the statement?
Start with the opening balance, then look for missing or duplicate transactions in the period, then for unrecorded bank charges. If a previous reconciliation was done wrongly, undo it and work forward from the oldest period. If you are stuck, an accountant can usually find the cause quickly.
How long should I keep reconciled records?
A limited company must keep accounting records for at least six years from the end of the financial year they relate to, according to GOV.UK. Sole traders and employers have their own periods, so check the official guidance for your structure.
Sources
Recommended