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

Column	Disable Rules
Values	Selected or deselected
Default	Deselected
Comment	If selected, the rule is disabled for the specified period.