This guide will be removed on April 29, 2022. Please use our new, easier-to-use Toast technical documentation site. All updated content is on the new site.

Product Mix Breakdown Reports

The product mix breakdown reports give you insights into how many of each of your menu items you sell and their average price after discounts. You can produce a report that is categorized either by your menu hierarchy or your sales categories to answer questions like, should I break out a sales category into more specific groups?

The following table shows the dimension and product selections you must make to produce a product mix report.

To produce an overview of: Select dimension... ...and select product:

Product mix breakdown by sales category

Sales category Menu items

Product mix breakdown by menu

Menu Menu items

In this example, the dimension is menu and the product is menu items, so the breakdown includes a row for each menu. You expand the rows to show the menu groups and subgroups at the next level, and again to review the menu items in those groups.

The product mix breakdown by menu report for a single-location restaurant during a one month period. All dollar values are blurred out.

If you select the sales category dimension instead, the report includes a row for each of your sales categories. You expand a sales category row to review the menu items in that category.

To include additional detail in the product mix breakdown you can add more products, such as modifier options and special requests (for both dimensions), and open items, Toast gift cards, and portions (for the menu dimension only, if you use the optional features).

When the report includes modifier options, special requests, or portions, they are categorized under the menu item with which they were ordered. This can help you answer questions like, What changes to a particular menu item get requested most often? Do we need to add a modifier option for a newly popular special request? Have employees been trained effectively to use modifier options instead of entering special requests?

The product mix breakdown by menu report for the same location and period, including modifier options and special requests as well as menu items. All dollar values are blurred out.

When the report includes open items or Toast gift cards, they appear on rows at the same top level as your menus or sales categories. Individual sales of open items and Toast gift card transactions are reported at the same level as menu items.

The product mix breakdown by menu report for the same location and period, including open items and Toast cards as well as menu items. All dollar values are blurred out.

In addition, this report includes:

  • Menu groups and any nested subgroups at the same hierarchical level.

  • Modifier options, special requests, and portions at the same hierarchical level.

  • A maximum of five levels of modifier options if your menu hierarchy nests modifier groups.

This report includes the following key figures and metrics.

Column Computation and Description

Avg Price

Net Amount / Item Qty for menu items, aggregated for rows that categorize menu items, including sales category or menu group and menu.

This report does not compute an average price for modifier options, special requests, or portions.

Item Qty

The count of all menu items sold, aggregated for categorization rows.

This count does not include modifier options, special requests, portions, deleted items, voided items, or items on voided checks or voided orders.

Gross Amount

Net Amount + Discount Amount for menu items, aggregated for categorization rows.

Discount Amount

Discounts on items. Aggregated for categorization rows.

Net Amount

Sale price x quantity sold for menu items, aggregated for categorization rows.

Net sales (net amount) identifies business income from restaurant items sold after deductions are taken for discounts. The sale price of an item includes any additional charges for modifiers or special requests.

Note that when you void an item or a check, the Toast system recomputes net sales. As a result, this value can change over time.