Viewing Tax Automation Trace Information
If you run Tax Automation for selected entities with the trace capability, you can view the details of how the data is calculated based on the source data. You view trace information from a data form that contains an intersection that was calculated. For example, if Tax Automation with Trace is run for NIBTBA1, you can go to the Current Provision and view the intersection of the Account and RollForward.
Note:
If you loaded the sample files during the installation process, you can view sample data forms that display trace information: Tax Automation Trace, and Tax Automation Trace Regional.
To view Tax Automation trace information:
- Create or view a data form that contains an intersection that was calculated.
- From the data form, right-click and select Cell Text.
The data form displays the cell text information, including the Tax Calculation method, percentage, Source amounts, and amount calculated from Tax Automation. If the MOVE calculation method was used, the cell text displays the current period amount and the last period of the prior year amount for each Source account.
Data Form - Tax Automation Trace National
This form displays the trace information for National accounts.
Rows: National Tax accounts - descendants of NTaxAutomation hierarchy
Columns: Tax automation-supported RollForward members
POV: W#YTD.V#<Entity Currency>.I#[ICPNone].DC#PreTax_Input.TT#National
Selectable POV: Scenario/Year/Period/Entity/ReportingStandard
Data Form - Tax Automation Trace Regional
This form displays the trace information for Regional accounts.
Rows: Regional Tax accounts - descendants of RTaxAutomation hierarchy
Columns: Tax automation-supported RollForward members
POV: W#YTD.V#<Entity Currency>.I#[ICPNone].DC#PreTax_Input.TT#Regional
Selectable POV: Scenario/Year/Period/Entity/ReportingStandard/Jurisdiction
Cell Text Format Example 1
Logic: Pull
Percentage: 50%
Source POV1 Amount: 100
Source POV2 Amount: 200
Source POV3 Amount: 150
Total: 450
Calculated amount: 225
Cell Text Format Example 2
Logic: Move
Percentage: 50%
SourceAcct1/Current period: 500
SourceAcct1/Prior Year: <200>
SourceAcct2/Current period: 800
SourceAcct2/Prior Year: <300>
Total: 800
Calculated amount: 400