How to import a CSV or Excel file into QuickBooks Desktop (bank transactions and lists)

QuickBooks Desktop has an Excel and CSV import, but it isn't for bank transactions: it brings in customers, vendors, items and the chart of accounts. A bank or card CSV goes in another way. This guide shows the three routes Intuit documents for getting a CSV or Excel file of transactions into QuickBooks Desktop (an IIF file, Batch Enter Transactions, or a Web Connect .QBO), which one your edition and version can use, the list imports the Excel tool is actually for, and how to check that every row came in.

1. What QuickBooks Desktop imports from CSV and Excel

Intuit's Import and export data in QuickBooks Desktop article lists four methods: MS Excel or .CSV files, form templates, IIF files, and "Bank Data: Import bank transactions using Web Connect (.qbo) files". The Excel tool's own article is narrower: "You can import Customer, Vendor, Items, and Chart of Accounts from an Excel spreadsheet." Put together:

That's why "import CSV" in Desktop often ends at a mapping screen with no transaction type: the Advanced Import is a list tool. For bank lines, pick one of the three routes below.

2. Which route fits your edition and version

Intuit's 2023 discontinuation notice says that after May 31, 2026 those versions "won't be able to download transactions", and that "uploading transactions will also get discontinued". IIF and Batch Enter are local features, so they don't depend on that service. If you have a choice, IIF is the quickest for a whole statement: one file, both money in and money out, imported in one step.

3. Route 1: convert the CSV to IIF and import it

A bank CSV has one row per transaction. An IIF file describes each one as a small journal: a TRNS line for the bank account, an SPL line for the other side and an ENDTRNS line, with money out as a CHECK and money in as a DEPOSIT. These are the first rows of the sample CSV:

Date,Description,Debit,Credit,Balance
09/01/2026,Beginning balance,,,12418.36
09/01/2026,ACH DEBIT GUSTO PAYROLL 0912,6420.18,,5998.18
09/01/2026,STRIPE TRANSFER ST-K2M8Q4,,3184.27,9182.45

and the same two transactions in the .IIF the converter writes from it (the "Beginning balance" row isn't a transaction, so it's left out):

!TRNS	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	MEMO
!SPL	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	MEMO
!ENDTRNS
TRNS	CHECK	09/01/2026	Checking		-6420.18	ACH DEBIT GUSTO PAYROLL 0912
SPL	CHECK	09/01/2026	Uncategorized Expense		6420.18	ACH DEBIT GUSTO PAYROLL 0912
ENDTRNS
TRNS	DEPOSIT	09/01/2026	Checking		3184.27	STRIPE TRANSFER ST-K2M8Q4
SPL	DEPOSIT	09/01/2026	Uncategorized Income		-3184.27	STRIPE TRANSFER ST-K2M8Q4
ENDTRNS

1. Convert the CSV with CSV to IIF (or Excel to IIF for an .xlsx). Check the column mapping, the row count and the balance check on the preview.
2. Set the bank account name to the exact name in Lists → Chart of Accounts. If it doesn't match, QuickBooks creates a new account with the name in the file.
3. Back up the company file. Intuit's import article is blunt: "You cannot undo an import."
4. Sign in as admin in single-user mode, then File → Utilities → Import → IIF Files and pick the file.
5. If QuickBooks says File not imported, choose Review now and fix the rows it lists. The codes are explained in QuickBooks Desktop IIF import errors.
6. IIF transactions post straight to the register with no review step, so recategorize the Uncategorized lines and reconcile the account to the statement.

Run any .iif through the free IIF file checker before importing. The full walkthrough for a company file without bank feeds, including a sample to copy, is in importing bank transactions into QuickBooks Desktop without bank feeds.

4. Route 2: Batch Enter Transactions from Excel

Intuit says: "Only QuickBooks Enterprise and QuickBooks Accountant Desktop support batch entering transactions from excel or .CSV files into QuickBooks bank, credit card, accounts receivable, and accounts payable registers." Pro and Premier don't have it; use IIF instead. The transaction types include Checks, Deposits, Credit card charges or credits, Invoices, Credit memos, Bills and Bill credits, and one batch holds one type.

1. Back up. Open the CSV in Excel and split it into money out and money in. For the sample that's 20 withdrawals for a Checks batch and 11 deposits for a Deposits batch. Enter the amounts as positive numbers in each.
2. Choose Accountant → Batch Enter Transactions, set Transaction Type to Checks and pick the bank account.
3. Arrange the spreadsheet columns in the same order as the Batch Enter window. Leave out anything it doesn't have, such as Balance.
4. Highlight the rows, right-click and Copy. In QuickBooks, right-click the first date field and choose Paste.
5. Payees or accounts that aren't in the company file turn red. Select each one and choose Quick Add or Set Up.
6. Select Save Transactions, then Yes, and OK when QuickBooks shows how many it saved. Repeat with Deposits.

Batch Enter is the right choice when you want payees and categories filled in as you go. For a card account the types are Credit Card Charges and Credit Card Credits; the card version of these steps is in importing credit card transactions into QuickBooks.

5. Route 3: convert to .QBO (Web Connect)

On a supported version you can also turn the CSV into a .QBO and let QuickBooks treat it like a bank download, so the transactions arrive in the Bank Feeds center for matching instead of posting straight to the register.

1. Convert with CSV to QBO (or Excel to QBO).
2. Sign in to your Intuit account inside QuickBooks Desktop; Intuit requires it for Web Connect imports.
3. Choose Banking → Bank Feeds → Import Web Connect Files, pick the file, then choose your existing bank account rather than creating a new one.
4. Add or match the transactions in the Bank Feeds center, then reconcile.

Intuit's bank feed article says Web Connect "only works with .qbo files", so renaming a .csv or .qfx doesn't work. It also says you can't download the same transactions into a company file more than once. Error codes such as OL-222 are covered in .QBO Web Connect import errors.

6. Importing Excel lists: customers, vendors, items, accounts

If your CSV or Excel file is a list rather than transactions, this is the tool. From Intuit's Import or export MS Excel files article:

1. Back up the company file.
2. File → Utilities → Import → Excel Files. If the Add/Edit Multiple List Entries window opens, select No.
3. Select Advanced Import, then Browse to the file and choose the sheet. Tick This data file has header rows.
4. In Choose a mapping, select Add New, name the mapping, pick the Import type (Customer, Vendor, Item and so on) and match the QuickBooks fields to your columns. Save.
5. Select Preview, then Import. If you get Duplicate Record Found, choose whether to keep the existing data or replace it.

For the chart of accounts, Intuit's route is Lists → Chart of Accounts → Account ▾ → Import from Excel with the import type set to Account. A starting list is in the chart of accounts template. Lists → Add/Edit Multiple List Entries also takes rows pasted from Excel, but Intuit says it "is for list information (name, description, etc.) and cannot be used to import transactions".

7. Get the CSV ready

• One header row. Bank downloads often start with lines like the account name and the date range (the sample has two). Delete them, or let the converter find the header row.
• No balance rows. "Beginning balance", "Totals" and running-balance-only rows aren't transactions. The sample's last row is a Totals line: 28,575.27 out and 29,597.43 in.
• Signs or columns. Either one Amount column with money out negative, or separate Debit and Credit columns as in the sample. Don't mix them.
• Dates in one format. MM/DD/YYYY is the safe choice for a US company file.
• No old months? Bank CSV downloads usually go back a limited time, while PDF statements go back years. For those months, convert the PDF statement to IIF or QBO instead.

8. Check the import against the statement

Whatever the route, confirm the count and totals before you categorize anything. For the sample CSV:

Then reconcile in QuickBooks with the statement date and ending balance. If the difference isn't zero, finding bank reconciliation discrepancies walks through it, and duplicate transactions after import covers overlaps with an existing feed.

9. Common problems

10. Convert your own CSV or Excel file

Each converter reads your file, finds the header row, shows every transaction and the balance check, and writes the file QuickBooks Desktop takes. Free up to 100 rows for CSV, Excel and OFX files, with a free preview for PDF statements. Files are read in memory and not stored.

Utilly isn't affiliated with Intuit. Menu names change between versions; the paths above are from Intuit's help, checked November 9, 2026, and weren't run in a live QuickBooks company. Sources: Intuit, Import and export data in QuickBooks Desktop (methods, "You cannot undo an import"), Import or export MS Excel files (lists, Advanced Import, chart of accounts), Enter transactions by batch in QuickBooks Desktop, Accountant tools: batch enter transactions (transaction types), Download bank feed transactions in QuickBooks Desktop (Web Connect .qbo only) and QuickBooks Desktop 2023 service discontinuation policy. The sample CSV is fictional.

FAQ

Related guides

• How to import bank transactions into QuickBooks Desktop after bank feeds stopped (2026)
• QuickBooks Desktop IIF import errors (File not imported, Review now, and how to fix them)
• How to import credit card transactions into QuickBooks Online and Desktop (CSV, Excel or PDF)
• Free sample IIF file for QuickBooks Desktop (bank and credit card)
• How to open an .IIF file (QuickBooks Desktop, Excel or no QuickBooks)
• QBO vs IIF vs QIF: which file QuickBooks and Quicken actually need

Related tools

• Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
• Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.