How to import credit card transactions into QuickBooks Online and Desktop (CSV, Excel or PDF)
QuickBooks can take a credit card's transactions without a bank connection, but the route depends on which QuickBooks you have and what file you're starting from: the card issuer's CSV or Excel download, a .QBO Web Connect file, or only the PDF statement. This guide covers each one for QuickBooks Online and QuickBooks Desktop, the sign rules that trip up most card imports, and how to check that every charge and payment came in.
Short answer: in QuickBooks Online, go to Bank transactions → Link account ▾ → Upload from file, upload a CSV (Date, Description, Amount), .QBO or .QFX, and pick the credit card account, not a bank account. In QuickBooks Desktop there's no CSV import for card transactions: import a .QBO with Banking → Bank Feeds → Import Web Connect Files on a supported version, an .IIF file (File → Utilities → Import → IIF Files) on any version, or paste from Excel with Batch Enter Transactions in Accountant and Enterprise. Only have PDF statements? Convert them with credit card statement to CSV or straight to .QBO / .IIF.
See a card statement turned into QuickBooks files
Open Utilly's fictional September 2026 card statement (card ending 7316, 21 transactions: 19 charges totalling 1,939.94 and 2 payments and credits totalling 1,542.18) in the converter. You get the QuickBooks Online CSV, the .QBO and the .IIF, each checked against the 3,243.88 new balance, all free because the data is made up. Your own card PDF gets a free preview.
- Which route fits your QuickBooks
- QuickBooks Online: upload a CSV, .QBO or .QFX
- QuickBooks Online: from Excel
- QuickBooks Online: from a PDF statement
- QuickBooks Desktop: Web Connect (.QBO)
- QuickBooks Desktop: IIF file
- QuickBooks Desktop: from Excel (Batch Enter)
- Charges, payments and the minus sign
- Check the import against the statement
- Common problems
- Convert your own card statement
1. Which route fits your QuickBooks
| You have | QuickBooks Online | QuickBooks Desktop |
|---|---|---|
| The issuer's CSV download | Upload from file, 3- or 4-column CSV | No CSV import. Convert to .QBO or .IIF, or use Batch Enter (Accountant, Enterprise) |
| An Excel file | Save as CSV, then Upload from file | Excel to IIF or Excel to QBO, or Batch Enter |
| A .QBO / .QFX download | Upload from file takes .QBO and .QFX | .QBO via Import Web Connect Files, supported versions only; .QFX convert with QFX to QBO |
| Only the PDF statement | Upload the PDF (QuickBooks reads it), or convert first and check the balance | Convert to .QBO or .IIF: statement to QuickBooks |
| Desktop 2023 after May 31, 2026 | n/a | IIF or Batch Enter only: Web Connect stopped with online banking |
Whichever you choose, the transactions must go into a credit card account in your chart of accounts. Intuit's own tip for card files is to choose the credit card account, not a bank account, when you upload.
2. QuickBooks Online: upload a CSV, .QBO or .QFX
- Download the transactions from the card issuer's site as CSV, or as QuickBooks (.QBO) or Quicken (.QFX) if it offers those. Intuit suggests .QBO.
- In QuickBooks Online go to Bank transactions. If the card already has a tile, select it.
- Open Link account ▾ and choose Upload from file (with nothing connected yet you may see an option to upload transactions manually instead).
- Upload the file. Intuit's limits for transaction files: 350 KB or less and up to 1,000 lines per upload, English. Split a long history into months.
- In the QuickBooks account ▾ list, pick the card's credit card account, or Add New to create one.
- For a CSV, map the columns: Date, Description and either one Amount column or separate Credit and Debit columns. Check the preview and select the transactions to import.
- The transactions land on the For review tab. Match or categorize each one, then reconcile the card.
The CSV layout Intuit accepts is the same for banks and cards. For a card, the 3-column version looks like this, charges negative and payments and returns positive (the first rows of the sample's QuickBooks Online CSV):
Date,Description,Amount
09/01/2026,GOOGLE WORKSPACE CC GOOGLE COM,-72.00
09/02/2026,DELTA AIR LINES 0062 ATLANTA GA,-418.60
09/05/2026,PAYMENT THANK YOU - WEB,1500.00Ready-made files in Intuit's layout, including a credit card version with known totals, are on the QuickBooks Online CSV import template. The same screen for bank accounts, with missing months and upload errors, is in importing bank transactions into QuickBooks Online.
3. QuickBooks Online: from Excel
Upload from file doesn't take .xlsx, so save the sheet as CSV first (File → Save As → CSV; on a Mac, Intuit says to save it as a Windows CSV). Before you upload, apply Intuit's formatting rules: dates in one format, no day-of-week text in the date column, no zeros (leave those cells blank), no numbers-only descriptions, and headers that read just Credit and Debit if you use the 4-column layout. Intuit's article also warns that card CSVs "may display transactions in reverse order", meaning payments can show as negative because they reduce the balance. If yours does that, flip the signs before uploading, or let a converter do it. To check a file against all of these rules, use the free QuickBooks Online CSV checker.
4. QuickBooks Online: from a PDF statement
QuickBooks Online can read a PDF or image statement itself: same Upload from file screen, pick the credit card account, then check its side-by-side view before you save. That's free and built in. What it doesn't do is prove that every line was caught. Utilly reads a text-based card PDF and checks the transactions against the statement's previous and new balance before you import anything, then writes a QuickBooks Online CSV or .QBO. Step by step, and how to tie out QuickBooks' own extraction: uploading a PDF statement to QuickBooks Online.
5. QuickBooks Desktop: Web Connect (.QBO)
- Back up the company file.
- Download the card's activity as a QuickBooks Web Connect (.QBO) file, or convert the CSV or PDF to .QBO.
- Sign in to your Intuit account in QuickBooks, then choose Banking → Bank Feeds → Import Web Connect Files (or File → Utilities → Import → Web Connect Files).
- Choose the existing credit card account, not a new one, unless you mean to create it.
- Review the transactions in the Bank Feeds center, add or match them, then reconcile.
A card .QBO is the credit-card version of the file: its account block is <CCSTMTRS> and <CCACCTFROM> rather than the bank one, so QuickBooks knows it belongs in a credit card account. Two limits: Intuit says Web Connect "only works with .qbo files" (rename a .qfx and it still fails; use QFX to QBO), and Web Connect is part of online banking, which Desktop 2023 lost after May 31, 2026. On that version use IIF. Error codes such as OL-222 are covered in .QBO Web Connect import errors.
6. QuickBooks Desktop: IIF file
IIF is a tab-separated text file that every Desktop version imports locally, with no online banking needed. Card transactions use two types: CREDIT CARD for charges (negative on the card line) and CCARD REFUND for payments and returns (positive). Each has a TRNS line for the card account, an SPL line for the other side and an ENDTRNS line. From the sample's .IIF:
!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT MEMO
!SPL TRNSTYPE DATE ACCNT NAME AMOUNT MEMO
!ENDTRNS
TRNS CREDIT CARD 09/01/2026 Credit Card -72.00 GOOGLE *WORKSPACE CC@GOOGLE.COM
SPL CREDIT CARD 09/01/2026 Uncategorized Expense 72.00 GOOGLE *WORKSPACE CC@GOOGLE.COM
ENDTRNS
TRNS CCARD REFUND 09/05/2026 Credit Card 1500.00 PAYMENT THANK YOU - WEB
SPL CCARD REFUND 09/05/2026 Uncategorized Income -1500.00 PAYMENT THANK YOU - WEB
ENDTRNS- Replace
Credit Cardwith the exact name of your card account from Lists → Chart of Accounts. If a name doesn't match, QuickBooks creates a new account with that name. - Back up, switch to single-user mode, then File → Utilities → Import → IIF Files.
- If you see File not imported, use Review now and fix the ERROR rows (IIF import errors).
- IIF transactions post straight to the register, with no matching step, so reconcile the card against the statement right away.
A card payment from your checking account is one transfer: if checking is also imported, keep the payment on one side only, or you'll count it twice. Run any file through the free IIF file checker first. The full walkthrough for a Desktop file without bank feeds is in importing bank transactions into QuickBooks Desktop without bank feeds.
7. QuickBooks Desktop: from Excel (Batch Enter)
Intuit says only QuickBooks Desktop Accountant and Enterprise batch enter transactions from Excel or CSV into bank, credit card, AR and AP registers. Pro and Premier don't have it.
- Back up. Choose Accountant → Batch Enter Transactions.
- Set the transaction type to Credit Card Charges and pick the card account.
- In Excel, arrange your columns in the same order as the Batch Enter window, copy the charge rows, right-click the first date field and choose Paste. Names or accounts shown in red aren't in your lists yet: Quick Add or Set Up.
- Save Transactions, then Yes.
- Repeat with the type set to Credit Card Credits for payments and returns. One batch holds one type, so sort the sheet into charges and credits first, and enter the amounts as positive numbers in each.
On Pro or Premier, convert the sheet to IIF with Excel to IIF instead.
8. Charges, payments and the minus sign
Most failed card imports aren't rejected files; they're files that import with every amount backwards, so charges show as payments and the balance grows the wrong way. The rule QuickBooks Online and the IIF format follow is the cardholder's side: a charge is negative (it increases what you owe), and a payment, return or credit is positive. Issuers' own CSVs vary. Some write purchases as positive numbers, some put a Type column (Sale, Payment, Return) next to unsigned amounts, and PDF statements print credits as negatives or with "CR". Check two rows before you upload: a purchase must be negative and the monthly payment positive. If it's the other way round, flip the column (in Excel: an empty column with =-C2, fill down, paste as values). Utilly's converter reads the Type column and the statement's sections and signs the rows for you; you can also set the account type to Credit card in the preview.
9. Check the import against the statement
Before you categorize anything, confirm the count and the totals. With the sample statement the numbers that should appear are:
| Check | Sample card 7316, September 2026 | If it's off |
|---|---|---|
| Transactions | 21 | 42 means it was imported twice; fewer means rows were skipped or deselected |
| Charges (negative) | 19, totalling 1,939.94 (purchases 1,918.58 + interest 21.36) | Missing interest or fees is the usual gap |
| Payments and credits (positive) | 2, totalling 1,542.18 (a 1,500.00 payment and a 42.18 return) | If these show as charges, the signs are flipped |
| Net change | −397.76 | Must equal previous balance minus new balance |
| Balance owed | 2,846.12 → 3,243.88 | Reconcile the card account to the new balance |
Then reconcile in QuickBooks with the statement's closing date and new balance. If the difference isn't zero, the free reconciliation discrepancy guide walks through finding it, and duplicate transactions after import covers overlaps with a card feed.
10. Common problems
| What happens | Likely cause | What to do |
|---|---|---|
| Charges show as payments | The issuer's CSV writes purchases as positive | Flip the sign of the amount column, or convert with CSV to QBO |
| QuickBooks Online won't read the CSV | Extra account line above the header, zeros, mixed date formats, a Mac CSV | Fix per Intuit's rules or run the CSV checker |
| Upload refused as too large | Over 350 KB or 1,000 lines | Split into months |
| Transactions went into checking | A bank account was picked at upload | Exclude them, then upload again into the credit card account |
| Desktop: "unable to verify the Financial Institution Information" | Web Connect on an unsupported version (Desktop 2023 after May 31, 2026), or a renamed .qfx | Use IIF instead |
| Desktop: a new account appeared | The IIF account name didn't match the chart of accounts | Merge it into the card account, fix the name in the file next time |
| The card payment is counted twice | It came in from both the checking and the card import | Keep one side, or match it as a transfer |
| No CSV or QBO for older months | Issuers' downloads go back a year or two; statements stay longer | Start from the PDF statement |
11. Convert your own card statement
Have the issuer's PDF or a messy CSV? Each converter shows every transaction and the balance check before you download. Free up to 100 rows for CSV, Excel and OFX files, with a free preview for PDFs. Files are read in memory and not stored.
Get your card transactions into QuickBooks
Pick what you're starting from.
Utilly isn't affiliated with Intuit or any card issuer. Menu names change between versions; the paths above are from Intuit's help, checked November 9, 2026, and weren't run in a live QuickBooks company. Sources: Intuit, Format CSV files in Excel to get bank transactions into QuickBooks (3- and 4-column formats, credit card tips), Manually upload transactions into QuickBooks Online (file types, 350 KB / 1,000 lines), Fix Web Connect import errors, Enter transactions by batch in QuickBooks Desktop and Accountant tools: batch enter transactions (credit card charges or credits). The sample statement is fictional.
FAQ
How do I import credit card transactions into QuickBooks Online?
Go to Bank transactions, open Link account and choose Upload from file. Upload the card's CSV (Date, Description, Amount, or Date, Description, Credit, Debit), .QBO or .QFX, then pick the credit card account, not a bank account. Map the columns, import, and categorize the transactions on the For review tab. Intuit's limit for transaction files is 350 KB and 1,000 lines per upload.
Can you import credit card transactions into QuickBooks Desktop?
Yes, but not from a CSV directly. Import a .QBO Web Connect file with Banking, Bank Feeds, Import Web Connect Files on a supported version, an .IIF file with File, Utilities, Import, IIF Files on any version, or paste rows from Excel with Batch Enter Transactions in the Accountant and Enterprise editions.
How do I import credit card transactions into QuickBooks Desktop from Excel?
In QuickBooks Desktop Accountant or Enterprise, choose Accountant, Batch Enter Transactions, set the type to Credit Card Charges and pick the card account, then paste the rows in the same column order as the window and save. Repeat with Credit Card Credits for payments and returns. On Pro or Premier, convert the sheet to an IIF file and import that.
Why do my credit card charges show up as payments in QuickBooks?
The amounts are signed the wrong way. QuickBooks Online and IIF files expect charges as negative numbers and payments and returns as positive, but many card issuers' CSVs write purchases as positive. Intuit's own tip is that card CSVs may display transactions in reverse. Flip the sign of the amount column before uploading, or convert the file so it's signed for you.
Can I import a credit card statement PDF into QuickBooks?
QuickBooks Online can read a PDF or image statement through Upload from file; pick the credit card account and check its side-by-side view before saving. QuickBooks Desktop can't read PDFs, so convert the statement to a .QBO or .IIF file first, and check the transactions against the statement's new balance.
What IIF transaction types are used for credit cards?
CREDIT CARD for charges, with a negative amount on the card account's TRNS line, and CCARD REFUND for payments and returns, with a positive amount. Each transaction also needs an SPL line for the other account and an ENDTRNS line, and the card account name must match your chart of accounts exactly.
Can QuickBooks Desktop 2023 still import credit card transactions?
Yes, through IIF files or Batch Enter. Intuit discontinued Desktop 2023 after May 31, 2026, which switched off online banking, including Web Connect .QBO imports. IIF imports are local and keep working on any version.
Related guides
- How to upload a PDF bank statement to QuickBooks Online (and check nothing was missed)
- Free QuickBooks Online CSV import template for bank transactions (3- and 4-column)
- How to import bank transactions into QuickBooks Desktop after bank feeds stopped (2026)
- QuickBooks Desktop IIF import errors (File not imported, Review now, and how to fix them)
- Free sample credit card statement PDF (fictional, with known totals)
- Free credit card reconciliation template for Excel (with a worked example)
Related tools
- Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
- Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.
