First of all, let us understand what is a Chart of Accounts in QuickBooks and how to import chart of accounts templates 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.
Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.
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:
- The file size should not exceed 2 MB and 1000 rows.
- If you want to import sub-accounts as well, it can be imported by using the parent account name.
- All the columns that you are importing must have headings.
- 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.
Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.
Frequently Asked Questions (Faqs)
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 accounts 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.