Free bakery inventory template with recipe costing
An 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.
- No card needed
- iPhone, Android and web
- In 20 languages
Products and ingredients
Croissants and loaves by the piece, flour, butter and sugar by the kilo, each with its stock and alert level.
What one costs to make
The recipe sheet adds up a batch's ingredients at their cost and divides by what the batch makes. Change a price and the cost updates.
Ready for Binhop
Import the first sheet as it is. Then add what each product is made from, and Make takes the ingredients out of stock as it adds the product.
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.
- 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.
- Bar templateAn 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.
- 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 I record expiry dates for ingredients?
Yes. Track an ingredient by lot, each with its expiry date, and when you make something Binhop uses the lots that expire first.
What if I'm short of an ingredient?
Binhop never makes more than the ingredients in stock allow, and tells you which one runs out first.
