Checklist
Period food cost reconciliation checklist
Review matching period cutoffs, inventory values, purchases, recipe records, and documented adjustments before interpreting food-cost variance.
Overview
A period review compares records that must share the same dates, location, food scope, valuation basis, and sales denominator. Inventory-based food used is not the same measure as a menu item's recipe cost percentage. Actual-versus-theoretical comparison also needs documented adjustments that were included in actual use and have not already been removed. This checklist records review evidence and follow-up; it does not calculate a variance or diagnose its cause.
How to review a period food-cost difference
- Fix the period and scope. Record location, start and end dates, cutoff, food scope, and valuation basis. Confirm that the sales denominator covers the same period and food category.
- Reconcile inventory and purchases. Check beginning and ending inventory counts, purchase records, returns, transfers in and out, and cutoff timing. Resolve unit or movement differences before interpreting a ratio.
- Check theoretical records. Match menu sales quantities to recipe versions, component quantities, portions, and ingredient-cost dates used for the same period.
- Confirm each adjustment once. Subtract recorded waste or approved non-sale use only when it is included in actual food use and was not already deducted. Combined adjustments cannot exceed actual use.
- Record unresolved questions. List source records, review outcomes, and a follow-up owner. A remaining difference is a signal to investigate records, not a diagnosis.
Your review record
Fill in your own records, then print or download them. Fields are optional. No costs, quantities, percentages, or totals are calculated. Entries stay in this page and are not saved by this site. Keep a downloaded or printed copy if you need the record later.
Period food cost review record
- Location / cost scope
- ________________
- Period and cutoff
- ________________
- Reviewer / review date
- ________________
Review item 1
- Review item
- ________________
- Supporting record reference
- ________________
- Review result / status
- ________________
- Follow-up owner
- ________________
- Unresolved question / action
- ________________
Reconcile actual and theoretical food cost on one basis
- Align Period and scope
Dates, location, food basis, valuation, and sales.
- Calculate Actual food used
Beginning inventory + purchases + transfers in − transfers out − ending inventory.
- Compare Theoretical cost
Recipe-derived cost for matching sales and recipe versions.
- Adjust Document once
Remove eligible waste/non-sale use already included in actual.
- Review Follow up
Record remaining questions; do not infer a cause from arithmetic.
Keep the two period measures separate
The actual food-used calculation and the adjusted variance use related records but answer different questions.
| Measure | Formula | Required alignment | Interpretation |
|---|---|---|---|
| Actual food used | Beginning + purchases + transfers in − transfers out − ending | Same period, location, food scope, and valuation basis | Inventory-based food consumption on the entered basis. |
| Actual food-used percentage | Actual food used ÷ matching food sales × 100 | Food sales match the same period and exclude tax/fees | Period ratio; not a menu-item recipe percentage. |
| Gross actual/theoretical variance | Actual food cost − theoretical food cost | Both amounts cover comparable food, period, and basis | Dollar difference before eligible adjustments. |
| Unexplained remainder | Gross variance − eligible documented adjustments | Adjustments are included in actual use and subtracted once | Review signal, not a cause diagnosis. |
Match the period and scope
Use the same date range, cutoff, location, and food-only scope. A menu-item ingredient ratio and an inventory-based period ratio are different measures.
Check inventory and purchases
Review physical counts, purchase units, receipts, returns, transfers, and inventory movements. Reconcile timing and valuation differences before calculating a period percentage.
- Confirm opening and closing inventory use a consistent reviewed value basis; investigate missing or duplicate items.
- Check case-to-inner-unit relationships against actual invoice specifications.
- Match purchases and returns to the cutoff. Record transfers in and out separately.
- Keep non-food supplies and directly assignable packaging separate from food values.
Check the theoretical recipe records
Trace theoretical cost to matching sales quantities, recipe versions, component amounts, and ingredient units for the period.
- Check missing recipe associations and incorrectly matched item names.
- Verify portion definitions and changed recipe or purchase specifications.
- Identify approved non-sale use and recorded waste separately. Do not assume a variance measures waste.
Prevent duplicate adjustments
Subtract documented waste or approved non-sale usage only when it remains inside actual food use and has not been removed elsewhere. Combined adjustments cannot exceed actual use.
Worked example: align a period and adjust once
A period has $10,000 beginning inventory, $25,000 purchases, $500 transfers in, $250 transfers out, and $11,000 ending inventory. Matching food sales are $80,000. The same-basis theoretical cost is $21,000; $400 recorded waste and $100 approved non-sale use are already included in actual food use.
Inputs
- Beginning inventory
- $10,000
- Purchases
- $25,000
- Transfers in / out
- $500 / $250
- Ending inventory
- $11,000
- Theoretical cost
- $21,000
- Eligible adjustments
- $400 waste + $100 other approved use
- Matching food sales
- $80,000
- Actual food used = $10,000 + $25,000 + $500 − $250 − $11,000 = $24,250.
- Actual food-used percentage = $24,250 ÷ $80,000 × 100 = 30.3125%, displayed as 30.31%.
- Gross variance = $24,250 − $21,000 = $3,250.
- Unexplained remainder = $3,250 − $400 − $100 = $2,750; $2,750 ÷ $80,000 × 100 = 3.4375 percentage points, displayed as +3.44 points.
- Actual food used: 10,000 + 25,000 + 500 − 250 − 11,000 = $24,250
- Unexplained share: 2,750 ÷ 80,000 × 100 = +3.44 percentage points
Result: $2,750.00 unexplained variance (+3.44 percentage points)
The period percentage displays to two decimals. Dollar variance displays to cents; the percentage-point remainder is calculated from unrounded amounts and rounded to two decimals. Subtract only eligible amounts already included in actual food use.
Record what remains unresolved
Record supporting documents, unresolved questions, and a follow-up owner. Confirm that dates and cost bases match and that each adjustment is counted once. A remaining difference does not establish its cause.
Interpret the remainder as a review signal
A percentage is comparable only when period, food scope, inventory valuation, and sales denominator align. Confirm counts, purchases, recipe records, and eligible adjustments before follow-up. The arithmetic does not prove waste, theft, portion error, or another cause.