cancel
Showing results for 
Search instead for 
Did you mean: 
smleick4484
Level 2

Inventory tracking for items purchased as unit and sold as separate pieces

Am using quickbooks for mac to track inventory. We have an item that we purchase as a unit, which consists of 2 different items that are sold individually.  So, 25 of these units equals 50 items for sale - 25 each of two different items.  How do we track this in inventory?

 

In addition, some of the same two items will be modified (we outsource milling as part of this process) and sold as a new third item.  How do we account for the cost of milling & supplies (stain, hooks, screws, etc) used in this new item? Any help is great

Solved
Best answer February 25, 2019

Best Answers
MaryGraceS
Moderator

Inventory tracking for items purchased as unit and sold as separate pieces

Hello there, @smleick4484.

 

Thank you for posting in the Community. I'd be happy to help share some information about tracking inventory in QuickBooks Desktop for Mac.

 

You can create two items with slightly different names to track the inventory in your account. This way, you'll know how many items you actually have in stock. Additionally, you can consult your accountant about the income account you want QuickBooks to use to track the income you earn from sales of this item.

 

For more information about this, I recommend checking the following articles about inventory:

If you need to reach out for more help, you can also contact our Customer Care support. They have the tools to guide you through the steps and help you get back to business in no time.

 

Here's how: 

  1. Go to https://help.quickbooks.intuit.com/en_US/contact.
  2. At the top right, select your product.
  3. Select your QuickBooks version.
  4. Select a topic.
  5. Click on the Get Phone Number button. 

These resources should help to get you on the right track. I'm just a post away if you should have any other questions about tracking inventory in QuickBooks. Have a great rest of your week.

View solution in original post

3 Comments 3
MaryGraceS
Moderator

Inventory tracking for items purchased as unit and sold as separate pieces

Hello there, @smleick4484.

 

Thank you for posting in the Community. I'd be happy to help share some information about tracking inventory in QuickBooks Desktop for Mac.

 

You can create two items with slightly different names to track the inventory in your account. This way, you'll know how many items you actually have in stock. Additionally, you can consult your accountant about the income account you want QuickBooks to use to track the income you earn from sales of this item.

 

For more information about this, I recommend checking the following articles about inventory:

If you need to reach out for more help, you can also contact our Customer Care support. They have the tools to guide you through the steps and help you get back to business in no time.

 

Here's how: 

  1. Go to https://help.quickbooks.intuit.com/en_US/contact.
  2. At the top right, select your product.
  3. Select your QuickBooks version.
  4. Select a topic.
  5. Click on the Get Phone Number button. 

These resources should help to get you on the right track. I'm just a post away if you should have any other questions about tracking inventory in QuickBooks. Have a great rest of your week.

smleick4484
Level 2

Inventory tracking for items purchased as unit and sold as separate pieces

Thank you!

Anonymous
Not applicable

Inventory tracking for items purchased as unit and sold as separate pieces

Hi there!

 

@smleick4484 thanks for posting this question and @MaryGraceS thanks for sharing information on this topic. I have a similar issue with some of my items. I get why you said:


You can create two items with slightly different names to track the inventory in your account.

My only question here is, how does QB track inventory / the QOH for the items I purchased originally? I need inventory to be adjusted automatically when items sold in separate pieces equal one unit. I hope I'm making sense to you.

 

Here's my situation:

I purchase 25kg pails of chlorine tablets (125 tablets each). At some point I started selling 2kg and 4 kg buckets which I was thinking of setting up as non-inventory parts. When the amount of buckets / tablets sold equal 25kg, I need inventory to be reduced by 1 X 25kg pail automatically since that is an inventory part.

 

I'd appreciate all help!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us