Skip to the converter
StatementZap

Guides

How to fix credit card amount signs in QuickBooks

Make card purchases money out and payments money in before you import.

  1. 1

    See which way the file points

    QuickBooks wants a purchase as money out and a payment as money in. In the download that is a negative purchase and a positive payment. Many card sites show the charge as a positive number instead.

  2. 2

    Use the bank preset when there is one

    Chase, Bank of America, and Citi card files already show purchases as negative. American Express shows charges as positive, and the Amex preset reverses them. Capital One puts charges in a Debit column, which is read as money out.

  3. 3

    Flip the signs when the import is backwards

    If QuickBooks shows purchases as deposits, or payments as charges, the signs are reversed. On the converter, choose Flip signs and download again. Do this before importing. An import that already landed cannot be unsigned by downloading a second file.

  4. 4

    Check one purchase and one payment

    A grocery charge should be negative. A payment that reduces the balance should be positive. When both look right, download QBO for Desktop or the 3-column CSV for QuickBooks Online.

Questions

Does flipping the signs change the dates?

No. Flip signs changes the direction of the amounts. Dates, payees, and check numbers stay as they were.