Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 16, 2019
Question

Items for Excavator

  • February 16, 2019
  • 13 replies
  • 57 views

Hello All,

We are a growing company that does a wide variety of work and transforming into a GC.  I'm a bit stuck on how to setup my items.  I have a lot of heavy equipment, so if I setup an item for the different sub phase of excavating do I need to setup an item for each piece of equipment & corresponding labor for each phase that the equipment might possibly be used for?  I think this could be overwhelming for my guys to get the codes right (using tsheets).  I'm looking for the best approach to tracking the general labor, equipment & equipment labor for each phase that equipment may be used (Bobcat, Dozer, Haul Truck, Excavator, Backhoe...etc).  I don't think I will be able to track material by the subphases (if we get loads of stone it would be impossible to separate it to the subphases).  We use the equipment in other ways (bobcats for snow removal for example).  Does anyone have any advice how how to setup my item lists?  

 

Also, is there a way to get the Time by Job summary report to show in a hierarchy instead of it showing the header:subphase:subphase? It is difficult to read this way.

 

Thanks in advance for your valuable input.  We are using QB Premier contractor edition - Desktop

13 replies

qbteachmt
Level 11
February 16, 2019

Let's take a bit at a time:

 

"I have a lot of heavy equipment, so if I setup an item for the different sub phase of excavating"

 

You would only do this if it Matters to you; if you charge different Rates for the different Services; if you need to use that level of detail on Estimates and Purchase and Sales. Otherwise, it might just be "Service item = Excavator, rate per hour." Then, you can put some short description, such as on an Estimate:

Excavator, 5 hours, Clearing

Excavator, 1 hour, Foundation Prep

Excavator, 1 hour, Driveway Prep

 

Or, you want:

Clearing, rate might or might not be different

Foundation, rate might or might not be different

Driveway/Paths, rate might or might not be different

 

That's up to you, for what you want to see and use in reporting and data management.

 

"& corresponding labor"

 

Again, that's up to you. Example: Labor. Or, Landscape Labor vs Roofing Labor.

 

"for each phase that the equipment might possibly be used for?  I think this could be overwhelming for my guys to get the codes right (using tsheets)."

 

You also get to use them differently. Example:

On the Estimate, you listed the Excavator. On the Timesheets, the People list their Tasks, which might be Operator, or General Cleanup. These people are Not the Excavator. They use the excavator.

 

"I'm looking for the best approach to tracking the general labor, equipment & equipment labor for each phase that equipment may be used (Bobcat, Dozer, Haul Truck, Excavator, Backhoe...etc)."

 

Again, it's up to you. for what matters to you. I have an attached example of "Appliance" that is generic as Item, used specifically for quotes, purchase and sales entries.

 

"I don't think I will be able to track material by the subphases (if we get loads of stone it would be impossible to separate it to the subphases)."

 

Well, stone is stone, unless you Need to see it, quote it, buy it and track it as "noninventory item types" for Pit Run, 3/4", Stone Dust, etc. Again, only you know what matters in your operation. It is all provided for. Here's what I teach: You cannot report what you did not track. If you find yourself doing lots of freeform text, then you should have made more items, and not Notation and memos and freeform text.

 

"We use the equipment in other ways (bobcats for snow removal for example).  Does anyone have any advice how how to setup my item lists?"

 

Snow Removal is what you Charge me. Bobcats are what you Used to do that work. Someone Drove that Bobcat around. You won't track the Bobcat using the Employee's timesheet. You track the Employee's tasks, spent working at my location, doing that Snow Removal service. If you want to see "Snow Removal Driver" and "Snow Removal Labor" to track, report and manage your Staff, that means you need those two, separate, service items. You might be charging me "Monthly Maintenance Contract Fee" which is the same summer and winter, because you blow, mow, and generally maintain my property under a monthly contract fee.

 

See how what you manage is up to you, what you call it, how many different things you need, whether you job track it or not, and if that is billable or not?

 

"Also, is there a way to get the Time by Job summary report to show in a hierarchy instead of it showing the header:subphase:subphase? It is difficult to read this way."

 

That's the designation that a hierarchy exists. Run the different reports: Time by Item by Job by Name. Time by Name by Item by Job. Time by Name by Item. Time by Item by Job.

February 16, 2019

Thank you so much for taking the time to reply to my post.  I appreciate your response.  I am trying to accomplish multiple layers of things.  Using the items to create our estimates and also be able to present job progress reports to our foreman to better manage the job in the field and of course analysis from a financial perspective.  Yes stone is stone but what the foreman has told me they would like to see is how each phase is going as compared to what was estimated (Needed 20T of stone, is at 23T now and job not done) but when I haul stone it it will be for the job as whole not specifically for a specific phase so I will not be trying to separate the material. We of course expect this to help us better estimate and better manage the projects.  All of our team are multi faceted, meaning I don't have just an operator, the operator may perform many tasks while on the jobsite.  While they would select a labor code of course I need to know what piece of equipment they were using not just that they were an operator.  This is also for multiple reasons - the equipment is billed at different rates, the equipment has different operation costs, I want to know how much each piece of equipment is utilized, and if we are working a prevailing wage job then the labor rates can be different depending on which piece of equipment the are using.  This is essentially what is driving the equipment question, when my team is using the bobcat, I need to know that is the piece of equipment they were on so I can't just have an operator code in the phase.  But I didn't want to have Equipment, subphase bobcat equip and subphase bobcat operator (effectively two codes for each piece of equipment) under every single phase.  

 

so for simple example:

 

Phase - Strip Top Soil 

              General Labor

              Equipment

                    Bobcat

                    Bobcat Operator

                    Excavator

                    Excavator Operator

   

Phase - Subgrade

              General Labor

              Equipment

                    Bobcat

                    Bobcat Operator

                    Excavator

                    Excavator Operator

Phase -Snow Removal\Salting

              General Labor (salting sidewalks)

              Equipment

                    Bobcat 

                    Bobcat Operator

                    Salt Truck

                    Snow Plow

              Material

                    Spreader Salt

                    Bag Salt

 

And so on.  I would then have this for every Phase and Every Main category of work (Septic, Snow Removal, Excavation, etc). I think I must just be looking at it wrong, at least I hope that I am as I don't like the way I am approaching it.  I'm trying to gather enough information to provide the foreman running the job, to input the estimate in a meaningful way to analyze where we are doing well and where we need to work on but not make it ridiculous or crazy to collect the data in this way.  

 

Setting up multi tiered phases\subphases is also what makes the Time by Job Summary difficult to read as it it strings it all together Strip Top Soil:Equipment:Bobcat Operator

 

 

 

February 17, 2019

Your attachment for Est vs Actuals shows only Costs. Make sure All of your items are Two Sided.

 

Please see my attachment.


Thank you for all of your input, I think I need to work through some examples of the information you presented to get my head around what you are saying.  A couple of comments while I do that....

 

I can create two estimates but I was hoping to design this so that only one entry was needed to accomplish multiple things (ie create a detailed estimate (for my estimator and for tracking the job), print the initial estimate with scope and detail costs\quantities excluding rates for my foreman on one sheet at the start of the job and print the summary scope with total price (using the groups) for the customer.  So I was looking at the different options to do this.  If I don't select to print the items of the group it accomplishes two of these (though I think the 50 item limit for a group might run into issues if my items are this detailed).  But I couldn't figure out how to get the foreman piece without printing multiple reports for the foreman, which is where printing the detailed estimate cover letter came into play - even with the group set to roll up into one line the detail cover letter still shows the details with the quantities.  So this seemed to capture all three needs with just one entry.  The detailed estimate cover letter inserts the "estimation block" so after it is output to Word it can be formatted and yes I can do that I was just looking to have it flow without having to do additional steps.  I looked at the field options to further customize it but haven't found a way to go further than what I was trying to explain.

 

The estimate vs actual report I attached...I intentially turned off the actual cost for the purpose of printing that report.  I was still on the thought process of the best report to give my foreman at the start of the project so it was only showing the estimated.  the items are two sided.

 

If I use say non inventory it doesn't allow me to attach it to the service item so I can't keep it grouped with the phase for the job, yes?