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.

ColumnTarget Account
ValuesA base member of the valid parent Tax account
DefaultThe base account is displayed by default.
CommentSystem 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.

ColumnOccurrence
Values1 or any consecutive number above 1
Default0
CommentWhen 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.
ColumnLogic
ValuesPull, Move, Squeeze, National Adjustment, Annualize, Prior Year
DefaultNone
CommentThis column is required. From the drop-down list, you must select one of the valid calculation logic methods. See Tax Automation Calculation Methods.
ColumnPercent
ValuesAny number between -100 and 100.
Default100%
CommentThe percentage parameter used for the logic calculation.
ColumnSource Account
ValuesOne 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.
DefaultDefaults to target account for Annualize, Prior Year and National Adjustment logic. Other methods require selection of a valid account.
CommentThe source accounts from which the system obtains data for calculation.
ColumnSource RollForward
ValuesOne valid RollForward member
DefaultRF#TBClosingTotal
CommentThe 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.

ColumnSource Scenario
ValuesOne valid Scenario member
DefaultNot required. If not specified, the POV Scenario is used.
CommentThe source Scenario member from which the system obtains data for calculation.
ColumnSource Year
ValuesOne valid Year member
DefaultNot required. If not specified, the POV Year is used.
CommentThe source Year member from which the system obtains data for calculation. For Prior Year logic, the current year and future years are not valid.
ColumnSource Period
ValuesOne valid Period member
DefaultNot required. If not specified, the POV Period is used.
CommentThe source Period member from which the system obtains data for calculation.
ColumnSource ICP
ValuesOne valid Intercompany Partner (ICP) Top member
DefaultICP {None}
CommentThe 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.
ColumnTarget Entities
ValuesOne or more valid base entities or valid entity lists, separated by a semi-colon (;)
Default<Blank> for ALL base entities in the application
CommentIf 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.
ColumnExcluded Entities
ValuesOne or more valid base entities or valid entity lists, separated by a semi-colon (;)
DefaultNone
CommentIdentifies the entities to be excluded for processing. Entity specification applies to Source and Target.
ColumnTarget Jurisdiction
ValuesOne 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.

CommentThe 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.
ColumnTarget ReportingStandard
ValuesOne or more valid ReportingStandard base members or lists, separated by a semi-colon (;).
Default<Blank> for ALL ReportingStandards (with the exception of [None])
CommentThe automation process is done only for the specified ReportingStandard. The specification applies to Source and Target ReportingStandard.
ColumnTarget RollForward
ValuesOne valid RollForward member or multiple members from a predefined member list
DefaultRF#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.

ColumnDefault 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 TaxTypeBased on Jurisdiction member specified. For example:
  • If the Jurisdiction is a base member of AllNational, then the TaxType is National.

  • If the Jurisdiction is a base member of AllRegional, then the TaxType is Regional.

ColumnDisable Rules
ValuesSelected or deselected
DefaultDeselected
CommentIf selected, the rule is disabled for the specified period.