How to convert a PDF bank statement to Excel
Upload the PDF to a converter that reads the transaction table and checks it against the statement's balances, then download the Excel file. Copying and pasting from the PDF also works for some statements, but columns often break across lines and nothing tells you if a row was missed.
Steps
- Upload the PDF to Balanced Statement. Scanned statements and phone photos (JPG, PNG, HEIC) work too, up to 20 pages per statement. Your first statement is free.
- Look at the result: opening balance, closing balance, the computed closing balance and the difference, and every transaction. Rows that don't reconcile are highlighted.
- Download Excel. The Transactions sheet has one row per transaction (Date, Description, Amount, Debit, Credit, Balance, Reference); the Check sheet shows the balance check. Statements with extra tables, such as savings pockets, get an Other sections sheet.
- Need plain text instead? Download CSV: same columns, for any spreadsheet or tool.
Check before importing
- Balances: the result is marked Verified (opening balance plus all transactions equals the closing balance, or the running balance matches on every row). If it says Failed or Not verified, review the highlighted rows first.
- Count: the number of transactions matches the statement.
- Signs: money out is negative and money in is positive.
- Dates: all dates fall inside the statement period, in the date format your spreadsheet expects.
- Overlaps: none of these transactions are already in your spreadsheet from a bank feed or an earlier import, or you'll get duplicates.
Where Balanced Statement fits
It saves the retyping and tells you whether the result adds up, so you don't have to tick every line against the PDF. You pay per statement (pricing), with no subscription. Going on to accounting software? See QuickBooks or Xero.