Chart of Accounts Importer
When a new company is created in ActiveBooks, the chart of accounts will be created by default in a pre defined structure. You can also import your own chart of accounts.
Last updated
When a new company is created in ActiveBooks, the chart of accounts will be created by default in a pre defined structure. You can also import your own chart of accounts.
Last updated
This feature allows you to create your own Chart of Accounts according to your requirement and import it into the system.
Remember: 1. Any existing Chart Of Accounts against that company will be overwritten. 2. The company you are selecting doesn't have any pre-existing transactions otherwise you'll receive a validation error.
You can access chart of accounts via: Accounting > Opening and Closing > Chart of Accounts Importer or Type 'Chart of Accounts Importer' in search bar
How to import the Chart of Accounts in ActiveBooks?
Follow the step by step process given below:
Select the Company for which you want to import the Chart of Accounts.
Click on "Download Template" button to download the template. Select file type in which you want to download the template. Select the template type and click on "Download". "Sample Template" contains pre-filled sample data so that you get an idea of how to fill the template. You can edit the data in "Sample Template" itself or download "Blank Template" for a fresh template.
3. Once you download the template, fill in the details in the template as shown in the sample template below. Please make sure to make accounts for account types "Cost of Goods Sold", "Depreciation", "Fixed Asset", "Payable", "Receivable", "Stock Adjustment". Root types for these accounts must be one of Asset, Liability, Income, Expense, and Equity.
4. Click on "Attach" to upload the template.
5. Once you upload the template you'll be able to see the preview of the Chart of Accounts in the Chart Preview section.
6. If everything seems correct in the preview, click on "Import" in the top right corner and the accounts will be created.
7. To verify the created accounts you can go to Chart of Accounts and see the newly created accounts for that company.
