Consolidation Module Control

---

Open this form under the System > Consolidations menu. The Consolidation Module Control is system wide. Settings apply to all companies using the consolidation function.

Percentage ownership

This is set to 100, and is read-only.

Elimination Level

You can set up eliminations to occur at either a general ledger account level, a transaction tree level, or both.

GL Account

Select this option to perform eliminations at a general ledger account level. If you select this option, you must nominate an elimination general ledger accounts.

Transaction Tree

Select this option to perform eliminations at a transaction tree level.

Elimination Tree

If the transaction tree option is selected, you must select the transaction tree to use when processing eliminations. You can only make one tree in Greentree Desktop the elimination tree. The elimination tree settings become read only once you set up a consolidation code with elimination tree mappings.

Period Mapping

Use this option to map financial periods from one calendar to periods in another calendar. You can consolidate companies using different general ledger calendars into a single company.

Reference

Enter a unique reference, up to 12 characters, to identify the mapping.

Description

Enter a description of the mapping.

Source calendar

Select the map FROM calendar.

Destination calendar

Select the map TO calendar.

You must save the header information and recall the mapping by reference to continue the process.

Map year from

Select a year from the source calendar. Source periods updates to the mapping table using the year selected. Click Create Default Mapping to populate period detail to the mapping table. Source periods are read-only, using the selected mapping year, and you cannot change them. However, you can select a different destination period from a dropdown list, based on the mapping to create.

Note: Once mapping changes are saved for a selected year, re-applying the Create Default Mapping does not change modified mappings.

The default mapping updates to the table based on these rules:

• If the start and end dates for a source period match the start and end dates for a destination period, map the periods 1:1.
• If the start and end dates for a source period fall within a destination period, map to that period.
• If the start and end dates for a source period do not fall entirely within a destination period, map to the period into which the end date falls.

Years that are mapped subsequent to the initial mapping is inserted into the correct order in the mapping table. For example, a subsequent year is appended and a prior year is inserted in front of existing years.

Mapping Rules:

• The selected period in the destination column must be after the selected period in the previous line.
• All periods in the source calendar must be mapped.
• Multiple source periods can be mapped to a single destination period.
• A single source period may not be mapped to multiple destination periods.
• Periods can map across financial years — for example, Source Period 1 in 2019 can map to Destination Period 7 in 2020.

If the subsidiary and consolidation company do not use the same general ledger calendar, you must specify the period mapping to be applied when the relationship is set up on the Consolidation Company Mapping Maintenance form.

• GL Account Maintenance
• Consolidation Company Mapping Maintenance

---