If you use multiple Coins ERP+ companies (kcos) to record the transactions of other group entities (subsidiaries, associates, joint ventures, etc.), you may need to produce single entity and/or "consolidated" reports.
This is more complex if the functional currency (base currency) is different from one company to the next - "consolidated" reports often need to use a common "presentation" currency. This may also require including varying percentages of joint venture(s).
The GL reporter allows you to:
Vary the base/alternative base currency for particular columns that use company groups and make it different from the one chosen for the whole report.
Apply a percentage rate to the column value. For example, in joint ventures you may only want to count part of the total value in the consolidated figures.
To configure a consolidated report:
Use company Group Maintenance to set up company groups as required:
Set up a group that contains all the companies you want to consolidate across.
Set up groups for each combination of companies you want to show in a single column. For each of these groups, all the companies in the group should use the same base currency or alternative base currency.
It is useful to also create a company group for each individual company. This allows company comparisons within a single report.
Typically you would write the report in the company that uses the presentation currency as its base currency.
On each row, in the company Group field, enter the company group that includes all the companies you want to report on.
On each column, when adding any relevant decimal item (Opening Balance, Closing Balance and Movement) :
In the company Group field, enter the company group that includes the companies whose figures you want to add together. These could be groups that include a single company only, or they could include several companies that use the same base or alternative base currency.
Specify which currency to show (the base currency or one of the alternative base currencies).
For example, if you have companies as follows:
company | Base currency | Alternative |
1 | GBP |
|
2 | EUR | GBP |
3 | USD | GBP |
you would use a company group on the report rows that includes companies 1, 2 and 3. You could then configure separate report columns for each company:
Column 1 would specify a group that only included company 1, and would use "base" currency.
Column 2 would specify a group that only included company 2, and would use "alternative base 1".
Column 3 would specify a group that only included company 3, and would use "alternative base 1".
Alternatively, you could consolidate companies 2 and 3 in a single column, using a group that included both companies, and again used "alternative base 1".
To report a percentage of the total (for a joint venture):
When adding any relevant decimal item (Opening Balance, Closing Balance and Movement):
Enter the percentage to report on in the Reported Percentage field.