Bar Inventory Spreadsheet, Fridge Par Levels & Stock Count Excel Template | Bar Stock Control + Fill List, HTML Tool Works Offline

Seller's description

STOP GUESSING WHAT TO PUT BACK IN THE FRIDGES.

Count what is left in each fridge at the end of the night. The spreadsheet tells you exactly how many to put back to reach par, takes it off your storeroom, and flags anything that does not add up.

Built by a hotel assistant manager who counts bar stock for a living. It works for bars, pubs, restaurants, hotel bars, cafes, clubs and event bars.


WHAT YOU GET (2 files)
1. The Excel workbook: Bar Stock & Fridge Par System (main product)
2. BONUS: a single-file HTML version that opens in any web browser. No install, no internet needed. It has a button to add as many fridges as you like.


HOW IT WORKS
- Set up your fridges and products once, with the par level (how many each fridge holds when full).
- Each night, type what is left in each fridge.
- The fill list tells you what to take from the storeroom, per fridge.
- At the end of the week, count the storeroom. The sheet compares it with what it expected and flags what is MISSING or EXTRA, with the £ value.
- An order list builds itself in whole cases, with the cost, once stock is at or below your reorder point.


INSIDE THE EXCEL WORKBOOK
- Start Here: simple instructions and a colour key
- Setup: venue name, week date, and your fridge names
- Products: up to 60 products with category, supplier, case size, cost, par for each fridge, normal daily use, reorder point and order-up-to level
- Mon to Sun day tabs: nightly count, fill list, deliveries, waste, storeroom running total
- Print Fill List: pick a day and print a clean list of only what needs filling
- Weekly Stock: expected vs counted storeroom, missing stock value, usage, days of stock left
- Order List: what to order, by case, with estimated cost


UP TO 10 FRIDGES, SWITCHED ON BY TYPING A NAME
Got more than one fridge? Type a name in the next empty slot on the Setup tab and that fridge appears on every tab. Back bar fridge, bottle cooler, wine cooler, terrace chiller: anything cold that you count.
(Need more than 10? The bonus HTML version has no limit.)


STATUS FLAGS THAT TELL YOU WHAT NEEDS ATTENTION
FILL: top up from the storeroom
OK: fridge is at par
ORDER: storeroom is at or below the reorder point
SHORT STOCK: the storeroom cannot fill the fridges back to par
CHECK COUNT: a count is higher than par, so recount
HIGH USE: much higher than normal use today
NOT COUNTED: a fridge has not been counted yet


THE BONUS HTML TOOL
- Opens by double-clicking the file. Works offline on a computer, tablet or phone.
- Count fridge by fridge, with a fullness bar and the number to put back
- Add, rename, reorder and remove fridges yourself, no limit
- Printable fill list, weekly stock check and order list (with CSV download)
- "Close week" button rolls your counted storeroom into next week's opening stock
- Back up and restore with a small file
Your figures are saved in the browser on the device you use, so use the Back up button now and then.


EXAMPLE DATA INCLUDED
24 sample products and 4 sample fridges are included so you can see how it works. Replace them with your own.


GOOD TO KNOW
- Please open the Excel file in Microsoft Excel (2007 or newer) for the best result. Google Sheets and Numbers can open it, but some colour highlighting may not carry over.
- "Used" figures are estimates (put in fridges minus waste). The workbook is not linked to your tills.
- Starting a new week in the Excel version is a manual copy-and-paste. The steps are on the Start Here tab. The HTML bonus does it with one button.
- This is a digital download. Nothing will be posted to you. You will receive the files straight after purchase.
- Colours and layout can be edited to suit your own venue. Personal and business use for your own venue is fine. Please do not resell or share the files.


QUESTIONS
Not sure it will suit your venue? Message me before buying and I will help.