RollForward Dimension
The RollForward dimension is used to capture all current year’s activity for a specified Tax account. This movement dimension contains members to capture the movement of the tax account balances from the Opening to the Closing of the account.
Different movement hierarchies are set up in the dimension to be used for different types of accounts. Below are examples of the hierarchies in the application.
Note:
Do not change or remove members from the hierarchy in the RollForward dimension, with the exception of the FinesTotal and PenaltiesTotal hierarchies noted below.
ClosingReclassDTNR—Captures the movement activities for the Tax accounts. This includes the opening balance, current period movement (including reversal, adjustments, Return to Accrual adjustment, impact from tax rate changes, and Net Benefit of Region (NBR) adjustment), Non Provisioning Adjustments for the period, and any FX adjustments. The members of the hierarchy capture every movement activity from Opening to Closing balance. Most adjustments can be manually input by the user, and some of the movement activities are calculated by the system through rules.
TBClosingTotal—Captures the Trial Balance closing amount loading from G/L and the auto adjustment calculated by the system when there is a difference between the Trial Balance and the Book data.
TaxLossCreditTotal—Captures activities for any specified Tax Loss or Tax Credit account, including the original amount available to use, the actual utilization during the period, additional adjustments, and any FX movement.
TrialBalanceBS—Captures the movement of Book data and Trial Balance data, the difference between Book and Tax from opening to closing for Balance Sheet accounts.
TrialBalancePL—Captures the difference between Book and Tax closing amount for the current period for Profit and Loss accounts.
FinesTotal—Captures the details of each fine paid during the period. Modify the members of this hierarchy to include the appropriate Fines details for the application. The existing Fines members created as part of the sample tax application are examples only and you should remove or update them as needed.
PenaltiesTotal—Captures the details of each penalty paid during the period. Modify the members of this hierarchy to include the appropriate penalty details for the application. The existing penalty members created as part of the sample tax application are examples only and you should remove or update them as needed.
There are also many Close hierarchies in the RollForward dimension to be used for reporting purposes. Below are some Movement hierarchies used in data entry forms or reports.
TempDiffClosing—Movement hierarchy for Temporary Differences. No NBR or RC or Reclass.
ClosingDTNR—Movement hierarchy for Deferred Tax National Provisioning. No ReClass.
RegionalClosingDTNR—Movement hierarchy for Deferred Tax Regional Provisioning Temporary Differences. No NBR or Reclass.
RegionalClosing—Movement hierarchy for Deferred TARF Regional Provisioning. No NBR.
Below is the high-level main structure of the RollForward dimension. Additional detail for each sub-structure is explained in subsequent sections.
![Sample Rollforward account list Sample Rollforward account list](img/rollforward.gif)
ClosingReclassDTNR—This hierarchy captures the movement activities for the Tax accounts from Opening to Closing balance. Most of the members in bold and italic type are calculated by the system through rules. Parent members are aggregated based on the aggregation weight factor defined in Node Attributes. The remaining base members are for user input.
Do not modify or remove members of this hierarchy.
![Sample list of Closing accounts Sample list of Closing accounts](img/closing.gif)
TaxLossCreditTotal—This hierarchy captures activities for any specified Tax Loss or Tax Credit account, including the original amount available to use, the actual utilization during the period, additional adjustments, and any FX movement.
Do not modify or remove members of this hierarchy.
![Sample list of Tax Loss Credit Total accounts Sample list of Tax Loss Credit Total accounts](img/taxloss.gif)
FinesTotal and PenaltiesTotal—These two hierarchies are used to capture the details of fines or penalties paid during the period. Modify the members of this hierarchy to include the appropriate fines details for the application. The existing Fines and Penalties members (*) created as part of the sample tax application are examples only and you should remove or update them as needed.
![Sample Fines and Penalties Total accounts Sample Fines and Penalties Total accounts](img/finestotal.gif)
Specifying RollForward Members for Tax Automation
To enable RollForward members for the Tax Automation process, you must specify the TaxAutomation user-defined property. See Account User-Defined Properties.
Specifying Exchange Rate Calculation Methods
For Exchange Rate calculations, you can specify if a RollForward member should be translated at the Opening Rate or Average Rate using the OpeningRate user-defined property. See Account User-Defined Properties.