It's easy to make mistakes from time to time when trying to keep an accurate count of all your liquor inventory. Being able to easily punch in numbers at the end of the day, will make ordering time much less of a hassle. When using a spreadsheet to keep track of all these numbers, you will find out that this is the best way to keep from making too many mistakes. Having a restaurant to run involves wearing a lot of hats, so finding a way to eliminate some of the stress of tracking inventory is much needed. Using a free restaurant liquor inventory spreadsheet to monitor stocked quantities makes ordering time go much smoother. Below, we are going to tell you more about this...
An extremely user friendly site to use for spreadsheets is freerestaurantforms.com. This site has a fantastic selection of spreadsheets and the one for keeping track of liquor stock is very well set up.
The first column has the UPCS number listed, next to this is a column with the brand name of the product listed and these are sorted into different categories; liquor, wine, coolers, beer, draughts, domestic draft beer, and imported draft beer. To the right of this column is a blank one where quantities on hand can be entered, which then totals itself against the individual cost and provides a total for each brand at the far right.
Having an inventory sheet that will automatically total the costs of each product needed makes accounting much easier, as well as being able to follow a budget much closer. The sheet after the list of inventory is called the extension sheet.
This one provides the total cost for each individual category. This free restaurant liquor inventory spreadsheet is an amazingly easy way to keep track of all liquor in stock.
