cancel
Showing results for 
Search instead for 
Did you mean: 
mdean6899
Level 1

Job costing: allocating labor costs

I have a company that has about 150 employees (75% salary and 25% hourly), and we use the Desktop Enterprise 17.0 version of QuickBooks. In addition, we use a third party payroll service as well as Tsheets for time entry. Currently we have about 1,000 jobs set up in QuickBooks. Every time we add a job, it goes into QuickBooks first and then syncs to Tsheets. Employees enter their hours each week to Tsheets, and once approved they are synced to QuickBooks, so timesheets in QB are updated with actual hours worked.

 

Here is my issue: I would like to know how to get per-job labor costs on the Job Profitability Reports. We have salaried and hourly employees who are paid every two weeks, but each employee might work 1-50 jobs during that time. Is there any way to get the labor costs that I get from our Payroll provider into QuickBooks by job? I know that I can download a Tsheets report and summarize everyone's hours by job and then apply their salary, but that is an incredible amount of work. We can't be the only company that has this issue - can someone suggest a way to get the information I need? I just want to be able to pull a Job Profitability Report for a particular job and see the labor costs in there. 

 

Thanks!
Matt

5 Comments 5
QBsguru
Level 7

Job costing: allocating labor costs

I am assuming that your payroll costs are either manually entered as a journal entry based on the payroll company's report or the transactions are downloaded in summary form from the payroll company.

 

The only way to get the details into QuickBooks for job costing with a very tedious example you suggest is to run payroll within QuickBooks.  This will enter actual costs per job.  But then you run into another issue.  Each paycheck would have to be referenced against the payroll reports since their will be some issues with withholding amounts and net pay. 

 

If this is really your goal, you might consider Intuit Assisted Payroll Service.  Assisted will handle your tax reporting and payments.  However, at 150 employees you are pushing that system to the limit.  I did it for a couple of years with 300+ employees, but when it finally maxxed out we had major problems and little time to correct the issue of getting everyone paid before deciding to switch to a payroll service mid-year.

Teri
Level 9

Job costing: allocating labor costs

Sounds very painful to pay for three different systems and still not be able to get job cost reports! I can point you to a system that does all of this automatically and no need to wait for Payroll runs. I do not sell any systems but know them well as all my clients require true job costing including all direct and indirect cost and all must include on customer invoices submitted within 3 days.

 


@mdean6899 wrote:

I have a company that has about 150 employees (75% salary and 25% hourly), and we use the Desktop Enterprise 17.0 version of QuickBooks. In addition, we use a third party payroll service as well as Tsheets for time entry. Currently we have about 1,000 jobs set up in QuickBooks. Every time we add a job, it goes into QuickBooks first and then syncs to Tsheets. Employees enter their hours each week to Tsheets, and once approved they are synced to QuickBooks, so timesheets in QB are updated with actual hours worked.

 

Here is my issue: I would like to know how to get per-job labor costs on the Job Profitability Reports. We have salaried and hourly employees who are paid every two weeks, but each employee might work 1-50 jobs during that time. Is there any way to get the labor costs that I get from our Payroll provider into QuickBooks by job? I know that I can download a Tsheets report and summarize everyone's hours by job and then apply their salary, but that is an incredible amount of work. We can't be the only company that has this issue - can someone suggest a way to get the information I need? I just want to be able to pull a Job Profitability Report for a particular job and see the labor costs in there. 

 

Thanks!
Matt


 

Colleen411
Level 1

Job costing: allocating labor costs

Teri;  Can you please send me the name of the company/software?  I need to look at this option.  Thanks.

JosiahK
Level 1

Job costing: allocating labor costs

I'd be curious to hear about this software of which you speak, as well. Could you send me the info? Thanks! -josiah

GreenLife
Level 1

Job costing: allocating labor costs

Hi Teri,

Could you please let me know the name of the company or software you were referring to? Would be much appreciated :)

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us