Sick and Vacation Accrual only if the employee works a certain amount of hours a month

Hello, I have a costumer with a very particular workers comp decree established by the local DoA which stated that the hourly employee accrues 6hrs/mo Vacation (144hrs max) and Sick (120hrs  max) only if total hours for the pay period is equal 115 or more.  They might accrue or not depending on how may hours they worked during the month.

I was trying to fiddle with the formula for hourly employees on https://support.na.sage.com/selfservice/viewContent.do?externalId=10246&sliceId=1 but still unable to figure out how to add and compare the worked hours for the period.

Any help would be awesome!

Parents
  • You can get the hours in the current pay period, but you can't get Month To Date hours unless your pay period happens to be monthly.

    You can access the hours worked in a payroll formula by using the name of the hourly pay level, for example if your hourly pay fields are name Regular and Overtime, then "Regular+Overtime" would give you the total hours for this check.

    So part of your formula could be something like:

    IF(Regular+Overtime>115,6,0)

    That would give 6 hours if Regular+Overtime is greater than 115, if not they would get 0 hours.

    If you're going to be writing payroll formulas, i recommend going into the Help and searching the index for "functions, tax table formulas"

    By the way, you cannot access the hours for salaried employees in a formula.

Reply
  • You can get the hours in the current pay period, but you can't get Month To Date hours unless your pay period happens to be monthly.

    You can access the hours worked in a payroll formula by using the name of the hourly pay level, for example if your hourly pay fields are name Regular and Overtime, then "Regular+Overtime" would give you the total hours for this check.

    So part of your formula could be something like:

    IF(Regular+Overtime>115,6,0)

    That would give 6 hours if Regular+Overtime is greater than 115, if not they would get 0 hours.

    If you're going to be writing payroll formulas, i recommend going into the Help and searching the index for "functions, tax table formulas"

    By the way, you cannot access the hours for salaried employees in a formula.

Children
No Data