Setup

This page is used to set up the information of the corporate group. The data on this page is collected through different sub modules as discussed below.

Add Entity:

• The corporate controller or the corporate controller team will be able to onboard an entity using the “Add New Entity” page.

• The onboarded entity can be a subsidiary or associate.

• The field structure for this page are as follows:

  • Add Entity – User input field – Type should be String – Enters the name of the entity

  • Add Identifier – User input field – Type should be String – Enters the short name of the entity

  • Nature of entity – Drop down field – Selects the nature of entity – which can be Subsidiary, Associate

  • Functional Currency – Drop down – This field will have a list of all the currencies. The user will select the appropriate currency for that entity.

  • Acquired through BC – Drop down – The options available are ‘Yes’ and ‘No’. The user will pick if the entity is acquired through BC or not.

  • Region - Drop down - The list of regions based on the functional currency provided will be displayed

  • The user should also be able to download the template and do a bulk addition of entities using ‘Upload Template’.

  • On click of ‘+’ button, the user should be able to add new entity.

  • On click of ‘Submit’, the user should be able to submit the entered entities which will get added in the database.

Functionalities:

• All fields are mandatory.

• For subsidiaries alone, “Acquired through BC” field is enabled. For ultimate parent and associate, this field is disabled.

• The entity name and identifier fields should be unique.

• If the nature of any entity becomes “Stop Consolidation”, then the user can add another entity with the same name and identifier.

• The user will be able to change the nature to “Stop Consolidation” only through “Loss of Control” in the “Edit” button.

View Entity List:

Once the user submits the entity details, the user should be redirected to the view page.

Functionalities:

• The user can edit or delete the data using the three dots at the end of the row.

• If the user selects ‘Edit’ – All the fields in this page, that is, Entity name, Identifier and Relationship with Ultimate parent fields should be enabled where in the user can edit the values.

• On click of ‘Submit’, the edited values will be saved directly if the user is corporate controller and will be sent for approval if the user is not a corporate controller.

• The values will be saved only if the changes are approved by the corporate controller.

• If the user edits the page and navigates to the other page without saving the edited data, then the user should be notified with a pop-up – “Existing data will be lost! Do you want to continue?”.

• If the user selects ‘Delete’ – The user should be notified with a pop-up – “Are you sure you want to delete the entity?”

• The entity will be deleted only if the associated forms of this entity are deleted.

• The entity will be deleted directly if the corporate controller deletes it. Else, it will go for approval and the entity will be deleted only when the corporate controller approves the change.

• Also, the user will be able to access the forms from this page.

• The color of the forms button will be yellow until the forms are in progress and color of the button will turn green if the forms are completed.

Add Investments:

• To add the investment, that is, the share percentage, the user can click on the ‘Add Investment’ under the ‘Action’ field.

• If the investments are added, then the “Add Investment” should be changed to “View Investments”.

• On click of “View Investments” button, the tool should take them to the investments page which the user has already entered.

• If the “Relationship with Ultimate Parent” is Associate, then the user should not be allowed to enter the investments. So, the “Add Investments” button should be disabled for Associate.

Functionality:

• This page enables the user to input the share percentage it has in other entities.

• For ex: If A has shares in B and C, then, A will input the share percentage it has in B and C.

• The field structure for this page is as follows:

  • Select Entity – Drop-down – Displays the list of entities that the user has added.

  • Investment Percentage – User Input – Type should be Decimal – Enters the share percentage the user holds in each entity.

  • Investment Type – Drop–down – The values will be Subsidiary and Associate – Selects subsidiary or associate to this entity.

• The user should be able to edit or delete the investments using the ‘Edit’ and ‘Delete’ buttons.

• The investment for each entity can be added only once.

• If any entity has already entered x % as an investment in any other entity, then the rest of the entities, on adding their investment should be able to add only 100-x%.

• For ex: If H has entered 55% in C2, and when C1 enters its investment in C2, the tool should allow only 100-55%, that is, 45% in C1’s investment.

Edit:

• Edit functionality allows the user to edit the data in the group structure.

• It allows the user to edit the name, identifier of the entity, change in investment and move the entity to loss of control.

• The nature of the entity can be changed from the given nature to “Stop Consolidation” only.

• The nature cannot be changed from subsidiary to associate or from associate to subsidiary.

Stop Consolidation Functionality:

• A subsidiary entity can be stop consolidated only if the entity has BC or Investment form and the form status should be completed.

• An associate can also be stop consolidated. Since the associate will have no forms, stop consolidation will happen directly.

• By default, if the user chooses loss of control, the nature will be moved to “Stop Consolidation”.

• If the entity becomes “Stop Consolidation”, then the row gets frozen, and the user will not be able to do any further action in this entity.

• Once an entity's status is changed to stop consolidation the user still needs to see the status of the entity - the data to be frozen in the set-up page, matrix page and COA page.

• All subsidiaries (direct and indirect) of the stop consolidation entity should also be marked as ' stop consolidation' and the user must be asked to delete forms.

• The entity which is chosen to stop consolidation should not be visible in the “Add Investments” page as well as in the “Add Investments” page drop down and the investments should be made 0.

  • For ex: If A is acquired by H and A is moved to stop consolidation, then A should not be made visible in the “Add Investments” page of H and by default, the investments of A will become 0.

• When the user edits the investment percentage,

  • If the updated value is greater than the existing value, then the “Further Investments” form will be generated and gets added to the forms in the “Group Structure – Matrix view” page.

  • If the updated value is less than the existing value, then the user will be prompted with “Reason for decrease” – Under which it has two values – Sale to MI and Dilution through equity issue.

    • If the user selects “Sale to MI” as the reason to decrease in shareholding, then the “Sale to MI” form gets added to the forms in the “Group Structure – Matrix view” page.

    • If the user selects “Dilution through equity issue”, then no further action is required.

Group Structure Errors:

The group structure errors page displays the errors which are the basic validations to create a project.

The errors in the group structure are as follows:

• Entity’s shareholding is not mapped.

• Incomplete forms of an entity

• Acquired through BC is not filled.

• Subsidiaries without BC or Investment form

Share Holding View:

• Group Structure overview page displays the shareholding in the matrix view.

• The user will be able to navigate if and only if all the entities' shareholding is mapped and acquired through BC field is filled for all the subsidiaries.

• It displays the entities and their respective share percentages in the matrix form.

• The field structure for this page is as follows:

  • Entities name in rows and columns – Type Decimal – Auto populated – Displays the percentage entered by the entities in the “Add Investments” page.

  • MI – Type Decimal – Auto populated – Displays the balance percentage of each entity (100-group share).

  • Nature of entity – Drop down – Auto populated – Displays the nature of entity entered in “Add Entity” page – The nature of entity is with respect to the Ultimate Parent.

  • Parent – Auto populated – Text box – Displays the parent of the entity.

  • Associate of – Auto populated – Text box – Displays the parent for which the entities are associates.

Functionalities:

• The corporate controller or the corporate controller team should first fill in the COA Master before updating the forms.

• If the user tries to fill in the form without completing COA master, then the user will be prompted with a message – “Please map the COA before going to the next step”.

• When the user clicks on “Map COA” in the prompt, then the tool should navigate the user to the “COA Mapping” page.

• The user should be able to view the investments of all the entities in the Shareholding view (Matrix) page.

• The user should be able to view the logs for the selected period using “Last Edit” link.

• The log should have the following fields.