How to Import Chart of Account by Excel Template

Created by Cheng Kah Poh, Modified on Thu, 16 Apr at 2:44 PM by NUR AZREEN

In Order to Import

Note: User may refer to this Guide, to understand where to download the Excel Template.

Step 1 - We need to understand the relation between Excel Column and Chart of Account

1. Account Code - GL Account in Chart of Account

2. Account Name - GL Account name

3. DRCR - CR is Credit, DR is Debit

4. AccountType - the GL Account is which Type, like Sales, Expenses OR COGS

INC = Sales
INA = Sales Adjustment
COG = Cost of Goods Sold
OTI = Other Income
EXP = Expenses
TAX = Taxation
EOI = Extra Ordinary Income
EOE = Extra Ordinary Expenses
APP = Appropriation Account
BFA = Fixed Asset
BIA = Intangible Assets
BCA = Current Asset
BCL = Current Liabilities
BLA = Long Term Assets
BEQ = Equity
BLL = Long Term Liabilities
BOL = Other Liabilities

User require to fill in this short code under the Account type, so then system will know the particular GL Account code will fall into which type.

5. Parent Code - if the GL Account Code is Under Account type, just fill in No.4 ShortCode will do, but if the GL Account is have a Parent Code like Below, 400-0200 is under a GL Account which is 400-000, and both Account is under Expenses.

Then user may need to fill in like below

400-0000 Account Type is EXP, Parent Code is EXP

and

400-0200 Account Type also EXP, because they are all under Expenses Account, but 400-0200 Parent Code is 400-0000, because 400-0200 is children account of 400-0000.

6. SpecialCode - is Special Account Code is for system to recognize that this account is under which Formula in Profit and loss report or Balance sheet report.