Modifier Sales Report

Track modifier usage with the Modifier Sales report. See how often modifiers are ordered, view sales totals for individual modifiers, and filter the report to customize the details.

Table of Contents

Run the Report

In Ambur Cloud, run the Modifier Sales report to see modifiers sold during a specific time period.

You must be using Ambur version 2.9.1 or above to run this report. Visit our Update the Ambur App support article to learn how to update your app.

  1. Click 'Modifier Sales'.
  2. Hover over the views button to load a custom preset view.

    Hover over a preset to view its description.

    Click to Enlarge
  3. Hover over 'Time Period' to select a preset or custom time period.
    Click to Enlarge

Report Summary

The Summary section gives an overview of open and closed orders for the selected date range. View your modifier sales by staff, business location, or by any of the criteria mentioned below.

  1. Hover over 'Summarize' and select a summary type.
    Click to Enlarge

    Location | Shows total modifier sales for each active linked Ambur location.
    Click for a sample view of the Location Summary

    Menu Item | Shows total modifier sales for each menu item.
    Click for a sample view of the Menu Item Summary

    Modifier | Gives total sales for each modifier.
    Modifiers are the options customers ask for when they order.
    Click for a sample view of the Modifier Summary

    Modifier Type | Gives total sales for each modifier type.
    Modifier types are the groupings that contain modifier options.
    Click for a sample view of the Modifier Type Summary

    Staff | Gives each individual user’s total modifier sales.
    Click for a sample view of the Staff Summary

  2. (optional) Click the plus sign to select another option to organize your summary by.
    Click to Enlarge

    The summary includes columns for all selected summary types.

    Click to Enlarge
  3. Click any table header to sort ascending or descending.
    Click to Enlarge

    Ratio | Percentage of the total Gross that the row represents.
    Count | Total number of modifiers sold.
    Gross | Total amount of revenue from the sale of modifiers.

Report Details

The Details section breaks down the Summary and shows every individual modifier that was sold.

Click to Enlarge

Menu Item | Name of the menu item associated with each modifier.
Modifier Type | Name of the modifier type that the modifier is a part of.
Modifier | Name of the modifier that was sold.
Ratio | Percentage of the total Gross that the row represents.
Count | Number of times that modifier was sold.
Gross | Total amount of revenue coming from sales of that modifier.

  1. Hover over 'Add columns' to add columns to the report.

    Location | Breaks down how many of each modifier were sold at each location.
    Click to view a sample report with the Location column

    Order Ref | Gives the unique transaction ID assigned to the order where the modifier was sold.
    Click the Order Ref number to see a summary of the associated order.
    Click to view a sample report with the Order Ref column

    Staff | Shows the user who sold each modifier.
    Click to view a sample report with the Staff column

Filter the Report

Use the built-in filters to get the specific data you need. When you apply filters, the report displays only the modifier sales that match those parameters.

  1. Click a filter to expand its menu.
  2. Select values for the filter.
  3. (optional) Click ‘Reset’ to remove all filters.

Save a Custom View

Save your customized Modifier Sales report so you can quickly return to that exact view later. Once a custom view is saved, it can be set as the default view that opens when the report is launched.

Save a Custom View

  1. Hover over the views button and select ‘Save my search as a view’.
  2. Enter a name and description of the view and click 'Save as view'.

    (optional) Check ‘Make this my default view’ to make it the default view that loads for the report.

Change the Default View

  1. Hover over the views button and select a view.
  2. Hover over the views button and click 'Set current view as default'.

Export the Report

Quickly export a copy of the Modifier Sales report to share it with others who may need its data.

  1. Hover over the 'Export' button and select an export method.

    Google Sheet | Copy the report data to a Google spreadsheet.
    Email PDF | Send the report attached to an email in PDF format.
    Email Excel | Send the report attached to an email in Excel format (.xlsx).
    Share Link | Copy a direct link for the report to your clipboard.
    Print | Print the report to a connected printer.