Tallyrow
Tallyrow / Bank statement to Excel

Bank statement to Excel

A PDF statement is made to be read, not sorted. Moving it into Excel lets you filter by merchant, total a category, or hand a clean file to your accountant.

Convert a PDF

How to convert a statement

  1. Download the statement PDF from your bank’s website. Use the PDF from online banking, not a photo or a scan.
  2. Open the converter and choose the file. It is read in your browser tab and not uploaded.
  3. Look at the preview. Check the dates, descriptions and the Debit and Credit columns against the PDF.
  4. Read the totals and the balance check above the table. If both match your statement, download the .xlsx.

What you get in the workbook

One sheet named Transactions with a frozen header row and filters switched on. Date and Description are text. Debit, Credit and Balance are numbers formatted with thousands separators, so SUM, pivot tables and charts work without cleaning. A row with a withdrawal has a value in Debit and nothing in Credit, and the other way round for deposits.

Why pasting the PDF into Excel goes wrong

Copying text out of a PDF usually merges columns into one cell, splits long descriptions across rows, and turns amounts into text. Excel’s own import from PDF can work well on tidy files, but you still end up cleaning every page by hand. Tallyrow does that clean-up for the common layouts: it finds the heading row, assigns each amount to the column it sits under, and joins wrapped description lines.

Check the result before you rely on it

  • Compare total debits and total credits with the summary printed on your statement.
  • Look at the balance check. It tests whether each row’s balance equals the previous balance plus credit minus debit. A low score means a column was misread.
  • Dates are kept as printed. If your statement writes 03/04/2026, decide whether that is 3 April or 4 March before you convert the column to real dates.

Privacy

The file never leaves your device. You can switch off Wi-Fi after the page loads and it still converts. How that works and how to verify it.

Limits

Scanned PDFs, photos and password-protected files are not supported yet. Free use previews the first 2 pages of a file and allows 1 full export per day; see pricing for one-time page packs.

Questions

What do I get in the Excel or CSV file?

One row per transaction with Date, Description, Debit, Credit and Balance. Amounts are real numbers, not text, so sums and filters work. Dates are kept exactly as printed on the statement, because day-month order cannot be guessed safely.

How accurate is it?

It depends on the layout. After parsing, Tallyrow adds up debits and credits and checks each row against the running balance, then tells you if rows do not add up. Always compare the totals with your statement before you rely on the file.

Which PDFs work?

Text-based PDFs: the kind you download from online banking, where you can select and copy the text. Open the file in a PDF viewer and try to highlight a transaction. If you can, Tallyrow can usually read it. Scanned or photographed statements are not supported yet.

Questions or want this? Tell us

Missing a bank layout, a feature, or a price that fits? Write a line.