You use rollover programs to carry forward balances for pay types, deductions, benefits, and accruals (PDBAs) at the end of the year; and to create the beginning balances for the next year. You need to carry forward these balances to correctly process payroll cycles in the new year.
For PDBAs with ending balances that you do not need to calculate, the system rolls over the accumulated total to the new year. No special PDBA setup is necessary. For benefits and accruals with balances that you must calculate, you must set up rollover information for the deductions, benefits, and accruals (DBAs). For example, you might need to subtract vacation that was taken from available vacation before the balance can roll over.
This chapter contains the following topics:
The Payroll system provides two types of rollover programs for year-end processing:
The system maintains balances in different tables because of the differences between calendar months and payroll months. For example, when a pay cycle crosses calendar months, monthly DBA totals are different for the payroll month and calendar month, but year-to-date (YTD) totals remain the same (unless the cycle also crosses calendar years).
Rollovers includes the following tasks:
Entering Rollover Information for DBAs
Processing Rollovers
For most types of DBAs, such as retirement plan benefits and medical plan deductions, the system carries forward year-end balances when you run the standard year-end rollover programs.
For some DBAs, such as those that track vacation and sick time, employees can earn or hold balances that the system must calculate before it can roll over the balance from one year to the next. When you set up these DBAs, you must enter rollover information so that the system can calculate the balance to roll over.
The system rolls over DBAs that have any of the following:
Remaining balances
Remaining periods
An inception-to-date limit
An annual carryover limit
Deduction amounts due
Arrearages
You also enter rollover information to specify the table in which the system stores history for the DBA, either in the Fiscal and Anniversary Year History table (F06147) or the Payroll Month PDBA Summary History table (F06146).
You can set up vacation and sick DBAs in either of the following ways:
When an employee accrues time that becomes available at a later date, you set up two DBAs. The first DBA accrues the time. The second DBA tracks the amount of that accrued time which is available to the employee.
When an employee can take time as they earn it, you set up a single DBA to track accrued, or available, time.
Either of these scenarios might also involve a limit to the number of hours that an employee can carry forward into the following year.
Your organization's vacation or sick-leave policy might state that employees cannot carry forward more than 80 hours from one year to the next.
To administer this policy, you set up a calculation table that allows only 80 hours to roll over into the following year. This table works in conjunction with the DBA that tracks availability.
The available amount might include a beginning balance from a prior year as shown in the following screen.
Description of the illustration ''cal_tabls_1.gif''
The system compares the balance with the limit in the table. Any amount that is over the limit does not roll over into the new year.
Alternatively, your organization's vacation or sick-leave policy might state that employees cannot carry hours forward from one year to the next. To administer this policy, you define zero as the limit in the rollover calculation table, as shown in the following screen.
Your organization's vacation policy might state the following:
Employees accrue vacation time at the rate of four to ten hours per month, based on years of employment.
Employees can take vacation time in the calendar year following the year in which they earn the time.
To administer this vacation policy, you set up the following:
A pay type (such as 815, Vacation Pay) that tracks the vacation time that an employee takes.
An accrual (such as 8015, Vacation) that tracks the vacation time that an employee earns. The accrued time rolls over to a second DBA that tracks the available vacation time. Accrued time is not available until it rolls over. The following screen illustrates the set up for this type of accrual:
Description of the illustration ''dba_setup_1.gif''
An accrual (such as 8016, Vacation Available) that tracks the vacation time that is available to the employee. The accrual rollover table that you associate with the second DBA establishes the limit on the amount of vacation time that can roll over into the following year. The following screen illustrates the set up for this type of accrual:
Description of the illustration ''dba_setup_2.gif''
When you set up accrual 8016, Vacation Available, you enter the following rollover information:
In the Bnft/Accrl Type field, enter V (Vacation Pay).
In the Rollover Table field, enter the table code of the table that you created so that the mandated amount rolls over.
In the Related PDBA field, enter the number of the pay type that you use for vacation pay.
In the Related PDBA field, enter the DBA number of the accrual that represents accrued but not yet available hours.
Description of the illustration ''rolover_setup_window.gif''
When you run the rollover program, the system calculates the balance to roll over by adding the accumulated and available balances, and then subtracting the vacation time taken.
You do not enter any information on the Rollover Setup Window for accrual 8015.
Note:
You can create as many pay types and accruals as you need. For example, you can have many accrual DBAs that roll over to a single available DBA. You can also have many pay types that relate to a single available DBA. However, you cannot relate a pay type to multiple DBAs that are based on different rollover years. For example, your organization might use the following vacation accruals:One accrual for office workers, which rolls over balances at the end of the standard year
One accrual for factory workers, which rolls over balances on employees' hire dates
To record employees' vacation time taken, you must use separate pay types for each of these accruals.
Your organization's vacation policy might state the following:
Employees can take vacation time as they earn the time.
Employees accrue vacation time at the rate of four to ten hours per month, based on years of employment.
Employees cannot accumulate more than 80 vacation hours from the start to the end of the DBA (the calendar or fiscal year) unless the employee takes the time during the term of the DBA.
To administer this vacation policy, you set up the following:
A pay type (such as 811, Vacation Pay) that tracks the vacation time that an employee takes
An accrual (such as 8011, Vacation) that tracks the vacation time that an employee earns. The following screen illustrates this accrual.
Description of the illustration ''dba_setup_3.gif''
When you set up accrual 8011, you set up the following information:
In the Benefit/Accrual Type field, enter V (Vacation Pay).
In the Rollover Table field, enter the table code of the table that you created so that the mandated amount rolls over.
In the Related PDBA field, enter the number of the pay type that you use for vacation pay (811).
In the Related PDBA field, enter pay type 811 as the pay type that the system uses to calculate the balance for accrual 8011.
When you run the rollover program, the system calculates the balance to roll over by subtracting the vacation time taken from the vacation time earned.
Set up the pay types to calculate the balance for the DBA that requires rollover information.
To enter rollover information for DBAs
From Pay/Deductions/Benefits (G0742), choose DBA Setup
On Rollover Setup Window, choose Rollover Table from the Functions menu to define carryover limits.
On Calculation Tables, enter R in the following field:
Table Type
Enter VR in the following field:
Table Method
In the following fields, enter the number of months of service from the original hire date:
Lower Limit
Upper Limit
Complete the following fields and Click Add:
Table Code
Amount/Rate
Access the Rollover Setup Window.
On Rollover Setup Window, complete the following fields:
Benefit/Accrual Type
Rollover Table
PDBA
Field | Explanation |
---|---|
Table Type | A code that defines the purpose of the table. Valid values are:
D – The system uses the table to calculate DBAs. R – The system uses the table to determine limits for rolling over sick and vacation accruals. |
Table Method | A user defined code (00/UM) that specifies any unit of measure that is appropriate for an employee's time and pay. |
Table Code | A numeric code that identifies this table in the Generic Table Constants table (F069026). |
Amt./Rate | The amount or rate the system uses to calculate a DBA. When you enter 1, 2, 3, 4, 5, or 6 as the method of calculation, you must enter a value in this field to use in the calculation in conjunction with the basis table.
For example, if you create a calculation table for vacation rollovers and enter 80 in this field, any amount that exceeds 80 does not roll over to the following year. An employee might have 92 hours of available vacation at the end of the year, but the employee loses 12 hours of vacation and begins the new year with 80 hours of vacation. |
Bnft/Accrl Type | A user defined code (07/SV) that specifies whether the benefit or accrual type is sick, vacation, holiday, leave, or other. The system uses this code to print sick and vacation accrual balances on the payment stub. |
Rollover Table | The identification number of the rollover table that the system uses to limit the amount rolled over for an accrual.
For example, you can base the limit on an employee's months of service. You can set up the table so that an employee with 0 through 12 months can roll over up to 40 hours at year end and an employee with 13 through 999 months can roll over up to 80 hours. |
PDBA | The number and description of the PDBA that you want the system to use to calculate the corresponding PDBA. This number is the beginning number in the range that is the basis of the calculation.
Screen-specific information For rollover setup, this is the number and description of the PDBA that the system uses to calculate a remaining balance, for example, a pay type that deducts from the current balance. The remaining balance becomes the beginning balance for the new year. |
You use the year-end rollover program to process DBAs that roll over balances at the end of the standard year. You should process year-end rollovers after you process the last payroll cycles of the year. The rollover program uses the previous year's DBA balances to create beginning balances for the new year.
You can process year-end rollovers in proof or update mode. Processing rollovers in proof mode allows you to review information and make necessary corrections before updating history tables. Processing rollovers in update mode allows you to update history tables with beginning rollover balances.
Processing Rollovers includes the following tasks:
Use the year-end rollover programs to process DBAs that roll over balances at the end of the standard year. You should run versions of these programs after you process the last payroll cycle of the year. These programs use the previous year's DBA balances to create beginning balances for the new year.
You need to run the following rollover versions before you run the first payroll of the new year:
You run the Year-End Payroll Month Rollover version after the last check date of the current year and before the first check date of the new year. You do not need to consider work dates within a payroll cycle when deciding when to run this rollover version because the program bases it solely on check date.
You run the Year-End Calendar Month Rollover version after the last payroll with work dates in the current year. You do not need to consider check dates of a payroll cycle when deciding when to run this rollover version because the program bases it solely on work dates.
The following table illustrates when you should run the rollover versions:
Pay Period Ending Date | Check Date | Run Calendar Month Rollover | Run Payroll Month Rollover |
---|---|---|---|
12/31/18 | 12/31/18 | After this payroll | After this payroll |
12/31/18 | 01/05/20 | After this payroll | Before this payroll |
01/05/19 with work dates in 2019 and 2020 | 01/05/20 | After this payroll | Before this payroll |
01/10/19 with no work dates in 2020 | 01/10/20 | Before this payroll | Before this payroll |
The Payroll system maintains balances for the standard year for all PDBAs in two tables. The system stores calendar month information by work date in the Calendar Month DBA Summary History table (F06145). The system stores payroll month information by check date in the Payroll Month PDBA Summary History table (F06146).
The Payroll system maintains balances for the standard year for all PDBAs in the following tables:
Version | Table | Based on |
---|---|---|
Calendar Month Rollover | F06145 | Work dates |
Payroll Month Rollover | F06146 | Check dates |
The system updates the F06145 table by work date and the F06146 table by check date. You use different versions of the same DREAM Writer program to process both types of rollovers.
First, set the Print the Report without Update processing option to run the rollover versions in proof mode. When you run the rollover versions in proof mode, the system prints a report that identifies possible errors but does not change any information in the history table. Review the reports for errors. After you correct any errors, rerun the rollover versions in update mode.
If an employee worked in more than one company last year, the payroll history rollover combines like PDBAs from the individual companies and carries over the total to the employee's current home company. The report also prints a separate line showing the detail for each company. If you do not want to combine the employee's accruals, create a unique payroll-month history version for each company.
If an employee has sick or vacation pay history in multiple companies, the system combines all hours for each pay type before subtracting the total hours from the combined history for the related accrual.
If different groups of employees have unique rollover rules for the same DBA, you must create a separate payroll-month history version for each group. Set up each version so that it selects only the employees in that group.
Set up the rollover information for DBAs.
Create backups of the Payroll Month PDBA Summary History (F06146) and Calendar Month DBA Summary History (F06145) tables. The system does not automatically create backups when you run the year-end rollover versions.
From Integrity, Rollover & Repost (G072471), choose Year End Rollover
After you process the year-end rollovers without updating history tables, review the rollover reports to verify that the balances are appropriate to roll over. If necessary, make any changes to PDBA history and process your rollovers without updating history tables again.
When your rollover reports contain the correct balances, process the year-end rollovers in update mode. Review the rollover report to verify that the correct rollover information is in the history tables.
When beginning balance hours or monetary amounts are negative, the rollover creates the Year-End Rollover report with the message that the rollover amount is negative.
Example: Year-End Payroll Month Rollover Report
Description of the illustration ''image017.gif''