Which banks does it work with?

Any bank whose statement is a PDF with real text in it, which is what online banking gives you. It does not depend on knowing the bank: it reads the layout of the page. A paper statement that has been scanned is a picture with no text, and cannot be read.

What does "does not add up" mean?

For each transaction, the previous balance plus money in, minus money out, should equal the balance printed beside it. When it does not, the transaction was probably read wrongly, often because two columns ran together or a line wrapped unusually. Look at that row on the page and adjust the column lines; when every balance adds up, the conversion is right.

Which file should I choose for my accounting software?

QuickBooks, Xero, GnuCash and Moneydance import OFX. Quicken and GnuCash import QIF. For anything else, or to work in a spreadsheet, choose Excel or CSV.

My statement has no year in the dates. What year is used?

The year printed most often elsewhere on the statement, usually in the statement period at the top. Check the dates of a statement that runs from December into January.

Is my statement uploaded?

No. A bank statement is about as private as a document gets, and this one is read by your browser on your computer and never sent anywhere. For other tables in PDFs, see PDF to Excel.

Stays on your computer How this works

Bank statement converter

Convert a PDF bank statement to Excel, CSV, OFX or QIF: every transaction with its date, description, amount and balance, checked against the running balance. Free, and your statement never leaves your computer.

Drag & drop a bank statement PDF here, or browse

A statement downloaded from online banking · nothing is uploaded

About converting bank statements

Banks give out statements as PDFs, but bookkeeping, budgeting and tax returns need the transactions in a spreadsheet or in accounting software. Typing them in takes hours, and the converters that do it for you upload your statement to their servers, limit how many pages you can convert for free, and charge a subscription after that. This one reads the statement in your browser. Nothing is uploaded, and there is no page limit.

It finds the table of transactions on each page and works out which column is which: from the headings, or, where there are none, from what is in the columns. Dates and amounts are read in whichever style the bank prints them, descriptions that wrap onto a second line are joined back together, and balances brought and carried forward are recognised. Then every transaction is checked: the previous balance plus the amount has to give the balance printed. Rows that do not add up are highlighted, so you know exactly which lines to look at before you rely on the export. It is free to use, with no account and no upload limit, and it runs entirely in your browser: nothing is uploaded, and while the page stays open, a feature you have already used keeps working offline.

What you can do

Convert PDF bank statements to Excel (.xlsx) or CSV
Save OFX for QuickBooks, Xero, GnuCash and Moneydance, or QIF for Quicken and GnuCash
Read amounts written as 1,234.56 or 1.234,56, in brackets, with a minus sign before or after, or marked CR and DR
Read dates as 31/01/2026, 01/31/2026, 2026-01-31, 31 Jan 2026 or 31 Jan
Split money in and money out, and keep the running balance
Check every balance and highlight any row that does not add up
Change which column is which, or move the column lines on the page, if a statement is laid out unusually
Convert statements of any length: there is no page limit

How to convert a bank statement PDF to Excel

Download the statement as a PDF from online banking, then drop it onto the page.
Check the summary: the number of transactions, the opening and closing balances, and whether every balance adds up.
If a row is highlighted, look at that page and move a column line if one is out of place.
Press Excel, CSV, OFX or QIF.

Questions

Which banks does it work with?: Any bank whose statement is a PDF with real text in it, which is what online banking gives you. It does not depend on knowing the bank: it reads the layout of the page. A paper statement that has been scanned is a picture with no text, and cannot be read.
What does "does not add up" mean?: For each transaction, the previous balance plus money in, minus money out, should equal the balance printed beside it. When it does not, the transaction was probably read wrongly, often because two columns ran together or a line wrapped unusually. Look at that row on the page and adjust the column lines; when every balance adds up, the conversion is right.
Which file should I choose for my accounting software?: QuickBooks, Xero, GnuCash and Moneydance import OFX. Quicken and GnuCash import QIF. For anything else, or to work in a spreadsheet, choose Excel or CSV.
My statement has no year in the dates. What year is used?: The year printed most often elsewhere on the statement, usually in the statement period at the top. Check the dates of a statement that runs from December into January.
Is my statement uploaded?: No. A bank statement is about as private as a document gets, and this one is read by your browser on your computer and never sent anywhere. For other tables in PDFs, see PDF to Excel.

Built by John McMillan, a senior full-stack engineer. Open to remote roles: hire me.

Report a problem or suggest a feature