To upload a credit card statement to QuickBooks Online, first create a Credit card account for the card, then convert the statement's transactions into a CSV, check that charges and payments carry the right signs, and use Upload from file on the Bank transactions screen, choosing the card account rather than a bank account. Review each row before adding it.
Setting up the credit card account before the upload
A credit card account in QuickBooks Online is a chart-of-accounts entry with the Credit card account type, which tracks what the business owes on one card. Card transactions should land in that account, not in a bank account. Create it before the first upload, with an opening balance and an As of date taken from a statement.
Intuit's article Add an account to your chart of accounts in QuickBooks Online gives the path: All apps, then Accounting, then Chart of accounts, then the new account button. Choose the account type. For Bank, Asset, Credit card, Liabilities and Equity accounts, it says to enter an opening balance and a starting date in the As of field, and that the best place to find the balance is the bank or credit card statement.
Pick the As of date with the upload in mind. If the opening balance is the closing balance on the January statement, dated January 25, the first upload should start on January 26. Intuit's article Manually upload transactions into QuickBooks Online says that when an account has an opening balance but no transactions, the file's date range should match the opening balance date.
Choosing the right account at upload time matters as much as creating it. Intuit's article Format CSV files in Excel to get bank transactions into QuickBooks says to choose the credit card account, not a bank account, when uploading a card file into QuickBooks Online.
A CSV is not the only input. Intuit's manual-upload article says the same screen also accepts a statement as a PDF or an image, such as a JPG, PNG or HEIC file, and extracts the transactions from it. You then review a side-by-side comparison, correct any fields and select Save. Whichever input you use, the account choice and the sign check below still apply, so review every row against the statement before it is added.
Name the account so staff can tell cards apart, for example "Example Bank Visa XXXX-4821". A client with two cards from one issuer needs two accounts, or a parent with subaccounts, covered in the last section.
Why do credit card statement signs look backwards in QuickBooks?
Credit card statement signs look backwards because a card statement counts from the card issuer's side. A purchase raises the balance owed, so it often prints as positive, and a payment prints as negative. Intuit's bank example does the opposite, with money out negative. The upload preview shows which way your file reads.
Intuit's CSV formatting article says this directly: CSV files for credit card accounts may display transactions in reverse order, and deposits may appear as negative amounts because paying the card reduces the balance. The same article's 3-column example, for a bank, shows a payment as -100.00 and a deposit as 200.00.
That leaves the firm with a check, not a rule. The screen-by-screen steps for mapping CSV columns on the QuickBooks Online upload screen have their own post. After mapping, look at a charge you know. If a $245.00 restaurant charge appears as money coming in, every sign in the file is reversed. Intuit's manual-upload article says to check whether amounts show correctly as positive or negative, and its video says to select reverse all values when they are reversed.
The 4-column layout replaces the sign with separate Credit and Debit columns, but the direction then depends on which column each amount sits in, so the same preview check applies. Intuit's formatting article says to remove the word "amount" if it appears in either header, so they read only Credit and Debit. Layout details are in what the 3-column QuickBooks CSV layout looks like.
A few cleanup rules from the formatting article apply to every card file. Leave zero cells blank instead of entering 0. Use one date format throughout. Remove numbers from the Description column. Mac users must save the file as a Windows CSV.
Refunds, interest and annual fees on a card statement upload
Refunds, interest and annual fees are the card statement lines that are neither ordinary purchases nor payments. In an upload file, each one is a single row with a date, a description and an amount. A refund takes the opposite sign from a charge. Interest and annual fees take a charge's sign, since both raise the balance.
Refunds are the line people get wrong. A merchant credit of $60.00 lowers the balance, so in the file it sits on the same side as a payment, not a charge. Leaving its sign the same as a purchase records it as a second purchase and overstates spending by twice the refund.
When the refund comes into the books another way, the steps differ. Intuit's article Enter vendor credits and refunds in QuickBooks Online covers a vendor refund made directly to a credit card: select Credit card credit, choose the vendor and the card account, and enter the date, amount and category. It says the category must match the original expense account.
Interest and fees are charges the issuer adds itself. Keep the statement's own description, such as "PURCHASE INTEREST CHARGE" or "ANNUAL MEMBERSHIP FEE", so whoever categorizes the row can see what it is. How each is categorized is a decision for the firm, not the file.
A sample card statement converted into an upload file
This example is fictional. Example Design Studio LLC's card ending XXXX-4821 has a statement for February 26 to March 25, 2026. The statement prints purchases and fees as positive and payments and credits as negative:
| Date | Statement description | Statement amount |
|---|---|---|
| Mar 3 | EXAMPLE CAFE 0217 | 245.00 |
| Mar 9 | EXAMPLE OFFICE SUPPLY RETURN | -60.00 |
| Mar 12 | PAYMENT THANK YOU | -1,500.00 |
| Mar 25 | PURCHASE INTEREST CHARGE | 18.42 |
| Mar 25 | ANNUAL MEMBERSHIP FEE | 95.00 |
Converted into a 3-column upload file following the money-out-negative pattern of Intuit's bank example, the signs flip:
Date,Description,Amount
03/03/2026,Example Cafe,-245.00
03/09/2026,Example Office Supply return,60.00
03/12/2026,Payment thank you,1500.00
03/25/2026,Purchase interest charge,-18.42
03/25/2026,Annual membership fee,-95.00
The store number in "EXAMPLE CAFE 0217" was removed, following the formatting article's rule against numbers in descriptions. The dates use one format. On the upload screen, check that the $245.00 charge shows as money out before continuing. If it shows as money in, use reverse all values.
The net change in the file is 1,201.58 in the card's favour: the payment and refund lower the balance by 1,560.00, and the three charges raise it by 358.42. That should equal the statement's previous balance minus its new balance. If it does not, a row is missing or has the wrong sign.
Should card payments come from the card file or the bank file?
A card payment shows up twice in the source data: once on the card statement as a payment received, and once on the bank statement as money out. It is one transaction. Record it once, as a transfer between the bank account and the card account, and match or pair the other side to it instead of adding it again.
Intuit's article Record your payments to credit cards in QuickBooks Online gives two ways. The manual route is + Create, then under Other, Pay down credit card: choose the card, enter the amount, date and bank account, then Save and close.
The bank transactions route handles a downloaded or uploaded payment. Open the row, set the Transaction type dropdown to Credit Card Payment, select the card account, and look for Pair in the Match/Categorize column; then select Post. If Pair does not appear, the article says to pair manually by selecting the other account, finding the transaction in the Pending tab, and selecting Match. It also says a transfer can record the payment when both accounts are connected.
The double usually happens when both files are uploaded and both rows are added. In the sample, the $1,500.00 payment arrives in the card file and the same $1,500.00 leaves the checking account ending XXXX-1190 in the bank file. Adding both as separate entries records two payments. Post one as the credit card payment and pair the other.
Card balances are proved at reconciliation. The post on how to reconcile credit card statements shows how a doubled payment surfaces there.
Card statement uploads for cards with several cardholders
A card statement with several cardholders is one statement covering employee cards that share a single account, often with a section of transactions for each card number. The upload question is whether all cardholders' transactions go into one QuickBooks card account or into one account per card. Either works if the totals still agree with the statement.
One account is simpler. Upload every cardholder's rows into the single card account and keep the cardholder name or last four digits in the description, for example "Example Cafe (J. Rivera 4821)". The statement balance and the account balance then match directly.
Separate accounts give per-person tracking. Intuit's chart-of-accounts article shows that a new account can be made a subaccount by checking "Make this a subaccount" and choosing the parent, and the manual-upload article suggests setting up parent accounts and subaccounts before uploading. Check the upload target first, though: Intuit's Common errors for importing bank transactions using CSV says not to import into a subaccount, calling it a current limitation. If per-card subaccounts will not take the file, one card account per cardholder works, as long as their totals add up to the one statement.
The payment needs care with subaccounts. The issuer receives one payment for the whole statement, so record it once against the account the issuer bills, then decide how the firm handles it across subaccounts.
Splitting the statement is manual work in either case. Each cardholder section becomes its own block of rows, and one missed page means one missing employee's charges. Reading the statement into a spreadsheet first makes the split easier. Schema CPA classifies credit card statements by issuer and period in a client's file and exports the transactions to Excel or CSV; it has no QuickBooks connection, so the upload is still done in QuickBooks. The document types on the homepage show which statements it reads.
Firms that also keep Xero clients face the same sign and layout questions there. See how to import bank statements into Xero and the Xero bank statement CSV import template.