Account Dimension

The Account dimension provides accounts for data entry of all data required for the tax application. This dimension includes accounts from the source trial balance or accounting book, as well as the tax accounts used for calculation and provisioning within the application. Additional accounts exist for configuration purposes.

Some accounts are defined as part of the Tax Provision application and you should not modify or remove them. These accounts are described in subsequent sections.

The Book Accounts are created by the administrator based on its Chart of Accounts. The sample Tax Provision application provides sample accounts for the Balance Sheet and Profit and Loss. If you start an implementation using this sample tax application, you should remove the Book Accounts and replace them with your own Chart of Accounts. Additional information regarding Book Accounts setup is explained in subsequent sections.

Account Groupings

The Account dimension is organized into the following subgroups. The top member of each subgroup is defined as “GROUPLABEL” account type.

Sample list of Accounts
GroupComments
CurrencyRatesThe accounts in the CurrencyRates subgroup (Opening rate, Closing rate, Average rate) are exchange-rate accounts to be used for currency translation. You can replace them with your own exchange rate accounts.

The default rate for Balance account and default rate for Flow account Exchange Rate accounts are also referenced in the Application Setting section. Therefore, any changes to the Exchange Rate accounts should also be reflected in the Application Setting.

TaxSettingsThe accounts in the TaxSettings subgroup are tax rate accounts used to calculate the National tax provision and Regional tax provision. It contains Opening and Closing tax rates for the current year to use for calculating Current tax expense and Deferred tax. For Regional tax calculation, it also contains the apportionment percentage and the calculated apportionment tax rate account for the Opening and Closing rate. Other tax settings for Return to Accrual (RTA) calculations are also included in this subgroup.
BookAccountThe accounts in the BookAccounts subgroup are source accounts from your application and can be replaced by your own Chart of Accounts. It should contain accounts in the Balance Sheet (Assets/Liabilities/Equities), as well as the accounts in Profit and Loss (Income/Expense).

In the Book accounts, you can capture Trial Balance data from the G/L or accounting book data from the consolidation application, such as Financial Management. You can capture both sets of data in the same account, since the type of data is stored in the DataCategory dimension.

In the application, the system automatically calculates the difference between the Trial Balance and the Book amount and stores the difference in the TBClosingAutoAdjustment RollForward dimension member.

TaxAccountsThe accounts in the TaxAccounts subgroup are used to calculate the current and deferred tax provision for national and regional tax. They include accounts for temporary difference and permanent difference adjustment, as well as accounts for reclassification. There are also accounts for the total tax credits and tax losses for current period and carry-forward from prior periods.

Some of the parent accounts in this subgroup are considered system accounts, and you should not remove or change them. You should create temporary difference and permanent difference accounts for your application. The sample tax application contains some temporary and permanent difference accounts as examples.

OtherTaxAccountsAdditional tax accounts are included in this subgroup. This includes accounts for storing the calculated Valuation Allowance allocation percentage and amount, Statutory and Regional Effective Tax Rate (ETA) calculation, and Consolidated ETA rate information.

Most tax accounts are system accounts used for calculation. You should not remove or change them.

SupplementalSchAccountsThe accounts in the Supplemental Schedule Accounts subgroup are tax accounts used for supplemental detail reporting purposes. An example of supplemental details included in the sample tax application is the set of Fines and Penalties accounts. These accounts provide additional details regarding specific fine or penalty information, which are permanent differences on the current provision.

This subgroup of accounts contains accounts for storing the National Tax Credits and Losses. Additional detail information for any carryforward amount from prior years is stored in the DataCategory members by year, as well as the detail activities for opening balances, current year amount. Expiration and utilization details are stored in the RollForward members for these accounts.

Another example of accounts included in this subgroup is to capture the current period activity and the closing balance of the temporary difference based on the Book versus the Tax Basis Balance Sheet.

You can configure these accounts for your implementation and remove them if they are not needed.

TARF AccountsThe accounts in this subgroup are used to capture the balance of the Tax Accounts (including total expenses, deferred assets, and liabilities) as calculated by the tax provision and compare the amounts to the source system, so that the Tax Journal Entry can be used to adjust the source system at the individual legal entity.
TaxBasis Balance SheetThe accounts in the Tax Basis Balance Sheet subgroup are the Balance Sheet accounts used to capture balance sheet data for Tax Basis purpose. It should have a similar account structure as the Book Accounts subgroup, but should have additional temporary difference accounts to reflect what the balance should be for tax basis.
ReportsThe accounts in the Reports subgroups are set up as alternative hierarchies to use strictly for reporting purposes.
ValidationAccountsThe accounts in this subgroup are accounts used for validation purposes. They are used for validating Total NOLs, Total Effective Tax rate – CETR, SETR, RETR to ensure that totals are balanced.