Custom Budget Spread Examples in Personnel Budgeting

The following are specific examples of changes that can be made on the Detail tab of Personnel Budgeting using the Custom Budget spread options and the steps to complete them.

To create a Custom Spread, see this article: Custom Budget Spreads

Example 1 - Allocate by working days per month

In this example, there is a need to apply a 3% COLA increase in July of the calendar year.

1. Navigate to Setup > Calendar.
2. Go to the Custom Spread tab.
3. Add a spread with the working days per month.
4. Navigate to Personnel Budgeting > Scenarios.
5. Ensure the appropriate scenario is Selected or set as the Default.
6. Go to the Detail tab.
7. Filter to the appropriate pay items such as the hourly and/or salary pay items.
8. Select all records.
9. Click Update Pay Items.
10. Click on the Custom Spread tab.
11. Choose the appropriate spread from the dropdown.
12. Click Preview to see the impact of the spread on the first 10 lines.
13. Click Apply.
    
    

Example 2 - Adjust the number of pay periods per month

Depending on how you accrue the pay periods, you may want to remove a pay period from the beginning of the year and add it to the end. This can be accomplished by putting into the custom spread the amount of pay periods you would like per pay period.

1. Navigate to Setup > Calendar.
2. Go to the Custom Spread tab.
3. Add a spread with the number of pay periods per month. Ensure the total number of pay periods matches the pay type frequency (for example, if the Pay type frequency is bi-weekly, that is 26 pay periods, if it is bi-monthly, it is 24 pay periods)
4. Navigate to Personnel Budgeting > Scenarios.
5. Ensure the appropriate scenario is Selected or set as the Default.
6. Go to the Detail tab.
7. Filter to the appropriate pay items such as the hourly and/or salary pay items.
8. Select all records.
9. Click Update Pay Items.
10. Click on the Custom Spread tab.
11. Choose the appropriate spread from the dropdown.
12. Click Preview to see the impact of the spread on the first 10 lines.
13. Click Apply.

Example 3 - Adjust the number pf days per month

If you need to adjust the total annual salary by the number of days per month, use the following method:

1. Navigate to Setup > Calendar.
2. Go to the Custom Spread tab.
3. Add a spread with the number of days per month.
4. Navigate to Personnel Budgeting > Scenarios.
5. Ensure the appropriate scenario is Selected or set as the Default.
6. Go to the Detail tab.
7. Filter to the appropriate pay items such as the hourly and/or salary pay items.
8. Select all records.
9. Click Update Pay Items.
10. Click on the the Custom Spread tab.
11. Choose the appropriate spread from the dropdown.
12. Click Preview to see the impact of the spread on the first 10 lines.
13. Click Apply.