How to Reconcile Stocktakes, Recipe Costing and POS Sales

How Do Stocktakes Reconcile Food Costs?

To reconcile food costs, compare supplier purchases, opening and closing stocktakes, and POS sales for the same period. Use the same dates, venue, units and product scope for all three records. If they do not align, your food cost percentage can mislead you about margins.

The Eats365 inventory guide covers available quantities, preset quantities, End of Day resets and Excel export in the Eats365 POS Merchant Portal. It does not calculate ingredient-level theoretical food cost, so recipe costs need to be set up separately.

Read more: Fav Inventory

Why Does Food Cost Drift?

Food cost drifts when actual kitchen usage departs from recipe-based theoretical usage, or when purchase prices and records fall out of date. Treat each gap as a prompt to investigate, not proof of staff wrongdoing. The food cost variance formula makes these gaps visible.

Genuine usage variance (kitchen practice):

• Waste and spoilage: Stock is thrown out or kept past its use-by date. Signal: usage of short-life items exceeds what sales justify.

• Over-portioning: Dishes are plated above recipe weight. Signal: protein or dairy usage rises while covers stay flat.

• Preparation yield loss: Trimming, peeling or cooking loss uses more product than costed. Signal: prep-heavy items show a consistent usage gap.

• Unrecorded staff meals and tastings: Food is eaten or sampled without a POS entry. Signal: usage gaps appear on items with few or no matching sales.

Data errors (records):

• POS voids, comps and discounts: Signal: theoretical usage shifts when these transactions are treated differently across reports.

• Supplier price changes: Recipe costs still use old prices. Signal: theoretical cost lags behind current invoices.

• GST mismatch: Invoices and recipe costs use different GST bases (one GST-inclusive, the other GST-exclusive). Signal: a consistent variance gap appears across multiple items. The impact depends on the mix of taxable and GST-free items you sell. GST-registered businesses can also claim input tax credits on eligible purchases, which may offset the initial discrepancy. To ensure your reconciliation is accurate, confirm with your accountant how GST treatment should be applied to your specific records.

• Invoice errors and missing invoices: Signal: purchase totals do not match supplier statements.

• Lagging recipe updates: Recipe cost sheets are not revised after pack size or price changes.

Check records first by recounting affected items and confirming invoices. Menu pricing and item mix are covered in What Is Menu Engineering.

How Often Should Stocktakes Happen?

A practical starting point is three tiers: count premium proteins, seafood and liquor daily or every shift, run a full food and beverage stocktake weekly, and check slow-moving dry goods and consumables monthly. Adjust these frequencies to stock turnover, risk and your venue's own variance, as outlined in MarketMan's stocktake frequency guidance.

Set up the count sheet with these columns:

1. Item

2. Unit (for example, kg, bottle or case)

3. Quantity counted

4. Unit cost (AUD)

5. Counted value (AUD)

6. Count date

Count on the same day and at the same time each week, and record each item in the same unit every time. Changing either one makes week-to-week variance comparisons unreliable.

Read more: StockTake Online

How Do You Calculate Food Cost Percentage?

Food cost percentage is actual food cost divided by food sales, multiplied by 100. Actual food cost equals opening stock plus purchases minus closing stock, and theoretical food cost equals POS quantities sold multiplied by standard recipe costs. Use the same period, AUD values and GST basis for every input, following the variance calculation guide.

Note: This formula assumes no inter-venue stock transfers. If you transfer stock between venues, adjust your calculation by reducing purchases (for outgoing stock) or increasing opening stock (for incoming stock) to reflect the actual flow of goods for the period under review.

1. Actual food cost = opening stock + purchases − closing stock. Opening and closing values come from physical stocktakes, and purchases come from supplier invoices.

2. Theoretical food cost = Σ (POS quantity sold × current standard recipe cost per item).

3. Food cost percentage = actual food cost ÷ food sales × 100.

4. Variance ($) = actual food cost − theoretical food cost.

5. Variance (%) = variance ($) ÷ food sales × 100.

6. Sales basis: Use food sales either ex-GST or incl-GST, and value purchases and stock on the same GST basis.

How Does Recipe Costing Link to POS Sales?

Recipe costing links POS sales to stocktakes by turning each menu item into expected ingredient usage. Standardise units and yields, cost each recipe at current supplier prices, map menu items and modifiers, then compare expected usage with the quantities sold over the same dates.

1. Standardise units and yields. Convert each purchase unit into a stocktake unit, such as a 10 kg carton into kilograms, and record trim or cooking loss. Document every conversion, such as one 750 mL bottle equalling 25 x 30 mL pours.

2. Cost each recipe at current prices. Use the latest supplier invoice for each ingredient. Note whether each cost includes GST, and keep the same basis as your food sales.

3. Map menu items and modifiers. Link each POS item to its recipe. Link modifiers, such as extra shots or oat milk, to their ingredient quantities, because a modifier affects theoretical usage only when its ingredient quantity is configured and recorded.

4. Calculate expected usage. Multiply POS quantities sold by the recipe quantity for each ingredient across the stocktake period.

5. Review voids and comps. Check sales, void and comp reports for the same dates as the stocktake. Decide whether each voided or comped item used stock, and apply that rule consistently.

In the Eats365 Merchant Portal, managers can view and adjust available quantities, set preset quantities, turn on inventory tracking per item and export inventory to Excel. The Eats365 inventory guide also documents end-of-day reset options. These settings track menu-item quantities only, so the recipe-to-stocktake comparison remains a manual step.

Read more: StockTake Online

How Can Stocktakes Prepare for Peak Season?

A two-week plan gives a venue time to fix counts, recipe costs and POS data before summer or Christmas trade. Each task has one owner and a concrete output, so the reconciliation is ready before the busy period starts.

Cafés and bars should add these items to the baseline count:

• Cafés: high-use coffee beans, milk, syrups, cups and lids. Record each in the same unit every time, such as kilograms or litres.

• Bars: spirits and wine by bottle, with each standard pour measure documented as a recipe unit so pours convert correctly.

Get Started with Inventory Reconciliation with Eats365

Reconciling stocktakes, recipe costs, and POS sales provides the visibility needed to protect margins and identify operational waste. Successful reconciliation relies on regular count schedules, accurate unit conversions, and up-to-date supplier pricing. Contact Eats365 to learn how our inventory tools can streamline your stocktake process and help you maintain tighter margin control across your venue.

Theoretical vs Actual Food Cost: Common Questions

Q: What is the difference between theoretical and actual food cost?

Theoretical food cost is the expected cost based on POS quantities sold multiplied by standard recipe costs, whereas actual food cost is the real expenditure calculated using opening stock plus purchases minus closing stock. The gap between them is food cost variance, which reveals whether your venue is losing margin to kitchen waste, over-portioning, or outdated supplier pricing.

Q: What causes variance between theoretical and actual food costs?

Variance is caused by genuine kitchen usage discrepancies or administrative data errors. Kitchen issues include food waste, spoilage, over-portioning, trimming yield loss, and unrecorded staff meals. Data errors stem from outdated supplier prices in recipe cards, missing purchase invoices, inconsistent recording of POS voids and comps, or mismatched GST treatments between purchase invoices and sales reports.

Q: How should GST be handled when calculating food cost percentage in Australia?

Food cost percentage must use the same GST basis across sales, purchases, and inventory valuations. If your POS food sales are recorded GST-exclusive, supplier invoices and opening and closing stocktakes must also be valued GST-exclusive. Mixing GST-inclusive purchases with GST-exclusive sales creates a variance, but the size of that variance depends on the mix of taxable and GST-free items you sell. Restaurants selling primarily hot food and beverages will experience a different impact than those selling a high proportion of GST-free basic food. GST-registered businesses may also claim input tax credits on eligible purchases, which can offset part of the discrepancy. To ensure your reconciliation is accurate, consult with your accountant to confirm how GST treatment should be applied to your specific records.

Q: How often should a restaurant complete stocktakes to track food cost?

Stocktakes should follow a tiered schedule based on product turnover and risk. High-value proteins, fresh seafood, and liquor should be counted daily or every shift. A full food and beverage stocktake should take place weekly at the same day and time, while slow-moving pantry items, dry goods, packaging, and cleaning supplies can be counted on a monthly cycle.

Q: Why is modifier mapping necessary for recipe costing and inventory control?

Modifier mapping links POS item customisations, such as alternative milks or extra coffee shots, directly to their specific ingredient costs and stock quantities. Modifiers consume physical ingredients, but they only reflect in theoretical usage calculations when properly configured. Unmapped modifiers leave expected usage understated in reports, creating unexplained theoretical-to-actual food cost variance across trading periods.