Hour Report

[marge]

Hello Again Paul:
This time I'm needing clarification on the Hour Report. The gross figure is the same as my 941, right? BUT the hour figure does not contain the vacation or holiday hours. ---Only regular and Overtime hours. Is that right? I need to have all of the hours put in so that I can multiply them by the regular wage for workman's comp reports. Is this something that I should do manually or am I not understanding the report?

If it is to be done by me, I know I can go to the Pay History Report for each employee and figure out the total hours. But, whew! Thank You , Marge

[Paul Mayer]

Hello Again Paul:
This time I'm needing clarification on the Hour Report. The gross figure is the same as my 941, right? BUT the hour figure does not contain the vacation or holiday hours. ---Only regular and Overtime hours. Is that right? I need to have all of the hours put in so that I can multiply them by the regular wage for workman's comp reports. Is this something that I should do manually or am I not understanding the report?

If it is to be done by me, I know I can go to the Pay History Report for each employee and figure out the total hours. But, whew! Thank You , Marge

Workman's comp is calculated on hours worked. Vacation, Sick and Holiday is not hours worked.

[marge]

Thank you for your answer. However, I'm dealing with Montana and I just called them and they told me that yes, they do want all of the Vac, Sick leave, Holiday, OT and reg wages listed and we are allowed to multiply that total by the reg wage hourly amount. This office is the State Fund (Workmans Comp) for Montana.

Since asking my question I also figured I could use a custom report to gather these hours. Thanks again. Any further ideas I would be glad to hear about them. Marge

[Paul Mayer]

Thank you for your answer. However, I'm dealing with Montana and I just called them and they told me that yes, they do want all of the Vac, Sick leave, Holiday, OT and reg wages listed and we are allowed to multiply that total by the reg wage hourly amount. This office is the State Fund (Workmans Comp) for Montana.

Since asking my question I also figured I could use a custom report to gather these hours. Thanks again. Any further ideas I would be glad to hear about them. Marge

The only thing I can find that has to do with Workman's Comp and "hours" is for volunteer firemen.

This link may be too long:

http://www.montanastatefund.com/wps/wcm/connect/?MOD=PDMProxy&TYPE=personalization&ID=NONE&KEY=NONE&LIBRARY=%2FcontentRoot%2Ficm%3Alibraries%5B10%5D&FOLDER=%2FMSF_External_Documents%2FPolicyholders%2 FPayroll+Reporting%2F&DOC_NAME=%2FcontentRoot%2Ficm%3Alibraries%5B10%5D% 2FMSF_External_Documents%2FPolicyholders%2FPayroll +Reporting%2FMSF+Payroll+Report.pdf&VERSION_NAME=NONE&VERSION_DATE=NONE&IGNORE_CACHE=false&CONVERT=NONE&MUST_CONVERT=false

We use a tax bureau for taxes and do not see any W/C tax for Montana, are you working with an insurance company that wants the hours or something? In 25 years, we've never had anyone in Montana asking for the hours before and I'm trying to pin down where the requirements are besides the link above.

[marge]

The e-mail address I have for the State Fund of Montana (State Agency) is
www.montanastatefund.com Address 5 South Last Chance Gulch, PO Box 4759, Helena, Mt. 59604-4759.

They require Payroll Reports 2-3 times a year depending on the business. Under General Report Requirements it says, "You must report the following items that constitute earnings" Instruction No. 1 says. Wages, salaries, commissions, bonuses, vacation pay, holiday pay, sick leave and piecework payments are reportable.

I know you'll pick up on the phrase 'constitute earnings' and this is what I called them about this morning and they said yes, vacation etc as Number 1 (quoted ) above.

[Paul Mayer]

The e-mail address I have for the State Fund of Montana (State Agency) is
www.montanastatefund.com (http://www.montanastatefund.com) Address 5 South Last Chance Gulch, PO Box 4759, Helena, Mt. 59604-4759.

They require Payroll Reports 2-3 times a year depending on the business. Under General Report Requirements it says, "You must report the following items that constitute earnings" Instruction No. 1 says. Wages, salaries, commissions, bonuses, vacation pay, holiday pay, sick leave and piecework payments are reportable.

I know you'll pick up on the phrase 'constitute earnings' and this is what I called them about this morning and they said yes, vacation etc as Number 1 (quoted ) above.

Yes Marge, earnings, but nothing about hours. The reason I searched is that there are only two states that we are aware of that calculate W/C on hours and not earnings and Montana is not one of them.

[marge]

Thanks for all this..... The reason I need hours, is that I don't have to report actual Gross money for each employee on this report. It can be reduced by taking all OT hours for that person times a regular wage. BUT I had noticed that the hour report didn't even include vacation or holiday hours in each total. That got me asking about the report. The Gross money is correct for everything but the hour figure was off. That is what instigated my original question. I'll run a custom report and carry on. Thank you. Marge

[Sarah]

Hi Paul and Marge,
I'm in MT too, but previously in CA. It has been my experience in both states that Work Comp is calculated on total hours times the straight rate.
(Key words: straight time, straight rate, premium time, premium rate.)

I set up my hourly people, for example, someone making $10 per hour, as Pay Rate: $10, and O/T One: $5. If they work 44 hours one week, I enter 44 for regular hours and 5 o/t hours.

It would be nice to have the "Employers Totals Report" report have an additional line that reports these premium wages. Take the top line you now call "regular wages" and change that to "Straight wages", add a line right under it called O/T Premium wages.

Paul, the $20, is not subject to work comp premium. And like Marge stated, vacation, holiday and sick pay is.

When you have a lot of employees being paid overtime it takes a bit of work to cull the reports to separate straight wages from premium wages. It can be done, it just takes time.

Thanks for great, reasonably priced software that doesn't break.

[Paul Mayer]

Sarah, does the "Hours" report give you what you need under the period reports?

I'm not sure I understand what "premium wages" is for though, it seems like a very convoluted way to have to come up with a number.

We are coming out with a time clock this year in time for the annual upgrade, but I'm not even sure that will give you what you are looking for.

[Sarah]

Thanks for asking, the hours report, if the person's hourly wage rate doesn't change, is helpful, but a workpaper is needed to tally the wages, etc.

What I do now is use the "payroll 132 column report", but I have to run one for each pay period. Then create a workpaper to add them up. That report has fields titled o/t1 pay and o/t2 pay.

"Straight wages" are the "regular" hourly rate times the total hours worked. That is the wages an employer has to total up and pay work comp premium on. (Plus include vacation and sick time)

If you had lots of overtime, you can see where you would like to distinguish straight wages from premium wages when calculating how much wages you must pay work comp on.(80 hrs x @20 = 1600 for work comp, even tho the employee grossed 2000, or 2400, if they were getting dbl time for the extra time worked)

Say I have an employee who worked 56 hours the week of labor day. They even worked labor day for 8 hours. Their "regular" hourly rate is $20:

56 x 20 = 1120 straight time x straight rate = straight wages
8 x 20 = 160 overtime x premium rate (double time on labor day)
8 x 10 = 80 overtime x premium rate (1.5 times the straight rate)

The employer reports wages of 1120 for work comp.

When I set up the employee file, their pay rate is $20, I use OT1 for time and a half, so that rate is $10, OT2 is double time so that rate is $20.

When I enter the hours worked that pay period, I enter 56 for 'reg hours worked' 8 for "o/t1 hours worked" and 8 for "o/t2 hours worked."

When I look at the payroll 132 report for this person, I'll have the RegPay1 of 1120, OT1 pay of 160 and OT2 pay of 80.

It would save a work paper and some digging and calculating, if somehow (the magic of programming!) the system could present rows for OT1Pay and OT2 pay as line items below Regular pay on the "Employers Payroll Total Report" also.

[Paul Mayer]

Does not setting up your employees to be paid in different departments give you the breakdown you need?

If so, you may want to join the beta test we are about to start for our new TimeClockWindow. A software time clock that will give you a report that looks like the attachment I've added to this reply.

If you want to join the beta test, email me at support@zpay.com requesting to join the beta test.

[Sarah]

Paul,
Update: if I run the pay history report, for one employee at a time, I get the info I need for Work Comp reporting.