Investor reporting for restaurants: Excel template with prior year.
This Excel template for restaurant investor reporting shows net revenue, cost of goods and labor costs per location and month, against prior year. The file calculates cost-of-goods ratio, labor cost ratio, prime cost and an optional EBITDA before rent with formulas. All sample figures are fictional. Free, no sign-up.
01 // WHAT'S INSIDE
Three sheets: Instructions, Metrics, Summary.
All figures are fictional. Input cells are blue, formulas shaded grey.
- Instructions: purpose, metric definitions and notes on the template's limits.
- Metrics: one row per location and month. You enter net revenue, cost of goods and labor costs, the same figures for the prior year and, optionally, other operating costs excluding rent. The file calculates cost-of-goods ratio, labor cost ratio, prime cost ratio, EBITDA before rent, the change in revenue against prior year and the change in the ratios in percentage points.
- Summary: totals per location and across all locations, with ratios calculated as sum over sum, and a prior-year comparison over the months that have figures in both years.
02 // METRICS
How the template calculates.
| Metric | Formula | Note |
|---|---|---|
| Cost-of-goods ratio | Cost of goods ÷ net revenue | More in the glossary: Cost-of-goods ratio |
| Labor cost ratio | Labor costs ÷ net revenue | See Labor cost ratio in restaurants |
| Prime cost ratio | (Cost of goods + labor costs) ÷ net revenue | See Prime cost in restaurants |
| EBITDA before rent (optional) | Net revenue − cost of goods − labor costs − other operating costs excluding rent | A simplified operating figure, not EBITDA as in the annual accounts |
| Prior-year comparison | Revenue ÷ prior-year revenue − 1, ratios as difference in percentage points | Same month of the prior year |
03 // HOW TO USE IT
Your report in four steps.
- Replace the location names in the sample rows and on the Summary sheet. They must be spelled exactly the same on both sheets.
- Enter the figures per location and month from your accounting or the monthly management accounts (BWA), all amounts net.
- Enter the prior-year values for the same month.
- Read off ratios and the prior-year comparison per location and across all locations on the Summary sheet.
Background on the metrics: Restaurant metrics and managing multiple locations.
04 // LIMITS
What the template is not.
The template does not replace monthly management accounts (BWA) or annual accounts. The figures come from your accounting; clarify cut-offs and valuations with your accountant. Which metrics, periods and formats an investor or bank expects is something to agree with them.
With many locations, pulling it together every month gets laborious. Kiosa One View shows revenue, cost of goods and labor costs per location, updated daily, against plan and prior year, and costs €99 per location per month. All modules are under Pricing, and if you run several locations, see the solution for restaurant groups.
05 // FREQUENTLY ASKED QUESTIONS
Frequently asked questions
The template shows net revenue, cost of goods and labor costs per location and month, and from them the cost-of-goods ratio, labor cost ratio and prime cost, each against prior year. You can add an EBITDA before rent. Which other metrics your investor needs is something to agree with them.
Cost-of-goods ratio is cost of goods divided by net revenue, labor cost ratio is labor costs divided by net revenue, and prime cost is the sum of both divided by net revenue. For several locations, the Summary sheet works with totals, not with the average of the location ratios.
No. All locations and figures are fictional examples. Replace them with your own figures from your accounting or the BWA.
No. It is a simplified operating figure: net revenue minus cost of goods, labor costs and other operating costs excluding rent. The column stays empty until you enter other operating costs. For reports to third parties, clarify cut-offs with your accountant.
When you have many locations and have to pull numbers together from several sources every month. One View shows revenue, cost of goods and labor costs per location, updated daily, against plan and prior year, without you having to merge the data yourself.
Numbers without manual work?
In the demo call we show you One View with all your locations at a glance.
Book a demo call