To import bank transactions into QuickBooks Desktop, load a Web Connect (.qbo) file under Banking, Bank Feeds, then review the rows in the Bank Feeds Center. Evidilo writes that file from a PDF or scanned statement, with an id on every row. Enterprise and Accountant can also paste Excel or CSV rows into Batch Enter Transactions.
The five routes Intuit documents for Desktop
Intuit’s overview, Import and export data in QuickBooks Desktop, gives bank data one line: “Import bank transactions using Web Connect (.qbo) files.” The same page offers Excel and CSV “for general data transfer of lists and transactions”, but the Excel import and the CSV import behind that line both take lists. Intuit’s Excel article says that route “cannot be used to import transactions”.
Read across seven of Intuit’s Desktop help pages on 25 October 2026, five routes come out, and three of them carry the rows of a bank statement:
| Route | File | Where the rows land | Does Intuit say a repeat is refused? | Edition |
|---|---|---|---|---|
| Web Connect import | .qbo | Bank Feeds Center, for review | Yes: the same transactions cannot be downloaded into a company file twice | Pro, Premier, Accountant and Enterprise |
| Batch Enter Transactions | Rows pasted from Excel or CSV | Straight into the bank or credit card register | Not stated | Enterprise and Accountant only |
| IIF import | .iif | Into the company file, with no review step described | Not stated | Every Desktop edition |
| Excel import | .xlsx | Lists only: customers, vendors, items and the chart of accounts | Not applicable | Not applicable |
| CSV import | .csv | Lists only: customers, vendors and items, through a toolkit | Not applicable | Not applicable |
So in Pro and Premier a CSV is not a way in for bank rows. Of the three routes that are, one holds the rows for review before they touch the register, and it is the same one Intuit says will not take a download twice.
How to import bank transactions in QuickBooks Desktop
The steps below are Intuit’s, from its Bank Feeds setup and import-and-export articles, for Desktop on Windows.
- Get a Web Connect (.QBO) file for the account and the dates you need, from the bank’s website or written from the statement.
- Sign in to your Intuit Account inside QuickBooks Desktop. Intuit says importing Web Connect files requires it.
- Go to Banking, select Bank Feeds, then Import Web Connect Files.
- Select the .qbo file and Open.
- When asked for the bank account, use an existing account or create a new one, then select Continue, and OK once QuickBooks says the data has been read.
- Go to the Bank Feeds Center to review the transactions.
On repeats, Intuit’s article on downloading bank feed transactions in Desktop is blunt: “You can’t download transactions into the same QuickBooks Desktop company file more than once.” The other side of that rule is on the same page: once you delete downloaded transactions, you cannot download them again. What a file carries for each row so that a second download looks like the first is set out in the guide to PDF statements and QBO row ids.
If all you hold for a month is a PDF or a sheet of paper, the .qbo file has to be made first. Evidilo is a bank statement to accounting import file converter, and the QBO (Web Connect) file is one of the seven formats it writes, alongside IIF, OFX, QFX, QIF, CSV and Excel. It adds up every row against the opening, closing and daily balances the bank printed and marks the first day that does not tie out, so a misread amount shows up on that day rather than months later in the register. Every transaction in its QBO file has a FITID, the id field, and when the same account was converted for an overlapping period before, the download step names those dates first.
Can I import transactions from Excel to QuickBooks Desktop?
Yes, in two editions, and by pasting rather than importing. Intuit’s batch entry article 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.” Its steps:
- From the Accountant menu, open Batch Enter Transactions.
- Select the transaction type and the bank account.
- Open the spreadsheet and arrange its columns in the order of the columns in the Batch Enter Transactions window.
- Copy the rows, right-click the first date field in the window and select Paste.
- Fix anything shown in red, which marks a name or account the company file does not hold yet, with Quick Add or Set Up.
- Select Save Transactions, then Yes on the Confirm Account screen.
Saving writes the rows into the register. The article describes no review step and says nothing about duplicates, so the check that a month is not already there is yours to make before step 6. Evidilo writes the same statement as a CSV or an Excel file with Date, Description and Amount columns, or Date, Description, Credit and Debit; step 3 still applies to either. If the spreadsheet will be opened and edited first, the Excel file keeps dates and amounts as they were where a CSV leaves them to the spreadsheet’s settings.
Where an IIF file fits
IIF is the route that runs in every edition: File, Utilities, Import, Import IIF. Intuit tells you to back up the company file first, and adds that it “doesn’t offer technical support for the import and export of IIF files.” The IIF file Evidilo writes has six transaction columns (TRNSTYPE, DATE, ACCNT, NAME, AMOUNT, MEMO) and none of them is a row id, so nothing in the file marks a row as already imported. The format itself, header by header, is in the guide to the IIF file format.
Which route to use for a statement
For a statement that has to go in once, Web Connect is the better choice, because it is the only one of the three that holds the rows for review and the only one where Intuit says the same download cannot go in twice. Batch Enter suits an Enterprise or Accountant file where the rows already sit in a spreadsheet and someone checks the dates against the register by hand. IIF is for a file someone has already built in Intuit’s format and is prepared to restore from backup if it goes wrong.
How was this checked?
On 25 October 2026 we read seven of Intuit’s QuickBooks Desktop help pages and one QuickBooks Online page, and recorded 35 quotes behind the five routes in the table; the routes are in dataset.csv. The script check.py re-reads each page for every quote and checks four facts about Evidilo’s own files against its source code. No file was imported into a copy of QuickBooks Desktop for this post, so it says nothing about how Desktop treats a file Evidilo wrote.
What bookkeepers ask about Desktop bank imports
How do I import a CSV file into QuickBooks Desktop?
For bank rows, only by pasting it into Batch Enter Transactions in Enterprise or Accountant; the CSV import itself takes customers, vendors and items. Evidilo can write the same statement as a QBO (Web Connect) file instead, which goes through Bank Feeds in Pro and Premier too. QuickBooks Online is the product with a CSV upload for bank transactions; Intuit’s article on formatting that CSV is written for Online only.
Why does Bank Feeds not take my bank’s CSV?
Intuit’s download article says “Web connect only works with .qbo files.” Evidilo reads a CSV the bank exported, as well as a PDF or a photo, and writes a QBO file from it. The ids in that file come from the statement rather than from the bank, so they cannot keep a live bank feed and a file apart when both cover the same week.
Can the same statement end up in QuickBooks Desktop twice?
Through Web Connect, Intuit says the same transactions cannot be downloaded into a company file more than once; through Batch Enter or IIF, Intuit describes no such check. Evidilo names an earlier conversion of the same account for an overlapping period before you download, with the dates it covered. That warning only knows about statements converted in Evidilo, not what is already in your register.
Which QuickBooks Desktop editions have Batch Enter Transactions?
QuickBooks Desktop Enterprise and QuickBooks Accountant Desktop, according to Intuit’s batch entry article. Evidilo’s Excel download is one way to have the rows in a spreadsheet ready to arrange and paste. In Pro or Premier the choice is a Web Connect file or an IIF file.
Do I have to sign in to Intuit to import a Web Connect file?
Yes. Intuit’s import-and-export article says importing Web Connect files requires you to sign in to your Intuit Account within QuickBooks Desktop. Evidilo needs no account for its free use, which is three statements a day of up to 10 pages each. If Desktop answers “To download and import transactions, sign in with your Intuit account” while you are signed in, Intuit’s advice is to try switching bank feed modes.