The Retail Count Variance report allows you to generate a report that compares the theoretical inventory number to the actual inventory from a physical count. This feature works similarly to the Inventory Count Variance report.
See report options for the Inventory Count Variance report.
Each item is identified by its Description and/or Item # at the beginning of the row. Most fields can be displayed alternatively in dollars or quantity, depending on the report options selection. The following descriptions assume a quantity selection, but the description is much the same if Costs were selected.
Note: The math used to calculate the Theoretical Ending Inventory is shown in the column headers.
Beg Inv Displays the beginning inventory on the day before the From date selected for the report, based on the post type selected (valuation or inventory counts).
Receiving Shows the quantity received (through AP Invoices or Manual Checks) during the date range specified.
Xfers In Shows the quantity of inter-store transfers received during the specified time period.
Xfers Out Shows the quantity transferred out by inter-store transfers during the specified time period.
Waste Damage Shows the amounted wasted during the specified time period.
Sales Shows the total quantity of the item used during the date range. In addition to sales polled from the POS, this also includes inventory transfers and waste/donations.
Theo End Inv Shows the theoretical ending inventory — the quantity expected based on all of the inventory-affecting transactions made in Compeat. Calculated as Beg Inv + Receiving + Xfers In - Xfers Out - Sales (when Add Across is selected in report options). Calculated as (Actual Ending Inventory dollars/Actual Ending Inventory quantity) x Theoretical Ending Inventory quantity (when Use Actual Ending Inv $ is select in report options).
Actual End Inv Shows the counted quantity. This is the last posted quantity from either valuation or order counts, depending on the report options selected.
Variance Shows the difference between the theoretical quantity and the actual quantity. Calculated as Ending Inv - Theo Ending Inv.
On Order or Xfer Shows items in unreceived orders and inter-store transfers.
Cost Each Displays the Inventory Unit Cost (also shown on the Restaurant Inventory screen, Restaurant Information tab).
Cost Value Represents the value of the inventory on-hand for the item, based on the cost of the item. Calculated as Cost Each x Actual Ending Inventory.
Retail Each Displays the selling price per unit. Calculated by dividing the selling price (from the Advanced tab of Restaurant Inventory Items) by the number of base units in a selling unit.
Retail Value Represents the value of the inventory on-hand for the item, based on the retail selling price. Calculated as Retail Each x Actual Ending Inventory.