Picture this: you're bleeding money through spoiled produce, but your food cost percentage looks "normal" on paper. Most restaurant owners see their total food cost but can't pinpoint how much they're losing to spoiled products. A structured monthly inventory P&L reveals exactly where your inventory leaks money.
What is an inventory P&L?
An inventory P&L (Profit & Loss) reveals the gap between what you purchase and what actually generates revenue. It exposes profit losses from:
- Spoilage and waste
- Theft or disappearance
- Incorrect portioning
- Administrative errors
Tracking spoilage losses separately shows you're over-ordering or storing products too long. From tracking this across dozens of restaurants, spoilage often accounts for 40-60% of unexplained inventory losses.
Basic structure of your monthly inventory P&L
Your inventory P&L needs these core components:
💡 Example inventory P&L March:
- Opening inventory March 1: €3,200
- Purchases March: €12,500
- Closing inventory March 31: €2,800
- Theoretical sales: €12,900
- Actual sales (till): €11,800
- Loss from spoilage: €450
- Other losses: €650
Total loss: €1,100 (8.5% of purchases)
Register spoilage losses separately
Spoilage represents one of your largest loss categories, yet it's often buried in overall numbers. Separate tracking reveals critical patterns:
- Which products spoil most frequently
- When spoilage peaks (specific days/weeks)
- Why it occurs (over-purchasing, poor storage)
⚠️ Important:
Document spoilage immediately upon disposal. Retrospective estimates are notoriously unreliable and you'll forget at least half.
Calculate your actual food cost
Your real food cost exceeds expectations due to hidden losses. Use this formula:
Actual food cost % = ((Purchases + Opening inventory - Closing inventory) / Revenue excl. VAT) × 100
💡 Example calculation:
Restaurant with €45,000 revenue in March:
- Purchases: €12,500
- Opening inventory: €3,200
- Closing inventory: €2,800
- Consumption: €12,500 + €3,200 - €2,800 = €12,900
Revenue excl. VAT: €45,000 / 1.09 = €41,284
Actual food cost: (€12,900 / €41,284) × 100 = 31.3%
Loss analysis by category
Categorize losses for targeted action:
- Spoilage of fresh products: vegetables, fish, meat, dairy
- Expiry date exceeded: products past best-before dates
- Damage: broken, dropped, improperly stored items
- Overproduction: prepared food that wasn't sold
- Unexplained: missing inventory (theft, administrative errors)
💡 Loss analysis March:
- Spoilage of fresh products: €280 (2.2%)
- Expiry date exceeded: €170 (1.4%)
- Damage: €95 (0.8%)
- Overproduction: €200 (1.6%)
- Unexplained: €355 (2.8%)
Total loss: €1,100 (8.8% of consumption)
Red flags you shouldn't ignore
These percentages signal problems in inventory management:
- Spoilage > 3%: Over-purchasing or inadequate storage
- Unexplained loss > 2%: Potential theft or administrative errors
- Overproduction > 2%: Poor forecasting or excessive portions
- Total loss > 8%: Significant money hemorrhaging through inventory
⚠️ Important:
Loss percentages of 5-8% are typical for restaurants. Below 5% indicates excellent control, above 10% seriously damages profitability.
Digital registration vs. manual tracking
Manual Excel tracking works but consumes time and invites errors. Digital systems offer advantages:
- Automatic food cost calculations
- Direct loss entry capabilities
- Multi-month trend analysis
- Report generation without manual work
How do you set up a monthly inventory P&L? (step by step)
Count your opening inventory on the 1st of the month
Go through your entire kitchen and count everything: fridge, freezer, dry storage, beverages. Note the purchase value of each product. This is your opening inventory.
Record all purchases throughout the month
Keep all invoices and note every delivery. At the end of the month, add up all purchases. These are your monthly purchasing costs.
Track spoilage losses daily
Every time you throw something away, note what it was and what it cost. Create categories: spoilage, damage, overproduction, unexplained loss.
Count your closing inventory on the last day of the month
Repeat step 1 on the last day of the month. This is your closing inventory. The difference from your opening inventory shows how much you actually consumed.
Calculate your actual food cost and loss percentages
Use the formula: (Purchases + Opening inventory - Closing inventory) / Revenue excl. VAT × 100. Divide your spoilage loss by your total consumption for the loss percentage.
✨ Pro tip
Weigh and photograph all spoiled items during your first 30 days - you'll identify which suppliers deliver short shelf-life products and which storage areas cause the most waste. Most owners are shocked by the actual dollar value.
Calculate this yourself?
In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.
Was this article helpful?
Frequently asked questions
How often should I count my inventory?
Monthly counts provide reliable P&L data for most restaurants. Weekly counts offer superior loss control and faster adjustment capabilities, though they require more labor investment.
What's a normal loss percentage from spoilage?
Total losses of 5-8% of consumption are standard for restaurants. Spoilage alone shouldn't exceed 3% - higher percentages indicate over-purchasing or storage issues.
Should I involve staff in loss registration?
Absolutely - train kitchen staff to log losses immediately using simple forms or apps. Without team cooperation, you'll capture less than half your actual losses.
Can I separate losses by specific product categories?
Yes, and you should track your highest-cost items separately. Proteins, seafood, and specialty ingredients deserve individual tracking since they represent your biggest potential losses per unit.
📚 Sources consulted
- EU Verordening 852/2004 — Levensmiddelenhygiëne (2004) — Official source
- EU Verordening 853/2004 — Hygiënevoorschriften voor levensmiddelen van dierlijke oorsprong (2004) — Official source
- EU Verordening 1169/2011 — Voedselinformatie aan consumenten (2011) — Official source
- NVWA — Hygiënecode voor de horeca (2024) — Official source
- NVWA — Allergenen in voedsel (2024) — Official source
- Codex Alimentarius — International Food Standards (2024) — Official source
- FSA — Safer food, better business (HACCP) (2024) — Official source
- BVL — Lebensmittelhygiene (HACCP) (2024) — Official source
- Warenwetbesluit Bereiding en behandeling van levensmiddelen (2024) — Official source
- WHO — Foodborne diseases estimates (2024) — Official source
Food Standards Agency (FSA) — https://www.food.gov.uk
The HACCP standards shown in this application are for informational purposes only. KitchenNmbrs does not guarantee that displayed values are current or complete. Always consult the FSA or your local authority for the latest regulations.
Written by
Jeffrey Smit
Founder & CEO of KitchenNmbrs
Jeffrey Smit built KitchenNmbrs from 8 years of hands-on experience as kitchen manager at 1NUL8 Group in Rotterdam. His mission: give every restaurant owner control over food cost.
Calculate your break-even point in seconds
Food cost is just one part of the story. KitchenNmbrs also helps you structure labor costs and other expenses for a complete break-even overview. Start free.
Start free trial →