Tracking Timesheet Hours vs Hours Invoiced
Tracking timesheet hours vs hours invoiced is crucial for a companies cash flow. See this question submitted by a reader.
I’ve also noticed it is possible to add time to timesheets that have already been billed. Is there a way to prevent this?
Thanks for your time and energy. Brian
Thanks for stopping by and submitting a question.
QuickBooks has some good time tracking reports, here are my recommendations for some reports for you to look at.
The Time by Job Detail Report is available in all versions/flavors (Pro, Premier, Enterprise); access it from the Reports menu -> Jobs, Time & Mileage. If you don’t see a Billing Status column, click the Customize Report button and on the Display tab, check Billing Status. Once the Billing Status column has been activated you can tell if the time is billable, not billable, or has been billed.
If you are using the Premier Contractor or Enterprise Contractor versions, check out the Billed/Unbilled Hours by Person and Job Report; access it from the Reports menu -> Contractor Reports. This report is very easy to read as it has columns for Billed, Unbilled, and Not Billable – which makes it very easy to read.
No matter what version of QuickBooks you are using, you might want to check out some of the Contributed Reports – accessed from the Reports menu. These are custom reports that have either been created by Intuit or other QuickBooks users just like you, and you can download and import the report template into your own version of the software.
Yes, it is possible to add more hours to a timesheet after you’ve created paychecks and after you’ve pulled unbilled time into customer invoices. This feature has it’s good and bad points, unfortunately. It’s great if you discover that you didn’t enter all of an employee’s time and shorted him/her in their paycheck and want to get those missed hours into your job costing reports.
As for preventing someone’s ability to enter time after the fact, in Pro or Premier you could edit various user accounts and on the Time Tracking window, set their status as No Access – which means that the user in question would not be able to access any of the time tracking functions at all – including the ability to create reports (so you do want to be careful with these settings). Another thing that you could do, is to set a closing date password after you’ve pulled billable time into Invoices. That way, you would be the only one who could modify any existing timesheet entries by providing the closing date password.
I “think” that in the Enterprise versions you have more flexibility with these specific settings – unfortunately I don’t have Enterprise installed on my laptop so can’t check it out for you at the moment.
2 Responses to Tracking Timesheet Hours vs Hours Invoiced
Leave a Reply
- The Great Debate – QuickBooks Desktop vs. QuickBooks Online
- Using Account Numbers in Your QuickBooks Chart of Accounts
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- How To Turn On and Use Manual Payroll in QuickBooks
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- QuickBooks Tip - Child Support Garnishments
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- QuickBooks Tip-Creating a Functional Payroll Liabilities Section
- Welcome to the QuickBooks for contractors blog
- QuickBooks Tip: Important Facts About Items Left as Billable
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Tip - Determing Cost of Goods Sold
- Straight from the IRS - Social Security Tax Reduced to 4.2%
- QuickBooks 2013 Upgrade Do's, Don'ts & Frequent Questions
- QuickBooks 2012 - Frequently Asked Questions About Upgrading
- QuickBooks 2015 Announced - Important System Requirements
- QuickBooks 2015- The Good, Bad and Ugly, Part 1