You can import credit card transactions into QuickBooks Online in two ways: by connecting your card for automatic daily syncing, or by manually uploading a file. The automatic feed is best for ongoing bookkeeping, while manual uploads work well for older transactions or banks that don’t support a direct connection. Here’s how to do both, plus how to handle the categorization and matching that comes after.
Connect Your Credit Card for Automatic Imports
The fastest way to get transactions flowing into QuickBooks Online is to link your credit card directly. Once connected, new transactions download automatically, usually within 24 hours of posting to your account. You can connect as many cards as you need.
To set it up, go to All Apps, then Accounting, then Bank Transactions. Select “Connect account” (or “Link account” if you’ve already connected another account). Search for your bank or card issuer by name, then select Continue. You’ll sign in using the same username and password you use for your bank’s online portal. Your bank may require a verification code or other security step.
After you authenticate, QuickBooks shows you all the accounts available at that institution. Select the specific credit card you want to connect. You’ll also see a date range dropdown that lets you choose how far back to pull transactions. Select Connect, then Done.
From that point forward, QuickBooks pulls in new posted transactions automatically. They land in a “For Review” queue where you categorize or match them before they hit your books.
Upload Transactions from a File
If your bank doesn’t support a direct connection, or you need to import older transactions that fall outside the automatic feed’s date range, you can upload a file instead. QuickBooks Online accepts QBO files (its native format), QFX files (Quicken’s format), and CSV files. Most banks let you export transactions in at least one of these formats from their online portal.
Your file must be in English and 350 KB or less, with a maximum of 1,000 lines per upload. Each line represents one transaction. If you’re working with a CSV, the file needs either three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit). A few formatting rules matter here:
- Dates: Every date must use the same format. QuickBooks recommends dd/mm/yyyy. If your bank includes the day of the week alongside the date (like “20/11/2022 TUE”), split them into separate columns before uploading.
- Column headers: If you use separate Credit and Debit columns, remove the word “amount” from those headers.
- Zeroes: Leave any cells in the Amount, Credit, or Debit columns blank rather than entering a zero.
- Description column: Remove any standalone numbers from cells in the Description column, as QuickBooks may misread them as amounts.
To upload, go to All Apps, then Accounting, then Bank Transactions. If the credit card account already exists in QuickBooks, select its tile, then choose “Upload from file” from the Link Account dropdown. If you haven’t set up the account yet, select “Upload from file” or “Or upload transactions manually” from the main screen.
Drag and drop your file or browse to select it, then hit Continue. QuickBooks asks you to pick the account the transactions should import into. On the next screen, you’ll map the columns in your file to the correct QuickBooks fields (Date, Description, Amount). Review the preview, select the transactions you want to include, and confirm. The imported transactions appear in the same “For Review” queue as automatically synced ones.
Categorize and Match Imported Transactions
Whether transactions come in through a bank feed or a file upload, they don’t post to your books automatically. They sit in the For Review tab on the Bank Transactions page, waiting for you to categorize or match each one.
QuickBooks tries to suggest matches when an imported transaction lines up with something you’ve already recorded, like a bill payment or an expense you entered manually. A match is based on the transaction amount and date. QuickBooks looks for records within 90 calendar days before and 20 calendar days after the imported transaction’s date. If both the dollar amount and the timing line up, you’ll see a suggested match in the Categorize or Match column.
To accept a match, select the transaction to expand it, review the suggested record, and select Post. If the suggestion is wrong, select “Find other match” to search for a different record. You won’t see a match suggestion if the amounts differ (due to fees or discounts, for example), if the existing record falls outside that 90-day-before or 20-day-after window, or if the record has already been reconciled.
For transactions that don’t have a match, you categorize them directly. Assign an expense category (like “Office Supplies” or “Travel”), add a payee if one isn’t already filled in, and post the transaction. QuickBooks learns from your categorization choices over time and starts suggesting categories for similar future transactions.
Handle Cards with Multiple Users
If your business credit card account has multiple cards issued to different employees, you’ll want to set up a parent account with subaccounts, one for each cardholder. This lets you track spending by person while keeping everything consolidated for reconciliation.
Before connecting to the bank feed, check how your bank sends downloaded transactions. Some banks funnel all card activity into a single account. Others break it out by individual card number. If transactions download to one account, connect only the parent account in QuickBooks. If they download separately by card, connect each subaccount individually. You can’t connect both a parent account and its subaccounts at the same time.
One thing to watch for: when you first connect, the same opening balance transaction may download to every subaccount. Delete all but one of those duplicate balances when you reconcile. At reconciliation time, you only need to reconcile the parent account, since all subaccount transactions roll up into it automatically.
Avoid Duplicate Transactions
Duplicates are the most common headache when importing credit card transactions, and they usually happen in one of two ways. First, you manually enter a transaction and then the same transaction comes in through the bank feed. This is exactly what the matching feature described above is designed to prevent. If QuickBooks suggests a match for an imported transaction, review it carefully before posting. Accepting the match links the two records together instead of creating a second entry.
Second, duplicates can appear if you upload the same file twice or if your upload’s date range overlaps with transactions already pulled in by the automatic feed. Before uploading a file, check the date range of transactions already in QuickBooks for that account. During the upload process, QuickBooks lets you select or deselect individual transactions, so you can uncheck any that are already in the system.
If a duplicate does slip through and you’ve already charged a customer twice as a result, you’ll need to create a refund receipt in QuickBooks to offset the extra charge. Go to the plus icon at the top, select Refund Receipt, fill in the customer details to match the original sale, and check the “Process credit card refund” box. If you use QuickBooks Payments, you’ll also process the actual refund through the merchant center by locating the duplicate transaction and selecting Reverse.
Which Method to Use
For day-to-day bookkeeping, the automatic bank feed is the clear winner. It requires almost no ongoing effort once connected, and transactions arrive daily without any manual steps. Use manual file uploads for specific situations: importing historical transactions from before you connected the feed, pulling in data from a bank that doesn’t support direct connections, or migrating records from another accounting system. You can also combine both methods on the same account. Just be careful about overlapping date ranges to avoid the duplicate issue.