# Actual vs theoretical food cost: reconcile the gap without counting waste twice

Reconcile actual vs theoretical food cost using a five-cause example, a downloadable variance worksheet and checks for overlapping waste and data errors.

> Actual food cost comes from stock and received purchases; theoretical food cost comes from recorded sales and recipe standards. Compare the same site, period, units and tax basis. Investigate the difference using non-overlapping evidence. A variance is not automatically avoidable waste, lost profit or recoverable savings.

Kivloo editorial team · 2026-10-29T08:11:27.763Z

## Make the two calculations comparable

Choose one site and a completed trading period. Freeze the count cutoff, sales export and recipe-cost version. Actual cost starts with opening food inventory plus received purchases minus closing inventory, adjusted consistently for transfers and other recorded movements. Purchases ordered but not received do not belong in the same calculation.

Theoretical cost is the sum of recorded sold quantities multiplied by the corresponding recipe standards. Check yields, portion units, modifiers and missing prices. Decide how staff meals and complimentary food are classified. A missing sales day is not proof of zero sales; a zero cost is not proof an ingredient was free.

[BCcampus · Monthly Food Costs](https://opentextbc.ca/basickitchenandfoodservicemanagement/chapter/monthly-food-costs/)

## Example record and review decision

Illustrative example in one currency: opening stock 4,000 + received purchases 15,000 − closing stock 3,000 gives recorded actual food cost 16,000, assuming no net transfers or other adjustments. Sales of 50,000 imply a 32% food-cost ratio. Recipe standards for those recorded sales produce theoretical cost 14,000, or 28%. The gap is 2,000 and four percentage points.

Four percentage points is not a four-percent relative increase. Use the same sales denominator for both ratios. The amounts are fictional and do not represent a Kivloo customer, an industry benchmark or a promise of savings. Food gross margin excludes labour, rent and other expenses.

## Explain five causes with separate evidence

A hypothetical investigation assigns 600 to price differences, 500 to recorded waste, 400 to portion or yield differences, 250 to staff meals outside the sold-recipe calculation, and 250 to an overstated count or cutoff. These five mutually exclusive amounts sum to 2,000. They are assigned only after reviewing their supporting records, not by splitting the total arbitrarily.

After verifying the 250 data error, corrected actual cost would be 15,750. The remaining 1,750 has operational explanations, but is still not a savings forecast. Staff meals may be intentional; price changes may be unavoidable; a portion difference may expose an outdated recipe. Keep corrections separate from changes in physical consumption.

## Prevent double counting and leave a residual

Waste already affects actual stock consumption. If its 500 is included in an ingredient-usage difference, do not add the same 500 a second time. Give each event an evidence reference and one primary explanation. Cross-reference overlapping rows, and include the amount in the bridge once.

Calculate unresolved residual as actual minus theoretical minus the signed, distinct explanations. Keep a nonzero residual visible. Do not create an invented cause just to reach zero, and allow negative adjustments when evidence supports them. A negative overall variance also needs review: timing, missing purchases or understated recipe standards may be responsible.

## Use the worksheet for a weekly review

Download the localized CSV and replace the fictional baseline and rows with your own period. Record amount, evidence, overlap reference, reviewer and decision. The file contains plain numbers and a blank entry row; it is a recording worksheet, not a live spreadsheet calculator. Recompute the bridge after changes.

Assign one action to the most useful verified cause: recount an ingredient, update a confirmed purchase price, observe portions or check an omitted sales mapping. Keep the original observation, correction date and reason. Compare the next complete period with similar sales mix and note menu, supplier and closure changes.

## Review the underlying records in Kivloo

Kivloo’s procurement beta compares recorded and recipe-based costs over completed trading days, shows missing inputs and provides amounts to investigate. Check opening counts, receipts, recipe standards and classified sales before interpreting a report. Do not add all investigation cards as independent savings.

Setup begins on web and requires a live connection. Document scanning and invoice workflows are web-only; internal purchase approval does not send an order to the supplier. Use the linked purchasing and margin guides to test the whole workflow, then check current product and pricing details for a limited pilot.

[Restaurant food cost software: find the margin gaps worth fixing](https://kivloo.com/en/guides/restaurant-food-cost-software-margins)

[Restaurant procurement software: what to test before you buy](https://kivloo.com/en/guides/restaurant-procurement-software)

[Restaurant food cost calculator: stock, transfers and sales](https://kivloo.com/en/guides/restaurant-food-cost-calculator)

[Restaurant stock transfers: reconcile quantities and landed cost](https://kivloo.com/en/guides/restaurant-stock-transfer-reconciliation)

[Restaurant food waste log: a practical UK template](https://kivloo.com/en/guides/restaurant-food-waste-log-uk)

[Kivloo · Procurement beta](https://kivloo.com/features#mobile-procurement)

## Food-cost variance reconciliation worksheet

Fictional example

| Type | Explanation | Signed amount | Evidence reference | Include in bridge | Overlap reference | Reviewer | Decision |
| --- | --- | --- | --- | --- | --- | --- | --- |
| explanation | Price differences | 600 | DEMO-PRICE | true |  |  | Fictional example |

[Download the variance CSV](https://kivloo.com/worksheets/food-cost-variance-en.csv)

## Does a 2,000 gap mean 2,000 can be saved?

No. It may include timing and data errors, planned staff meals, unavoidable price changes and overlapping explanations. Verify the causes before valuing an action.

## What should remain after reconciliation?

Any amount not explained by distinct evidence remains an unresolved residual. Zero is useful only when the records support it, not when a balancing plug forces it.

## Can actual food cost be below theoretical cost?

Yes. Check counts, purchases, sales mapping and current recipe standards before assuming unusually efficient operations.

## Continue reading

- [Food batch traceability: connect deliveries, ingredients and finished products](https://kivloo.com/en/guides/food-batch-traceability-records)

- [Restaurant food cost calculator: stock, transfers and sales](https://kivloo.com/en/guides/restaurant-food-cost-calculator)

- [Digital HACCP records: build a temperature log your team can actually use](https://kivloo.com/en/guides/digital-haccp-temperature-records)

- [Workplace safety inspections: turn findings into verified corrective actions](https://kivloo.com/en/guides/workplace-inspections-corrective-actions)

## Sources and further reading

- [BCcampus · Monthly Food Costs](https://opentextbc.ca/basickitchenandfoodservicemanagement/chapter/monthly-food-costs/)

- [GS1 · Global Traceability Standard](https://www.gs1.org/standards/traceability)

- [Kivloo · Procurement beta](https://kivloo.com/features#mobile-procurement)

Operational guidance, not a certification or a legal assessment. Adapt examples to your site, approved procedures and local requirements. Product links lead to the English website; this guide does not imply a fully translated application or verified hardware compatibility.

Canonical: https://kivloo.com/en/guides/actual-vs-theoretical-food-cost-reconciliation