Bank Statement Converter (PDF to Excel)

Turn your PDF into a spreadsheet

Drop your bank statement PDF into the tool above and it reads the transaction rows, then hands you back a CSV or Excel file you can open in Excel, Google Sheets or Numbers. The point is to save you the soul-destroying job of copying hundreds of lines across by hand before your tax return is due.

How the bank statement converter works

Most UK bank statements are laid out as a table: a date column, a description (the payee or reference), then amounts and a running balance. A converter does three things in order.

• Reads the page. If the PDF was downloaded straight from online banking, the text is already embedded and can be lifted directly. If it is a scan or a photo of a paper statement, the tool uses OCR (optical character recognition) to recognise the printed characters first.
• Finds the structure. It detects where each column sits and which lines are real transactions versus headers, page footers or marketing strapline text, then rebuilds each row as date, description, amount and balance.
• Exports clean data. It writes the rows out as a CSV (comma-separated values) or an Excel sheet, with one transaction per row and consistent date and number formatting.

In plain terms the workflow is: PDF in → read text or OCR → detect columns → CSV or Excel out. No tax rate is involved - this is a data tool, not a calculator, so there is nothing to work out against the 2026/27 thresholds. What matters is that every penny lands in the right column so your later totals are correct.

A genuine accountant's tip: the running balance column is your built-in checksum. If you take the opening balance, add every "money in" and subtract every "money out", you should arrive exactly at the closing balance. If you do not, a row has been missed or mis-read, and you have caught it before it reaches your tax figures.

Worked example: a freelancer's quarter

Say you are a self-employed designer and your April statement has 42 transactions across four pages. Typing them into a spreadsheet by hand at, realistically, 20 seconds a row is about 14 minutes per statement - and that is before you fix the typos. Three months of statements is roughly 45 minutes of mind-numbing data entry. The converter does the same job in under a minute and does not fat-finger a 7 into a 1.

Now the reconciliation check in action. Your April statement shows:

• Opening balance: £2,150.00
• Money in (three client invoices): £1,800 + £950 + £420 = £3,170.00
• Money out (software, rent, fuel, fees): £1,540.00

Expected closing balance = £2,150.00 + £3,170.00 − £1,540.00 = £3,780.00. If the converted spreadsheet's final balance reads £3,780.00, your data is complete. If it reads £3,360.00, you are £420 short - the £420 invoice row did not convert, so you add it back before filing. That £1,800 + £950 + £420 = £3,170 of income is exactly what would flow into your self-employed tax calculator to estimate the bill.

Who actually needs this

The converter earns its keep wherever bank data has to become accounting data:

• Sole traders and freelancers pulling a year of transactions together for the 31 January Self Assessment deadline.
• Landlords separating rent received from mortgage interest, letting fees and repairs. Once it is in a sheet you can feed the figures into a landlord rental income organiser and keep a clean audit trail.
• VAT-registered businesses who need transaction-level detail to support a VAT return and to tie back to invoices.
• Anyone moving onto Making Tax Digital, where HMRC expects digital records rather than a shoebox of paper. A converted CSV slots into a quarterly record organiser so your numbers are ready each quarter.

Pair the output with an expense tracker and you have categorised, totalled records without touching a calculator by hand.

Getting the cleanest possible export

• Download the original PDF from online banking, not a photo. A native PDF keeps the real text, so conversion is near-perfect. A phone snap of a paper statement relies on OCR and is more prone to mistakes on faint print.
• Convert one account at a time. Mixing a personal and a business account in the same sheet is the fastest route to claiming the wrong expenses. Keep business banking separate - it makes every later step simpler.
• Check the date format. UK statements use DD/MM/YYYY. If a sheet treats 03/04 as 4 March instead of 3 April, your monthly and quarterly totals drift. Set the column to a UK date format before you sort.
• Keep the original PDFs. HMRC asks self-employed people to keep records for at least five years after the 31 January filing deadline. The spreadsheet is your working copy; the PDF is the evidence. gov.uk sets out the record-keeping rules.

Common mistakes to avoid

• Trusting the file without the balance check. Always run the opening-plus-in-minus-out test described above. It takes ten seconds and catches a dropped row instantly.
• Double-counting transfers. Money moved between your own accounts is not income or an expense. If you convert two accounts, a transfer appears in both - remove one side, or you will overstate turnover.
• Treating gross card takings as profit. If a payment processor pays you after fees, record the gross sale and the fee separately so your figures match your invoices and your VAT records.
• Losing the description detail. A bare amount with no payee is hard to categorise months later. Keep the full description column - it is what tells you whether £60 was fuel, a subscription or a refund.
• Forgetting these are estimates, not advice. A converter organises your data; it does not decide what is taxable. The figures here are estimates for guidance only and are not personal tax or financial advice - check anything material with HMRC or a qualified accountant. For a wider view of your digital obligations, the gov.uk Making Tax Digital guidance and MoneyHelper are reliable starting points.

Is it safe and is the data accurate?

A bank statement is sensitive, so only use a converter you trust and delete working copies you no longer need. On accuracy, a native PDF from online banking converts almost flawlessly; scanned or photographed statements depend on image quality, which is why the balance reconciliation matters. Treat the export as a fast first draft you verify, not a figure to file blind.

Related tools to finish the job

Once your transactions are in a spreadsheet, keep the momentum: log purchases with the expense tracker, prepare for HMRC with the MTD quarterly record organiser, and estimate what you owe using the self-employed tax calculator.

Who should use this tool

Turns a bank statement into a structured transaction list you can categorise and reconcile. For anyone catching up on a year of bookkeeping, the statement is the most complete record of what actually happened — every payment appears whether or not a receipt survived.

Working from the statement is also the reliable way to find costs you would otherwise miss: annual subscriptions, insurance renewals, bank charges and standing orders that never generated a receipt but are perfectly allowable.

What this tool assumes

• Transactions are extracted with date, description and amount, and summarised over the statement period.
• Money in and money out are separated to show the net change.
• Categorisation is yours to apply — a description is not a category.
• The account is used for business, or business items are identifiable within it.

Limitations — what it does not cover

• Whether a transaction is allowable, which the statement line cannot tell you.
• Mixed personal and business accounts, where every line must be judged individually — a separate business account avoids this entirely.
• Supporting evidence. A statement line proves payment, not what was bought; HMRC may still want the invoice.
• VAT, which cannot be reclaimed on a statement line alone.
• Transfers between your own accounts, which are not income or expenditure.
• Cash transactions, which never appear.