.jpg)
Running a restaurant is a very time-consuming occupation. There is so much that you have to keep up with, especially when it comes to inventory. The more help you can get with this process, the less stressful it will be. If you are in charge of a restaurant that has a bar in it or serves liquor, keeping the right count of all your inventory can be quite the task. Using a spreadsheet for this type of inventory is a great way to have a visual aid of all that you have in stock or need. Better yet, finding a free restaurant liquor inventory spreadsheet online will save you a lot of the time and effort that is involved with creating one from scratch.
There are many different online sites that provide spreadsheets, but one of the easiest sites to use is freerestaurantforms.com. The liquor inventory spreadsheet offered on this site is very set up very well and lists the most common liquors, wines, wine coolers, beers, draughts, domestic and imported draft beers by name.
A column with the UPCS for each item is positioned right in front of the column with the brand names. Blanks are located in the column to the right of the brand names, in order to provide a place for quantities on hand to be written down. To the right of the column, the price of each type of product is noted. All of this is the main inventory count sheet.
On the next sheet provided is the extension sheet. This is a quick display of all the totals in each section from the front. Since this is a spreadsheet, quantities and prices are added automatically as numbers are punched in.
For instance, when the separate quantities are inserted next to various brands in the wine section, then total costs for each brand are displayed on the inventory page, while a total for the entire wine section is provided on the extension sheet. There's never been a quicker way to tally up a more accurate number of quantities and price totals, than with this free restaurant liquor inventory spreadsheet.
