Skip to content
Restaurant Food Inventory cover: a sample sheet with items on the list, items to order and stock value on hand and a bar chart, beside the Dashboard tab

Restaurant Food Inventory

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 for a restaurant or café kitchen that counts food and drink every week. On the Stock tab every item appears with a food group, unit, par level, count on hand, unit cost and last counted date. The To order column shows how much to buy to get back to par, and the value on hand adds up what the walk-in and dry store hold. The Waste tab records each item thrown away, its reason and its cost, which uses the unit cost from the Stock tab.

Set the par level as the amount you want on hand before the next delivery, based on how fast the item sells. Count on a fixed weekday, type the number into On hand and the order column calculates what to buy. Rows turn red when stock falls below par. Log waste the day it happens so the monthly cost is right. Keep item names matching the Stock tab exactly, or the cost will show zero.

Useful for

  • Weekly count before placing produce and dairy orders
  • Tracking which dishes cause the most waste
  • Keeping par levels for a small café kitchen

What's included

  • 4 tabs: Dashboard, Stock, Waste, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Stock: a table
  • Waste: 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 Stock 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

How do I set a par level for each item?

Start with how much of the item you use between deliveries, then add a margin for late orders and busy weekends. Review the level every few weeks, because menu changes and seasons shift the numbers. Par levels are a planning guide, so adjust them to match your own sales.

Why does the waste cost show as zero?

The cost looks up the item name in the Stock tab. If the name differs by a space or a capital letter, the lookup finds nothing and the formula returns zero. Copy the name from the Stock tab to fix it.

Can I use this for drinks as well as food?

Yes. Add beer, wine and mixers as rows on the Stock tab and pick the group that fits best. Spirits are easier to count by bottle, so a bar-specific sheet can give you more accurate figures for those.

  • #inventory
  • #restaurant-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…