Sales Reports
→ → →
The following introduces the Xenial Cloud reports that are available in the Sales category.
Report | Description |
---|---|
Details about product/modifier usage across categories enabling the site manager to recognize sales trends and forecast inventory. | |
Summarizes key financial statistics for a selected employee enabling the site manager to reconcile and audit their activities at the POS. Spaces are provided at the bottom of the report for both the manager and the employee's signature. | |
Details employee productivity enabling the site manager to gauge and optimize overall workforce strategy. | |
Sales activity per employee enabling the site manager to monitor employee sales including tips, taxes, and applied discounts. | |
Employee performance based on defined business logic for the company. | |
High-level breakdown of sales data across all company sites. | |
Lists comments or preparation notes that were added for an order item enabling a site to determine if product modifications are necessary. | |
Provides a time-incremented analysis of sales, guest count and corollary performance and productivity metrics grouped by order destination. | |
Details the cost of labor in relation to hourly sales enabling the site manager to optimize labor usage. | |
Provides a time-incremented analysis of sales, guest count and corollary performance and productivity metrics grouped by user. | |
Detailed information about gift certificate sales. | |
Summarized information about gift certificate sales. | |
Details modifier usage across product categories enabling the site manager to recognize sales trends and inventory requirements. | |
Detailed information about the payments used to tender each order. | |
Labor currency amount for each job code in hourly increments. | |
Details product sales sorted by major category. | |
View and compare a breakdown of specific sales measures for a selected business date. | |
Details the cost of labor in relation to sales enabling the site manager to optimize labor usage. | |
Graphical display of summarized sales and labor totals. | |
Sales and transaction counts by time interval enabling the site manager to forecast labor and inventory requirements. | |
Compares sales and guest counts with the respective labor hours. | |
Details speed of service times enabling the site manager to audit the performance of the kitchen staff and determine how quickly order items are prepared. | |
Details speed of service metrics by check and table number. | |
Details speed of service performance statistics. | |
Details about tax exemption transactions. | |
Key sales information for a selected week enabling the site manager to audit all payment flows. | |
Contains key sales and labor information for a selected week enabling the site manager to optimize labor usage. |
Category Sales per Site
The Category Sales per Site report contains details about product/modifier usage across categories enabling the site manager to recognize sales trends and forecast inventory.
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 desired option for grouping items on the report. |
Display Options | From the dropdown, choose to view totals for Net Sales or Gross Sales. |
Order By | From the dropdown, select the values by which to order the items on the report. For example, select Sales to group the items on the report by their respective sales data. |
Demonstration Level | From the dropdown, select the desired category, product, and/or employee display option. |
Employees | From the dropdown, select the employees to include. |
Column Descriptions
The following describes the columns on the report:
Category | The content is determined by the selected Demonstration Level. |
Net Quantity / Gross Quantity | The column name is determined by the selected Display Option. Quantity of products sold per each category. |
Net Quantity / Gross Quantity <destination name> | The column name is determined by the selected Display Option. Quantity of products sold per each category per order destination. |
% of Net Quantity / Gross Quantity | The column name is determined by the selected Display Option. Percentage of the Net Quantity or Gross Quantity that is attributable to this item. |
Net Sales / Gross Sales | The column name is determined by the selected Display Option. Total currency amount in Net Sales or Gross Sales. |
Net Sales / Gross Sales <destination name> | The column name is determined by the selected Display Option. Total currency amount in Net Sales or Gross Sales per order destination. |
% of Net Sales / % of Gross Sales | The column name is determined by the selected Display Option. Percentage of the Net Sales or Gross Sales that is attributable to this item. |
% of Category | The content is determined by the selected Demonstration Level.
|
Incident rate % | The content is determined by the selected Demonstration Level.
|
Discount Totals | Total currency amount in applied discounts (does not include promos or walkouts). |
This report includes the following grouping levels:
By Hierarchy
By Hierarchy and Site
Employee Audit
The Employee Audit report summarizes key financial statistics for a selected employee enabling the site manager to reconcile and audit their activities at the POS. Spaces are provided at the bottom of the report for both the manager and the employee's signature.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Employees | From the dropdown, select the employees to include. |
Column Descriptions
The following describes the columns on the report:
Sales Breakdown | Breakdown of the Gross Sales calculation including the Net Sales total. |
Destination Sales | Total sales for each order destination. |
Tip Totals | Total currency amount in customer tips. |
Cash Due | Total amount of cash collected by employee. |
Pay Type Totals | Total sales for each pay type; the Rounded Adjustments subsection contains totals for currency that was rounded at the POS. |
Service Metrics |
|
Employee Productivity
The Employee Productivity report details employee productivity enabling the site manager to gauge and optimize overall workforce strategy.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Hide Inactive Rows | Enable this toggle to not include rows that do not contain any data. |
Column Descriptions
The following describes the columns on the report:
Time | Time of day. |
Labor Hours | Total number of hours worked by employees. |
Net Sales | Net currency amount of sold products (includes refund transactions). |
Transaction Count | Total number of transactions processed. |
Guest Count | Total number of guests served. |
SPLH | Sales per Labor Hour = Net Sales / Actual Labor Hours. |
OPLH | Orders per Labor Hour = Orders / Actual Labor Hours. |
GPLH | Guests per Labor Hour = Guests / Actual Labor Hours. |
Total | Totals for each applicable column. |
Employee Sales
The Employee Sales report contains sales activity per employee enabling the site manager to monitor employee sales including tips, taxes, and applied 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 |
Column Descriptions
The following describes the columns on the report:
Site | Identifies the site where the sales were processed. |
Employee Name | Name of the employee. |
Employee Code | ID of the employee. |
Gross Sales | Gross currency amount of sold products. |
Taxes | Total currency amount in applied taxes. |
Discounts | Total currency amount in applied discounts (does not include promos or walkouts). |
Liabilities | Total currency amount in gift card and gift certificate sales. |
Net Sales | Net currency amount of sold products (includes refund transactions). |
Guests | Total number of guests served. |
Guest AVG | Average Net Sales per guest. |
Tips | Total currency amount in customer tips. |
Tip % | Percentage of Net Sales this is attributable to tips. |
Deleted Items Amt | Currency total of deleted items. |
Voided Items Amt | Currency total of voided items. |
Deleted Items Qty | Quantity of deleted items. |
Voided Items Qty | Quantity of voided items. |
Payment Total | Totals for each applicable column. |
Employee Scorecard
The Employee Scorecard report contains information about employee performance based on defined business logic for the company.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Destinations | From the dropdown, select the order destinations to include. |
Column Descriptions
The following describes the columns on the report:
Name | Name of the employee. |
Guests Count | Total number of guests served. |
Net Sales | Net currency amount of sold products (includes refund transactions). |
Donations | Total currency amount in guest donations. |
GCA | Guest Check Average (Net Sales / Guest Count). |
Discounts | Total currency amount in applied discounts (does not include promos or walkouts). |
Promos | Total currency amount in applied promotions. |
Voids | Total currency amount in canceled items and voids. |
Walkouts | Total currency amount in walkout transactions. |
Average Table Turn Time (minutes) | The average difference between created time, and the close time per order. |
Guests Per Labor Hour | Guests per Labor Hour = Guests / Actual Labor Hours. |
Sales Per Labor Hour | Sales per Labor Hour = Net Sales / Actual Labor Hours. |
AVG Transaction | Net Sales / Guest Count. |
Total | Totals for each applicable column. |
Enterprise Sales Summary
The Enterprise Sales Summary report contains a high-level breakdown of sales data across all company sites.
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 |
Column Descriptions
The following describes the columns on the report:
State | State where site is located. |
Site ID | ID of the site. |
Site Name | Name of the site. |
Business Date | Business date associated with the sales. |
Gross Sales | Gross currency amount of sold products. |
Custom Calculations | Custom Named Calculations defined in Data Management. |
Discount Total | Total currency amount in applied discounts (does not include promos or walkouts). |
Liabilities Sold | Total currency amount in gift card and gift certificate sales. |
Refund Total | Total currency amount in refunds. |
Tax Total | Total currency amount in taxes. |
Net Sales | Net currency amount of sold products (includes refund transactions). |
Tips | Total currency amount in employee tips. |
Payments | Total sales for each pay type; the Rounded Adjustments subsection contains totals for currency that was rounded at the POS. |
Liabilities Sold: Gift Card | Total currency amount in gift cards sold. |
Deposit Variance: Actual | Total variance between the expected deposit total and the actual deposit total. |
Paid In | Total currency amount in Paid In transactions. |
Paid Out | Total currency amount in Paid Out transactions. |
Donations Total | Total currency amount in guest donations. |
Donations Qty | Total quantity of guest donations. |
Item Comments
The Item Comments lists comments or preparation notes that were added for an order item at the POS enabling a site to determine if any menu modifications are necessary.
Parameters
Submit the following parameters to generate the report:
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:
Comment/Product | Comment entered at the POS and the associated product. |
Quantity of Comments | Total number of comments. |
Grand Total | Totals for each applicable column. |
Labor Performance: Destination
The Labor Performance: Destination report provides a time-incremented analysis of sales, guest count and corollary performance and productivity metrics grouped by order destination.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Column Descriptions
The following describes the columns on the report:
Time | Time of day. |
Guest Count | Total number of guests served. |
Guest Avg | Average Net Sales per guest. |
Net Sales | Net currency amount of sold products (includes refund transactions). |
Gross Sales | Gross currency amount of sold products. |
Avg. Check | Average Net Sales per guest. |
Labor Hours | Total number of hours worked by employees. |
Ideal Labor $ | Currency amount for the ideal labor cost for this time period, sales amount, and/or guest count. |
Labor % | Percentage of hourly net sales that is equal to the ideal labor cost for the day. |
Avg. Wage Rate | The average wage rate paid to employees. |
Sales / Man HR | The average net sales per labor hour. |
Labor Performance: User
The Labor Performance: User report provides a time-incremented analysis of sales, guest count and corollary performance and productivity metrics grouped by user.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Column Descriptions
The following describes the columns on the report:
Time | Time of day. |
Guest Count | Total number of guests served. |
Average Table Turn Time (minutes) | Average difference between the Start Time and Close Time of the order. |
Net Sales | Net currency amount of sold products (includes refund transactions). |
Actual Labor $ | Total currency amount of actual labor for this time frame. |
Labor Hours | Total number of hours worked by employees. |
Var +/- | Difference between the ideal labor hours and the actual labor hours. |
Labor Performance: Hour
The Labor Performance: Hour report details the cost of labor in relation to hourly sales enabling the site manager to optimize labor usage.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Column Descriptions
The following describes the columns on the report:
General | |
Time | Time of day. |
Guest Count | Total number of guests served. |
Guest Traffic % | Percentage of total Net Sales that is attributable to this time frame. |
Net Sales | Net currency amount of sold products (includes refund transactions). |
Guest Avg | Average Net Sales per guest. |
Actual Labor $ | Total currency amount of actual labor for this time frame. |
Primary Labor | |
Ideal Labor $ | Currency amount for the ideal labor cost for this time period, sales amount, and/or guest count. |
Labor Var $ | Difference between the ideal labor hours and the actual labor hours. |
Actual Labor % of Hourly Net Sales | Percentage of hourly net sales that is equal to the actual labor cost for the day. |
Ideal Labor % of Hourly Net Sales | Percentage of hourly net sales that is equal to the ideal labor cost for the day. |
Labor Var % of Hourly Net Sales | Difference between the Actual Labor % of Hourly Net Sales and the Ideal Labor % of Hourly Net Sales. |
All Labor | |
Actual Labor % of Total Labor | Percentage of total labor cost that is equal to the actual labor cost for the day. |
Actual Labor % of Hourly Net Sales | Percentage of hourly Net Sales that is equal to the actual labor cost for the day. |
Actual Labor % of Total Net Sales | Percentage of total Net Sales that is equal to the actual labor cost for the day. |
Liability Detail
The Liability Detail report contains detailed information about gift certificate sales.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Column Descriptions
The following describes the columns on the report:
Site | Name of the site where the transaction was processed. |
Business Date | Business Date when the transaction was processed. |
Liability Type | Type of liability item sold. |
Order Time | Time when the transaction was processed. |
Order # | Order number associated with the transaction. Select an order number in this column to view detailed information about the transaction. |
Employee | Name of the employee who performed the transaction. |
Order Type | Order type associated with the transaction. |
Quantity | Quantity sold. |
Total | Totals for each applicable column. |
Liability Summary
The Liability Summary report contains summarized information about gift certificate sales.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Column Descriptions
The following describes the columns on the report:
Site | Name of the site where the transaction was processed. |
Business Date | Business Date when the transaction was processed. |
Liability Type | Type of liability item sold. |
Liability Name | Name of liability item sold. |
Quantity | Quantity sold. |
Total | Totals for each applicable column. |
Modifier Analysis by Category
The Modifier Analysis by Category report details modifier usage across product categories enabling the site manager to recognize sales trends and inventory requirements.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Demonstration Levels | From the dropdown, select the desired category, product, and/or employee display option. |
Group By | From the dropdown, select the method for grouping the data: Business Date or Site. |
Column Descriptions
The following describes the columns on the report:
ID | The content is determined by the selected Demonstration Level. |
Category | The content is determined by the selected Demonstration Level. |
Total Quantity | Total quantity of products sold. |
Qty w/Mods | Quantity of products sold with modifiers. |
% w/Mods | Percentage of total products sold that is attributable to products sold with modifiers. |
Qty w/o Mods | Quantity of products sold without modifiers. |
% w/o Mods | Percentage of total products sold that is attributable to products sold without modifiers. |
Quantity | Quantity of applied modifiers. |
Frequency,% | Percentage of total products sold that is attributable to applied modifiers. The content is determined by the selected Demonstration Level. |
Total | Net Sales total. The content is determined by the selected Demonstration Level. |
% of Net | Percentage of total Net Sales that is attributable to the Total column value. |
Order Payments
The Order Payments report contains detailed information about the payments used to tender each order.
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 |
Transaction Type | From the dropdown, select the types of transactions to include (e.g. Sale, Void). |
Payment Status | From the dropdown, select the payment statuses to include (e.g. Paid, Voided). |
Column Descriptions
The following describes the columns on the report:
Site Name | Name of the site where the transaction was processed. |
Business Date | Business Date when the transaction was processed. |
Payment Date/Time | Date/time when the transaction was processed. |
Order # | Order number associated with the transaction. Select an order number in this column to view detailed information about the transaction. |
Order Type | Type of order. |
Order State | Order state of the transaction. |
Ext Total | Extended order total amount: (Subtotal + Exclusive Taxes) - Discount. |
Liabilities | Currency amount in gift cards and gift certificates. |
Pre-Payment Tips | Currency amount in pre-payment tips. |
Payment Tips | Currency amount in post-payment tips. |
Payment | Total currency amount in payments on the order. |
Payment Status | Current status of the payment. |
SAF | "Store and Forward" transactions (i.e. transactions occurred while the PIN pad was offline). |
Pay Type | Payment type applied to the order. |
Acquisition Type | Identifies how the payment type information was acquired (e.g. SWIPE). |
Trans Type | Transaction type (e.g. Sale, Void). |
Trans ID | ID of the transaction. |
Card Brand | Brand of payment card (e.g. VISA, MasterCard). |
Auth # | Authorization number for the payment. |
Last 4 of CC# | Last four digits of the card account number. |
Primary Labor by Hour
The Primary Labor by Hour report contains the labor cost for each job code in hourly increments.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Display Options | From the dropdown, select the desired option:
|
Column Descriptions
The following describes the columns on the report:
Column | Description |
---|---|
Time | Time of day. |
Guests | Total number of guests served. |
Job Code | The following information is provided for each job code:
|
Total | Totals for each applicable column. |
Product Mix
The Product Mix report details product sales sorted by major category.
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 |
Column Descriptions
The following describes the columns on the report:
Column | Description |
---|---|
Major Category | Identifies the major product category to which the product is assigned. |
Minor Category | Identifies the minor product category to which the product is assigned. |
Product ID | Numeric ID for the product. |
Name | Name of the product. |
Net Quantity | Net Quantity sold of the product. |
Net Sales | Net sales currency amount for the product. |
Gross Quantity | Gross Quantity sold of the product. |
Gross Sales | Gross sales currency amount for the product. |
Discount Totals | Total currency amount in applied discounts (does not include promos or walkouts). |
Tax Totals | Total currency amount in applied taxes. |
Site-level groupings on the report provide the ability to drill down into site-level detail for each product.
Sales Analysis
The Sales Analysis report enables the site manager to view and compare a breakdown of specific sales measures for a selected business date.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Select the Sales Measures
From the Left Measure dropdown, select the first sales measure.
From the Right Measure dropdown, select the second sales measure.
From the By Business Date: Net Sales graph, select the desired Business Date / Net Sales.
The following values are provided for the selected sales measures:
Store
By Destination
By Day Part
By Hour
By Terminal
By Employee
Sales and Labor
The Sales and Labor report details the cost of labor in relation to sales enabling the site manager to optimize labor usage.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Interval | From the dropdown, select the time interval to view. |
Hide Inactive Rows | Enable this toggle to not include rows that do not contain any data. |
Column Descriptions
The following describes the columns on the report:
Time | Time of day. This content is determined the selected Interval. |
Net Sales | Net currency amount of sold products in this time interval. |
Accum Sales | Accumulated Net Sales. |
Transaction Count | Total number of transactions in this time interval. |
Accum Transaction Count | Accumulated Transaction Count. |
Labor Hours | Total number of hours worked by employees. |
Labor Cost | Total labor cost for hours worked by employees. |
Accum Labor Cost | Accumulated Labor Cost. |
Labor % | Percentage of sales that is equal to the total labor cost. |
Accum Labor % | Accumulated Labor %. |
Total | Totals for each applicable column. |
Sales and Labor Visualization
The Sales and Labor Visualization report contains a graphical display of summarized sales and labor totals.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Element Descriptions
The following describes the elements on the report:
Element | Description |
---|---|
Net Sales | Net currency amount of sold products in this time interval. |
Sales per Labor Hour | Average Net Sales per Labor Hour. |
Labor Hours | Total number of hours worked by employees. |
Labor Cost | Total labor cost for hours worked by employees. |
Labor Cost % | Percentage of sales that is equal to the total labor cost. |
Sales and Transaction
The Sales and Transaction report contains sales and transaction counts by time interval enabling the site manager to forecast labor and inventory requirements.
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 |
Interval | From the dropdown, select the time interval to view. |
Display Options | From the dropdown, choose to view totals for Net Sales or Gross Sales. |
Column Descriptions
The following describes the columns on the report:
Site | Name of the site. |
Business Date | Business date when the sales were processed. |
Time | Time of day. This content is determined the selected Interval. |
Qty of Sold Items | Quantity of items/products sold. |
Net Sales / Gross Sales | The column name is determined by the selected Display Option. Total currency amount in Net Sales or Gross Sales. |
Net Sales / Gross Sales <destination name> | The column name is determined by the selected Display Option. Total currency amount in Net Sales or Gross Sales per order destination. |
Transaction Count | Total number of transactions in this time interval. |
Guest Count | Total number of guests for this time interval. |
Guest Avg | Average check amount per guest. |
Service Productivity
The Service Productivity report compares sales and guest counts with the respective labor hours.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Column Descriptions
The following describes the columns on the report:
Time | Time of the day. |
Guest Count | Number of guests. |
Net Sales | Net currency amount of sold products (includes refund transactions). |
Labor Hours | Total number of hours worked by employees for the day. |
Average Table Turn Time (Minutes) | Average number of minutes to close an order. |
Speed of Service
The Speed of Service report details speed of service times enabling the site manager to audit the performance of the kitchen staff and determine how quickly order items are prepared.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Column Descriptions
The following describes the columns on the report:
Weekly Metrics | Speed of service averages for each day of the week. |
Active Orders: HH:MM:SS | Fulfillment times of orders just completed in the kitchen. |
Production Screens | Speed of service averages for each kitchen display including the expected service times. |
Lead Fulfillment Product Time: HH:MM:SS | Top 4 items with the shortest speed of service time. |
Highest Fulfillment Product Time: HH:MM:SS | Top 4 items with the longest speed of service time. |
Speed of Service Check Audit
The Speed of Service Check Audit report details speed of service metrics by check and table number.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Column Descriptions
The following describes the columns on the report:
Order# / Table | Order number associated with the transaction. |
Guest | Guest count. |
Carry Out | Indicates if the order destination is Carry Out. |
Start Time | Time when the first item was added to the order. |
Kitchen Send | Time when the order was sent to the kitchen application. |
Cook Sell | Maximum bump time from the assembly kitchen displays. |
Window Pickup | Maximum bump time from the Expo displays. |
Order Close | Time when the order was closed. |
Cook Time | Difference between Start Time and Cook Sell. |
Window Time | Difference between Cook Sell and Window Pickup. |
Start To Close | Difference between Window Pickup and Start Time. |
Speed of Service Performance
The Speed of Service Performance report details speed of service performance statistics. The metric calculations include:
Cook Time
Guest Count
Table Turn Time
Ticket Time
Window/Expo Time
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Destinations | From the dropdown, select the order destinations 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. |
Interval | From the dropdown, select a time interval by which to group the items on the report (e.g. 30 Min, Hour, By Day Part). |
Tax Exempt Detail
The Tax Exempt Detail report contains details about tax exemption transactions.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Column Descriptions
The following describes the columns on the report:
Company ID | ID of the company. |
Order Id | Order number associated with the transaction. Select an order number in this column to view detailed information about the transaction. |
Site | ID and name of the site where the transaction was processed. |
Business Date | Business Date when the transaction was processed. |
Order Time | Time when the transaction was performed. |
Order # | Order number associated with the transaction. Select an order number in this column to view detailed information about the transaction. |
Channel | Order source associated with the order (e.g. Terminal, Mobile Order). |
Destination | Order destination associated with the order. |
Tax Exempt ID | Tax Exempt ID associated with the transaction. |
Employee | Name of the employee who performed the transaction. |
Approver | Name of the site manager who approved the transaction. |
Reason | Reason selected by the employee for the tax exempt transaction. |
Order State | Order state of the transaction. |
Subtotal | Order total before tax. |
Discount | Total currency amount in applied discounts (does not include promos or walkouts). |
Grand Total | Totals for each applicable column. |
Tax Exempted | Total currency amount of tax exemption. |
Weekly Sales
The Weekly Sales report contains key sales information for a selected week enabling the site manager to audit all payment flows.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |
Column Descriptions
The following describes the columns on the report:
Sales Breakdown | Daily totals for the following items:
Click the links on the report to drill down into an item and view more details (if applicable). |
Drawer Count Variance | Total variance between the expected drawer count amount and the actual drawer count amount. |
Destination Sales | Sales by order destination (e.g. Eat In, Carry Out). |
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. Click the links on the report to drill down into an item and view more details (if applicable). |
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 guest donations. |
Order Source | Total sales by order source. |
Weekly Sales and Labor History
The Weekly Sales and Labor History report contains key sales and labor information for a selected week enabling the site manager to optimize labor usage.
Parameters
Submit the following parameters to generate the report:
Sites | From the Site Selector, select the sites to include. |
Calendar | Select the calendar icon |