Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowThanks, James
It's an AMEX credit card CSV file that I downloaded from AMEX. After receiving an error for the date format, I modified the CSV so that the date is in mm/dd/yyyy. The AMEX CSV file has three fields:
Date
Payee
Amount
Importing into QB, I match up the fields as follows:
QB date = AMEX date
QB description = AMEX payee
QB amount = AMEX amount
The AMEX CSV file has both positive (charges) and negative (payments), so I select the option "1 column: both positive and negative numbers".
There is no error during the upload. All of the transactions load. However, the positive amounts (which were charges on the AMEX -- so corporate expenses and payments to a vendor) are uploaded to the QB "Received" column. Negative amounts (which are company payments made to AMEX to pay the charged amounts) are uploaded to the QB "Spent" column.
This is the exact opposite of what I was expecting. I was expecting charges made on the AMEX card to be imported as "Spent" on the AMEX register, and payments made to AMEX to be recorded as "Received" on the AMEX register.
I cannot change the amounts so that they are in the correct QB column.