Import CSV into QuickBooks Desktop: Convert to QBO First
No account needed for your first 3 conversions. We never store your bank login.
Short answer: QuickBooks Desktop cannot import a bank-transaction CSV in any version. The only supported route for transactions is a .qbo Web Connect file loaded under Banking, then Bank Feeds, then Import Web Connect File. So to get a CSV into Desktop, you convert the CSV to a .qbo first, then import that file. The whole process takes about two minutes.
People search for a CSV import menu in QuickBooks Desktop and never find one, because it does not exist. Unlike QuickBooks Online, Desktop has no upload-from-file option for bank activity. This guide shows the exact path that does work, for Pro, Premier, and Enterprise on Windows. Last updated July 2026.
Can you import a CSV file into QuickBooks Desktop?
No, not directly. QuickBooks Desktop cannot read a bank CSV of transactions in any edition or year, and there is no add-in that changes this for the register. The workaround is to convert the CSV into a .qbo Web Connect file, which is the only transaction file Desktop imports natively. Once converted, the import itself is quick and reliable.
This differs from list imports. Desktop can bring in customers, vendors, and items from an Excel or IIF file using the QuickBooks Import Excel and CSV toolkit, but bank and credit card transactions are a separate path that requires .qbo. If you also run QuickBooks Online, note that it does accept a formatted CSV, unlike Desktop. See the differences in can QuickBooks import CSV files.
How to import a CSV into QuickBooks Desktop, step by step
The process has two parts: convert the CSV to a .qbo, then import the .qbo through Bank Feeds. Here is the full sequence.
| Step | Action |
|---|---|
| 1 | Download the bank CSV or Excel export from your bank |
| 2 | Convert it to a .qbo file with a CSV to QBO converter |
| 3 | Open QuickBooks Desktop and go to Banking, then Bank Feeds |
| 4 | Choose Import Web Connect File |
| 5 | Select the .qbo file you just created |
| 6 | Link it to the correct bank or credit card account |
| 7 | Review the transactions in the Bank Feeds center and add them |
To convert the file in step 2, upload your export to a CSV to QuickBooks Desktop converter, map the Date, Description, and Amount columns, and download the .qbo. Our Web Connect file converter builds the exact file Desktop expects. For the import itself, the full walkthrough is in how to import a QBO file into QuickBooks.
Why doesn't QuickBooks Desktop accept CSV?
QuickBooks Desktop was built around bank feeds and the Web Connect (.qbo) format, which carries an account ID and a unique transaction ID for each line. A raw CSV has none of that structure, so Desktop has no safe way to match transactions or block duplicates. Intuit never added a CSV import for the register, and that has not changed in the 2026 releases.
The upside of the .qbo requirement is duplicate protection. Because each transaction carries a unique ID, re-importing the same file does not create double entries, which a plain CSV cannot guarantee. That safety is a big part of why the .qbo path is the standard for Desktop.
Does this work for credit card statements too?
Yes. A credit card CSV converts to a .qbo the same way a checking export does, then imports through Bank Feeds into the matching credit card account. The one rule is to link the .qbo to the credit card account, not a bank account, so charges and payments post in the right direction. Mismatched account types are the most common cause of reversed signs.
If your only copy of the statement is a PDF, convert the PDF to a spreadsheet first, clean it up, then run it through the .qbo converter. Many Desktop users moving off bank feeds are doing exactly this after their bank dropped Direct Connect support.
What about older transactions and full-year imports?
Desktop handles large imports better than QuickBooks Online here. A single .qbo can carry many months of activity in one file, with no 1,000-row or 350 KB cap like the Online CSV upload. So for catch-up bookkeeping or a full-year backlog, convert the entire export to one .qbo and import it in a single pass rather than splitting by month.
After the data lands, a clean Desktop file makes it far easier to produce accurate reports and turn the bookkeeping export into finished financial statements at period end. Getting the import right the first time saves the reconciliation cleanup later.
Why won't my .qbo file import into QuickBooks Desktop?
If the .qbo will not import, the usual causes are a mismatched bank account, an account not set up for Bank Feeds, or a file whose bank ID does not match the one QuickBooks has on record. First confirm the target account is enabled for Bank Feeds under Edit, then Preferences, then Checking. Then re-import and, when prompted, link the file to the correct existing account rather than creating a new one.
Two other snags come up often. If QuickBooks says the file is empty, the converter may have skipped rows because the amount column read as text, so re-check the source CSV before converting. If it warns about a date range already imported, that is the duplicate protection working, and you can safely skip the overlapping transactions. For the specific Web Connect prompts and error codes, the Web Connect file converter page and our guide to fixing a QuickBooks Web Connect import error walk through each message.
Which QuickBooks Desktop versions does this work for?
The .qbo Web Connect import works in every current Windows edition: QuickBooks Desktop Pro, Premier, Enterprise, and Accountant, across the 2021 through 2026 releases. The menu path is identical in each, under Banking, then Bank Feeds, then Import Web Connect File. The one caveat is that Intuit sunsets older Desktop versions after three years, so an unsupported release may still import the file but no longer receive security updates.
QuickBooks for Mac reached end of life, so if you are on the Mac line the practical move is to use a CSV to QBO converter for Mac and convert to .qbo and import into a supported Windows edition or QuickBooks Online. Either way, the .qbo file you create works the same, which is the advantage of standardizing on that format for every bank and card account.
What QuickBooks Desktop will and will not import
Most of the confusion here comes from QuickBooks Desktop genuinely importing several file types, none of which is a transaction CSV. It helps to see the whole set at once.
| File type | What it can carry | Where it goes | Can you undo it? |
|---|---|---|---|
| .qbo (Web Connect) | Bank and credit card transactions | File, Utilities, Import, Web Connect Files, into the Bank Feeds review queue | Yes, before you accept them |
| .qfx / .ofx | Bank and credit card transactions | Same Web Connect path, depending on version | Yes, before you accept them |
| .iif | Transactions and lists | File, Utilities, Import, IIF Files, posted straight to the ledger | No. Restore a backup |
| .csv / .xlsx via the Import Excel and CSV Toolkit | Customers, vendors, items, chart of accounts | File, Utilities, Import, Excel Files | No bulk undo |
| .csv of bank transactions | Nothing. There is no importer for it | Convert it to .qbo first | Not applicable |
Read the last row carefully, because it is the whole problem in one line. Every other file type has a menu entry. A transaction CSV does not, in any version, and no update has ever added one.
Can I import a CSV file into QuickBooks Desktop 2024?
No. QuickBooks Desktop 2024 imports bank and credit card transactions from a .qbo Web Connect file only, exactly like every version before it. The 2024 release added nothing to change this, and since it is the final non-Enterprise Desktop release, no future update will either. Convert the CSV to .qbo and import that.
Worth knowing where 2024 sits: Intuit stopped selling new Pro, Premier and Mac Plus licences in September 2024, making 2024 the last non-Enterprise version, with support running to September 30, 2027. Enterprise is still sold and still supported. If you are on 2024 and planning to stay there, a converter is not a stopgap until the next release fixes this; it is the permanent route.
What can the QuickBooks Import Excel and CSV Toolkit actually import?
Four list types and nothing else: customers, vendors, items, and the chart of accounts. The toolkit is a set of sample spreadsheets and a reference guide for importing lists, not transactions. People download it expecting a bank import and find no option for one, because setting up records is a different job from posting activity.
That distinction is the one to hold on to. Lists are the master records your file is built from. Transactions are the activity against them. QuickBooks Desktop is happy to take lists from a spreadsheet and has never taken transactions the same way, which is why the toolkit and the bank import question keep getting confused with each other.
What happens to the transactions after the .qbo file imports?
They land in the Bank Feeds review queue rather than posting straight to your register. QuickBooks matches each one against existing entries, flags likely duplicates, and waits for you to assign accounts and accept them. Nothing hits the general ledger until you do, which is the safety net an IIF import does not give you.
The matching runs on the FITID, a unique transaction identifier carried inside every Web Connect and OFX file. QuickBooks records the FITIDs it has already seen for an account and skips them on a later import, so re-importing an overlapping date range does not duplicate anything. Note the flip side: it remembers a FITID even after you delete the transaction it created, so if you delete something and re-import the same file expecting it back, it will not return. Rebuild that entry by hand instead.
This is also the concrete reason a CSV cannot work as a transaction import. A CSV has no transaction identifier at all, just columns of text, so nothing in the file tells QuickBooks whether row 40 is new or something it imported last month.
Can you undo a bank transaction import in QuickBooks Desktop?
Yes, as long as you have not accepted the transactions yet. While they sit in the Bank Feeds review queue you can delete them from the queue and the import leaves no trace in your books. Once you accept them they become real register entries, and undoing means deleting each one, or restoring a backup taken before the import.
Take the backup first. It costs a minute and it is the only clean reversal for a large import that turns out to have the wrong account, the wrong dates, or the wrong sign convention. This matters most on credit card accounts, where the sign meaning flips relative to a bank account, and a whole statement can import backwards. The credit card CSV to QuickBooks guide covers how the debit and credit columns should map before you convert.
The bottom line
If you would rather install a desktop utility than convert in a browser, the ProperSoft alternative comparison covers what that licence buys you. QuickBooks Desktop will never take a raw bank CSV, so stop looking for the import button. If somebody has suggested building an IIF file instead, the CSV to IIF vs CSV to QBO comparison explains why that route gives up duplicate protection and has no undo. Convert the CSV to a .qbo, load it through Banking, then Bank Feeds, then Import Web Connect File, and your transactions come in cleanly with duplicate protection built in. It is the one reliable path, and once you have done it once it takes about two minutes a month. Bookkeepers weighing the tools that do this conversion can compare them in the CSV to QBO converter comparison.