How to convert a Chase statement PDF to Excel or CSV

If you have a Chase account and need your transactions in a spreadsheet, you can convert the statement PDF on your own computer with StatementLocal. The file is read inside your browser and is never uploaded.

Step 1: download the statement PDF

  1. Sign in to Chase's website on a computer. Banking apps often show a statement without an easy way to save the PDF.
  2. Open the statements or documents section for the account. Banks usually call it something like Statements, or Statements and documents. Menus change, so Chase's own help pages are the final word on where it is.
  3. Choose the statement period and download the PDF. Save it where you can find it.
  4. Use the PDF exactly as downloaded. A statement that was printed and scanned back in has no text layer, and this version of StatementLocal cannot read scans.

Step 2: convert it

  1. Open the StatementLocal converter.
  2. Drop the PDF on the page, or choose it.
  3. Read the verdict at the top of the result:
    • Reconciled: the rows add up from the printed opening balance to the printed closing balance.
    • Off by $X, check rows N to M: something does not add up. The likely rows are highlighted.
    • Cannot check: the statement prints no balances to check against.
  4. If a row is wrong, fix it in the grid. The verdict updates when you leave the cell.
  5. Download CSV, Excel (.xlsx) or QuickBooks CSV. You can download 3 statements a day free.

Then import it into QuickBooks Online

StatementLocal's Download QuickBooks CSV button writes three columns, Date, Description and Amount, with dates as MM/DD/YYYY and money going out as negative numbers. That is the layout QuickBooks Online accepts when you upload a bank file.

  1. In QuickBooks Online, open the bank account you want to fill and choose the option to upload transactions from a file. QuickBooks moves its menus from time to time; its own help page on uploading bank transactions is the final word.
  2. Choose the CSV you downloaded.
  3. When QuickBooks asks which column is which, pick Date, Description and Amount, and say the amounts are in one column.
  4. Review the transactions before you accept them. If the statement said Reconciled, its amounts add up to its own printed balances, so a difference in QuickBooks usually comes from transactions already in the account, a duplicate upload or a date to check.

Upload one statement at a time and in date order. Uploading the same month twice creates duplicates that QuickBooks will not always catch.

What has and has not been tested

We tested StatementLocal on 200 synthetic (made-up) statements across 10 common US statement layouts, built by our own generator. Every statement it could not verify was flagged with Off by or Cannot check, never shown as Reconciled. We have not tested it on real Chase statements, and we do not claim it reads every one. That is why every conversion is checked against the statement's own printed balances: if an amount is missed or misread, the totals stop adding up and you see Off by instead of Reconciled.

More answers are in the FAQ, and the privacy page lists exactly what the page sends (nothing, unless you use Pro).

StatementLocal is not affiliated with, endorsed by or sponsored by Chase or its parent company. The name is used only to say whose statements this guide is about.

Need more than 3 statements a day? Buy the 30-day pass for $9 or Buy Lifetime for $39. One-time payments, taken by Stripe. Sold to US customers only.

Use Chrome? The same converter is also a Chrome extension: Add to Chrome from the Chrome Web Store.