How to Import Chart of Accounts Templates in QuickBooks?

by James Antonio

First of all, let us understand what is a Chart of Accounts in QuickBooks? A chart of accounts is a list of accounts defined in your QuickBooks accounting software. Different accounts will have different nature, and you can post entries in them according to the nature of the transaction. Thus, it can be said that the Chart of Accounts helps in organizing the different transactions into appropriate category as per their nature. Which ultimately make the accounting easier to understand and analyze.

Import Chart of Accounts Templates in QuickBooks

A chart of account is nothing but the list of all accounts and their balances listed in your accounting software like QuickBooks. Chart of accounts is used as a medium by your accounting software to organize business accounting. You can select a pre-created template when you are setting up your company file and you can also import your chart of accounts template with the help of a CSV file.

But if you will go for creating a Chart of Accounts as a new user, it will take a lot of time and efforts, it is always better to import previously created Chart of Accounts templates in your new QuickBooks accounts. In the next section, we will look into the process of importing the Chart of Accounts in QuickBooks. You can also choose the Chart of Accounts template from the already available templates for the QuickBooks companies.

Always ensure that you import the chart of accounts templates at the time when you don’t have a lot of accounts already running in your company file. In the next section, we will see the process steps for importing the chart of accounts template in QuickBooks after setting up your company file.

Steps to Import the Chart of Accounts Templates in QuickBooks

There are various industry-specific templates available for QuickBooks Online companies which you can choose from, after choosing the template you can follow the below process to import it in QuickBooks:

Step 1. At the start, you need to first select the appropriate excel sheet or file in which you have your chart of Account template to be imported in QuickBooks. Once you get the file, you need to click on open. You should keep in mind that your excel file with chart of accounts in it meet following parameters:

  1. The file size should not exceed 2 MB and 1000 rows.
  2. If you want to import sub-accounts as well, it can be imported by using the parent account name.
  3. All the columns that you are importing must have headings.
  4. You will have to format your excel sheet of existing accounts, with details like Account number, Account name, Type, and Details types.

Step 2. In this step, you need to review and match the mappings between Chart of accounts in excel sheet and QuickBooks. Basically, you will have to change the headings in the excel file to match it to Chart of Accounts in QuickBooks. You can save information like Account type, account number, Name, Description, Bank account number/credit card number, opening balance, as of date balance, tracking of reimbursable expenses, Income account for reimbursable expense, etc.

Once you are done with the headings mapping part, give a name to the mapping on the top of the screen and click on Save at the bottom of the screen.

Step 3. In this step, you need to actually import your spreadsheet of existing accounts in QuickBooks by following the below steps:

  • Click open and launch the QuickBooks on your system and enter your login credentials.
  • After that, in this step, you need to click on settings (gear icon) and then click on Import Data.
  • After clicking on Import data, you will have to click on Chart of Accounts and upload the spreadsheet with Chart of Accounts templates that we created before and done the mapping matching.

Step 4. Though we have already looked into the mapping part, but in this step, you can choose “No Match” for all other data except Account name if the column from the Excel file with Chart of Accounts does not match the columns in QuickBooks.

Step 5. In this last step, you need to click on Import and actually import the chart of Accounts templates into QuickBooks, you need to also ensure to correct any field that is highlighted in red and deselect accounts that you do not wish to import before finally choosing the import option.

Once the process is completed, you can then start by entering the opening balances of the accounts that you imported through Chart of Accounts templates in QuickBooks. We have tried to include all the aspects, but we understand, there can be lot of sub-topics of related things on which you may need help upon. So, we have listed down a few frequently asked questions from users end to help you out further.

Just one more thing, before we move further, you should know that once the Chart of Accounts is imported, you cannot undo it, so it better to first create full backup of your company file.


Need Some one on one QuickBooks Assistance?


What are the Process Steps for Creating a Chart of Accounts in QuickBooks Desktop?

You need to click on list > click on Chart of Accounts > choose new from Account drop-down menu > choose an account and click on continue, complete the details of account and click on save and close.

On what Location can I find the list of Charts of Accounts in QuickBooks?

First, click on List > Select chart of account under your company > click on the printer icon above action column to directly print the chart of account or you can also run the chart of account report, by clicking run report and print the list of charts of account.

What are the Steps that I can follow to Manually Rearrange the Chart of Accounts in QuickBooks?

To access a chart of accounts, click on List > then select the Chart of accounts, now highlight the account that you wish to move or rearrange, and using the left mouse button drag that accounts to your desired position.

Can you throw a Light on Editing the Chart of Accounts in QuickBooks?

You need to click on the Accounting menu and click on the account that you want to edit in the chart of accounts, now click on the drop-down beside account history or run the report, click on edit and make the desired changes, do not forget to save and close for completing the process.

Can you Advise how can I Export the Chart of Accounts from QuickBooks?

You need to first open the QuickBooks and then go to the Chart of Account screen. And then, you need to click on ‘Run Report’ button on the Chart of Account screen. After that, on the top right corner of the account list, you will see 4 icons, that are, email, print, export and setting. Once you reach here, you just need to click on export and extract the file of chart of account in excel or PDF.

Is there a way I can Fix a Chart of Accounts in QuickBooks?

Yes, you can. You need to first open QuickBooks and select Accounting from the left menu and then search for the account that you wish to edit. After that, you need to go to the Account history or Run report (as per the account) and choose the drop-down arrow next to it. After that, click on edit, make the changes as you wish and later click on save and close.

I wanted to Categorize the Product and Services items in QuickBooks, can you help me?

Yes certainly, first go to the sales menu, and choose Products and services. After that, search the product and services you wish to categorize and click on edit in the action column. After that, click the category drop-down, and select the most appropriate category for your product and service and click on save and close.

Can you List down the steps to Import the Journal Entries in QuickBooks?

You need to first click on settings on QuickBooks page, and click on import data functionality and then Journal entries. Go to the download page and click on browse, choose your CSV or excel file with journal entry, map your details, click on next and choose to start import. Once the process is completed, click on Done.

Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Dancing Number

Kindly Provide The Following Information To Download The Dancing Numbers.

X





    Top