Restaurant Profit and Loss Spreadsheet

Restaurant Profit & Loss Spreadsheet (Monthly P&L)

The Restaurant Profit & Loss Spreadsheet is a monthly financial tool designed to help restaurant owners and managers track revenue, expenses, food cost, labor cost, and overall profitability. A P&L (Profit and Loss Statement) is one of the most important financial documents in the restaurant industry — it shows exactly how much money your restaurant is making or losing.

What Is a Restaurant Profit & Loss Spreadsheet?

A profit and loss statement summarizes:

• Total revenue
• Cost of goods sold (COGS)
• Operating expenses
• Labor costs
• Net profit or loss

Restaurants typically review P&L statements monthly, but weekly numbers play a critical role in controlling food and labor costs before they spiral out of control.

Why Weekly Numbers Matter

Food cost should be monitored weekly, not monthly. Here’s why:

• Weekly inventory helps you identify missing products quickly
• You can correct issues before they become expensive
• Monthly reviews are too late — losses compound over time
• Weekly tracking reveals trends, theft, waste, and ordering mistakes

The longer you wait to review food cost, the more money you lose. Weekly numbers give you the power to react immediately.

How the Restaurant Profit & Loss Spreadsheet Works

The spreadsheet is designed for accuracy and ease of use:

• Colored cells are protected — these contain formulas and should not be edited
• White cells are open for data entry — enter your revenue, expenses, and inventory numbers

Once your information is entered, the spreadsheet automatically calculates:

• Food cost percentage
• Labor cost percentage
• Prime cost
• Net profit or loss
• Key financial indicators

This spreadsheet becomes your restaurant’s financial report card, helping you pinpoint issues and correct them quickly.

Understanding Prime Cost

Prime cost = Cost of Sales (Food + Beverage) + Total Payroll

Payroll includes:

• Hourly wages
• Management salaries
• Payroll taxes
• Benefits
• Workers’ compensation

Prime cost benchmarks:

• Full‑service restaurants: 60%–65% of total sales
• Quick‑service restaurants: 55%–60% of total sales

Prime cost is the most important number in restaurant financial management. Monitoring it consistently is essential for long‑term success.

Why Food and Labor Costs Matter Most

Food and labor are the two largest expenses in any restaurant. Together, they should total:

• 60%–65% for full‑service restaurants
• 55%–60% for fast‑food or quick‑service restaurants

If these numbers climb higher, profitability drops fast. The Restaurant Profit & Loss Spreadsheet helps you stay on track and make informed decisions.