Skip to main content

Track COGS Variance

COGS variance shows the gap between what your recipes say your sales should have used (theoretical) and what actually left your stock, so you can spot waste, over-portioning, theft, or a mis-costed recipe.

How the data is produced​

Every night Biznsbook reads yesterday's POS sales in your restaurant time zone, matches each sold item to its Active recipe, and records the ingredients, including waste %, those sales should have used. "Actual" is the stock that left inventory for those ingredients in the same period: sales, stock adjustments, delivery notes, and recipe depletion.

Ingredients inside sub-recipes are not expanded in these snapshots, although recipe costing does roll sub-recipes up.

Read the variance report​

  1. Open Analytics & Reports → COGS Variance.
  2. Set Date From and Date To (the default is the last 7 days) and optionally a Warehouse, then choose Apply. With no warehouse chosen, the comparison uses your default depletion warehouse if one is set.
  3. Read the cards for total theoretical cost, total actual cost, and overall variance %, then the ingredient table with the biggest variances first. Variance % is red over 20%, amber 10 to 20%, and green under 10%. A positive variance means you used more than the recipe predicts.
  4. Choose Export to Excel for the grid.
  5. With Manage Recipes, choose Recalculate to rebuild snapshots for the selected range (up to 92 days), for example after fixing a recipe.

Start with large positive variances on costly ingredients. If the report is empty, there are no snapshots yet. Recalculate, and check that sold items are the output items of Active recipes.

See the trend​

Open Analytics & Reports → COGS Dashboard for the coverage of the range, a theoretical-versus-actual line per day, and the top 5 variance items.

Next step​