Restaurant inventory list: free Excel template.
This restaurant inventory list is a free Excel file, no sign-up needed. It contains the inventory list with actual cost of goods, recipe and price costing, and a best- and worst-seller analysis. All sample figures are fictional; replace them with your own.
01 // WHAT'S INSIDE
Three worksheets with formulas.
All figures are fictional and can be overwritten.
- Recipe & Price: ingredient, quantity per portion, purchase unit and net purchase price give you the cost per portion. The sheet also calculates net and gross selling price, cost-of-goods ratio and contribution margin per portion.
- Inventory & Actual COGS: item, storage location, quantity, unit and net cost per unit give you the net closing stock. The period reconciliation calculates opening stock plus purchases minus closing stock as actual cost of goods and sets it against net revenue.
- Menu Engineering: units sold, sales and cost per item give you contribution margin and sales share. The template classifies each dish as a star, plowhorse, puzzle or dog.
02 // HOW TO USE IT
A stocktake in five steps.
- Set the period and location. Opening stock, closing stock and revenue must cover the same period.
- Count by storage location and enter quantity and unit. A case of six bottles is not one bottle, so stick to one unit per item.
- Value the stock at the net cost price per unit.
- In the period reconciliation, enter opening stock, net purchases and revenue.
- Check big deviations first for wrong units, wrong prices, missed storage locations and booking dates.
For the detailed guide, including a list of common mistakes and how often to count each product group, read Restaurant inventory count. The cost of goods calculator gives you the ratio in a few seconds.
03 // LIMITS
Where the template ends.
The template helps with the operational groundwork. Clarify the formal requirements and valuation methods for your accounts with your accountant. The file does not set a tax-compliant stocktake method.
With several locations, coordination takes more work: consistent item names, clear responsibilities and changes anyone can trace, all of which you have to organise yourself. Kiosa Inventory runs stocktakes with direct target/actual reconciliation per location and costs €49 per location per month on top of One View (€99). All modules are under Pricing.
04 // FREQUENTLY ASKED QUESTIONS
Frequently asked questions
The workbook has three sheets: "Recipe & Price", "Inventory & Actual COGS" and "Menu Engineering". On the inventory sheet you enter item, storage location, quantity, unit and net cost per unit and get the net closing stock. A period reconciliation calculates opening stock plus purchases minus closing stock as actual cost of goods.
No. The file is free and you download it without signing up. You work on it locally in Excel or a compatible program.
No. All sample figures are fictional and are only there so you can follow the formulas. Replace them with your own.
No. The template helps with the operational groundwork. Which method and valuation apply to your accounts is something to clarify with your accountant.
With several locations you need shared item names, clear responsibilities and changes anyone can trace. A file won't take care of that on its own. That's where an inventory system such as Kiosa Inventory helps, connecting stocktakes, recipe costs and purchase prices.
Stocktakes without maintaining Excel?
In the demo call we show you what stocktakes and target/actual cost of goods per location look like in Kiosa.
Book a demo call