How Chase statement to Excel conversion works
Chase checking and savings statements list each transaction with a short MM/DD date, a description, a single signed Amount column and a running Balance, rather than separate debit and credit columns. The converter splits that one signed column into debit and credit for you: negative amounts and amounts in brackets become debits, positive amounts become credits, so the spreadsheet is ready for SUM formulas.
Because the transaction lines carry no year, the year is taken from the statement period printed on the first page. When a statement crosses New Year, the year advances automatically when the month rolls from December back to January, so a 12/29 and a 01/02 transaction end up in the right years. If no period can be found the current year is used and you are warned.
A Chase statement also contains sections that look like tables but are not transactions — the account summary, daily ending balances and the fee-avoidance panel. Rows that have no date in the date column are not treated as transactions; ones that carry an amount are listed as skipped so nothing disappears silently. Credit-card statements are different: they have no running balance, so the balance check cannot run and you should review the rows by eye.
Statement layouts change, so treat this profile as a convenience and the balance check as the proof. Where a running balance is printed, every row is re-added from the one before it; any row that does not reconcile is highlighted and can be edited before you download the Excel or CSV file.
Chase statement layout the parser expects
- Bank: JPMorgan Chase Bank, United States
- Date format: MM/DD (year taken from the statement period)
- Columns detected: date, description, amount (signed), balance
- Typical currency: USD
- Checked against: the printed running balance, row by row
How to use it
- Drop one or more PDF statements onto the box, or choose “Try a sample statement” to watch it work on a fictional one first.
- Wait a moment while each page is read. A progress bar shows how far along it is.
- Check the summary bar. A green “balance reconciles” badge means every running balance agrees with the transactions; a red count means that many rows need a look.
- Fix any highlighted row directly in the table — the check recalculates as you edit. Delete junk rows or flip debit and credit if a bank uses the opposite convention.
- Download the result as an Excel .xlsx file with a formatted header row, or as a CSV.
Frequently asked questions
Is my Chase statement uploaded when I convert it?
No. The Chase PDF is read inside your browser and never sent to a server. Only an anonymous count, such as the number of rows converted, is recorded.
Does this work on every Chase statement?
It works on text-based Chase PDFs that contain a transaction table. Scanned copies have no text to read, and a redesigned statement can occasionally need a correction, which is why the tool shows a balance check and lets you edit any row.
What does “balance reconciles” mean, and what if it says rows need review?
For every row with a printed balance, the tool checks that the previous balance plus credits minus debits equals it. If every row agrees, the extraction is internally consistent. If some do not, those rows are highlighted in red — usually a misplaced digit, a merged column or a wrapped line — and you can edit them in the table; the check recalculates as you type.
Can I convert a password-protected statement?
Yes. When a PDF is encrypted the tool asks for its password and unlocks it locally. Many banks protect statements with something like your date of birth or the last digits of your account number. The password is used only to open the file in your browser and is not stored or sent anywhere.
Statement layouts are set by the bank and change without notice. Always confirm the “balance reconciles” badge and review flagged rows before relying on the converted figures.