Adding RollForward Members

You can add additional RollForward members under these sections:

  • Provision section (P&L section)

  • Non provision section

  • Equity adjustment section

  To add a RollForward member under the Provision section:

  1. Add the member as a sibling of the ContingencyDO member and before the RCTotal member.

  2. Ensure that the new member is added to the following hierarchies so that the predefined data forms display the new member:

    • CYDTNRTotal

    • TempDiffCYTotal

    • TempDiffCYTotalTR

  To add a RollForward member under the Non provision section:

  1. Add the member as a sibling of the DisposalsNP member and before the EquityNPTotal member.

  2. Ensure that the new member is added to the following hierarchies so that the predefined data forms display the new member:

    • NPDTNRTotal

    • NPTotal

    • TempDiffNPTotal

    • RegionalNPTotal

  To add a RollForward member under the Equity Adjustment section:

  1. Add the member as a sibling of the EquityOtherNP member and before the RCEquityTotal member.

  2. Ensure that the new member is added to the following hierarchies so that the predefined data forms display the new member:

    • EquityNPTotal

    • TempDiffEquityNPTotal

    • TempDiffEquityNPTotalTR

These user-defined properties apply to new RollForward members:

To ensure that the data is included in ETR rate reclassification calculations, use these properties to specify the Destination account for each RollForward member:

PropertyValue
UD PropertyDestAcVA
ValuesValid RollForward member, for example, VAOther
PropertyValue
UD PropertyDestAcDef
ValuesValid RollForward member, for example, DefTaxOther
ExampleOtherSys: UD1 = DestAcVA:VAOther^DestAcDef:DefTaxOther
  • To ensure that the data is included in the TARF movement hierarchy, use these properties:

    PropertyValue
    UD PropertyTARF1
    ValuesValid RollForward member, for example, RF#OtherSys

    When you specify the RollForward member for the TARF1 keyword, the member name should be preceded by “RF#”.

    ExampleTARFOtherDeferredSys: UD1 = TARF1:RF#OtherSys
  • To ensure that the data is included in Tax Automation, use these properties:

    PropertyValue
    UD PropertyTaxAutomation
    ValuesYes or No
    ExampleOtherSys:UD1=TaxAutomation:Yes

After you add new members and specify the user-defined properties, you must modify data forms to include the new members. You can modify data forms using either of these methods:

  • Use the Data Form Designer page.

  • Manually edit the data form script.

  To edit data forms using the Form Designer:

  1. Select Consolidation, and then Documents, and open a data form.

    Tip:

    If the Designer page is not automatically displayed, click Designer, or select Actions, and then Designer.

  2. Click Edit, or select Actions, and then Edit.

  3. Select the column where you want to insert the new member, and then click Add New Column, or select Actions, and then Add New Column.

  4. Drag and drop the RollForward dimension from the POV Dimensions list, select the dimension and then select the corresponding member.

  To edit data forms using the form script:

  1. Select Consolidation, and then Documents, and open a data form.

  2. From the form toolbar, click Script, or select Actions, and then Script.

  3. Insert a column for the new member and adjust the column numbers.

For example, the following columns exist in a form:

  • C1=RF#RTADO

  • C2=RF#ContingencyDO

  • C3=RF#RCTotal

If you insert a new RollForward member after the ContingencyDO member, the script would show these columns for the form:

  • C1=RF#RTADO

  • C2=RF#ContingencyDO

  • C3=RFNewMember

  • C4=RF#RCTotal

The following table lists the forms that include individual members from a RollForward hierarchy.

Data FormRollForward Hierarchy
Deferred TaxClosing
Deferred Tax RegionalRegionalClosing
Deferred Tax for TARClosingReclass
Deferred Tax for TAR RegionalRegionalClosingReclass
Deferred Tax - IFRSClosingDTNR
Deferred Tax for TAR - IFRSClosingReclassDTNR