Statement rows to Excel or CSV, with a certificate
Open the CSV or Excel export from a bank or card account, or paste the rows of a statement. The columns are matched from the header words and can be changed. Type the opening and closing balances, or let them come from the running balance column, and the tool checks that the rows add up to the statement before you download the table.
The file is read in your browser and stays on this device. Nothing is uploaded. This tool reads rows (CSV, Excel, or pasted text); it does not read PDF files or scans.
Or paste rows copied from a statement or spreadsheet, with a header row first (for example Date, Description, Amount, Balance):
The rows are read in this browser and are not uploaded. This tool reads rows; it does not read PDF files or scans.
These are matched from the header words. Check them and change any that are wrong. Use either one amount column, or the money out and money in columns.
Optional: totals from the statement's summary box. When typed, they are checked against the rows.
Statement
Transactions
What gets checked
- Opening balance plus every transaction equals the closing balance, to the cent. For a card: previous balance plus activity equals the new balance.
- Every running balance in the file equals the balance before it plus that row's amount.
- Every transaction has a valid date, and dates outside the typed statement period are flagged.
- When summary totals are typed, deposits and withdrawals match them by amount and by count.
- Money in minus money out equals closing minus opening balance, added a second way.
- The table that is downloaded is read back, and its total and last balance equal the statement's.
- Every row with data was read. A row that could not be read is listed with the reason and the result is marked not verified.
How it works
- Open the rows. Drop a .csv or .xlsx export from the bank or card account, or paste rows copied from a statement with a header row first. The rows are read in the browser. PDF files and scans are not read.
- Check the columns. Date, description, amount (or separate money out and money in columns), and running balance are matched from the header words. Every choice can be changed, along with the header row, whether dates are month first or day first, and whether the signs are flipped.
- Enter the balances. Type the opening and closing balances from the statement, or leave them blank to use the running balance column. Summary totals and the statement period are optional and are checked when typed.
- Convert and download. The transactions are put in date order and checked against the balances. Download the table as Excel or CSV with the certificate, or print it.
Worked example
A made-up March export with a running balance column. The opening balance of $1,200.00 and the closing balance of $3,953.33 are typed from the statement, along with its summary: 2 deposits totaling $3,750.00 and 4 withdrawals totaling $996.67.
| Date | Description | Amount | Balance |
|---|---|---|---|
| 03/02/2026 | PAYROLL DEPOSIT EXAMPLE CO | 2500.00 | 3700.00 |
| 03/03/2026 | CARD PURCHASE HARDWARE STORE | -48.27 | 3651.73 |
| 03/05/2026 | CHECK 1042 | -800.00 | 2851.73 |
| 03/09/2026 | ACH DEPOSIT CLIENT INVOICE 118 | 1250.00 | 4101.73 |
| 03/16/2026 | ELECTRIC UTILITY PAYMENT | -136.40 | 3965.33 |
| 03/31/2026 | MONTHLY SERVICE FEE | -12.00 | 3953.33 |
Money in is $3,750.00 and money out is $996.67, a net of $2,753.33. $1,200.00 + $2,753.33 = $3,953.33, the closing balance. All six running balances match, the deposit and withdrawal totals and counts match the summary, and the table read back totals $2,753.33 and ends at $3,953.33. All 12 checks pass.
The example uses made-up names and numbers.
Questions
Does it read PDF statements or scans?
No. It reads rows: a .csv or .xlsx export from the bank, or rows copied from a statement or spreadsheet into the box on the page. Most banks offer a CSV or Excel download next to the PDF statement.
Which bank layouts does it read?
Any export with a header row. Layouts differ between banks and change over time, so the tool does not assume one: it matches header words, shows its choices, and every column can be changed. When a column cannot be identified, the page says which one and links to a form for requesting support for that format.
What if my export has no running balance column?
Type the opening and closing balances from the statement. The check that opening balance plus transactions equals closing balance works the same way; only the row-by-row running balance check is left out.
What happens when the numbers do not tie?
The certificate shows which check failed and by how much, for example a closing balance that is off by the amount of a missing row. The table can still be downloaded, but only after a confirmation, and the file name is marked UNVERIFIED.
Can it handle a credit card export?
Yes. Choose credit card as the account. Positive amounts are then charges and negative amounts are payments and credits, and the check is previous balance plus activity equals new balance. If the export shows charges as negative numbers, flip the signs in the column mapping.
This tool calculates and checks numbers. It is not legal, tax, or medical advice.