A credit card statement and QuickBooks look at the same number from opposite sides. The issuer reports what you owe, so a purchase adds to the balance and usually prints as a positive figure. In a file QuickBooks reads, a purchase is typically a negative amount and a payment or refund is positive, exactly as money out and money in are on a bank account. Convert a statement without translating between the two and every line lands backwards.
The statement identity, in both directions
Every card statement obeys one equation: previous balance + purchases + fees + interest − payments − credits = new balance. Take a previous balance of 1,200.00, purchases of 845.30, fees of 35.00, interest of 22.15, a payment of 1,200.00 and credits of 45.00. The new balance is 857.45. In QuickBooks direction the amounts are −845.30, −35.00, −22.15, +1,200.00 and +45.00, which total 342.55. That equals the previous balance minus the new balance, and it is the check to run on any card file.
Labels settle most doubts. Purchases, cash advances, balance transfers, fees and interest increase the balance, so they are negative in the file. Payments, refunds, merchant credits and rewards credits reduce it, so they are positive. If the total comes out as the negative of the expected number, every sign is backwards. If it is off by twice one group, that group has the wrong sign: a payment entered as −1,200.00 instead of +1,200.00 gives a total of −2,057.45, which is 2,400.00 short.
Card statements rarely print a running balance, so there is no row-by-row chain to point at a bad line. Work from the summary box instead. It lists totals for purchases, payments, credits, fees and interest; total your rows for each group and match them one by one. A net that ties can still hide offsetting mistakes, but group totals cannot.
How issuers print signs
Layouts differ between issuers. Identify which one you have before you touch a column.
| Layout | What it means | For QuickBooks |
|---|---|---|
| Purchases positive, payments negative or bracketed | The balance-owed view | Flip every sign |
| Payments and credits marked CR, purchases unmarked | CR marks money that reduces the balance | Make CR amounts positive and the rest negative |
| Separate Charges and Payments columns, all positive | The column decides direction | Charges negative, payments positive |
| Trailing minus, such as 45.00- | Negative as printed, often a refund or payment | Read each line against its label first |
| Purchases negative, payments positive | Already matches QuickBooks | Leave as is and run the total check |
Step by step: set the direction before you import
- Find the summary box. Copy the previous balance, purchases, payments, credits, fees, interest and new balance from the first page of the statement.
- Identify the layout. Use the table above to decide whether the printed signs match QuickBooks or must be flipped.
- Set the signs. Make purchases, cash advances, fees and interest negative. Make payments, refunds and credits positive.
- Run the total check. The signed amounts must add up to the previous balance minus the new balance. A previous balance of 0.00 and a new balance of 400.00, for instance, means the file should total −400.00.
- Upload to the card account. In QuickBooks Online choose Bank transactions, then Link account, then Upload from file, and pick the credit card account, not a bank account. Menu names move between versions.
- Check the preview and the balance. In the preview, confirm one purchase shows as money spent and one payment as money received. After the import, the card’s balance should equal the statement’s new balance.
The same rule holds for CSV uploads, but the direction then depends on your column mapping. QuickBooks Online typically lets you map one amount column or separate money in and money out columns, so confirm what the preview shows.
What can go wrong
- A file that ties out but runs backwards. A card statement can pass its own balance check in the issuer’s convention and still carry every sign the wrong way for QuickBooks. Only the previous-minus-new total shows it.
- A bank file in a card account. Pick the credit card account when you upload. A bank-type file loaded into a card account, or the reverse, can be refused or post inverted.
- The payment counted twice. It is money out on the bank statement and money in on the card statement. Book one transfer, not an expense plus a payment.
- Refunds booked as income. A refund reduces the balance and belongs against the original expense, not in income.
- Two date columns. Statements often list a transaction date and a posting date. Use the posting date so the month matches the statement period.
- Foreign-currency lines. A line in another currency may print both the original and the converted amount. Use the billed-currency figure, or the total check will fail.
- Cardholder subtotals. Statements with several cards show subtotals per cardholder. They are not transactions and double the total if included.
Where SheetParser fits
SheetParser reads a card statement into one row per transaction and keeps every sign as printed, with no guessed flip. Its balance check compares the statement’s own figures, so a file can tie out and still run backwards for QuickBooks, and on a card statement printed in the issuer’s convention the Money In column can hold purchases. Apply the total check and the preview check above before you accept anything. Start with the credit card statement to Excel tool; 1 file a day is free up to 10 pages, and paid plans open files up to 150 pages. The balance-check guide explains how to read any difference.