Reconciled bank statement converter
Every export reconciles to the cent, or we tell you why it didn’t.
StatementStudio runs the math on every statement before you download it. If the transactions don’t add up to the printed closing balance, the export carries a red flag and names the row that broke. No silent off-by-a-cent errors.
The rule
For a bank statement to reconcile, this equation has to hold to the cent:
opening_balance + sum(credits) − sum(debits) = closing_balance
Credit-card statements use the same idea with a family-specific equation. The numbers on the page have to equal what the transaction rows say.
Worked example
Sample Bank, N.A. · account ending 4242 · period 2026-04-01 to 2026-04-30
| Date | Description | Amount |
|---|---|---|
| 2026-04-01 | Opening balance | $1,000.00 |
| 2026-04-03 | Rent | -$1,650.00 |
| 2026-04-09 | Payroll deposit | $2,500.00 |
| 2026-04-12 | Utilities | -$110.00 |
| 2026-04-19 | Grocery | -$240.00 |
| 2026-04-25 | Coffee shop | -$25.00 |
| 2026-04-30 | Closing balance (reported) | $1,475.00 |
Computed
$1,000.00 + $2,500.00 − $2,025.00 = $1,475.00
Verdict: Reconciled
Computed equals reported. Export is marked Reconciled.
When math fails, the export tells you
- reconciliation_mismatch: the totals do not match. The export is not blocked, but the badge is red.
- transactions_missing: the parser found no rows. Almost always a layout we have not seen yet.
Try a statement. Upload one on the homepage →