Skip to main content

Item Sales Report by Employee

The Item Sales Report by Employee is most often used for contests or sales challenges (for example, tracking which employee sold the most desserts during a time period). It allows restaurants to compare sales performance by employee, by item, or by location.

Where to find the report

  • Backoffice --> Reporting --> Reports --> Sales folder --> Item Sales Report by Employee --> Select Date Range --> Select the Items you'd like included --> Execute

image.png

Report Options

Filters
  • Items – If nothing is selected, the report includes all items. You can also select specific items (e.g., all 12 desserts).

  • Item Filters – Use a pre-built filter (like “Desserts”) instead of selecting items one by one.

View Settings
  • Show Chart – Adds a bar graph at the top, showing employee totals visually.

  • Sort Type – Sorts by Units Sold (default), Net Sales, Total Sales, Comps, or Employee.

    • Note: Sorting only applies within groups. Groups themselves are always alphabetical.
  • Base Employee On – Choose to count sales by either:

    • The user associated to the order OR

    • The user who rang in the item

  • Item Display Name – Choose which configured item name to display: Name, Kitchen Name, Receipt Name, or Online Name.

Group By
  • None selected – Groups results by employee (e.g., Sally sold the most desserts overall).

  • Item – Groups by each item, then lists employees under each item (e.g., who sold the most brownies, who sold the most cheesecake).

  • Location – Groups by store location, then lists employees under each store.

  • Item + Location – Groups first by location, then by item, then lists employees under each item.

What it looks like

Example #1 - Grouped by Employee (with Chart)

  • Shows each employee’s total sales, with a bar chart for quick comparison.

  • Best when you’re running a contest for overall units sold or overall sales by person.

image.png

Example #2 - Grouped by Item

  • Breaks out sales by individual menu item, then shows employees under each.

  • Best when you want to know who sold the most of a specific item (e.g., brownies vs. cheesecake).

image.png

Report Parts

Column Descriptions
  • Avg Sale – Average dollar value of each sale (Net Sales ÷ Units).

  • Units – Number of items sold.

  • Net Sales – Dollar value of items sold (after discounts).

  • % of Net – Percentage of total sales represented by that employee/item.

  • Comps – Amount of sales comped (if any).

  • Total – Net Sales + Comps (represents full sales before comps).

How to Use This Report

  • Contests: Run this report to see which employee sold the most of a category (like desserts or drinks) during a contest period.

  • Performance: Compare sales volume (units sold) vs. revenue (net sales) — useful since the highest number of items sold isn’t always the same as the highest dollar amount.

  • Flexibility: Choose whether to view the information grouped by employee, item, or location, depending on the type of contest or analysis you’re running.

Tips for Using This Report

  • Set clear contest rules – Decide in advance whether the contest is based on Units Sold or Net Sales, since the winner could change depending on item prices.

  • Use Item Filters for speed – If you run the same contest often (like desserts), create an Item Filter so you don’t have to re-select items every time.

  • Turn on the chart for quick visuals – The optional bar chart makes it easy to see at a glance who’s in the lead.

  • Group by Item for fairness – If you want to compare sales of specific items (like cheesecakes vs. brownies), group by item instead of employee.

  • Group by Location for multi-store contests – Use the “Location” option to compare different stores and their employees in one report.

  • Track progress mid-contest – Run the report partway through the contest so employees can see where they stand and stay motivated.