How to convert a Chase CSV for QuickBooks
Read a Chase checking or credit-card CSV and download a QuickBooks file.
- 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
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
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
Skip pending rows
A row that is still pending is left out. Download again after it posts if you need it in the register.
- If the columns do not match either Chase layout, map Date, Description, and Amount yourself. The preset only applies when those headers are present.
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.