This form can be used to input the trial balance data into Anaplan Financial Consolidation.

The system requires these member tags for the Trial Balance input form:

DimensionElementTag
AccountBalance Sheet#BalanceSheet
AccountIncome Statement#NetIncome
DataViewValue#Value
EntityTotal Group (main root)#TotalGroup
IntercompanyNo Intercompany#NoIntercompany
IntercompanyTotal Group (main root)#TotalGroup
MeasureAmount#Amount
MovementClosing#Closing
ScenarioActual#Actual

Note: Member tagging is done within the Anaplan Financial Consolidation Model Manager.

The system also requires global variables for the input form.

Variable NameValue
CurrentPeriod<Name of the Current Period>. For example, 2026 P3.

The system requires these attributes to be set:

  • p_TrialBalanceInputType: Set by entity, this property defines the method by which the entity enters their Trial Balance data. Valid values are Input or Import. Any entities where the p_TrialBalanceInputType is set to Import won't be allowed to input data into the Trial Balance Input application.
  • p_Audit: Audit members must be set as the property in the Entity dimension. Data input into the Trial Balance Input is input to the Audit member set on the selected Entity parameter.

To access the Balance Sheet Continuity Schedule input form:

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

Note: Your administrator may have moved the form to another location, or it may be started as part of a process.

The key parameters of the input form are:

Variable NameValue
EntityIt's a list of all non-elimination entities where the p_TrialBalanceInputType isn't set to Import.
PeriodIt defaults to the value set in the global variable CurrentPeriod.
ScenarioIt defaults to the scenario tagged as #Actual.

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

  • Rows display accounts tagged as #BalanceSheet, and #NetIncome.
  • In the columns, there's a column that contains a link to the Intercompany input for any intercompany accounts and the closing dataview to input your trial balance data.
    Intercompany accounts are any account set up in the Intercompany Matching detail rules. They aren't set up in the intercompany bookings rules or the consolidation detail rules.
  • Current earnings account (SysName = CurrentEarnings) is protected.
  • When you submit data, the net income to retained earnings calculation runs and the net income data is then copied to the current earnings account.

Data input into the form is submitted to the intersection below. 

DimensionMember
AccountThe account defined in the row.
AuditThe audit member set as the audit property of the entity, p_Audit.
CurrencyThe local currency of the selected entity.
DataViewThe member tagged as #Value.
DateThe date parameter selected.
EntityThe entity parameter selected.
Intercompany
  • If p_TrialBalanceInputType is blank, it uses the member tagged as #NoIntercompany.
  • If p_TrialBalanceInputType = Input, it uses the member tagged as #TotalGroup, all parent totals in the input form are also pulled from #TotalGroup. Intercompany information can only be loaded through the Trial Balance Intercompany Detail Input form in this scenario.
MeasureThe member tagged as #Amount.
MovementThe member tagged as #Closing.
ScenarioThe scenario parameter selected.
Extra DimensionsAny extra dimensions, such as product or cost center, are set to the default input member of the dimension.

Note: If the period and scenario combination selected isn't open, the input form will be locked.

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.