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.

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.

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