A guide to doing your own liquor stocktaking.
Your current stock taker will almost certainly be using an excel based stocktaking program to process his stock counts you do not need fancy stocktaking software to do you own stock take an excel based stocktaking worksheet will be more than adequate for your needs. And that's why our stocktaking software is ideal for you. Only £8.99, instant download straight after cleared payment.
The hardest part of performing your own stock take is knowing how to count those part used stock items, the solution is not found in learning the stock takers "skill" of judging the contents by eye but by using weight to achieve a very accurate result. You can buy keg weighing scales costing about £85 plus VAT or sticks that use springs to give the contents of the keg again costing £175 each my solution as regards part kegs is simple; a set of bathroom scales.
Your next problem is that the kegs come in both steel and aluminum containers, with considerable weight differences. The solution is to weigh both types of containers. My stocktaking program has a whole section to help you calculate the contents of part used kegs, bottle and BIB products. Once you have weighed both types of kegs, steel and aluminum when full you have your start weight. No need to worry if you do not have both types in stock at the start of your stock take, you will have plenty of time to have both delivered before you need to perform your closing stock count. You will also need to weigh an empty keg of each type.
Once you weighed your full kegs you will need to weigh one full pint of the product and to do this I suggest you use a set of kitchen scales, place an empty pint glass of the product on the scales and then press zero or tare and replace the empty glass with a full glass of the product. This will give the weight of one pint of the product. I strongly suggest that you use grams as the unit of weight.
Now you can weigh your part used kegs. Uncouple then from the beer lines and place them on the scales, weigh them in Kg then times that weight by 1000 you now have the weight of the part used stock plus the container. Take away the empty weight of an equivalent container and divide to remaining weight by the weight of one pint of the product. This will give you the number of pints remaining in the keg.
Record this count and repeat the process when you wish to perform your closing stock count. I suggest that your perform your stock take counts at the same time as you clean your lines you will be then feeding two birds with one hand.
To see how to count part used bottles and BIB products please use this link
Stocktaking part used bottles and BIB.
My excel based stocktaking software is only £8.99 and is available for instant download straight from this site following cleared payment. Remember excel is probably what your current stock taker is using!