How to Import Bank Statements into QuickBooks (2026)

QuickBooks is designed around bank feeds: a live connection that pulls transactions from your bank every day. In practice, bookkeepers import files all the time. The feed may not reach back far enough for a catch-up project, the bank may not support a connection, a feed may have broken or dropped transactions, or a client may simply hand you a stack of PDF statements.

This guide covers importing bank and credit card transactions into both QuickBooks Online and QuickBooks Desktop, the file formats each accepts, how to convert PDF statements into those formats, and how to fix the most common import errors. Menu names change occasionally as Intuit updates the products, so if a label differs slightly in your version, look for the closest equivalent.

Bank feed vs file import: when to use which

Bank feeds and file imports are complementary, not competing, methods.

Use the bank feed for day-to-day work on accounts your bank supports. Transactions arrive automatically, usually daily, and matching against open invoices and bills is quick.

Use file imports when the feed cannot help:

Periods before the feed's history window, such as a catch-up of the previous year.
Accounts at banks without a supported connection, including many smaller banks and some foreign banks.
Gaps when a feed disconnected or skipped transactions.
Client records delivered as PDFs or paper.
Accounts that have been closed, where the feed no longer works at all.

Many firms use both: the feed going forward and converted statements for history. The key is a clean boundary date between the two, so nothing is imported twice and nothing is missed.

Which file formats QuickBooks accepts

Format	QuickBooks Online	QuickBooks Desktop	Notes
CSV	Yes	Not for bank registers in most versions	Most flexible; you map columns during upload
QBO (Web Connect)	Yes	Yes	Intuit's bank-feed format; includes account and bank identifiers
QFX	Yes	Generally no	Quicken's format, very similar to QBO
OFX	Yes	Generally no	Open Financial Exchange; the base standard behind QBO and QFX
Excel (.xlsx)	Save as CSV first	No	Convert to CSV before importing
PDF	No	No	Must be converted first

If you are deciding which format to produce from a converter, our comparison of QBO, OFX, QIF and CSV explains the trade-offs. As a rule: CSV for QuickBooks Online when you want control over mapping, QBO when you want the import to behave like a bank feed, and QBO for QuickBooks Desktop.

Preparing a CSV for QuickBooks Online

QuickBooks Online supports two CSV layouts:

Three-column layout

Date	Description	Amount
03/02/2026	Payroll - Northwind LLC	4250.00
03/04/2026	Rent - Elm Street Props	-1850.00
03/07/2026	Card - Office Depot #221	-86.47

Four-column layout

Date	Description	Credit	Debit
03/02/2026	Payroll - Northwind LLC	4250.00
03/04/2026	Rent - Elm Street Props		1850.00

Rules that prevent most upload problems:

One header row, then transactions only. Remove opening balance rows, subtotals, page headers and blank lines.
Consistent date format throughout the file. During upload you tell QuickBooks which format the file uses, so MM/DD/YYYY and DD/MM/YYYY both work as long as you choose correctly.
Numbers only in amount columns. No currency symbols, no thousands separators, no "CR" or "DR" suffixes, and no text such as "n/a".
No commas inside descriptions unless the field is properly quoted. A stray comma shifts every following column.
Reasonable file sizes. Intuit limits upload size; if a file is rejected as too large, split it by month.

Our QuickBooks CSV export produces exactly these layouts from PDF statements, with dates in the format you choose.

Importing into QuickBooks Online: step by step

Go to the bank transactions screen. In current versions this is under Transactions > Bank transactions (older menus call it Banking).
Open the upload option. Use the Link account drop-down arrow, or the Upload transactions button, and choose Upload from file.
Choose your file. Drag in the CSV, QBO, QFX or OFX file.
Select the QuickBooks account. Pick the bank or credit card account the transactions belong to. If it does not exist yet, add it here with the correct account type.
Map the columns (CSV only). Tell QuickBooks which column holds the date, the description and the amount, choose the date format, and indicate whether amounts are in one column or two.
Check the preview. Confirm dates parsed correctly and that money in and money out are in the right direction. Deselect any rows you do not want, such as transactions already present from a feed.
Import. The transactions appear in the For review tab, not directly in the register.
Categorise or match. For each transaction, accept a suggested match to an existing transaction (for example an invoice payment or a bill payment), or categorise it to an account. Use rules for recurring payees.
Reconcile. Once everything for the period is reviewed, reconcile the account to the statement's closing balance.

Importing credit card statements into QuickBooks Online

The process is the same, but choose the credit card account in step 4. Pay extra attention to the signs in step 6:

Purchases and fees should increase the card balance (appear as money spent).
Payments to the card and merchant refunds should decrease it (appear as money received or payments).

Card statements often show purchases as positive numbers and payments as negatives, which is the reverse of what a bank account CSV would contain. Depending on the account type and file, QuickBooks may ask how to interpret the amounts, or you may need to flip the signs in the CSV before uploading. A quick test: import one month, then compare the card account balance in QuickBooks with the statement's new balance. If the difference is roughly double the activity, the signs are reversed.

Remember that the payment from your bank account to the card is a transfer. When it appears in both the bank and card accounts, match one side to the other as a transfer rather than categorising it as an expense. Our article on bank vs credit card statements explains why.

Importing into QuickBooks Desktop with Web Connect

QuickBooks Desktop imports bank and credit card transactions through Web Connect files with the .QBO extension.

Back up your company file before importing anything.
Go to File > Utilities > Import > Web Connect Files.
Select the .QBO file.
Choose whether to link the transactions to an existing account or create a new account. Link to the correct existing account to avoid duplicates.
Open the Bank Feeds Center (or the online banking centre in older versions) to review downloaded transactions, then add or match them to the register.
Reconcile against the statement.

Web Connect files contain an institution identifier (the INTU.BID value) that QuickBooks uses to associate the file with a financial institution. If QuickBooks cannot recognise the identifier, it may refuse the file or show an institution error. When you create QBO files with our PDF to QBO converter, you can set this value to match your bank or a commonly accepted identifier.

QuickBooks Desktop's online banking features, including Web Connect, depend on the version being within Intuit's supported window. When older versions lose support for bank feeds, imports can stop working. Our guide to what to do when QuickBooks Desktop bank feeds stop working covers the options.

Converting PDF statements for QuickBooks

When all you have is PDFs, which is common for catch-up work, older periods and client documents, the workflow is:

Convert the PDF. Upload statements to a converter such as our bank statement to QuickBooks tool. It reads text PDFs, scans and phone photos.
Check the balance proof. The converted transactions should reproduce the statement's opening and closing balances. If they do not, fix the flagged rows before exporting. This step prevents most reconciliation headaches later.
Choose the format. QuickBooks CSV for Online, or QBO for Online or Desktop.
Import one statement at a time and reconcile each before moving to the next.

For a general walkthrough of the conversion itself, see how to convert a bank statement PDF to Excel; the same principles apply to CSV and QBO.

Setting up a new company file with historical statements

When you start QuickBooks part-way through a year, or move a client from spreadsheets, the opening balance is where most long-term problems begin.

Pick a clear start date. Choose the first day of a statement period, ideally the start of the financial year. Everything before that date is summarised in opening balances; everything after is imported in detail.

Enter the opening balance from the statement. When you create the bank account in QuickBooks, use the closing balance of the statement that ends the day before your start date, dated that day. If uncleared cheques or deposits in transit existed at that date, the bookkeeping balance differs from the bank balance, and your accountant may prefer to enter those items individually so they can clear in the first reconciliation.

Import statements in order. Start with the first statement after the start date and work forward. Reconciling each one before importing the next gives you a clean audit trail and catches problems while the period is still small.

Don't import the opening balance as a transaction. Converted CSVs sometimes contain an "opening balance" or "balance brought forward" row. Remove it before uploading; otherwise QuickBooks treats it as a deposit or withdrawal and the account will be out by exactly that amount.

Watch the account type. A savings account, a credit card, a loan and a line of credit behave differently. Create each with the right type so that statement signs are interpreted correctly.

Foreign currency accounts

If multicurrency is enabled in QuickBooks Online, a bank account can be held in a currency other than your home currency. Import files for that account should contain amounts in the account's own currency, not converted amounts. QuickBooks applies exchange rates when it calculates home-currency values. Mixing currencies within one file, or importing a euro account's transactions into a dollar account, produces balances that can never reconcile.

Statements that show both the original currency and a converted amount on the same line need special care during conversion; make sure the exported amount is the one that actually moved through the account.

Avoiding duplicates

Duplicates are the most common problem when files are imported alongside a bank feed.

Find where the feed starts. Check the earliest date the feed downloaded and import only transactions before that date.
Don't import the same file twice. QBO and OFX files contain a unique transaction ID (FITID) for each transaction, which helps QuickBooks recognise duplicates, but CSV files do not.
Exclude rather than delete. In QuickBooks Online, excluded transactions stay in the excluded tab, which leaves a trail.
Watch for overlapping statement periods. If one statement ends on the 15th and the next starts on the 16th, a file covering the whole month will overlap both.

The FITID glossary entry explains how transaction IDs work in bank-feed files.

Troubleshooting common import errors

Problem	Likely cause	Fix
"Some info may be missing from your file"	Blank rows, missing dates or non-numeric amounts	Remove blank and summary rows; make sure every row has a date and a numeric amount
Dates in the wrong month	Day and month swapped	Choose the correct date format during mapping, or normalise dates before upload
All amounts imported as deposits	Single amount column without negatives, or wrong column mapping	Use negative numbers for money out, or the four-column layout
Credit card balance doubled	Signs reversed for card transactions	Flip signs in the file or choose the correct interpretation during upload
File rejected as too large	Too many rows in one upload	Split the file by month
Desktop: institution not recognised	INTU.BID missing or unsupported	Regenerate the QBO with a valid institution ID
Desktop: Web Connect does nothing	Unsupported QuickBooks version or file association issue	Update QuickBooks, or import via File > Utilities > Import
Descriptions cut short	Field length limits	Keep the essential payee text at the start of the description

Reconciling after the import

Importing transactions is not the end of the job. After categorising and matching, reconcile each account:

Go to the reconcile screen for the account.
Enter the statement ending date and ending balance from the PDF.
Tick off transactions that appear on the statement.
The difference should be zero.

If it is not zero, check for missing or duplicated imports, reversed signs, or transactions dated outside the statement period. Our step-by-step guide to reconciling a bank statement covers the technique, and the bank reconciliation calculator helps with the arithmetic.

Best practices for bookkeepers

Keep a log of which statements have been imported for each client and account, with dates and file names.
Use bank rules in QuickBooks Online for recurring payees, but review them periodically; a rule that miscategorises silently is worse than none.
Close the books after reconciling by setting a closing date, so imported history is not accidentally changed.
Keep the source PDFs with the client's records; the import file is a working document.
Work month by month on catch-up projects. Our bookkeeping clean-up page and accountants page describe workflows for larger batches.

Frequently asked questions

Can I upload a PDF bank statement directly to QuickBooks?

No. QuickBooks Online and Desktop do not import transactions from PDF statements. Convert the PDF to CSV or QBO first, then upload that file.

What is the difference between QBO and CSV for QuickBooks Online?

A CSV is a plain table that you map during upload, which gives you control but no duplicate protection. A QBO file is a bank-feed file with account details and unique transaction IDs, so it behaves more like a bank feed and helps QuickBooks recognise duplicates.

How far back can I import transactions into QuickBooks?

File uploads are not limited to the bank feed's history window, so you can import older periods from converted statements. Large histories should be split into smaller files, typically one per statement period.

Can QuickBooks Desktop import CSV bank transactions?

In most versions, QuickBooks Desktop does not import CSV files into bank registers. Use Web Connect (.QBO) files instead, or a third-party import tool. Our converter exports QBO files suitable for Desktop.

Why are my imported credit card transactions showing the wrong sign?

Card statements often present purchases as positive numbers, while QuickBooks may expect purchases as money spent. Check the preview during upload, choose the correct interpretation if offered, or flip the signs in the CSV before importing.

How do I avoid importing duplicate transactions?

Import only periods not already covered by your bank feed, never upload the same file twice, and prefer QBO or OFX files, which carry unique transaction IDs. Review the For review tab carefully and exclude duplicates.

Summary

QuickBooks Online imports CSV and bank-feed files from the bank transactions screen; QuickBooks Desktop uses Web Connect .QBO files. Prepare clean files, get the signs right for credit cards, import one period at a time and reconcile each to the statement. If your source documents are PDFs, convert them with balance checks first so every import starts from complete, verified data. For Xero users, see the companion guide to importing bank statements into Xero.

How to Import Bank and Credit Card Statements into QuickBooks Online and Desktop

Key takeaways