Thank you but I don't think that's what I need. Here is more information about this business:
Multiple classes each month
Classes change each month
2 Subscription types, each sub different wine (all 2 bottle subs do not get the same wine in the same month)
Remainder bottles purchased for classes and subscriptions sometimes go into subscriptions or are sold individually
Private tastings, each one different
Classes could be sold before wine is purchased or selected for that class
Sells misc snacks and merchandise but doesn't really keep inventory of that.
Inventories Packaging, but packaging is not used for all orders, some are pick up and some are shipped.
So you can see that it is all very difficult to keep track of inventory with invoices. I tried to use "bundles" for these classes and subscriptions, but that doesn't really work when different wines are used. Here's what I'm proposing:
Use a service item; classes, for what goes on the invoice. have that go into the same class service item as the income account for that class. Then go back and do an inventory adjustment at the end of the month to remove the bottles used for that class. Enter the merchandise used in the classes as COGS. Now, I'm just stuck on what to do with packaging when used. I'm thinking I should put it on the invoice too, with a $0 sales amount (Customers do not see these invoices) so that they are properly removed from inventory, but I want to be sure that even though I put a $0 sales on the invoice, it is moved to COGS at the correct cost.
