Hello everyone,
My employees are paid on an hourly basis and their pay rate depends on the work they're performing. I would like to know how to enter an employee's time into the weekly timesheet and attribute that time to a customer's job and service item. The service item drives the customer's billing rate and employee's pay rate. Is it possible for the customer to see a specific service item rate on their invoice with the employee's lesser rate showing up on some type of wage report?
A little background, I use a 3rd party for payroll and need to report hours and rates monthly to my accountant.
Thank you!
Solved! Go to Solution.
Good to see you here, awthomas85.
I'd like to share what I know about timesheets in QuickBooks Desktop.
You can enter the CUSTOMER: JOB hours in the Weekly Timesheets. Ensure to use the prior date the job was done. This way, it won’t affect your future payroll. Let me show you how to do it in your QuickBooks Desktop (QBDT) software:
You may refer to this article to learn more about entering timesheets: Create timesheets and time data report
Please know that you can always get back to us if you have any other clarifications or questions about managing employees' timesheets. I'm always here to help. Have a great day!
Good to see you here, awthomas85.
I'd like to share what I know about timesheets in QuickBooks Desktop.
You can enter the CUSTOMER: JOB hours in the Weekly Timesheets. Ensure to use the prior date the job was done. This way, it won’t affect your future payroll. Let me show you how to do it in your QuickBooks Desktop (QBDT) software:
You may refer to this article to learn more about entering timesheets: Create timesheets and time data report
Please know that you can always get back to us if you have any other clarifications or questions about managing employees' timesheets. I'm always here to help. Have a great day!
Thank you!
Your post helped me get setup where the "Payroll Item" field now shows for each employee. I've also got each employee set up with their respective pay rates.
Could you point me in the direction of a report that I could run monthly, that shows the number of hours worked for each "payroll item" by employee name? I haven't been able to find that one.
Thank you for your guidance.
Hi awthomas85,
I've got the information you're looking for about a report that shows the employee's number of hours worked per item.
You can pull up the Payroll Item Detail report and customize it to the data needed. Let me show you how:
You can check this resource page for future reference in case you want to learn more about the recording of timesheets by an employee in QuickBooks Desktop: Create and print timesheets.
Please let me know if there's anything I can do to help. I'm always around to assist you. Have a good day!
Thank you for your response.
Unfortunately when I follow your instructions, step by step, the report is blank with a total of 0 for all employees.
I've done a bit of troubleshooting and added all possible columns under the customize>display section. None of them display their hours worked by payroll item. I also eliminated all filters with the same result.
Good evening, @awthomas85.
Thanks for reaching back out to us.
To clarify, is this only happening in the file you're currently in? I recommend trying another file to see if you get the same result.
If you get the same result, perform the steps to repair the program.
If not, use our Verify and Rebuild tool to help eliminate this problem in the file you're using.
Please come back and let us know how it goes. It's my priority that you get this taken care of as soon as possible. Bye for now!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here