Excel SpreadsheetGlobalGrowing

Restaurant P&L Statement Template

4.9rating

1,547 downloads

30 min setup

About This Resource

Most restaurant owners know their revenue but can't tell you their actual profit margin, prime cost ratio, or break-even point. This P&L template is built specifically for restaurants — not adapted from a generic business template. It separates food costs from beverage costs (they have different target margins), breaks labor into FOH and BOH, tracks controllable vs. non-controllable expenses, and calculates your prime cost (food + labor) automatically. The break-even tab shows exactly how many covers or how much revenue you need daily to cover your fixed costs. Color-coded cells turn red when any line item exceeds industry benchmarks.

What's Included

Food cost % tracker

Labor cost breakdown (FOH/BOH)

Prime cost calculator

Break-even analysis tab

Industry benchmark comparisons

Monthly and annual views

Who Is This For?

Restaurant owners and GMs who want financial clarity. Whether you're a new owner who's never built a P&L or a veteran who's been using a napkin, this template gives you the numbers that matter.

Quick Start Guide

1Enter your monthly revenue figures (dine-in, delivery, catering separately)
2Input your costs — the template guides you through every restaurant-specific line item
3Review the auto-calculated ratios and compare against industry benchmarks
4Use the break-even tab to set daily revenue targets for your team

The Resource

Restaurant P&L Structure

Line Item	Target %	What It Includes
Revenue	100%	Dine-in + delivery + catering + merchandise + any other income
Cost of Goods Sold (COGS)	28-35%	Food cost + beverage cost (all ingredients and supplies that go into menu items)
GROSS PROFIT	65-72%	Revenue − COGS
Labor	25-35%	Wages, salaries, payroll taxes, benefits, workers comp, management
PRIME COST	55-65%	COGS + Labor (your most critical number)
Occupancy	6-10%	Rent, property tax, insurance, CAM charges
Operating expenses	10-15%	Utilities, repairs, supplies, marketing, technology, pest control, waste removal
General & admin	3-6%	Accounting, legal, permits, licenses, office supplies, bank fees
NET PROFIT	5-15%	What's left after all expenses — this is your actual earnings

How to Use This Template

1Enter all revenue sources on separate lines — break out food, beverage, delivery, catering, and other income
2Enter COGS: do a beginning + purchases − ending inventory calculation monthly (don't just use purchase totals)
3Enter all labor costs including taxes and benefits — not just hourly wages, but TOTAL cost of employment
4Fill in operating expenses using your bank statements and invoices — categorize each expense correctly
5Review the auto-calculated percentages: if any line item is above the target range, investigate immediately
6Compare month-over-month: are costs trending up while revenue is flat? That's the early warning sign

Key Ratios to Watch

Prime cost (COGS + labor) above 65% means you're not making enough to cover occupancy and operating costs. This is an emergency. Food cost above 35% means your pricing is too low, portions are too big, waste is too high, or theft is occurring. Labor above 35% means you're overstaffed for your volume, paying above market, or not managing overtime. Net profit below 5% means the business is fragile — one bad month could put you in the red. Healthy restaurants target 10-15%.

Frequently Asked Questions

Yes, significantly. Generic P&L templates don't separate food from beverage costs, don't calculate prime cost (the most important restaurant metric), and don't include break-even analysis. This is built by restaurant operators for restaurant operators.

The template uses USD by default, but you can change the currency symbol in the settings tab. All calculations are currency-agnostic — they work with any currency.

Monthly at minimum. Top-performing restaurants update weekly to catch food cost or labor creep early. The template supports both cadences.