Why statements drive your Self Assessment
If you're a sole trader, landlord or have untaxed income, your Self Assessment income and expense figures come straight from money that moved through your accounts. HMRC doesn't ask you to send the statements, but it expects you to keep them and to be able to back up every figure — so your bank statements are the foundation of the whole return. The catch is the same everywhere: a PDF can't be totalled, sorted or filtered.
Converting a year of statements into a spreadsheet lets you total your turnover, tot up allowable expenses by category, split business from personal spending, and produce the income-and-expense summary that fills in the self-employment pages. Start with bank statement to Excel, or export to CSV for your bookkeeping app.
Beating the 31 January deadline
Don't leave it to January
Convert each quarter as you go, or the whole year in one sitting — either way it's minutes, not a weekend of typing.
Every account, all year
Business and personal accounts you used for the trade, plus any cards — 12 months of PDFs from each (6 April–5 April).
Allowable vs disallowable
Tag each expense so only allowable costs roll into the return; keep the rest visible for your records.
Records you can defend
Keep the reconciled workbook; HMRC can ask you to substantiate figures, so a traceable file matters.
How to prepare your statements step by step
Download the tax year
Pull every statement for the 6 April–5 April year as PDFs from each bank and card. Photos and scans are fine — the scanned statement converter reads them with OCR.
Convert to clean rows
Run them through the bank statement converter — every transaction becomes a structured row with date, description and signed amount, with no column mapping.
Merge the year
Use Smart Merge to combine up to 100 statements into one workbook so the whole year totals together.
Split business and personal
Tag each row; for mixed accounts, mark which transactions relate to the trade so only those count. See how to categorize bank transactions.
Total and file
Total turnover and each expense category, reconcile each account, and read the figures straight into the self-employment pages — or hand the workbook to your accountant.
Claiming allowable expenses correctly
The expenses that reduce your tax bill are sitting in your statements — you just need them categorised and totalled. With your year in a spreadsheet you can filter by description and sum each allowable category: office costs, travel, stock and materials, professional fees, bank and finance charges, and a fair business share of any mixed costs. The full method is in how to prepare bank statements for taxes.
The structured data also feeds the tools you already use: export to Excel, import into Xero (popular with UK accountants), convert to QBO for QuickBooks, or process card spend with the credit card statement converter. For UK banks specifically, see converters for HSBC, Lloyds, NatWest and more.
| Self-employment figure | Where it comes from | How to total it |
|---|---|---|
| Turnover / income | Customer payments and deposits | Sum incoming rows, excluding transfers and personal money |
| Office & admin costs | Software, stationery, phone, postage | Filter description, sum outgoing rows |
| Travel & motor | Fuel, train, parking, mileage-related | Filter and total; keep receipts as backup |
| Stock & materials | Supplier purchases | Filter by supplier, sum |
| Bank & finance charges | Account, card and interest fees | Filter fee rows, sum |
| Business use of mixed costs | Part-business expenses | Apportion a fair business %, total that share |
Keeping HMRC-ready records (and staying private)
HMRC asks you to keep your business records for at least five years after the 31 January submission deadline. A reconciled, categorised workbook is exactly that record — and because it keeps every original transaction line, each total traces straight back to the transactions behind it. FlowParse balance-validates each statement and flags low-confidence fields and duplicates in an editable review so your figures hold up.
Your statements are sensitive, so privacy matters: uploads run over TLS on EU-hosted infrastructure, the original PDF is deleted immediately after processing, and your documents are never used to train AI models. If an accountant files for you, hand them the reconciled workbook — the summary an accountant wants — and they'll work from clean data. Accountants doing many returns should see the converter for tax preparers.
Working out turnover without counting your own money twice
On the self-employment pages, turnover is your total business income before expenses — and the most common mistake is inflating it by counting money that isn't trade income. In a PDF every credit looks identical, but a transfer from your savings, a refund, a personal top-up, a Bounce Back or other loan, or money shuffled between your own accounts is not turnover. Sum every incoming line and you'll declare more than you earned and pay tax you don't owe. Structured rows let you read the description on each credit and exclude the ones that are merely movement.
The dependable approach is to convert every account, merge the year into one workbook, and find transfers as matched pairs — a debit leaving one account and an equal credit arriving in another around the same date. Tag those out, and what's left on the income side is genuine trade income you can cross-check against your invoices or platform payout reports. If a marketplace or payment processor pays you net of its fees, gross up: record the full sale as turnover and the fee as an allowable expense, rather than just the net amount that hit your account.
Doing this cross-check yourself is exactly what HMRC would do if it ever queried the return, so it's the difference between a figure you can defend and one you're hoping is right. It also feeds cleanly into the rest of the self-employment pages, because once turnover is correct the expense side simply nets against it.
| Incoming amount | Counts as turnover? | Treatment |
|---|---|---|
| Client / customer payment | Yes | Include in turnover |
| Marketplace payout (net of fee) | Yes (gross up) | Turnover = gross; fee = expense |
| Transfer from your savings | No | Tag as transfer, exclude |
| Personal money paid in | No | Capital introduced, not income |
| Bounce Back / business loan | No | Financing, not turnover |
| Refund from a supplier | No | Net against the original cost |
Landlords, side income and the property pages
Self Assessment isn't only for sole traders. If you let property, the same conversion turns a year of rent receipts and property-account spending into the figures the UK Property pages need: rental income on one side, allowable costs — letting agent fees, repairs, insurance, ground rent, mortgage interest treated under the current rules — on the other. Convert each property's statements, tag rows by property, and total per property so the income and expenses map straight onto the return. The landlord's converter goes deeper on this.
Side income alongside a job works the same way. Whether it's freelance work, consulting or selling online, the trick with a mixed personal account is to convert the whole thing and then tag only the transactions that relate to the trade, so just those total into the self-employment pages. The freelancer's converter covers business-versus-personal splitting in detail, and everything stays editable in the review grid before you export.
Multiple streams — say a bit of freelancing plus some rental — are no harder: keep them in one workbook, filter by description or payer, and sub-total each stream so each lands on the right part of the return. The consolidation does the organising; you just decide the categories.
Rental income
Per-property income and allowable costs for the UK Property pages.
Freelance / side income
Tag trade rows in a mixed account; total just those.
Multiple income streams
Filter and sub-total each stream in one consolidated workbook.
Untaxed interest & dividends
Surface interest and investment income that also needs declaring.
Don't wait for January: a quarterly habit
Self Assessment hurts because a year of bookkeeping gets crammed into the weeks before 31 January. It doesn't have to. Since converting and reconciling a batch of statements takes minutes, fold it into a short quarterly routine: download the quarter, convert, categorise the new rows, reconcile, done. Four small sessions across the year replace one frantic one — and you'll always have a rough idea of the tax you owe, which makes setting money aside far easier.
Categorising while the year is fresh is also more accurate: it's much easier to remember what a card payment was for in the same quarter than nine months later. A regular cadence surfaces problems — a missing statement, a misposted payment, a duplicate — while they're still trivial to fix, so when the deadline comes you're polishing a finished workbook rather than starting from a pile of PDFs. The full method is in how to prepare bank statements for taxes.
If an accountant files for you, a quarterly export keeps them current and spreads their work out, which usually means a smaller bill and a calmer January. Either way the tool carries the load — you just keep a steady rhythm instead of an annual sprint.
Key dates and payments on account
Self Assessment runs on a fixed calendar, and clean books make hitting it painless. The online return and any balancing payment for a tax year are due by 31 January following the end of that year (5 April), and if you owe enough, HMRC also asks for payments on account — advance instalments towards next year's bill, due 31 January and 31 July. The point for bookkeeping is simple: the sooner your income and expense figures are ready, the sooner you know the number, and the more time you have to set the money aside.
Having a reconciled workbook well before the deadline also lets you make sensible decisions rather than rushed ones — claiming all your allowable expenses, checking whether a payment on account should be reduced because your income fell, and avoiding the late-filing penalty and interest that come from scrambling at the last minute. Converting and consolidating the year takes minutes, so there's no reason for the figures to be the thing you're waiting on.
If you're registering for Self Assessment for the first time, or you've just gone self-employed, getting into a quarterly conversion habit from the start means your very first return is a non-event. Pair this with the step-by-step in how to prepare bank statements for taxes.
| Date | What's due |
|---|---|
| 5 April | End of the tax year — statements to gather run 6 Apr–5 Apr |
| 31 October | Deadline for a paper return (most people file online instead) |
| 31 January | Online return + balancing payment + first payment on account |
| 31 July | Second payment on account (if applicable) |
What records to keep, and for how long
HMRC doesn't want your statements with the return, but it does expect you to keep your business records and be able to produce the figures behind every box. For the self-employed that generally means keeping records for at least five years after the 31 January submission deadline for the relevant year. A reconciled, categorised workbook is precisely that record — and because it retains every original transaction line, each total traces straight back to the transactions that make it up.
Keep three things together for each year: the original statement PDFs, the converted and reconciled workbook, and receipts or invoices that back up individual deductions. Stored that way, an HMRC enquiry becomes a matter of opening a file rather than reconstructing a year from memory. It's the same discipline a good accountant applies, and the validation engine helps by confirming each statement reconciles before you ever rely on it.
Allowable expenses in detail
The expenses you can deduct are the costs incurred "wholly and exclusively" for the business — and once your year is in a spreadsheet, claiming them is a matter of filtering and totalling rather than hunting. The categories below cover most sole-trader and landlord spending. For anything used partly for personal reasons, claim only the business proportion: a phone used 70% for work means 70% of the bill, and a reasonable, consistent basis matters more than a precise-looking but arbitrary figure.
A few UK-specific points are worth knowing. Some traders use simplified expenses (flat-rate amounts for vehicle mileage or working from home) instead of apportioning actual costs — your structured workbook makes it easy to compare both and pick whichever is better. Mortgage interest on a let property is handled under the current finance-cost rules rather than as a simple expense. And capital items (equipment you'll use for years) are treated differently from day-to-day running costs. When a row's treatment isn't obvious, flag it and check with your accountant — the workbook makes the question specific.
| Allowable category | Examples | Note |
|---|---|---|
| Office & admin | Software, stationery, phone, postage | Apportion mixed-use items |
| Travel & motor | Fuel, train, parking | Actual cost or simplified mileage |
| Premises | Rent, utilities, business rates | Home-office: actual share or flat rate |
| Stock & materials | Supplier purchases | Capital items treated separately |
| Professional fees | Accountant, legal, subcontractors | Keep invoices as backup |
| Finance charges | Bank, card, interest, FX fees | Property mortgage interest: special rules |
Sort your Self Assessment in an afternoon
Convert a year of statements, split business from personal, total your allowable expenses, and export a clean workbook to file from or hand to your accountant.