Skip to content
Restaurant Profit and Loss cover: a sample sheet with net sales, food and drink cost and food cost and a bar chart, beside the Dashboard, Sales and Costs tabs

Restaurant Profit and Loss

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This template is built for restaurant owners and managers who check the numbers every week. The Sales tab records gross sales, discounts and comps for dine-in, takeout, delivery and catering, and calculates net sales. Every bill goes on the Costs tab under a category, including food, beverages, wages, rent, utilities, marketing, repairs and card fees.

The Dashboard shows net sales, food and drink cost, food cost and labor cost as percentages of sales, and profit after costs. Two breakdowns sit beside charts: costs as a share of sales by category, and net sales by channel. The sample weeks run from late October to early November 2026, with made-up figures for a neighborhood restaurant.

Useful for

  • Checking food cost against the weekly target
  • Deciding whether delivery volume is worth its commission
  • Showing staff and owners the labor cost each week

What's included

  • 4 tabs: Dashboard, Sales, Costs, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Sales: a table
  • Costs: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Sales tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What food cost percentage should I aim for?

Many full-service restaurants aim for food cost between about 28 and 35 percent of sales, but the right target depends on your menu, portions and prices. Set your own target from your recipe costs, then use the Dashboard to see whether each week is on track.

Should I record delivery app sales gross or net of commission?

Record them gross, then log the commission as a card fees or marketing cost. That way you can see what each channel really earns. Mixing net and gross figures makes the channel comparison misleading.

Why does profit after costs leave out some expenses?

Only costs entered on the Costs tab are included. Add every expense you pay, including insurance, licenses and loan interest, or the figure will look higher than it is.

  • #profit-and-loss
  • #restaurant-profit-and-loss
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More profit and loss templates

See all 12

Also in Finance

All finance templates
Get this template

Preparing your template…