→ → →
The following Xenial Cloud Reports that are available in the Inventory category:
Report | Description |
|---|---|
Summarized information about discounted items. | |
Provides details on the inventory cost of goods sold based on the company or site level. | |
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 item purchases for a date or date range. | |
Summarized information about purchase orders for inventory items. | |
Summarized information about physical and terminal sales. | |
Summarized information about physical sales accounting with Revenue General Ledger (GL) Account line items. | |
General information about each product sold at sites. | |
Provides details about inventory item depletion/usage amounts in recipes. | |
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. | |
Details about current inventory item transfers to facilitate with inventory ordering. | |
Provides the transfer inventory item information from one site to other sites. |
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.
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. |
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. |
The Inventory Cost of Goods Sold provides details on the inventory cost of goods sold based on the company or site level. This report offers the ability to view the report data as a Company View or a Site View.
Submit the following parameters to generate the report:
Events | From the Event Selector, select the events to include. |
Calendar | Select the calendar icon NoteDates prior to January 6, 2025, are unavailable and cannot be selected. |
Costing Method | From the Costing Method dropdown, select Last Purchase or Moving Average. |
Search | Identify a specific inventory item to include by name or item ID number. |
The following describes the columns on the report:
Item ID | ID number of item. |
Item Name | Name of item. |
Event Name | Name of event. |
Chargeable | Flag that indicates if the sale is chargeable. |
GL Account | General ledger account associated with the site and item. |
Unit Cost | Unit cost of the item. This field is calculated based on the Costing Method selected in the Parameters. |
Physical Quantity | Physical inventory counts. |
Physical Sales | Physical sales information. |
Physical COGS | Physical cost of goods sold. This field is calculated based on the Costing Method selected in the Parameters. |
Terminal Quantity | Terminal inventory counts. |
Terminal Sales | Terminal sales information. |
Terminal COGS | Terminal cost of goods sold. This field is calculated based on the Costing Method selected in the Parameters. |
Spoilage Qty | Spoilage quantity. |
Spoilage Cost | Spoilage cost. This field is calculated based on the Costing Method selected in the Parameters. |
Gratis Qty | Gratis quantity. |
Gratis Cost | Gratis cost. This field is calculated based on the Costing Method selected in the Parameters. |
Order Taxes | Order taxes applied to goods sold. |
The Inventory Count report provides detailed information about physical inventory counts.
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. |
Unit Option | From the dropdown, select the inventory unit option from the following: Report Measure, Default Recipe Unit, Default Transfer Unit, or Default Ordering Unit. |
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. |
Physical Count Unit | The measure which is used to do the inventory count. |
Count | The count amount of the inventory item. |
Manager Count | The quantity which is equal to the count divided by the selected Unit Option's factor value. If the selected Unit Option does not exist, use the reporting measure to calculate. NoteThe Manager Count changes when a different Unit Option is chosen. |
UOM | Unit of measurement. |
Counted Value | The dollar amount which is equal to the count multiplied with the cost of the inventory item. |
Starting QOH | The starting amount of quantity on hand. |
Extended Value | Extended value of the inventory. |
Variance Quantity | Variance quantity. |
Variance Cost | Variance cost. |
The Inventory Item Listing report provides general information about each inventory item.
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
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. |
The Inventory on Hand report offers the ability to view the report data as a Company View or a Site View.
Submit the following parameters to generate the report:
Search | Identify a specific inventory item to include by name or item ID number. |
Calendar | Select the calendar icon If a date is selected, the quantity on hand (QOH) and unit cost data are of that date. The default setting is the current date. NoteDates prior to October 25, 2024, are unavailable and cannot be selected. |
Unit Option | From the dropdown, select the inventory unit option from the following: Report Measure, Default Recipe Unit, Default Transfer Unit, or Default Ordering Unit. |
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 (UOM) associated with the item |
Site Name | Name of the site |
Unit Cost | Unit cost of the item |
QOH | Quantity on hand (QOH) of the item |
Extended Cost | Extended cost of the item |
The Inventory Purchase Summary Report provides a summary of item purchases for a specific date or date range.
Submit the following parameters to generate the report:
Vendors | From the Vendor Selector, select the vendor to include. |
Calendar | Select the calendar icon |
Measure | From the Measure Selector, select Base Measure or Reporting Measure. |
The following describes the columns on the report:
Vendor | Name of vendor |
Major Category | Item major category |
Minor Category | Item minor category |
GL Account | General Ledger (GL) account associated with the item |
Item ID | ID number of item |
Item Name | Name of item |
Measure | Item measurement (UOM) |
Received Quantity | Quantity of the inventory item that is received |
Total Received Cost | Total cost of items received |
The Order Summary report summarizes information about purchase orders for inventory items.
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. |
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. |
The Physical/Terminal Sales report provides summarized information about physical and terminal sales.
View report data as a Company View or a Site View.
Filter the report by Chargeable, Non-Chargeable and/or All Items. Sort and Group by Filter options.
Submit the following parameters to generate the report:
Events | From the Event Selector, select the events to include. |
Search | Identify a specific inventory item to include by item ID number. |
Calendar | Select the calendar icon |
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 Date | Date 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 | |
Chargeable | Flag that indicates if the sale is chargeable | |
GL Account | General ledger account | |
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 received |
During Event In | During event transfers received | |
During Event Out | During event transfers sent | |
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 | |
The Physical Sales Accounting report provides summarized information about physical sales accounting with Revenue General Ledger (GL) Account line items.
Submit the following parameters to generate the report:
Events | From the upper-left pane under Events, select the events to include. The default is set to All Events. |
Calendar | From the the upper-left pane under Calendar, select the date range. If an event is selected, the Calendar field is disabled. |
Site Hierarchy - Level | From the upper-left pane under Site Hierarchy - Level, select the site hierarchy name and level. The default is set to All. |
Revenue GL Accounts | From the upper-left pane under Revenue GL Accounts, select the Revenue GL account type. The default is set to All. |
The following describes the columns on the report:
Site Hierarchy | The first level of the site hierarchy |
Hierarchy Level | The site hierarchy level |
Revenue GL Account | The list of Revenue GL account names |
Physical Sales $ | The physical sales dollar amount |
Sales % | The percentage of physical sales per GL Account compared to the total |
Credit | Spread the total Credit by the corresponding percentage per GL account |
Cash | Spread the total Cash by the corresponding percentage per GL account |
Custom | Spread the total Custom by the corresponding percentage per GL account |
Other | Spread the total Other by the corresponding percentage per GL account |
Tips | Spread the total Tips by the corresponding percentage per GL account |
Total Receipts | The amount of total payments |
Variance | The variance of total receipts to physical sales |
Tax | Spread the total Tax by the corresponding percentage (%) per GL account |
Net Receipts | The Total Receipts subtracting the Receipt Tax |
The Product Listing report provides general information about the products sold at company sites.
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. |
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. |
The Recipe Depletion report provides details about inventory item depletion/usage amounts in recipes. This report data may be viewed in Company View or Site View.
Submit the following parameters to generate the report:
Events | From the Event Selector, select the event. |
Sites | From the Site Selector, select the sites to include. |
The following describes the columns on the report:
Site Name | Name of site | |
Order | Close Date/Time | Closing date and time of order |
Business Date | Business date of order | |
Order Number | Order number identifier | |
State | Progress of order | |
Type | Order type | |
Cost | Order cost | |
Taxes | Taxes applied to order | |
Discounts | Discounts applied to order | |
Product | Name | Product name |
ID | Product ID | |
State | Product state | |
Type | Type of product | |
Unit Price | Unit price of product | |
Qty | Product quantity | |
Price | Product price | |
Taxes | Taxes applied to product | |
Discount | Discounts applied to product | |
Recipe | Name | Recipe name |
ID | Recipe ID | |
Cost | Cost of recipe | |
Inventory Item | Name | Item name |
ID | Item ID | |
Major Category | Major category of item | |
Minor Category | Minor category of item | |
Measure | Item measurement (UOM) | |
Qty | Item quantity | |
Cost | Item cost | |
Taxes | Taxes applied to item | |
Discounts | Discounts applied to item | |
The Sales Detailed Report (SDR) contains detailed net and gross sales information with totals for various categories including destination sales and discounts.
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. |
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. |
The Sales Over Short report provides summarized sales information that identifies the difference between the receipt totals and physical totals.
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. |
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. |
The Stand Worksheet Closing report provides detailed closing sales information.
See Stand Worksheet Formula Versions for additional information.
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. |
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 |
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 |
The Transfer Summary report provides summarized information about inventory items transferred to another site.
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.
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. |
Qty Requested* | Requested transfer quantity. |
Qty 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, including the total quantity of reversed transfer items. |
* Only appears on Site Type View.
The Transfers by Item report provides details about current inventory item transfers to facilitate with inventory ordering.
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Unit Option | From the dropdown, select the inventory unit option from the following: Report Measure, Default Recipe Unit, Default Transfer Unit, or Default Ordering Unit. |
The following describes the columns on the report:
Site From | Site ID of the sending location. |
Site To | Site ID of the receiving location. |
Transfer Date | Date of transfer. |
Status of the transfer. | |
Type of transfer. | |
Transfer ID | Assigned ID. |
Event Name | The event name. |
Item Number | ID number of the inventory item that was transferred. |
Item Name | Name of the inventory item that was transferred. |
Request Cost | Cost of transfer. |
Received Cost | Cost of items received. |
Cost Difference | Difference between the Request Cost and the Received Cost. |
Qty Requested | Quantity of the inventory item that is requested for transfer. |
Qty Received | Quantity of the inventory item that is received for transfer. |
Qty Difference | Difference between the Qty Requested and the Qty Received. |
Measure | The reporting UOM. |
Supplier Name | Identifies who supplied the inventory item. |
GL Account | General Ledger account associated with the transfer. |
QOH - From | Quantity On Hand at the location where the item is transferred from. |
QOH - To | Quantity On Hand at the location where the item is transferred to. |
On-Hand Inventory | Blank column for manual Quantity On Hand entry. |
The Transfer Pick Sheet Report provides the transfer inventory item information from one site to other sites. Based on the user's From Site selection, the system calculates the total number of items that need to be picked to transfer to the other sites. The report replaces negative numbers with 0 to allow the user to see the total amount of items needed from the warehouse.
Submit the following parameters to generate the report:
Events | From the Event Selector, select the events to include. |
From Site | From the Site Selector, select the site to include. |
To Site(s) | From the Site Selector, select the site(s) to include. |
Transfer Type | From the Transfer Type Selector, select to include Pre-Event Transfer, During Event Transfer, both, or Unselect All. All transfer types are selected by default. |
Major Category | From the Major Category Selector, select from the category list or unselect all. All categories are selected by default. |
Minor Category | From the Minor Category Selector, select from the category list or unselect all. All categories are selected by default. |
The following describes the columns on the report:
Item ID | ID number of item. |
Item Name | Name of item. |
OUM | Unit of measure (UOM) for ordering unit. |
Total | The total number of items that need to be transferred. |