Convert a bank statement PDF to Excel

Upload the PDF and download an .xlsx with one row per transaction. Before you download, every page is checked against the balances printed on the statement. Your first 10 pages each day are free.

Convert a statement

What’s in the Excel file

Transactions sheet
One row per transaction: Date, Description, Debit, Credit, Amount and Balance.
Dates
Real Excel dates, shown as month/day/year, so you can sort and filter them.
Amounts
Numbers, not text. Amount is signed: money in is positive, money out is negative.
Summary sheet
One line per page: opening balance, credits, debits, the closing balance we calculated, the one printed on the statement, and whether they match.
Header row
Frozen, so the column names stay in view as you scroll.
Text that looks like a formula
A description that starts with =, +, - or @ is kept as plain text, so a spreadsheet never runs it.

Why the balances are checked

A converted spreadsheet looks just as tidy when a digit was misread or a row was skipped. So on each page we take the opening balance, add the money in, subtract the money out, and compare the result with the closing balance printed on the statement, to the cent. Each page also has to start where the one before it ended.

If a page doesn’t add up, you see which one and by how much. You can fix the row in the table and check again, or download it as it is: the Summary sheet shows which pages didn’t balance.

Which statements it reads

Any bank: there’s no list of supported banks. Scanned PDFs work too. One PDF can be up to 100 pages and 20 MB.

Credit card statements don’t print a balance on every page, so they’re checked against their totals instead.

Convert it in three steps

  1. Upload the PDF on StatementTally. Scanned statements work too.
  2. Review it. Every page has to add up, to the cent, and start where the one before it ended. If something’s off, you see which page and by how much, and you can fix it.
  3. Download Excel, CSV or a QuickBooks CSV, as many times as you need.

Your PDF is deleted as soon as it’s read, and your transactions are removed within 24 hours. Security

Questions

Is it free?

Yes, for 10 pages a day, with no account. After that, a page pack is US$2.99 for 20 pages and never expires, or Pro is US$24 a month for 600 pages.

Can I convert several statements at once?

With Pro, up to 20 PDFs at a time. Each one gets its own check and its own Excel file.

Does it work with scanned statements?

Yes. Scanned PDFs work too; a clean scan reads best.

Can I get CSV instead?

Yes. Every plan downloads Excel, CSV, a QuickBooks CSV, or all three in a .zip, as many times as you need.

What happens to my statement?

The PDF is deleted as soon as it’s read. The transactions are kept for up to 24 hours so you can review and download them, then they’re removed. You can delete them sooner yourself.

More ways to convert