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
- 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.
- OST = Opening Stock
- CST = Closing Stock
- ADA = Accumulated Depreciation
- DAC = Debtor Control Account
- BAC = Bank Account
- CAC = Cash Account
- SAC = Stock Account
- CCAC = Creditor Control Account
- 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
Feedback sent
We appreciate your effort and will try to fix the article