Many restaurant owners think rough estimates work fine for quarterly reports. Your accountant actually needs precise inventory figures to calculate your true cost of goods sold. A €5,000 inventory error means €5,000 difference in your reported profit.
Why inventory counting drives your P&L accuracy
Your accountant calculates cost of goods sold with this formula:
Cost of goods sold = Beginning inventory + Purchases - Ending inventory
Get your ending inventory wrong? Your entire profit figure shifts by the same amount. An inventory miscounted by €3,000 creates a €3,000 swing in quarterly profit.
💡 Example:
Restaurant with €400,000 annual revenue:
- Beginning inventory January 1: €8,000
- Purchases Q1: €32,000
- Ending inventory March 31: €6,500
Cost of goods sold Q1: €8,000 + €32,000 - €6,500 = €33,500
What your accountant expects from you
Quarterly reports require these specific figures:
- Exact inventory value as of March 31/June 30/September 30/December 31
- Breakdown by product category (meat, fish, vegetables, beverages, etc.)
- Comparison with previous quarter to spot trends
- Explanation of major variances (why did inventory jump or drop?)
⚠️ Important:
Never estimate your inventory. Count everything physically. A €500 estimation error shifts your quarterly profit by exactly €500.
Counting frequency for reliable quarterly figures
From tracking this across dozens of restaurants, here's what works:
- Monthly counting: Builds accountant confidence and catches errors early
- Quarterly minimum: Bare bones for decent P&L accuracy
- After major purchases: Count within 48 hours of any €3,000+ delivery
Converting inventory counts to cost price
You'll count inventory at purchase price, never selling price. Here's the correct P&L method:
💡 Example inventory valuation:
- 20 kg beef at €18/kg = €360
- 15 bottles wine at €8/bottle = €120
- Various vegetables = €180
- Frozen products = €240
Total inventory value: €900
Digital systems vs. Excel spreadsheets
Excel still dominates many kitchens, but creates these risks:
- Calculation errors: One mistyped number destroys your entire quarterly report
- Forgotten products: Small items slip through counting
- No comparison history: Previous quarter data gets lost or corrupted
Digital tools like KitchenNmbrs automatically track purchases and convert your physical counts into proper accountant-ready valuations.
⚠️ Important:
Store count sheets for minimum 7 years. Your accountant and tax authorities can demand these during audits.
Explaining inventory swings to your accountant
Major inventory changes need clear explanations:
- Inventory jumped: Seasonal prep, holiday stockpiling, supplier minimum orders
- Inventory dropped: Reduced purchasing during busy stretch, cooler failure waste
- Category shifts: Menu changes favoring fish over meat, wine list updates
How do you create a quarterly inventory report? (step by step)
Count your complete inventory on the last day of the quarter
Go through all refrigerators, freezers, dry storage and bar. Note everything you have at purchase price. Do this after closing time for the most accurate count.
Divide your inventory into main categories
Create categories like meat/fish, vegetables, dairy, beverages, dry products. This gives your accountant insight into where your money is tied up and helps analyze trends.
Compare with previous quarter and explain major differences
Calculate the difference per category. Did your beverage inventory increase by €2,000? Explain why (new supplier, holidays, menu change). This helps your accountant understand your figures.
✨ Pro tip
Count inventory on the last Sunday of each quarter at 6 PM sharp. This 13-week rhythm gives your accountant consistent comparison points and eliminates day-of-week sales variations.
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 inventory for my accountant?
Minimum once per quarter for reliable P&L figures. Monthly counting gives your accountant better trend visibility and catches errors before they compound.
Do I have to count everything or can I estimate small items?
Count everything worth more than €50 individually. Spices, oils, and condiments under €50 total can be estimated, but stay consistent quarter to quarter.
What if my inventory differs significantly from last quarter?
Differences exceeding 20% need written explanations. Document seasonal purchasing patterns, menu changes, equipment failures, or deliberate inventory buildups for peak periods.
How do I value products nearing expiration dates?
Products expiring within 2 days get valued at 50% of purchase price. Expired products count as €0 inventory value for your quarterly report.
📚 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 →