Restaurant Income Statement Template preview

Restaurant Income Statement Template

A restaurant income statement template with food cost, labor, and operating expense line items built in — so you can see your actual margins without building a spreadsheet from scratch.

$29Save 4+ hours vs. building a restaurant income statement from scratch
Secure checkout
|
|
Powered by
Instant download after purchase
Works in Excel & Google Sheets
30-day money-back guarantee
.xlsx230 KB4 sheetsUpdated 2026-03-22

What's Inside This Restaurant Income Statement Template

This template includes 4 worksheets, each designed for a specific part of your restaurant financial workflow:

1

Monthly Income Statement

The core P&L worksheet, structured the way restaurant accountants actually build them.

2

Annual Summary

A 12-month rollup that consolidates your monthly statements into a single view.

3

Key Ratios

A dedicated worksheet that tracks the financial ratios that matter most in food service.

4

Department P&L

An optional breakdown sheet that separates your restaurant's income statement by revenue center — typically dine-in, bar, catering, and delivery.

Restaurant Income Statement Template Features

  • Revenue split by food, beverage, catering, and delivery channel
  • COGS separated into food cost and beverage cost with auto-calculated percentages
  • Labor breakdown by front-of-house, back-of-house, and management
  • Prime cost, EBITDA, and net margin calculated automatically
  • 12-month annual summary with year-to-date running totals
  • Key ratio tracker with industry benchmark ranges built in

How to Use This Restaurant Income Statement Spreadsheet

Start by downloading the .xlsx file and opening it in Excel or Google Sheets — no macros or add-ins needed. Open the Monthly Income Statement sheet and review the pre-loaded categories. Most restaurants will keep the structure as-is: adjust the revenue line items to match your channels (add a line for gift card redemptions, remove catering if it's not applicable), and tweak any operating expense labels that don't match your chart of accounts. This initial setup takes 10–15 minutes and you only do it once.

Each month, enter your actual revenue and expense figures from your POS reports and bank statements. Start with revenue totals at the top, then work down through food cost and beverage cost, then labor by department, then the fixed and semi-fixed expenses at the bottom. The gross profit, prime cost, EBITDA, and net income lines calculate automatically. Once the monthly sheet is complete, the Annual Summary and Key Ratios sheets update without any extra steps.

15 minutes from download to your first income statement

Download the template, enter your revenue and costs, and see your restaurant's actual margins — food cost percentage, prime cost, EBITDA, and net income all calculated automatically.

Secure checkout
|
|
Powered by

Why Every Restaurant Needs a Proper Income Statement

Restaurants operate on margins that leave almost no room for error. Average net margins in food service run 3–9%, which means that a food cost running 3 percentage points above target — $3,000 overspent on a $100,000 revenue month — can cut your net income in half. The income statement is where these numbers show up. Without one, you're flying on gut feel and bank balance, which is why so many restaurants that are busy and full still struggle at the end of the quarter.

A restaurant income statement follows a specific structure that's different from generic business P&Ls. Revenue is split by channel because food, beverage, catering, and delivery have different margin profiles. COGS is split between food cost and beverage cost because they're managed separately — a wine list running at 30% beverage cost is a different problem from proteins running at 38%. Below the gross profit line, labor is the biggest variable expense and needs its own breakdown by department. Prime cost — the sum of food cost and labor as a percentage of revenue — is the single number most operators watch most closely. Industry rule of thumb: prime cost should stay below 65% for full-service restaurants and below 60% for fast-casual.

Restaurant Industry at a Glance

Financial templates built for restaurants — from fast-casual to fine dining. Pre-loaded with food cost categories, labor splits, and industry-standard KPIs.

Revenue Drivers

  • Dine-in sales
  • Takeout & delivery
  • Catering
  • Alcohol sales

Key Cost Categories

  • Food costs (COGS)
  • Labor
  • Rent & occupancy
  • Utilities
  • Marketing
  • Equipment & maintenance

Typical Margins

Gross: 60-70% · Net: 3-9%

Seasonality

Higher revenue in summer and holiday seasons; January-February typically slowest months.

Key Performance Indicators

Food cost percentageLabor cost percentageAverage check sizeTable turnover rateRevenue per seat

Restaurant Income Statement Template FAQ

Restaurant Income Statement Template

$29