# Import Credit Card Transactions into QuickBooks Online

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-16
- Category: QuickBooks Online imports
- Canonical: https://simplebankconvert.com/blog/import-credit-card-transactions-into-quickbooks

> Import credit card transactions into QuickBooks from a statement or download: set up the card account, get charge signs right and record payments once.
To import credit card transactions into QuickBooks, first create the card as a credit card account, then upload a CSV or QBO file of its charges into that account. Check that charges and refunds point the right way in the preview, and record the payment you make to the card in only one place.

## Setting up a credit card account before the import

A credit card is not a bank account in QuickBooks. It is its own account type, credit card, and it must exist before you upload. The upload screen asks which QuickBooks account the file belongs to, and for a card file the answer has to be a credit card account.

### Why the type matters

Intuit's guide to [formatting CSV files for bank upload](https://quickbooks.intuit.com/learn-support/en-uk/help-article/bank-transactions/format-csv-files-excel-get-bank-transactions/L4BjLWckq_GB_en_GB) says that payments on a credit card may appear as negative deposits, and that you should select a credit card account in QuickBooks, not a bank account, when you upload. The reason is that the two types read the same amount in opposite directions. A bank account balance is money you have. A card balance is money you owe.

### Creating the account

On the upload screen, the QuickBooks account dropdown offers Add New when the account is missing. Choose it, set the account type to credit card, and name it for the real card, for example "Visa business 2210" using the last four digits. If you have several cards, a distinct name per card keeps the files from landing in the wrong place. Creating an account from the chart of accounts instead is covered in [adding the account to the chart of accounts](/blog/how-to-import-bank-account-into-quickbooks#adding-the-bank-account-to-the-chart-of-accounts).

### Where the upload starts

The file goes in through the same Bank transactions page as any other. The screens are set out in [how to import bank transactions into QuickBooks Online](/blog/how-to-import-bank-transactions-into-quickbooks-online), and the card steps differ only in the account you pick.

### What you need from the card issuer

Download either a transaction file or a statement. Many card issuers let you download recent activity as CSV or QBO from their website. If you only have a PDF statement, you need to turn it into a CSV or QBO file first. SimpleBankConvert is built to turn a PDF bank or card statement into an import file, and you can ask for a place before it opens at [the get started page](/get-started).

### Opening balance

The first import into a new card account does not set what you owed on the day you started. If the card had a balance before your first file, enter that starting balance separately, or your account will not match the statement. Ask whoever set up your books how they want it recorded.

## Are credit card charges positive or negative in the file?

In a three-column file, treat a charge as money out and a refund or payment as money in, which makes charges negative and refunds positive. Card issuers differ, though, and many export charges as positive numbers. The preview on the review screen shows which way QuickBooks reads your file, and it can reverse all values.

### Why card files differ from bank files

On a bank statement, a purchase takes money out and is shown as a minus or in a Withdrawals column. A card statement is built around what you owe, so the issuer often lists purchases as positive amounts and payments as negative ones. The same word, "positive", means opposite things in the two files. American Express has its own conventions, set out in [Amex charges, credits and the sign each needs](/blog/how-to-import-amex-statement-into-quickbooks#amex-charges-credits-and-the-sign-each-needs).

### The worked example

Here are five lines from a card statement, as the issuer prints them, and as the import file needs them. The merchants and amounts are made up for illustration.

| Date | Description | As printed on the statement | As the import file needs it |
| --- | --- | --- | --- |
| 03/04/2026 | Office supply store | 62.15 | -62.15 |
| 03/07/2026 | Fuel station | 48.30 | -48.30 |
| 03/11/2026 | Online software | 19.00 | -19.00 |
| 03/18/2026 | Office supply store, refund | -62.15 | 62.15 |
| 03/25/2026 | Payment, thank you | -129.45 | 129.45 |

Three charges become negative, and the refund and the payment become positive. The statement shows purchases as positive, so every sign flips. If your issuer prints them the other way, the file already matches and needs no change.

### Test with one row

Do not guess from the issuer's convention. Upload the file, reach the review screen, and read one charge you recognize. It should show as money out. Then read the payment, which should show as money in. If both are wrong, [Intuit's manual upload steps](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) give an option to reverse all values. If only some rows are wrong, repair the file instead.

### Using the four-column layout instead

If the file has separate columns for charges and for payments, you can keep them as a four-column file, with each amount in one column and the other blank. Rename the headers to Credit and Debit, with no extra words, as Intuit's formatting guide requires. The details of both layouts are in the post on [mapping CSV columns in QuickBooks](/blog/quickbooks-import-csv-transactions).

### Making the signs consistent

SimpleBankConvert's homepage says it merges separate withdrawal and deposit columns into one amount, with money going out shown as a minus. Whatever made the file, confirm the signs in the preview, because the preview is what QuickBooks will act on.

## Card payments from your bank, recorded once, not twice

The payment you make to a credit card appears on two statements: as a withdrawal from your bank account and as a payment on the card. Record it once, as a transfer between the two accounts, not as an expense in one and a deposit in the other. Otherwise your books count the same money twice.

### How the double count happens

Suppose you pay the card $129.45 from checking. The bank file has a payment line, and the card file has a matching payment line. If you import both and categorize the bank line as an expense, your costs rise by $129.45, even though you only paid off purchases that were already counted as expenses when you made them. The result is an overstated expense and a card balance that does not match.

### The fix: treat the payment as a transfer

The payment is movement between two accounts you own, so it should be a transfer. When you review the bank line, record it as a transfer to the credit card account. When you review the card line, match it to that transfer instead of adding a new entry. The match ties both sides together, and the card balance falls by the payment.

### Which side to import first

Import both accounts for the same period before you review either. Seeing both queues makes it easier to spot the pairs. If you review the bank side first, the card side will already have a transfer waiting for the matching payment line.

### Check the result

After review, the payment should appear as a transfer in each account's register and nowhere in the expense accounts. Your profit and loss should not show a line for the card payment. If it does, you recorded it as an expense. Open that bank line and change it to a transfer.

## Refunds and credits on a credit card statement

A merchant refund is money coming back onto the card, so it shows as a positive amount in the file, as in the worked example above. When you review it in QuickBooks, record it as a credit or a negative expense in the same category as the original charge, not as income.

### Why not income

A refund reverses an earlier purchase. If you book it as income, your sales look larger, and your expense category for that purchase stays too high. Putting the refund against the original category brings both back to the true figures.

### Matching a refund to its charge

In the example, the $62.15 refund cancels the $62.15 charge on March 4. When the amounts match, you can use the matching tools on the review screen to link them, or categorize the refund to the same account as the charge. Either way, the net effect on that category for the month is zero.

### Partial refunds and fees

A partial refund is the same idea with a smaller number. A fee the issuer charges, such as interest or an annual fee, is not a refund. It is a charge, and it belongs in a bank charges or interest expense category. Interest and fees often appear only on the statement and not in a transaction download, so compare the total of your imported lines with the statement's.

### Statement credits

Cashback credits and statement credits arrive as positive lines that look like refunds. Treat them according to what they are. Cashback is generally a reduction of cost or other income, and your accountant can tell you which treatment applies to your business. If you are unsure, enter the line, flag it and ask.

## Does QuickBooks import card transactions per cardholder?

No. The QuickBooks upload brings in a transaction list for one account, and the accepted layouts have no cardholder column. A statement with several cardholders goes in as one set of lines for one card account. To track who spent what, add that detail yourself in a description, a class or a tag.

### What the layouts allow

The three-column and four-column CSV layouts hold a date, a description and an amount, or the two money columns. There is no field for an employee or a card number, so the upload cannot split rows by person. A QBO file also belongs to one account.

### Keeping the cardholder in the description

Many statements print each cardholder's name or last four digits above that person's section, not on every line. When you build the CSV, you can add the name to the description, for example "Sam: fuel station". Intuit's formatting guide says to avoid numbers in the description, so use the name, not the card digits.

### Separate cards, separate accounts

If each person has a different card number with the same issuer, treat each card as its own credit card account in QuickBooks and import its file separately. This keeps balances per card and makes the statement check simple. A single shared account is easier on the bookkeeping, but it cannot answer "who spent this" without extra notes.

### When rows need adding by hand

A few lines that do not appear in any download, such as a cash advance noted on paper, are quicker to type. The post on [adding a transaction by hand in QuickBooks Online](/blog/how-to-manually-add-a-transaction-in-quickbooks-online) shows the form. For adjustments that touch several accounts at once, the guide to [importing journal entries into QuickBooks Online](/blog/import-journal-entries-into-quickbooks-online) is the next place to look. For one issuer's file in particular, see the steps to [import an American Express statement into QuickBooks](/blog/how-to-import-amex-statement-into-quickbooks).