US · Statement to CSV & Excel
Convert Chase bank statement PDFs to CSV or Excel
Upload a text-based Chase checking or business statement, review the extracted transactions, and download a CSV or Excel file for bookkeeping. BankSheet is the step where a PDF becomes a register you can check. It does not replace reconciliation.
Both open the homepage converter. Use Load sample statement there for the Chase sample PDF, or upload your own statement.
What you get
- Built for text-based Chase checking and business statement PDFs that cover a statement period.
- The preview separates debit and credit and keeps date, description, and running balance visible.
- An opening-to-closing balance check is on screen before you export.
- Standard CSV and Excel, plus QuickBooks and Xero column presets. A preset does not map accounts, categorize payees, or finish the import.
- Scope is text-based PDFs. Unusual layouts and scans need a manual review of the preview.
Want to see the math before downloading? Read How BankSheet checks balances.
Upload, preview, check, export
The Chase path is the same review loop as any other text statement in BankSheet.
- Upload a text-based Chase statement PDF in the converter.
- Preview date, description, debit, credit, and running balance.
- Read the opening-to-closing balance check before you download.
- Export Standard CSV or Excel, or a QuickBooks or Xero column preset. Review the file before you import it.
How BankSheet reads Chase statements
These are the rules the converter applies to a Chase statement, taken from BankSheet’s parser and its tests. Always compare the preview with the PDF.
- Chase is detected from the statement text
- A statement is read as Chase when its text contains “JPMorgan Chase”, “Chase Bank” or “chase.com”.
- Dates without a year get it from the statement period
- Chase checking statements print transaction dates as MM/DD, such as 12/16, with no year. BankSheet takes the year from the period line, for example “December 15, 2025 through January 14, 2026”. A month and day after the closing date belong to the year before, so 12/16 becomes 2025-12-16 and 01/02 becomes 2026-01-02.
- No period line means a warning, not a silent guess
- If no statement period is found, each row gets the latest year that keeps the rows in order and is not in the future, and a warning asks you to check the years.
- Dates are read month first
- Numeric dates are always month first (MM/DD or MM/DD/YYYY), and exports write them as YYYY-MM-DD. An impossible date such as 02/30 is kept as printed and flagged so you can check it against the PDF.
- Card purchase dates stay in the description
- In a row like “12/16 Card Purchase 12/15 Walmart”, the first date is the row date. The purchase date after it stays in the description.
- Beginning and ending balances drive the check
- “Beginning Balance” or “Opening balance” and “Ending Balance” or “Closing balance” are read for the opening-to-closing check. They are not exported as transactions.
- Rows without a date are reported
- A line between transactions that has an amount but no date at the start is not read as a transaction, and a warning tells you how many such lines were skipped.
Chase statement columns and where they go
Chase statements come in two table layouts: one Amount column, or separate Debit and Credit columns. Both carry a running Balance. This is where each column lands in BankSheet’s exports.
| On the Chase statement | Standard CSV / Excel | QuickBooks preset | Xero preset |
|---|---|---|---|
| Date (MM/DD, or MM/DD/YYYY) | Date, as YYYY-MM-DD with the year filled in | Date | Date |
| Description | Description | Description | Description |
| Amount (one column) | Debit or Credit from the printed sign (a minus or parentheses is money out). Wording is used only when no transaction amount is signed | Amount: money in positive, money out negative | Amount: money in positive, money out negative |
| Debit and Credit (two columns) | Debit and Credit; a 0.00 cell is left blank | Amount: money in positive, money out negative | Amount: money in positive, money out negative |
| Balance | Balance | Not included | Not included |
| Beginning and Ending Balance (summary) | Used for the balance check. In Excel they are on the Statement sheet | Used for the balance check only | Used for the balance check only |
Xero’s Payee and Reference columns are left blank. Excel downloads have a Transactions sheet with the same columns as the CSV, plus a Statement sheet with the bank, opening balance and closing balance. Every bank’s rules are in the bank statement formats guide.
Best fit and limits
Best fit
Bookkeepers and firms who receive a Chase checking or business PDF and need a reviewable register for month-end workpapers or a CSV handoff.
Limits
Text-based PDFs only. Pending activity that never posted to the statement is not a substitute for the statement file. Scanned or image-only PDFs may need another tool or manual entry. BankSheet does not certify a Chase layout, and the QuickBooks preset is not a .QBO or Web Connect file.
Posted statement vs pending activity
Download the statement PDF from the Chase portal after the period has posted. The pending list on the account screen is not the same set of lines as the posted statement, and a photo or scan of a paper statement is an image, not a text PDF. Convert the portal file, then check descriptions in the preview against the PDF before you export.
Privacy and retention
Uploads are processed in memory to extract transactions and run the balance check. BankSheet does not keep a long-term archive of the PDF. Processed uploads are discarded after about 60 seconds, and statement text is not written to application logs. The PDF is uploaded so the conversion can run. That is not a claim that the file never leaves your browser. Details are on the privacy page.
FAQ
- Can BankSheet convert a Chase checking statement PDF?
- Yes, when the file is a text-based Chase checking or business statement PDF. The preview shows date, description, debit, credit, and running balance. BankSheet does not promise that every Chase layout will parse. Related: How BankSheet checks balances.
- What happens if the Chase PDF is scanned or has an unusual layout?
- BankSheet reads embedded text. A phone photo, a flatbed scan, or a screenshot is image-only and may come back empty, short, or flagged as likely scanned. An unusual text layout can also miss lines. Download the portal PDF and compare the preview to the statement before you export. There is no accuracy percentage.
- Can I review the balance check before exporting?
- Yes. Opening, statement closing, computed closing, and the difference are on screen before download. The result is pass, fail, or incomplete. Incomplete means a balance label was missing, which is not a silent pass. Export after you review that panel. Related: How BankSheet checks balances.
- Which CSV or Excel option should I use for a bookkeeping workpaper?
- Use the Standard preset when you want date, description, debit, credit, and balance columns. Use the QuickBooks or Xero preset only when you want that package’s column layout. Those presets are CSV helpers, not .QBO, OFX, or Web Connect files. You still map accounts and categorize on import. Related: Import bank CSV to QuickBooks.
- Chase leaves the year off transaction dates. How does BankSheet fill it in?
- It reads the statement period printed on the statement, such as “December 15, 2025 through January 14, 2026”. A row dated 12/16 falls after the 01/14 closing date in month-and-day order, so it gets the year before: 2025-12-16. A row dated 01/02 gets the closing year: 2026-01-02. If no period is found, the latest year that keeps the rows in order and is not in the future is used, and a warning asks you to check the years.
- How does BankSheet decide money in and money out on a Chase statement?
- With separate Debit and Credit columns, each amount stays in its column. With a single Amount column, the printed sign decides: a leading minus, a trailing minus, or parentheses is money out, and a positive amount is money in. Wording such as deposit, credit, payroll, transfer from, payment from, refund or interest is used only when no transaction amount on the statement has a sign. If a row lands on the wrong side, the opening-to-closing check will not tie, so read the balance panel before you export. Related: How BankSheet checks balances.
- What columns does the Chase CSV or Excel export have?
- Standard: Date, Description, Debit, Credit, Balance. QuickBooks preset: Date, Description, Amount. Xero preset: Date, Amount, Payee, Description, Reference, with Payee and Reference left blank. Dates are written as YYYY-MM-DD. Amounts in the QuickBooks and Xero presets are positive for money in and negative for money out. Related: Bank statement CSV formats (US & UK).
- What if a Chase row prints no date of its own?
- BankSheet does not guess a date for it on a Chase statement. The line is skipped and a warning says how many lines with an amount but no date were not read. The balance check will usually show the gap, so compare those rows with the PDF.