Free Profit Margin Template

Know where your profits are coming from (and going to) with this free template

Know where your restaurant stands profit-wise in just a glance
Identify areas to improve on to increase your profit margin
Completely customizable to meet your restaurant's needs
Restaurant Profit Margin Calculator TemplateRestaurant Profit Margin Calculator Template
Know where your restaurant stands profit-wise in just a glance
Identify areas to improve on to increase your profit margin
Completely customizable to meet your restaurant's needs

How to use your profit margin template

Keep track of where you are earning and spending money with this free template.
Add in all your total restaurant revenue from all sources.
Add in your total expenses like CoGs, labor and more.
Calculate your profit margin to see where you stand.
Make adjustments to areas to improve your margins.
Example restaurant profit margin calculatorExample restaurant profit margin calculator

What should you include to calculate profit margin?

To calculate your restaurant profit margin, you’ll need the following numbers:

  1. Total revenue, or the total sales of food, beverage, and merchandise
  2. Cost of Goods Sold, or what you pay for food and beverage
  3. Labor costs, for both hourly and salaried employees (including benefits!)
  4. Other expenses, like rent, utilities, maintenance, marketing, and anything else you spend to run your restaurant

What is an average restaurant profit margin?

This varies from restaurant to restaurant, but the average profit margin for a full-service restaurant ranges from 3-5%. For restaurants that are quick service or food trucks, operating costs are lower, leaving profit margins considerably higher, at 6-9%. You should assess your profit margin weekly or monthly to spot trends and make judgements.

How does this free template stack up to 7shifts?

Compare how functionality of this Excel sheet against a robust team management platform like 7shifts.

Profit Margin Calculator

Customizable to your restaurant

Free

Sharable with your team

Easy schedule builder

Free mobile apps

Robust labor, sales, and compliance reports

Communication tools (chat, announcement)

Online manager log book

Labor budgeting tool

Labor compliance tools

Discover more efficiencies to save time and money with 7shifts

That is just one piece of the puzzle

A powerful team management platform like 7shifts is the perfect addition to your tech start. Connecting your schedule to your POS and payroll systems can uncover efficiencies you never even realized.
7shifts integrations for POS, payroll, and more.7shifts integrations for POS, payroll, and more.

Restaurants save
with 7shifts

80 Time saved on scheduling
8080%
Time saved on scheduling
3 Reduced labor costs
33%
Reduced labor costs
70 Reduced calls and texts
7070%
Reduced calls and texts
stats backdrop image

Trusted by over 1 million restaurant pros

Scheduling software for restaurants.Scheduling software for restaurants.

Restaurant Employee Scheduling Software

Learn more
24/7 scheduling.24/7 scheduling.

How to Create a 24 Hour Schedule for Your Restaurant (5 Examples)

Read now
The guide to restaurant costs.The guide to restaurant costs.

The Ultimate Guide to Restaurant Costs

Read now
Chatime and 7shifts case study and success.Chatime and 7shifts case study and success.

How Chatime Canada Conquered Spreadsheet Mountain

Read now

Free Restaurant Management Excel Templates

Welcome to your complete collection of scheduling and restaurant management resources to grow your restaurant

Excel templates made for restaurants. Download all the tools you need to help you save time, money, and streamline your operations.

Template icon

Tip Pooling Template

Download the free excel tip pooling calculator to help determine and distribute tips to your employees using tip pools.

Template icon

Manager Log Book Template

Download the log book template to help managers keep track of what's going on in your business.

Template icon

Restaurant Budget Template

Get the restaurant budget template to determine the budgeting of your restaurant.

Template icon

Restaurant Schedule Template

Get the best restaurant excel-file schedule template to help create your staff work schedules.

Expand your profit margin today!