How-to Customize a Report – One Employee for All Jobs Worked
Customizing reports in QuickBooks is often a huge source of frustration for users. Here’s a great example of just how frustrating it can be. This question was submitted by a reader of our blog.
For the life of me I cannot understand why source name is a foundation for reports yet not available as a selected filter. Thank you – Sam
Source Name is only available in certain QuickBooks Reports – which I agree can be quite frustrating, to say the least.
I think that I would approach creating the report that you need, that targets one specific employee with hours worked on all jobs over a specific time period, a little differently.
- start by going to the Reports menu in QuickBooks
- choosing Jobs, Time & Mileage
- Time by Name Report
- click the Customize Report button in the upper left
- click the Filters tab
- select Name in the Filter box -> then using the Name drop-down menu -> choose Multiple Names -> then in the Select Name window, make sure that the radio button next to Manual is selected, then in the list on the right, scroll down and select (click on) just this one employee, then click the OK button
- Now back at the Modify Report: Time by Name window-> click the Display tab, change your report dates to be the period that you are looking for, click the Ok button again
The final report that is displayed should look something like the sample in the graphic below – which shows the total number of hours worked on each job by this specific employee for the date range that you selected.
If you need or want a more detailed report, try customizing the Time By Job Detail Report in the same manner as outlined above, this will give you a breakdown of hours worked by day, by service item (cost code) and you can even choose to Display the name of the Payroll item used and the billing status of the employees time.
I hope this has helped solve your report frustration, if you have additional questions or more help – please let me know.
2 Responses to How-to Customize a Report – One Employee for All Jobs Worked
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
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- How To Turn On and Use Manual Payroll in QuickBooks
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks Tip - Child Support Garnishments
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- Welcome to the QuickBooks for contractors blog
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Tip-Creating a Functional Payroll Liabilities Section
- QuickBooks Tip: Important Facts About Items Left as Billable
- 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- The Good, Bad and Ugly, Part 1
- QuickBooks 2015 Announced - Important System Requirements