A deli inventory spreadsheet is a workbook for recording what you have on hand, what comes in, what is sold or used, and what is lost to spoilage or preparation. In Excel for Microsoft 365, a practical starting point is one row per item, with columns for opening stock, receipts, usage, waste, closing stock, reorder level, and unit cost; formulas can calculate the closing balance, quantity to reorder, and inventory value.
What a deli inventory spreadsheet does
A deli has products with very different handling and counting needs: packaged drinks may be counted by the bottle, sliced meat by weight, and prepared salads by pan, tub, or portion. A spreadsheet gives staff a consistent record of those items and helps a manager compare the count on the shelf or in the cooler with the amount the business expects to have.
That record is useful for more than placing orders. It can help identify fast-moving products, recurring waste, unexpected stock differences, and items that are taking up space without selling. It is also a working document, not an automatic source of truth: its accuracy depends on timely entries, clear units, and physical counts.
Keep inventory separate from food-safety records. A stock sheet can include a lot number or use-by date if those fields help staff rotate products, but it does not replace required temperature checks, cleaning records, receiving procedures, or other records required by local rules.
Choose a useful row and column structure
Use one row for each item you need to count or reorder. Avoid putting several sizes or flavors in one row if they have different costs, suppliers, or reorder points. A simple worksheet can use these columns:
- Item ID and item name: Use a stable code where available, plus a plain name such as “Turkey breast, sliced” or “Sparkling water, 12 oz.”
- Category and storage area: Examples include deli meat, cheese, prepared food, beverage, walk-in cooler, and dry storage. These fields make counts easier to assign.
- Count unit: Record a consistent unit such as pound, case, each, tub, or tray. State whether a case contains a fixed number of units when that matters.
- Opening stock, received, sold or used, and waste: These quantities explain how the balance changed during the period.
- Closing stock and reorder level: Record the counted balance and the minimum amount that should trigger replenishment.
- Supplier, unit cost, and last count date: These details support ordering and make it easier to find stale records.
For a small operation, this can all live on one sheet. If the list grows, keep a product master list for stable details such as item ID, unit, supplier, and cost, and use a separate count sheet for changing quantities and dates. Do not create duplicate product names just because a different employee entered the count.
How the inventory calculation works
The basic stock equation is opening quantity plus receipts, minus sales or other use, minus waste. For the example below, assume the sheet has opening stock in D, receipts in E, sold or used quantity in F, waste in G, and calculated closing stock in H. With values of 12 pounds opening, 8 pounds received, 11 pounds used, and 1 pound wasted, enter =D2+E2-F2-G2 in H2. The result is 8 pounds remaining. Copy the formula down for the other items.
That calculation estimates what should remain based on recorded movements. A physical count may differ. If the sheet is intended to show actual stock, enter the counted amount in a separate “physical count” column rather than silently changing a movement number. Comparing expected closing stock with the physical count makes discrepancies visible and gives staff a chance to investigate them.
For example, if the expected balance is 8 pounds but the count is 7.5, the half-pound difference could reflect trimming, an unrecorded sample, a measurement error, or a missed transaction. Record an adjustment with a reason instead of changing the opening balance, which would hide the history.
Calculate reorder quantities and stock value
A reorder point or par level is a target chosen for the specific item. It may account for typical use before the next delivery, supplier lead time, storage capacity, and a reasonable buffer. It is not a universal number: a busy weekend may require a different plan from a quiet weekday, and highly perishable food should not be ordered simply to fill a large target.
Assume the reorder level is in I and calculated closing stock is in H. With a reorder level of 14 pounds and closing stock of 8 pounds, enter =MAX(0,I2-H2) in J2 to show the quantity needed to reach the target. The result is 6 pounds. This is a simple suggestion, not a purchase order: check pack sizes, existing orders, delivery schedules, and storage space before buying. If the supplier sells only fixed case sizes, convert the suggested quantity to a valid order quantity using the supplier’s case rules.
To estimate the value of remaining stock, put the cost per count unit in K and closing stock in H. With 8 pounds on hand at $4.20 per pound, enter =H2*K2 in L2. The result is $33.60. Format the cost and value columns as currency using Home > Number Format. Make sure the cost basis matches the count unit: a case price cannot be multiplied directly by a count in individual packages unless the case has first been converted.
Set consistent units for deli products
Unit consistency is one of the most important design decisions. If a case of 12 drinks is received but the count is recorded as individual bottles, enter 12 units received, not 1 case, unless the sheet explicitly tracks cases. For a product bought by the case and used by the pound, document how the purchase quantity is converted to the inventory unit. Do not assume that a case’s net weight equals usable weight after trimming or preparation.
Prepared foods create another distinction: ingredients used to make a recipe are not the same thing as the finished portions available for sale. A basic stock sheet can track the finished salad by tub or pound, while ingredient use is recorded separately. More detailed food-cost systems connect recipe quantities to ingredient depletion, but that requires reliable recipes, portion sizes, and production records. A spreadsheet cannot infer those quantities from sales unless the data is entered or integrated.
Use a short written counting guide for unusual items. For example, specify whether an opened case is counted in individual units, how partially used containers are measured, and whether the tare weight of a container is excluded. A consistent method makes counts comparable from one shift to another.
Build the workbook in Excel
In Excel for Microsoft 365 on Windows, place the headers in row 1, select the range, and choose Insert > Table. Confirm that “My table has headers” is selected. Tables make it easier to filter by category or supplier and usually extend formulas and formatting as rows are added. On a Mac, the same table feature is available; the keyboard shortcut is Command+T rather than Ctrl+T. Excel for the web also supports tables, though some ribbon details can differ.
For fields with a controlled set of values, such as category or count unit, use Data > Data Validation to create a list. This reduces variations such as “lb,” “lbs,” and “pound” appearing as separate units. Use Home > Conditional Formatting to highlight low stock or missing dates, but keep the rule understandable and verify it after adding rows. A visual warning should prompt a check, not substitute for one.
Useful working habits include:
- Keep a dated backup or version history before making major structural changes.
- Protect formula columns from accidental edits if multiple people enter counts.
- Use filters to count one storage area or category at a time.
- Freeze the header row with View > Freeze Panes so column labels remain visible while scrolling.
- Record who counted and when, especially if multiple shifts update the same workbook.
Use counts to manage waste and rotation
Waste should be recorded in a way that helps explain it. A waste reason might be spoilage, damage, trimming, preparation overage, or a customer return, depending on the operation’s procedures. A single waste total is easier to maintain, while a separate reason column offers more insight but asks staff to enter more information. Choose a level of detail people can keep up consistently.
For perishable inventory, include a lot, received date, or use-by date only if staff can maintain the information accurately and the field supports the operation’s rotation process. A spreadsheet can help sort or flag dated stock, but it does not ensure that older product is used first or that food is safe. Staff still need to follow applicable labeling, storage, and discard procedures. Requirements vary by location and product, so confirm them with the relevant authority or qualified food-safety professional.
Review waste and stock differences over several counts rather than drawing conclusions from one unusual day. A recurring discrepancy on one product may point to a unit conversion problem, a recipe that is not accounted for, or a missed transaction. A sudden increase in waste may instead reflect a change in demand, delivery timing, or production volume.
Common spreadsheet problems to prevent
- Mixing units: Keep each item’s count and cost basis clear, and use conversions only when they are documented.
- Overwriting formulas: Separate input columns from calculated columns, label them, and protect formulas where appropriate.
- Counting at inconsistent times: A count taken before delivery cannot be compared fairly with one taken after a delivery unless the timing is recorded.
- Leaving out transfers and samples: Stock can be used outside normal sales. Define how samples, staff meals, transfers, and production use are recorded.
- Using vague item names: “Ham” may refer to different products, formats, or suppliers. Include enough detail to distinguish items.
- Treating the reorder result as an order: Check open purchase orders, delivery minimums, case quantities, and perishability before ordering.
Another common misconception is that a spreadsheet automatically tracks inventory because it contains formulas. It only calculates from the entries it receives. If sales, receipts, waste, or transfers are not entered, the calculated balance will drift away from reality. Schedule regular physical counts and reconcile meaningful differences.
When to use software instead
A spreadsheet is often a reasonable starting point when the item list is manageable, one or a few people maintain it, and counts can be updated without interfering with service. It is flexible, inexpensive to start, and easy to adapt to local products. Its disadvantages are manual data entry, limited transaction history unless designed carefully, and the risk of conflicting copies or accidental edits.
Inventory software or a point-of-sale system may be more suitable when several locations need shared stock data, sales should reduce stock automatically, purchasing needs approval workflows, or recipe-level depletion and detailed reporting are essential. Such systems still require accurate product setup, units, receiving, and counts; automation does not remove the need for operational controls. Compare total costs, integrations, staff training, offline behavior, and the effort of maintaining item records before switching.
A practical progression is to begin with a clearly structured sheet, review whether staff can keep it current, and identify the specific limitation before adopting another tool. If the key problem is inconsistent counting, software alone may not solve it. If the problem is repeated manual entry from a large POS catalog, integration could address a genuine bottleneck.
Frequently Asked Questions
What should a deli inventory spreadsheet include?
At minimum, include an item name or ID, count unit, counted quantity, reorder level, supplier, unit cost, and count date. Add receipts, usage, waste, and a calculated balance if you want to track stock movement between counts.
How often should deli inventory be counted?
There is no single schedule for every deli. Count high-value, fast-moving, or perishable items more often than stable low-cost supplies, and align counts with ordering and operating routines. Use the same timing and method each time so comparisons are meaningful.
Can Excel calculate how much to reorder?
Yes. A simple formula can subtract current stock from a chosen target and return zero when stock is already at or above that target. The result is only a planning estimate; account for open orders, supplier pack sizes, delivery lead time, and shelf life before placing an order.
Should waste be included in inventory?
Yes, if the sheet is used to explain stock movement. Record discarded or otherwise unusable product separately from sold or used stock, and use consistent reasons where helpful. This helps distinguish normal sales from loss and makes unexplained differences easier to investigate.
Is a spreadsheet enough for food-safety tracking?
Not by itself. An inventory sheet can support rotation and product identification, but it does not replace required food-safety procedures or records. Follow applicable local requirements and use appropriate logs and processes for temperature control, labeling, receiving, and handling.
Related
- PowerPoint Template: How to Create, Save, and Reuse One
- Create a PowerPoint Template From an Existing Presentation
- PowerPoint Animate Bold Text: Steps, Effects, and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Phone List Template: Create a Contact ListAn Excel phone list template is a worksheet for keeping names, phone numbers, and useful contact details in…
- Flip Words Upside Down in Excel: 3 Practical MethodsTo flip words upside down in Excel, use upside-down Unicode characters in a formula or paste text from…
- Excel Consolidate and Empty Cells: What Happens?Yes—Excel’s Data > Consolidate command can combine ranges that contain empty cells. With Sum, a blank contributes no…
- How to Lock an Excel Row at the Top While ScrollingTo keep a row visible at the top while you scroll in Excel for Microsoft 365 on Windows,…
- Excel Shortcut to Insert a Row: Windows and MacIn Excel for Microsoft 365 on Windows, select the row where the new row should go and press…
- Power Query in Google Sheets: What You Can Do InsteadNo—Google Sheets does not include Microsoft Excel’s Power Query editor, and it cannot run Power Query’s M language…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.