How to Import Chart of Account by Excel Template

Created by Cheng Kah Poh, Modified on Thu, 14 Mar at 3:01 PM by Cheng Kah Poh

In Order to Import Chart of Account by Excel Template


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

  1. INC = Sales
  2. INA = Sales Adjustment
  3. COG = Cost of Goods Sold
  4. OTI = Other Income
  5. EXP = Expenses
  6. TAX = Taxation
  7. EOI = Extra Ordinary Income
  8. EOE = Extra Ordinary Expenses
  9. APP = Appropriation Account
  10. BFA = Fixed Asset
  11. BIA = Intangible Assets
  12. BCA = Current Asset
  13. BCL = Current Liabilities
  14. BLA = Long Term Assets
  15. BEQ = Equity
  16. BLL = Long Term Liabilities
  17. 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.

  1. OST = Opening Stock
  2. CST = Closing Stock
  3. ADA = Accumulated Depreciation
  4. DAC = Debtor Control Account
  5. BAC = Bank Account
  6. CAC = Cash Account
  7. SAC = Stock Account
  8. CCAC = Creditor Control Account
  9. APLAC = Accumulated Profit & Loss Account

Example : 


Step 2 - After Fill in the Excel Template, then Expand 'Company' > Expand 'Tools' > Press 'Data Migration'



Step 3 - Press 'Upload' Button which next to Chart of Accounts



Step 4 - Then Press 'Click to Upload'


Step 5 - Then Select the Excel Template and Press 'Import' Button.

Done



** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article