cancel
Showing results for 
Search instead for 
Did you mean: 
CT-TX
Level 1

Labor in inventory assemblies

I am setting up inventory item codes and assemblies for a new client who makes tree syrups.  I've decided that in order to capture all the costs related to harvesting the raw material (ie syrup), I'll create a GL account called WIP then move the balance to the raw material item code once I know the total amount (gallons) harvested.  Only then will I be able to calculate a unit cost for my raw material.

 

My problem is how to account for labor costs that go into assemblies.  I now want to create a build for a bottle we sell.  So I need an assembly with x amount of raw material, a bottle, a cap, a label (all easy to identify and cost) as well as labor to make this assembly.  I don't know what the labor historically costs per item so I'm not sure how to add it or IF I can add it.  Suggestions for how to make this work are appreciated.  COGS will not be correct unless I can add labor to the products. 

8 Comments 8
Fiat Lux - ASIA
Level 15

Labor in inventory assemblies

Are you using QB Online or QB Desktop (i.e Premier/Enterprise)?

CT-TX
Level 1

Labor in inventory assemblies

QB Desktop Enterprise

Liftco
Level 3

Labor in inventory assemblies

I have same question, need to add a line in assembly for labor

Tori B
QuickBooks Team

Labor in inventory assemblies

Hey there, @Liftco

 

Thanks for following the thread and sharing your concerns.

 

A part of using an assembly item is what it is made of. We like to refer to this as bill of materials. Within the bill of materials, there are components. You'll want to focus on the components in order to add the labor cost. Once your settings are in order, you'll set up all the parts you use to build your product. 

 

The types of components:

 

You will need to use a service item for this component. A service item is used for a service you provide to a customer. You can create services that are charged by the job or by the hour. I've included some steps to add a service item below. 

 

  1. Go to Lists,  then select Item List.
  2. On the Item List window, choose Item then New.
  3. Click on Service Item as the type. 
  4. Key in the name (such as Labor for job 23).
  5. Be sure to check off the This service is used in assemblies or is performed by a subcontractor or partner box. 
  6. Add your rate and the account. 

 

Once you've added your new service item, it's time to include it in your assembly. Or you can just add an extra line to your invoice. Let me walk you through the steps. 

 

  1. Open your assembly item by right-clicking it and choose Edit
  2. In the edit screen under the Bill of Materials section, add your new labor service item and hit OK to save. 

 

That's all there is to it. I've included some great help articles below that will be resourceful in learning the process. 

 

 

I hope that this information helps you out. Please let me know if you have further questions or concerns. I'm always around to lend a hand. Take care! 

Liftco
Level 3

Labor in inventory assemblies

Thanks Tori B, 

 

I followed you instructions (see attached) just wondering why the "Sell Price" didn't change

JessT
Moderator

Labor in inventory assemblies

Hi Liftco,

 

Thanks for the update. Let me help you with the difference in the sales price.

 

You can run the Verify and Rebuild data utilities. These will check for data issues and fix them. We run these tools when figures on prices and or reports are not syncing within the different sections in QuickBooks.

 

If the sales price of the assembly doesn't change to 3,511.06, please contact our QuickBooks Support to check this further using more tools.

 

I'm just right here if you have any other questions regarding QuickBooks. Take care.

cloughhead
Level 1

Labor in inventory assemblies

I'm curious what account did you use for the labor part number? 

SelectBuilder72
Level 1

Labor in inventory assemblies

Hi:

 

I have quickbooks premier contractor 2020 desktop.

i am a contractor and we are finishing basements.

I would like to use timesheets to record my workers time on each task and then record their labor cost as an inventory assembly.  At the end of the job, then we will record cost of sales vs job sales price.

Am i using the correct version of quickbooks?  Also how do i set this up?

Need to get in touch?

Contact us