Employee Hours Report
A client of mine has said, the following but I cannot figure out how to run a report showing the hours worked, amounts paid to check them all, Help!
Our HR contact said for any time sheeted staff we need to do a year end reconciliation between hours paid and there time sheets to ensure we havenβt underpaid them?
Answers
-
There are a number of reports you can create to show this. Probably, the simplest one is the Payroll Summary with the (Hours &) Rate columns added :
You can also filter it to the relevant timeframe, Payroll Items & employees if you prefer π
1 -
Thanks Shaz, I have ran that report, but the problem I have is they increased the hourly rate of one employee and also paid them back pay, so the amount of $11,007.26 is right as some of it was paid at $26.66 and some at $28 per hour, and then $31 per hour, but if you take 388.25 hours x 31 as per this report she would think she should have got $12,035.75, so then I break that report amount down further if it would show the $28 and $26.66 per hour it would look ok, but I don't know how to make it do that, does that make sense, I have done two screen shots.
0 -
I have the hours into the report, if I could just find how to add the Rate of Earnings but I cannot see that item.
0 -
-
Thank you thank you Shaz, you are wonderful, who would have thought Sales Price, that is it π
2 -
Absolutely β¦! Sometimes I also discover things completely by accident π€£π
Another useful FYI β¦ On a Super report, the Sales Price column will actually display the Super percentage rate used on each Paycheque :
(This is a very old file! LOL)
2 -
OMG how weird, thank you Shaz I will check this out.
1
