How to prepare bank statements for taxes

Before you start

• Every account and card you used for income or deductible spending — the full tax year as PDFs.
• A consistent category list that maps to the lines on your return (advertising, travel, supplies, fees, etc.).
• Receipts for individual deductions, kept as backup to the statement totals.
• A spreadsheet tool — so you can sort, filter and total, which a PDF can never do.

There's nothing to install and no per-bank template to configure. Start from the bank statement converter or go straight to bank statement to Excel. For card spend, use the credit card statement converter.

app.parseflow.io

How the conversion actually works

It helps to know what's happening under the hood, because it's why this beats both manual entry and old template-based tools. When you upload a statement, the engine reads the document's layout directly — it doesn't rely on a pre-built template for each bank, so a Chase statement, a Monzo export and a scanned credit-union statement all work without any setup. For image-only or photographed PDFs, OCR turns the picture into text first, then the same structuring runs on top.

Each transaction is rebuilt as a row: a date, a description, and a single signed amount (debits negative, credits positive), rather than the awkward split debit/credit columns or currency-symbol strings that make raw exports painful. The engine then validates the maths — opening balance plus the transactions should equal the closing balance — and flags any row it's unsure about so you can confirm it. That validation is the difference between data you can file from and data you're hoping is right; the validation engine explains it in depth.

The result is structured, reconciled, editable data — not a flat dump of text. That's what makes everything after this (categorising, totalling, exporting) fast and trustworthy. For the difference between plain OCR and structured AI extraction, see OCR vs AI document extraction.

app.parseflow.io

Step-by-step: a year of statements → tax-ready

Consolidating a year is the part that saves the most time — read how to consolidate a year of statements in minutes and use Smart Merge.

app.parseflow.io

Counting income correctly (don't double-count transfers)

Before you total income, deal with the trap that catches almost everyone: not every deposit is income. A transfer from your own savings, a refund, a loan drawdown, a credit-card payment landing back in checking, or money moved between your accounts all look identical to a customer payment in a PDF. Sum every incoming line and you'll overstate your turnover and pay tax on money you never earned. Because converted rows carry the description, you can see each credit for what it is and exclude the ones that are merely movement.

The reliable method is to convert all your accounts, consolidate them with Smart Merge, then 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 remains on the income side is genuine revenue, which you can cross-check against invoices or platform payout reports. If a marketplace pays you net of fees, gross up: record the full sale as income and the fee as an expense, not just the net deposit.

app.parseflow.io

Categorising income and expenses

Categorising is where statements become a tax return. With your year in a spreadsheet you can filter by description and total each category — income on one side, allowable expenses on the other. The trick is consistency: use the same category names every time so totals roll straight up year to year. A repeatable, rules-based approach is described in the at-scale processing playbook.

Everything stays editable in the review grid before you export, so you can fix a category or amount and watch the totals update. For freelancers and sole traders, the freelancer's converter goes deeper on business-vs-personal splitting.

app.parseflow.io

Finding every deduction

The deductions people miss are rarely the big ones — they're the small, recurring charges that never get entered by hand: software subscriptions, cloud storage, professional memberships, bank and processor fees, the odd tool bought mid-year. Spread across a year and several cards, they add up to real money left on the table. When every card transaction is structured and filterable, you can sort by vendor and surface all of them at once, so nothing legitimate goes unclaimed.

• Filter card statements by vendor to catch every recurring subscription.
• Total bank, card and payment-processor fees — all deductible, all easy to overlook.
• Apportion a fair business share of mixed costs (phone, home office, vehicle).
• Cross-check this year's categories against last year's so nothing recurring is dropped.
• Keep receipts as backup for individual deductions alongside the statement totals.

Most deductible spending runs through cards, so don't leave them out — convert them with the credit card statement converter and total card spend alongside your bank activity in the same workbook.

app.parseflow.io

Separating business and personal spending

Clean books separate the trade from your personal life. The ideal is a dedicated business account, but in reality many sole traders and freelancers run some business activity through a personal account, or use a business card for the occasional personal purchase. That's workable — the rule is to convert the whole account, then tag each row, so only genuine business transactions total into the return. The freelancer's converter covers this split in depth.

For costs that are genuinely part-business — a phone, home internet, a vehicle — apportion a fair business percentage and record only that share. Be consistent and reasonable; an arbitrary split is the kind of thing that draws questions. Everything stays editable in the review grid, so you can set the business flag and the apportioned amounts before exporting, and the totals update as you go.

Handling multiple accounts cleanly

Most people don't have just one account, and that's where things get messy if you're not careful. The clean approach is to convert each account and card separately, then bring everything into one workbook with Smart Merge, which lines up the columns from different banks so the year totals in a single place. Keeping the source account on each row means you can still see where a transaction came from, while the totals roll up across everything.

The one thing to watch with multiple accounts is internal transfers, because money moving from your checking to your savings — or from a personal account into the business — appears as a debit in one statement and a credit in another. If you don't tag those as transfers, you'll double-count: once as an expense and once as income. With the whole year consolidated, the matching pairs are easy to spot and exclude, which is exactly why you merge before you total rather than totalling each account in isolation.

app.parseflow.io

Worked examples

Filing late or doing several years is one of the strongest use cases — see bank statements for a tax return for the catch-up workflow.

A full walkthrough, start to finish

Let's make it concrete with a typical sole trader — call her a freelance designer with a business current account, one credit card she uses for software and travel, and a personal account she occasionally took client payments into early in the year. Here's how her tax prep goes from a pile of PDFs to a filed-ready figure.

1. 1She downloads all 12 months for the business account, 12 statements for the card, and the three personal-account months where client money landed — 27 PDFs in total, a couple of them scans.
2. 2She drops them into the converter. Every statement, scans included, comes back as structured rows; one card statement flags a low-confidence amount, which she confirms against the PDF in the review grid.
3. 3She consolidates everything into one workbook with Smart Merge, so the whole year — bank, card and the personal months — totals in a single place.
4. 4She tags transfers out: two movements between her own accounts and a tax refund are excluded so they don't inflate income. The remaining incoming rows are her real turnover, which she cross-checks against her invoices.
5. 5She categorises expenses — software, travel, subscriptions, professional fees, bank charges — and apportions 30% of her phone bill as business use.
6. 6She reconciles each account: opening + transactions = closing on all three, confirming nothing is missing.
7. 7She exports an Excel workbook and reads her income and expense totals straight into the self-employment pages — total time, under an hour.

The same shape works for a landlord (split by property), an e-commerce seller (gross up payouts, break out fees), or a catch-up client doing three years at once — only the categorising changes. See bank statements for a tax return for more scenarios.

app.parseflow.io

Edge cases: cash, foreign currency and odd transactions

Real years are messy, so it's worth knowing how to handle the awkward bits. Cash income and expenseswon't appear in your statements at all — if you take or spend cash in the business, keep a separate simple log and add those totals to the bank-derived figures, because a tax return must include cash trade even though the bank never saw it.

Foreign currencyshows up when you're paid from abroad or buy from overseas suppliers. Convert each statement as normal, but record income and expenses in your home currency using a reasonable exchange rate for the transaction date (or your bank's posted rate), and treat card foreign-transaction fees as a deductible cost. Refunds and chargebacks should be netted against the original expense or income rather than counted as new money, and owner drawings or capital you put in are neither income nor expense — tag them out.

When in doubt on treatment, flag the row and confirm with your accountant — the structured workbook makes those questions specific and quick to answer.

Getting the data into your accounting software

A spreadsheet is enough to file from, but if you use accounting software you can let it do the categorising and keep your books live year-round. The structured data exports to the format your tool reads: convert to a .QBO for QuickBooks, import into Xero, or take a plain Excel or CSV file. The same statement can produce all of them, so the format is a choice, not a constraint.

A bank-feed file like .QBO has a real advantage for catch-up: each transaction carries a unique ID, so importing overlapping date ranges won't create duplicates — which is exactly what goes wrong with CSV. For the step-by-step, see how to import bank statements into QuickBooks and into Xero; for the trade-offs, CSV vs QBO.

app.parseflow.io

Common mistakes

• Retyping transactions by hand when a converter structures them in seconds.
• Skipping the reconciliation — always confirm opening + transactions = closing per account.
• Lumping business and personal spending together instead of tagging each row.
• Forgetting card statements, where most deductible purchases actually happen.
• Inconsistent category names year to year, so totals don't roll up cleanly.
• Discarding the workbook after filing — keep it as your audit trail.

app.parseflow.io

Best practices

• Convert each quarter as you go so January isn't a wall of data entry.
• Keep a fixed category scheme and reuse it every year for clean roll-ups.
• Reconcile every account before totalling — a reconciled year is a defensible one.
• Keep receipts as backup for individual deductions alongside the statement totals.
• Export to the format your accountant works in — Excel, CSV, QBO or Xero.
• Store the reconciled workbook; it doubles as your record-keeping audit trail.

Want the accounting software to do the categorising? Convert to a .QBO for QuickBooks or import into Xero, then categorise there — see importing into QuickBooks.

Should you do it yourself or hand it to an accountant?

Preparing your statements and filing the return are two different jobs, and you can split them however suits you. The preparation — converting, categorising, reconciling — is data work that's well within reach for most sole traders and small businesses, especially once a converter does the heavy lifting. The filing itself, particularly anything involving judgement (capital allowances, complex reliefs, an unusual year), is where an accountant earns their fee.

A useful middle path is the one most people land on: do the bookkeeping yourself to produce a clean, reconciled workbook, then hand thatto your accountant rather than a folder of PDFs. You pay them for expertise instead of data entry, which usually means a smaller bill and a faster turnaround — it's exactly the clean input the accountant's converteris designed to receive. If your situation is genuinely simple, you may not need an accountant at all; if it's complex, the prep work still saves you money because the expensive person isn't typing.

Either way, the preparation in this guide is the part that pays for itself — see the broader picture in the tax-season bookkeeping guide.

Keeping records after you file

Filing isn't the end of the job — tax authorities expect you to keep your records for several years afterward (often around five to seven, depending on where you file) and to be able to substantiate any figure if asked. The good news is that the work you just did is the record. Keep three things together for each year: the original statement PDFs, the converted and reconciled workbook, and any receipts or invoices that back up individual deductions.

Stored that way, an enquiry becomes a matter of opening a folder rather than reconstructing a year from memory. Because the workbook retains every original transaction line, each category total traces straight back to the transactions behind it — which is exactly the audit trail a reviewer wants to see. It's also the foundation for next year: a consistent category scheme and a kept workbook make year-on-year comparisons and the next return dramatically faster.

app.parseflow.io

Final pre-filing checklist

Before you file or hand off, run through this quick checklist. If every box is ticked, your books are complete, reconciled and defensible — and the return itself becomes mostly transcription.

• Every account and card for the full tax year is converted and in one workbook.
• Transfers and personal money are tagged out so income isn't overstated.
• Each account reconciles: opening + transactions = closing, with no missing pages.
• Every transaction is categorised with a consistent, repeatable scheme.
• Card subscriptions and fees are totalled so no deduction is missed.
• Mixed costs are apportioned to a fair business share.
• Low-confidence fields and duplicates flagged in review have been resolved.
• The workbook (or QBO/Xero file) is exported, and the originals kept as records.

Filing your own return? See bank statements for a tax return or, in the UK, for Self Assessment. Preparing returns for others? The converter for tax preparers scales this across a client list, and the tax-season bookkeeping guide goes broader still.

Frequently asked questions

Related guides & tools