Bank statements for Self Assessment and MTD: a working method

By Arron Child, reviewed by Arron Child. Updated 16 July 2026.

Every January, a wave of sole traders and their accountants reconstruct a year of income and expenses from bank statements. From April 2026 the pressure moved earlier in the year: Making Tax Digital for Income Tax began replacing the annual Self Assessment return with quarterly digital updates for sole traders and landlords over the qualifying income threshold, and quarterly updates mean statement data four times a year instead of once. This guide covers turning statements into usable figures for either regime, and the checks that keep those figures defensible.

What HMRC actually needs from your statements

HMRC does not want your bank statements attached to a return. It wants accurate totals, and it wants you to be able to evidence them if asked. Statements are the raw record behind the totals: income arriving, allowable expenses leaving. Your obligations are to keep the records (five years after the 31 January deadline for the self-employed), to report accurate figures, and, under MTD, to keep them digitally and file quarterly from software.

The workflow that holds up

  1. Get digital statements, not scans. Download the PDF (or better, CSV) from the bank itself; the download routes for each UK bank are collected in one guide. Photographed paper statements make every later step unreliable.
  2. Convert to a spreadsheet you can filter. A year of statements becomes a single sheet with dates, descriptions, and signed amounts. The converter does this for certified banks and proves the result reconciles; whatever tool you use, insist on that proof, because a silently missing March expense is a wrong tax bill.
  3. Verify before you categorise. Check opening balance plus credits minus debits equals closing balance for every statement period, or use the built-in checks here. Categorising an incomplete sheet wastes every hour you spend on it.
  4. Categorise income and allowable expenses. That part is judgement and belongs to you or your accountant; a converter that guesses categories for you is guessing about your tax.
  5. Keep the trail. Keep the original PDFs alongside the spreadsheet. Under MTD, the spreadsheet or software records are the digital records; the statements remain your evidence.

Common traps

  • Mixed accounts. Personal spending through the business account (or the reverse) means filtering line by line. A clean converted sheet makes the split visible; a hand-typed summary hides it.
  • The missing month. Twelve statements minus one is the classic January discovery. Reconciliation across periods catches it: last month's closing balance must equal this month's opening balance, which the balance checker verifies for free.
  • Duplicated rows from re-converted files. Converting overlapping date ranges twice and pasting both produces inflated income. Deduplicate on date plus amount plus description before totalling.
  • Trusting a percentage. Tools advertise "99.9% accuracy"; a year of statements can hold thousands of rows, and 0.1% of that is real money. Only arithmetic on your actual document, not a marketing average, tells you whether your conversion is complete.

Where this converter fits, honestly

ukbankconv turns certified UK bank statement PDFs into verified spreadsheets, in the browser, without uploading the document. It does not categorise expenses, calculate tax, or file anything, for Self Assessment or MTD; that is deliberate, and tools that do file (from accounting suites to MTD-specific products) sit downstream of clean data, not instead of it. Get the data provably right first; everything after that inherits its quality.

This guide describes record-keeping mechanics, not tax advice. Thresholds, dates, and rules for MTD for Income Tax are HMRC's and change; check gov.uk or your accountant for your own position. Checked 16 July 2026.