Softwiro
Free Excel template

Restaurant and cafe inventory and waste sheet

A free Excel sheet for daily restaurant or cafe inventory. You enter each raw material with its purchase unit (carton or bag), usage unit (gram or ml), the conversion factor between them, its price and its par level. Then you log daily purchases, what was issued to the kitchen, what was thrown away and why (expired, damaged, prep loss or returned dish), and an end-of-day count. The sheet compares what was actually issued with what the recipes of the dishes sold say should have been used, and calculates food cost percentage, waste value and waste percentage by reason, category and week, plus a purchase list for items that fell below par.

Excel file (.xlsx) · 179 KB · 13 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “الخامات” tab (Arabic), with the numbers and formulas that are in the file.
الكودالخامةالمشتريات (استعمال)المنصرف للمطبخالهالكالرصيد الدفتريقيمة الرصيدالحالةنسبة الهالك من المشتريات
R01صدور فراخ219,000218,3603,7004,940741.00اطلب1.7%
R02لحم مفروم116,000119,4121,8004,7881,340.64اطلب1.5%
R03جبنة موزاريلا72,00068,4322,4006,1681,110.24متوفر3.3%
R04دقيق بيتزا75,00071,4003,00050,6001,315.60متوفر4.0%
R05زيت قلي36,00037,0803,60031,3201,914.00متوفر10.0%
R06طماطم90,00080,6408,80010,560190.08متوفر9.6%
R07بطاطس150,000139,0509,00041,950503.40متوفر6.0%
R08خس51,00045,3445,4004,256106.40متوفر10.6%
R09بن قهوة28,00028,2742405,4862,852.72متوفر0.9%
R10لبن288,000284,28013,00014,720515.20متوفر4.5%
R11سكر20,00010,608029,392646.62متوفر0.0%

Example from the “الخامات” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • الإعدادات: Period start and end, target food cost percentage, the par multiplier for order quantity, the alert thresholds for variance and waste, and the lists of categories, waste reasons and issue destinations.
  • الخامات: Each item's card: code, category, purchase unit, usage unit, conversion factor, purchase price, opening balance and par level. The sheet calculates usage unit cost, purchases, issued, waste, book balance and its value, status, order quantity, last count and its variance. Holds up to 60 items.
  • المشتريات: One line per delivery: date, code, supplier, quantity in purchase units, price and invoice number. The quantity in usage units and the total appear. Holds up to 300 deliveries.
  • الصرف للمطبخ: What left the store for the kitchen, bar or cold prep, in usage units, and its value. Holds up to 600 movements.
  • الهالك: Everything thrown away, with date, quantity and reason; its value and the item's category appear. Holds up to 300 entries.
  • الجرد اليومي: The quantity you counted at the end of the day. The book balance on that day, the variance and its value appear. Holds up to 400 entries.
  • الأطباق: The price of each dish and the number sold, so sales, the dish cost from its recipe, its percentage and a comparison with the target appear. Holds up to 30 dishes.
  • الوصفات: One line per ingredient in a dish with its quantity in usage units, so its cost and the theoretical usage for what was sold appear. Holds up to 150 lines.
  • الفعلي والنظري: For each item, what should have been issued according to sales and recipes, what was actually issued, and the difference in quantity, value and percentage, with a verdict of "ضمن الحد" (within limit) or "راجع" (review).
  • طلب الشراء: Items that fell below par, sorted by order cost, with the suggested quantity in purchase units and its cost.
  • الملخص: Sales, actual and theoretical food cost and the target, purchases, waste and its percentage, stock and count variance, waste by reason, category and week, with four charts.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

What makes it different

Issues, waste, counts and dish recipes in one file, so you know how much the kitchen should have used, how much it actually used, and where the difference went.

How to use it

  1. In "الإعدادات" (Settings) enter the period start and end (for example a month), the target food cost percentage, the order multiplier and the alert thresholds.
  2. In "الخامات" (Items) enter for each item: code, name, category, purchase unit (a carton, for example), usage unit (gram), the factor between them, the price per purchase unit, the opening balance and the par level.
  3. Record each delivery in "المشتريات" (Purchases) in purchase units with its price, and in "الصرف للمطبخ" (Kitchen issues) what left the store for the kitchen or bar, in usage units.
  4. Record everything thrown away with its reason in "الهالك" (Waste), and in "الجرد اليومي" (Daily count) the quantity you actually counted at the end of the day, so differences from the book balance appear.
  5. Enter each dish's price and the number sold in "الأطباق" (Dishes), and the quantity of each ingredient in the dish in "الوصفات" (Recipes), so the dish cost and theoretical usage appear.
  6. Review "الفعلي والنظري" (Actual vs theoretical), "طلب الشراء" (Purchase order) and "الملخص" (Summary) for food cost percentage, waste by reason, category and week, and what you need to buy.

Before you start:

  • Book balance = opening balance + purchases - issued to the kitchen - waste, all in usage units. Count variance = actual count - book balance on the count day.
  • Actual food cost = value issued to the kitchen + value of waste, and its percentage = that divided by the dish sales recorded in "الأطباق" (Dishes). Theoretical = recipe quantities x number of dishes sold.
  • Item status: "نفد" (out of stock) if the balance is zero or less, and "اطلب" (order) if it fell below par. Order quantity = (par x multiplier - balance) / factor, rounded up in purchase units.
  • The value of issues, waste and balance is calculated at the purchase unit price entered in "الخامات" (Items) divided by the factor, while the value of purchases uses the price you enter on each delivery.
  • This sheet tracks inventory and waste. To calculate dish cost and a suggested selling price, use the dish costing and recipes sheet.
  • Capacity: 60 items, 300 deliveries, 600 issue movements, 300 waste entries, 400 count entries, 30 dishes and 150 recipe lines. The purchase order list shows the first 40 items.

Excel file (.xlsx) · 179 KB · 13 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

Cheat sheet: restaurant stock and waste (1/3)Cheat sheet: restaurant stock and waste (2/3)Cheat sheet: restaurant stock and waste (3/3)
0 downloads · 3 pages

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

How do I calculate food cost percentage for a restaurant in Excel?

Add the value issued to the kitchen and the value of waste, then divide by dish sales. The sheet does this in "الملخص" (Summary) and compares it with the theoretical percentage from the recipes and with your target.

What is the difference between actual and theoretical usage?

Theoretical usage is the recipe quantities multiplied by the number of dishes sold, that is, what should have left the store. Actual usage is what was recorded as issued to the kitchen. A difference points to oversized portions, unrecorded waste or a recipe error.

How do I record an item I buy by the carton and use by the gram?

Enter the purchase unit, the usage unit and the factor between them (for example 1000 grams per kilo). Record purchases in the purchase unit and issues and waste in the usage unit; the sheet converts between them.

What is par level and how do I use it?

Par is the minimum quantity of an item you want to find in the store. If the balance falls below it, "اطلب" (order) appears in the purchase order, with a quantity that brings you up to a multiple you set in Settings.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Restaurants and cafes

More free templates

All templates · Free tools