How to investigate stock discrepancies across restaurant outlets

Define the discrepancy precisely

A statement such as 'stock is wrong' is too broad to investigate. Name the item, location, unit of measure, physical count time and system quantity at that same moment. Freeze the time window so later receipts or sales do not keep changing the comparison.

Check whether the difference is a quantity problem, a value problem or both. A correct quantity with the wrong cost needs a different investigation from missing physical units.

Rebuild the movement equation

Use the simplest possible movement statement: opening stock, plus receipts and confirmed transfers in, minus confirmed transfers out, expected usage, waste and other approved adjustments, equals expected closing stock.

Keep transfers in transit separate. A dispatch from one outlet should not become available stock at another until receipt is confirmed. Treating both sides as complete at different times can create a false shortage at one location and false availability at the other.

Check the common break points in order

• Count timing: sales, receipts or waste were posted after the physical count but included in the system balance.
• Unit conversion: a case, kilogram, litre, portion or each was converted incorrectly.
• Receipt: the invoice quantity was entered, but the delivered quantity was different or partly rejected.
• Transfer: the sending outlet dispatched stock, but the receiving outlet has not confirmed the same quantity.
• Recipe or item mapping: a menu item consumed the wrong ingredient, quantity or recipe version.
• Waste and staff use: a real movement happened but was recorded late, under the wrong reason or not recorded.
• Duplicate or missing event: an import repeated a transaction or failed before it reached the stock record.

Use patterns to narrow the cause

One item at one outlet often points to a local count, receipt or handling issue. The same item across many outlets may point to a shared recipe, unit or catalogue definition. Many items at one outlet may indicate a missed count, transfer timing problem or a process gap during a particular shift.

Compare the first date the discrepancy appeared with changes to recipes, suppliers, pack sizes, menu mappings or system connections. The first break is usually more useful than the largest later variance, because later balances inherit the original error.

Correct the cause and preserve the evidence

Do not begin by posting a balancing adjustment. Record the evidence, correct the source event or mapping when possible, and use an adjustment only with a clear reason and owner. Otherwise the balance may look clean while the same error continues tomorrow.

After the correction, run the movement again and confirm the next count. If the discrepancy returns, move the review closer to the event, such as confirming a transfer at receipt or checking the unit when goods are recorded.

Keep inventory in the operating picture

Ri'SERVE's inventory capability keeps stock and movement context alongside the outlet operation. Broader production and supply workflows are scoped separately and remain part of the Source-to-Sale work in development.