Guide to Export the chart of accounts from QuickBooks to Excel

QuickBooks to excel

QuickBooks is a user-friendly financial accounting software the offers you with multiple functions for bookkeeping. One such function is the ability to save an accounting chart in order to reuse it whenever you require. You can save your chart of accounts by exporting it to Microsoft Excel, to keep a record of it to reuse at your convenience. The objective of this article is to provide you with the steps to export QuickBooks to excel.

Why do you need to Export QuickBooks to Excel?

All QuickBooks users would know what a tedious task it is to create the perfect company file, even with all the inbuilt reports and templates provided to them. Performing this task each time can be rather frustrating. You can avoid making all this effort by simply exporting your chart of accounts to excel. This will also create a standard chart format that you can simply follow yourself, as well as share it with other users on your account.

Now, we move on to the steps that will teach you how to export chart of accounts in QuickBooks.

How to Export Chart of Accounts in QuickBooks?

  • Open the company file in QuickBooks.
  • Find the chart of accounts it contains, the one you want to export.
  • From the taskbar, select File and it will open a drop-down menu.
  • Navigate to Utilities, then Export, and then Lists to IIF Files.
  • You should be faced with a pop-up list with multiple checkbox list icons.
  • From the list, select the option for Chart of Accounts.
  • Selecting it will prompt the Save as dialog box.
  • Navigate to the folder you would like to save it to, choosing from the drop-down list.
  • Name the file appropriately, so you can use it as a point of reference to what it contains. For example, “Annual Contractor CoA”.

Converting the file appropriately for Microsoft Excel

Now that you have exported the file to a separate location, you will need to convert to an appropriate format, in order to open it in Excel. Doing so will enable you to make it compatible to import the file back to QuickBooks later on.

Using the Text Import Wizard

  • Firstly, you must Open up Excel.
  • Secondly, from the taskbar at the top of your screen, find the Data
  • Click on the option which says From Text.
  • This will prompt a dialog box titled Import Text File.
  • Navigate to the folder you previously saved your chart of accounts in.
  • Please note that if you have a version of Microsoft Office that is dated prior to the 2010 version, you will have to find the Text Import Wizard, and use it to navigate to your preferred IIF file.
  • Once you find the IIF file, click on Open. As per our earlier example, it is “Annual Contractor CoA”.
  • Carefully read through the steps and follow them.

The wizard will walk you through three steps

  • The first step will be to choose the type of file you are trying to export. Make sure you select the option for Delimited.
  • After you click next, the second step is to choose from among the delimiters. Check the option for Tab and then move on to the next step.
  • The third step is to choose the column data format. Select General and proceed to finish the wizard.

After you close the Text Import Wizard

  • You will see a small notification appear on your screen, that asks you where you’d like to import the data. Select the option for the existing worksheet and then click on Okay.
  • Go back to the File drop-down menu and find the option to Save as. This will save your new file to Excel sheet format. Simply name the file appropriately, select the location of your choice, and click on This will ensure that Excel automatically saves it in the required format (.xls).
  • Lastly, close the current window of Excel, and then open the file you saved above.

 A final note:

This should help you wind up your export process and to prepare the saved file for importing back to your version of QuickBooks.

  • Delete all the rows that fall above the!ACCNT
  • Navigate to the!ACCNT type If you observe the names of the account types, you will notice that they have been abbreviated.
  • Make sure that you always use these exact abbreviations while saving your account. This will prevent the possibility of any error.

Your file is ready for import!

We hope this blog has taught you how to export chart of accounts in QuickBooks. We tried our best to include all the steps, and explain them as comprehensively as possible. In case you would like a more detailed explanation of the benefits of exporting your chart of accounts to Excel from QuickBooks, please contact QuickBooks Enterprise Support Phone Number +1-805-257-5030 (toll-free).