If you’re tracking stock levels for your dry goods (e.g., corks, capsules, labels, glass) in vintrace, you can track their cost as well. Including these items on a Bill of Materials (BOM) for a finished wine stock item will cause the dry good cost to transfer to the finished product when the item is bottled in vintrace. This, along with all costs associated with bulk wine, will give you a true Cost of Goods Sold (COGS) for the finished wine.
Dry goods used in bottling will impact the Packaging category for finished products you create.
Average vs. LIFO or FIFO Costing on Dry Good Stock
By default, vintrace assumes the average weighted cost for all dry goods stock items that you track in vintrace. If you want to use the LIFO or FIFO method, you’ll need to have lot/batch tracking enabled on your dry goods inventory items.
Each time you receive inventory, you’ll need to specify a lot/code. The cost of that lot is tracked independently of other lots that you already have in stock. You can achieve LIFO or FIFO costing by selecting the appropriate lot when you deplete these stock levels.
Setting the Default Price for Dry Goods
You can set up your dry goods items from the Winery Setup window (Setup Options > General Stock Items).
To set the default price for dry goods:
- Click Set Up in the sidebar.
- Click Materials.
- Click Configure in the appropriate tile.
- Click the item.
- In the Order Price field, enter the current per unit price from your supplier.
- Click Save.
Capturing Costs When You Receive Dry Goods
If you don’t set up order price and don’t use purchase orders from vintrace, you can still capture the cost when you receive stock. To do this, enter the unit price in the Price field of the Action Receive window.
Refer to our Receiving Stock article to learn more.
Adding Costs After Receiving an Invoice
If you don’t know the cost of an item when you receive it, you can add the cost information at a later time (i.e., when you get the invoice). For example, suppose you used glass in bottling, but didn’t get the invoice for the glass until after the bottling was recorded. You can update the cost and have it ripple forward to the finished bottled product.
To add costs after you've received an invoice:
- Use vintrace’s Quick Search to find the item.
- From the Stock Item Overview window, select the History tab.
- Click View that’s beside the Receive operation. The Action Receive window displays.
- Click Correct.
- Update the price and/or any quantities that you received.
- Enter an explanation in the Reason for Correction field.
- Click Save.
The updated price and/or quantities will ripple forward to any costs that need to be updated.
Adding Additional Costs During Bottling
You can add additional costs such as cellar labor, forklift costs, and third-party bottling charges during bottling. In order to do this, be sure that you’ve set up cost items.
To add additional costs as part of the Packaging (Bottling) operation, click Add Extra Costs.
Please sign in to leave a comment.