PacMech
Level 2

Employees and payroll

I didn't see your question answered specifically enough for what it sounds like you're asking, so I'm jumping in as I am working on an insurance audit today and they are pretty much asking the exact question (employee's gross pay and how many weeks worked is what my insurance auditor wants, you can just ignore the gross pay portion and focus on the hours worked by an employee by the week for a specific term).  Here's what I did:

 

-Open up the Payroll Summary Report and fill in the From/To Dates for the report.

-Customize the Payroll Summary Report - Click on the Filter Tab to filter it to the specific employee you are working on.

-When the Payroll Summary Report shows the one employee you are working on, double-click on the employees gross wages amount (you'll see black arrows surround the amount when you click on it - you'll need to double-click to blow open a report called "Transactions by Payroll Item".

-When the Transactions by Payroll Item report has been opened in the previous step, choose Customize Report and in the customize report screen, for the columns displayed, scroll down the list where you would put a checkmark next to each item you want displayed and choose "Qty" - this stands for Quantity, and on this particular report, it'll give you the hours worked as the Quantity.

-Of note, if an employee has several different payroll items on one paycheck date, it'll show the hours for each of the payroll items as separate line items - so for instance you may see 2 lines with the same paycheck date, where they were paid two different payroll items (such as regular pay on one line, sick pay or overtime on a different line), but the dates are all clumped together in date order, so it's pretty easy to see if they've worked that week for what I'm doing.

 

Hope this helps!