Forecast True Up

Reporting Levels:

 

 

Sub-consolidation

Consolidation

Control Center Configurable Options:

Dataset

Unit

 

Sub-consolidation

Currency

Source Data:

Forecast Interim Unit Details

Available Views:

N/A

 

The Forecast True Up report for Interim datasets explains the calculation of the True-Up required to make up the difference between applying the Unit by Unit Forecasted rate and the Overall Forecasted rate to the Actual PTBI.

 


Note: This report is available when either the Unit by Unit or Overall basis is selected when creating an Interim dataset on the Interim Datasets screen in the Administration area.


Line by Line

Shows all active units within the selected dataset.

Column By Column

Units: Code and name of active units.
Actual PTBI: Data Input > Actual > Federal > Interim Unit Details > Pre Tax Book Income.
Forecasted Rate Unit by Unit: If Unit by Unit is selected, this will be Data Input > Actual > Federal > Interim Unit Rate number. If Overall is selected, this will be what the Unit By Unit Interim Rate would be, if Unit by Unit was selected.
PTBI at Unit by Unit Forecasted Rate: Actual PTBI multiplied by Forecasted Rate Unit by Unit.
Forecasted Rate Overall: If Overall is selected, this will be Data Input > Actual > Federal > Interim Unit Rate number. If Unit by Unit is selected, this will be what the Unit By Unit Interim Rate would be, if Overall was selected.
PTBI at Overall Forecasted Rate: Actual PTBI multiplied by Forecasted Rate Overall.
True Up Amount: Difference between PTBI at Overall Forecasted Rate and PTBI at Unit by Unit Forecasted Rate.