Operations reports (orders, discounts, voids, tables, delivery areas, outlets)
What the Order report, Discounts & complimentary bills, Voids & cancellations, Covers & tables, Delivery areas and Outlet comparison reports show, and what each one counts and adds up to.
6 min read
The Operations reports in Reports look at how the restaurant ran: every order, discounts, voids and cancellations, tables, deliveries and outlets. Each downloads as Excel and CSV, and Outlet comparison also as PDF. For the period, times and outlet filters, see Reports.
Order report
Every order created in the period, whatever became of it: Open, Settled or Cancelled. It has the order type filter. The cards at the top show Orders, Open, Settled and Cancelled; they count the whole period even when the list is cut short.
Columns: Bill no (empty until the order is settled), Order, Created, Outlet (with All outlets), Type, Channel, Table, Status, Payment (Unpaid, Part-paid, Paid, Part-refunded, Refunded or Platform handled), Total, Paid, Refunded and Balance due.
- Paid is the money received on the order, minus refunds. Refunded is money given back after the bill was settled.
- Balance due is what an open check still owes. It is 0 for settled and cancelled orders, and for platform orders the platform collects for.
- The total row adds every order shown, whatever its status. It is not sales: for sales use the sales reports.
- Orders count by when they were created, unlike the sales reports, which count bills by when they were settled. An order created late one night and settled after midnight can sit in two different periods.
The screen shows up to 2,000 orders and the download up to 100,000. When the list is cut short, the total row is left out.
Discounts & complimentary bills
Settled bills (counted when they were settled) that have a manual discount, an offer, loyalty points, or the service charge taken off. It has the order type filter.
Amounts are without tax, like Gross sales and Discounts on the Z report. Columns: Bill no, Order, Settled, Gross sales, Manual discount, Reason (the one typed with the discount), Offers (the offers that gave a discount on the bill), Offer discount, Loyalty points, Service charge waived, Net sales and Complimentary.
- Offer discount includes offers on single items (a happy-hour price) as well as offers on the whole bill, such as a coupon.
- A bill is Complimentary (no charge) when its Net sales are 0 after discounts but its gross sales are not. A charge that isn't part of the food, such as a delivery fee, can still be left to pay on such a bill. The Executive summary and the Z report show the count and the discount on these bills as "of which complimentary bills", under Discounts & complimentary.
- The totals of Manual discount, Offer discount and Loyalty points are Manual discounts, Offers and Loyalty points on the Executive summary and the Z report for the same period.
Voids & cancellations
Two tables. Downloads: Excel and CSV. The cards show Items voided, Value voided, Orders cancelled and Value cancelled for the whole period.
Voided items: each item taken off a check after it was ordered. Columns: Ordered (when the item was ordered), Outlet (with All outlets), Bill no, Order, Item, Qty, Value, Reason and Voided by. Voided items count by the time they were ordered, as on the Z report, whether the whole line or only part of it was voided. The totals are the Z report's Items voided (quantity and value).
Voided by shows the person only when the activity log has a record for that very line. When only part of a line was voided (one of three Lassi), or the line was cancelled together with its whole order, it is left empty. AirQR doesn't guess.
Cancelled orders: orders cancelled in the period, counted by the time they were cancelled. Columns: Order, Created, Cancelled, Outlet (with All outlets), Type, Value, Cancelled by (a staff member's name, Guest or System) and Reason. Value is the items value of the order before discounts and tax. A check merged into another is not a cancellation and is not listed. The count and value are Cancelled orders on the Z report. Voids and cancelled orders are not sales.
Covers & tables
Dine-in bills, counted when they were settled, per table and floor area. Columns: Area, Table, Outlet (with All outlets), Seats, Bills, Covers, Net sales, Net per cover and Average minutes seated. The cards show total Covers and Net per cover. Sales here are before sales returns (refunds), which are not tied to a table.
- Covers are the guests entered on the bill. The total is Covers (dine-in guests) on the Executive summary. A bill without a guest count adds none.
- Average minutes seated runs from when the check was opened to when it was settled.
- A bill with no table is under No table, and a table without a floor area under No area.
Delivery areas
Delivery bills (including platform orders), counted when they were settled, by PIN / postal code, City and Delivery zone, with Bills, Net sales, Total sales and Share of net sales. Bills are counted before sales returns (refunds).
The POS records the PIN code of a delivery; online orders also record the city and the delivery zone. Platform orders (Swiggy, Zomato) usually come without an address and are listed under Not recorded. The totals are the delivery bills of the Bill-wise sales report.
Outlet comparison
Your outlets side by side for the period: Bills, Covers, Sales returns (refunds), Net sales, Taxes, Total sales, Collected (payments taken at that outlet), Refunds paid (every refund given at that outlet), Net collected (Collected − Refunds paid), Average bill and Share of net sales. Downloads: PDF, Excel and CSV.
It appears only for a business with more than one outlet, and only for people with Business-wide reports (owners and accountants by default; managers only if the owner allows). Open it from the Reports page and it already has All outlets chosen. With a single outlet chosen it asks you to choose All outlets. Outlets that use different currencies can't be compared. The totals are the all-outlets Executive summary.
When Tables is off
Covers & tables belongs to the Tables module. It is hidden from the Reports page, and its download is refused, when Tables is off at every outlet you can see. In a business where at least one outlet uses tables, it stays and covers all outlets. Past bills keep their table name in the other reports. Covers still show in the totals.
Common questions about operations reports
Why does the Order report have more orders than Bills settled? It counts every order created in the period, including open and cancelled ones, while sales reports count only bills settled in the period.
Why is Voided by empty? The log has no record for that very line: usually a partial void, or a line cancelled with its order.
Why do voids count when the item was ordered but cancellations when they were cancelled? That's how the Z report counts them, and the reports match the Z report.
How do I find a no-charge (NC) bill? Open Discounts & complimentary bills and look for Complimentary: Yes. The reason typed with the discount is in Reason.
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.
Related articles
- AI Analyst, ask about your businessThe AI assistants (Business analyst and Inventory assistant) answer questions on your sales, dishes, guests, staff, cash, tax and stock in plain words with tables and charts. Figures come from your own data and are checked, and anything that can't be checked is marked. It can prepare a draft purchase order for you to confirm. Who can use it, what it costs and its limits.
- AI Insights on AnalyticsA short brief at the top of Analytics, built from your own numbers and checked, once a business day per outlet. What it covers, what it costs and how Ask about this works.
- Analytics and sales reportsRead your sales, orders, average bill, busy hours, channel and payment mix, QR scans, kitchen speed and ratings, compared with the previous period.
- Menu engineeringSee which dishes are Stars, Plowhorses, Puzzles or Dogs, and what to do about each.