Deferred Balances

Reporting Levels:

Unit

 

Sub-consolidation

Consolidation

Control Center Configurable Options:

Dataset

Unit

 

Sub-consolidation

Currency

Source Data:

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

Available Views:

Custom Rollups

Summary / Hybrid / Detail / Unit

Pre-Tax / Pre-Tax post-app

State / FBOS / state/fed+FBOS

All / current / non-current

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

 

The Deferred Balances (State) report in the Provision and Interim datasets displays the 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: The State name displays in the report's header.

 

Provision Items

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

 

Report Views

•Defaults to the pre-tax and contracted view of the report details.
•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 the 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 select 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.
•The Pre-tax, State, and FBOS options determine the rate that should be applied to temporary differences. Either the default unit rates or the rates that were entered to override the unit rate for a specific line item are applied. Either 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), and Expanded (income statement) options allow you to view beginning balances, period change, and ending balances in different ways. The balance sheet view can display both pre and post rate, while the income statement view only displays when a rate option is selected. Rate effected views support the Deferred Tax Asset/Liability when Expanded (balance sheet) is selected or the Deferred Tax Expense and CTA when Expanded (income statement) is selected. User-defined columns that display in the Expanded views are defined in the Manage Deferred Rollforwards screen in the Administration area.
•Any single column can be expanded to see underlying unit-by-unit data by selecting Brkout. Expanded results either display on the screen or export to an Excel file, depending on the version and parameter settings.

 

Line by Line

•Temporary Differences: v > Temporary Differences - Tax Basis, Temporary Differences - Book/Tax Basis, State Temporary Differences - Tax Basis, and State After Apportionment Temporary Differences - Tax Basis.
•NOL Reclass: Data Input > NOL Temporary Differences - Tax Basis.
•After Tax Temporary Differences: Data Input > After Tax Temporary Differences - Tax Basis, After Tax Temporary Differences - Book/Tax Basis, and State After Tax Temporary Differences - Tax Basis.

 

Column by Column

•Beginning Balance: Beginning balances are typically populated by rolling over balances from prior periods. Amounts populate in the Beginning Balance field in Data Input > Unit > 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, and Data Input > State > State Temporary Differences - Tax Basis, State After Apportionment Temporary Differences - Tax Basis, and State After Tax Temporary Differences - Tax Basis.
•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 the deferred tax expense. The currency translation adjustment needed to adjust the beginning balances for a change in the foreign exchange rate does not impact the 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.
•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 15 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.