QuickBooks Desktop can't import a CSV directly. Convert any bank or credit card CSV to a .qbo Web Connect file that imports through File, Utilities, Import.
No account needed for your first conversions. We never store your bank login.
QuickBooks Desktop cannot import bank or credit card transactions from a CSV file directly. The only transaction file it imports is a .qbo Web Connect file, so the reliable path is to convert your CSV or Excel export to a .qbo first, then bring it in through File, Utilities, Import, Web Connect Files. The converter at the top of this page does that conversion in one pass, and the same .qbo also works in QuickBooks Online.
Drop in a CSV or Excel file from any US bank, credit card, or accounting tool. You get back a .qbo built to the Web Connect spec QuickBooks Desktop reads natively, plus Excel and CSV copies. Each transaction keeps its date, description, and amount, and the converter checks the parsed total against your original file before you download, so nothing is dropped on the way into Pro, Premier, Enterprise, or Accountant.
| Method | What it handles | Works for bank transactions? | Effort |
|---|---|---|---|
| Convert CSV to .qbo, import via Web Connect | Any bank or card CSV or Excel export | Yes, native import | One upload, no column mapping |
| QuickBooks Desktop CSV import (File menu) | Lists only: customers, vendors, items | No, lists are not transactions | Limited to list data |
| IIF file import | Transactions, but you build the IIF by hand | Yes, error prone | High, technical formatting |
| Direct Connect bank feed | Live feed from supported banks | Yes, if your bank supports it | Setup and login, recent dates only |
| Manual entry | Anything | Yes | Very high for large files |
Built for the CSV and Excel exports US banks and cards actually send, checked before it exports.
The converter adds up the transactions it parsed and matches that to your file total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
Date, description, and amount are detected for you, so you skip QuickBooks' strict 3-column and 4-column CSV layout.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Mixed date formats, currency symbols, and stray commas that break a raw CSV import are cleaned up before the .qbo is built.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a CSV, XLS, or XLSX export from your bank, credit card, or accounting tool. Any column order is fine.
Every transaction is parsed and checked against your file total. You see the rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, message us in chat.
Not for bank or credit card transactions. QuickBooks Desktop imports lists such as customers, vendors, and items from CSV, but it has no built-in way to import transactions from a CSV. To get bank or card activity in, convert the CSV to a .qbo Web Connect file and import that instead, which is exactly what the converter above produces.
Convert the CSV to a .qbo file first, then import it. Upload your CSV in the converter above, download the .qbo, and in QuickBooks Desktop go to File, Utilities, Import, Web Connect Files. Pick the .qbo, choose the matching account, and the transactions drop into the Bank Feeds center for review and matching.
QuickBooks Desktop imports bank and credit card transactions from a .qbo Web Connect file, which is OFX text with a financial institution block and a unique ID on every transaction. It does not read raw CSV transaction files, so a CSV has to be converted to .qbo before Desktop will accept it.
In QuickBooks Desktop, open the File menu, choose Utilities, then Import, then Web Connect Files. Select your .qbo file and click Open. QuickBooks asks whether to use an existing account or create a new one, then loads the transactions into the Bank Feeds center, where you review, match, and accept them.
Because QuickBooks Desktop has no transaction CSV importer; it only takes .qbo Web Connect files for bank and card activity. Renaming a CSV to .qbo does not help, since QuickBooks reads the file contents, not the extension. Convert the CSV into a real .qbo with the tool above and the import goes through.
Upload your CSV or Excel file in the converter above. It detects the date, description, and amount columns, normalizes the dates, strips currency symbols and commas from the amounts, and writes a valid .qbo with a unique ID per transaction. Download the file and import it through File, Utilities, Import, Web Connect Files.
Yes, once you convert the card CSV to a .qbo. Export the activity from your credit card account, convert it here, and import the .qbo into the matching credit card account in QuickBooks Desktop. The converter sets charges as negative and payments as positive, the sign convention card imports need to balance correctly.
The same way you would a CSV: convert the spreadsheet to a .qbo first. The converter above accepts .xls, .xlsx, and .xlsm directly, so you do not need to save the file as CSV beforehand. After converting, import the .qbo through File, Utilities, Import, Web Connect Files.
Web Connect (.qbo) import works in QuickBooks Desktop Pro, Premier, Enterprise, and Accountant, and in QuickBooks for Mac. The steps are the same across them: File, Utilities, Import, Web Connect Files. The .qbo built by the converter follows the standard Web Connect spec, so it imports into any of these editions.
A single .qbo file can hold a full year of transactions, far more than the small CSV uploads QuickBooks Online caps at 350 KB. For very large histories, splitting the file by account or by quarter keeps each import easy to review. The converter handles thousands of rows in one pass.
A CSV is a plain spreadsheet with no fixed structure, which is why QuickBooks Desktop will not import transactions from it. A .qbo is a Web Connect file QuickBooks reads natively, with bank identity and a unique ID per transaction. Converting CSV to QBO turns an unreadable spreadsheet into the file Desktop expects.
Upload your CSV or Excel export in the converter above. The tool finds the date, description, and amount columns, normalizes the dates to a single format, removes currency symbols and thousands commas from the amounts, and reconciles the parsed total against your file. Download the .qbo, then in QuickBooks Desktop go to File, Utilities, Import, Web Connect Files and pick it. The whole pass takes under a minute, with no IIF formatting and no mapping wizard.
Bookkeepers and accountants on QuickBooks Desktop rely on it most, because clients hand over a year of bank and card CSVs that Desktop has no way to import on its own. Businesses still on Pro, Premier, or Enterprise use it to backfill accounts the bank feed never reached, and anyone moving off spreadsheets uses it to load historical transactions without keying them in by hand.
Upload a CSV or Excel export, get a QuickBooks-ready .qbo back in seconds. No card to try it.
Working from a different source or tool? Use the CSV to QuickBooks Online converter if your books are online, turn a spreadsheet into a .qbo with the Excel to QBO converter, handle card files on the credit card CSV to QuickBooks page, fix a failed import with the Web Connect import error guide, batch a backlog with the bulk CSV to QBO converter, learn what a .qbo file is, or compare the best CSV to QBO converters before you choose a tool. To convert a file now, start on the home page.
For the solo bookkeeper running a monthly close in QuickBooks.
USD / month
billed $288 yearly
For a firm or finance team converting across many clients and currencies.
USD / month
billed $888 yearly
For multi-bookkeeper firms managing many client books at scale.
USD / month
billed $2,988 yearly
