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 (SF0401R / SF0401S / SF0401G)

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

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

This report contains tax-affected data for the Temporary Difference Forecast Accounts and the following symbols in the Elements dimension:

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

  The end of the year Actuals deferred tax balance.

• 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.

• NetRAFCCYIP- Regional Interim Deferred Tax Impact - Change in Apportionment Factors CY

  This column represents the impact of the current year activity by the difference between the current year apportionment factor and the end of year apportionment factor.

• 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.

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

  The end of the year regional interim deferred tax balance.

• MSP_NetREOYFcst_ASC — Forecast Regional EOY Deferred Tax Asset/(Liability)

  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. Do one of the following:
   1. To view all regions report:
      1. Expand All Regions.
      2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
      3. Click SF0401R - Deferred Tax Rollforward Forecast.The report opens in the workspace. The forecast deferred tax elements are displayed with the values for the total of all regions.
   2. To view the separate regions report:
      1. Expand Separate.
      2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
      3. Click SF0401S - Deferred Tax Rollforward Forecast.
      4. Select a region to display in the report. The report opens in the workspace. The selected region is displayed as a column above the forecast deferred tax elements.
   3. To view the group regions report:
      1. Expand Group.
      2. Use the drop-down list or the symbol selector to select the appropriate region. For more information, see Using the Symbol Selector.
      3. Click SF0401G - Deferred Tax Rollforward Forecast. The report opens in the workspace. The selected region is displayed as a column above the regional groups within the selected region. Below each regional group the forecast deferred tax elements are displayed.
3. Review the account values for each appropriate element.

Deferred Tax Rollforward Forecast - Scheduling report (SF0402R / SF0402S / SF0402G)

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 tax-affected data for the Temporary Difference Forecast Accounts and the same Elements as the Deferred Tax Rollforward Forecast report (SF0401R / SF0401S / SF0401G), 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.

• NetREOY5ConsAdj — Regional Consolidation Adjustment - Scheduling Impact

  The column holds the consolidation adjustment for regional groups using the group consolidation adjustment calculation method. Only the group adjustment entity will have values in this column.

• 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.
   1. To view all regions report:
      1. Expand All Regions.
      2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
      3. Click SF0402R - Deferred Tax Rollforward Forecast - Scheduling. The report opens in the workspace. The forecast deferred tax elements with the values for the total of all regions.
   2. To view the separate regions report:
      1. Expand Separate.
      2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
      3. Click SF0402S - Deferred Tax Rollforward Forecast - Scheduling.
      4. Select a region to display in the report. The report opens in the workspace. The selected region is displayed as a column above the forecast deferred tax elements.
   3. To view the group regions report:  
      1. Expand Group.
      2. Use the drop-down list or the symbol selector to select the appropriate region. For more information, see Using the Symbol Selector.
      3. Click SF0402G - Deferred Tax Rollforward Forecast - Scheduling. The report opens in the workspace. The selected region is displayed as a column above the regional groups within the selected region. Below each regional group the forecast deferred tax elements are displayed.
2. Review the account data for each scheduling period.

Deferred Tax Rollforward Interim report (SF0403R / SF0403S / SF0403G)

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 Forecast input app (SSF0301 / SGF0301).

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. Do one of the following:
   1. To view all regions report:
      1. Expand All Regions.
      2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
      3. Click SF0401R - Deferred Tax Rollforward Interim. The report opens in the workspace. The interim deferred tax elements are displayed with the values for the total of all regions.
   2. To view the separate regions report:
      1. Expand Separate.
      2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
      3. Click SF0401S - Deferred Tax Rollforward Interim.
      4. Select a region to display in the report. The report opens in the workspace. The selected region is displayed as a column above the interim deferred tax elements.
   3. To view the group regions report:
      1. Expand Group.
      2. Use the drop-down list or the symbol selector to select the appropriate region. For more information, see Using the Symbol Selector.
      3. Click SF0401G - Deferred Tax Rollforward Interim. The report opens in the workspace. The selected region is displayed as a column above the regional groups within the selected region. Below each regional group the interim deferred tax elements are displayed.
3. Review the account values for each appropriate element.

Deferred Tax Classification Interim report (SF0404R / SF0404S / SF0404G)

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. Do one of the following:
   1. To view all regions report:
      1. Expand All Regions.
      2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
      3. Click SF0404R - Deferred Tax Classification Interim. The report opens in the workspace. The interim elements are displayed with the values for the total of all regions
   2. To view the separate regions report:
      1. Expand Separate.
      2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
      3. Click SF0404S - Deferred Tax Classification Interim.
      4. Select a region to display in the report. The report opens in the workspace. The selected region is displayed as a column above the interim elements.
   3. To view the group regions report:
      1. Expand Group.
      2. Use the drop-down list or the symbol selector to select the appropriate region. For more information, see Using the Symbol Selector.
      3. Click SF0404G - Deferred Tax Classification Interim. The report opens in the workspace. The selected region is displayed as a column above the regional groups within the selected region. Below each regional group the interim elements are displayed.
3. Review the account values for each appropriate element. For more information on the accounts in this report, see Deferred Tax Rollforward Forecast report (SF0401R / SF0401S / SF0401G).

Deferred Tax - for Tax Account Rollforward Interim report (SF0405R / SF0405S / SF0405G)

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. Do one of the following:
   1. To view all regions report:
      1. Expand All Regions.
      2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
      3. Click SF0405R - Deferred Tax - for Tax Account Rollforward Interim. The report opens in the workspace. The interim elements are displayed with the values for the total of all regions.
   2. To view the separate regions report:
      1. Expand Separate.
      2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
      3. Click SF0405S - Deferred Tax - for Tax Account Rollforward Interim.
      4. Select a region to display in the report. The report opens in the workspace. The selected region is displayed as a column above the interim elements.
   3. To view the group regions report:
      1. Expand Group.
      2. Use the drop-down list or the symbol selector to select the appropriate region. For more information, see Using the Symbol Selector.
      3. Click SF0405G - Deferred Tax - for Tax Account Rollforward Interim. The report opens in the workspace. The selected region is displayed as a column above the regional groups within the selected region. Below each regional group the interim elements are displayed.
3. To view all regions report:
   1. Expand All Regions.
   2. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, see Using the Symbol Selector.
   3. Click SF0405R - Deferred Tax - for Tax Account Rollforward Interim. The report opens in the workspace. The interim elements are displayed with the values for the total of all regions.
4. Review the account values for each appropriate element. For more information on the accounts in this report, see Deferred Tax Rollforward Forecast report (RF0401).