Our company offers paid support assistance to set this up. Please reach out to us if interested.

Tammi M. Ermerins ([email protected])

Certified Sage 50/Peachtree Accounting & Crystal Reports Consultant & Trainer

800-780-0700 / 954-961-0600, Visit Us on the Web at https://pcosupport.com

I think this is the formula we need to enter, for Michigan employers.

Employees receive 1 hour for every 30 worked, and are entitled to accrue and use 72 hours of paid leave per calendar year.

You can copy & paste this formula into the USER MAINTAINED PAYROLL FORMULAS.

1. Select the SICK_ADD current year formula from the Formula ID list (for example, SICK_ADD 22)
2. 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.

L=72; "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)

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

Actually, the new law says.....

Once accrued, you can use up to 72 hours of sick time each year.  The first 40 hours of accrued sick time will be paid at your regular rate of pay and the remaining 32 hours of accrued sick time will be granted without pay.

So then, I think the new formula would be:

1. Select the SICK_ADD current year formula from the Formula ID list (for example, SICK_ADD 25)
2. 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.

L=40; "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)

I tried this and it gave me the error: "The word REGULAR in this formula is not recognized by Sage 50 - ?

I actually figured that out yesterday. Missouri just changed to this 30/1 formula effective today. Replace the word "regular" with the actual name your system uses for wages. In my case it was "WageHourly"  It's the description you'll see on the line where you enter hours for an employee.  I also had to create a formula for Salary. 

Still trying to get both to calculate correctly.k

I don't think these are the correct formulas, they are not calculating correctly, and Sage Support is absolutely no help.