Restaurant Inventory Management: Run a Reliable Weekly Stock Count

Fix a cutoff and hold stock movements

Choose one cutoff and keep it every week, for example after closing on Sunday night or before opening on Monday. A count only compares fairly with last week's if both describe the same point in the trading cycle.

Pause stock movements during the count where practical. Segregate deliveries arriving after the cutoff and record them in the next period. If operations cannot pause, log the time, item and quantity of each receipt, issue or transfer so the physical count can be reconciled back to the cutoff. Apply the same boundary to every location.

Count by location

Lay out the count sheet in the order stock is physically stored: walk-in, each reach-in, dry store shelf by shelf, bar, then the line. Counters move through the space once instead of hunting for items alphabetically, which is where things get missed or counted twice. Labelled shelves and containers help a great deal. The same item can appear in several locations, as long as each one is counted separately and added up afterwards.

Agree base units and pack conversions

Give each item one base unit: kilograms for rice, litres for oil or pieces for eggs. Record pack sizes in the item record, then convert before entry. Two 25 kg bags plus 6 kg loose equals 56 kg. The Stock Count sheet accepts quantities already converted into base units; it does not automatically convert packs. Never add bags to kilograms or quantities to rupee values in the same column.

Open packs and part-used tins cause many errors. Decide in advance whether they are weighed or estimated to an agreed fraction, and apply that rule every week.

Count blind, then recount exceptions

In a blind count, the counter records what they see without being shown the expected quantity, because seeing the expected figure tends to pull the count towards it. Where staffing allows, one person counts and another writes.

Once counts are entered, compare them with expected levels and recount any item with a large or unusual difference before the sheet is closed. A same-day recount takes minutes; untangling a counting error weeks later takes far longer.

Batches, yields and in-process food

Prepared gravies, marinated meat and cooked rice need their own production and stock records. For a raw-ingredient count, expected use must include the raw ingredients issued into production, including food still held as work in progress at cutoff. Sales alone will not capture that movement.

Reconcile prepared items separately using batches produced, portions issued, waste and closing prepared stock. Do not count the same material as both raw stock and prepared stock. Use approved recipes and measured yields when translating between these records; kilograms of raw rice and cooked rice are different quantities.

Waste, transfers and valuation

Record waste once, when it happens, with the item, quantity and reason. The common error is counting it twice: once in the waste log and again because the recipe allowance already includes trimming or spillage. Decide which method each item uses and keep to it.

Transfers between outlets or to a central kitchen should be recorded on both sides with the same quantities and dates. For valuation, compare like with like: the same items, the same locations, the same period and the same costing basis each week. The example below uses a single sample unit cost purely to show the arithmetic. That is an illustration, not an accounting valuation policy, so agree your method with whoever prepares your accounts.

A worked example: raw rice

These figures are hypothetical and chosen only to show the calculation. Here, expected use is raw rice issued to production; the example has no unrecorded work in progress.

Actual use is opening stock plus receipts plus transfers in, minus transfers out, minus closing stock. Unexplained use is actual use minus expected recipe use minus recorded waste. If an item's expected usage already includes its waste, do not subtract waste again. Work in kilograms until the unexplained quantity is known, then apply the unit cost as a separate step.

Reading the difference fairly

Two kilograms of unexplained rice shows where to look, without telling you why. Possible causes include extra raw rice issued into a batch but not recorded, raw rice spilled without a waste entry, a recipe card that differs from the actual ingredient issue, a short delivery that was recorded at the ordered quantity, or a counting error. Check those records first and see whether the same item shows a recurring gap before drawing a conclusion.

Do not treat variance as proof of theft. A number cannot establish what happened, and accusing staff on the strength of one damages trust and may simply be wrong. If you have a genuine concern, follow your own fair process.

Using the Stock Count and Count Routine sheets

The Stock Count sheet keeps location and item together, with base units, opening stock, receipts, transfers, closing stock, expected use and waste. It calculates actual use, unexplained use and an illustrative variance value. Enter all quantities in the same base unit and use zero only when the quantity is genuinely zero. Blank inputs leave the dependent result blank.

The Count Routine sheet covers the cutoff, movement control, units, recount and review. Keep the physical count record separate from expected balances if you want counters to work blind.