Distributing schedule details

By default, the option to distribute schedule details is enabled in the configuration of Core Consolidation in Business Modeling. When enabled, the Data Entry Schedule Detail Distribution option is displayed in the navigation panel and on the Trial Balance card. Check rules and, for each main schedule, the default detail element for detail distribution are created. The Manual Detail Distribution adjustment level is also created.

Schedule detail distribution is useful if you do not use schedules during the year and distribute the differences at the end of the year. Or, if you do not have schedule detail information from the source system and distribute the details later in the year.

With this option enabled, you import the closing balances of group accounts that have schedule details without those details and you can distribute those schedule details at a later point in time. Or, you can distribute the schedules before you import the finance data. In this case, do not change the already distributed schedules.

If the option to distribute schedule details is disabled in Business Modeling, the Data Entry Schedule Detail Distribution option is not available in Financial Consolidation. Only members of the Consolidation Modeler and Business Modeling Administrator roles can disable the option to distribute schedule details.

Select Data Transfer and Processes > Entity Data Transfer > Trial Balance > Data Entry Schedule Detail Distribution.
Specify the context.
The currency and level are specified automatically and cannot be changed. You can select main schedules when distributing schedule details.
In the Difference to distribute column, the differences are highlighted with a warning icon. To distribute the difference, specify the required amounts in the appropriate schedule detail columns until the difference is distributed completely and the warning icon changes to the success icon.

Note: If an account has intercompany information, you cannot specify any amounts in the main grid. Click the folder icon that is displayed next to the account and distribute the differences by specifying the required amounts in the appropriate schedule detail columns for intercompanies.

Note: The decimals are rounded up or down. You are not required to distribute the difference amount's decimals.

Note: To delete a specified value from the database, press Ctrl + Del or specify #delete in an appropriate cell in a schedule detail column.
If the Immediate Writeback option is enabled, the schedule detail distribution is saved automatically. If the Immediate Writeback option if disabled, click Save.
Return to the Landing Page.
On the Entity tab, click the check icon on the Trial Balance card to verify if all the steps related to the distribution of schedule details are complete.
Note: To have checks only for specific versions or periods, or both, you must create customized checks with limitations to specific versions or periods, or both.
In case you require schedule details only for closing the year, we recommend these workarounds:
- During the year, in Business Modeling, disable the standard checks regarding, for example, versions, periods, or entities.
- Keep the standard checks always disabled and create customized checks with rules that use only period 12 in the target area.