The following are a few examples of how to set up the Through Service Year table and the Calc Max. Carry-over based on Remaining Balance option on the on the Employee tab of the Earning/Deduction Codes for an accrual. The examples specifically describe vacation time accrual, but the principles would also apply to sick time accrual. For compensatory/banked time, you do not specify beginning and increment amounts. (The Employee tab becomes available only if you select Accrual in the Category field of the Basic Info tab.)
Example 1: Accrue once a year, with unlimited carry-over
Assume that:
In such a case, it does not matter whether you select the Calc Max. Carry-over based on Remaining Balance option.
Your table on the Employee tab of the Earning/Deduction Codes window would look like this:
Through Service Year |
Beginning |
Increment |
Max. Accrual |
Max. Carry-over |
---|---|---|---|---|
99 |
120.00 |
0.00000 |
999,999.00 |
999,999.00 |
If employees are allowed to accrue only up to a certain number of hours (for example, 240 hours), then you would enter 240.00 in the Max. Accrual field.
Example 2: Accrue once a year, with no carry-over permitted
Assume that:
In such a case, it does not matter whether you select the Calc Max. Carry-over based on Remaining Balance option.
Your table on the Employee tab of the Earning/Deduction Codes window would look like this:
Through Service Year |
Beginning | Increment |
Max. Accrual |
Max. Carry-over |
---|---|---|---|---|
99 |
120.00 |
0.00000 |
120.00 |
0.00 |
Example 3: Accrue per pay period, without the Calc Max. Carry-over based on Remaining Balance option
This example illustrates a situation where:
Suppose that vacation time is accrued depending on the years of service as follows:
You would enter 5 in the first Through Service Year field, 10 in the second Through Service Year field, and 99 (or another appropriately high number) in the third Through Service Year field.
Suppose that, as a bonus for long-term employment:
In the Beginning column, you would enter 0 for the first Through Service Year line, 8 in the second Through Service Year line, and 16 in the third Through Service Year.
Suppose you are accruing vacation for your employees by means of a monthly Hours Per Frequency accrual.
Suppose that:
Suppose that, of the vacation time accrued during the year:
In addition, assume that employees are also allowed to carry over any unused vacation accumulated from past years, regardless of the service year level.
To set this up:
Your table on the Employee tab of the Earning/Deduction Codes setup window would look like this:
Through Service Year | Beginning | Increment |
Max. Accrual |
Max. Carry-over |
---|---|---|---|---|
5 |
0.00 |
10.00 |
240.00 |
40.00 |
10 |
8.00 |
15.00 |
360.00 |
60.00 |
99 |
16.00 |
20.00 |
480.00 |
80.00 |
In summary, employees in the example given who have up to five years of service with the company accrue three weeks (120 hours) of vacation in a year. Of the three weeks they accrue, they must use two within each year or lose them, as they are allowed to carry over only one week (40 hours) per year.
Although these employees may eventually accrue up to six weeks (240 hours) of unused vacation time, their maximum annual carry over of one week means that it would take a minimum of six years for an employee to reach the maximum unused accrual ceiling. By that time, however, the employee’s maximum unused accrual ceiling would have increased to 9 weeks (360 hours) according to the Through Service Year 10 bracket of the accrual schedule.
Note that employees with more than five years of service receive an additional 8 hours (or 16 hours, if more than ten years), which is added after the maximum carry-over is considered. However, the result cannot exceed the maximum accrual.
Example 4: Accrue per pay period, with the Calc Max. Carry-over based on Remaining Balance option
This example illustrates a situation where, regardless of the employee’s total remaining balance at the end of the accrual year, the employee is not permitted to carry over any unused hours beyond the specified maximum carry-over.
Assume the same values entered in the Through Service Year, Beginning, Increment, and Maximum Carry-over fields as in Example 3.
In Example 4, you would set the following:
Your table on the Employee tab of the Earning/Deduction Codes window would look like this:
Through Service Year |
Beginning |
Increment |
Max. Accrual |
Max. Carry-over |
---|---|---|---|---|
5 |
0.00 |
10.00 |
160.00 |
40.00 |
10 |
8.00 |
15.00 |
240.00 |
60.00 |
99 |
16.00 |
20.00 |
320.00 |
80.00 |
In summary, employees in this example who have up to five years of service with the company accrue three weeks (120 hours) of vacation in a year. Of the three weeks they accrue, they must use two within each year or lose them, as they are allowed to carry over only one week (40 hours) per year.
However, unlike Example 3, these employees are more restricted in the number of hours they can carry over.
When you select the Calc Max. Carry-over based on Remaining Balance check box, the values you set in the Max. Carry-over column indicate the number of hours of the total remaining balance that can be carried over.
So, for example, employees in the first bracket (Through Service Year five) can carry over only 40 hours every year, and cannot carry over any other remaining unused hours that the employee may have accumulated. (In Example 3, the employee can carry over 40 hours of the total hours accrued during the current year, plus any remaining unused hours accumulated.)
Note: Employees with more than five years of service receive an additional 8 hours, which is added after the maximum carry-over is considered. This means that they may start the new accrual year with 68 hours (8 hours more than the specified maximum carry-over of 60).
Similarly, employees with more than ten years of service receive an extra 16 hours, so they may start the new accrual year with 96 hours (16 hours more than the specified maximum carry-over of 80).
Published: May 17, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks