calcolihoreca

Free calculators for restaurants, bars and pizzerias. Results are operational estimates and do not replace professional tax, legal, health or technical advice.

Food cost calculatorCocktail cost calculatorBlood alcohol calculatorPizza dough calculatorBreak-even calculatorBMI calculatorPercentage calculatorItalian tax codeAll calculatorsBar gamesBlogAuthorsAbout usEditorial policyContactPrivacyCookieTerms
Made in Italy
$calcoli·HoReCaFree · fast · no sign-up
Food CostMarginsBar & CocktailPizzaPastaStaff & HREventsCoffee
Home/Inventory Management

Inventory Management

Inventory Value Calculator — Restaurant Stock Valuation

Count and value your full restaurant or bar inventory across all categories. Generate the closing stock figure needed for accurate COGS and monthly profit reports.

Updated: May 2026
No registration Instant calculation Data stays in browser
ProductQuantityUnit cost

Inventory value

Total value$708.00
Inventory rows3
150 persone trovano utile questo calcolatore

Inventory Valuation Formula

Inventory value = Σ (Quantity on hand × Unit cost)

COGS = Opening inventory + Purchases − Closing inventory

Weighted average unit cost = Total cost of stock / Total units

FIFO: cost is based on oldest purchase price first

Example (wine cellar, weighted average):
  Chianti Classico DOCG — 36 bottles in stock
  Batch 1: 24 bottles @ €9.50 = €228
  Batch 2: 12 bottles @ €10.20 = €122.40
  Weighted avg cost: €350.40 / 36 = €9.73/bottle
  Inventory value: 36 × €9.73 = €350.40

Monthly Inventory Workflow

StepActionTiming
1. CountPhysical count of all stock items by weight, unit or volumeLast day of month
2. ValueMultiply quantities by latest purchase cost per unitSame day
3. ReconcileCompare to book inventory, investigate variances > 2%Within 2 days
4. ReportCalculate COGS and food cost % for the monthBy 5th of next month
5. ReorderPlace orders for items below reorder pointSame day as count

Example: Year-End Wine Cellar Valuation

A Florentine enoteca needs to value its wine cellar for the 31 December balance sheet. Total cellar: 420 bottles across 35 labels.

CategoryBottlesAvg costValue
House wine (vino della casa)48€4.20€201.60
Regional DOC (Chianti, Vermentino)180€9.80€1,764
DOCG premium (Brunello, Barolo)84€28.50€2,394
Prosecco & sparkling72€7.40€532.80
Dessert wines (Passito, Vin Santo)36€16.00€576
Total cellar value€5,468.40
Risposte rapide

Direct answers

Why does inventory valuation matter for a restaurant?
Your closing inventory value directly affects your COGS (Cost of Goods Sold) and therefore your gross profit. Under-valuing stock inflates COGS and understates profit; over-valuing does the opposite. Accurate monthly inventory counts are essential for true P&L reporting and for the annual balance sheet (stato patrimoniale).
Which inventory valuation method should an Italian restaurant use?
Italian accounting standards (OIC 13) recommend the weighted average cost method for most food businesses due to its simplicity with perishables. FIFO (First In, First Out) is also acceptable and is the most logical method for ingredients with expiry dates. LIFO is not permitted under Italian GAAP (codice civile, art. 2426).
How do I value wine inventory for the annual balance sheet?
Wine held for resale is valued at purchase cost (FIFO or weighted average). Premium wines (Barolo, Brunello, Amarone) that appreciate over time may be carried at cost in most small businesses. For fine wine collections used as investments, consult a commercialista (Italian accountant) about the appropriate accounting treatment.
How often should I count restaurant inventory?
Monthly counts are the professional standard for Italian restaurants. Fresh food should be counted weekly or at every delivery. Wine and spirits: monthly. Dry goods: monthly. Some larger operations count high-value items (foie gras, truffles, aged meats) weekly. Year-end inventory count is legally required for the balance sheet.
What is the difference between physical inventory and book inventory?
Book inventory is the theoretical value based on opening stock + purchases − COGS. Physical inventory is the actual count. The difference is your variance — typically 1–3% for well-run operations and up to 8–10% for those with theft, waste or recording errors. Reconcile monthly.
Can I deduct spoiled inventory as a tax loss in Italy?
Yes, under specific conditions. Food waste due to natural spoilage (deperimento) is deductible if documented. You need a destruction declaration (verbale di distruzione) or a certificate from the local ASL (health authority) for larger amounts. Keep records of all write-offs for your accountant.
Quick answers

Frequently Asked Questions

Why does inventory valuation matter for a restaurant?

Your closing inventory value directly affects your COGS (Cost of Goods Sold) and therefore your gross profit. Under-valuing stock inflates COGS and understates profit; over-valuing does the opposite. Accurate monthly inventory counts are essential for true P&L reporting and for the annual balance sheet (stato patrimoniale).

Which inventory valuation method should an Italian restaurant use?

Italian accounting standards (OIC 13) recommend the weighted average cost method for most food businesses due to its simplicity with perishables. FIFO (First In, First Out) is also acceptable and is the most logical method for ingredients with expiry dates. LIFO is not permitted under Italian GAAP (codice civile, art. 2426).

How do I value wine inventory for the annual balance sheet?

Wine held for resale is valued at purchase cost (FIFO or weighted average). Premium wines (Barolo, Brunello, Amarone) that appreciate over time may be carried at cost in most small businesses. For fine wine collections used as investments, consult a commercialista (Italian accountant) about the appropriate accounting treatment.

How often should I count restaurant inventory?

Monthly counts are the professional standard for Italian restaurants. Fresh food should be counted weekly or at every delivery. Wine and spirits: monthly. Dry goods: monthly. Some larger operations count high-value items (foie gras, truffles, aged meats) weekly. Year-end inventory count is legally required for the balance sheet.

What is the difference between physical inventory and book inventory?

Book inventory is the theoretical value based on opening stock + purchases − COGS. Physical inventory is the actual count. The difference is your variance — typically 1–3% for well-run operations and up to 8–10% for those with theft, waste or recording errors. Reconcile monthly.

Can I deduct spoiled inventory as a tax loss in Italy?

Yes, under specific conditions. Food waste due to natural spoilage (deperimento) is deductible if documented. You need a destruction declaration (verbale di distruzione) or a certificate from the local ASL (health authority) for larger amounts. Keep records of all write-offs for your accountant.

Italian version: Calcola valore inventario
ProductQuantityUnit cost

Inventory value

Total value$708.00
Inventory rows3
150 persone trovano utile questo calcolatore

Explore 3 similar calculators

Inventory Turnover CalculatorMinimum Stock CalculatorFood Cost Calculator
Next useful tools

Related calculators

InventoryInventory Turnover CalculatorCalculate inventory turnover ratio and days of stock on hand.Open calculatorInventoryMinimum Stock CalculatorCalculate the minimum safety stock level for each ingredient.Open calculatorFood CostFood Cost CalculatorCalculate the food cost percentage for any dish or entire menu.Open calculator