Ashley65
Level 3

Job Reports to show Labor Expenses

Hello, 

 

I'm using QBD Pro+ 2018. I have very recently converted over from Sage and just finished setting up TSheets integration. That provides the weekly timesheet information for us. We outsource payroll processing. I have tried and tried and cannot find out how to get the Job Profitability report and the P&L by Job reports (or anything else) to show how much labor was spent on a job. Although we don't bill the customer for labor, it is a huge part of our estimating process and we need to know how much time is actually spent on each job. It took zero set up to see this in Sage and I view it as a very basic report/feature so I'm really surprised it doesn't just pop up normally unless I'm missing a checkbox or filter somewhere. 

 

I do have "Track Expenses by Job" and "Job Costing and Item tracking for paycheck expenses" selected. I have not turned on class tracking, as the help guide says it is generally for multiple locations and such. We only have shop labor and office labor, which each have their own accounts and payroll items.

 

Whenever I try to add a payroll item filter to a job report, it doesn't show any payroll information and even clears out everything else on the report like income and expenses. 

 

On one of the guides, there's a note: "Time sheets are a non-posting entry. Time must be imported to a bill or invoice to be included in the Job Profitability or Company Financial Reports." I'm hoping this doesn't mean I need to purchase payroll. As I've said, it is already outsourced and we are locked into a contract. It should not be required just to get accurate job reports. Maybe I misunderstand what it means. 

 

On a side note, is selecting a service item on each line in the Weekly Timesheets required for my situation? And is there a way to set that up to autofill automatically between QB and TSheets depending on the job/customer if so? It seems like an unnecessary step for us as everyone is either shop labor or office labor, and those are already 2 payroll items tied to 2 accounts. 

 

So, thanks for reading. I realize there are tons of guides and posts about this, but I still can't find a fix. 

Solved