Statement converter
Chase bank statement to Excel
Download the PDF from Chase, drop it here, and get a spreadsheet with the beginning balance, each transaction, and a pass or fail on the ending balance.
Where to download the PDF
In chase.com, open the account, then Statements & documents, and download the PDF. Use that file, not a photo of the paper statement that arrived in the mail. If you can highlight a description with your mouse, the file has a text layer and Northline can read it.
Chase Total Checking and similar deposit statements put the year in the statement period and print transaction dates as month and day only. Northline takes the year from that period, including statements that run from December into January.
What gets read
The usual transaction detail is Date, Description, Amount, and a running Balance. Deposits are positive. Withdrawals, card purchases, ATM withdrawals, and fees are negative. A description that wraps onto the next line is kept with the same transaction instead of becoming a second row.
Beginning Balance and Ending Balance in the account summary are the two numbers the reconciliation uses. Opening balance plus the signed amounts has to equal the ending balance. If a running balance on a single row does not follow from the row above it, that row is highlighted even when the final totals agree.
Before you book it
Chase sometimes prints a transfer or a Zelle payment with a truncated name. You can edit the description, split a row, or fix an amount before export. Excel, CSV, and QBO all use the edited table, not the first parse.
Pages are counted from the PDF, including a second page that only continues the same table. A file we cannot read is not charged.
Questions
Does this work for Chase credit cards?
Credit cards use a different layout. Use the Chase credit card page for Sapphire, Freedom, and other card statements.
Will a scanned Chase statement work?
No. If the PDF is only an image, Northline stops and says so. Download the digital statement from the website.
Northline is not affiliated with the bank named on this page. This is not tax or financial advice. Compare the export to the original statement. Read the disclaimer.