Convert bank statements to Excel, privately

Turn bank and credit-card statement PDFs into Excel, CSV or OFX with a balance check. The PDF is read on your device and never uploaded.

Runs in your browser. Your file never leaves this device.

Loading the tool…

What this tool does

Accountants, bookkeepers and small businesses spend hours copying transactions from PDF bank statements into spreadsheets and accounting software. This tool does it in seconds: drop in the statement PDF your bank lets you download, and you get every transaction with its date, description, amount and running balance, ready to download as Excel, CSV or OFX.

It reads the table the way a person would. It finds the column headings (Date, Description, Money in, Money out, Withdrawals, Deposits, Amount, Balance and their many variants), lines up the numbers underneath, joins descriptions that wrap onto a second line, and works out the year when the statement only prints "Jan 05". It handles US, UK, European and Indian date and number formats, separate debit and credit columns or a single signed amount, and credit-card statements as well as bank accounts.

Every result is double-checked against the statement itself. If the statement prints an opening and closing balance or a running balance, the tool adds up what it found and tells you whether it matches to the cent, and highlights any row where it doesn't. You never have to wonder whether a row went missing.

The PDF is read entirely on your computer. Nothing is uploaded, which matters when the file is a client's financial record. Scanned statements (a photo or scan of paper) have no text to read and aren't supported yet.

People use it for

  • Bookkeepers importing a client's months of bank statements into QuickBooks or Xero
  • Accountants preparing year-end or tax workpapers from PDF statements
  • Small businesses categorising spending in a spreadsheet
  • Loan, mortgage or visa applications that ask for transaction summaries

How to use it

  1. Download the statement as a PDF

    In your online banking, open the statement and choose Download or Save as PDF. That PDF contains real text the tool can read. A scan or photo of a paper statement won't work.

  2. Drop it on the converter

    The transactions appear in a table within seconds, with a balance check at the top. Green means the totals match the statement to the cent; red points you to any row that needs a look.

  3. Download Excel, CSV or OFX

    Excel keeps dates and amounts as real numbers and adds a summary sheet. CSV opens anywhere, with a QuickBooks 3-column option. OFX imports straight into QuickBooks, Xero and most bookkeeping apps.

What it works with

You give itYou get
Bank statement PDF (text)Excel (.xlsx)
Credit-card statement PDFCSV
Bank or card statement PDFOFX

Questions

Is my bank statement uploaded anywhere?

No. The PDF is opened and read by your browser on your own device, and the Excel, CSV or OFX file is created there too. You can disconnect from the internet after the page loads and it still works.

How do I know nothing was missed?

Most statements print an opening and closing balance, a running balance, or both. The tool adds up every transaction it found and checks that the numbers match the statement to the cent. If they don't, it tells you by how much and highlights the rows to check.

Which banks does it work with?

It doesn't rely on bank-specific templates. It reads the table layout, so it works with most text-based statements from US, UK, European and Indian banks and credit-card issuers. If a statement doesn't convert cleanly, send us a note through the contact page and we'll improve it.

Does it work with scanned statements?

Not yet. A scan or photo has no text to read. Download the statement from online banking instead; nearly every bank offers PDF statements with real text.

Why are credit-card charges negative in the export?

So that every export uses the same rule: money in is positive, money out is negative. Purchases on a card are money out; payments and refunds are money in. Accounting software expects this when you import.

What's the difference between CSV, Excel and OFX?

CSV is a plain table any program can open. Excel adds proper number and date formatting and a summary sheet. OFX is the bank-feed format accounting software understands, so transactions import without mapping columns.

Guides