- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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:
- Select Company & Financial from the Reports tab, then click on Profit & Loss by Job or Profit and Loss by Class.
- 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.
- 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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
The steps you showed are great but where to you enter in the hours which piece of equipment is used
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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:
- Go to the Help menu.
- Hit QuickBooks Desktop Help.
- Press the Contact Us hyperlink.
- Give a brief description of the issue and click Let's talk.
- 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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Hey,
Are you still using this method? Did you find anything else?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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?