[Question] Setting Up Project Job Costs in Quickbooks?

[litlearth]

Hi,

Does anyone know if Quickbooks offers/provides a report for job costs per project? I see the profit & loss by job and the job profitability. But they aren't given the exact information needed. I could be doing something wrong to not generate the proper information though. The job profitability seems good, but it's not detailed enough. Here's what I'm trying to do...
My client has about 10 clients/projects and wants to bill each one appropriately. He needs to be able to generate a report that automatically calculate the job cost for each project - showing the hours worked, burdened rate, labor cost, the balance to finish the project, etc. I've created an excel spreadsheet for me to go in and plug in the numbers and give him a report until I can figure out how to do this in Quickbooks. Does anyone know anything about this? Any advice? Are there any add-ons that Quickbooks allows that I can use to generate a report like this? Does anyone know of another software to use to generate a report like this?

Thanks so much for any help you can provide.

I've searched for this in the forum and didn't see it. If anyone does know if there has been a post of this, please guide me to it.


Tia

[christinenc]

Hi,

Does anyone know if Quickbooks offers/provides a report for job costs per project? I see the profit & loss by job and the job profitability. But they aren't given the exact information needed. I could be doing something wrong to not generate the proper information though. The job profitability seems good, but it's not detailed enough. Here's what I'm trying to do...
My client has about 10 clients/projects and wants to bill each one appropriately. He needs to be able to generate a report that automatically calculate the job cost for each project - showing the hours worked, burdened rate, labor cost, the balance to finish the project, etc. I've created an excel spreadsheet for me to go in and plug in the numbers and give him a report until I can figure out how to do this in Quickbooks. Does anyone know anything about this? Any advice? Are there any add-ons that Quickbooks allows that I can use to generate a report like this? Does anyone know of another software to use to generate a report like this?

Thanks so much for any help you can provide.

I've searched for this in the forum and didn't see it. If anyone does know if there has been a post of this, please guide me to it.


Tia

Hi Tia,

You can get the reports out of QB that you want. Is your client a contractor? If so, then use estimates and progress invoicing for your client to be able to show the estimated cost and to bill against that and also show how much is still owed by the client. If not, but they give estimates for a job then you can still use progress invoicing. It all depends on how the billing is done. If the clients are invoiced at an hourly rate, but receive payments against the full amount, then a statement can be issued to show the balance still owed on the invoice . To get labor costs, all of the hours worked on a job will need to be assigned to that job. You'll need to use the lists to assign everything to the jobs.

Feel free to PM me if you need to.

Christine

[litlearth]

Thanks so much for your response.

Well this is based mostly on the client wanting to know how much has been spent on a job for the employees only (for now). He wants to be able to see if he's going over or under budget during the job in case he needs to move some people (the higher paid employees) off of it and put other people on it (maybe one or two people as opposed to 5 people). So I would do a (actual vs. budget) report...but for hours/time spent on the project. I don't see where QB will allow me to generate a report like that - something showing the cost of the job (based on hours spent only) for this period, prior periods, and the total remaining.

I hope that's not too confusing.

Thanks for any help.

LOVE
Tia