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.

5 sections 20 steps Collects data
1

Count Preparation

  1. 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.

  2. 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.

  3. 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.

  4. 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.

2

Physical Count

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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
3

Variance Review

  1. 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.

  2. 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.

  3. 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
  4. 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
4

Post Adjustments and Reporting

  1. 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.

  2. 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.

  3. 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.

  4. 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
5

Corrective Action and Next Count

  1. 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.

  2. 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.

  3. 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.


Sections 5
Steps 20
Category Restaurant
Price Free to start
Need a different process

Browse hundreds of free templates across every team and industry.

Back to template library

Run Inventory Reconciliation Checklist with your team

Customize the steps, assign roles, set a schedule, and keep a complete record for every run.