VSThiran

How to extract transactions from a bank statement

Quick answer

Open the statement in Bank Statement to Excel: a locked PDF asks for its password and is unlocked in your browser; a scan is read with OCR. Then use the balance check to confirm every transaction was captured before you rely on the list.

Extract transactionsAll Utilities tools

Free, no sign-up, and your file is read on your own device rather than uploaded.

Getting transactions out of a clean, one-page statement is easy. The awkward cases are the common ones: e-statements that arrive password protected, old statements that exist only on paper, long statements where headers and "carried forward" lines repeat on every page, and layouts where one transaction spreads over three lines.

Whatever the case, the goal is the same - a list you can prove is complete. The running balance printed on most statements is that proof, so the method below always ends with it.

Step by step

  1. Password-protected statement: enter the password

    Banks usually tell you the password format in the email that carried the statement (often built from your date of birth, account number or customer ID). The PDF is decrypted in your browser; a wrong password just asks again.

    Bank Statement to Excel

  2. Scanned statement: let OCR read it

    A scan has no text inside it, so the converter offers to read it with OCR. It is slower and can mistake 8 for 3 or drop a decimal point, so treat every flagged row and the balance check as essential, not optional.

    Bank Statement to Excel

  3. Long statement: check the count

    Headers, footers and carried-forward lines on each page are skipped automatically. Compare the transaction count with the statement - many banks print the number of transactions or the totals on the last page.

    Bank Statement to Excel

  4. Prove it with the balance

    Opening balance + total credits - total debits should equal the closing balance. If it does, every amount is accounted for. If it does not, the first row flagged "Balance does not follow" is where to look.

    Bank Statement to Excel

Tips

  • If you would rather have an unlocked copy of the PDF itself, the PDF Password tool removes the password in your browser - you need the password to do it.
  • For a statement with no running balance, compare the total debits and credits with any totals printed on the statement instead.
  • Photographing a paper statement? Lay it flat, shoot straight on in good light, and use the highest resolution - OCR accuracy drops quickly with skew and shadow.

Common problems

"This PDF uses a kind of encryption that cannot be opened here."

Open the statement in your PDF reader with its password and print it to a new PDF (Print > Save as PDF), then convert that copy.

A few descriptions are joined with the next transaction.

That happens when a statement prints no date or amount on a transaction line. Correct the description in the review table, or remove and re-add the row.

The statement has no column headings.

The converter falls back to reading lines that start with a date and marks every row for review, because without headings it cannot be sure which number is which.

Frequently asked questions

Can I extract transactions without giving my bank login to an app?
Yes. Download the statement PDF yourself and convert it in the browser. No bank login, no account linking and no upload are involved.
Which banks are supported?
The converter is not built around specific banks. It reads any statement laid out as a table with headings, and is honest about rows it cannot read with certainty.

Related related tools

Related articles

Ready to do it?

Free, no sign-up, and nothing is uploaded to a server.

Extract transactionsAll articles