Skip to main content

Xenial Product Documentation

Inventory Reports

Xenial Cloud Portal 4-Dot Menu Reports Inventory

The following Xenial Cloud Reports that are available in the Inventory category:

Report

Description

Discount Summary

Summarized information about discounted items.

Inventory Count

Detailed information about physical inventory counts.

Inventory Item Listing

General information about each inventory item.

Inventory on Hand

Summarized information about the quantity of inventory items on-hand.

Order Summary

Summarized information about purchase orders for inventory items.

Physical/Terminal Sales

Summarized information about physical and terminal sales.

Product Listing

General information about each product sold at sites.

Recipe Depletion

Provides details about inventory item depletion/usage amounts in recipes.

Sales Detailed Report

Detailed net and gross sales information with totals for various categories including destination sales and discounts.

Sales Over Short

Summarized sales information that identifies the difference between the receipt totals and physical totals.

Stand Worksheet Closing

XVI Stand Worksheet with detailed closing sales information.

Transfer Summary

Summarized information about inventory items transferred to another site.

Transfers by Item Report

Details about current inventory item transfers to facilitate with inventory ordering.

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 Calendar_Icon.png to select the period/dates to include.

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 Calendar_Icon.png to select the period/dates to include.

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 Calendar_Icon.png to select the period/dates to include.

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.

Recipe Depletion

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.

Parameters

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.

Column Descriptions

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

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 Calendar_Icon.png to select the period/dates to include.

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.

See Stand Worksheet Formula Versions for additional 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

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 Calendar_Icon.png to select the period/dates to include.

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

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.

Transfer Type

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.

Transfers by Item Report

The Transfers by Item report provides details about current inventory item transfers to facilitate with inventory ordering.

Parameters

Submit the following parameters to generate the report:

Sites

From the Site Selector, select the sites to include.

Calendar

Select the calendar icon Calendar_Icon.png to select the period/dates to include.

Column Descriptions

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.

Transfer Status

Status of the transfer.

Transfer Type

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.