Convert a bank statement PDF to Excel

Why teams use Bank Statement to Excel

DocumePro is the UK bank statement converter for accountants and bookkeepers, and bank statement to Excel is its most-used tool. Bank statement PDFs are designed to be read, not parsed, which is why importing them into accounting software is usually a painful copy-paste job. DocumePro reads the transaction table inside your statement — date, description, money in, money out, balance — and rebuilds it as a structured Excel file with proper data types: dates as Excel dates, amounts as numbers (not text), and one transaction per row. Multi-page statements are stitched into a single continuous sheet so totals and pivots work without any cleanup.

How do I convert a bank statement to Excel? Upload the PDF you downloaded from online banking, wait for the transaction table to be detected, then download the .xlsx. There is no signup for the first file and no watermark on the output. Password-protected statements should be opened and re-saved without the password first, because a locked PDF cannot be read by any converter.

The converter detects layouts from every major UK bank — Barclays, HSBC, Lloyds, NatWest, Santander, Nationwide, TSB, Halifax, Co-operative, Metro, Monzo, Starling, Revolut, Tide and Chase UK — plus US, EU and APAC formats. Wrapped descriptions are re-joined, transaction codes like DD, SO, FPI, FPO, BP, CHQ and ATM are preserved as a separate Type column, and credit/debit columns are kept as positive numbers so SUM formulas behave correctly. If your accounting tool needs a single signed Amount column, one Excel formula on import converts it — or use the Xero, QuickBooks and Sage variants, which output the exact column order each package expects.

Worked example: a three-page Barclays business current account statement covering 1 April to 30 April with 74 transactions converts into a single sheet of 74 rows and six columns — Date (01/04/2026 as a real Excel date), Type (DD), Description ("BT GROUP PLC DD"), Money out (48.00), Money in (blank) and Balance (12,418.62). Because the balance column survives intact, you can check that row 74's closing balance matches the PDF to the penny before you import anything — the fastest way to prove no transaction was dropped.

Typical workflows: monthly reconciliation when a bank feed misses a few days; year-end and UK Self Assessment work that needs 12–24 months of history in spreadsheet form; VAT return preparation where transactions need categorising before submission; forensic, audit and lending work where a structured running balance is mandatory; and bookkeeping for clients whose banks do not expose a CSV download. For an accountant handling twenty clients, that is typically several hours a month of retyping removed.

Accuracy and limits: text-based statements exported directly from online banking convert essentially perfectly. Scanned or photographed statements are run through OCR first — scan at 300 DPI and keep the page straight for best results. Free conversions cover files up to the size shown on the upload box; paid tiers raise the limit and allow batches of 100+ statements. Processing runs over TLS on UK/EU infrastructure, files are deleted within 60 minutes under our Non-Persistence Guarantee, nothing is used to train AI models, and no human reads your statement — which matters when the document contains a client's full account number and transaction history.

How it works

1. Upload Statement — Drag and drop your bank statement PDF
2. Extract Data — Our system extracts transactions automatically
3. Download Excel — Get a clean spreadsheet ready for import

Key benefits

• Perfect for Xero, QuickBooks, and accounting software imports
• Extracts dates, descriptions, and amounts automatically
• Handles multi-page statements with ease
• Bank-grade security — files deleted in 1 hour
• No manual data entry required
• Works with all major bank statement formats

Common use cases

• Importing transactions to Xero or QuickBooks
• Monthly reconciliation for small businesses
• Expense tracking and categorization

Frequently asked questions

Is Bank Statement to Excel free to use?

Yes — your first conversion is free with no signup. For heavier use, DocumePro offers a £9.99 24-hour Day Pass and a £39.99/month Professional plan with unlimited conversions.

Are my files kept after I use Bank Statement to Excel?

No. Every uploaded file is permanently deleted from DocumePro servers within 60 minutes under our Non-Persistence Guarantee. Nothing is retained, shared, or used to train AI models.

Do I need to install any software?

No — Bank Statement to Excel runs entirely in your browser. There's nothing to install and no plug-in required. It works on Windows, macOS, iOS and Android.

Is DocumePro suitable for UK legal, finance and accounting teams?

Yes. DocumePro is UK GDPR-aligned, hosted on UK/EU infrastructure, and built specifically for solicitors, accountants, bookkeepers and finance teams that handle sensitive client documents.

How do I convert a bank statement PDF to Excel?

Upload the statement PDF you downloaded from online banking, wait for the transaction table to be detected, then download the .xlsx. The output has one row per transaction and columns for date, type, description, money out, money in and balance — real Excel dates and real numbers, not text. No signup is needed for your first file, and there is no watermark on the output.

1. Download the statement from your bank as a PDF (not a screenshot) — most UK banks put this under Statements or Documents in online banking.
2. Drop the PDF onto the upload box above. If the PDF is password-protected, open it, enter the password, and re-save it without one first.
3. Wait while the transaction table is detected and the columns are typed. A 3-page statement usually takes a few seconds.
4. Download the .xlsx and check that the final row's balance matches the closing balance printed on the PDF — that single check proves no transaction was dropped.
5. Import into Xero, QuickBooks, Sage or FreeAgent, or keep working in Excel with pivots and SUMIFs.

Can I convert a bank statement PDF to CSV instead?

Yes. CSV is the format most accounting packages actually want for a manual bank import, and it is the safer choice when a package rejects .xlsx. The parser is identical — only the output writer changes — so the columns, date format and signed amounts are the same in both.

Use the CSV converter when you are importing into bookkeeping software, and Excel (.xlsx) when a human is going to work in the file: sort it, categorise transactions, build a reconciliation tab, or hand it to a lender or auditor. If you have already produced an Excel file, saving it as CSV from Excel gives an equivalent result, but going straight to CSV avoids Excel silently reformatting long reference numbers.

Will it work on a scanned or photographed statement? (OCR)

Yes, with a caveat. Statements exported directly from online banking are text-based and convert essentially without manual retyping. A scanned or photographed statement has no text layer, so it is run through OCR first: the page image is read, columns are detected from alignment rather than from embedded text, and the recognised rows are written into the spreadsheet.

OCR quality depends almost entirely on the input. Scan at 300 DPI, keep the page flat and square to the glass, avoid shadows across the middle fold, and use greyscale rather than heavily compressed colour. Where OCR is uncertain — a smudged 3 that could be an 8, a torn edge — check those rows against the PDF. The balance column is your safety net: if the closing balance reconciles, the amounts in between are consistent.

How do I export the result to Xero, QuickBooks, Sage or FreeAgent?

Each package expects its own column order, and getting it wrong is the usual cause of a failed import. Rather than remapping by hand, use the variant tuned to your software — the columns come out in the order the import wizard expects, with DD/MM/YYYY dates.

Xero's Manual Statement Import wants Date, Amount, Payee, Description, Reference, Cheque Number. QuickBooks Online accepts a 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) CSV. Sage 50 and Sage Business Cloud use their own bank feed import layout. FreeAgent takes a three-column dated CSV. All four expect UK dates, which is exactly why a generic US-format PDF-to-CSV tool tends to import 03/04 as 4 March instead of 3 April.

• Xero: use the Xero-ready converter, then Accounting → Bank Accounts → Manage Account → Import a Statement.
• QuickBooks: use the QuickBooks CSV converter, then Transactions → Bank transactions → Upload from file.
• Sage: use the Sage CSV converter, then Banking → the relevant account → Import Statement.
• FreeAgent: use the FreeAgent converter, then Banking → the account → More → Upload a Statement.

Which UK banks are supported?

Every major UK high-street bank, building society and challenger has a layout-tuned converter, because the differences between them are exactly what breaks generic tools: HSBC splits descriptions over two lines, Barclays wraps long references, NatWest separates paid-in and paid-out into distinct columns, Monzo includes emoji in merchant names, and Revolut adds an FX leg to foreign transactions.

Supported with a dedicated page: Barclays and Barclaycard, HSBC UK, Lloyds, NatWest and RBS, Santander UK, Nationwide Building Society, Halifax, TSB, The Co-operative Bank, Monzo, Starling and Revolut. Metro Bank, Tide, Chase UK, Wise, Bank of Scotland and Virgin Money statements are handled by the general converter, as are US, EU and APAC layouts.

Is it free, is it safe, and how accurate is it?

Your first conversion is free with no signup. Heavier use is covered by a £9.99 24-hour Day Pass or the £39.99/month Professional plan, which raises the file size limit and allows batches of 100+ statements for year-end and Self Assessment work.

On safety: uploads travel over TLS, are stored encrypted with AES-256 while being processed on UK/EU infrastructure, and are hard-deleted within 60 minutes under our Non-Persistence Guarantee. Nothing is used to train AI models, no human reads your statement, and there are no third-party advertising scripts on the page. That matters, because a statement contains a full account number and a complete picture of someone's spending.

On accuracy, an honest answer: text-based statements downloaded from online banking convert without manual retyping — the numbers in the spreadsheet are the numbers in the PDF, because they are read from the file's own text layer rather than guessed. Scanned statements depend on scan quality and should be spot-checked. We do not publish a headline accuracy percentage, because the only figure that matters is on your statement: reconcile the closing balance in the last row against the PDF and you have verified the conversion end to end.

Who uses this, and what does it replace?

The heaviest users are UK bookkeepers and accountants working through client statements where a bank feed has gaps or was connected part-way through the year, sole traders assembling 12 months of history before a Self Assessment deadline, and finance teams pulling transactions into a spreadsheet model rather than into a ledger. Mortgage brokers, insolvency practitioners and litigation teams use it when a structured running balance is mandatory evidence.

In every one of those cases the alternative is manual data entry — typing 75 rows per statement, per month, per client. The comparison table above sets out what that costs in time, error exposure and money.

Related document tools

• Invoice to Excel — Extract invoice data from PDFs into organized Excel spreadsheets for easy tracking.
• Password Protect PDF — Add password protection to your PDF documents for secure sharing.
• Flatten PDF — Flatten PDF forms and annotations for secure, uneditable document submission.
• AI to PDF — Convert Adobe Illustrator (.ai) files to PDF for easy sharing and viewing.
• EPS to PDF — Convert EPS (Encapsulated PostScript) files to universally viewable PDFs.
• SVG to PDF — Convert SVG vector files to high-quality PDFs for printing and sharing.

Browse all DocumePro tools →