Calculating Budget Review Date and Current Review Date

The following use cases explain how to calculate the Budget Review Date and Current Review Date using the Payroll Upload Date, Scenario Start Date, and Scenario End Date when employee data is loaded via a data load rule. 

Use Case 1: Payroll Upload Date is before the Scenario Start Date

When the Payroll Upload Date is before the Scenario Start Date, the image below illustrates the step-by-step process. 

Use Case 2: Payroll Upload Date falls between the Scenario Start Date and Scenario End Date

When the Payroll Upload Date is within the range of the Scenario Start Date and Scenario End Date, the image below illustrates the step-by-step process. 

Use Case 3: Payroll Upload Date is after the Scenario End Date 

In cases where the Payroll Upload Date occurs after the Scenario End Date, the image below illustrates the step-by-step process. 

The following are the definitions for the key terms used above: 

• Payroll Data: Information related to employee compensation and pay details. 
  • Payroll Upload Date: The date on which payroll data is extracted from the payroll systems. This date is assumed to reflect the most recent employee data available at that time. 
  • Next Review Date (NRD): Commonly included in employee data files, this field can represent the "Last Pay Increase Date," "Next Pay Increase Date," or other similar review dates. 

Review Dates Used by the Planful Application: 

• Current Year Review Date: Represents the gap between the present and the Scenario Start Date and is intended to account for any pay increases between now and the Scenario Start Date. 
• Budget Year Review Date: Applicable for one or multiple years, depending on the application's configuration. It is used for budgeting or forecasting purposes. In multi-year budgeting, a single field is displayed, and pay increases are assumed on anniversary dates for subsequent budget years, i.e. budget 2, budget year 3, and so on.