Preparing bank statements for a VAT return means converting your raw transaction data into a clean, structured format that reconciles with your VAT records before you submit to HMRC. Under Making Tax Digital for VAT, all VAT-registered businesses must keep digital records and submit returns through HMRC-approved software. That means a PDF bank statement sitting in your downloads folder is not enough. You need the data in a workable format, matched against your sales and purchase invoices, and ready to feed into accounting software like Xero, QuickBooks, or Sage.
Why Your Bank Statement Format Matters for VAT
A bank statement is not a VAT record on its own, but it is the backbone of your reconciliation process. HMRC expects your submitted figures to match the underlying transactions in your digital records. When they don't, you risk a compliance check.
Most UK banks still issue statements as PDFs. Barclays, HSBC, Lloyds, NatWest, and Santander all default to PDF format for downloaded statements, and most use a three-column layout showing the date, description, and a running balance alongside debit and credit columns. That layout looks readable to a human, but it's difficult to process in bulk. Pasting it into Excel manually takes time and introduces errors, especially when descriptions wrap across lines or when the bank uses non-standard date formats.
Converting that PDF into a clean CSV or OFX file is the first step. Once you have structured data, you can sort by transaction type, filter by date range, and match each line against your VAT records.
How Does Making Tax Digital Affect VAT Return Preparation?
Making Tax Digital for VAT (MTD for VAT) has applied to all VAT-registered businesses since April 2022, regardless of turnover. If you are VAT-registered in the UK and your taxable turnover exceeds the £90,000 threshold (as of April 2024), you must keep digital records and use compatible software to file. Businesses below that threshold that registered voluntarily are also within MTD.
HMRC's MTD rules do not require you to submit bank statements directly, but they do require a digital audit trail linking your source transactions to your VAT return figures. In practice, this means:
- Every sale and purchase that affects your VAT must be recorded digitally
- There must be no manual re-keying of totals between software systems
- Digital links must connect your records from the raw data all the way to the submitted return
A CSV converted from your bank statement can serve as part of that digital chain, provided it flows directly into your accounting software without manual intervention. Copying a figure from a PDF and typing it into a spreadsheet breaks the digital link and puts you outside MTD compliance.
You can check the current MTD for VAT rules on the HMRC Making Tax Digital guidance page.
What Format Should You Convert Bank Statements Into?
The right format depends on your accounting software and workflow. Here is how the main options compare:
| Format | Best for | Compatible with | Notes |
|---|---|---|---|
| CSV | Manual review, Excel, bulk import | All major software | Most flexible; requires column mapping |
| OFX | Direct bank feeds, automated import | Xero, QuickBooks, Sage | Preserves transaction IDs; fewer import errors |
| QBO | QuickBooks-specific imports | QuickBooks Online/Desktop | Proprietary format; not universal |
| MT940 | Business banking, treasury | Sage 200, enterprise tools | Common in larger business accounts |
| QIF | Legacy software | Older Sage/Quicken versions | Largely superseded by OFX |
For most UK small businesses and sole traders filing VAT returns, CSV is the most practical starting point. It works with every major accounting package, you can open it in Excel to review before importing, and it maps cleanly to the date, description, amount, and balance columns that most banks provide.
If you are processing multiple accounts or need to automate the workflow, OFX is worth considering. It carries more metadata per transaction and reduces the chance of duplicate imports.
You can convert PDF statements from any UK bank into CSV or OFX format using the bank statement converter tool at convertbank-statement.com.
How Do You Reconcile Bank Statement Data with Your VAT Records?
Reconciliation is where most errors creep in. Here is a step-by-step process that works for a standard quarterly VAT period:
Step 1: Define your date range Your VAT quarter has a fixed start and end date. If your period ends 31 March 2026, you need every transaction from 1 January 2026 to 31 March 2026. Download statements for all business accounts covering that exact range. If your bank issues monthly statements, you will need three PDFs.
Step 2: Convert to CSV Convert each PDF into a single CSV file. Check that dates are in a consistent format (DD/MM/YYYY is standard for UK banks) and that credits and debits are in separate columns rather than signed amounts in one column. Some banks use a single amount column with a CR/DR indicator, which needs separating before import.
Step 3: Remove non-VAT transactions Not every bank transaction affects your VAT return. Payroll transfers, loan repayments, internal transfers between your own accounts, and PAYE payments to HMRC do not carry VAT. Filter these out or flag them in your CSV before importing. Leaving them in creates reconciling differences that take time to unpick.
Step 4: Match to invoices Every payment in your bank statement that relates to a VATable supply should match an invoice in your accounting software. This is where a structured CSV earns its value: you can sort by amount, search by supplier name, and spot anything that has no corresponding invoice.
Step 5: Check VAT treatment Confirm the VAT rate applied to each transaction. Standard rate (20%), reduced rate (5%), zero-rated, and exempt supplies all need correct treatment. A common error is applying 20% VAT to zero-rated purchases such as most food items, children's clothing, or certain financial services. HMRC's VAT rates guidance lists which supplies fall into each category.
Step 6: Reconcile totals Once your transactions are in your accounting software, run a VAT reconciliation report. The total output tax, input tax, and net VAT payable should match what your software is preparing to submit. If the figures don't match, work backwards line by line rather than adjusting the totals manually.
Step 7: File through MTD-compatible software Submit your return directly from your accounting software. Do not re-key the figures into HMRC's portal manually. That would break your digital link under MTD rules.
Common Mistakes That Cause VAT Return Errors
These are the issues that come up most often when bank statement data feeds into a VAT return:
- Duplicate transactions: If you import the same statement twice, or if a bank feed and a manual CSV upload overlap, you will overstate your figures. Always check your accounting software's transaction list before importing a converted statement.
- Wrong currency handling: If you make purchases in foreign currencies, the GBP equivalent on the settlement date is what matters for VAT purposes, not the invoice amount.
- Missing statements: A single missing month within a quarter leaves a gap in your records. HMRC expects a complete, unbroken digital record.
- Personal and business accounts mixed: If any business transactions appear on a personal account (or vice versa), you need to identify and account for them separately. Using a personal account for business transactions also raises questions in a VAT inspection.
- PDF conversion errors: Some bank PDFs have scanned pages rather than selectable text. A basic PDF converter will produce garbled output from a scanned document. A tool with OCR (Optical Character Recognition) capability handles these correctly.
The bank statement converter at convertbank-statement.com uses OCR for scanned PDFs, so the output is accurate even when the original document is an image rather than a text-based PDF.
Practical Tools and Costs
You have a few options for converting bank statements before your VAT prep:
- Manual copy and paste: Free, but slow and error-prone. Not suitable for businesses processing more than a handful of transactions per quarter.
- Your bank's export function: Many UK banks let you export transactions as CSV directly from online banking. This works well for recent periods but is not always available for older statements.
- Dedicated converter tools: Purpose-built tools handle the PDF-to-CSV conversion reliably, including edge cases like scanned documents, multi-page statements, and unusual column layouts. See convertbank-statement.com/pricing for current options.
- Accounting software bank feeds: Xero, QuickBooks, and Sage all offer automated bank feeds via Open Banking. These are the most efficient option if you are starting from scratch, but they do not help if you are catching up on past periods or working with statements from closed accounts.
For a full comparison of converter tools available in the UK, the best bank statement converter guide for 2026 covers the main options with pros and cons.
The Institute of Chartered Accountants in England and Wales (ICAEW) also publishes practical guidance on digital record-keeping for MTD, available via icaew.com.
About the author: James Cooper is a chartered accountant with over 10 years of experience helping UK businesses manage their financial records and meet HMRC compliance requirements.
Frequently Asked Questions
Do I need to submit bank statements to HMRC with my VAT return? No. HMRC does not require you to submit bank statements as part of your VAT return. You submit your VAT figures through MTD-compatible software. However, you must keep digital records of the underlying transactions for at least six years, and HMRC can request them during a compliance check.
What happens if my bank statement figures don't match my VAT return? A discrepancy between your bank data and your submitted VAT return is a common trigger for an HMRC VAT inspection. If the figures don't reconcile, you should correct the return before filing using a VAT652 form if the error is under £10,000, or contact HMRC directly for larger corrections.
Can I use a personal bank account for business VAT records? You can, but HMRC strongly advises against it. Mixing personal and business transactions makes reconciliation harder and raises questions during inspections. Most accountants recommend a dedicated business account for any VAT-registered business.
How far back can HMRC request bank statement records? HMRC can typically inspect VAT records going back four years for routine checks, or up to 20 years in cases involving deliberate non-compliance. You are legally required to keep VAT records for at least six years.
Which UK banks allow direct CSV export for VAT reconciliation? Barclays, HSBC, Lloyds, NatWest, and Santander all allow CSV or OFX export from their online banking portals for recent transactions, usually covering the past 12 to 24 months. For older periods or closed accounts, you will need to work from PDF statements and convert them.
What is the penalty for incorrect VAT returns? HMRC charges penalties based on the size of the error and whether it was careless or deliberate. Careless errors can attract penalties of up to 30% of the unpaid tax. Deliberate errors can reach 70%, or 100% in cases involving concealment. Accurate reconciliation using your bank statement data is one of the simplest ways to avoid these penalties.
Last reviewed: 2026-03-15
