AirQR
Reports & analytics

Sales reports (executive summary, bill-wise, day-wise, hourly, channels)

What the Executive summary, Bill-wise sales, Day-wise sales, Hourly sales and Order types & channels reports show, and how they add up.

7 min read

With Game Zone on, the Sales family also has Game sessions and Station utilisation. Game time is part of the Executive summary, Bill-wise, Day-wise and Hourly sales like any other line, and is not in the item reports.

The Sales reports in Reports count settled bills, by the time they were settled, in business days. Sales returns (refunds), the refunds given on bills that were already paid, are taken off on the day they were given. Open checks and cancelled orders are not sales. For the period, times and outlet filters, see Reports. What each term means and how the lines add up: What these numbers mean.

Executive summary

One page for the period, with the same figures as the X / Z report: it is built with the Z report's own calculation. Downloads: PDF, Excel and CSV. The four cards at the top show Net sales, Total sales, Collected and Bills settled.

  • Sales, in the order of the Z report: Bills settled, Gross sales (before discounts, without tax), Manual discounts, Offers and Loyalty points (when used), Discounts & complimentary, "of which complimentary bills" (with the count, when you gave free bills), Sales returns (refunds) with the count (when there were any), Net sales, Service charge, Delivery & packaging, Card charges (when used), each tax line (for example CGST @ 2.5%), Taxes, Recorded platform tax · externally invoiced (when you record platform orders the platform invoices), Round off, Total sales, Tips, then Voids (count and value) and Cancelled orders (count and value), which are not sales. At an outlet whose prices include tax the row reads Taxes (included in prices); Gross sales, discounts and charges are shown without the tax inside them.
  • Payments: count and amount for each payment mode (Cash, Card, UPI, Online (prepaid), Other; modes with no payments are left out, except Cash), tips included, then Collected. When refunds were given: Refunds by cash, Refunds by card, Refunds by UPI, Refunds by bank transfer or Refunds by other means, then Refunds paid, split into "of which sales returns" and "of which payment corrections" (money given back on a check that was still open) when there were both, and Net collected.
  • Order types: bills and total sales for dine-in, takeaway and delivery, after sales returns.
  • Channels: how many bills came from the POS, QR (table) and Online, plus Swiggy, Zomato and Other platform orders with their totals.
  • Guests: Covers (dine-in guests) and Average bill (without tips).
  • Expenses (only for people who can see expenses): Expenses paid, Money returned, Net expenses and Net recorded collections. See Daily expenses.

Use it for the owner's daily or monthly look, or to send to a partner or accountant. The Executive summary has no order type filter: it always covers every order type.

Bill-wise sales

Every settled bill in the period, one row each, with a total row. Downloads: Excel and CSV. Filter by order type.

Columns: Bill no, Order, Settled (date and time), Outlet (with All outlets), Type, Channel, Table, Covers, Guest, Gross sales, Discounts & complimentary, Net sales, Service charge, Delivery & packaging, Card charges, Taxes, Round off, Total sales, Tips, Returned (to date), Paid by and Opened by.

Each bill is listed as it was settled. Returned (to date) shows the refunds on that bill up to now, so you can look the bill up; the refund itself is taken off on the day it was given, in Sales returns on Day-wise sales and the Executive summary. The figure Sales returns in period at the top shows the period's refunds on paid bills, and the total row adds up the bills only.

Use it to find a bill, check the discounts given, or hand your accountant a bill list for the period. The screen shows the first 2,000 bills; the download has up to 100,000.

Day-wise sales

One row per business day (Business date), with Bills, Gross sales, Discounts & complimentary, Sales returns (refunds), Net sales, Service charge, Delivery & packaging, Card charges, Taxes, Round off, Total sales, Tips and Average bill. Downloads: Excel and CSV. Filter by order type.

Late-night bills count on the business day they belong to (see the business day in Reports), so the day rows add up to the period with no gap or overlap. Sales returns count on the day the refund was given, so a day that only has refunds still gets a row, and its Net sales can be below zero. The original day is not changed.

Hourly sales

Bills by the hour they were settled, in the outlet's time zone: Hour, Bills, Covers, Sales returns (refunds), Net sales, Total sales, Share of net sales and Average bill (without tips). Downloads: Excel and CSV. Filter by order type.

Use it to plan staff and kitchen prep around the rush. The hour is when the bill was settled (for a refund, when it was given), not when the order was placed, so a long dinner counts in the hour it was paid. For orders by the hour they were placed, see Busy times in Analytics.

Order types & channels

Dine-in, takeaway and delivery, split by where the order came from: POS, QR order, Online, Kiosk, Swiggy, Zomato and Other platform. Columns: Type, Channel, Bills, Covers, Sales returns (refunds), Net sales, Taxes, Total sales, Share of net sales and Average bill. Downloads: Excel and CSV. A refund goes to the type and channel of the bill it was given on.

Covers are counted on dine-in bills only. Platform orders appear here when you record them in AirQR; see Platform orders.

How the sales reports add up

  • With all order types, the total row of Day-wise sales, of Hourly sales and of Order types & channels show the same bills, sales returns, net sales, taxes and Total sales as the Executive summary for the same period and outlet. The total row of Bill-wise sales adds up the bills as they were settled, so it equals those before sales returns.
  • Tips can differ a little: the bill reports show the tips on the bills settled in the period, while the Executive summary (like the Z report and Payment modes) shows the tips on payments taken in the period. A tip paid with an earlier part-payment, or on a bill settled the next day, moves between them; Total sales is the same in both.
  • Net sales is Gross sales minus Discounts & complimentary (manual discounts, offers, loyalty points and item offers) minus Sales returns (refunds). Total sales is Net sales plus service charge, delivery & packaging, card charges, taxes and round off, and does not include tips.
  • All of these are without tax down to Net sales, also at an outlet whose prices include tax.
  • Taxes include tax recorded on platform orders the platform invoiced itself; the Executive summary shows it on its own row.

Common questions about sales reports

Why is an open check not in the report? Only settled bills are sales. Settle or cancel it in Orders; it then counts at the time it was settled.

Why don't these match Analytics? They do: Analytics and the home screen use the same rules as the sales reports (bills counted when settled, in business days, refunds on the day given, without tax). Only Busy times counts orders by when they were placed. See Analytics.

A guest was refunded this week for a bill from last month. Which month changes? This one: the refund comes off Net sales on the day it was given. Last month's figures stay as they were.

Can I use the Executive summary for GST filing? No. Use GST & accounts, which counts bills by invoice date and makes the GSTR-1 files. See GST reports.

Why does the Executive summary differ from today's Z report? A Z report covers one drawer session, from opening to closing the drawer. Set the same start and end times on the Executive summary to compare. See X and Z reports.

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.