Working with National Tax Automation

Tax automation rules can be defined as Global Rules, Domicile Rules, and Entity Rules. When you create a global rule using the Tax Automation Global form, when it is saved, the rule is copied to all Domiciles and Entities.

If required, the Global rule can be overridden at the Domicile or Entity level. When you create a Domicile rule using the Tax automation Domicile form, when it is saved, the rule is copied to all Entities that belong to that domicile. If required, this rule can be overridden at Entity level.

You can add multiple rules for each account. To enhance the flexibility of tax automation, you can perform the following for each rule that is created:

Select a different tax automation rule (Logic). You can create two or more rules all using the same Logic or a different logic selection for each one. Logic selections include Pull, Movement, Squeeze, Annualize, DeAnnualize, National Adjustment, and Prior Year.
Select a different source (Source Account). You can select a different Source Account for each rule, or the same Source Accounts for one or more of the rules.
Select a different Scenario (Source Scenario) member for each rule.

Tax automation is executed when you perform Consolidation.

To run National Tax Automation:

From the Home page, click Application, and then click Overview.
Click the Dimensions tab, then under the Data Source dimension, create the Data Source members that you require to store tax automation rules. See Adding Tax Automation Rules to Data Source Dimension.
On the Home page, click Tools, then Variables.
On the User Variables tab, under Account, select the Tax Automation Target Account form, and then click Save. The account is displayed on the Tax Automation form.
On the Home page, click Application, then Configuration, and then click Tax Automation.

Note:
If the period has not been started, the Global Rules screen will be blank.

Select the appropriate tax automation rule scope:

Global Rules - Global rules apply to all entities regardless of domicile. When you update a global rule in the Tax Automation Global form, the modified rule is cascaded to all Entities. After a global rule is cascaded to all Domiciles and Entities it shows up in the Tax Automation Domicile and Tax Automation Entity forms. If required, global rules can be overridden at the Domicile or Entity level. By default, only users with a System Administrator role can cascade global rules to all Domiciles and Entities after saving global rules.
Users or groups must be granted Launch permission to the Tax Automation Global Save business rule to cascade and manage global rules.
Domicile Rules - Domicile rules apply to all entities associated with a particular domicile. Domicile refers to the country or jurisdiction where the entity pays tax. For example, Canada is the national domicile for legal entity Montreal, and US is the national domicile for legal entity New York. When you modify a domicile rule in the Tax Automation Domicile form and save it, the rule is cascaded to all entities that belong to the selected domicile.
After a domicile rule is cascaded to all Entities, it shows up in the Tax Automation Entityform. If required, domicile rules can be overridden at the Entity level. By default, only users with a System Administrator role can cascade domicile rules to the appropriate entities after saving domicile rules.

Users or groups must be granted Launch permission to the Tax Automation Save business rule to cascade and manage domicile rules.
Entity Rules - Entity rules apply to the entity that you selected.

Note:

By default only users with a System Administrator role can cascade global and domicile rules to the appropriate entities after saving global or domicile rules.
Users with a Power User or User role must be granted Launch permission to the Tax Automation Global Save business rule to cascade and manage global rules.
Users with a Power User or User role must be granted Launch permission to the Tax Automation Save business rule to cascade and manage domicile rules.
No business rule Launch permissions are required for cascading and managing Entity Rules.

For example, a Service Administrator can grant Launch permission for the Tax Automation Global Save rule to the Global Automation Admins group from the Rules card. This enables members of the Global Automation Admins group to modify and cascade Global tax automation rules.

The table below shows the corresponding business rule and form for each national tax automation rule scope.

Table 20-4 Tax Automation National

Scope	Cascading Business Rule	Form
Global Rules	Tax Automation Global Save	Tax Automation Global
Domicile Rules	Tax Automation Save	Tax Automation Domicile
Entity Rules	N/A	Tax Automation Entity

Note that the cascading Global and Domicile rules must not be updated at Domicile and Entity levels. It is recommended to always disable the cascading rules and create local Domicile and Entity rule if cascading rules are not required. For example, you have a Global rule to PULL 100% from Account X, and then at a specific Domicile you need to update the rule to PULL at 50% from Account X. To achieve this, you must disable the Global rule at the Domicile level and then create a new Domicile rule which pulls 50% from Account X. You must not update the cascading Global rule at the Domicile level.

The same is applicable for cascading Domicile rules at Entity level.

Optional: If the page is blank, under Actions, select Tax Automation, and then Show All Accounts. This step adds a new blank rule for each tax account. See Adding Tax Automation Rules to Data Source Dimension.
Right-click the rule name cell (for example, Global Rule 1) to display the pop-up menu, and select Tax Automation, and then Add Rule to create one additional rule for each tax account. The rule is created at the bottom as a last rule, and the selected rule data is copied into the newly created row.

Note:
When adding the rule, ensure that placeholder members have already been created on the Data Source dimension, otherwise, the Add Rule will not create a new row. You can add Rule 2 only after Rule 1 has been defined and saved. See Adding Tax Automation Rules to Data Source Dimension
Click Save to save the rule.
Optional: Right-click the rule name cell to display the menu, and select Tax Automation, and then Delete Rule to delete one rule per account. The Delete rule deletes the selected rule by shifting the rules up from the bottom of the list. Deleting the first row only clears the rule, and the row is not removed.

Note:
You cannot delete Global rules from the Domicile form, and you cannot delete Global and Domiciles rules from the Entity form.
Optional: Under the Disabled column, select Disabled to exclude the entity from the calculation. By default, Enable is selected for all base entities.

For example, to override Global and Domicile rules by an Entity rule, set the Global and rules to Disabled, and then enable an Entity Rule to override the other rules and redirect the values.
Under Logic, from the drop-down, select the logic to be applied to the row. You can select a different tax automation rule for each rule created for the account. The following rules are available:
- Pull--Takes the specified percentage of the Source account and applies it to the Target account
  Example:
  - PULL 50%
  - Source Account : 100
  - Destination = (100 * 50%) = 50
- Movement--Takes the difference between the current period amount of the Source account and the last period of the prior year's amount of the Source account, and applies the amount to the Target account.
  Example:
  - MOVE 20%
  - Source Account: Prior Year: 100; Current: 150
  - Destination = ((150-100) * 20%) = 10
- Squeeze--The value at the intersection of the source Account and source Movement must equal the ending balance in Temporary Differences for the target Account when squeezing from the book or any supplemental schedules.
  Squeeze from supplemental schedule (such as Fixed Assets):
  - Example 1: Fixed Assets:
    - Source Account/Movement = -8110 (Book Basis minus Tax Basis for Property and Related Plant, and Current Year Movement)
    - Ending Balance Temporary Differences for target Account/Movement = -8110
      
      Note:
      If any other Movements for the target account are populated on Temporary Differences, they will be "squeezed out" (subtracted) so that the ending balance remains the value of the Source Account/Movement.
  - Example 2:
    - Fixed Assets Source Account/Movement = -8110 (Book Basis minus Tax Basis for Property and Related Plant, and Current Year Movement)
    - Ending Balance Temporary Differences for target Account/Movement remains at = -8110.
    - Opening Balance Adjusted on Temporary Differences for target Account = 1000
    - The Difference between the Opening Balance Adjustment 1000 and P&L Total Movement -9100 still equals -8110
  Squeeze when source data is Book Data:
  - When no source or target Movement is specified in Tax Automation, the source Movement defaults to TB Closing and the target movement defaults to Automated (Current Year). A valid Source book account must be specified.
  - The value will display in Temporary Differences in Movement Automated and the Ending Balance = Source Book Account value.
- Annualize—Allows partial year amounts to be annualized to a full year amount.
- DeAnnualize—Allows full year values to be De-Annualized to a partial year amount based on the period of the rule.
- National Adjustment—Allows for adjustment (for example, reversal) of a National Permanent or Temporary Difference in the Regional Provision.
- Prior Year—Provides the ability to bring the prior year data into a provision.
Note:

For detailed examples of Annualize, DeAnnualize, National Adjustment and Prior Year logic, see Tax Automation Logic Examples.
For examples of creating rules that contain a combination of multiple rules to perform a transaction, see Creating Tax Automation Using Multiple Rule Combinations.
Under Percentage, enter a whole number or decimal number to represent the percentage of the book data to be copied to the selected entity. For example, for 100%, enter 1, or for 50%, enter .5. The figures display correctly when you exit the cell.
Under Source Account, select the source account number from which you want to copy data. You can select a different Source Account for each rule created for the account.
Under Source Movement, select the Movement member which you want to use to move the data.
From the drop-down under Target Movement, select the Movement member which you want to use to move the data. If no value is selected, the default is Automated for the Movement dimension.
Under Source MultiGAAP, select the Multi-GAAP member from which the data will be drawn.
From the drop-down under Target MultiGAAP, select the Multi-GAAP member to which you want to move the data.
From the drop-down under Source Scenario, select the Scenario from which data will be drawn. You can define a different Scenario member for each rule.

Note:
Changes in data in the source Scenario will not impact the target scenario based on the Tax Automation rules. For example, if a Tax Automation rule is defined to Pull data from the source GAAP scenario, any data changes in the GAAP Scenario system will not impact the STAT Scenario. Set the business rule Impact Entities with Data in Consol Cube.
For Intercompany Eliminations only, from the drop-down under Source ICP, select the Intercompany member which you want to use as the source to calculate Intercompany eliminations. You can define a different Intercompany source member for each rule.
From the drop-down under Source Data Source, you can only select the Data Source members which have Tax Automation Source Data Source attribute attached. When you don’t select the Source Data Source column, then by default Source Data Source member is set as Pre Tax.

You can define a different Data Source member for each rule.

Note:
A new custom attribute Tax Automation Source Data Source is added in Data Source dimension. See also: Defining Data Source Tax Attributes
.
Click Save. You can see which entities have been impacted by viewing Data Status. When you click Save, all the rules are pushed to the base Domiciles and Entities.
The base entity inherits the rules defined for Domicile specific rules, or if that is not specified, the base entity will inherit the rules defined in the Global form.
Under Actions, select Consolidate to perform Tax Automation.