Skip to main content

Get 50% OFF QuickBooks for 3 months*

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

Items for Excavator

  • February 16, 2019
  • 1 reply
  • 18 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

1 reply

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

 

 

 

Rose-A
Level 10
February 16, 2019

Greetings, overtaxed72.

Allow me to step in and provide some information about items in QuickBooks Desktop.

 

You can manage your Inventory by creating and building Inventory Assembly item, which can be a combination of inventory part items and/or sub-assemblies into a single item. An assembly is usually used for a unique item you make from other items.

 

To build an inventory assembly item:

 

  1. From the Inventory menu, choose Build Assemblies.
  2. From the Assembly Item drop-down, select an assembly item to build.
    Note: Depending on Inventory Preferences settings, you may or may not see the Quantity on Sales OrderQuantity Reserved for Other Assemblies, and Quantity Available information. The table in the middle of the Build Assemblies window lists the components (BOM) needed to build this assembly item. For each component, the quantity on hand and the quantity needed for the current build quantity are also shown. The quantity needed automatically updates as you enter different quantities to build. With Advanced Inventory, components can be selected from multiple sites. Directly below the table is the maximum quantity of this assembly item that you can build, given the current quantities of the components on hand.
  3. (With Advanced Inventory) Choose the Finished Assembly Inventory Site drop-down and select the site where the assembly will be stored after it is built. You can track multiple inventory sites with the Advanced Inventory add-on available in QuickBooks Desktop Enterprise US or Canada.
    1. From the Site drop-down, select the site each component will come from.
    2. Enter a quantity in the Quantity to Build field and press Tab to update the Qty Needed column in the components table.
      Note: If you enter a quantity greater than the quantity indicated by Maximum number you can build from the quantity on hand, you will be prompted to mark the build as pending. After marking the build as pending, you'll need to wait until there is enough inventory on hand before marking the build as final.
  4. (Optional) Change the build date only if you need to. The ability to complete a build is directly dependent on the quantities of component items available in inventory on the date of the build. Changing the build date could have any of the following effects:
    • Any or all quantity information displayed in the Build Assemblies window could change.
    • Your ability to complete the build could change.
    • The status of other completed builds could change to pending.
  5. (Optional) Enter a memo about this build.
  6. Select Build & Close to finalize this build or Build & New to finalize the build and start a new one.

Here's an article that contains detailed information about inventory assembly items: https://quickbooks.intuit.com/community/Inventory-and-projects/Create-build-and-work-with-inventory-assembly-items/td-p/203722.

 

Also, you may find this article helpful: https://quickbooks.intuit.com/community/Inventory-and-projects/Use-Advanced-Pricing/td-p/203698.

 

If you require more information about inventory items, don't hesitate to drop a reply below.