Skip to main content

Inventory Reports

Xenial Cloud Portal 4-Dot Menu Reports Inventory

The following introduces the 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.

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.

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.

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.

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 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.

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.