How to Import Transactions into QuickBooks from Excel?

As a start-up or budding businessman, it might seem a bit difficult for you to operate on a novel software tool like QuickBooks, which you haven’t used before. Given the issues that you might face in handling your transactions on QuickBooks, here is a guide to get you going. 

When you start using QuickBooks, the first thing you do is shift your database to the software interface. Taking the data maintained in the Excel sheet to QuickBooks, therefore, is the very first thing that you would look forward to.

Get Expert Advice to Fix All Accounting & Bookkeeping Problems


Importing Transactions into QuickBooks from Excel

After QuickBooks is installed in your system, it is crucial to make sure that you have a single platform where all your transnational details are stored, maintained, and ready to be retrieved whenever required. However, before transactions importing into QuickBooks from Excel, a user needs to make sure he/she has the relevant toolkit installed in the system to make the process easier.

The Process Importing Transactions to Quickbooks from Excel

1. Step One: Install QuickBooks Import Excel & CSV Toolkit

2. Step Two: Import Charts of Accounts from Excel to QuickBooks

3. Step Three: Mapping Accounts

Need Professional Help?

If you get stuck anywhere in the process, feel free to get in touch with SMB QuickBooks Technical Support Team, Which is available 24/7 on

Get Expert Advice to Fix All Accounting & Bookkeeping Problems



  1. How can I unzip a file to import transactions into QuickBooks from excel?

    1. Go to your zip file
    2. Then right-click on it
    3. Select the option Extract all
    4. Then in the window Extract Compressed (Zipped) Folders, browse the location where you want to unzip the files
    5. Also, check the box Show extracted files when completed
    6. After that, click on the button Extract
    7. When the extract process is done it opens up the folder where the files are extracted.

  2. What are the general steps to import transactions from Excel to QuickBooks?

    1. In QuickBooks, click on the File menu option
    2. Then select the Utilities 
    3. Click on the Import option then select the Excel Files option
    4. In The window named Add/Edit Multiple List Entries, click on the No button
    5. Now, follow the instructions of the installation wizard that are:-
    —(A). Firstly, select the data
    —(B). Then it opens up the excel sheet that is in the format
    —(C). Update the information in it then save the file and close it
    —(D). Review the results and data in your QuickBooks
    —(E). Click on the Close button.

  3. What are the situations in which I have to import transactions from Excel to QuickBooks Desktop?

    There are a few situations in which You have to import transactions from Excel to QuickBooks desktop. The situations are as follows:-

     1. It is required when your  company file data is corrupted or damaged and you are not able to open that company file
    2. When you are transferring your data from one account to another account or one system to another system
    3. In case of an update or upgrade, you are  importing your old transaction from Excel to  QuickBooks 
    4. When you get some files from someone else and you have to import this into your account.



Toll Free: 800-961-4963 user