Inventory Reconciliation Checklist
Weekly or period-end inventory reconciliation for a full-service restaurant. The chef or GM uses this to count physical product against the inventory system, investigate variance, and post adjustments before food cost reports the period.
Count Preparation
-
Freeze receiving and transfers
Stop all deliveries, transfers between locations, and back-of-house product movement before the count starts. Counting against a moving target is the single biggest source of false variance — schedule the count for after close or before open, when the line is cold and the walk-in is settled.
-
Pull the par sheet from MarginEdge
Export the count sheet from MarginEdge, R365, or your inventory tool — organized by storage location (walk-in, dry storage, bar, freezer) and walk-path order. A sheet sorted alphabetically wastes hours; a sheet sorted by where items physically live cuts count time in half.
-
Assign counters by storage zone
Two-person teams per zone: one counts, one records. Assign the bar to the bar lead, walk-in produce to the sous, dry storage to the prep lead. Counters should never count their own ordering zone — pair them across to keep the count honest.
-
Verify scales and measuring tools
Tare and zero the kitchen scales counters will use for partial cases and open containers. Confirm liquor measure (tenths of a bottle by sight, or a Bar-i scale for precision). Bad scales produce bad counts that look like shrinkage when posted.
Physical Count
-
Count walk-in and reach-in coolers
Count proteins by weight, not by piece — a half case of ribeye is a weight, not 6 portions. Note any product approaching its use-by date so it can be 86'd or featured. FIFO-reorder while you count; this is the one moment in the week the walk-in is fully audited.
-
Count freezer inventory
Pull cases forward to read counts on partial pallets. Note any product without a date label — undated freezer product is a food-safety flag for the next line check.
-
Count dry storage and paper goods
Count whole cases plus partial cases as a decimal (e.g., 2.4 cases of fryer oil). Include to-go containers, deli wrap, and chemicals if the inventory system tracks them — paper and chem are common silent cost-creep items.
-
Count bar liquor, beer, and wine
Liquor counted in tenths of a bottle by eye, or weighed on a Bar-i scale for higher accuracy. Beer kegs counted as full / partial (estimate by weight against tare). Wine by bottle, including the BTG opens behind the bar — opened wine still counts as inventory until poured.
-
Submit the completed count sheet
Upload the completed count sheet (PDF, photo of the paper sheet, or export from MarginEdge). This is the source-of-truth artifact for the variance review — if a number gets disputed later, this is what gets pulled.
Collects file
Variance Review
-
Match counts against theoretical usage
Theoretical usage = beginning inventory + purchases − ending inventory, compared to POS sales mix × recipe yields. Variance over 2% on a single item — or over 1% at the category level — is the threshold most operators investigate. Bar items above 5% variance almost always indicate over-pour or comp leakage.
-
Review recent vendor invoices for posting errors
Pull Sysco, US Foods, PFG, and produce-vendor invoices for the period. Common errors: case-pack changes (vendor switched from 4/1gal to 6/64oz and the system kept the old conversion), unposted credits, and short-shipped items signed for at full count. These show up as phantom shrinkage.
-
Flag any item with variance over the threshold
Flag any line where the recorded count differs from theoretical by more than the kitchen's set threshold (typically 2% by item, 1% by category, 5% on bar). If everything is within tolerance, skip the investigation step and proceed to posting.
Collects list -
Investigate flagged variance items
Walk the variance line by line with the chef or bar lead. Common root causes: unrecorded comps/voids, spoilage thrown without a waste log, over-portioning, recipe drift on new specials, theft, miscount on partial cases. Note the cause per item — "unknown shrink" is not an acceptable answer for a recurring variance.
Collects paragraph
Post Adjustments and Reporting
-
Log waste, spoilage, and comps
Enter the waste log into the inventory system separately from the count adjustment — they are different signals for food cost analysis. A protein tossed for being out of temp is waste; a protein you can't find is shrink. Conflating them hides the operational problem.
-
Post final counts to the inventory system
Enter the reconciled counts in MarginEdge or R365 so the closing food cost calculation reflects actual on-hand. Lock the period once posted — reopening to edit counts after the fact corrupts trend reporting.
-
Reconcile COGS to the GL
Tie the ending inventory value and computed COGS to the QuickBooks or Restaurant365 general ledger. Food cost percentage on the P&L should reconcile to the inventory system within a dollar. If it doesn't, the adjustment journal entry catches the difference and the variance gets investigated next period.
-
Publish the period food and beverage cost report
Capture the headline cost percentages for the period and attach the full reconciliation PDF. Most full-service kitchens target 28–32% food cost and 18–22% beverage cost; quick-service and bar-driven concepts trend differently. The trend over periods matters more than the single-period number.
Collects number Collects number Collects file
Corrective Action and Next Count
-
Assign owners to each root-cause finding
One named owner per finding. Over-pour at the bar gets the bar lead; recipe drift on new specials gets the sous; receiving short-counts get the manager who signs deliveries. Findings without an owner repeat next period.
-
Update recipe yields and pars in the system
If theoretical was off because the recipe in the system doesn't match what the line actually cooks, the recipe is wrong — fix it in MarginEdge or R365. Same for pars that consistently produce shorts or excess: adjust them now, while the data is in hand.
-
Schedule the next inventory count
Lock the next count on the schedule — weekly for bar and proteins, biweekly or monthly for dry storage in most operations. A count that drifts on the calendar drifts in accuracy; the discipline is the cadence.
Collects date