Tax Settings Subgroup
The Tax Settings subgroup contains accounts to capture the various settings needed for the core tax calculation for both National and Regional tax provisions.
Because the tax settings are used in the tax provision calculation, they are considered system accounts and you should not modify or remove them. The only exception is the AutoAdjTrigger account.
![Sample list of Tax Settings accounts Sample list of Tax Settings accounts](img/taxsettings.gif)
Auto Adjustment Trigger Account
The Auto Adjustment Trigger (AutoAdjTrigger) account hierarchy is used to trigger the calculation for the Trial Balance to Book closing adjustment. In applications in which Trial Balance data and Book data are loaded, a discrepancy might exist between the two amounts, because Trial Balance data is usually loaded when G/L data is available, whereas the final Book data amount could contain adjustments made to the original G/L data.
The system calculates the difference between the two amounts and automatically adjusts the Trial Balance data to be the same as Book data by storing the difference in the RollForward member RF#TBClosingAutoAdjustment.
The Auto Adjust Trigger triggers the automate adjustment process if real data exists in either the Balance Sheet or Profit & Loss accounts. To determine the proper trigger, you must include the corresponding Book account details (for example, Balance Sheet total and the Net Income total) in the AutoAdjTrigger account structure.
If you do not want the system to automatically trigger the auto-adjustment based on the Book Account data, you can configure the “AutoAdjTrigger” account as a base input account, and manually input an amount to trigger the auto-adjustment process.
Below is an example provided in the sample tax application where the Book Account structure is included in the AutoAdjTrigger hierarchy:
![Example of Automatic Adjustment Trigger account Example of Automatic Adjustment Trigger account](img/autotrigger.gif)
In the rule file, a constant keyword is used to identify the account to trigger the auto adjustments.
Const A_AUTOADJ_TRIGGER = AutoAdjTrigger
If you decide to use a different account instead of AutoAdjTrigger, then you must make corresponding changes in the rule file for the constant keyword.
OverrideTaxRates Accounts
The TaxSettings subgroup also includes an account hierarchy for OverrideTaxRates. Accounts for storing Override Tax Rates have a suffix of _TR. See Adding Override Tax Rate Accounts.
![Example of Override Tax Rates accounts Example of Override Tax Rates accounts](img/override.gif)
Tax Automation Accounts
Accounts are included in each respective hierarchy (National accounts in NTaxAutomation, and Regional accounts in RTaxAutomation) to enable tax automation. These accounts are only displayed in the Tax Automation Custom Screen.
![Tax Automation Accounts hierarchy Tax Automation Accounts hierarchy](img/taxauto_hier.gif)
Inactive Accounts
Accounts are included in each respective hierarchy (National accounts to NInactive, and Regional accounts to RInactive) to enable you to specify accounts as Active by Entity. These accounts are only displayed in the Inactive and Inactive Regional data forms.
![Inactive Accounts hierarchy Inactive Accounts hierarchy](img/inactive.gif)
Tax Apportionment Accounts
Regional tax apportionment rates by legal entity must be provided when applicable to calculate the current and deferred regional tax expense and deferred tax asset/liability. You should not modify any of the following Tax Apportionment accounts.
Table 3-3 TaxApportionmentReg – Regional Tax Apportionment - Group Label
Group | Description | Account Type | Calculated | Comments |
---|---|---|---|---|
TaxApportionmentRegOpening | Opening Regional Tax Apportionment | Balance Recurring | Yes | The opening tax apportionment rate is retrieved from the closing rate of the last period of prior year.
In the sample application, it is the rate from prior year Period P12. The retrieval is part of the rule calculations. |
TaxApportionmentRegCy | Current year Regional Tax Apportionment | Balance Recurring | No | The current tax apportionment rate is entered by the user.
This can be manually entered in the Rates form, or from data load. |
TaxApportionmentRegClosing | Closing Regional Tax Apportionment | Balance Recurring | No | The closing tax apportionment rate is entered by the user.
This can be manually entered in the Rates form, or from data load. |
ActiveRegion | Active Region Setting | Balance | Yes | The Active Region setting is used as part of the regional core tax calculation.
If regional tax is valid for the entity, the system checks whether the region is an active region to be included as part of the regional calculation. To determine whether the ActiveRegion setting should be set to 1 or not, the system checks if at least one of the three regional tax apportionment rates is entered for the region (Opening rate, Average rate or Closing rate). If any of the rates are entered, then the region is considered “active” and must be included as part of the regional tax calculation. |
Tax Rate Accounts
Income tax rates by legal entity must be provided. You should not modify any of the following Tax Rate accounts.
Table 3-4 Tax Rates - Tax Rates - Group Label
Group | Description | Account Type | Calculated | Comments |
---|---|---|---|---|
TaxRatesPY | Prior year tax rate | Balance Recurring | Yes | The national or regional statutory tax rate for the prior year. The tax rate is retrieved from the closing rate (A#TaxRatesCY) of the last period of prior year. In the sample application, it is the rate from Period P12 of prior year.
The retrieval is part of the rule calculations. |
TaxRatesCY | Current year tax rate | Balance Recurring | No | The National or Regional statutory tax rate for the current period. It is used in the calculation of the Current Provision as well as other Deferred Tax RollForward calculations. The current period’s tax rate is entered by the user. This can be manually entered in the Rates form, or from data load. |
TaxRateCurrentOpening | Opening Tax Rate - Current | Balance Recurring | Yes | The beginning of year Deferred Tax rate used for Current Deferred Assets or Liabilities.
This opening rate is retrieved from the end of the year Deferred Tax rate (A#TaxRateCurrentClosing) of the last period of prior year. In the sample application, it is the rate from Period P12 of prior year. This rate is used for Deferred Tax calculation for any Temporary Differences that are classified as Current Deferred Assets or Liabilities. The retrieval is part of the rule calculations. |
TaxRateCurrentClosing | Closing Tax Rate - Current | Balance | No | The end of the year closing Deferred Tax rate. The rate is used for Deferred Tax calculation for any Temporary Differences classified as Current Deferred Assets or Liabilities.
The current year’s closing rate is entered by the user. This can be manually entered in the Rates form, or from data load. |
TaxRateNonCurrentOpening | Opening Tax Rate - Non Current | Balance Recurring | Yes | The beginning of year Deferred Tax rate. This opening rate is retrieved from the end of the year Deferred Tax rate (A#TaxRateNonCurrentClosing) of the last period of prior year. In the sample application, it is the rate from Period P12 of prior year.
This rate is used for Deferred Tax calculation for any Temporary Differences classified as Noncurrent Deferred Assets or Liabilities. The retrieval is part of the rule calculations. |
TaxRateNonCurrentClosing | Closing Tax Rate - Non Current | Balance Recurring | No | The end-of-the-year closing Deferred Tax rate. The rate is used for Deferred Tax calculation for any Temporary Differences classified as Noncurrent Deferred Assets or Liabilities.
The current year’s closing rate is entered by the user. This can be manually entered in the Rates form, or from data load. |
TaxRateConsETR | Consolidated Tax Rate for ETR | Balance Recurring | No | The consolidated Effective Tax Rate to be used for CETR calculation. |
TaxRateCYEquity | Tax rate for Tax in Equity and Reserves | Balance Recurring | Yes | Current year tax rate for equity used for Tax in Equity and Reserves calculations. |
TaxRateCYInterCurrent | Interim Tax Provision Tax Rate for Current Tax Expenses | Balance Recurring | Yes | Current year tax rate is used for Interim Tax Provision Tax Rate for Current Tax Expenses calculations. |
TaxRateCYInterDeferred | Interim Tax Provision Tax Rate for Deferred Tax Expenses | Balance Recurring | Yes | Current year tax rate is used for Interim Tax Provision Tax Rate for Deferred Tax Expenses calculations. |
ConsolTaxRateLocal | Consolidated Tax Rate for IFRS ETR - Regional | Balance Recurring | No | The consolidated Effective Tax Rate will be applied for IFRS CETR Regional calculation. |
ConsolTaxRateNat | Consolidated Tax Rate for IFRS ETR - National | Balance Recurring | No | The consolidated Effective Tax Rate will be applied for IFRS CETR National calculation. |
Apportionment Tax Rates Accounts
You should not modify any of the following Apportionment Tax Rates accounts.
Table 3-5 Apportionment Tax Rates - Group Label
Group | Description | Account Type | Calculated | Comments |
---|---|---|---|---|
AppTaxRateCY | Current year apportionment tax rate | Balance Recurring | Yes | A calculated tax rate for the region, which takes into consideration the apportionment percentage.
AppTaxRatesCY=TaxRateCY* TaxApportionmentRegCY |
AppTaxRatesCurrentOpening | Opening apportionment tax rate - Current | Balance Recurring | Yes |
A calculated Opening tax rate for Current assets or liabilities, which takes into consideration the opening apportionment percentage. AppTaxRatesCurrentOpening= TaxRateCurrentOpening * TaxApportionmentRegOpening |
AppTaxRatesCurrentClosing | Closing apportionment tax rate - Current | Balance Recurring | Yes |
A calculated Closing tax rate for the Current assets or liabilities, which takes into consideration the closing apportionment percentage. AppTaxRatesCurrentClosing= TaxRateCurrentClosing * TaxApportionmentRegClosing |
AppTaxRatesNonCurrentOpening | Opening apportionment tax rate - NonCurrent | Balance Recurring | Yes |
A calculated Opening tax rate for the Noncurrent assets or liabilities, which takes into consideration the opening apportionment percentage. AppTaxRatesNonCurrentOpening=TaxRateNonCurrentOpening* TaxApportionmentRegOpening |
AppTaxRatesCurrentClosing | Closing apportionment tax rate - NonCurrent | Balance Recurring | Yes |
A calculated Closing tax rate for Noncurrent assets or liabilities, which takes into consideration the closing apportionment percentage. AppTaxRatesNonCurrentClosing=TaxRateNonCurrentClosing* TaxApportionmentRegClosing |
Return to Accrual Accounts
You should not modify any of the following Return to Accrual (RTA) accounts.
Table 3-6 RTACopy - Return to Accrual Copy from source to destination year - Group Label
Group | Description | Account type | Calculated | Comments |
---|---|---|---|---|
RTAYearCopy | RTA Copy Destination Year | Balance Recurring | No | The destination year that you enter to identify where to copy the RTA adjustment amount.
In the RTAYearCopy account, you must specify the start year for the RTA using the UD keyword: StartYear. See Account User-Defined Properties. |
RTAPeriodCopy | RTA Copy Destination Period | Balance Recurring | No | The destination period that you enter to identify where to copy the RTA adjustment amount. In the RTAPeriodCopy account, you specify the start period using the UD keyword StartPeriod. See Account User-Defined Properties.
The system uses the RTAYearCopy and RTAPeriodCopy information to determine the correct destination Year and Period for the RTA adjustment. |
VA Allocation Accounts
You can classify accounts differently for VA allocation calculation purposes than for financial statement purposes.
VAClassification Hierarchy
To classify account for VAClassification purposes, specify the accounts in the VAClassification hierarchy under the Tax Settings subgroup.
Note:
Make sure that you define at least one member under the VAClassification hierarchy.
![Sample VA Classification hierarchy Sample VA Classification hierarchy](img/vaclass.gif)
To use the VAClassification accounts, you must specify the VAClassLevel user-defined property.
Property | Value |
---|---|
Property Name | VAClassLevel |
Keyword | VAClassLevel |
UD Field | ALL |
Valid Entry | Yes or No |
Default | Yes |
Example | TempST0016a VAClassLevel:No |
Description | If this property is set to No, the system searches its ancestry chain for the VAClassLevel property set to Yes. When the system finds any member with the VAClassLevel set to Yes, the account is classified based on the value at the parent member.
If the property is set to Yes, or is blank, the account is classified by the base level member. Note: When the VAClassLevel property for the base account is set to No, it is recommended that you set the property to Yes for any member in the ancestry chain. |
BSClassification Hierarchy
For Financial Statement classification purposes, define accounts under the Tax Settings subgroup BSClassification hierarchy, based on the account type. Define Current accounts under the Current hierarchy, and NonCurrent accounts under the NonCurrent hierarchy.
Note:
The Temp accounts should have the default parent member pointing to the Current/NonCurrent hierarchy. For example, TempGS0006 should have the default parent property pointing to the Current parent. For Data Relationship Management (DRM) applications, make sure that the members under these hierarchies are set as primary, which is equivalent to marking the parent as the default parent. See Oracle Data Relationship Management Integrating Oracle Data Relationship Management Suite with Enterprise Performance Management.
![Sample BSClassification hierarchy Sample BSClassification hierarchy](img/finstmtclass.gif)
Note:
Make sure that you define at least one member under the Current and NonCurrent hierarchies.
VA Classifications in DataCategory
The system provides these additional DataCategory dimension members for the VA Classifications.
![DataCategory members for VA Classifications DataCategory members for VA Classifications](img/vadatacategory.gif)
These hierarchies are included in the existing hierarchies so that Permanent/Temporary accounts are valid for VA Classifications:
-
AppRegionalCurrent
-
AppRegionalNonCurrent
-
PreTaxNationalCurrent
-
PreTaxNationalNonCurrent
-
PreTaxRegionalCurrent
-
PreTaxRegionalNonCurrent
-
PreTaxNationalRegionalCurrent
-
PreTaxNationalRegionalNonCurrent
-
TaxNationalCurrent
-
TaxNationalNonCurrent
-
TaxRegionalCurrent
-
TaxRegionalNonCurrent
Moving the VA Allocation Amounts to Tax Account Rollforward
You use the TARF1 user-defined property to specify how the VA Allocation amounts should flow into the Tax Account Rollforward, based on their classification level (VA Classification, or Financial Statement).
![Sample VA Classification accounts in Tax Account Rollforward Sample VA Classification accounts in Tax Account Rollforward](img/vatotarf.gif)
![Sample Financial Statement accounts in the Tax Account Rollforward Sample Financial Statement accounts in the Tax Account Rollforward](img/fstotarf.gif)