• Oregon Sick Time law
• California Healthy Workplace Healthy Family Act
• Illinois Paid Leave for All Workers Act
• Massachusetts Earned Sick Time
• New York City Earned Sick Time
• Arizona Calculated Sick Time
• Maryland Healthy Working Families Act
• Washington Sick Time Law
• New Mexico Sick Time Law
• Minnesota Earned Sick & Safe Time Law
• Michigan Earned Sick Time Act

The information and formula configuration is a courtesy to those needing a sick time formula based on hours worked. Sage 50—U.S. Edition support doesn’t assist in the setting up or troubleshooting this or any other custom formula.  

 NOTE: Before completing this solution, the default vacation/sick time settings must already exist within the Sage 50 Company file. Refer to How to set up vacation or sick time. 

 TIP: For steps to configure Salary Employees payroll formula for sick hours earned, refer to: How to set up a sick formula based on hours worked and sick hours earned for Salary Employees. 

1. Hourly employees formula

The formula for hourly employees refers to the default system-generated pay types, Regular and Overtime. Replace or add any special pay types as needed for hours worked within the formula.
The formula's accrual amount of one hour per every 30 hours worked but can be changed to reflect the accrual amount of your company.

1. Make a backup of the company.
2. Select File, Payroll Formulas, User-Maintained.
3. Select the SICK_ADD current year formula from the Formula ID list (for example, SICK_ADD 24).
4. Copy and paste the following formula to overwrite the existing one present based on the limit as it pertains to the plan.

• No Limit Applies

ANSWER=(Regular+Overtime)*1/30

• Limit Applies

L=XX; "Maximum hours accrued allowed for 1 year"

Y=YTD(SICK_Accrue)-SICK_Accrue; "YTD Hours Accrued"

R=L-Y; "Remaining Accrual"

C=(Regular+Overtime)*1/30;

A=If(C<R,C,R); "Accrual this check"

ANSWER=If(R<=0,0,A)

Edit the line "L=XX" to include the max number of hours an employee can accrue. For example, L=48 would cause no more hours to accrue once the employee has accrued 48 YTD hours of sick time.

4. Click Save to save your changes.
5. Click Close.
6. Proceed to Section 2.

2. Update formula for Hourly Employees

1. Select Maintain, and then select Employees/Sales Reps.
2. Highlight one of the hourly employees earning vacation hours applicable to this plan.
3. Select the Vacation/Sick Time tab, select the hyperlink for Current formulas, and then select the SICK_ADD formula for the total hours.
4. Click OK.
5. Click Save.
6. Repeat the steps above to set up the remainder of the hourly employees.
7. Verify calculations with a test payroll entry.

The formulas are only for accrual tracking purposes. To pay your hourly employees' for sick time taken, see How do I pay employees for vacation or sick taken?.

Sage Expert Services (SES)
How to set up a sick formula based on hours worked and sick hours earned for Salary Employees