Loading Bank Statement Converter…

Convert bank statements to Excel, free and private

Banks send statements as PDFs, but budgets, bookkeeping and tax returns need the transactions in a spreadsheet. Copying them from a PDF by hand is slow, and pasting usually jumbles the columns. This bank statement converter reads the PDF and gives you a clean table of every transaction: date, description, money out, money in and balance.

What makes it different is the balance check. The converter adds up every transaction it found and compares the result with the opening and closing balances printed on the statement, and with the running balance on every row. When they match to the cent, you know nothing was missed or misread. When they don’t, it shows you exactly which row to look at.

It’s free, with no sign-up, no page limit and no limit on the number of statements. Your statements are read on your own computer and are never uploaded, so it’s safe for your banking details.

Want to try it first? Choose Try a sample statement on the start screen. It opens a made-up statement from “Sample Bank”, so you can see the table, the balance check and the downloads before you add your own. How to use at the top opens a short step-by-step guide.

What statements can it read?

  • Bank statements: checking and savings accounts, with separate Withdrawals and Deposits columns, one signed Amount column, or an amount with a Dr/Cr marker.
  • Credit card statements: purchases come out as money out and payments as money in, even though the card’s balance goes the other way.
  • Statements that are hard to copy: descriptions that wrap onto two or three lines, dates without a year, deposits and withdrawals in separate sections, check grids, newest-first order, and tables that continue over many pages.
  • Scanned statements and photos: PDFs without a text layer, and JPG or PNG photos of a paper statement, are read with OCR (text recognition) on your device.
  • Password-protected PDFs: you’re asked for the password, and the file is unlocked on your device.
  • Different countries: dates like 01/31/2026, 31/01/2026 or 31.01.2026, amounts like 1,234.56, 1.234,56 or 1,23,456.78, and $, £, €, ₹ and other currencies.

It doesn’t need a template for your bank. It reads the layout of each statement: where the columns are, which amounts are money in and which are money out, and where the balances are.

How to convert a bank statement to Excel

  1. Add your statements. Drop one or more PDF statements on the page, or choose Choose bank statement PDFs. Each statement gets its own tab, and with several statements, All statements shows them together, sorted by date.
  2. Check the result. The badge at the top says Balances match when the transactions add up to the closing balance. Each row has a green check when the running balance after it matches the statement.
  3. Compare with the PDF. The statement shows next to the table with a box around every transaction found. Click a row to jump to it in the PDF, or click a box to find its row.
  4. Fix anything that’s off. Double-click a cell to edit it. The ⋯ menu on each row can flip money in and out, insert a missing row or delete a row. Rows needing checking shows only the rows to look at, and Ctrl+Z undoes a change.
  5. Download. Choose Download, pick a format, and choose one Amount column or separate Money out and Money in columns, and the date format you want.

On a phone, tap Statement to switch between the table and the PDF.

How the balance check works

Every statement prints an opening balance and a closing balance, and most also print the balance after each transaction. The converter uses them in two ways:

  • The whole statement: opening balance + money in − money out must equal the closing balance. If it does, the badge turns green. If not, it shows how much it’s off by.
  • Each row: the balance before a row, plus or minus the row’s amount, must equal the balance printed after it. A red sign marks the first row where this stops adding up, so you know where the problem is: a wrong amount, a sign the wrong way round, or a missing row just above.

If every row adds up but the last balance isn’t the closing balance, the rows at the end are missing, often because a page wasn’t included. When the statement says “Page 1 of 3”, the converter tells you how many pages are missing.

The balances also decide whether an amount is money in or money out when the statement doesn’t say, for example when there’s just one Amount column with no minus signs.

Download formats

  • Excel (.xlsx): a Transactions sheet with real dates and money formatting, a frozen header row and filters, plus a Summary sheet with the opening and closing balances, totals and the check result for each statement.
  • CSV: opens in Excel, Google Sheets, Numbers and any accounting app. Add a statement-name column when you combine several statements.
  • QuickBooks CSV: the three-column (Date, Description, Amount) or four-column (Date, Description, Credit, Debit) layout that QuickBooks Online’s bank upload expects.
  • Xero CSV: the Date, Amount, Payee, Description and Reference columns of Xero’s statement import.
  • OFX: for Quicken, GnuCash, Moneydance, YNAB and other money apps that import bank files.
  • QIF: for older Quicken versions and apps that still use QIF.
  • JSON: every statement’s account, period, balances and transactions, for your own scripts.

Copy table in the Download window copies the rows so you can paste them straight into a spreadsheet.

Combine many statements into one spreadsheet

Drop a whole year of statements at once, or statements from several accounts. All statements lists every transaction by date, and the download can put them all in one file.

Statements often overlap: a transaction near the end of one month can appear again at the start of the next statement. Remove transactions that appear in two statements in the Download window keeps one copy of each, and the window tells you how many repeats it left out.

Scanned statements and photos

If a PDF is a scan, or its text comes out garbled, the converter reads the page as a picture with OCR. You can also force this for any statement with Read with OCR under the gear button.

For a paper statement, take a photo of each page and add all the photos at once: they’re read as the pages of one statement, in file-name order. Take the photos straight on, in good light, with the whole page in the picture.

OCR can mix up similar digits, like 3 and 8. When the balances show that a digit was misread, the converter corrects the amount and marks the row amber so you can check it against the statement. Choose Mark as checked in the row’s menu once it looks right.

Tips if something looks wrong

  • The badge is red: click it to see what to check. Then turn on Rows needing checking and compare those rows with the boxes in the PDF.
  • A line in the PDF has no box: that transaction was missed. Use Insert a row below on the row above it and type it in.
  • Money in and money out are swapped for the whole statement: open the gear button and turn on Flip all money in and money out, or set Statement type to Credit card.
  • Dates look wrong: open the gear button and set Date order to Month first or Day first.
  • Amounts like 1.234,56 are read wrong: set Numbers to 1.234,56 under the gear button.

Your statements stay private

Everything happens in your browser. Statements are read on your device and never sent to a server, and nothing is saved: close the tab and they’re gone. Once the page has loaded, it reads PDF statements even with your internet connection turned off (reading scans with OCR needs a one-time download of the text reader). Remember to download your file before you close the page.

Disclaimer

The converter is a free tool provided as is. It can make mistakes, especially with unusual layouts and scanned pages, so check the result against your original statement before you use it for taxes, accounting, a loan application or anything else important. Nothing on this page is financial, tax or legal advice. The converter is not affiliated with, endorsed by or connected to any bank, and product names such as Excel, QuickBooks, Xero and Quicken are trademarks of their owners. Using it means you agree to our Terms of Use. How the site handles cookies and ads is explained in our Privacy Policy.

Related tools