• 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
• Missouri Proposition A Earned Paid Sick Time Law

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 defaults to one hour per every 30 hours worked.  You can change it 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 one of the following formulas to overwrite the existing one.  The formula you use will depend on whether or not your company has a limit to time accrued.

• 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 stops accrual for the payroll year 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, then select the hyperlink for Current formulas.
4. Select the SICK_ADD formula for the total hours.
5. Click OK.
6. Click Save.
7. Repeat the steps above to set up the remainder of the hourly employees.
8. Verify calculations with a test payroll entry.

The formulas are only for accrual tracking purposes. Click here for the process to pay your hourly employees' for sick time taken.

Sage Expert Services (SES)

How to set up a sick formula based on hours worked and sick hours earned for Salary Employees