The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 76.
See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100"
Accounts (con't)
See KB article: "Dimension - Accounts (1/2)"
See KB article: "Dimension Member Names - Renaming and Deleting"
See KB article: "Dimension Text Fields - Summary"
TXP_ETRStatTotal – Total Statutory ETR
TXP_PTIAdjustedTotal
- This is the same parent as in TXP_CurTaxExp.
TXP_PermDiffTotal
- This is the same parent as in TXP_CurTaxExp.
TXP_ETRLocalTotal
- TXP_TaxLocalDeductionTotal - This is the same member as in TXP_CurTaxExp.
- TXP_ETRNatBen prefixed accounts hold national benefit deferred expense data.
- TXP_ETRLocal prefixed accounts hold local jurisdiction current and deferred expense data.
TXP_LocalExp
- This is the same member as in TXP_CurTaxExp.
TXP_OtherTaxTotal
- This is the same parent as in TXP_CurTaxExp.
TXP_Adjustment_Total
- This is the same member as in TXP_CurTaxExp.
TXP_AdjustmentOther_Dscr
- This is the same parent as in TXP_CurTaxExp.
TXP_ETRVATotal
- Valuation allowance data from the deferred tax flow members of TXP_TaxClosing.
TXP_ETRRTPTotal
- TXP_AdjustmentRTP_Total – This is the same parent as in TXP_CurTaxExp.
- TXP_ETRRTPAdj – Return to Provision true-up deferred tax data.
TXP_ETRDeferredTotal
- Rate change impact and other deferred tax expense data.
TXP_ETRStatSubTotal
- If a new TXP_CurTaxExp account member is added as a sibling to TXP_LocalExp add the new account here as a child of TXP_ETRStatSubTotal.
TXP_ETRConsolTotal – Total Consolidated Rate Reconciliation
TXP_PTIAdjustedTotal
- This is the same parent as in TXP_CurTaxExp.
TXP_ETRLocalTotal
- This is the same parent as in TXP_ETRStatTotal.
TXP_TxRateDiffTotal
- TXP_TaxRateDiff is the calculated tax rate differential between the Consolidated Tax Rate and the Statutory tax rate.
- TXP_LocalExp is the same member as in TXP_CurTaxExp.
TXP_PermDiffTotal
- This is the same parent as in TXP_CurTaxExp.
TXP_OtherTaxTotal
- This is the same parent as in TXP_CurTaxExp.
TXP_Adjustment_Total
- This is the same member as in TXP_CurTaxExp.
TXP_AdjustmentOther_Dscr
- This is the same parent as in TXP_CurTaxExp.
TXP_ETRVATotal
- This is the same parent as in TXP_ETRStatTotal.
TXP_ETRRTPTotal
- This is the same parent as in TXP_ETRStatTotal.
TXP_ETRDeferredTotal
- This is the same parent as in TXP_ETRStatTotal.
TXP_ETRConsolOther
- If a new TXP_CurTaxExp account member is added as a sibling to TXP_LocalEXP add the new account here as a child of TXP_ETRConsolOther.
The numbers in the screen shot below correspond to the numbers above.
The Tax Account Reconciliation (TXP_TxRAccountRecon) hierarchy provides summary level data for Current and Deferred Tax Expenses as well as related Balance Sheet Data (Deferred Tax Asset & Liability, Tax Payments & Refunds). It is intended to allow for the comparison of the equivalent General Ledger accounts and to facilitate preparation of the required Tax Entry back to the General Ledger.
This account hierarchy works in conjunction with the UD2 TXP_TXRecData hierarchy. The data is populated via business rules and displayed in Schedule 7 Tax Account Reconciliation.
TXP_TxRAccountRecon Setup Notes
- All accounts in this hierarchy are prefixed with TXP_TxR. The naming convention should be followed when adding a new account.
- Data is split between prior year (TXP_TxRAdjustedOpeningBal) and current year (TXP_TxRCurrentYear).
- Data input is only allowed in the Reclassification accounts; all others are populated via business rules.
When to Add a New Account
- The following situations will require a new account(s) to be added to either the prior year or current year section, along with Business Rules updates and Cube View updates.
- New TXP_CurTaxExp account: New Child of TXP_Adjustments_GL is added.
- New TXP_CurTaxExp account: New Base member of TXP_AdjustmentRTP_Total is added.
- New Flow Tax Closing (TXP_TaxClosing) member is added, except when the new member is added to TXP_TotalDefBSO or TXP_TotalDefOther.
Account overview
- TXP_TxRAccountRecon is the amount of the tax journal entry. It is based on the tax ending balance (TXP_TxREndingBalance) less the general ledger data (TXP_TxRperGL) through the use of the Aggregation Weight property.
- TXP_TxRperGL is intended to hold the general ledger data (most likely loaded via Data Management).
- The Aggregation Weight on this account is -1.00
- TXP_TxREndingBalance has an Aggregation Weight of 1.00 and is the sum of prior year and current year tax data.
- TXP_TxRAdjustedOpeningBal has the prior year data.
- TXP_TxROpeningBal is populated using rules from the prior year December closing balance.
- For the siblings of TXP_TxROpeningBal note in the description which schedule the data is coming from.
- TXP_TxRPYReclassIncSt and TXP_TxRPYReclassBalSheet allow input.
- TXP_TxRCurrentYear has the current year data.
- All children, except the reclassification lines, note in the description which schedule the data if coming from.
- TXP_TxRCYReclassIncSt and TXP_TxRCYReclassBalSheet allow input.
- TXP_TxRFXTotal
- FX data is detailed by opening balance, the current period, and prior periods.
- Do not modify these accounts.
- TXP_TxRAccountRecon_TotalActivity is an alternate Account hierarchy used in the calculation of the FX impact.
- It has an Aggregation Weight of 0.00 .
- Any new activity account added to TXP_TxRAdjustedOpeningBal will need to be added to this hierarchy.
- All accounts under the parent TXP_TxRCurrentYear are considered activity.
- TXP_TxRAdjustedOpeningBal has the prior year data.
TXP_TaxPaymentsDiff
This is an alternate reporting hierarchy to view the combined total of tax payments and refunds, and tax withholding payments (from Schedule 4 Tax Payments / Schedule 4 FC Tax Payments).
TXP_TaxPaymentsDiff Setup Notes
- TXP_TaxPaymentsDiff
- This parent account is the difference between TXP_TaxPayments (tax provision total payments and refunds) versus TXP_TaxPaymentsGL (what is in the General Ledger).
- Aggregation weight is 0.00
- TXP_TaxPaymentsGL
- Is intended to hold the general ledger data (most likely loaded via Data Management).
- The Aggregation Weight on this account is -1.00
- TXP_TaxPayments
- This parent account is the subtotal of all the tax payments and refunds, including withholding tax.
- The base accounts are the same members as in TXP_TxRAccountRecon.
- The Aggregation Weight on this account is 1.00.
- If new payment or refund accounts are added to TXP_TxRAccountRecon check to see if they should also be added to this alternate account hierarchy
- Note that accounts TXP_TaxPaymentsDiff and TXP_TaxPaymentsGL are not currently displayed on Schedule 4 Tax Payments / Schedule 4 FC Tax Payments. They will need to be added to the cube views, if needed.
TXP_OtherAccounts
This account structure contains accounts that facilitate the Tax Provision Blueprint calculations and the display of data in schedules and reports.
TXP_OtherAccounts Setup Notes
- The original accounts should not be modified, except for the descriptions.
- New accounts may be added as needed.
- TXP_Year is used for the Origin Year (Form: 3 Tax Attributes and populated through Business Rules).
- TXP_TXMemoRTP is used with a year and month Flow Member in Business Rules to determine the RTP timing. It is used in Cube Views, Business Rules, and parameters.
- TXP_Nat_Excl_LocalJD is designed to facilitate Entity National calculations where only specific Local Jurisdictions are included.
- TXP_Nat_Benefit_Excl_LocalJD is set up to facilitate the National Benefit calculation (used in Business Rules, Cube Views, and Parameters).
- TXP_LossesNotBenefited_Flag is set up to indicate if a base entity is a Losses Not Benefited entity (populated in a schedule and used in Business Rules).
- TXP_NatDeferredwLocal_ETRLocal is used for the Local jurisdiction ETR rules (Statutory ETR and Consolidated ETR). If a new subtotal within the TXP_NatDeferredwLocal is added and required for the Local jurisdiction ETR, the new (parent) account will need to be added to this alternate Account hierarchy. This hierarchy excludes Equity and Valuation Allowance data.
- TXP_CurTaxExp_AltDiscreteView is an alternate view that subtotals Discrete and Non-Discrete accounts. If a new account is added to TXP_CurTaxExp, it should also be in this hierarchy.
- TXP_FCETR_ConsolTotal is the Total Forecasted consolidated ETR hierarchy. This is an alternate view of the Consolidated ETR where the data is grouped by non-discrete and discrete data. If a new account is added to TXP_ETRConsolTotal confirm the account is in this hierarchy too.
- TXP_ETRInterim_Total is the Total Interim Reporting Rate Reconciliation hierarchy. It allows for the calculation of Losses Not Benefited related to pretax income. Data is grouped by non-discrete and discrete data. Used in Schedule 18 & Schedule 18 FC.
- TXP_ETRInterimApplied_Total is the Total Applied Interim Reporting ETR hierarchy. This applies to Actuals only. Used in Schedule 10.
- TXP_FX_Rates base members are dynamic accounts used to allow reporting on the FX Rates.
- TXP_Data_Copy is used in two Dashboards to help in the copy of Provision and Return data.
- TXP_Annotation_Accounts holds the Filer accounts (TXP_LocalFiler, TXP_LocalFilerType, TXP_NatFiler, TXP_NatFilerType, TXP_NatFilerCalc) are used in the Group Filer Definitions schedules. Also, holds the time stamp annotation information after running a specific bulk copy.
- TXP_xDLTotal is an alternate hierarchy that combines local only permanent differences and temporary differences. This is used in data copy Dashboards to help display data variances.
- TXP_FCST_Data_Copy accounts used in Dashboards to help in the copy of (Actual) data into a Forecast scenario.
- TXP_Blank is used to help in the formatting of cube views to suppress data.
