Import Credit Card Transactions into QuickBooks Online

TL;DR Set up the card as a Credit Card account in QuickBooks Online, convert the statement to CSV or QBO, and upload it to that account through the banking area's upload-from-file option. Test a handful of rows first, because the most common problem is signs: charges arriving as payments and payments as charges. After review, match the card payment to the transfer from your bank account so it isn't counted twice, then reconcile the card account to the statement's closing balance.

Credit card activity is where a lot of small business bookkeeping goes wrong. The bank feed might be disconnected, a card might be from an issuer that doesn't connect, or you might be catching up on months of statements that only exist as PDFs. Importing the transactions from a file is the reliable fallback, but credit cards behave differently from bank accounts, and QuickBooks Online is particular about how it reads them.

This guide covers account setup, file formats, getting signs right, matching payments, reconciliation and the errors that come up most. We describe QuickBooks Online screens in general terms because Intuit updates menu labels from time to time; the concepts stay the same.

Why credit cards are different

On a bank account, deposits increase your balance and withdrawals decrease it. On a credit card, the balance is what you owe:

• Charges, fees and interest increase the balance owed.
• Payments, refunds and credits decrease it.

In QuickBooks Online, a credit card account is a liability. A charge is recorded as an expense (or another account) with the card as the source of funds. A payment is a transfer from your bank account to the card.

When you import a file, QuickBooks has to decide which rows are charges and which are payments. It does this from the sign of the amount, or from which column it's in if you use separate columns. Get that wrong and the whole import is backwards.

Set up the account first

Before importing, make sure the card has its own account in your chart of accounts with the Credit Card account type. Don't import card transactions into a bank account or an "Other current liability" account; the transaction types and reconciliation won't work as expected.

If you have several cards, or several cardholders on one account who each get their own number, decide whether to track them as separate accounts or as one. One account per statement is usually simplest, because you reconcile one account to one statement.

Note the opening balance. If you're starting mid-year, the card account's balance in QuickBooks on the day before your first imported statement should equal that statement's previous balance. If it doesn't, the first reconciliation won't work. Our guide to an opening balance that doesn't match the statement covers how to fix that.

Choose the file format

QuickBooks Online imports bank and card transactions from a few file types. The two that matter here:

QBO (Web Connect). An OFX-based file with QuickBooks-specific fields. It carries the account, the transaction types and unique transaction IDs, so QuickBooks knows which rows are charges and which are payments without you mapping columns, and it can recognize duplicates. It's usually the smoothest option.

CSV. A plain table. QuickBooks accepts either three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit). You map columns during upload. It's flexible and universal, but the sign question is entirely in your hands.

Our comparison of QBO vs IIF vs CSV explains the differences in detail. For most card imports, QBO is the easier path, and CSV is the fallback when you want to edit rows first.

Convert the statement

A card statement PDF usually has a payment summary, a section for payments and credits, a section for purchases, fees and interest charges, and sometimes separate sections per cardholder. All of that needs to become one list of transactions.

Copy and paste is fine for a short statement, but separate sections and cardholder subtotals make it tedious.

A statement converter handles the layout. SheetStatement merges the sections into one chronological list, assigns the year from the statement period, checks that previous balance plus activity equals the new balance, and exports CSV, QBO or Excel. The free plan includes 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans cover more volume.

Whichever method you use, check the balance before importing:

=ROUND(PreviousBalance + SUM(Charges) - SUM(PaymentsAndCredits) - NewBalance, 2)

It should return 0. If not, a row is missing, a refund has the wrong sign, or the interest or fee line was skipped. The free balance checker does this arithmetic for you.

Get the signs right in CSV

This is the step that causes most failed card imports.

Three-column CSV

With one Amount column, QuickBooks reads the sign. The convention that's generally expected for a card account is that charges are negative (money going out, from the business's point of view) and payments and refunds are positive. That's the opposite of how the statement itself presents things, where charges increase the balance.

So if your converted data has charges as positive numbers (the statement's view), flip the sign before import:

=-C2

Four-column CSV

With separate Credit and Debit columns, put charges in one and payments in the other. Which column QuickBooks treats as which depends on the mapping you choose during upload, so be explicit.

Test with a few rows first

Because the convention isn't always obvious and screens change, the safest approach is a test:

1. Make a CSV with three rows: one ordinary charge, one refund and one payment.
2. Upload it to the card account.
3. In the review list, check that the charge appears as spending and the payment and refund as money in, or credits.
4. If they're reversed, exclude the test rows, flip the signs in your full file and upload again.

That five-minute test prevents a month of backwards transactions.

Upload and review

Upload the file to the card account using the banking area's upload-from-file option. QuickBooks will show a preview, ask you to map columns for CSV, and then add the transactions to the review list (often called "For review").

In the review list, each transaction needs a decision:

• Categorize a charge to an expense account, and add a payee.
• Match it to a transaction already recorded, such as a bill paid with the card.
• Transfer for payments from your bank account.
• Exclude anything that shouldn't be there, such as a duplicate.

Bank rules help here. If the same merchants appear every month, create rules that assign the payee and category automatically. Our guide to categorizing business expenses from bank statements has a sensible category list to start from.

Handle card payments as transfers

A payment to the card shows up twice: as money out of your checking account and as a payment on the card. It's one transaction, a transfer between two of your accounts. It isn't an expense.

If you import or connect both accounts:

1. On the checking side, record the payment as a transfer to the credit card account.
2. On the card side, match the incoming payment to that transfer rather than adding it again.

If you categorize both sides as an expense, or add both separately, you'll double count spending and the card balance will be wrong. When this has already happened, our guide to fixing duplicate transactions in QuickBooks explains how to find and remove the extra entries.

Refunds, fees and interest

Refunds reduce what you owe. Categorize them back to the same expense account as the original purchase, so the expense nets down, rather than to income.

Interest charges usually go to an interest expense account.

Annual and late fees typically go to bank or card fees.

Foreign transaction fees are often a separate line next to the purchase. Categorize them to fees, or to the same account as the purchase if you prefer to see the full cost together. Pick one approach and stick to it.

Cash back and rewards are a judgment call; some businesses record them as a reduction of expenses and some as other income. This is general information, not tax or accounting advice; ask your accountant which treatment they want.

Reconcile the card account

After reviewing every transaction for the period, reconcile the card account to the statement:

1. Start a reconciliation for the card account.
2. Enter the statement's ending (new) balance and ending date.
3. Tick each transaction that appears on the statement.
4. The difference should be zero.

If it isn't:

• Off by one transaction: something wasn't imported or was excluded by mistake.
• Off by twice one amount: a sign is wrong; a refund recorded as a charge is the usual cause.
• Off by the payment amount: the payment was added twice, or not matched to the transfer.
• Off from the start: the opening balance doesn't match the previous statement's new balance.

Our general guide to finding bank reconciliation discrepancies applies equally to cards, and our article on credit card reconciliation in Excel shows how to check a statement before it ever reaches QuickBooks.

A worked example

A small design studio has one business credit card. The bank feed for the card disconnected four months ago, and the owner has four PDF statements to catch up.

1. Account check. The card already exists in QuickBooks as a Credit Card account. Its balance on the day before the first missing statement matches that statement's previous balance.
2. Convert. All four statements are converted. Three balance immediately. One is off by twice a refund from a software vendor; the refund was positive like a charge. The sign is fixed and it balances.
3. Choose format. The owner uses QBO for three months. For the fourth, they want to remove a personal charge made by mistake before import, so they export CSV, edit it and keep the personal charge for reimbursement.
4. Test. A three-row CSV shows charges coming in as money in. The full CSV's signs are flipped before upload.
5. Review. Bank rules categorize about two-thirds of rows. The rest are categorized by hand. The four card payments are matched to transfers already recorded from checking.
6. Personal charge. It's recorded against an owner's draw account (or as an amount the owner repays), following the accountant's preference.
7. Reconcile. Each month reconciles to zero.

The studio's books are current, nothing is counted twice, and each month ties to a statement.

Cards with several cardholders

Business cards often have employee cards on the same account, and the statement groups transactions by cardholder with a subtotal for each. That's useful information to keep, but it causes two problems when converting.

First, the subtotals aren't transactions. If they end up in your file, they'll be imported as extra charges. Remove them, or use a converter that skips them, and rerun the balance check.

Second, you lose who spent what once everything is merged into one list. Add a Cardholder column before you import. In QuickBooks, you can carry that information in the memo or description, or use classes or locations if your subscription supports them and your accountant wants spending tracked that way.

If each employee has a separate account number and a separate statement, it's often cleaner to create one Credit Card account per cardholder in QuickBooks, with a parent account for the overall card. Each sub-account then reconciles to its own statement.

A monthly routine

Once the catch-up is done, a short monthly routine keeps the card account clean:

1. Download the statement as soon as it's available.
2. Convert and check the balance before importing.
3. Upload to the card account, then review: categorize, match bills paid by card, and match the payment to the transfer from checking.
4. Collect receipts for anything that needs one while the month is still fresh.
5. Reconcile to the statement's new balance.

This fits neatly into a month-end close checklist, and it takes far less time each month than a long catch-up at year-end.

Common import errors

"Some info may be missing from your file" or similar. Usually a header problem, an empty row at the top or bottom, or extra columns. Keep only the columns QuickBooks expects. Our guide to QuickBooks Online CSV import errors lists the common causes.

Dates rejected. QuickBooks needs dates it can read in a consistent format. Avoid mixed formats and text dates. See fixing bank statement dates in Excel.

Amounts rejected. Remove currency symbols and thousands separators, and make sure amounts are numbers, not text.

Everything is backwards. The sign convention. Flip it and re-upload, after excluding the first batch.

Duplicates after re-uploading. CSV imports don't carry transaction IDs, so re-uploading an overlapping file can create duplicates. Exclude them in the review list before accepting.

The file imports into the wrong account. Upload from inside the right account, and with QBO files, check that the file's account details match.

Import a card statement

Upload your credit card statement to SheetStatement, confirm the balance check, and download QBO or CSV for QuickBooks Online. The free plan covers 3 pages a month, enough to test with a real statement.

FAQ

Can I import credit card transactions into QuickBooks Online without a bank feed?

Yes. Convert the statement to CSV or QBO and upload it to the card account. That's the standard approach when a feed is disconnected or the issuer doesn't connect.

Why do my charges import as payments?

The sign convention. With a single amount column, QuickBooks reads the sign, and card charges usually need to be negative. Test with a few rows and flip signs if needed.

Should I use QBO or CSV for credit cards?

QBO is usually easier because it carries transaction types and IDs. CSV is useful when you want to edit rows before import. Either works if the signs and dates are right.

How do I stop card payments being counted twice?

Record the payment from checking as a transfer to the card account, and match the card-side payment to that transfer instead of adding it again.

How do I record a refund?

Categorize it to the same expense account as the original purchase so the expense nets down.

What if the card account won't reconcile?

Check the opening balance, look for a refund with the wrong sign, and make sure the payment wasn't added twice. Compare the difference to individual amounts to narrow it down.

Can I import several months at once?

You can, but importing and reconciling one statement at a time is much easier to check and fix.

What should I do with a personal charge on the business card?

Don't categorize it as a business expense. Record it in whatever way your accountant prefers, commonly against an owner's draw or as an amount to be repaid, and keep a note explaining it.

Is this tax or accounting advice?

No. It's general information about the import process. Ask your accountant how they want specific items, such as rewards or personal charges, recorded.