How to reconcile theoretical and actual wine stock in a restaurant

When system stock and the bottles in the cellar do not match, forcing the number to balance removes the signal but not the cause. A useful reconciliation rebuilds movement by wine, measures the variance and helps determine whether the issue is a format error, an unlinked sale, undeclared waste or an inaccurate count.

The starting equation

Theoretical stock is opening stock + receipts − bottles sold − bottles opened for by-the-glass service − declared events ± transfers. Compare that figure with the physical count. If one layer is missing, the result must be labelled incomplete rather than presented as certainty.

Establish a reliable opening point

Without a trustworthy opening inventory, reconciliation can only measure changes from the first valid count. Choose a date, count by wine and format, and lock that baseline. From then on, every purchase, sale, opening, breakage, complimentary serve and transfer needs a trace.

Normalise units and formats first

Many variances are conversion problems: bottle versus glass, 750 ml versus magnum, case versus unit, or two POS products linked to one wine. Normalise identifiers and formats before treating a difference as waste.

Read the direction of variance

Actual stock below theoretical stock may point to an unlinked sale, overpour, breakage, complimentary serve, transfer or count error. Actual stock above theoretical stock may reveal missing receipts, returns, duplicates or sales deducted from the wrong wine. Direction helps narrow the investigation.

Prioritise by impact

Do not investigate every variance equally. Sort by cost value, retail value at risk, recurrence and operational importance. A premium bottle or a repeated issue deserves attention before a small one-off variance. Use an explicit tolerance, never a silent correction.

Shift close and monthly reconciliation

At each close, record open bottles, breakage, complimentary serves and substitutions. Weekly, review high-movement wines. Monthly, run a targeted or complete physical count and document every adjustment. This cadence reduces retrospective work and improves purchasing and margin data.

POS and multi-location integration

The POS supplies sales and formats; Winerim maps those lines to wine records, receipts and stock. In a group, every location keeps its own baseline and movements while the central view compares incidents and policies without mixing inventory.

What the report should show

For each wine: theoretical stock, actual stock, unit variance, cost, retail value, explanatory movements, data confidence and next action. Actions should be specific: review POS mapping, register waste, add a receipt, recount or accept a documented adjustment.

Frequently asked questions

Does a variance mean theft or waste? No. Check formats, receipts, POS links, transfers and counting errors first. Can I reconcile without opening stock? You can start tracking movement, but you cannot claim a cumulative variance until a reliable baseline exists. Use the [stock reconciliation tool](/en/tools/wine-stock-reconciliation), then explore [wine waste](/en/tools/wine-waste-calculator), [POS integrations](/en/integrations), [sleeping stock](/en/article/sleeping-cellar-stock-pos-cloudrim-savia-rotation) and [demo](/en/demo).