Home » Sample output
Sample output
What you actually get back when you drop a bank statement PDF into Bank2XL.
The example below uses a synthetic Chase-style checking statement. Every Bank2XL Excel has the same three sheets: Account info, Transactions, and Validation. Older converters don't ship the Validation sheet.
Sheet 1 — Account info
| Field | Value |
|---|
| Bank | JPMorgan Chase Bank, N.A. |
| Account number | ****1234 |
| Account type | Total Checking |
| Holder | JOHN P SAMPLE |
| Statement period | 2024-11-01 — 2024-11-30 |
| Currency | USD |
| Opening balance | 4,900.00 |
| Closing balance | 6,096.16 |
Sheet 2 — Transactions
| Date | Description | Debit | Credit | Balance | Page |
|---|
| 2024-11-02 | STARBUCKS #4521 | 7.85 | | 4,892.15 | 1 |
| 2024-11-03 | PAYROLL DEPOSIT | | 3,200.00 | 8,092.15 | 1 |
| 2024-11-05 | ZELLE TO J.SMITH | 250.00 | | 7,842.15 | 1 |
| 2024-11-08 | AMAZON.COM*HK4P9 | 45.99 | | 7,796.16 | 2 |
| 2024-11-12 | RENT PAYMENT — OAKWOOD PROPERTIES | 1,800.00 | | 5,996.16 | 2 |
| 2024-11-15 | SHELL OIL 57495038 | 42.00 | | 5,954.16 | 2 |
| 2024-11-22 | TRADER JOE'S #244 | 98.00 | | 5,856.16 | 3 |
| 2024-11-28 | ATM WITHDRAWAL | 200.00 | | 5,656.16 | 3 |
| 2024-11-29 | VENMO — SPLIT DINNER | 60.00 | | 5,596.16 | 3 |
| 2024-11-30 | INTEREST PAID | | 500.00 | 6,096.16 | 3 |
We take column headers verbatim from your PDF. A Russian statement gives you Russian column headers; a Portuguese statement gives you Portuguese ones.
Sheet 3 — Validation
| Check | Value |
|---|
| Opening balance (from PDF) | 4,900.00 |
| Sum of credits | 3,700.00 |
| Sum of debits | 2,503.84 |
| Computed closing balance | 6,096.16 |
| Reported closing balance (from PDF) | 6,096.16 |
| Delta | 0.00 |
| Reconciliation status | reconciled |
What happens on a mismatch
If the computed and reported balances disagree by more than 0.5%, the Validation sheet flags it with mismatch and shows the delta. The Excel still lands in your downloads (we don't silently hide it), but you know to investigate before importing into accounting software. Legacy converters skip this step. That's how bad data sneaks into books.
Join the waitlist How the extraction works