Free bar inventory template
An Excel template for bars and cafés: bottles, kegs, mixers and fresh fruit, each with an alert level so you reorder before the weekend. Import it into Binhop when you're ready.
- No card needed
- iPhone, Android and web
- In 20 languages
Bottles, kegs and mixers
Spirits and wine by the bottle, tonic by the box, kegs by the piece and lemons by the kilo.
Order before you run out
Each row's alert level is the stock you reorder at. In Binhop, your phone tells you when an item gets there.
Ready for Binhop
Import the file as it is. Then count the bottles at closing time by scanning them, and note why stock went missing.
Templates for each kind of business
- Free spreadsheet templateDownload a free Excel inventory template with the columns small businesses need. Fill it in, and import it into Binhop when you outgrow it.
- Phone shop templateAn Excel template for phone shops: phones and accessories on one sheet, each phone's IMEI on another. Import it into Binhop when you're ready.
- Car parts templateAn Excel template for car parts shops and garages: part numbers, barcodes, packs and litres, with an alert level for each part. Import it into Binhop when you're ready.
- Bakery templateAn Excel template for bakeries: what you sell and the ingredients it's made from, plus a sheet that works out what one croissant costs to make. Import it into Binhop when you're ready.
- Clothing store templateAn Excel template for clothing shops: one row for each size and colour, with its own code, barcode and stock. Import it into Binhop when you're ready.
- Hardware store templateAn Excel template for hardware stores and building supplies: screws by the box, cable and pipe by the metre, each with its own code and alert level. Import it into Binhop when you're ready.
Terms used here
Questions
Can staff count stock without seeing prices?
Yes. Staff can count, sell and receive stock but don't see prices or costs. Invite them with a link; teams are free.
How do I record a broken bottle?
Take it out of stock and say why: damaged, lost or stolen, expired, own use or other. Reports add up what was lost by cause.
