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:

  1. Create or view a data form that contains an intersection that was calculated.

  2. 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