Reviewing The Deferred Tax Rollforward Regional Forecast Reports

Tax Provision calculates a detailed forecasted deferred tax and forecasted interim deferred tax provision. The forecasted national deferred tax is the sum of the deferred tax for the Actual time period and the Interim time period (remainder of the year).

Deferred Tax Rollforward Forecast report (RF0401)

This report contains tax-affected data for the accounts that appear in the Temporary Differences Forecast input app (RF0301).

Note: For more information on reports, see Working with Reports.

This report contains the following symbols in the Elements dimension:

• NetREOY_ASC — Regional EOY Deferred Tax Asset/(Liability)

  The end of the year Actuals deferred tax balance. For more information on these symbols, see “Deferred Tax Rollforward report (NA0401)”.

• NetRCYIP_ASC — Regional Interim Current Year

  This column represents the tax impact of the interim current year temporary differences that are used in the calculation of the current provision. This balance equals the amount in the gross temporary difference column multiplied by the current year tax rate. Since the tax impact of these adjustments is reflected in the current provision, this is not reflected in the effective tax rate.

• NetRCurDfdIP_ASC — Regional Interim Other Adjustments - Current and Deferred Impact

  This column represents the tax impact of the activity posted into the Other Adjustments - Current and Deferred column of the gross temporary difference rollforward. This balance is equal to the amount in the gross temporary difference column multiplied by the current year tax rate. This adjustment impacts the deferred provision and the current provision in an equal and opposite amount in an additional provision item.

• NetRDfdIP_ASC — Regional Interim Other Adjustments - Deferred Only

  This column represents the tax impact of the activity posted into the Other Adjustments - Deferred Only column of the gross temporary difference rollforward. This balance is equal to the amount in the gross temporary difference column multiplied by the current year tax rate. This is treated as a deferred provision only adjustment, which means that this adjustment is part of the deferred provision and is also reflected as an adjustment on the effective tax rate report.

• NetRRCCYrIP_ASC — Regional Interim Deferred Tax Impact - Change in Tax Rates CY

  This column represents the impact of the current year activity by the difference between the current year tax rate and end of year deferred rate.

• NetRTotBDAIP_ASC — Regional Interim Before Discrete Adjustments

  This column is the sum of the previous interim columns.

• NetRRTPDfdIP_ASC — Regional Interim RTP - Deferred Only Impact

  This column represents the tax impact of the activity posted into the Regional Interim RTP - Deferred Only Impact Reversal column of the gross temporary difference rollforward. This balance is equal to the amount in the gross temporary difference column multiplied by the current year tax rate.

• NetRARDfdIP_ASC — Regional Interim RAR - Deferred Only Impact

  This column represents the tax impact of the activity posted into the Regional Interim RAR - Deferred Only Impact column of the gross temporary difference rollforward. This balance is equal to the amount in the gross temporary difference column multiplied by the current year tax rate.

• NetRRCCYIP — Regional Interim Rate Change Reversal

  This column is automated within the system to remove the net regional tax expense or benefit of the regional tax rate change calculated on the interim elements. This amount is removed from the annualized deferred effective tax rate and is automatically treated as a discrete amount.

• NetREOYIP_ASC — Regional Interim EOY Balance

  The end of the year regional interim deferred tax balance.

• NetNEOYFcst_ASC — Forecast EOY Balance

  This symbol is the sum of the end of year regional actuals and the end of year regional interim values.

To review the Deferred Tax Rollforward Forecast report:

1. In the Tax Provision navigation pane, click Reports.
2. Expand Regional Interim.
3. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
4. Click RF0401 - Deferred Tax Rollforward Forecast.rtp. The report opens in the workspace.
5. Review the account values for each appropriate element. For more information on the accounts in this report, see Deferred Tax Rollforward Forescast report (RA0401).

Deferred Tax Rollforward Forecast - Scheduling report (RF0402)

Entities using the deferred tax scheduling methodology use the same format and calculations as the deferred tax rollforward with the following differences:

• The end of period deferred tax balance is based on the sum of the deferred tax balances for each of the scheduled years. Since the tax rates may differ during the years over which the temporary difference is expected to reverse, the ending balance is a sum of the calculated deferred tax balances for each year.
• The tax rate change is based on the average deferred tax rate calculated by dividing the ending deferred tax balance as calculated by the end of period gross temporary difference and not on the deferred tax rates entered in the Tax Rates input app (XRC0201 or XRC1201).

Note: For more information on reports, see Working with Reports.

This report contains the same Elements as the Deferred Tax Rollforward Forecast report (RF0401), with the following additional symbols:

• NetREOYBDAFcst_ASC — Regional Forecast EOY Deferred Tax Before Discrete Adjustments

  This column represents the sum of the Actuals EOY and the Interim EOY values, excluding the discrete adjustments.

• NetREOY1_ASC — Regional Balance Reversing in Year 1

  This column represents the regional amount reversing in the first year.

• NetREOY1IP_ASC — Regional Interim Balance Reversing in Year 1

  This column represents the regional interim amount reversing in the first year.

• NetREOYFcst1_ASC — Forecast Total Balance Reversing in Year 1

  This column represents the regional forecast amount reversing in the first year. It is calculated as the sum of NetREOY1_ASC and NetREOY1IP_ASC.

• NetREOY2_ASC — Regional Balance Reversing in Year 2

  This column represents the regional amount reversing in the second year.

• NetREOY2IP_ASC — Regional Interim Balance Reversing in Year 2

  This column represents the regional interim amount reversing in the second year.

• NetREOYFcst2_ASC — Forecast Total Balance Reversing in Year 2

  This column represents the regional forecast amount reversing in the second year. It is calculated as the sum of NetREOY2_ASC and NetREOY2IP_ASC.

• NetREOY3_ASC — Regional Balance Reversing in Year 3

  This column represents the regional amount reversing in the third year.

• NetREOY3IP_ASC — Regional Interim Balance Reversing in Year 3

  This column represents the regional interim amount reversing in the third year.

• NetREOYFcst3_ASC — Forecast Total Balance Reversing in Year 3

  This column represents the regional forecast amount reversing in the third year. It is calculated as the sum of NetREOY3_ASC and NetREOY3IP_ASC.

• NetREOY4_ASC — Regional Balance Reversing in Year 4

  This column represents the regional amount reversing in the fourth year.

• NetREOY4_ASC — Regional Balance Reversing in Year 4

  This column represents the regional amount reversing in the fourth year.

• NetREOYFcst4_ASC — Forecast Total Balance Reversing in Year 4

  This column represents the regional forecast amount reversing in the fourth year. It is calculated as the sum of NetREOY4_ASC and NetREOY4IP_ASC.

• NetREOY5IP_ASC — Regional Interim Balance Reversing in Year 5

  This column represents the regional interim amount reversing in the fifth year.

• NetREOY5_ASC — Regional Balance Reversing in Year 5

  This column represents the regional amount reversing in the fifth year.

• NetREOYFcst5_ASC — Forecast Total Balance Reversing in Year 5

  This column represents the regional forecast amount reversing in the fifth year. It is calculated as the sum of NetREOY5_ASC and NetREOY5IP_ASC.

To review the Deferred Tax Rollforward Forecast - Scheduling report:

1. In the Tax Provision navigation pane, click Reports.
2. Expand Regional Interim.
3. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
4. Click RF0402 - Deferred Tax Rollforward Forecast - Scheduling.rtp. The report opens in the workspace.
5. Review the account data for each scheduling period. For more information on the accounts in this report, see Temporary Differences input app (RA0301).

Deferred Tax Rollforward Interim report (RF0403)

The deferred tax rollforward report shows the current period deferred tax activity for an entity for temporary differences, net operating losses, tax credits, and valuation allowances.

Note: For more information on reports, see Working with Reports.

This report contains tax-affected data for the accounts that appear in the Temporary Differences input app (RA0301).

This report contains the following symbols in the Elements dimension:

To review the Deferred Tax Rollforward Interim report:

1. In the Tax Provision navigation pane, click Reports.
2. Expand Regional Interim.
3. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
4. Click RF0403 - Deferred Tax Rollforward Interim.rtp. The report opens in the workspace.
5. Review the account values for each appropriate element. For more information on the accounts in this report, see Temporary Differences Forecast input app (RF0301).

Deferred Tax Classification Interim report (RF0404)

This report shows the breakdown of the deferred tax asset / (liabilities) into one of the following classifications:

• Regional Interim Current Deferred Tax Asset
• Regional Interim Current Deferred Tax Liability
• Regional Interim Non-current Deferred Tax Asset
• Regional Interim Non-current Deferred Tax Liability

The classification of these items is based on:

• The “Current or Non-Current” column. This setting determines whether the balance is classified in the current or non-current columns.
• The balance in symbol NetREOYCLSSIP_ASC — Interim EOY Deferred Tax Asset/(Liability). If this balance is positive, the amount is classified as an asset. If this balance is negative, the amount is classified as a liability.

The deferred tax ending balance is considered an asset if:

• For all temporary differences except valuation allowances:

  NetREOYCLSSIP_ASC > 0 or
  NetREOYCLSSIP_ASC = 0 and NetRBOYA_ASC > 0 or
  NetREOYCLSSIP_ASC = 0, NetRBOYA_ASC = 0, and NetRBOY_ASC > 0

• For valuation allowance accounts, the sign is reversed:

  NetREOYCLSSIP_ASC < 0 or
  NetREOYCLSSIP_ASC = 0 and NetRBOYA_ASC < 0 or
  NetREOYCLSSIP_ASC = 0, NetRBOYA_ASC = 0, and NetRBOY_ASC < 0

Otherwise, the ending balance is considered a liability.

Note: For more information on reports, see Working with Reports.

This report contains the following symbols in the Elements dimension:

To review the Deferred Tax Classification Interim report:

1. In the Tax Provision navigation pane, click Reports.
2. Expand Regional Interim.
3. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
4. Click RF0404 - Deferred Tax Classification Interim.rtp. The report opens in the workspace.
5. Review the account values for each appropriate element. For more information on the accounts in this report, see Deferred Tax Rollforward Forecast report (RF0401).

Deferred Tax - for Tax Account Rollforward Interim report (RF0405)

This report shows the breakdown of the deferred tax rollforward into further detail for each Element, for use in Tax Account Rollforward mappings.

Note: For more information on reports, see Working with Reports.

The deferred tax rollforward is classified as one of the following:

• Current Deferred Tax Asset
• Current Deferred Tax Liability
• Non-Current Deferred Tax Asset
• Non-Current Deferred Tax Liability

The classification of these items is based on:

• The “Current or Non-Current” column. This setting determines whether the balance is classified in the current or non-current columns.
• The balance in symbol NetNEOY_ASC — EOY Deferred Tax Asset/(Liability). If this balance is positive, the amount is classified as an asset. If this balance is negative, the amount is classified as a liability.

The deferred tax ending balance is considered an asset for all deferred tax accounts except valuation allowances if the value in element NetNEOY_ASC — EOY Deferred Tax Asset/(Liability) is greater than zero. For the valuation allowance accounts, the balance is treated as an offset to the asset balance if the value in element NetNEOY_ASC — EOY Deferred Tax Asset/(Liability) is less than zero. Otherwise, the ending balance is considered a liability.

Your administrator can use the Current and Deferred Tax editor to indicate the account level at which the classification of the deferred tax balances is determined. The highest level account selected is used as the classification level. For more information, see the Longview Tax Administrator’s Guide.

In addition to the above classification processes, Tax Provision also reviews the classification of balances between the end of the period and the beginning of the year to determine if there has been a change in the overall classification of deferred balances (i.e. current asset at beginning of year is a current liability at the end of the period). If there is a classification change, the reclass elements provide the adjustment that is mapped to the Tax Account Rollforward to automate the reclassification adjustment (reflected in the Reclassification of Deferred Tax Accounts row of the tax account rollforward).

This report contains the following symbols in the Elements dimension (across):

• NetREOYCLSSIP_ASC — Regional Interim EOY Deferred Tax Asset/(Liability)

  The interim deferred tax balance at the end of the year.

• NetRClassIP_ASC — Regional Interim Tax Classification

  The parent element of the classified deferred tax rollforwards for Current Asset, Current Liability, Non-Current Asset, and Non-Current Liability, along with their related beginning of year reclass adjustments.

To review the Deferred Tax - for Tax Account Rollforward Interim report:

1. In the Tax Provision navigation pane, click Reports.
2. Expand National Interim. 
3. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector. 
4. Click RF0405 - Deferred Tax - for Tax Account Rollforward Interim.rtp. The report opens in the workspace.
5. Review the account values for each appropriate element. For more information on the accounts in this report, see Deferred Tax Rollforward Forecast report (RF0401).