Sick formula for hours worked and sick hours earned for Salary employees

CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

 NOTE: For steps to configure Hourly Employees payroll formula for sick hours earned, see: How to set up a sick formula based on hours worked and sick hours earned for Hourly Employees. 

1. Salary employees formula

 NOTE: The formulas accrual amount of 1 hour per every 30 hours worked but can be changed to reflect the accrual amount of your company. 

1. Create a backup.
2. Set up a new payroll field for tracking the value (number) of hours worked. This will be used in the "C" line in the formula below.
3. Select File, Payroll Formulas, User-Maintained.
4. Select the SICK_ADD current year formula from the Formula ID list (for example, SICK_ADD 25).

• Type SICK_AD2 as the Formula ID, and SICK_AD2 XX Formula Name (XX being the current tax year for which the plan applies)

5. Select these options for the following fields.
   • How do you classify this formula?: Benefit
   • Effect on gross pay: Either subtracts or adds to gross
   • Filing status: All
6. Copy and paste the following formula to overwrite the existing one present based on the limit or no limit as it pertains to the plan.
   
   
   • No Limit Applies

   ANSWER=(XXXX)*1/30

   • Limit Applies

   L=XX; "Maximum hours accrued allowed for one year"
   Y=YTD(SICK_Accrue)-SICK_Accrue; "YTD Hours Accrued"
   R=L-Y; "Remaining Accrual"
   C=(XXXX)*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.

6. Replace XXXX with the new payroll field created in Step 2.
7. Click Save to save your changes.
8. Click Close.
9. Follow Section 2.

2. Update formula for Salary employees

1. Select Maintain, and then select Employees/Sales Reps.
2. Highlight one of the salary 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_ADD2 formula for the total hours.
4. Click OK.
5. Click Save.
6. Repeat steps 1-5 on each of the salary employee records to set up the remaining salary employees.
7. Verify calculations with a test payroll entry. Enter the number of hours taken in the new Sick field.

Sage Expert Services (SES)

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