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
Use this template
Copy it to your account, customize the steps, and run it with your team in minutes.
Browse hundreds of free templates across every team and industry.
Back to template libraryRelated templates
More workflows your team can run.
Run Inventory Reconciliation Checklist with your team
Customize the steps, assign roles, set a schedule, and keep a complete record for every run.