How to Import Bank and Credit Card Transactions into QuickBooks (Online & Desktop)

There are two ways to get bank and credit card activity into QuickBooks: connect the account so transactions arrive automatically, or import a file you downloaded from the bank. Most businesses need both — a live connection for everyday work and file imports for older months, unsupported banks or a connection that stopped working. This guide covers both for QuickBooks Online and QuickBooks Desktop.

Which method should you use?

Situation	Best method
Your bank connects to QuickBooks and you want automatic updates	Bank feed (connect the account)
You need months before the connection started	Upload a file for the missing period
The bank feed shows an error or stopped updating	Upload a file while you fix the connection (bank feed errors)
Your bank, card, PayPal or foreign account doesn’t connect	Upload a file every month
Your bank only offers CSV/Excel and you use QuickBooks Desktop	Convert CSV to QBO, then import Web Connect

QuickBooks Online

Option 1: connect the account (bank feed)

1. Go to Banking → Bank transactions (on some plans: Transactions → Bank transactions).
2. Click Connect account (or Link account), search for your bank and sign in with your online banking credentials.
3. Choose which accounts to connect and map each one to an account in your chart of accounts.
4. Pick how far back to download. Many banks only provide the last 90 days through the connection; anything older has to be uploaded as a file.

New transactions then appear in the For review tab, where you match or categorise them.

Option 2: upload a file

QuickBooks Online accepts CSV, QBO, QFX, OFX and TXT files.

1. Download the transactions from your online banking. Prefer QBO/QFX (“QuickBooks” or “Quicken” download); otherwise CSV.
2. In QuickBooks Online go to Banking → Bank transactions, open the arrow next to Link account and choose Upload from file (or click Upload transactions).
3. Drop the file and choose the QuickBooks account it belongs to — a checking, savings or credit card account.
4. For CSV files, map the columns: date, description and either one amount column or separate credit/debit columns, plus the date format. QBO/QFX/OFX files skip this step.
5. Select the transactions to import, confirm, and review them in For review.

CSV files often fail on formatting: extra header lines, currency symbols, mixed date formats. If the upload complains, see how to import a CSV into QuickBooks Online — or convert the CSV to QBO first, which also adds a unique ID to every transaction so you can’t import duplicates by accident.

QuickBooks Desktop

Option 1: bank feeds (Direct Connect or Web Connect)

In Banking → Bank Feeds → Set Up Bank Feed for an Account, search for your bank. QuickBooks offers one of two modes, depending on the bank:

• Direct Connect — QuickBooks downloads transactions itself (some banks charge a fee).
• Web Connect — you download a .qbo file from the bank’s website and QuickBooks imports it.

Option 2: import a Web Connect (.qbo) file

1. Download the QuickBooks (.qbo) file from your online banking.
2. In QuickBooks Desktop go to File → Utilities → Import → Web Connect Files and select the file. Double-clicking a .qbo file usually opens it in QuickBooks too.
3. Link it to an existing account or create a new one the first time.
4. Open the Bank Feeds Center (Banking → Bank Feeds), select the account and match or add the downloaded transactions. Bank rules speed this up in later months.

If your bank only gives you CSV or Excel, convert CSV to QBO or Excel to QBO. Quicken (.qfx) or plain OFX files can be converted to QBO without losing payees, memos or check numbers.

Credit card transactions

Credit cards work the same way, with two things to watch:

• Pick the credit card account when you import, not a bank account, so charges increase the card balance instead of reducing your checking balance.
• Check the signs. In some card CSV exports purchases are positive numbers. In the preview, purchases must show as charges (money out) and payments as credits. In the converter tick Reverse signs if they are flipped, and choose Credit card as the account type.

Importing older months

To catch up on history before a bank feed starts:

1. Find the date of the first transaction the feed downloaded.
2. Download a file from the bank (or from statements) for the period before that date — leave no overlap.
3. Upload or import that file into the same QuickBooks account.
4. Reconcile each month against the statement’s closing balance.

Only have PDF statements for old months? See how to convert a PDF bank statement to Excel.

Avoiding duplicates

• QBO/QFX/OFX files carry a transaction ID (FITID); QuickBooks skips IDs it has already seen in that account. CSV files don’t, so be careful with overlapping dates.
• Don’t import the same period both through the bank feed and from a file.
• If you do end up with duplicates, exclude them in the review list before adding them; deleting them after they are added takes longer.

Related

• How to convert CSV to QBO
• QBO vs QFX vs OFX
• QuickBooks bank feed errors and how to keep working
• Bank and card guides: Chase · Bank of America · American Express · PayPal · Stripe · Square · Shopify