@ArtanisHome
There's a lot to unpack here.
When you set up each bottle and pump as an inventory product, you need to fill in the initial quantity that is accurate on the "As of date" you input into QB. In the "Cost" field, you will need to enter the average cost of that item in stock. So, in your example, you will calculate the average cost of 3,000 @ $0.25, 4,000 @ $0.24 and 3,000 @ $0.26. (3,000 X .25) + (4,000 X .24) + (3,000 X .26) / 10,000 = $0.249. That will set your initial inventory value for that pump at $2,490. When you buy that pump in the future, the cost will be updated automatically based on the price you enter on the vendor bill. So, if the next time you purchase them, the cost has increased to $0.27, QB will adjust the cost and you will have an accurate valuation for that pump at all times. Under "Sales price/rate", you want to enter the price that you charge for that bottle or pump if sold separately. Do the same process for each bottle and pump you want to set up.
You should not be recording the cost of bottles and pumps purchased to COGS. When you purchase bottles and pumps in the future, they should be placed into inventory (this happens automatically when they are entered from a vendor bill) and expensed to COGS when sold to your customer (this happens automatically when sold on a sales receipt/invoice). Inventory is not an expense to a business until you sell it to your customer. Therefore, make sure you have COGS selected as your expense account under "Purchasing Information" when you set up each inventory product.
At this point, you have every bottle and pump entered into inventory. Now, you will need to set up a product bundle to sell a bottle and pump together. To do that, select the Bundle option and name it what you want. Under "Product/Service", you will need to select both a bottle and pump to create the bundle. However, QBO does not allow you to price the bundle separately from the sum of the costs of the individual products in the bundle. Presumably, your dispensers are less expensive than if you added the price of the bottle and pump together. If that's the case, a good workaround it to create a service item called "Bundle Discount" or something similar and add it to each bundle. When you set up the Bundle Discount, you will have to price it at a negative amount equal to the difference between the retail price of a dispenser and the pump and bottle separately. Lastly, when setting up the product bundle, make sure the box next to "Display bundle components when printing or sending transactions" is not checked. If it's checked, your customer will see the details of the bundle.
You should not have to make any inventory quantity adjustments until you find discrepancies during physical inventory checks in the future.
