This form is used to input balance sheet continuity data by a trading partner. This can be done for any account where the movement classification has the intercompany flag set to TRUE.
Movement classification movement allows administrators to control the movements that will be displayed and the availability of movement and account combinations for input. It also enables the selection of specific movement and account combinations that must be entered at the trading partner level.
Prerequisites
The system requires these member tags for the Balance Sheet Intercompany Detail input form:
| Dimension | Element | Tag |
| Account | Balance Sheet | #BalanceSheet |
| Audit | Contribution | #Contribution |
| DataView | Value | #Value |
| DataView | All Dataviews (main root) | #AllDataViews |
| Intercompany | No Intercompany | #NoIntercompany |
| Intercompany | Total Group (main root) | #TotalGroup |
| Measure | Amount | #Amount |
| Movement | All Movements (main root) | #AllMovements |
| Movement | CTA Parent | #CTA |
| Movement | Scope Parent | #Scope |
| Movement | Closing | #Closing |
| Scenario | Actual | #Actual |
Note: Member tagging is done within the Anaplan Financial Consolidation Model Manager.
Set these required SysNames in the Movement dimension:
| Dimension | Element | Tag |
| Movement | Allocation | #Allocation |
| Movement | Automatic Variation | #Automatic Variation |
| Movement | Automatic Variation Year 1 | #Automatic Variation Year 1 |
| Movement | Business Acquisition | #Business Acquisition |
| Movement | Closing | #Closing |
| Movement | Opening | #Opening |
| Movement | Result Period | #Result Period |
The system also requires global variables for the input form.
| Variable Name | Value |
| CurrentPeriod | <Name of the Current Period>. For example: 2026 P3. |
You must ensure that audit members are set as the p_Audit property in the Entity dimension. Data input into the Balance Sheet Intercompany Detail is input to the audit member set on the selected entity parameter.
Access the input form
To access the Balance Sheet Intercompany Detail input form:
- Select the Explorer module.
- Expand the Global > Consolidation > Input.
- Right-click the Balance Sheet Intercompany Detail form and select Open. Alternatively, double-click the form to open it.
Alternatively, right-click a cell in the Balance Sheet Continuity Schedule input form where it requires intercompany input to launch the Balance Sheet Continuity Schedule input form. Movement classification defines it and is highlighted as a dark yellow cell.
You can also launch the input form by right-clicking on a cell.
Note: Your administrator may have moved the form to another location, or it may be started as part of a process.
Parameters
The key parameters of the input form are:
| Variable Name | Value |
| Entity | Select the name of the entity. |
| Account | Select the selection of accounts under the account tagged as #BalanceSheet. |
| Period | It defaults to the value set in the global variable CurrentPeriod. |
| Scenario | It defaults to the scenario tagged as #Actual. |
Select these parameters only if you launch the input form directly and not from within the Balance Sheet Continuity Schedule.
Use the input form
Once you have selected the parameters, the input form displays:
- Rows display Intercompany members under #TotalGroup.
- Columns display Movements. The account movement classification defines the movements displayed. Elements tagged under #CTA, and #Scope are always hidden.
Refer to Movement Classification to know more. - The last two columns should be the difference between closing – (Opening + all movements) and a check column showing if the difference is zero.
Note: Any difference is plugged to the Variation Auto member upon submission. If the Period and Scenario combination selected isn't open, the form is locked.
These columns, if displayed, are only in read-only mode:
- Opening
- Allocation
- Business Acquisition
- Variation (Auto)
- Variation (Year 1)
- Result of Period
- Closing
- Difference
- Check
These read-only columns are pulled from this intersection:
| Dimension | Member |
| Account | The account parameter selected. |
| Audit | The member tagged as #Contribution. |
| Currency | The local currency of the selected Entity. |
| DataView | The member tagged as #AllDataViews. |
| Date | The date parameter selected. |
| Entity | The entity parameter selected. |
| Intercompany | The intercompany member defined in the row. |
| Measure | The member tagged as #Amount. |
| Movement | The movement defined in the column. |
| Scenario | The scenario parameter selected. |
| Extra Dimensions | Any extra dimensions, such as product or cost center are set to the default input member of the dimension. |
Data input into the form is submitted to the intersection below. Enter values for the available dimensions.
| Dimension | Member |
| Account | The account parameter selected. |
| Audit | The audit member set as the aAudit property of the entity, p_Audit. |
| Currency | The local currency of the selected Entity. |
| DataView | The member tagged as #Value. |
| Date | The date parameter selected. |
| Entity | The entity parameter selected. |
| Intercompany | The intercompany member defined in the row. |
| Measure | The member tagged as #Amount. |
| Movement | The movement defined in the column. |
| Scenario | The scenario parameter selected. |
| Extra Dimensions | Any extra dimensions, such as product or cost center are set to the default input member of the dimension. |
In an input form, if cells are:
- White: These cells are protected and can't be edited.
- Pale Yellow: These cells are editable. The movement classification allows input for that account.
- Dark Yellow: The movement classification requires intercompany input for that account.
Dropdown lists in an input template that are selectable are white with blue text.
