Rollup Sick Accrual for an Employee Working in Two Jurisdictions

  • Set up a rollup sick accrual for Spokane with the table code set up to accrue 1 hour for 30 hours worked, and appropriate values in the other required fields. In this example, DBA code 7911 is used for Spokane.

  • Set up another rollup sick accrual for Washington State with the table code set up to accrue 1 hour for 40 hours worked, and appropriate values in the other required fields. In this example, DBA code 7931 is used for Washington State.

  • Set up a master accrual with Method of Calculation specified as %. In this example, DBA code 7990 is used.

  • On the Basis of Calculation form, set up the pay type ranges for the master accrual DBA to include the rollup DBA ranges. In this example, the range is from 7900 through 7931.

  • Enter two timecards for an employee with the work locations as Spokane and Washington State, for one week each.

  • This is how the system calculates rollup and master accruals in the final update of payroll:

    Work with Pay Stub Detail and DBA Review Forms Showing Accruals for Spokane and Washington State This image is described in the surrounding text.

    The system calculates rollup accrual for Spokane higher than the accrual for Washington State.

  • The PDBAs by Payroll Month screen shows the master accrual balance of 4.99 that includes 2.66 from the first and 2.33 from the second payroll.

    PDBAs by Payroll Month Form
  • Enter 40 hours for California State and 40 hours for Washington State.

  • Run pre-payroll.

    This is how the system calculates rollup and master accruals in the final update of payroll:

    Work with Pay Stub Detail and DBA Review Forms Showing Calculation of Accruals This image is described in the surrounding text.
  • You can see that the system calculates accrual for California at a rate higher than the rate for Washington State, and accrues the previous balance of 4.99 and the current accrual of 2.33 into the master accrual balance. The PDBAs by Rollup Month screen shows the increments in the previous balances of PDBAs.

    PDBAs by Rollup Month Screen Showing Increments in Values of Accruals