Physical Inventory Summary

The Physical Inventory Summary displays the inventory data for each product for the selected post period(s). It defaults to being summarized by storage location, so users can see subtotals by storage as well as the grand total for the location. The inventory data can be viewed either by "Quantity" (number of inventory units) or by "Value" (each quantity multiplied by the product’s cost).

If the location uses lot tracking, the report can be grouped by "Storage Location-Lot," which will show a separate row for each product/lot combination in each storage. It can also be filtered for a specific lot number. Click HERE for details.

Menu Paths: Net-Chef > Inventory: Reports > Physical Inventory Summary
Menu Paths: Net-Chef > Reports: Inventory > Physical Inventory Summary

Transactions Included: Inventory, Inventory Variances

Report Controls

Location: (Cruise, Corporate only) – Select the desired location from the drop-down

From/To: Drop-downs; can select Post Period dates, including the current period after the Final for Post inventory has been reviewed

View By: Value (in Location currency), Quantity (in inventory units), Custom (user-selected columns; default)

Group By: Storage Location (default), Product, Category, Subcategory, Microcategory, GL Code - Description; enabled when "Summarize" is unchecked

Summarize: Product (default), Category, Subcategory, Microcategory, GL Code - Description

Funnel (Filters): Any report column; Storage Location, Product Type, GL Code/Description, User Defined Category, Storage Type, Category/Subcategory/Microcategory, Lot (if applicable), On Hand <> 0, Order Activity

Printer (Export): PDF, Excel, CSV formats

Report Columns (default view):

Click any column header to sort by the data in that column.

Product Number – The company product number.
Product Name – The company product name.
Unit Price – The current Inventory Cost of the product at the current location. Appears as a hyperlink; click to view cost change details for the selected product.
Unit – The company product inventory unit.
Begin Quantity/$ – The amount on hand at the beginning of the post period.
Received Quantity/$ – Includes all reconciled incoming orders, finalized daily prep, and incoming transfers; also includes vendor returns (which reduce total incoming vendor orders).
Sold Quantity/$ – Includes POS Depletion, Buffet Consumption, and reconciled outgoing commissary/customer orders.
Adjusted Quantity/$ – Includes inventory adjustments (manually entered or system-generated for Buffet Consumption waste), mid-period variances, production depletion, outgoing location transfers, and incoming/outgoing storage transfers.
Book Quantity/$ = [ Begin + Received – Sold – Adjusted ]
Physical Quantity/$ – Actual On Hand quantity/value for counts entered during Physical Inventory.
In Transit Quantity/$ – Includes unreconciled outgoing commissary/customer orders & location transfers.
Variance Quantity/$ = [ Physical Qty + In Transit Qty – Book Qty ]
Variance $ = [ Physical Value + In Transit Value – Book Value ]
Cumulative Variance – The sum of all variances for each included post period; this includes mid-period variances (which also appear in the "Adjusted" column.)

Additional Columns (hidden by default):

Category – The category assigned to the company product.
Subcategory – The subcategory assigned to the company product.
Microcategory– The microcategory assigned to the company product.
GL Code/Description – The GL Code/Description associated with the company product's assigned category.
Inventory Change Quantity/$ = [ Beginning – Physical ]
Retail Price – The "Standard" Retail Price from the Location Product record.
Retail Book $ = [ Book Quantity x Retail Price ]
Retail Physical $ = [ Physical Quantity x Retail Price ]
Retail Variance $ = [ Retail Book $ – Retail Physical $ ]