Chart of Accounts and Chart Master COA
Chart of accounts are GL codes which are created with classes, groups and chart names, Usually we have one default COA here. If you wish to modify you can edit it.
If you want to change the entire COA Entries, Use the import to change it. but keep the default values of System and GL preferences clearly. This will help you to replace the GL code in the system. But remember you need to make the Chart of Account during the time of initial setup. Once you made entries and start changing them are hard to do. And which will damage the Existing entries badly.
Format Data
This is a bit different than other samples. We have some predefined samples with data. the top two column datas are the System and GL setup data's which are mandatory to change the chart of account. during the time of changing the COA, we have to update these settings properly. These are all ofcourse explained in the System and GL Setup help documentation.
| Retained Earnings |
| Profit/Loss Year |
| Exchange Variances Account |
| Bank Charges Account |
| Shipping Charged Account |
| Deferred Income Account |
| Receivable Account |
| Customer Sales Account |
| Sales Discount Account |
| Prompt Payment Discount Account |
| Payable Account |
| Purchase Discount Account |
| GRN Clearing Account |
| Inventory Sales Account |
| Inventory Account |
| C.O.G.S. Account |
| Inventory Adjustments Account |
| WIP Account |
| Loss On Asset Disposal Account |
And its respective codes has to be filled here.
| Code | Parent Code | Name | Type/Group ID | Type / Group Name | Parent Type / Group ID | Class Name | Class Type [CL_NONE,CL_ASSETS,CL_LIABILITIES,CL_EQUITY,CL_INCOME,CL_COGS,CL_EXPENSE] | ||
These are all headers of your new COA list. Let's check them one by one.
- Code - its your GL code you can maintain them a proper grouping and its class codes. So you can remember them well and use it on your Journal entries. Suppose if you are having Accountant pack or its connected pack, your company COA has to be reused on the companies that you are creating under you.
- Parent Code - Suppose if you are creating nested parent child GL codes. you can use it otherwise leave it blank.
- Name - The GL account name is given here, as like sample.
- Type/Group ID, You should maintain both type and group ID sequence and input here carefully, incase of duplicate it wont import data.
- Type/Group Name - its related to the type and group name,
- Suppose if you are creating child parent groups, or types, you can use it. And try to maintain them carefully here. Suppose if you face trouble, bring us your data, we will help you to format it
- Class Name - You can define your class name, which actually needs to inherit the class types from our system. We will provide the constants in the next column to use it
- Class Type - It's a constant from our system you can't create those constants yourself, Its for your reference, Those constants are self explanatory for Accountants, kindly check with accountant while working with these constants.
Constants
| CL_NONE,CL_ASSETS,CL_LIABILITIES,CL_EQUITY,CL_INCOME,CL_COGS,CL_EXPENSE |
Memo and Error
During the upload, Incase if any error, that will allow you to new file. This new downloading file will have one new column Memo at the end, check the problem on that rows with that error and fix them and upload it again.
Export
Each of our module has both export and import. With help of this you can export the data from our system.