How to Import a Bank Statement into QuickBooks Desktop
QuickBooks Desktop accepts bank statements through Web Connect using a .QBO file. If your bank only gives you CSV or Excel, convert it to a .QBO first, then import it through the File menu or the Bank Feeds Center. Here is the exact path for both.
What QuickBooks Desktop actually accepts
Unlike QuickBooks Online, Desktop does not have a built-in CSV upload for bank transactions. Its native import format is Web Connect, which reads a single file type: .QBO. Quicken's .QFX and the older .QIF format will not import through Web Connect.
So if your bank hands you a CSV or Excel export, you have two real options: buy a third-party converter, or use a free one. QBO Maker turns your CSV or Excel statement into a valid .QBO entirely in your browser, then you feed that file to QuickBooks Desktop. Nothing is uploaded to a server, which matters when you are handling client bank data.
Step 1: Get a .QBO file
First check what your bank gives you when you download history:
- If your bank offers a QuickBooks (.QBO) / Web Connect download, save that file directly and skip ahead to Step 2. Download it from the bank's own website, not from inside QuickBooks.
- If you only have CSV or Excel, head to the converter. Upload the file, map your Date, Description, and Amount columns (the tool auto-detects most layouts), pick an account type, and download the
.QBO.
Want to confirm the output before importing? Run it through the OFX/QBO validator to catch malformed dates or unbalanced amounts before QuickBooks ever sees the file.
Step 2 (Method A): Import via File > Utilities
This is the most reliable path and works even when an account is not set up for online banking yet.
- Open your company file in QuickBooks Desktop.
- Go to File > Utilities > Import > Web Connect Files.
- Browse to your
.QBOfile and select Open. - When prompted, choose Use an existing QuickBooks account and pick the matching register, or choose to create a new account if this is the first import.
- Click Continue, then OK on the import confirmation.
QuickBooks reads the transactions into the Bank Feeds queue for that account, where you review and match them.
Step 2 (Method B): Import via the Bank Feeds Center
If you prefer to work from the Banking menu, the steps are nearly identical:
- Go to Banking > Bank Feeds > Import Web Connect Files.
- Select your saved
.QBOfile and click Open. - Choose the existing account to import into, then confirm the bank name, account type, and account number match.
- Click Continue to bring the transactions into the Bank Feeds Center.
Important: the target account must not be connected to Online Services. If you see a yellow lightning-bolt strike icon next to the account, it is linked to direct connect or express web connect. Deactivate online services for that account first, or the manual .QBO import will be refused.
Step 3: Review and add the transactions
Imported transactions land in a holding area, not directly in your register. Open Banking > Bank Feeds > Bank Feeds Center (or the Transaction List depending on your mode) and:
- Match transactions QuickBooks already recognizes against existing entries.
- Add new ones, assigning a payee and an account/category.
- Use renaming rules so recurring payees are categorized automatically next time.
Only after you click Add do the transactions post to the account register and affect your balances.
Troubleshooting common import errors
- OL-301 / OL-393 or a generic Web Connect error: the
.QBOis malformed or the account number inside it does not match a QuickBooks account. A clean re-export from the converter usually fixes formatting issues; double-check the account number you entered during conversion. - "This account is set up for online services": deactivate Bank Feeds for that account, then re-import.
- Duplicate transactions: Web Connect uses each transaction's unique ID to dedupe. If you re-convert the same statement, keep the same source rows so IDs stay consistent.
- Nothing happens on import: confirm the file extension is genuinely
.QBOand not.QFXor.csvrenamed by hand.
Frequently asked questions
Can I import a CSV directly into QuickBooks Desktop?
No. QuickBooks Desktop's Web Connect only reads .QBO files. Convert your CSV or Excel to .QBO first with QBO Maker, then import. (QuickBooks Online does support CSV uploads, covered in our QuickBooks Online guide.)
What's the difference between the File menu method and Bank Feeds?
Both import the same .QBO file into the same queue. The File > Utilities > Import > Web Connect Files path tends to work more smoothly for first-time imports and for accounts not yet set up for online banking, while Banking > Bank Feeds > Import Web Connect Files is convenient if you already live in the Banking menu.
Do I need an Intuit account signed in to import?
Recent QuickBooks Desktop versions may prompt you to sign in to your Intuit account before processing a Web Connect import. Sign in when asked; the transaction data itself still comes from your local .QBO file, not from Intuit's servers.
Will importing create duplicates if I run it twice?
Web Connect matches on each transaction's unique ID, so re-importing the identical file generally will not duplicate. Problems arise when you regenerate the .QBO from slightly different source data. Keep your source statement consistent, and review the Bank Feeds queue before clicking Add.
Does the conversion send my bank data anywhere?
No. The conversion runs entirely in your browser, so your statement never leaves your computer. That makes it safe for handling client files. Read more on the validator page about checking output locally.