cancel
Showing results for 
Search instead for 
Did you mean: 
pjmitchell55
Level 3

Using classes, job costing, equipment cost, etc

We WILL be using QuickBooks desktop CONTRACTOR edition.  My question is this:

 

The company owner wants to be able to get report of Profit & Loss for each project,  but also wants to track operating cost of trucks/equipment used.  Note - Many vehicles and equipment are leased, or rented.

 

A consultant, who I question is really as knowledegable as she claims at least as it pertains to QB, has told the owner that by using classes he can get all this.  I have not used classes in QB but have viewed several videos on this and don’t see how it is going to get the owner the information he wants. Maybe I'm just not getting it, so that's why I am here.

 

The owner desperately wants to get a handle on how much each truck /  piece of equipment costs him to operate,  but also wants to know  the costs on each as it relates to a particular project.

 

We know the factors that have to go into figuring out an hourly cost.  Whether this can be done in QB or not, I am not aware.  And if it can be, how, and also how do we apply this to a particular project?

 

 

13 Comments 13
Angelyn_T
QuickBooks Team

Using classes, job costing, equipment cost, etc

Thank you for the detailed information, @pjmitchell55.

 

Yes, you can use the class tracking feature to track these transactions in QuickBooks Desktop (QBDT). Once the feature is activated from the Preferences, you can now add a class to your transactions. That said, you can either open the Profit and Loss by Job or Profit and Loss by Class, then filter the names to your jobs/projects if you want to get a report for each project.

 

On the other hand, the hourly costs entered in QuickBooks (expense or payroll) can only be track by jobs.

 

To open the report/s:

 

  1. Select Company & Financial from the Reports tab, then click on Profit & Loss by Job or Profit and Loss by Class.
  2. Make the customization from the report's page. If you wish to open the Profit and Loss by Class, filter the name/s to show just your project/s.
  3. Tap OK to refresh the page.

To learn more about these features, check out the topics from these articles:

 

Also, read the details from this link to learn more about running and customizing reports in QBDT.

 

Let me know if you have any other questions. I'm always here to help as quickly as I can. Have a good day, @pjmitchell55!

Fiat Lux - ASIA
Level 15

Using classes, job costing, equipment cost, etc

@pjmitchell55 

If you don't need to have more than 5 users working on the same company file at the same time, consider using QBD Premier with a one time license and integrate it with a construction management app.

Sbond
Level 1

Using classes, job costing, equipment cost, etc

Hi PJ Mitchell,

I am new to QB Desktop Contractors and find myself needing the same type of set-up.  Have you had any luck figuring out equipment cost?

Maybelle_S
QuickBooks Team

Using classes, job costing, equipment cost, etc

Thanks for joining the thread, @Sbond.

 

You can follow the steps given by my colleague @Angelyn_T about tracking costs in QuickBooks Desktop (QBDT).

 

You can also check this article for more details: Tracking job costs in QuickBooks Desktop.

 

I've added this link about customizing jobs and sales reports in QBDT: Customize customer, job, and sales reports.

 

You can always visit us again if you have other questions. I'm here to help.

Pro Grade Enterprises Inc
Level 2

Using classes, job costing, equipment cost, etc

The steps you showed are great but where to you enter in the hours which piece of equipment is used

Candice C
QuickBooks Team

Using classes, job costing, equipment cost, etc

Good evening, @Pro Grade Enterprises Inc

 

Thanks for chiming in on this thread. I hope your day is going well so far. 

 

If the steps my colleague stated didn't help, then I recommend contacting our Customer Support Team for further assistance. They'll be able to use a screen share to walk you through some additional steps. Here's how: 

 

  1. Go to the Help menu. 
  2. Hit QuickBooks Desktop Help
  3. Press the Contact Us hyperlink. 
  4. Give a brief description of the issue and click Let's talk
  5. Scroll down and choose to get a callback

 

It's that simple. 

 

If you have any other questions of concerns, please don't hesitate to reach back out. I'll be here to help in any way that I can!

Fiat Lux - ASIA
Level 15

Using classes, job costing, equipment cost, etc

@Pro Grade Enterprises Inc 

You need a 3rd party app to track your equipment time and integrate it with your QB Desktop or QB Online. It also supports the VisionLink app and you will no longer have to guess where your dozer is or which employee is operating it.

pjmitchell55
Level 3

Using classes, job costing, equipment cost, etc

I see this thread has been resurrected so thought I would chime back in.

 

Without the company having to buy additional software, right now I am getting what we need by manually calculating our overhead costs, coming up with an employee pay rate that incorporates that and enter that rate into TSheets (QB Time).  Then I run a job costing report from TSheets so I get everyone's time and cost (with labor burden) and I get the time spent on various equipment (each has been entered into TSheets as a class.) It also gives me the jobs worked on.   I apply an operating rate (I believe by BlueBook).  THEN I have to do an internal "bill" where I can apply the labor cost and equipment cost to the various projects, and THEN I apply the total cost for the week with NO job.  The end result is zero, but it gets those labor and equipment costs into QB without affecting our P&L etc. so I can run a P&L by Class report.  Also a Job Profitability Report.

 

Pain in the butt, but I am so used to it now, it doesn't take that long. At least until / if / when we buy new/additional software and go through all the set up and converting process.  I'm still having PTSD from having to convert from QB Online to QB Desktop so I am in no rush now.

 

 

chrisdt
Level 2

Using classes, job costing, equipment cost, etc

Hey,

Are you still using this method? Did you find anything else?

pjmitchell55
Level 3

Using classes, job costing, equipment cost, etc

Sorry for the delayed response.  Still plugging away at "my" method. We are changing a lot at my office so will keep doing it this way until I see what they end up doing.

Naw-Ruh9000
Level 1

Using classes, job costing, equipment cost, etc

 
MaryLandT
Moderator

Using classes, job costing, equipment cost, etc

Hi there, Naw-Ruh9000.

 

I can see that you've edited your post. Please don't hesitate to leave a comment below if you need help.

 

I'm adding these articles to learn how job costing and class tracking works in QuickBooks Desktop.

 

 

I'll keep this post while waiting for your response. Thank you and have a great day ahead!

AJR6
Level 1

Using classes, job costing, equipment cost, etc

I have a question relating to overhead expenses. How would you allocate rent, for example? I understand the formula for calculating overhead costs, but how would you set this up in QBDT for the job costing report? We have assigned materials, payroll, etc. to each job, but am not sure how to set up overhead for each job. How would this be done? 

Need to get in touch?

Contact us