cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Tracking raw material used in service

I work for a small landscaping company and currently using QuickBooks Desktop - Premier Plus Contractor Edition.  We have bulk raw materials delivered to the shop (mulch, stone, sand, etc) which is then applied to jobs at a later date.  In the winter we have rock salt that gets applied to sites as needed.  For job costing, I have to apply the material, such as:  4 yards of mulch to grounds maintenance job A, or 3 tons of cobble to construction job B, or 40 tons of salt over 20 job sites per storm. 

 

My question is do I set up raw materials as Inventory items or Non-Inventory items?   For all of these jobs we do not sell the item individually, but as a component part of the overall contract.  Which sounds like Non-Inventory part but I'd like to track the quantity so that is only available with Inventory part.  Currently I put all the deliveries into a Shop Inventory account and create a monthly journal entry to COGS job materials (per division) with the customer/job. This is time consuming and requires a lot of rework to find the current quantity balance and cost of each aggregate.  Hoping there is a better/faster way but that records the costs appropriately as well.  

 

2 Comments
Highlighted
QuickBooks Team

Tracking raw material used in service

Thanks for sharing the details with me, @Peak Environmental.

 

Allow me to provide some information on how to achieve this. You’ll want to set up your raw materials as Inventory parts.

 

That way, the Cost of Goods Sold will be calculated when the item is assigned to a job. That being said, here’s how to set up an inventory item in your QuickBooks Desktop (QBDT) software:

 

  1. Go to the Lists menu.
  2. Select Item List 
  3. Click the Item drop-down and select New.
  4. Select the type of item.
  5. Fill out the item fields.
  6. Then click Save when done.

You can also utilize this article for more details (select the Create an item section): Add, edit, and delete items.

 

I’d also recommend checking with your account for guidance if you’re unsure of what income account to choose in setting up your inventory item. This way, we’ll ensure the accuracy of your accounts.

 

Additionally, I'm adding these resource that you can use as reference in case you have other inventories stored at different sites or locations and want to track them: Set up Advanced Inventory.

 

Let me know if there’s anything else I can help you with about managing your inventory items. I'll be around ready to assist you. Have a great day ahead!

Highlighted
Level 14

Tracking raw material used in service

@Peak Environmental 

Consider having a construction management app to manage your inventories. 

Need to get in touch?

Contact us