Convert bank statements to Excel

What you get in the Excel file

• A Transactions sheet with real Excel dates and numbers (not text), so SUM, pivot tables and filters work immediately.
• Separate Debit and Credit columns and a signed Amount column, so you can use whichever your workpaper template expects.
• The running balance printed on the statement, cheque numbers and references when the bank prints them.
• A Summary sheet with bank, account last four digits, statement period, opening and closing balance and the reconciliation result.
• Frozen header row and auto-filter, ready to sort or hand to a client.

Why copy-paste from a PDF into Excel goes wrong

Bank PDFs are designed for printing, not for data. When you copy a page, columns collapse into a single cell, multi-line descriptions split across rows, page headers repeat in the middle of your data, and negative amounts written as (1,234.56) or 1,234.56 DR stay as text. Fixing that by hand for a 12-month statement can take an hour and still leave a transposed digit nobody notices.

A converter that understands statement structure rebuilds each row, normalizes dates and amounts, and — most importantly — proves the result is complete by tying it back to the balances the bank printed.

Scanned statements and phone photos

Older statements, faxed copies and photos taken on a phone have no text layer. We detect that automatically and use AI vision OCR, then run exactly the same balance checks. If a figure is unreadable, the reconciliation tells you instead of silently guessing.

Excel or CSV?

Choose Excel when a person will read or work in the file — it keeps number formats and includes the reconciliation summary. Choose CSV when another system will import the data (most accounting tools, databases and scripts prefer CSV).