Convert a Chase bank statement to Excel

Checking and credit card statements

Checking statements list each transaction with a signed amount and running balance, followed by a daily ending balance table. RowBalance reads the transaction detail, skips the summary tables, and checks the beginning balance plus transactions against the ending balance. On credit card statements, purchases and payments are signed correctly for import.

CSV, QFX or PDF: which Chase download to use

The account activity page offers a download of recent transactions in file types such as CSV, QFX or QBO and OFX, for a limited recent window; Chase may change the options and the window. That file has no opening or closing balance. Monthly PDF statements under Statements & documents go back much further and carry the balances, so use them for older months, for statements you need as the official record, and for reconciling.

Layout gotchas

Chase checking statements print a summary box first (beginning balance, deposits and additions, ATM and debit card withdrawals, checks paid, fees, ending balance). Transactions come later in sections, and the date column shows month/day only, so the year must come from the statement period. Page headers and continuation notes repeat on every page and are skipped.

Get the PDFs from Chase

Sign in at chase.com, open the account, choose Statements & documents, and download each month as a PDF. Then drop them all above. Paid plans convert a full year in one batch and merge them into one file.

How to do it

1. Download your Chase PDF statements.
2. Drop them above and check the balance badges.
3. Export Excel, CSV, QBO or OFX.

Excel and CSV are free for up to 5 pages a day. QuickBooks, Xero and OFX files and batch conversion are on paid plans, from a $9 one-off pass: see pricing or go back to the converter.

Questions

Related guides

• Bank of America statement to Excel
• Wells Fargo statement to Excel
• Capital One statement to Excel
• PDF to QBO (QuickBooks)
• All guides