Skip to the converter
StatementZap

Guides

How to convert an Amex CSV for QuickBooks

Read an American Express CSV where charges are positive and download a QuickBooks file.

  1. 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. 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. 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. 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.

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.