Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
kencor
Level 1

Reply to message

Thanks, 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.

 

Need to get in touch?

Contact us