Employee Hours Report

Barbara Allen-Guthrie

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?

Acctd4

Hi @Barbara Allen-Guthrie

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 😊

Barbara Allen-Guthrie

https://community.reckon.com/discussion/comment/20655317#Comment_20655317

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.

Barbara Allen-Guthrie

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.

Acctd4

Add the Sales Price column:

☺️

Barbara Allen-Guthrie

Thank you thank you Shaz, you are wonderful, who would have thought Sales Price, that is it 😍

Acctd4

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)

Barbara Allen-Guthrie

OMG how weird, thank you Shaz I will check this out.