Home › Guides › Bank statement PDF to Excel

Bank statement PDF to Excel, checked to the cent

Turn a text-based bank statement PDF into a spreadsheet you can open in Excel, and know no row was dropped: StatementHaul checks opening balance + credits − debits = closing balance on every statement.

Convert a statement free

Why not just copy and paste?

Pasting a PDF into Excel or running a generic PDF-to-Excel converter usually gives merged cells, wrapped descriptions split across rows and amounts stored as text. Worse, nothing tells you if a transaction went missing. StatementHaul pulls out one row per transaction and runs a balance check, per statement, per page and per row when a running balance is printed. If it doesn't add up, the row that breaks it is highlighted.

Steps

Download the PDF statement from online banking. You should be able to select its text. If you can't, it's a scan and isn't supported.
Drop it into StatementHaul. It's read in your browser and never uploaded.
Confirm it shows Reconciled, or review the highlighted row.
Download the CSV.
In Excel, open it with Data › From Text/CSV [Microsoft], pick UTF-8 as the file origin, and load. Then File › Save As › Excel Workbook (.xlsx) if you want a workbook.

What you get in Excel

One row per transaction with the columns Date (YYYY-MM-DD), Description, Amount (negative for money out), Debit, Credit, Balance and Page. If the PDF holds several accounts, an Account column is added. Amounts are plain numbers, so SUM and pivot tables work straight away. If you also use QuickBooks, the same statement can be downloaded as a QBO file (guide).

Honest limits

The download is CSV, not a native .xlsx. Excel opens it, and you save it as .xlsx yourself.
Scanned or photographed statements don't work (no OCR).
The parser is generic. It reads standard text-based layouts by column position: separate debit/credit columns, a single signed amount column, wrapped descriptions, US and European number formats, Indian lakh amounts, several accounts in one PDF. It has been tested on 11 published sample statements and our own synthetic ones, not on most real banks' current statements. The balance check is how you know a given file came out right.
Statements without printed opening and closing balances can still convert, but can't be fully checked.
Double-clicking the CSV can garble accented characters in some Excel setups. Use Data › From Text/CSV with UTF-8 to avoid it.

Convert your PDF statement for Excel

5 statements a month are free with no signup (statements that don't balance aren't counted), then $9 one-time for 10 or $29 one-time for 100, any length, same price.

Convert a statement free See pricing

FAQ

Do I get an .xlsx file?

No. StatementHaul exports CSV (and QBO for QuickBooks). Excel opens the CSV directly. To keep it as a workbook, use File › Save As › Excel Workbook (.xlsx).

Is it free?

5 statements a month per device are free with no signup, and statements that don't parse or don't balance aren't counted. After that it's $9 one-time for 10 statements or $29 one-time for 100, any length.

Do scanned bank statements work?

No. Only text-based PDFs, the kind you download from online banking. If you can't select the text in the PDF, it's a scan and won't convert.

Is my statement uploaded?

No. The PDF is read in your browser with pdf.js and never uploaded to our server.

Which columns end up in Excel?

Date (YYYY-MM-DD), Description, Amount (signed), Debit, Credit, Balance and Page, plus Account when the PDF holds several accounts.

Does it work with Indian bank statements for Tally?

It reads Indian lakh amounts such as 1,23,456.78 and B/F and C/F balance lines, tested on synthetic statements only. It doesn't produce a Tally import file.

Sources

Microsoft: Import or export text (.txt or .csv) files (checked 2026-10-24)