To create a group chart of accounts based on legal accounting, that data must first be imported into the respective company. Further information can be found in the guide 1.2 Upload accounting files. It is also possible to create a group chart of accounts based on, for example, an Excel file.
The group chart of accounts can be found under "Group Financials" -> "Group Consolidation".
Click on "Accounting plan".
Then click on the tab "Accounting plan" below, where the group charts of accounts are created.
The accounts marked in red, as above, mean that the accounts are not in the group chart of accounts.
If there are accounts marked in purple, this means that they are in the group chart of accounts but under a different name. This may mean that the account needs to be bridged to the correct group account. See below under "Account bridges".
The next step is to select the accounts to be included in the group chart of accounts.
To include an account in the group, check the box in front of it and then select the "Manage" button.
Now click on "Use accounts in corporate group" to include the accounts in the group chart of accounts. Continue with all the accounts highlighted in red in both subsidiaries.
Use an existing group chart of accounts
If you already have a group account plan that you want to use, you can click on the down arrow next to "New group account" and then choose "Paste accounts".
Write the account number and account name or copy from, for example, Excel, in the new window. The account and name will appear in the section below the box.
Click on "Paste accounts" and these will be imported into the group chart of accounts.
Sub-groups
If there are subgroups in the group structure, it is advisable to create a group chart of accounts at the top of the group and then share it with the subgroups. It's not possible to share "from the bottom and up".
There is a down arrow next to "New group account". Below that, you will find the "Share chart of accounts to group" function.
Account bridge
In the guide How do I create an account bridge? you can read more about bridging an account and how it is set up.
The advice is to start at the "lowest" group level and then work your way up to ensure that all accounts are bridged correctly from the bottom to the top. However, it is important to remember that an account bridge only takes place on group data and does not affect the legal accounting that is imported. An account bridge only works after importing data into the group.
It is not a disadvantage to have many accounts in your group chart of accounts, as it facilitates follow-up at the group level. What is important to bridge is if two different accounts mean the same thing but are in different places in the organization's chart of accounts, or if you have foreign companies with a different number series than the one you want in the group.
It is not recommended to bridge a profit and loss account to a balance sheet account because this affects the group's results. If it is still needed, this should be kept in mind during the follow-up.
Mark the relevant accounts and click "Bridge accounts" to bridge.
Now select the group account to which you want to bridge. You can also set a time limit for the bridge, in which case select a time interval. Then click on "Save" to save the account bridge.
You can also bridge accounts by clicking on the tab "Accounting plan" and the sub-tab "Account bridges" and then on "New Account bridge".
Fill in the boxes marked in the image below.
Account groups
Account groups can be created in the "Account groups" tab with the accounts to be included in specific groups. These groups can be used in the reports. Variables that can be used are automatically created.
Account settings
Here, you can set up automatic bookings that will end up in the group, such as Goodwill, currency changes, and minority. These are important to do at start-up so that everything ends up correctly in the group.
Row template
In the Row template tab, you can restructure how the group table should look. The row template is saved and can be used in tables you create yourself.
Import corporate accounting
Whenever a change is made in the group chart of accounts, the accounting must be imported into the group again.
Click on the "Group data" -> "Accounting data" tab. Click on "Import corporate accounting". Now, the legal accounting will be imported to the group and transferred to group data according to the group chart of accounts. This completes the process of creating a group chart of accounts.
If the accounting data is completely uploaded, the periods in the list will turn green.
Green = OK, accounting data is imported.
The system checks that the result on the accounts [3000-8999] is the same in the legal accounting as it is in the group imported data. Otherwise, it will be yellow.
Yellow = There are differences in accounting data between subsidiary and group companies.
Blue = There is accounting data ready to be imported into the group
Red = Accounting data is not imported
Gray = Subsidiary was not owned during the period indicated in grey