AirQR
Reports & analytics

Item reports (category, item, menu, sizes and add-ons)

What the Category summary, Item summary, Menu-wise summary and Sizes & add-ons reports show, how gross sales and item offers work, and where deleted dishes go.

4 min read

The Items reports in Reports show what sold: by category, by dish, by menu, and which sizes and add-ons guests chose. They count items on settled bills, by the time the bill was settled, in business days. Each downloads as Excel and CSV and has the order type filter (All order types, or tick Dine-in, Takeaway and/or Delivery). For the period and outlet filters, see Reports.

Category summary

Quantity and sales per menu category: Category, Quantity, Gross sales, Item offers, After item offers, Returned qty, Returned value, Net qty, After returns and Share of gross, with a total row.

Item summary

Every dish sold, with its category: Item, Category, Quantity, Gross sales, Item offers, After item offers, Returned qty, Returned value, Net qty, After returns, Share of gross and Average price. Average price includes add-ons and is before item offers.

People with Costs and margins access also see Dish cost and Margin columns, here and in the Category summary and the menu and category table of the Menu-wise summary. Owners and accountants have it by default; managers only when the owner turns it on (Team → Staff → Roles → Manager → Choose what managers see). Dish cost comes from the food cost on your menu items or their recipes; see Recipes and food cost.

For which dishes to push, reprice or drop, see Menu engineering in Analytics.

Two tables:

  • By menu: sales per menu (for example food, bar, breakfast), with the same columns as the Category summary.
  • By menu and category: each menu split into its categories.

Sizes & add-ons

Two tables:

  • Sizes (variants): Item, Size / variant, Quantity and Gross sales. The value is the whole line's value, add-ons included.
  • Add-ons: Add-on group, Add-on, Quantity and Add-on value, which is what the add-ons added to the price. A free add-on shows 0.

See Sizes and add-ons.

How item figures add up

  • Gross sales is before discounts and without tax. With all order types, the Gross sales total of the Category, Item and Menu-wise summaries adds up to Gross sales on the Executive summary for the same period and outlet. At an outlet whose prices include tax, item values are shown without the tax and can differ from Gross sales by a few paise from rounding.
  • Item offers are discounts on a single line, such as a happy hour price. After item offers is Gross sales minus them.
  • Bill discounts (manual discounts, order offers and loyalty points) are taken off the whole bill. They are not spread across items, so the item reports don't show them. You find them on the Executive summary and in Bill-wise sales.

Returned dishes

When a refund on a bill that was already paid lists the dishes that came back, the reports show them against those dishes: Returned qty and Returned value, then Net qty (Quantity − Returned qty) and After returns (After item offers − Returned value). A return counts on the day the refund was given, even when the dish was sold on another day. Its value is the dish's share of the refund's sales value, before tax, counted the same way as After item offers (before bill discounts). A refund that doesn't name any dish is shown in a last row, Returns not tied to a dish, with a value only. After returns is after item offers and returns, and before bill discounts, so it is not the Net sales of the Executive summary. Sales returns (refunds) in general are explained in What these numbers mean. The Sizes & add-ons report doesn't show returns.

Deleted dishes and moved categories

  • A dish that has since been deleted from the menu shows under No longer on the menu, so its sales are never lost.
  • Categories and menus are the dish's current ones. If you moved a dish to another category, its past sales show under the new category.

Common questions about item reports

Why doesn't the item total match Net sales? Item reports show sales before bill discounts, so their Gross sales total matches Gross sales on the Executive summary, not Net sales. Their After returns column also leaves out bill discounts, so it is higher than the Executive summary's Net sales by those.

Why are Dish cost and Margin missing? You don't have Costs and margins access, or the dishes have no food cost yet.

A dish I deleted is missing from its category. Look under No longer on the menu.

New to AirQR?

Try everything free for 28 days, no card needed. Already a customer? Sign in to follow these steps in your dashboard.

Still stuck? Contact support at support@airqr.in.