Should Credit Card Charges Be Positive or Negative in QuickBooks?

In a QuickBooks credit card account, a charge must be a negative number in the Amount column, and a payment or refund must be positive. If you import a CSV where purchases are positive, QuickBooks reads every one of them as money paid toward the card, your balance walks in the wrong direction, and the reconciliation will never clear.

The frustrating part is that the file is not wrong. Your issuer exported it correctly, from its own point of view. The two points of view simply disagree, and QuickBooks does not translate between them.

Why the signs feel backwards

You will read, in a lot of places, that credit card accounts are the opposite of bank accounts in QuickBooks. That is not quite true, and the imprecision is what confuses people.

The numeric rule is identical for both: negative means money out. A withdrawal from checking is negative. A charge on a card is negative. Both increase what you owe or reduce what you hold.

What actually differs is the file you were handed. Card issuers write statements and exports from the issuer's perspective, where a purchase is an amount you now owe them, so they print it as a positive number. Bank exports are written from your perspective, where a withdrawal leaves your account, so they print it as negative. Same rule in QuickBooks, opposite input files.

The sign QuickBooks expects

Every issuer does it differently

If you are merging cards from several issuers into one file, the sign problem multiplies, because the issuers do not even agree with each other. Some use a single signed Amount column. Others split the amount across a Debit column and a Credit column, filling only one per row.

Look at Chase and Discover. Both use one Amount column, and they sign purchases oppositely. Concatenate an untouched Chase file and an untouched Discover file, sum the column, and your spending partially cancels itself out. The total will look plausible, which is exactly what makes it dangerous.

How to fix the sign before importing

Three approaches, in ascending order of how much you will enjoy them.

1. Flip the sign with a helper column

Add a column next to Amount with the formula =B2*-1, fill it down, copy the result, and paste it back over the original column as values. Delete the helper. This works, and it is fine once. It is miserable across twelve statements and four cards, and one missed row produces a reconciliation difference you will hunt for an hour.

2. Use the four column layout instead

QuickBooks Online accepts a CSV with Date, Description, Credit, and Debit columns rather than Date, Description, and Amount. Put charges in Debit and payments in Credit, both as positive numbers, and the sign question disappears entirely because the column name carries the direction. Issuers that already split Debit and Credit, such as Capital One and Citi, map almost directly into this layout.

One caveat: if a period contains only money out and no money in, QuickBooks can reject the four column file. Add an offsetting line or switch back to the three column layout for that period.

3. Import a QBO file and skip the question

A Web Connect .qbo file encodes the direction of each transaction inside the file format, so there is no Amount column to sign and nothing to flip. It also carries transaction identifiers, which is how QuickBooks recognizes a charge it has already imported and refuses to add it twice. This is the only option that works in QuickBooks Desktop, which cannot import a CSV of transactions at all.

If your statements arrive as PDFs, converting them straight to a QBO file for QuickBooks means you never touch a sign, a helper column, or a mapping screen. For teams whose books live entirely inside QuickBooks, a dedicated statement to QuickBooks converter does nothing but that one conversion.

I already imported them backwards. Now what?

Do not fix them one at a time in the register. Undo the batch and re-import.

1. Go to Transactions, Bank transactions, and open the account.
2. In the For Review tab, select the incorrectly imported rows and exclude them. If you already added them to the register, find them in the Categorized tab and undo, then exclude.
3. Fix the sign in the source file, or convert the statement to a QBO file instead.
4. Import again and confirm that a purchase now appears as a charge increasing the balance owed.

Check one row before you accept two hundred. Open the register, find a purchase you remember making, and confirm it increased what you owe on the card. If it reduced the balance, the sign is still inverted and importing the rest will just multiply the cleanup.

Why this matters beyond the balance

An inverted sign does not only break the card balance. It flips the expense too. Purchases posted as payments never land in an expense account, so your profit and loss understates costs, your tax deductions go missing, and the difference hides inside a liability account nobody looks at until the year end review.

That is why it is worth checking on the first import rather than the twelfth. One row, one glance, thirty seconds. Then reconcile the card against the statement ending balance and let the zero difference confirm the whole file.

The short version

Charges negative, payments positive. Your issuer wrote the file the other way around, and QuickBooks will not translate it for you. Flip the sign, use the Debit and Credit columns, or convert the statement to a QBO file and stop thinking about signs altogether.