Balance sheet continuity schedule

After submitting the movement details, the Variation Auto amount will be recalculated by the variation calculation. When the movement details are entered correctly, the continuity schedule should balance and the Variation Auto column should show a zero amount.

Movement classification within the Anaplan Financial Consolidation application allows administrators to manage the appearance of movements and the availability of movement and account combinations for input. It also allows for defining which movement and account combinations require intercompany level input. It means they'll be protected, and data will only be allowed to be input at the trading partner level.

The system requires these member tags for the Balance Sheet Continuity Schedule form:

You must set these SysNames in the movement dimension:

The system also requires global variables for the Balance Sheet Continuity Schedule input form to work.

To access the Balance Sheet Continuity Schedule input form:

1. Select the Explorer module.
2. Expand the Global > Consolidation > Input.
3. Right-click the form and select Open. Alternatively, double-click the form to open it.

The key parameters of the input form are:

Once you have selected the parameters, the input form displays:

• The account parameter selected.
• 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.

In the form, if the cell is:

• Pale yellow: The movement classification allows input for that account.
• Dark yellow: The movement classification requires intercompany input for that account. You can right-click on the cell and select Intercompany Detail to launch the Balance Sheet Intercompany Detail form. 
• White: All white cells are protected.  

Dropdown lists in an input template that are selectable are white with blue text.

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:

If you have a member tagged as #TotalIntercompanyLeaf, that member is used instead in the Intercompany dimension.

Data input into the form is submitted to the intersection below. Enter values for the available dimensions.

Set the Global Attribute BSContinuity_SupressEmptyOpenClose to TRUE to suppress rows where both the closing and opening balances are zero in the Balance Sheet Continuity Schedule.