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

smleick4484 · ‎February 25, 2019

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

MaryGraceS · ‎February 25, 2019

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:

QuickBooks Desktop for Mac 2019 User’s Guide ( CHAPTER 4 Items page 58-68)
Tracking orders for the items you need

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:

Go to https://help.quickbooks.intuit.com/en_US/contact.
At the top right, select your product.
Select your QuickBooks version.
Select a topic.
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

MaryGraceS · ‎February 25, 2019

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:

QuickBooks Desktop for Mac 2019 User’s Guide ( CHAPTER 4 Items page 58-68)
Tracking orders for the items you need

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:

Go to https://help.quickbooks.intuit.com/en_US/contact.
At the top right, select your product.
Select your QuickBooks version.
Select a topic.
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 · ‎March 04, 2019

Thank you!

Anonymous · ‎July 10, 2020

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!

Topics

Training

Community

Resources

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