Three years of P&L data reveals patterns that single-year snapshots miss completely. Most restaurant owners focus on monthly numbers, but gradual shifts in food costs or labor efficiency only become visible across multiple years. You'll catch profit-eating trends before they become disasters.
Why three years beats one-year analysis
Restaurant finances swing with seasons, unexpected repairs, and market changes. A single year can mislead you completely. Three years exposes the real direction your business is heading:
- Are ingredient costs outpacing your menu price increases?
- Is staff productivity declining year over year?
- Is revenue per square foot dropping despite steady traffic?
- Are overhead expenses consuming larger profit slices?
⚠️ Heads up:
Compare identical periods only. March 2022 against March 2023 and March 2024. Never mix seasons — December and June operate under completely different conditions.
Critical metrics to monitor
Food cost percentage annually: This number should hold steady or drop through smarter purchasing. Rising percentages mean suppliers increase prices faster than you adjust yours.
💡 Example food cost progression:
- 2022: 31% food cost
- 2023: 33% food cost
- 2024: 35% food cost
Warning: Menu prices lag behind ingredient costs. Time to adjust.
Labor cost percentage: Count wages, taxes, and temporary help. Steady increases signal either rising wages or declining efficiency — both need attention.
Revenue per square foot: Annual revenue divided by dining area. Falling numbers suggest you're not maximizing space potential.
Calculating percentage trends properly
Convert every expense category into revenue percentages:
Expense % = (Category Cost ÷ Total Revenue) × 100
💡 Example labor cost analysis:
- 2022: €180,000 payroll on €600,000 sales = 30%
- 2023: €210,000 payroll on €650,000 sales = 32%
- 2024: €245,000 payroll on €680,000 sales = 36%
Pattern: Payroll growth exceeds revenue growth. Address immediately.
Danger signals and positive indicators
Troubling patterns (require action):
- Food costs climb 1-2 percentage points annually
- Payroll expenses outgrow revenue consistently
- Fixed expenses (rent, insurance) claim bigger revenue shares
- Net profit margins shrink each year
Encouraging patterns (maintain course):
- Sales growth outpaces expense increases
- Food costs stabilize through negotiation and efficiency
- Higher revenue per square foot annually
- Profit margins expand or hold steady
💡 Example of healthy progression:
- 2022: 31% food cost, 30% labor, 8% profit
- 2023: 30% food cost, 29% labor, 10% profit
- 2024: 29% food cost, 28% labor, 12% profit
Efficiency improves annually. Excellent management!
Responding to negative trends
Rising food costs demand immediate menu price adjustments or ingredient substitutions. Don't let supplier increases erode margins silently.
Escalating labor costs need scheduling reviews and productivity analysis. You might be overstaffed during slower periods — the kind of thing you only learn after closing your first month at a loss.
Declining profits signal structural issues. Expenses are outrunning revenue growth, and quick intervention prevents deeper problems.
Analysis tools and tracking systems
Spreadsheets work but require manual data entry and calculations. Tools like KitchenNmbrs automate number collection and generate trend reports without additional math work.
Consistency matters most. Record identical metrics monthly so three years of data reveals clear patterns and actionable insights.
How to create a 3-year P&L trend analysis?
Gather three years of P&L data
Get your profit and loss statements from the past three years. Make sure you're comparing the same periods: January-December of each year. Don't have a complete P&L? Use your VAT filings and bank statements.
Calculate percentages for each cost item
For each cost item (food, labor, rent, utilities) calculate it as a percentage of your total revenue. Formula: (Costs ÷ Revenue) × 100. This makes the years comparable, even if your revenue has grown.
Look for patterns and trends
Put the percentages in a table by year. Which percentages are consistently rising? Which are falling? A rise of 1-2 percentage points per year in food cost is a warning sign. Same with labor.
✨ Pro tip
Track your 3 largest expense categories first: food, labor, and rent over 36 months minimum. These typically represent 70-80% of total costs, so controlling their percentage trends solves most profitability issues.
Calculate this yourself?
In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.
Was this article helpful?
Frequently asked questions
How often should I do a trend analysis?
Annual reviews capture the big picture effectively. But monitor key percentages monthly — food cost and labor especially — so you can make mid-course corrections.
What if I don't have three years of data?
Work with whatever you have. Two years still provides valuable insights. Start consistent tracking now to build a stronger database for future analysis.
Which trend poses the biggest threat?
Food costs rising while menu prices stay flat. This directly destroys profit margins. Labor costs matter too, but menu adjustments can address food cost issues faster.
Should inflation factor into these comparisons?
Not when using percentages. Percentage analysis automatically accounts for overall growth. If food costs jump from 30% to 33%, your ingredients are outpacing revenue regardless of inflation rates.
📚 Sources consulted
- EU Verordening 852/2004 — Levensmiddelenhygiëne (2004) — Official source
- EU Verordening 853/2004 — Hygiënevoorschriften voor levensmiddelen van dierlijke oorsprong (2004) — Official source
- EU Verordening 1169/2011 — Voedselinformatie aan consumenten (2011) — Official source
- NVWA — Hygiënecode voor de horeca (2024) — Official source
- NVWA — Allergenen in voedsel (2024) — Official source
- Codex Alimentarius — International Food Standards (2024) — Official source
- FSA — Safer food, better business (HACCP) (2024) — Official source
- BVL — Lebensmittelhygiene (HACCP) (2024) — Official source
- Warenwetbesluit Bereiding en behandeling van levensmiddelen (2024) — Official source
- WHO — Foodborne diseases estimates (2024) — Official source
Food Standards Agency (FSA) — https://www.food.gov.uk
The HACCP standards shown in this application are for informational purposes only. KitchenNmbrs does not guarantee that displayed values are current or complete. Always consult the FSA or your local authority for the latest regulations.
Written by
Jeffrey Smit
Founder & CEO of KitchenNmbrs
Jeffrey Smit built KitchenNmbrs from 8 years of hands-on experience as kitchen manager at 1NUL8 Group in Rotterdam. His mission: give every restaurant owner control over food cost.
Calculate your break-even point in seconds
Food cost is just one part of the story. KitchenNmbrs also helps you structure labor costs and other expenses for a complete break-even overview. Start free.
Start free trial →