Bank statement to Excel

Convert a bank statement PDF to Excel

Copying a statement into a spreadsheet line by line is slow, and it is where typos get into the books. Drop the PDF here and open an Excel workbook with every transaction in it, amounts stored as numbers so SUM and pivot tables work straight away.

Goes in

A bank or credit-card statement PDF, digital or scanned, up to 20 MB

Comes out

statement.xlsx: two sheets, Summary and Transactions

datedescriptioncreditdebitbalancereferenceclassification
2026-10-02Acme Payroll32005450PPD 1002ACME PAYROLL
2026-10-03Amazon64.995385.01AMAZON

What the workbook looks like

Both sheets below are built by the same code that writes your download, from a four-line sample statement.

Sheet 1: Summary

fieldvalue
bank_nameExample Bank
account_holderJordan Lee
account_numberXXXX4821
currencyUSD
statement_from2026-10-01
statement_to2026-10-31
opening_balance5450
closing_balance4766.61

Sheet 2: Transactions

datedescriptioncreditdebitbalancereferenceclassification
2026-10-02Acme Payroll32005450PPD 1002ACME PAYROLL
2026-10-03Amazon64.995385.01AMAZON
2026-10-05City Electric Co118.45266.61ACH 88213CITY ELECTRIC CO
2026-10-07Rent - Oak Street5004766.61CHK 1043OAK STREET RENTALS

Sample data from a made-up statement, not a real account.

Who this is for

  • Accountants and analysts who review a statement in Excel before anything is posted.
  • Anyone preparing figures for a loan, a tax return or a household budget who wants totals, filters and pivots.

How it works

  1. Step 1

    Upload the PDF

    Digital statements are read as text; scanned pages go through OCR.

  2. Step 2

    Check the preview

    Open the Excel tab of the preview to see the Transactions sheet before you download.

  3. Step 3

    Download statement.xlsx

    Opens in Excel, Google Sheets, Numbers and LibreOffice.

What each sheet is for

The workbook keeps the account details apart from the rows, so the Transactions sheet is a clean table you can filter or pivot.

Summary sheet

Bank, account holder, account number, currency, statement period and the opening and closing balances found on the statement.

Transactions sheet

One row per transaction: date, description, credit, debit, balance, reference, classification. Amounts are numeric cells, so a negative balance stays a number.

Pivot by payee

The classification column holds the cleaned payee name (AMAZON, ACME PAYROLL), which is the column to pivot on when you want spend by merchant.

Accuracy and limits

  • One workbook per statement. If you upload several PDFs at once, each is converted and downloaded separately.
  • The Excel file comes from the web app. The developer API returns JSON and CSV, not .xlsx.
  • Dates are text in YYYY-MM-DD form, which Excel sorts correctly; use DATEVALUE if you need real date cells.
  • PDF only, up to 20 MB per file. Photos and screenshots (JPG, PNG) are not accepted; save them as a PDF first. If the PDF is password-protected, save an unlocked copy.
  • Without an account you can convert one PDF of up to 3 pages a day. A free account converts up to 5 pages a day; Pro 400 at $15 / month (up to 400 pages per month) or Scale 1000 at $30 / month (up to 1000 pages per month).
  • On our ground-truth benchmark the current engine scores 93% transaction F1 and 99% date accuracy. That benchmark is three hand-checked statements (Canara, HSBC, ICICI), so treat it as a sign, not a guarantee for your bank. Check the preview before you download.
  • The running balance of every row is recomputed from the one before it. A row that does not add up is flagged in the JSON (balance_check), not silently fixed.

Questions

What is in the Excel file?

Two sheets. Summary lists the bank, account holder, account number, currency, statement period and opening and closing balance. Transactions has one row per transaction with date, description, credit, debit, balance, reference and classification.

Are the amounts numbers or text?

Numbers. Credit, debit and balance are numeric cells, and a side with no amount is left empty, so SUM, filters and pivot tables work without cleanup.

Do I get .xlsx or .xls?

An .xlsx workbook. Every current version of Excel opens it, as do Google Sheets, Numbers and LibreOffice.

Can I convert a credit card statement to Excel?

Yes. Purchases, fees and interest go in the debit column; payments and refunds go in the credit column.

Can I get Excel from the API?

Not today. The API returns the statement as JSON and as CSV; Excel is a download from the web app.

Can I convert several statements at once?

Yes, when signed in: select several PDFs and each is converted to its own workbook. Without an account it is one PDF of up to 3 pages a day; a free account converts up to 5 pages a day.

Related