Support & Training
Generic selectors
Exact matches only
Search in title
Search in content

Generating Menu Reports

Introduction

TouchBistro’s Menu Reports section allows you to generate reports about your menu items and products: break downs of sales by menu items, voids, food costs, and inventory reports.

Note: If you are using Inclusive Tax, see this discussion about how that effects reporting.

Ensure Your iPad Email Account is Set Up

Many reports can only be viewed by emailing them to yourself as a CSV file. Before you start to generate reports, you should ensure you have an email account set up on your iPad(s). To set up an email account see this guide on the Apple site.

Generating a Report

After determining the date range for the report, do the following:

1. Before you add a report, tap the report’s Information icon associated with the report. Many reports let you change how the report is sorted. For example, the Sales Items Totals report lets sort by Sales Totals, Item Count, Item Name, or Sales Category.

2. Tap the report to add it to the Current Report column.

3. You can add in additional reports by tapping them. For example, tap Cost of Goods Sold Report.

4. You can remove a report at any time by tapping the Delete icon next to the appropriate report and then tapping Delete.

5. If you’ve created a report with multiple reports and you’ll need to re-generate the report at a later date, tap Save Template As. Use Load Template to access this saved report.

6. Tap Generate Report on the top right when you’re ready to view the report results.

7. When you generate a report, TouchBistro gives you the following options at the top of the report:

Tap CSV to email the report as a CSV (comma separated values) file. A CSV file can be opened in a spreadsheet.

Tap Email to email the report as a formatted email.

Tap Printer to print the report to a configured printer.

8. If you choose to email your report, ensure you’ve setup an email account under your iPad’s Settings. TouchBistro uses your iPad’s existing email credentials for emailing.

Menu Item List Report

The Menu Item List Report lets you view (and export as CSV) a list of all your current menu items (grouped by Menu Category), their current menu prices, and their costs. You can use this report to quickly verify the menu item prices as well as see menu items that lack food cost details or have unusually high/low food costs. As well, this report can be useful if you need to export your menu and prices. For example, you want to use the raw export text as the basis for a printed menu or for posting online.

Note: This report will only generate a menu item list for your current menu. If you set the date/time wheels to a previous date range, this report will not show old menu items (which have been archived), or previous menu item costs, and prices.

How is the Menu Item List Report Generated?

Price

When you edit a menu item, you can enter the item’s price. The Menu Item List Report uses this figure to report on the item’s price.

Cost

When you edit a menu item, you can enter the item’s cost. The Menu Item List Report uses this figure to calculate total costs. If you later change the cost figure (because, for example, your cost of steak has gone up), TouchBistro will not retroactively recalculate the food or alcohol cost based on the new figure. Your reports will properly reflect the costs as entered for the given time period.

If you are using the Ingredient Inventory System and you’ve enabled Recipe Cost, TouchBistro will calculate the menu item’s cost based on your recipe and ingredient prices.

Sales Item Totals Report

The Sales Item Totals report will give you a breakdown of all menu items, how many times each menu items was ordered, and the total gross revenue of each menu item. Items flagged as returnable will show return counts. It will also report a breakdown of voids.

Sort By

Sales Totals

Sorts sales from highest grossing menu item to the lowest.

Item count

Sorts sales from the most sold menu item to the least sold.

Item Name

Sorts menu items alphabetically.

Sales Category

Sorts menu items by their sales category and identifies which sales category the item belongs to.

How is the Sales Item Totals Report Generated?

The Sales Item Totals Report combines data from three sources:

Menu items sales counts and totals flow from your closed bills. Totals are before tax.

On an item you’ve flagged as Allow Returns, you can tap the item and then tap Return This Item (Negative Price) to process a cash or credit card return. You have to explicitly flag menu items as being returnable in Admin | Admin Settings | Menu | Menu Items.

Voids are items canceled after being sent to the kitchen. Voided items do not calculate into menu item totals.

Cost of Goods Sold Report

The Cost of Goods Sold Report will break out costs via their Sales Category and give you an overall sales vs item cost calculation. Voided items are not included in this report.

How is the Cost of Goods Sold Report Generated?

Closed Bills

Menu items sales counts and totals flow from your closed bills. Totals are before tax.

Menu Items Costs

When you edit a menu item, you can enter the item’s cost. The Cost of Goods Sold report uses this figure to calculate total costs. If you later change the cost figure (because, for example, your cost of steak has gone up), TouchBistro will not retroactively recalculate the food or alcohol cost based on the new figure. Your reports will properly reflect the costs as entered for the given time period.

If you are using the Ingredient Inventory System and you’ve enabled Recipe Cost, TouchBistro will calculate the menu item’s costs based on your recipe and ingredient prices.

Modifier Report

The Modifier Report gives you a breakdown of which Text modifiers are being used and how often. If modifiers come with an extra charge, the report will display how much money was earned from the modifier. This report can be useful for determining top selling and poor selling modifications and adjusting your modification options.

Note: this report does not report on Menu Item modifiers.

How is a Modifier Report Generated?

Using and Setting Up Modifiers

This report tracks modifiers applied to menu items in the order screen.

Modifiers are added under Admin | Admin Settings | Menu.

Inventory List Reports

The Inventory List report gives you a breakdown of menu items you’re tracking in inventory. It shows how many items remain.

How is an Inventory List Generated?

Setting Up Menu Item Inventory Counts

Initial inventory numbers for any given menu item are entered under Admin | Admin Settings | Menu | Menu Item. Inventory numbers are set by tapping the Countdown button. As items are ordered via the order screen, the count is decreased appropriately.

Low Inventory Totals Report

The Low Inventory Totals report shows you menu item inventory counts and their corresponding “low inventory” warning setting.

How is a Low Inventory Totals Report Generated?

Setting Up Menu Item Inventory Counts

Initial inventory numbers for any given menu item are entered under Admin | Admin Settings | Menu | Menu Item. Inventory numbers are set by tapping the Countdown button. The Warn At setting is likewise set when you’re setting initial inventory numbers. This number remains unchanged unless you alter it.

Sales by Menu

The Sales by Menu report shows you a breakdown of menu categories ordered by Menu.

How is the Sales by Menu Report Generated?

Menus

When items are order, TouchBistro will record which Menu they were order under.

For example, imagine an item (e.g., a Bloody Mary) was ordered from the Drinks category under the lunch menu.

Later that night an item was ordered from the Drinks category under the dinner menu.

Running a Sales by Menu report we can see how TouchBistro recognizes which Menu and Menu Category the item was ordered under.

Sample CSV Report Download

Click here to download a sample CSV report for the following Menu Reports:

Menu Item List Report
Sales Item Totals
Cost of Goods Sold Report
Menu Item Cost Report
Modifier Report
Sales by Menu
Ingredient Consumption Report

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