Skip to the converter
StatementZap

Guides

How to convert a Chase CSV for QuickBooks

Read a Chase checking or credit-card CSV and download a QuickBooks file.

  1. 1

    Download CSV from Chase

    Checking activity uses Details, Posting Date, Description, Amount, Type, Balance, and Check or Slip #. The credit-card file uses Transaction Date, Post Date, Description, Category, Type, Amount, and Memo.

  2. 2

    Let the header match

    Upload the file. A matching header selects the Chase preset. The date used is the posting date. Purchases and withdrawals are negative. Deposits and payments are positive.

  3. 3

    Choose the QuickBooks file

    QuickBooks Desktop: download QBO and import it with Web Connect. QuickBooks Online: download the 3-column CSV and upload that. The card file and the checking file use the same rule for the sign.

  4. 4

    Skip pending rows

    A row that is still pending is left out. Download again after it posts if you need it in the register.

Questions

Which date is the transaction date?

The posting date. The card file also has a transaction date, and the preset keeps the posted date so it matches the statement period.