What you get in Excel
A typical statement converts into a sheet with these columns:
| Date | Description | Amount | Balance |
|---|---|---|---|
| 14/03/2025 | Card payment — supplier name | -86.40 | 1,412.75 |
| 12/03/2025 | Faster payment received | 650.00 | 1,499.15 |
- Dates are written as Excel dates, so you can sort and filter by month.
- Amounts and balances are numeric cells, not text, so
SUM, pivot tables andSUMIFSwork straight away. - Multi-page statements are joined into one table with a single header row (choose merged output), or kept as one sheet per detected table (split).
Column names follow your bank's own headings. Banks that print separate Paid out and Paid in columns keep that split; banks that use one signed amount column keep that.
How to convert a bank statement PDF to Excel
- Download the statement as a PDF from your online banking. A PDF exported by the bank has a real text layer and converts more cleanly than a scan or a phone photo.
- Drop the PDF on the converter on this page.
- Leave Tables only selected. Pick Normal PDF if you can select text in the statement, or Scanned (OCR) if it is an image.
- Choose Merged to get every transaction on one sheet, then click Convert to Excel.
- Download the
.xlsxfile and check the last balance against the closing balance printed on the statement.
Why statements are harder than they look
Copying a statement out of a PDF viewer usually produces a single column of text, because a PDF stores words at positions on a page, not rows and columns. Statements add their own problems:
- Wrapped descriptions. Long merchant names or payment references run onto a second line. A naive converter turns that second line into a new, empty transaction.
- Repeated headers and footers. Every page repeats the column headings, the bank's address and a page number. Those need to be dropped, not mixed in with transactions.
- Summary blocks. The first page often has an account summary (opening balance, money in, money out) laid out like a table but unrelated to the transaction list.
- Signs and currency symbols. "-£24.50", "24.50 DR" and "(24.50)" all mean money out and must end up as a negative number.
The converter groups words into rows and columns by their position on the page, merges continuation lines into the row above, removes repeating page furniture and parses amounts into numbers.
Checking the result before you rely on it
A converted statement is only useful if it reconciles. Before importing it anywhere:
- Compare balances. The first and last Balance values should match the opening and closing balance on the PDF.
- Recalculate one page. Add a column with
=previous balance + amountand check it matches the bank's balance column; any row that breaks the chain is worth a look. - Look for blank dates. Some banks print notes such as "This relates to a previous transaction" on their own line. They come through as a row with a description but no date or amount; filter them out or merge them into the row above.
- Delete the summary rows at the top of the sheet if the account summary was picked up above the header row.
Importing into accounting software
Once the sheet is clean, save it as CSV from Excel (File → Save As → CSV) and import it into your bookkeeping tool. Most tools, including Xero, QuickBooks and FreeAgent, ask you to map columns on import: map Date, Description and Amount, and set the date format to match your bank (for UK banks usually DD/MM/YYYY).
Scanned and photographed statements
Paper statements that were scanned, or PDFs your bank generates as images, have no text to read. Select Scanned (OCR) and use Accurate for small print. OCR currently reads English text only, and its output should always be checked against the original, especially digits like 1/7 and 5/6. For tips on getting a good scan see scanned PDF to Excel.