Showing results for 
Search instead for 
Did you mean: 
Level 2

importing excel file into qb desktop

Hi there, 

Do we need to convert the bank transactions excel or CSV file into .QBO file format to be able to import it into QB Enterprise 2021?


In QB it looks like we can import excel files (utilities - import -excel) but when I do mapping it doesnt give me option to chose transactions, just costumers, vendors or accounts.  


Someone (very known for QB lessons) on youtube said we need to convert it into .QBO file format. Was he just advertising the converter software or indeed we need that?


Thank you for any help!


P.s. please do not tell tell me how to connect direct to bank or to use any other method. I have the data in excel files already - bank statements with description date and amount.




3 Comments 3
QuickBooks Team

importing excel file into qb desktop

Thank you for posting here in the Community for clarification, @booklover. I’ll share some information about importing transactions into QuickBooks Desktop (QBDT).


There are two ways of downloading transactions into QBDT. First is Direct Connect. This is where you connect your bank to your QuickBooks account to automatically download the transactions.


On the other hand, you can import your transactions using a Web Connect (.QBO) file. These files are online banking transactions from your bank’s website. The (.QBO) files are downloaded to your computer. Then, you import the transactions so they become available in your bank feeds.


Since you’ve mentioned above that you have your data already in an excel file, I suggest you import your transaction using a Web Connect (.QBO) file and utilize a third-party application to convert excel to .QBO format. You can also directly reach out to your financial institution, as they can also provide this file to you.


The other way to get the file is to visit your bank’s website. Let me show you how:


  1. Open your web browser and go to your bank’s website.
  2. Sign in to your bank account.
  3. Download the transactions in a QuickBooks Web Connect (.qbo) format.


Once you have the Web Connect (.QBO) file, you can then import it into your QBDT company. Here’s how:


  1. Select the Banking menu, and select Bank Feeds.
  2. Select Import Web Connect Files.
  3. Select your bank account.
  4. Select Continue. A dialog window will appear, indicating that the data has been successfully read into QuickBooks. Select OK.
  5. Then, review your transactions by going to the Bank Feeds Center.


Furthermore, you can check out the following articles about adding and matching transactions as well as reconciling your account in QuickBooks Desktop.



Let me know in the comments if you need further assistance with importing. The Community always has your back. Have a great day!

Fiat Lux - ASIA
Level 15

importing excel file into qb desktop


You need a 3rd party app to import your bank statements.

Level 2

importing excel file into qb desktop

This answer is straight to the points. Thank you so much for your help.

Need to get in touch?

Contact us