Support & Training

Generic selectors
Exact matches only
Search in title
Search in content

Sales Reports

Drill Down

The Drill Down report gives you an hour-by-hour breakdown of pre-tax/post-discount sales or quantity sold by Section, Sales Category, Menu Category, and/or Menu Item. Use the checkboxes at the top to indicate how you want sales grouped. Use the Display drop-down to switch from net sales to a report of quantity sold for each hour. Use the Net Sales/Quantity drop-down box to display the report by sales or items sold. Use the Bill Start Time drop-down box to switch between figures reflecting when the bill was started or when the bill was closed.

You can download this report as a CSV by clicking the CSV icon at the top of the report chart.

Gross Margin by Day

Gross Margin by Day represents before tax sales totals and do not include gratuity. It also provides a gross margin based on labor and food costs. You can download this report as a CSV by clicking the CSV icon at the top of the report chart.

At the top, a bar chart gives you a visual indication of sales over the selected reporting range (for example, the last 7 days).

The By Day report shows you exact sales totals by day. You can sort by:

ColumnDescription
Day of the WeekA day (for example, Sunday).
Bill CountThe number of bills closed for that day.
VoidsThe value of voids (items voided after they were sent to the kitchen) authorized by a manager or admin. Void values do not factor into Gross Sales, Discounts, or Net Sales calculations.
Gross SalesThe sales totals (pre-tax, does not include gratuity) for the day. The Gross Sales total includes items at their pre-discount price.For example, if you sold one item for the day at $20 and then discounted it by $5, Gross Sales would report $20.
DiscountsThe value of discounts and promotions.For example, if you sold one item for the day at $20 and then discounted it by $5, Discounts would report $5.
Net SalesThe sales total for day less discounts.For example, if you sold one item for the day at $20 and then discounted it by $5, Net Sales would report $15.
Menu Item Cost

A total of all items sold based on their Menu Item Cost setting.

If you are using the Recipe Cost method (using the Ingredient Inventory system), Menu Item Cost will use your menu item recipe to calculate the cost.
Labor CostThe day’s labor cost. This figure will be the same as the Labor Cost figure in the Hours Summary report.
MarginThe gross margin: net sales less the menu item cost and the labor cost.Note: This figure will not be accurate until your staff members have all signed out, giving you an accurate labor cost report. You should not use the Gross Margin by Day report for real-time reporting.

Heat Map/Time of Day/Bill Start Time

The Time of Day report gives you a “heat map” at the top. The Time of Day heat map gives you a visual representation of pre-tax/post-discount sales totals for each hour of each day over the given reporting range. The heat map can be useful for staffing, understanding your core hours. This report uses the bill’s close time. If you prefer to use the bill’s start time, use the Bill Start Time report.

The By Day table gives you totals for each day over the given reporting range. You can sort by:

ColumnDescription
Net or Gross SalesTotal sales for that day over the given reporting range. The Time of Day heat map will give you Net Sales (sales less discounts). The Bill Start time heat map will give you Gross Sales (before discounts).
Bill CountNumber of bills closed.
MinThe minimum bill closed.
MaxThe maximum bill closed.
AverageThe average bill.

Sales by Menu Category

Sales by Menu Category gives before tax sales totals of your menu categories for the given date range. You can download this report as a CSV by clicking the CSV icon at the top of the report chart.

The By Menu Category table gives you sales figure for each menu item. You can sort by:

ColumnDescription
Menu CategoryYour configured menu categories (“mains”, “appetizers”, etc.)
VoidsThe value of voids (items voided after they were sent to the kitchen) authorized by a manager or admin in this category. Voids are not reflected in any sales figures. Typically voids are accounted for as waste.
Gross SalesThe before taxes sales total for each menu item in the category. Totals do not include tax and gratuity. If items in the category were discounted, Gross Sales represents the pre-discount amount paid. The total also does not represent voids.
DiscountsIf any menu items in this category were discounted (via a discount or a promotion), the total amount discounted is given here.
Net SalesThe net sales total for each category less discounts. Totals do not include tax and gratuity. If items in the category were discounted, Sales totals represent the post-discount amount paid.
Menu Item CostsThe cost of the menu items sold under this category. Costs are determined by the food cost you inputted for the menu item or, if you’re using the Ingredient Inventory system, then according to the item’s ingredient recipe. Costs will not include voided items.
Menu Item QuantityThe actual number of items ordered and billed within that category. This does not include voided items.

Sales by Menu Item

Sales by Menu Item gives you your per menu item sales over the given reporting range. You can download this report as a CSV by clicking the CSV icon at the top of the report chart.

The By Menu Item table gives you sales figures for each menu item. You can sort by:

ColumnDescription
Menu Item NameName of the menu item.
Sales CategoryYour configured sales categories. By default, you will have food and alcohol categories but you might have set up additional categories like “Merchandise” or “Game Rentals”.
Menu CategoryYour configured menu categories (“mains”, “appetizers”, etc.)
Menu Item Void QuantityThe number of times the item has been voided.
VoidsTotal voids in dollar amounts authorized for each menu item.
Menu Item QuantityThe number of times this item has been ordered. This does not include voided items.
Gross SalesThe before taxes sales total for each menu item. Totals do not include tax and gratuity. If the item was discounted, Gross Sales represents the pre-discount amount paid. The total also does not represent voids.
DiscountsIf any menu item was discounted (via a discount or a promotion), the total amount discounted is given here.
Net SalesThe net sales total for each menu item less discounts. Totals do not include tax and gratuity. If the item was discounted, Net Sales totals represent the post-discount amount paid.
Sales PercentageWhat percentage of total sales this menu item represents.

Sales by Order Type

The Order Type report gives you sales by orders type (takeout, delivery, bar tab, or dine-in). Sales data represents before tax totals and do not include gratuity. If any discounts or promotions were applied, they represent the discounted price. You can download this report as a CSV by clicking the CSV icon at the top of the report chart.

Grouped vs Stacked

You have an option to display the bar charts as either Grouped (individual order types represented by their own bar) or Stacked (order types are stacked by day).

Click the appropriate radio button to select the bar chart type.

You can also filter on order types to display on the bar chart. Click the radio button to add/remove an order type.

The By Day table gives you sales figure for each order type. You can sort by:

ColumnDescription
DayA specific day.
Take OutBefore tax sales figures for take-out orders over the given data range.
DeliveryBefore tax sales figures for delivery orders over the given data range.
Bar TabBefore tax sales figures for bar tab orders over the given data range.
Dine-InBefore tax sales figures for tableside orders over the given data range.
Online OrderBefore tax sales figures for online orders over the given data range. If you are not using online ordering you will see $0 figures.
TotalClick to sort from highest to lowest or lowest to highest sales total for the day.

Sales by Sales Category

Sales by Sales Category gives before tax sales totals of your sales category over the given date range. You can download this report as a CSV by clicking the CSV icon at the top of the report chart.

The Sales by Sales Category table gives you sales figure for each Sales Category. You can sort by:

ColumnDescription
VoidsThe value of voids (items voided after they were sent to the kitchen) authorized by a manager or admin in this category. Voids are not reflected in sales figures.
Gross SalesThe sales totals (pre-tax, does not include gratuity) for the Sales Category. The Gross Sale total includes items at their pre-discount price.For example, if you sold one item in the Alcohol category for the day at $20 and then discounted it by $5, Gross Sales would report $20.
DiscountsThe value of discounts and promotions for the Sales CategoryFor example, if you sold one item in the Alcohol category for the day at $20 and then discounted it by $5, Discounts would report $5.
Net SalesThe sales total for day less discounts for the Sales Category.For example, if you sold one item in the Alcohol category for the day at $20 and then discounted it by $5, Net Sales would report $15.
Menu Item CostsThe cost of the menu items sold in that Sales Category. Costs are determined by the food cost you inputted for the menu item or, if you’re using the Ingredient Inventory system, then according to the item’s ingredient recipe. Costs will not include voided items.
Menu Item QuantityThe total number of items sold in that Sales Category. This will not include voided items.
Tax 1/2/3These will not display as your tax names. These columns indicate taxes collected by tax type for each sales category.

Sales by Section

The Sales by Section report gives you sales by your floor plan sections, plus your cash register, and sales under Orders (takeout, delivery, bar tabs). Sales data represents before tax totals and do not include gratuity. You can download this report as a CSV by clicking the CSV icon at the top of the report chart.

You can also filter out sections by clicking on the sections associated radio button. For example, you might want to filter only on floor plan sections, removing orders and cash register sales.

The By Section table gives you sales figure for each section. You can sort by:

ColumnDescription
SectionName given to the floor plan section.
Bill CountTotal number of bills closed in this section.
VoidsTotal value of voids authorized under this section.
DiscountsTotal value of discounts given under this section.
Net SalesSales, before taxes, for this section.

Return to Table of Contents

Customer Support

Our help site offers helpful guides, videos, step-by-step tutorials, live workshops, and more, for all TouchBistro products. If you can't find what you're looking for, our customer support team is available to you any time, day or night. And yes, even holidays and weekends!

Call us today

North America 1-888-342-0131
United Kingdom +44-0800-051-3311
Latin America +52-55-8526-2122
Rest of the World +1 416-363-5252
Contact
TouchBistro customer support representative wearing a headset and smiling