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!
2 Responses to Billing Employee Time to Customers
- Using Account Numbers in Your QuickBooks Chart of Accounts
- Straight from the IRS - Social Security Tax Reduced to 4.2%
- QuickBooks 2012 - Frequently Asked Questions About Upgrading
- QuickBooks 2013 Upgrade Do's, Don'ts & Frequent Questions
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Tip - Determing Cost of Goods Sold
- QuickBooks for Contractors Tip – Advanced Progress Invoicing
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- QuickBooks 2012 Announced
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- New FHWA-1391 & 1392 Annual EEO Forms For Highway Contractors
- Frequently Asked Questions - California Prevailing Wage
- QuickBooks 2012 - Best Practices & Tips for Installing an Upgrade
- QuickBooks Tip - Child Support Garnishments
- QuickBooks 2011 - New Balance Sheet by Class Report - Part 1
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- QuickBooks 2011 - Computer Requirements & Office Compatibility
Join us on the 2nd Wednesday of each month, from 5-6 p.m. EST, on Google+ for the QuickBooks for Contractors hangout!
Webinar - QuickBooks Job Costing from A-Z
Having trouble getting job costing reports out of QuickBooks? Or maybe you are wondering if the information you see is accurate. Setup is KEY! Join us for an intensive 1 1/2 hour webinar covering job costing techniques and procedures on Wednesday March 26, 2014 from 1-2:30 p.m. EST. Sign up here.