How to convert an Amex CSV for QuickBooks
Read an American Express CSV where charges are positive and download a QuickBooks file.
- 1
Download the CSV
One Amex export includes Extended Details and Appears On Your Statement As. A shorter card-member file is Date, Description, and Amount. Charges are positive numbers. A payment is negative, or it is the amount that reduces what you owe.
- 2
Use the Amex preset
Choose Amex after you upload, or let the header match. The preset treats a positive charge as money out, which is what QuickBooks should show for a purchase. The two Amex layouts share that one control, and the file is read with the layout whose columns are actually present.
- 3
Check a payment
A payment should be money in. If the whole file is purchases and every amount is still positive after the preset, flip the signs before you download.
- 4
Download for the QuickBooks you use
Desktop gets a QBO file. QuickBooks Online gets the 3-column CSV, with purchases negative and payments positive.
- A month of only purchases, with no payment row, is the case that is easiest to reverse. The page says when the signs could go either way.
Questions
Why are card charges negative in the download?
In the books, a charge is money out. The Amex CSV shows it as a positive charge. The preset reverses that column.