How to fix credit card amount signs in QuickBooks
Make card purchases money out and payments money in before you import.
- 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
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
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
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.
- A month of only purchases, with no payment, is the easiest file to reverse by mistake. The page says when the signs could go either way.
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.