knackbench.

Convert a bank statement PDF to Excel

Turn the PDF statement from your bank or card provider into a spreadsheet of dates, descriptions and amounts. It is read on this device, and the running balance is checked so you know every line came out right.

  • Your file stays on this device
  • Works with Wi-Fi off. Check it yourself
  • Free, with no sign-up

  1. 1 Choose your PDF statement

    Drop a PDF statement here, or choose a file

    Bank or credit card statements downloaded from online banking

    Your statement is read inside this browser tab. Nothing is uploaded.

Why this converter is different

Most statement converters ask you to upload the PDF to their servers. A statement holds your account number, your balance and a record of where you spend money, so this one works differently: the PDF is opened and read inside your browser tab, and nothing leaves your device. You can switch off Wi-Fi after the page loads and it still works.

It also checks its own work. When the statement prints a running balance, every row is tested: the previous balance plus this transaction should equal the new balance. If all rows add up, every amount was read correctly. If some do not, the tool tells you which rows to look at.

How to convert a statement

  1. Download the statement from online banking as a PDF. A statement saved by the bank works best; a scan or a photo of a paper statement will not.
  2. Drop the PDF into step 1. If it is password protected, enter the password when asked. It is used only in this tab.
  3. In step 2, check that each amount column has the right job: money out, money in, a single signed amount, or the balance. Most statements are recognised automatically.
  4. Look at the preview and the balance check in step 3, then download an Excel file or a CSV.

What it reads

  • Separate columns for withdrawals and deposits, debits and credits, or paid out and paid in.
  • A single amount column, with minus signs, brackets or CR and DR markers. When the amounts have no signs at all, the balance column shows which way each one went.
  • Descriptions that wrap onto a second line, and statements that print the date only once for several transactions on the same day.
  • Dates in any common style: 11/05, 05/11/2026, 5 Nov 2026, Nov 5. When the statement leaves out the year, it is taken from the statement period, and a December to January statement moves into the new year by itself.
  • Several pages, with the column headings repeated or not.

Lines such as opening and closing balances, page totals and summaries are left out of the transactions. Anything with a date that was not turned into a transaction is listed in step 2, so nothing disappears without you knowing.

Scanned and photographed statements

This version reads PDFs that contain text, which is what online banking produces. A scan is only a picture of text, so there is nothing for the tool to read. If you only have paper statements, check whether online banking lets you download past statements as PDFs, or download the same dates as a CSV and use the CSV converters.

Straight into your accounting software

Besides Excel and CSV, step 3 can make a QBO file for QuickBooks, a CSV in the layout QuickBooks Online uploads, a QFX file for Quicken, an OFX file for Xero, Sage and others, or a QIF file for YNAB and GnuCash. These use a checking account and the account number 0000. If you need other settings, download the CSV and use the matching converter, such as CSV to QBO or CSV to QIF.

Questions

Which banks does it work with?

Any bank or card provider whose statement is a text PDF with a table of transactions: a date on the left and amounts on the right. If yours is read wrongly, tell us the bank and the layout (not the statement itself) and we will improve the tool.

Is my statement uploaded?

No. The PDF is opened by an open-source PDF reader that runs in this browser tab. Nothing is sent to a server, and the file is gone from memory when you close the tab.

Does it work for credit card statements?

Yes. Card statements often list purchases as positive numbers; tick Reverse signs if purchases show as money in.

Can I convert several months at once?

One statement at a time for now. Convert each month, then combine the CSV files, or turn them into one QBO, QFX or OFX file each and import them in order.

Does it remember my bank's layout?

If you leave Remember these column settings ticked, the column choices are saved in this browser. Next month's statement from the same bank is set up automatically. Nothing about the transactions is saved.

Check for yourself that nothing is uploaded

  1. Open this page, then turn off Wi-Fi or switch on airplane mode.
  2. Drop your file into the tool and convert it. It still works, because the conversion runs in your browser, not on a server.
  3. For a closer look, open your browser's developer tools and watch the Network tab while you choose a file. No request carries your file anywhere.

The tools work in current versions of Chrome, Edge, Safari and Firefox, on computers and phones.

Last reviewed November 11, 2026. Found a bank export this tool reads wrongly? Tell us about the layout and we will look at it.

More finance tools