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 shape: Account info, Transactions, and a Validation sheet. The Validation sheet is the one that makes Bank2XL different from legacy converters.
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 | 5,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 |
Column headers in your Excel are taken 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