Inventory Reports
→ → →
The following introduces the Xenial Cloud reports that are available in the Inventory category.
Report | Description |
|---|---|
Summarized information about discounted items. | |
Detailed information about physical inventory counts. | |
General information about each inventory item. | |
Summarized information about the quantity of inventory items on-hand. | |
Summarized information about purchase orders for inventory items. | |
Summarized information about physical and terminal sales. | |
General information about each product sold at sites. | |
Detailed net and gross sales information with totals for various categories including destination sales and discounts. | |
Summarized sales information that identifies the difference between the receipt totals and physical totals. | |
XVI Stand Worksheet with detailed closing sales information. | |
Summarized information about inventory items transferred to another site. |
Discount Summary
The Discount Summary report contains summarized information about discount totals for selected sites for the specified time range, so that an operator can audit discounted orders.
Parameters
Submit the following parameters to generate the report:
Events | From the Event Selector, select the events to include. |
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Group By | From the dropdown, select the values by which to group the items on the report. For example, select Business Date and Site to group the items on the report by the associated business date and site. |
Column Descriptions
The following describes the columns on the report:
Discount Code | ID code for the discount. |
Discount Name | Name of the discount. |
Discounts Applied | Quantity of discounts applied. |
Discount Item Quantity | Quantity of products that were discounted. |
Discount Amount | Currency amount of discount. |
Net Sales | Net currency amount of sold products (includes refund transactions). |
% of Net Sales | Percentage of Net Sales that is attributable to the Discount Amount. |
Gross Sales | Gross currency amount of sold products. |
% of Gross Sales | Percentage of Gross Sales that is attributable to the Discount Amount. |
Completely Discounted Products | Quantity of instances where an item price was discounted at 100% and reduced to 0.00. |
Total | Totals for each applicable column. |
Inventory Count
The Inventory Count report provides detailed information about physical inventory counts.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Search | Identify a specific inventory item to include by name or item ID number. |
Column Descriptions
The following describes the columns on the report:
Unique Inventory Count Total | Quantity of returned data rows. |
Start Date/Start Time | Count start date and time. |
Count Name | Name of count. |
Site Name | Name of the site. |
Item Name | Name of item. |
Item ID | ID of item. |
Major Category | Item major category. |
GL Account | General ledger account associated with the site and item. |
Unit Cost | Unit cost of the item. |
Ordering Unit | Unit of measurement (UOM). |
Ordering Unit Count | Quantity of item at using UOM. |
Inventory Item Listing
The Inventory Item Listing report provides general information about each inventory item.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Column Descriptions
The following describes the columns on the report:
Returned Row Count | Quantity of returned data rows. |
Item Name | Name of item. |
Item ID | ID of item. |
Major Category | Item major category. |
Minor Category | Item minor category. |
GL Account | General ledger account associated with the site and item. |
Ordering Unit | Unit of measurement (UOM). |
Vendor | Item vendor. |
Unit Cost | Unit cost of the item. |
Inventory on Hand
The Inventory on Hand report offers the ability to view the report data as a Company View or a Site View.
Parameters
Submit the following parameters to generate the report:
Search | Identify a specific inventory item to include by name or item ID number. |
Column Descriptions
The following describes the columns on the report:
Item Name | Name of item. |
Site Type | Type of site. |
Item ID | ID of item. |
GL Account | General ledger account associated with the site and item. |
Major Category | Item major category. |
Vendor | Vendor associated with the site and item. |
Measure | Unit of measurement associated with the item. |
Site Name | Name of the site. |
Unit Cost | Unit cost of the item. |
QOH | Quantity on hand of the item. |
Extended Cost | Extended cost of the item. |
Order Summary
The Order Summary report summarizes information about purchase orders for inventory items.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Search | Identify a specific purchase order ID. |
Column Descriptions
The following describes the columns on the report:
Returned Row Count | Located above the report, the number of returned data rows. |
Purchase Order No. | System-created purchase order number. |
Vendor | Vendor for the order. |
Warehouse | Location within the venue receiving the order items. |
Order Date | Order date. |
Delivery Date | Expected delivery date. |
External Ref. No. | External Reference Number. |
Invoice Number | Assigned invoice number. |
Grand Total | Grand total of the entire order. |
Physical/Terminal Sales
The Physical/Terminal Sales report provides summarized information about physical and terminal sales.
Parameters
Submit the following parameters to generate the report:
Events | From the Event Selector, select the events to include. |
Sites | From the Site Selector, select the sites to include. |
Column Descriptions
The following describes the columns on the report:
Report Header | Description | |
|---|---|---|
Header | Returned Sales Count | Located above the report, the number of returned data rows. |
Event Name | Name of event. | |
Event Time | Time of event. | |
Main | Site Name | Name of site. |
Status | Event status. | |
Item ID | ID number of item. | |
Item Name | Name of item. | |
Unit Price | Unit price of item. | |
Begin Count | Starting item count. | |
Adjustments | Item adjustments. | |
Ending Count | Ending item count. | |
Transfers | Pre-event In | Pre-event transfers in. |
During Event In | During event transfers in. | |
During Event Out | During event transfers out. | |
Total | Total transfers. | |
Gratis | Qty | Gratis quantity. |
Amount | Gratis amount. | |
Spoilage | Qty | Spoilage quantity. |
Amount | Spoilage amount. | |
Physical Sales | Qty | Physical sales quantity. |
Amount | Physical sales amount. | |
Terminal Sales | Qty | Terminal sales quantity. |
Amount | Terminal sales amount. | |
Variance | Qty | Variance quantity. |
Amount | Variance amount. | |
Product Listing
The Product Listing report provides general information about the products sold at company sites.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Search | Identify a specific product to include by product ID. |
Column Descriptions
The following describes the columns on the report:
Returned Row Count | Located above the report, the number of returned data rows. |
Site Name | Name of site. |
Product Name | Name of product. |
Product ID | ID number for the product. |
Major Category | Product major category. |
Minor Category | Product minor category. |
Product Type | Type of product. |
Revenue GL Account | Revenue GL account associated with product. |
Linked Recipe Name | Recipe linked to product. |
Recipe ID | ID number for the recipe. |
Chargeable | Indicates if product is chargeable. |
Chargeable Unit Cost | Chargeable unit cost of product. |
Product Price | Price of product. |
Recipe Cost | Cost of recipe using adjusted cost formula. |
Margin | Product margin. |
Margin Percentage | Margin in percentage. |
Sales Detailed Report
The Sales Detailed Report (SDR) contains detailed net and gross sales information with totals for various categories including destination sales and discounts.
Parameters
Submit the following parameters to generate the report:
Events | From the Event Selector, select the events to include. |
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Group Option | From the dropdown, select the items to display on the report. |
Column Descriptions
The following describes the columns on the report:
Sales Breakdown | Breakdown of the Gross Sales calculation including the Net Sales total. |
Drawer Count Variance | Currency amount of the variance between the expected drawer count total and the actual drawer count total. |
Destination Sales | Total sales for each order destination. |
Discount Totals | Total currency amount in applied discounts (does not include promos or walkouts). |
Tax Totals | Total currency amount in applied taxes. |
Pay Type Totals | Total sales for each pay type; the Rounded Adjustments subsection contains totals for currency that was rounded at the POS. |
Tip Totals | Total currency amount in customer tips. |
Cancel/Voids | Total currency amount in canceled items and voids. |
Deposits Variance | Total variance between the expected deposit total and the actual deposit total. |
Saved | Breakdown of the Saved Sales calculation. |
Other Statistics | Total currency amount in non-taxed item sales and gift card cash out transactions. |
Liability Items | Total currency amount in gift card and gift certificate sales. |
Donations | Total currency amount in customer donations. |
Order Source | Total sales for each order source. |
Net Sales By Day Part | Total net sales for each day part. |
Sales Over Short
The Sales Over Short report provides summarized sales information that identifies the difference between the receipt totals and physical totals.
Parameters
Submit the following parameters to generate the report:
Events | From the Event Selector, select the events to include. |
Sites | From the Site Selector, select the sites to include. |
Column Descriptions
The following describes the columns on the report:
Returned Row Count | Located above the report, the number of returned data rows. |
Site Name | Name of site. |
Status | Status of event. |
Cash Sales | Cash sales count. |
Credit Sales | Credit sales count. |
Cashrm | Cash room totals. |
Others | Other sales totals including gift cards and/or custom payments. |
Total | Total sales amount. |
Tips | Total tips. |
Receipt Totals | Receipt total. |
Physical Sales | Physical sales total. |
Terminal Sales | Terminal sales total. |
Receipt/Physical | Difference between receipt total and physical total. |
Receipt/Terminal | Difference between receipt total and terminal total. |
Phys/Terminal | Difference between physical total and terminal total. |
Stand Worksheet Closing
The Stand Worksheet Closing report provides detailed closing sales information.
Parameters
Submit the following parameters to generate the report:
Events | From the Event Selector, select the events to include. |
Sites | From the Site Selector, select the sites to include. |
Column Descriptions
The following describes the columns on the report:
Returned Row Count | Located above the report, the number of returned data rows. |
Site Name | Name of site |
Status | Status of event |
Physical Sales | Physical sales count |
Terminal Sales | Terminal sales count |
Phys/Terminal Diff | Count difference between physical and terminal totals |
Phys/Terminal Diff % | Percentage difference between physical and terminal totals |
Cash Count | Cash count total |
Receipt/Physical Diff | Count difference between receipt and physical totals |
Receipt/Physical Diff % | Percentage difference between receipt and physical totals |
Cash/Terminal Diff | Count difference between cash and terminal totals |
Cash/Terminal Diff % | Percentage difference between cash and terminal totals |
Credit/Gift Cards | Credit/Gift card totals |
Tips | Tips totals |
Total Discounts | Total discounts applied |
Fees/Other | Fees and or other sales totals |
Post-closure Sales | Sales occurring after closing the stand worksheet |
Post-closure Credit/Gift Cards | Credit/Gift card sales occurring after closing the stand worksheet |
Post-closure Tips | Tips accepted after closing the stand worksheet |
Post-closure Terminal Cash | Cash accepted after closing the stand worksheet |
Post-closure Discounts | Discounts applied after closing the stand worksheet |
Transfer Summary
The Transfer Summary report provides summarized information about inventory items transferred to another site.
Parameters
Submit the following parameters to generate the report:
Calendar | Select the calendar icon |
Search | Identify a specific inventory transfer by ID. |
The Transfer Summary report offers the ability to view the report data in Summary View or Site Type View. From the Select View dropdown, select the desired view type.
Column Descriptions
The following describes the columns on the report:
Transfer Count Total | Located above the report, the number of returned data rows. |
Event | The event name |
Transfer Date | Date of transfer |
Transfer ID | Assigned ID |
Status of the transfer | |
From (Type) | Location type. |
From (Name) | Location name. |
From (ID) | Site ID of the sending location |
To (Type) | Location type. |
To (Name) | Location name. |
To (ID) | Site ID of the receiving location |
Type of transfer | |
Reporting Measure* | The UOM. |
Quantity Requested* | Requested transfer quantity. |
Quantity Received* | Received transfer quantity. |
Received Cost* | Cost of items received. |
Cost | Cost of transfer. |
Total Cost | Total cost of all listed transfers located at the end of the section of the report. |
* Only appears on Site Type View.