How to Import a Credit Card Statement into QuickBooks

The Short Answer

A credit card statement goes into a credit card account in QuickBooks, not a bank account. That takes two things: a file that declares itself a credit card, and amounts that point the right way, with charges negative and payments positive.

• QuickBooks Online: set the card up as a Credit Card account, then use Upload from file with a QBO, QFX, or CSV file, or with the statement PDF itself.
• QuickBooks Desktop: import a credit card .qbo through Web Connect, or post an IIF file that creates the card as a credit card account.

The rest of this guide covers why a card behaves differently, what makes a file a credit card file, and what goes wrong when a card statement is imported as if it were a bank statement.

Why a Card Is Not a Bank Account

In QuickBooks a checking account is an asset: deposits raise its balance and spending lowers it. A credit card account is a liability: charges raise what you owe and payments lower it. A $412.60 airline ticket is money out either way, but it moves those two balances in opposite directions, so QuickBooks has to know which kind of account a transaction belongs to before it can post it.

Get the account type wrong and the damage is quiet. Card charges show up as withdrawals from a bank account you don't have, the payment you made to the card reads as a deposit, and the register's balance never ties to the new balance printed on the statement.

What Makes a File a Credit Card File

Every format that describes an account has a separate shape for a card. In a QBO file, and the QFX and OFX files built the same way, the difference is the block the transactions sit inside. A bank statement opens like this:

<BANKMSGSRSV1>
<STMTTRNRS>
...
<STMTRS>
<CURDEF>USD
<BANKACCTFROM>
<BANKID>121000248
<ACCTID>1000000007
<ACCTTYPE>CHECKING
</BANKACCTFROM>

A credit card statement uses its own message set, and its account block has no bank ID or account type, because a card has neither:

<CREDITCARDMSGSRSV1>
<CCSTMTTRNRS>
...
<CCSTMTRS>
<CURDEF>USD
<CCACCTFROM>
<ACCTID>2000000007
</CCACCTFROM>

The transactions inside are written exactly as they are for a bank. Only the wrapper changes, and the wrapper decides which accounts QuickBooks will let you import into. Across the formats QuickBooks and Quicken read:

For the difference between the formats themselves, see QBO vs QFX vs OFX vs QIF.

Which Way the Amounts Point

A card statement prints from the issuer's side: a charge is a positive number because it adds to your balance, and a payment is marked as a credit. QuickBooks reads amounts from your side: a charge is money you spent, so it's negative, and a payment to the card is positive. Here is the same card in a QBO file:

<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260809
<TRNAMT>-412.60
<FITID>920002
<NAME>DELTA AIR 0062391
<MEMO>Travel
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20260815
<TRNAMT>500.00
<FITID>920003
<NAME>PAYMENT THANK YOU
</STMTTRN>

This is where hand-built CSV files most often go wrong. Copy the amounts off the statement or out of the card portal's download, and every charge arrives in QuickBooks as a payment and every payment as a charge. Intuit's community answer for a card CSV that imported "in the opposite direction" is exactly this: all charges need to be negative numbers and credits positive, so multiply the amount column by -1 before uploading. A QBO file from a converter that knows it is reading a card avoids the step entirely.

Step 1: Set Up the Card in QuickBooks

Do this once per card, before the first import. In QuickBooks Online, open the Chart of accounts, choose New, and pick the Credit Card account type. In QuickBooks Desktop, open Lists, Chart of Accounts, then New, and pick Credit Card.

Use one account per card rather than one per issuer. A business with two cards from the same bank has two liabilities with two statements and two balances, and each should reconcile on its own. If employees carry cards on one account, the statement usually lists them together under a single balance, and one QuickBooks account matches that.

Step 2: Get the Statement into a Credit Card File

If your issuer offers a QuickBooks download, that file is already shaped for a card. For older months, closed cards, and issuers that only give you PDFs, convert the statement. In Bankflow:

1. Upload the PDF. Bankflow reads the transactions and checks them against the statement's own balances.
2. Check that it's marked as a card. A card statement prints things a bank statement has no reason to: a minimum payment, a payment due date, a late payment warning, and a credit limit with the credit still available. When Bankflow finds two of those on the first two pages, it marks the statement Card beside its name. A scanned statement has no text to check, so mark it yourself with Mark as credit card from the statement's menu.
3. Categorize and review. Categories travel in the QBO file's memo field if you want them to, and they become the expense accounts in an IIF file.
4. Export. Choose QuickBooks (Web Connect) for a .qbo or QuickBooks Desktop (IIF). The Account type setting starts at Credit card for card statements, and you can change it for a single export.

The statement parser for cards is covered on the credit card statement parser page, and the conversion itself on PDF to QBO.

Step 3a: Import into QuickBooks Online

Go to Bank transactions, open the dropdown beside Link account, and choose Upload from file. Select the file and pick the credit card account from Step 1 as the account it goes into. The transactions land in For review, where you categorize or match them before anything posts.

The same screen also takes a PDF or a photo of the statement, which QuickBooks reads itself. For one statement a month that can be all you need. Converting first is worth it when you have a year of statements to work through, when you want to categorize in bulk before the rows reach QuickBooks, or when the books are in Desktop.

Step 3b: Import into QuickBooks Desktop

Web Connect. Go to File, Utilities, Import, Web Connect Files, and select the .qbo. Choose Use an existing QuickBooks account and pick the card. If the list offers only bank accounts, the file was exported as a bank account; see Common Problems below. The transactions arrive in the Bank Feeds center for review. You need to be signed in to an Intuit Account inside QuickBooks first.

IIF. Go to File, Utilities, Import, IIF Files. A credit card IIF from Bankflow opens by declaring an account called Bankflow Card Import as a credit card account, then writes each charge as a CREDIT CARD transaction split to its category, and each payment or refund as a CCARD REFUND:

!ACCNT	NAME	ACCNTTYPE
ACCNT	Bankflow Card Import	CCARD
...
TRNS		CREDIT CARD	08/09/2026	Bankflow Card Import	DELTA AIR 0062391	-412.60
SPL		CREDIT CARD	08/09/2026	Travel	DELTA AIR 0062391	412.60
ENDTRNS

IIF skips the review step and posts straight to your books, which is the point of it and also the risk. Merge Bankflow Card Import into your real card account after the first import.

The Payment Row

Every card statement has one or more rows like PAYMENT THANK YOU. That money is not income, and it is not an expense: it is a transfer from your checking account to the card, and your checking statement already shows the other side of it. Record it as income and your revenue is overstated; record it as an expense on both statements and you have counted it twice.

In the QuickBooks bank feed, match the card payment to the payment already in your checking register, or record it as a transfer between the two accounts. In an IIF file, a payment's split goes to the account named by its category, and one left uncategorized posts to Uncategorized Income. Either give the payment the category name of the QuickBooks bank account that paid it, or correct it after import.

Common Problems

QuickBooks only offers bank accounts for the file. The file describes a bank account. In Bankflow, choose Mark as credit card on the statement, or set Account type to Credit card in the export dialog, and export again.

Charges show up as payments. The signs are reversed, almost always in a CSV taken straight from a card portal. Flip the amount column, or upload a QBO file instead.

QuickBooks Desktop says it is unable to verify the financial institution information. Desktop checks the institution ID a Web Connect file carries against Intuit's directory and refuses files that fail, including some downloaded from banks. Files exported from Bankflow carry an ID that passes. Our free QBO file checker reads a file in your browser and tells you which of QuickBooks' rules it breaks. If a file from somewhere else fails, check your QuickBooks version (Intuit's community reports releases before 2019 refuse these files), try Classic mode under Banking, Bank Feeds, Change Bank Feeds Mode, or import an IIF file instead.

The same month imported twice. QBO files carry a unique ID per transaction, so QuickBooks can recognise rows it has already downloaded. CSV and IIF files don't, so check the date range before importing an overlapping file.

The balance doesn't match the statement. Check that the interest and fee rows came across, since they often sit in a separate section at the end of a card statement, and that the opening balance in QuickBooks matches the previous statement's new balance.

Sample Files

Five illustrative card transactions, a payment and an interest charge among them, exported as a credit card by Bankflow's exporter:

• bankflow-sample-credit-card.qbo: QuickBooks Web Connect, with CCSTMTRS
• bankflow-sample-credit-card.iif: QuickBooks Desktop IIF, with a CCARD account
• bankflow-sample-credit-card.qif: Quicken Interchange Format, !Type:CCard

Compare the .qbo with the bank account sample to see the two wrappers side by side. The account numbers are stand-ins and the transactions are made up, so read them rather than importing them into real books.

Sources

Upload formats from Intuit's Manually upload transactions into QuickBooks Online. Card CSV signs from the QuickBooks Community thread Why are my credit card transactions imported from .csv in the opposite direction?. The financial institution error from Manually importing downloaded qbo file from credit card in QuickBooks Desktop. File excerpts are from Bankflow's own exporter. Checked September 15, 2026.