Billing employee time on customer invoices is something that many business need to do – not just contractors who perform Time & Materials Billing. Making sure that you bill all of the time your employee(s) have spent working on specific jobs or tasks for customers is crucial and depends data that you’ve entered in QuickBooks. Here’s a question from a reader.
Thanks for the tips.
I’m used to using the “Unbilled costs by job” report, however I am stumped when it comes to billable hours I’ve entered using the timesheet function. How do I tell if I need to create an invoice for a client to bill them for hours entered? Those hours do not show up on the “Unbilled costs by job report” !!
Any help would be greatly appreciated. Nick
Thanks for stopping by and submitting a question.
Actually, your question confused me and I’ve had to do some research. I “think” I’ve discovered the reason why you aren’t seeing the information that you want in the “Unbilled Costs by Job” report (found by going to the QuickBooks Reports menu -> choosing Jobs, Time & Mileage -> and selecting the Unbilled Costs by Job report).
When I run an Unbilled Costs by Job report in any of my test files, I get employee time from paychecks that I’ve created in QuickBooks, see below:
So either you aren’t doing payroll (actually creating paychecks) in QuickBooks – or somehow you’ve modified the original report to exclude payroll.
If you aren’t running payroll in QuickBooks this would explain why those costs aren’t appearing in this report – but there is a backdoor method to find out the billing status of the time you’ve entered into timesheets.
From the Reports menu -> choose Jobs, Time & Mileage -> and select the Time by Job Detail Report, this report will show you all the time you’ve entered by Customer/Client, Service Item, and Employee and how much time they spent; see below:
However, this only adds to my confusion. The time shown in the screenshot above does not have a paycheck associated with it (so doesn’t show up on the Unbilled Costs by Job Report), however, when I go to create an invoice, select this specific customer and go to the Time & Expenses option and click on the Time tab – those hours are displayed there. See below:
What version of QuickBooks are you using Nick? At this point I’m thoroughly confused!