Summary sheet
Bank, account holder, account number, currency, statement period and the opening and closing balances found on the statement.
Bank statement 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
| date | description | credit | debit | balance | reference | classification |
|---|---|---|---|---|---|---|
| 2026-10-02 | Acme Payroll | 3200 | 5450 | PPD 1002 | ACME PAYROLL | |
| 2026-10-03 | Amazon | 64.99 | 5385.01 | AMAZON |
Both sheets below are built by the same code that writes your download, from a four-line sample statement.
Sheet 1: Summary
| field | value |
|---|---|
| bank_name | Example Bank |
| account_holder | Jordan Lee |
| account_number | XXXX4821 |
| currency | USD |
| statement_from | 2026-10-01 |
| statement_to | 2026-10-31 |
| opening_balance | 5450 |
| closing_balance | 4766.61 |
Sheet 2: Transactions
| date | description | credit | debit | balance | reference | classification |
|---|---|---|---|---|---|---|
| 2026-10-02 | Acme Payroll | 3200 | 5450 | PPD 1002 | ACME PAYROLL | |
| 2026-10-03 | Amazon | 64.99 | 5385.01 | AMAZON | ||
| 2026-10-05 | City Electric Co | 118.4 | 5266.61 | ACH 88213 | CITY ELECTRIC CO | |
| 2026-10-07 | Rent - Oak Street | 500 | 4766.61 | CHK 1043 | OAK STREET RENTALS |
Sample data from a made-up statement, not a real account.
Step 1
Digital statements are read as text; scanned pages go through OCR.
Step 2
Open the Excel tab of the preview to see the Transactions sheet before you download.
Step 3
Opens in Excel, Google Sheets, Numbers and LibreOffice.
The workbook keeps the account details apart from the rows, so the Transactions sheet is a clean table you can filter or pivot.
Bank, account holder, account number, currency, statement period and the opening and closing balances found on the statement.
One row per transaction: date, description, credit, debit, balance, reference, classification. Amounts are numeric cells, so a negative balance stays a number.
The classification column holds the cleaned payee name (AMAZON, ACME PAYROLL), which is the column to pivot on when you want spend by merchant.
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.
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.
An .xlsx workbook. Every current version of Excel opens it, as do Google Sheets, Numbers and LibreOffice.
Yes. Purchases, fees and interest go in the debit column; payments and refunds go in the credit column.
Not today. The API returns the statement as JSON and as CSV; Excel is a download from the web app.
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.
The same rows as a CSV for QuickBooks, Xero or a database.
Structured output and an API for developers.
Text extraction, OCR, row extraction and the balance check.
Statement data ready for the close.
Small single-purpose statement tools.
Convert statements from your own code.