Good afternoon, Chen.
For bank/credit card accounts that do not offer .iif as an option for transaction downloads, I have been able to import some csv files by including .iif in the file name before the .csv name extension. I make clear column headings to include DATE mm/dd/yyyy, DESCRIPTION, SPENT (for credit card charges) RECEIVED (for credit card credits and payments on account). This works better for me than having the debits and credits in one column.
I have not tried this personally, but here is a link to a post regarding a QuickBooks Import Excel and CSV toolkit. If you try this method, I'd be interested to hear how it works for you! https://quickbooks.intuit.com/learn-support/en-us/manage-lists/import-export-csv-files/00/201366
Cindy Steel
Ray CPA PC
Round Rock, TX
