Deferred Balances

Reporting Levels:

Unit

Filing Group

Sub-consolidation

Consolidation

Control Center Configurable Options:

Dataset

Unit

 

Sub-consolidation

Currency

Source Data:

Unit Details, Temporary Differences, After Tax Temporary Differences, NOL Temporary Differences, State After Tax Temporary Differences, State After Apportionment Temporary Differences

Available Views:

Custom Rollups

Summary / Hybrid / Detail / Unit

Pre-Tax

Fed / State / FBOS / Fed+State+FBOS / state/fed+FBOS

All / current / non-current

Contracted / expanded (balance sheet) / cir expanded (balance sheet) / expanded (income statement)

 

The Deferred Balances report for Provision and Interim datasets displays beginning and ending cumulative temporary difference balances. When it is expanded, it shows the amounts that made up the change. The default view is pre-tax. Balances can also display at various tax effected levels by selecting options in the upper right corner. Selecting an amount with a hyperlink opens a supporting report.

 


Note: A Deferred Provision Only adjustment can cause the Interim Provision and the Deferred Balances report to be out of balance by the amount of the Deferred Provision Only Adjustment.


 

Provision Items

Translation Adjustment (CTA)
Deferred Tax Expense
Deferred Tax Asset/Liability
Currency

Report Views

Defaults to the pre-tax and contracted views.
Rollups are user-defined groupings that allow detail level component data to be consolidated and rolled up to a higher level. Creating and managing rollups for the report occurs in the Administration area. For example, a Rollup may assist in generating the footnote, while another may explain results for management reporting.
The Summary, Hybrid, Detail, and Unit options display either rate effected or pre-tax balances with various levels of detail. To view the Summary, first select a rollup code, then click Summary. The Hybrid view displays both rollup sub-totals and the underlying detail for each rollup code. The Detail view shows the report at a detailed level. The Unit view groups balances into a single line for each unit in the sub-consolidation or consolidation.

Note: In order to view the detail for a user-created custom roll-up (such as a footnote), after clicking a Custom Rollup view option, you must also click the Hybrid view option.


 

The pre-tax, Fed, State, FBOS, Fed+State+FBOS, and State/Fed+FBOS options determine the rates that should be applied to temporary differences. Either default unit rates or the rates that were entered to override the unit rate for a specific line item are applied. The State+FBOS or the Fed+FBOS option displays, depending on the federal benefit of state dataset parameter that is selected.
The All, Current, and Non-current options allow the report to be filtered by balance sheet status.
The Contracted, Expanded (balance sheet), cir expanded (balance sheet), and Expanded (income statement) options allow you to view beginning balances, period changes, and ending balances in different ways:
oThe Balance sheet view can display both pre- and post-rate.
oThe Change in Rate (cir) column can display on a contracted basis or be divided into the change in deferred rate and the change in foreign exchange rate.
oThe Income statement view only displays when a rate option is selected.
oThe rate effected views support the Deferred Tax Asset/Liability when Expanded (balance sheet) is selected, and the Deferred Tax Expense and CTA when Expanded (income statement) is selected.
oThe user-defined columns that display in the Expanded views are defined in the Manage Deferred Rollforwards section under the Administration area.
A single column can be expanded to see underlying unit-by-unit data by selecting Brkout. Expanded results display on the screen or export to an Excel file, depending on the version and parameter settings.

 

Line by Line

Temporary Differences: Data Input > Federal/State > Temporary Differences - Tax Basis, Temporary Differences - Book/Tax Basis, State Temporary Differences - Tax Basis and State After Apportionment Temporary Differences - Tax Basis in the Provision section. Data Input > Actual > Federal/State > Temporary Differences - Tax Basis, State Temporary Differences - Tax Basis, and State After Apportionment Temporary Differences - Tax Basis in the Interim section.
NOL Reclass: Data Input > Federal > NOL Temporary Differences - Tax Basis in the Provision section. Data Input > Actual > Federal > NOL Temporary Differences - Tax Basisin the Interim section.
After Tax Temporary Differences: Data Input > Federal/State > After Tax Temporary Differences - Tax Basis, After Tax Temporary Differences - Book/Tax Basis, and State After Tax Temporary Differences - Tax Basis in the Provision section. Data Input > Actual > Federal/State > After Tax Temporary Differences - Tax Basis and State After Tax Temporary Differences - Tax Basis in the Interim section.

 

Column By Column

Beginning Balance: Beginning balances are typically populated by rolling over balances from prior periods. Amounts are populated in the beginning balance field in Data Input > Federal/State > Temporary Differences - Tax Basis, Temporary Differences - Book/Tax Basis, NOL Temporary Differences - Tax Basis, After Tax Temporary Differences - Tax Basis and After Tax Temporary Differences - Book/Tax Basis, State Temporary Differences -Tax Basis, State After Apportionment Temporary Differences - Tax Basis and State After Tax Temporary Differences - Tax Basis for the Provision section; and Data Input > Actual > Federal/State > Temporary Differences - Tax Basis, NOL Temporary Differences - Tax Basis, After Tax Temporary Differences - Tax Basis, State Temporary Differences - Tax Basis and State After Apportionment Temporary Differences - Tax Basis for the Interim section.
Rate Change: When balances are rate effected, the system automatically adjusts beginning balances to accommodate for any change in the deferred rate and any change to the foreign exchange rate. The difference needed to adjust the beginning balance that was rated using the beginning deferred rate and the ending deferred rate impacts deferred tax expense. The currency translation adjustment needed to adjust beginning balances for a change in the foreign exchange rate does not impact deferred tax expense. It is treated as an equity item. View the report in Expanded (income statement) to display the components of the CTA calculation.

Note: This column cannot be moved or removed. It is system-generated.


Change Columns: The columns that explain the change in deferred balances are user-defined in the Manage Deferred Rollforward section. Each tag and item can be defined to up to 26 columns.
Adjusted Beginning Balance: A sub-total column can be inserted in the report to define adjusted beginning balances. There are several options, depending on the version and parameter settings.
Ending Balance: Total of beginning balances and all items that occurred during the period.