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 π
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! *** Bookkeeping & 1-on-1 customised software Training/Troubleshooting ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
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 -
Add the Sales Price column:
βΊοΈ
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! *** Bookkeeping & 1-on-1 customised software Training/Troubleshooting ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
3 -
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)
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! *** Bookkeeping & 1-on-1 customised software Training/Troubleshooting ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
2 -
OMG how weird, thank you Shaz I will check this out.
1
