VAT Reconciliation: Step-by-Step Guide from Bank Statements to VAT Return
VAT reconciliation is the process of checking that the VAT you’ve recorded in your books matches what actually went through the bank - and that both agree with what you’re about to tell HMRC. Get it wrong and the penalties start at 15% of the underpaid tax.
Why VAT reconciliation matters
Every VAT-registered business in the UK must submit a VAT return to HMRC, typically every quarter. The return declares the output VAT charged on sales, the input VAT paid on purchases, and the net amount owed to (or reclaimable from) HMRC. Under Making Tax Digital, these figures must come from digital records - which in practice means your accounting software.
The problem is that accounting software can only report what you’ve told it. If a transaction is coded to the wrong VAT rate, the VAT return is wrong. If a purchase is classified as exempt when it should be zero-rated, the input VAT claim is wrong. If an overseas service isn’t reverse-charged, boxes 1, 4, 6, and 7 are all wrong simultaneously.
HMRC Penalties for Incorrect VAT Returns
Under HMRC’s points-based penalty system (introduced January 2023), late submissions accumulate penalty points. Once you hit the threshold - four points for quarterly filers - each subsequent late return incurs a £200 penalty. For errors on returns, the penalty depends on the behaviour:
- Careless errors: 15–30% of the underpaid tax
- Deliberate errors: 20–70% of the underpaid tax
- Deliberate and concealed: 30–100% of the underpaid tax
The distinction between “careless” and “reasonable care” often comes down to whether you had a process for checking the return before submission. VAT reconciliation is that process.
Beyond penalties, incorrect VAT returns create a cascade of problems. Overstating input VAT means you’re reclaiming money you’re not entitled to - HMRC will want it back, with interest. Understating output VAT means you owe more than you’ve paid. And inconsistencies between your VAT return and your accounts trigger the kind of scrutiny that leads to enquiries into everything else.
Understanding VAT classifications
Before you can reconcile VAT, you need to understand the five VAT treatments that apply to transactions in the UK. Every single line on your bank statement falls into one of these categories - no exceptions.
Standard Rate (20%)
- Most goods and services
- Office supplies, software subscriptions
- Professional services (accountancy, legal)
- Advertising and marketing
- Vehicle repairs and maintenance
- Restaurant meals, hotel accommodation
Reduced Rate (5%)
- Domestic gas and electricity
- Child car seats
- Sanitary products
- Energy-saving materials (installation)
- Smoking cessation products
- Mobility aids for the elderly
Zero-Rated (0%)
- Most food and drink (not catering)
- Books, newspapers, magazines
- Children’s clothing and shoes
- Public transport fares
- Prescription medicines
- Exports of goods to non-UK countries
Exempt
- Insurance premiums
- Financial services, bank charges
- Education and training (by eligible bodies)
- Health services (NHS and registered practitioners)
- Postal services (Royal Mail universal service)
- Betting, gaming, and lottery
Outside Scope: The Fifth Category
Some transactions on your bank statement are completely outside the scope of VAT and don’t appear on the VAT return at all. These include wages and salaries, PAYE and NIC payments, dividend payments, bank transfers between your own accounts, loan repayments (capital element), director’s loan movements, and corporation tax payments. These are real transactions that affect the bank balance but have no VAT implication whatsoever. They must be excluded from boxes 6 and 7 of the return.
The critical distinction that trips people up is between zero-rated and exempt. They both have an effective VAT rate of 0%, but they are fundamentally different in how they affect your VAT return. Zero-rated supplies are “taxable supplies” - they appear in Box 6 (net value of sales) and you can reclaim input VAT on costs related to making them. Exempt supplies are not taxable supplies - they appear in Box 6 only for information, and input VAT on costs solely related to exempt supplies cannot be reclaimed. For partially exempt businesses, getting this wrong distorts the partial exemption calculation and can mean over- or under-claiming thousands of pounds of input VAT.
Worked example: bank statement to VAT return
Let’s work through a realistic month for a small marketing consultancy. The business is VAT-registered on the standard scheme, files quarterly returns, and uses the accrual basis. Here is January’s bank statement:
A few things to note in this example. The salary payment on 25 January is outside the scope of VAT entirely - it does not appear anywhere on the VAT return. The Mailchimp subscription is a service purchased from a US supplier, so the reverse charge applies: the business must account for both output VAT (Box 1) and input VAT (Box 4) on this purchase. The train tickets are zero-rated (public transport), not exempt. And the insurance premium and bank charges are exempt - not zero-rated, not “no VAT.”
Now let’s build the VAT return from these figures. In practice, this would be a full quarter (three months), but the principle is identical - you’re totalling the same categories across more transactions.
VAT Return Summary (January - one month shown)
The Reverse Charge in Practice
Notice how the Mailchimp reverse charge creates a £6.00 entry in both Box 1 (output VAT) and Box 4 (input VAT). The net effect on Box 5 is zero - it washes through. But you must still record it. If you simply code Mailchimp as “No VAT” and ignore the reverse charge, boxes 1, 2, 4, 7, and 9 are all understated. HMRC can and does check that reverse charge entries are present, even when the net VAT effect is nil.
The salary (£2,400) is excluded from every box. It’s outside the scope of VAT. The insurance and bank charges are exempt - they appear in Box 7 (net purchases) but contribute nothing to Box 4 (reclaimable VAT) because there is no VAT to reclaim on exempt purchases.
Common VAT reconciliation mistakes
After working with hundreds of bank statements across our platform, we see the same classification errors appearing repeatedly. These are the mistakes that cause VAT returns to be wrong - and they’re all avoidable.
1. Confusing exempt with zero-rated
This is the single most common VAT coding error. Bank charges are exempt, not zero-rated. Insurance premiums are exempt, not zero-rated. Coding them as zero-rated inflates Box 6 (for sales) or overstates the denominator in partial exemption calculations (for purchases). It also sends incorrect data to HMRC. They look the same on the face of the return - both have a VAT amount of zero - but they are categorically different in terms of VAT recovery rights and return calculations.
2. Forgetting reverse charge on overseas services
Any service purchased from an overseas supplier - a US SaaS subscription, a European freelancer, an international cloud hosting provider - requires the UK business to self-assess VAT under the reverse charge mechanism. This is not optional. Yet it is routinely ignored, especially for smaller subscriptions. Mailchimp, Zoom, Slack, AWS, Canva, Notion, GitHub - if the supplier is not UK VAT-registered, you need to reverse charge. The fact that no VAT appears on the invoice is precisely the point: you account for it, not them.
3. Not separating VAT on mixed purchases
A single Tesco receipt might contain biscuits (zero-rated), kitchen cleaner (standard-rated), and paracetamol (zero-rated). An Amazon order might include a book (zero-rated), a USB cable (standard-rated), and batteries (standard-rated). Coding the entire transaction to one VAT rate is wrong regardless of which rate you choose.
Solution: Split the transaction. Most accounting software supports multi-line entries with different VAT rates on each line. Yes, it takes longer. But the alternative is systematically over-claiming or under-claiming input VAT across every mixed purchase, which adds up to a material error over a full year.
4. Treating bank charges as zero-rated or no-VAT
Financial services - including bank charges, merchant processing fees, card terminal charges, and credit card interest - are VAT exempt. This means they appear in Box 7 (net purchases) but generate no reclaimable VAT in Box 4. Coding them as “No VAT” or “Outside Scope” excludes them from Box 7 entirely, understating your reported purchases. Coding them as “Zero Rated” is also wrong, for the reasons described above.
5. Including outside-scope items in the VAT return
Wages, dividends, loan capital repayments, transfers between the business’s own bank accounts, corporation tax payments, and director’s loan movements are all outside the scope of VAT. They must not appear in any box on the VAT return. Including wages in Box 7, for example, massively inflates the reported value of purchases and will trigger HMRC queries.
Step-by-step reconciliation process
Once you understand the classifications, the actual reconciliation process is methodical. Here is how to check your VAT return against your bank statements before submission.
Export your bank statement for the VAT period
Download a CSV or PDF statement covering the exact dates of your VAT quarter. Every transaction that clears the bank during this period needs to be accounted for. If you use the cash accounting scheme, this is straightforward - only transactions that actually hit the bank count. Under the standard (accrual) scheme, you’re reconciling invoices by their issue date, not payment date, which adds complexity.
Classify every transaction by VAT rate
Go through each line and assign the correct VAT treatment: standard (20%), reduced (5%), zero-rated (0%), exempt, or outside scope. For each taxable transaction, calculate the net amount and the VAT. For gross amounts, the formula is: VAT = Gross × (Rate ÷ (100 + Rate)). So for a £120 standard-rated purchase: VAT = 120 × (20/120) = £20.00, net = £100.00.
Total each category separately
Add up all output VAT (from sales), all input VAT (from purchases), all net sales values, and all net purchase values. Keep exempt and zero-rated totals separate - they both show in Box 6/7 but have different VAT recovery implications. Keep outside-scope items completely separate; they don’t appear on the return at all.
Compare against your software’s VAT report
Run the VAT return report in Xero, QuickBooks, Sage, or whatever platform you use. Compare your independently calculated figures for each box against the software’s figures. They should match to within a pound or two (rounding differences are normal). If Box 1 or Box 4 differs by more than a few pounds, there is a classification error somewhere in the books.
Investigate discrepancies
Common causes of differences: transactions coded to the wrong VAT rate, missing transactions (in the bank but not in the books), duplicated entries, partial exemption adjustments not applied, and reverse charge entries missing. Pull the VAT detail report (most platforms offer this) and scan for obviously wrong codes - a £3,000 insurance premium coded at 20%, a £15 bank charge coded as zero-rated, a US subscription with no reverse charge entry.
Correct and recheck before submitting
Fix any errors, re-run the VAT report, and compare again. Only submit the return when your independent reconciliation matches the software figures. Save your working papers - if HMRC queries the return, you’ll need to demonstrate the checking process you followed. This is what “reasonable care” looks like in practice, and it’s the difference between a careless error penalty and no penalty at all.
Automating VAT classification
The reconciliation process described above works. It is also, for any business with more than a handful of transactions per month, extremely time-consuming. Classifying 200 transactions by hand, calculating the VAT on each, cross-referencing against the software - this is hours of work per quarter for a single client. For a bookkeeper managing 20 or 30 clients, it’s an entire working week every quarter spent on nothing but VAT checking.
The bottleneck is the classification step. Knowing that Adobe Creative Cloud is standard-rated at 20%, that British Gas energy is reduced-rated at 5%, that train tickets are zero-rated, and that insurance is exempt - this is pattern recognition. It’s the same classification logic applied to the same types of merchants, quarter after quarter.
How CodeIQ Handles VAT Classification
Our team built CodeIQ specifically to automate this. When a bank statement is uploaded, the VAT classification engine analyses each transaction through multiple layers:
- Merchant pattern recognition: The universal pattern database knows that “BRITISH GAS” is 5% reduced rate, “HISCOX” is exempt, and “ADOBE” is 20% standard. These patterns are crowd-sourced and continually refined across thousands of transactions.
- Account-based classification: The nominal account itself carries VAT information. Insurance expense accounts default to exempt. Bank charges default to exempt. Travel defaults to a mix of zero-rated and standard depending on the type.
- Platform-specific VAT code mapping: CodeIQ doesn’t just classify the VAT rate - it maps to the exact VAT code your platform expects. Xero uses INPUT2, OUTPUT2, RRINPUT. QuickBooks uses its own tax codes. Sage uses T0, T1, T2, T5, T9. Pandle uses NV, ST, RR, EX. The classification is universal; the output is platform-specific.
- Learning from corrections: If you override a VAT classification, CodeIQ remembers. The next time that merchant appears, it uses your correction. Over time, the classification accuracy converges toward your specific preferences and edge cases.
The result is that the classification step - the part that takes hours manually - happens in seconds. You still review the output before posting. But reviewing 200 pre-classified transactions is fundamentally different from classifying 200 blank ones.
The VAT audit view in CodeIQ shows every transaction with its assigned VAT code, the confidence score, and the reasoning behind the classification. Low-confidence items are flagged for human review. Transactions where the VAT rate might be ambiguous - a purchase that could be zero-rated or standard-rated depending on the exact product - are highlighted rather than silently classified. The aim is not to replace human judgement, but to apply it where it actually matters rather than on the 90% of transactions where the answer is obvious.
For the reconciliation itself, once every transaction has the correct VAT classification, the Box 1–9 figures follow automatically. The numbers in your accounting software will match because the underlying classifications are right. That quarterly VAT reconciliation exercise becomes a five-minute sanity check instead of a half-day deep dive.
Frequently Asked Questions
How do I reconcile VAT from my bank statements?
To reconcile VAT from bank statements, classify each transaction by VAT rate (standard 20%, reduced 5%, zero-rated, exempt, or outside scope), calculate the net amount and VAT for each, then total these into the nine boxes of your VAT return. Compare your calculated figures against your accounting software’s VAT report and investigate any differences before submitting.
What is the best software for automatic VAT classification?
CodeIQ by The IQ Suite automatically classifies VAT on bank transactions using a multi-layer intelligence pipeline that analyses transaction descriptions, amounts, and merchant categories. It handles standard rate, reduced rate, exempt, zero-rated, and reverse charge classifications, then maps them to the correct platform-specific VAT codes for Xero, QuickBooks, Sage, and Pandle.
How do I check my VAT return is correct before submitting?
Run a VAT reconciliation by comparing your VAT return figures against your bank statements and purchase invoices. Check that Box 1 (output VAT) matches the VAT on your sales invoices, Box 4 (input VAT) matches the VAT on your purchase invoices and expenses, and Box 6 (net sales) and Box 7 (net purchases) agree with your profit and loss. Investigate any differences greater than a few pounds before submitting.
Can AI automatically classify VAT on bank transactions?
Yes. AI-powered tools like CodeIQ analyse transaction descriptions, merchant categories, and historical patterns to automatically classify VAT rates on bank transactions. The system distinguishes between standard-rated, reduced-rated, zero-rated, exempt, and outside-scope transactions, and handles edge cases like reverse charge on overseas services and mixed-rate purchases.
Ready to Automate VAT Classification?
CodeIQ classifies VAT on every transaction automatically - standard, reduced, exempt, zero-rated, reverse charge. Platform-specific codes for Xero, QuickBooks, Sage, and Pandle. Review in minutes, not hours.
Try CodeIQ Free