COA Master

• COA stands for Chart of Accounts.

• The ultimate parent must publish the chart of accounts. Once published, the other entities must map the GL code and GL description to the chart of accounts.

• The field structure for this page is as follows.

  • L1 Classification – Drop down

  • L2 Classification – Drop down

  • L3 Classification – Text box – User Input – Further classification of L2

  • L4 Classification – Text box – User Input – Further classification of L3

  • L5 Classification – Drop down

  • L6 Classification – Auto populated by the tool as follows:

    • If L5 is 'Cash & Cash Equivalents', then L6 will be PAT

    • If L5 is not 'Cash & Cash Equivalents', then L6 will be 'Movement in L3 Classification'.

      • For ex: If L3 is Intangible Assets and L5 is not 'Cash & Cash Equivalents', then the L6 value will be 'Movement in Intangible Assets'.

  • The user will also be able to filter the data from L1 to L6 levels.

Functionalities:

• All fields are mandatory.

• The ultimate parent alone will be able to add/edit the COA master.

• The subsidiaries fill the “Map my GL” page of their entity.

• The user should first fill in the COA master before filling in the forms.

• A new row will be added using “Add more rows” button.

• The user will also be able to download the template using “Download template” button, fills the sheet and upload the same using “Import from template” button.

• The user will also be able to edit or delete the COA using the 3 dots at the end of each row.

• The user will also be able to download the sample COA master and the uploaded COA master.

COA Edit:

• Any change in the COA master should get reflected in the other modules wherever the L3 and L4 is mapped.

  • For ex: If there is a change in L3 from PPE to PP&E, then this change should flow to all the other modules such as forms, GL mapping, ICO, Load BC, Other Adjustments.

COA Delete:

• If there is a line item deleted from COA master, then the tool will show the list of modules in which the line item is being used.

• The user should map these line items to another line item before deleting the COA master line item.

• A COA master line item can be deleted if and only if the line item is not being used anywhere in the setup module.

• During an ongoing project, the user will not be allowed to delete the COA line item.

COA Questionnaire:

The corporate controller or the corporate controller team maps the L3 and L4 for the below mentioned list of items.

• Cash & Cash Equivalents

• Currency Translation Reserve

• Retained Earnings (posting profit/loss) Balances

• Non-Controlling Interests

• Investment in Subsidiaries

The L3 and L4 can also be edited by the members of holding company.

If the corporate controller team maps the L3 and L4 for the above items, then the users of corporate controller has to approve the same.

If the corporate controller users map L3 and L4, then it will be auto approved.