Chase, Wells Fargo & Bank of America PDF to Excel
Purpose-built coordinate rules for major US commercial and consumer bank PDFs. Automatically filters Daily Ending Balance tables and splits 2-column Checks Paid grids.
Drop digital-native Bank or Credit Card PDF statements here
Parsed 100% inside your browser RAM · Supports Chase, Wells Fargo, BoA, Citi, Amex & US regional banks
Opening statement balance
3 active credits
9 debits (6 checks de-interleaved)
Computed: $24,185.00
| # | Date | Section | Check # | Description (Multi-Line Stitched) | Amount | Running Bal | Quick Fix |
|---|---|---|---|---|---|---|---|
| 1 | 2026-01-05 | Deposits & Additions | — | MERCHANT CARD SETTLEMENT BATCH 102 | +$5,400.00 | $27,800.00 | |
| 2 | 2026-01-15 | Deposits & Additions | — | B2B ACH RECEIVABLE APEX LOGISTICS | +$4,850.00 | $32,650.00 | |
| 3 | 2026-01-26 | Deposits & Additions | — | REMOTE CHECK DEPOSIT CAPTURE | +$1,920.00 | $34,570.00 | |
| 4 | 2026-01-08 | Withdrawals & Debits | — | ADP PAYROLL EFT BATCH 7721 | -$4,100.00 | $30,470.00 | |
| 5 | 2026-01-14 | Withdrawals & Debits | — | CON EDISON COMMERCIAL ELECTRIC | -$315.00 | $30,155.00 | |
| 6 | 2026-01-21 | Withdrawals & Debits | — | HARTFORD GENERAL LIABILITY INS | -$490.00 | $29,665.00 | |
| 7 | 2026-01-06 | Checks Paid | #2101 | Check #2101 Paid | -$850.00 | $28,815.00 | |
| 8 | 2026-01-09 | Checks Paid | #2102 | Check #2102 Paid | -$1,240.00 | $27,575.00 | |
| 9 | 2026-01-12 | Checks Paid | #2103 | Check #2103 Paid | -$620.00 | $26,955.00 | |
| 10 | 2026-01-18 | Checks Paid | #2105 | Check #2105 Paid | -$945.00 | $26,010.00 | |
| 11 | 2026-01-22 | Checks Paid | #2106 | Check #2106 PaidPro Full Export | -$1,110.00 | $24,900.00 | |
| 12 | 2026-01-28 | Checks Paid | #2107 | Check #2107 PaidPro Full Export | -$715.00 | $24,185.00 |
Built-in layout intelligence for major US bank PDF statements
JPMorgan Chase Checking & Business Complete PDFs
Separates `DEPOSITS AND ADDITIONS`, `ELECTRONIC WITHDRAWALS`, `ATM & DEBIT CARD WITHDRAWALS`, and `CHECKS PAID` while quarantining the trailing `DAILY ENDING BALANCE` table.
Wells Fargo Commercial & Consumer Checking PDFs
De-interleaves Wells Fargo’s side-by-side 2-column `Checks Paid` grid (including gap asterisks like `2103*`) and preserves every check number in its own column.
Bank of America Advantage & Full-Service PDFs
Stitches multi-line ACH/Square/Sysco descriptions and reconciles `Deposits and other additions` against `Withdrawals and other subtractions` to `$0.00`.
Major US bank PDF quirks handled automatically by StatementTab
| PDF extraction symptom | Underlying bank layout cause | How StatementTab resolves it |
|---|---|---|
| Chase Daily Ending Balance table inflates transaction count | Chase prints multi-column `Date + Balance` rows at the end of every monthly statement. | Automatically detects the `DAILY ENDING BALANCE` header and moves all subsequent balance snapshots to the Excluded Noise tab. |
| Wells Fargo 2-column Checks Paid table merges two checks into one row | Two checks share the same vertical Y coordinate on the PDF page. | Splits left and right X-coordinate columns into separate check rows with exact check numbers and negative amounts. |
| Cross-year statement (`Dec 15, 2025 through Jan 14, 2026`) date scramble | Transactions only show `12/18` and `01/06` without the year. | Infers `2025` for December rows and `2026` for January rows directly from the statement header period. |
Frequently asked questions
Does StatementTab work with regional US banks and credit unions too?
Yes. In addition to dedicated rules for Chase, Wells Fargo, Bank of America, Citi, Capital One, and American Express, our coordinate state machine parses any digital-native US bank or credit union PDF statement with standard date, description, and amount columns.
Why did my Chase statement only export 90 days from online banking?
Many banks limit direct CSV downloads to the most recent 90 days, but allow you to download up to 7 years of monthly PDF statements. StatementTab lets you convert those historical PDF statements back into reconciled Excel and CSV files locally.
What happens if a check number has an asterisk (`2103*`) indicating a sequence gap?
StatementTab strips the formatting asterisk while preserving the numeric check number (`2103`) in the dedicated `Check #` column.
Can I manually exclude a row or flip a +/- sign before exporting?
Yes. Every row in the interactive preview table has 1-click `Flip ±` and `Exclude` buttons that immediately recalculate your live reconciliation difference.