I will build a restaurant stock control and recipe costing system in excel
Inventory, Stock control systems on Excel, Google Sheets, Power BI
Sobre este Serviço
Running a restaurant or café and not sure where your stock and money are going? I'll build you a simple stock and recipe costing system in Excel or Google Sheets that shows what you're using, what you should be using, and where the gaps are.
I manage inventory reporting for a UK restaurant franchise and have 5+ years in supply chain and inventory, so this is built from real kitchen operations, not a generic template.
What you get:
- Stock count sheet for your products and suppliers
- Recipe costing with cost per dish and gross margin
- Usage vs sales variance to spot waste and losses
- Weekly summary dashboard
- Operations manual so your team can run it (Premium)
- Optional phone stock-take form for your staff
Perfect for restaurants, cafés, takeaways, juice bars, and small food businesses.
Message me before ordering with your number of menu items and how you count stock today, and I'll recommend the right package.
Perguntas frequentes
Do I need Excel, or can I use Google Sheets?
Either works. I can build your system in Excel or Google Sheets, whichever your team already uses.
I'm not good with spreadsheets. Will I be able to use it?
Yes. Everything is built to be simple, with clear input areas and formulas that do the work for you. The Premium package also includes an operations manual your team can follow.
What do I need to provide?
A list of your stock items and suppliers with prices, your menu recipes with ingredient quantities, and any sheets you currently use. Don't worry if it's messy. I'll organize it.
Does it work for businesses other than restaurants?
Yes. It suits cafés, takeaways, juice bars, bakeries, and other small food businesses. Message me if you're unsure and I'll confirm before you order.
Can my staff do stock counts on their phones?
Yes. Add the "Stock-take form" extra and I'll build a Google Form your staff fill in on their phones that feeds straight into your stock sheet.

