Making Tax Digital for Income Tax (MTD for IT) is now live in the UK, requiring sole traders and landlords earning above £50,000 to keep digital records and submit quarterly updates to HMRC through compatible software. Bank statements sit at the heart of this process — every income and expense entry must trace back to a digital source record. If your clients are still handing you paper statements or unstructured PDFs, converting those documents into structured, software-ready formats is no longer optional. It is a compliance requirement.

What Is MTD for Income Tax and Who Does It Affect?

MTD for IT replaces the annual Self Assessment tax return for eligible taxpayers with a system of quarterly digital submissions, a year-end declaration, and ongoing digital record-keeping. HMRC introduced the mandate in phases:

• April 2026: Sole traders and landlords with gross income above £50,000 must comply
• April 2027: The threshold drops to £30,000
• April 2028: The threshold drops further to £20,000 (subject to final confirmation from HMRC)

These are not soft deadlines. HMRC has confirmed the April 2026 phase is live, and the first quarterly update for most affected taxpayers covers the period ending 5 July 2026. Penalties for non-compliance follow HMRC's points-based system, where each missed submission adds a penalty point and a £200 fine applies once the threshold is reached.

For accountants and bookkeepers managing multiple sole trader or landlord clients, this creates a real operational challenge. You need clean, categorised transaction data — not a stack of bank PDFs.

How Do Bank Statements Fit Into MTD Digital Record-Keeping?

HMRC's MTD for IT rules require taxpayers to record each transaction digitally at source. Under HMRC's MTD for Income Tax guidance, compatible software must capture the date, amount, and category of every business income and expense entry.

Bank statements provide the raw data for all of this. The problem is that most UK high street banks — Barclays, HSBC, Lloyds, NatWest, Santander — export statements in formats that do not slot cleanly into accounting software. A Barclays business account PDF, for example, uses a three-column layout with a running balance column that confuses most spreadsheet imports. NatWest OFX exports sometimes split payee names across two fields. These formatting quirks create manual reconciliation work that scales badly when you are managing 30 or 40 clients.

Converting those statements into clean CSV or correctly structured OFX files before importing them into Xero, QuickBooks, or FreeAgent removes that friction entirely. Each transaction arrives with the correct date, description, and debit or credit value — ready to categorise against the relevant income or expense class.

The convertbank-statement.com converter tool handles PDF, OFX, QIF, and QFX inputs from all major UK banks and outputs clean CSV, OFX, or QBO files matched to your target software's import requirements.

What Format Does HMRC Require for MTD Digital Records?

HMRC does not mandate a specific file format for digital records. What it requires is that records are kept in a form that compatible MTD software can read and submit. In practice, this means your data needs to live inside HMRC-recognised software — Xero, QuickBooks, Sage, FreeAgent, and others on HMRC's list of compatible MTD for IT products.

The practical implication for bank statement conversion is straightforward. You are not sending a bank statement to HMRC. You are using the transaction data from that statement to populate digital records inside compatible software, which then generates the quarterly submission. Your converted file is an intermediary step, not the submission itself.

This means accuracy during conversion is non-negotiable. A misread credit entry that becomes a debit, or a transaction date that shifts by one day due to a parsing error, could put a quarterly update out of balance with the client's actual bank position.

What to check in a converted bank statement before importing

• Opening and closing balances match the original PDF or paper statement exactly
• All transaction dates fall within the correct quarter (5 April to 5 July, 5 July to 5 October, 5 October to 5 January, 5 January to 5 April)
• Debits and credits are correctly signed — no reversed entries
• Payee descriptions are complete, not truncated or split across two rows
• Duplicate rows from statement overlap periods have been removed

How to Prepare Client Bank Statements for MTD Reporting

Here is a practical workflow for accountants and bookkeepers processing client statements ahead of each quarterly MTD submission.

Step 1: Collect statements for the full quarter Request digital exports directly from your client's online banking wherever possible. CSV exports from Monzo, Starling, and Tide are already well-structured. For traditional banks, PDF is often the only option for older periods.

Step 2: Convert PDFs to structured data Upload each PDF to a dedicated converter that recognises UK bank layouts. convertbank-statement.com identifies the bank format automatically and applies the correct column mapping before output. This saves significant time compared with manual CSV cleaning.

Step 3: Validate the output Cross-check the opening balance of the converted file against the previous quarter's closing balance. Run a simple sum of debits and credits to confirm the net movement matches the bank statement's balance change.

Step 4: Import into MTD-compatible software Use the software's bank import or bank feed function. In Xero, this is under Accounting > Bank Accounts > Import Statement. In QuickBooks, it is under Banking > Upload Transactions.

Step 5: Categorise and reconcile before submission Every transaction must be matched to an account code before the quarterly update is submitted. For sole trader clients, separate business income from personal deposits at this stage. For landlords, split rental income by property if they own multiple units.

Step 6: Submit the quarterly update The quarterly update goes to HMRC through the software's MTD submission function. It reports total income and total expenses by category. Your converted and reconciled bank data is the foundation for every figure.

UK Bank Statement Formats: What to Expect

Different banks produce very different export files. The table below shows what you are likely to encounter when converting statements from major UK banks for MTD purposes.

Bank	Common Export Formats	Known Issues for Conversion
Barclays	PDF, CSV, OFX	PDF uses 3-column layout; running balance in column 3 can interfere with debit/credit parsing
HSBC	PDF, CSV	CSV exports include header rows that need stripping; date format is DD/MM/YYYY
Lloyds	PDF, CSV, OFX	PDF statements merge some payee descriptions onto continuation lines
NatWest	PDF, OFX, QIF	OFX files sometimes split payee data across MEMO and NAME fields
Santander	PDF, CSV	CSV uses a single Amount column with negative values for debits
Starling	CSV, JSON	Clean structured exports; minimal conversion needed
Monzo Business	CSV	Excellent column labelling; imports directly into Xero with minimal adjustment
Metro Bank	PDF, CSV	PDF layout changes between statement versions; older statements require manual review

For banks that produce clean CSV exports — Starling, Monzo, Tide — conversion is mostly about reformatting column headers to match your target software. For PDF-heavy banks like Barclays and HSBC, automated conversion tools save the most time.

See the best bank statement converter comparison for 2026 for a detailed review of tools that handle UK bank formats.

Pricing and Scale: What Does This Cost in Practice?

For accountants managing multiple MTD clients, the volume of statements to convert increases significantly once quarterly reporting replaces an annual cycle. A practice with 40 sole trader clients moves from 40 annual statement packages to 160 quarterly ones.

Manual conversion at even 15 minutes per client per quarter adds up to 40 hours a year just in data preparation. At a billing rate of £60 per hour, that is £2,400 of unbillable admin time. Automated conversion at scale brings that to under an hour.

Review the convertbank-statement.com pricing plans for volume options suited to practices handling MTD client work at scale.

James Cooper is a chartered accountant with over 10 years of experience helping UK small businesses and sole traders manage their financial records and meet HMRC compliance requirements.

---

Frequently Asked Questions

Does MTD for Income Tax apply to me if I earn under £50,000?

Not yet. The current threshold for mandatory MTD for IT compliance is gross income above £50,000, which applies from April 2026. The threshold drops to £30,000 in April 2027 and is expected to fall to £20,000 in April 2028. Voluntary sign-up is available for those below the threshold who want to prepare early.

Can I still use spreadsheets for MTD digital records?

Spreadsheets are permitted under MTD for IT only if you use HMRC-approved bridging software to submit the data. A plain Excel file saved to your desktop does not meet the digital records requirement on its own. Most accountants find it simpler to import converted bank data directly into compatible software like Xero or QuickBooks.

What happens if a client misses a quarterly MTD submission?

HMRC operates a points-based penalty system for MTD for IT. Each missed quarterly submission adds one penalty point. Once a taxpayer reaches the threshold (four points for quarterly filers), a £200 fine applies. Points expire after 24 months of full compliance.

How do I convert a bank statement PDF to CSV for MTD purposes?

Upload the PDF to a dedicated UK bank statement converter such as the one at convertbank-statement.com. The tool identifies the bank format, extracts transaction rows, and outputs a clean CSV with separate columns for date, description, debit, credit, and balance. You can then import that CSV into Xero, QuickBooks, Sage, or FreeAgent.

Do bank feeds replace the need for statement conversion?

Bank feeds pull live transaction data directly into accounting software and remove much of the need for manual statement imports for current periods. However, bank feeds are not always available for older periods, business credit cards, or overseas accounts. Statement conversion remains necessary for historical data, feed gaps, and clients whose banks do not support direct feeds.

Are landlords with property income required to comply with MTD for IT?

Yes. Landlords with gross property income above £50,000 must comply with MTD for IT from April 2026. This includes rental income from residential and commercial property. Landlords with income from both a trade and property must combine both sources when calculating whether they meet the income threshold.

---

Last reviewed: 2026-04-13