Tax Automation Columns
This section explains the valid values for columns used for Tax Automation.
Note:
The Tax Automation process uses RollForward members that have been enabled for automation using the Tax Automation user-defined property. See RollForward User-Defined Properties.
| Column | Target Account |
|---|---|
| Values | A base member of the valid parent Tax account |
| Default | The base account is displayed by default. |
| Comment | System automatically displays base accounts. This is the account to which the Tax Automation calculation is applied. You can insert additional rules for the same account.
Note: You cannot define a Tax Automation rule and a NOL Automation rule for the same Tax Loss Carryforward target account. Caution: Do not set up Tax Automation for the following Permanent Different account: FXAdjPerm (NIBT Translation Adjustment). This account is used to store the NIBT override translation rate difference amount. |
| Column | Occurrence |
|---|---|
| Values | 1 or any consecutive number above 1 |
| Default | 0 |
| Comment | When you define additional rules for the same account, the system automatically increases the occurrence value by 1. This value indicates how many rules are defined for the same target account. |
| Column | Logic |
|---|---|
| Values | Pull, Move, Squeeze, National Adjustment, Annualize, Prior Year |
| Default | None |
| Comment | This column is required. From the drop-down list, you must select one of the valid calculation logic methods. See Tax Automation Calculation Methods. |
| Column | Percent |
|---|---|
| Values | Any number between -100 and 100. |
| Default | 100% |
| Comment | The percentage parameter used for the logic calculation. |
| Column | Source Account |
|---|---|
| Values | One or more valid accounts, separated by a semi-colon (;). The source accounts must be descendants of TaxAccounts or OtherTaxAccounts. They can also be book accounts for certain logic types. They can be base or parent accounts. This column is required. |
| Default | Defaults to target account for Annualize, Prior Year and National Adjustment logic. Other methods require selection of a valid account. |
| Comment | The source accounts from which the system obtains data for calculation. |
| Column | Source RollForward |
|---|---|
| Values | One valid RollForward member |
| Default | RF#TBClosingTotal |
| Comment | The source RollForward member from which the system obtains data for calculation.
Note: If you specify National Adjustment logic in Tax Automation, the Source Rollforward field is disabled. |
| Column | Source Scenario |
|---|---|
| Values | One valid Scenario member |
| Default | Not required. If not specified, the POV Scenario is used. |
| Comment | The source Scenario member from which the system obtains data for calculation. |
| Column | Source Year |
|---|---|
| Values | One valid Year member |
| Default | Not required. If not specified, the POV Year is used. |
| Comment | The source Year member from which the system obtains data for calculation. For Prior Year logic, the current year and future years are not valid. |
| Column | Source Period |
|---|---|
| Values | One valid Period member |
| Default | Not required. If not specified, the POV Period is used. |
| Comment | The source Period member from which the system obtains data for calculation. |
| Column | Source ICP |
|---|---|
| Values | One valid Intercompany Partner (ICP) Top member |
| Default | ICP {None} |
| Comment | The source ICP member from which the system obtains data for calculation. This column is used to specify an ICP Top Member to enable the Tax Automation process to include Elimination values. |
| Column | Target Entities |
|---|---|
| Values | One or more valid base entities or valid entity lists, separated by a semi-colon (;) |
| Default | <Blank> for ALL base entities in the application |
| Comment | If you specify an entity or a list of entities, the calculation applies only to those entities. If you do not specify an entity, the calculation applies to all base entities. Entity specification applies to both Source and Target. |
| Column | Excluded Entities |
|---|---|
| Values | One or more valid base entities or valid entity lists, separated by a semi-colon (;) |
| Default | None |
| Comment | Identifies the entities to be excluded for processing. Entity specification applies to Source and Target. |
| Column | Target Jurisdiction |
|---|---|
| Values | One or more valid Jurisdiction members or lists, separated by a semi-colon (;). Jurisdiction is only available for Regional accounts. Must be a base member of AllRegional, and a valid region of the entity's domicile. |
| Default |
For a Regional account, <blank>. The system uses all active regions. |
| Comment | The automation process is done only for one of the active regions of the entity's domicile country. The specification applies to both Source and Target Jurisdiction. |
| Column | Target ReportingStandard |
|---|---|
| Values | One or more valid ReportingStandard base members or lists, separated by a semi-colon (;). |
| Default | <Blank> for ALL ReportingStandards (with the exception of [None]) |
| Comment | The automation process is done only for the specified ReportingStandard. The specification applies to Source and Target ReportingStandard. |
| Column | Target RollForward |
|---|---|
| Values | One valid RollForward member or multiple members from a predefined member list |
| Default | RF#CYSys |
| Comment |
The target RollForward member. If the PULL method is specified, the member must have the Tax Automation UD keyword, and must have IsCalculate setting enabled. |
You do not need to specify the following dimension information, as the system uses these members for processing by default.
| Column | Default Member |
|---|---|
| Source DataCategory |
DC#SourcePreTax |
| Target DataCategory |
DC#PreTax_Input |
| Entity |
The system uses the same member as the Target member. |
| Source Jurisdiction |
Source Jurisdiction can only be specified for Regional Target accounts. For National accounts, the system uses the Jurisdiction member based on the entity's Domicile UD code. |
| Source TaxType |
TT#AllTaxTypes |
| Target TaxType | Based on Jurisdiction member specified. For example:
|
| Column | Disable Rules |
|---|---|
| Values | Selected or deselected |
| Default | Deselected |
| Comment | If selected, the rule is disabled for the specified period. |