Reports (sales, items, staff, payments and operations)
Open sales, item, staff, payment and operations reports for any day or period, filter by business day, shift times, outlet and order type, and download them as Excel, CSV or PDF. Totals match the X / Z report.
11 min read
Reports (the Reports tab of Reports, beside GST and accounts) gathers the reports you need to check a day, a week or a month: what was sold, which dishes and categories sold, who sold and who collected, how the money came in, and how the restaurant ran. Every report shows on screen and downloads as Excel and CSV; the Executive summary, Payment modes, Settlement by counter and Outlet comparison also download as PDF. The totals use the same rules as the X / Z report, so the same period gives the same figures.
Reports is part of Analytics, which is on every plan.
Who can open Reports?
You need the See analytics and sales totals permission. By default:
| Role | Reports | All outlets together, up to 366 days | Dish cost and margin columns |
|---|---|---|---|
| Owner | Yes, all of them | Yes | Yes |
| Accountant | Yes | Yes | Yes |
| Manager | Yes, their outlet, up to 31 days | Only if the owner turns on Business-wide reports | Only if the owner turns on Costs and margins |
| Waiter, captain, cashier, kitchen and other roles | No | No | No |
These are the defaults. Owners can change any role in Team → Staff → Roles (for managers: Team → Staff → Roles → Manager → Choose what managers see), so what a person actually sees follows their role as the owner set it. Two reports ask for more: Tips also needs See pay rates and labour cost (on by default for owners, managers and accountants), and Outlet comparison needs Business-wide reports. Expense figures on the Executive summary appear only for people who can see expenses. See Staff roles: who sees what.
The reports
The Reports page groups the reports by what they are for. Open a card to see the report.
Sales (settled bills: what was sold, discounted, taxed and billed). See Sales reports.
- Executive summary: one page for the period with sales, discounts, sales returns (refunds), taxes, tips, payments, refunds and voids. PDF, Excel, CSV.
- Bill-wise sales: every settled bill with its discounts, charges, tax, tip and how it was paid. Excel, CSV.
- Day-wise sales: sales per business day, with discounts and sales returns. Excel, CSV.
- Hourly sales: bills and sales by the hour they were settled. Excel, CSV.
- Order types & channels: dine-in, takeaway and delivery by where the order came from. Excel, CSV.
- Game sessions and Station utilisation (only with Game Zone on): every session with its time, extra time, amount, who started and stopped it and any adjustment, and per station the hours played, the revenue and how much of the opening hours it was in use. Excel, CSV. Game time is in the sales totals but not in the item reports, which count dishes only.
Items (categories, menus, dishes, sizes and add-ons sold). See Item reports.
- Category summary, Item summary, Menu-wise summary and Sizes & add-ons, with the dishes that were returned. Excel, CSV.
Staff (who sold and who collected, and the tips). See Staff reports.
- Staff sales & collection: sales by who opened each bill, and money collected by who took each payment. Excel, CSV.
- Tips: tips taken, by staff member and by table. Needs access to staff pay. Excel, CSV.
Payments (money collected by payment mode, and refunds). See Payment reports.
- Payment modes: cash, card, UPI, online and other, with tips, refunds paid and net collected. PDF, Excel, CSV.
- Settlement by counter: the same money by counter (POS device), staff member and payment mode, and refunds by who recorded them. PDF, Excel, CSV.
- Refunds: every refund given, on which bill, how, why and by whom. Excel, CSV.
Operations (orders, discounts, voids, tables, deliveries and outlets). See Operations reports.
- Order report: every order created in the period, open, settled or cancelled. Excel, CSV.
- Discounts & complimentary bills: bills with a discount, offer, loyalty points or no service charge, and no-charge bills. Excel, CSV.
- Voids & cancellations: voided items and cancelled orders, with the reason and who. Excel, CSV.
- Covers & tables: dine-in bills, covers and sales per table and floor area. Excel, CSV.
- Delivery areas: delivery bills and sales by PIN code, city and zone. Excel, CSV.
- Outlet comparison: your outlets side by side. For a business with more than one outlet and Business-wide reports. PDF, Excel, CSV.
More reports elsewhere links to the reports that live on their own pages:
- GST & accounts (outside India: Tax & accounts): GSTR-1 files, HSN summary, bill numbers and Tally export for each GSTIN, by invoice date. Shown to people who can see GST & accounts. See GST reports.
- X and Z reports: the day-end cash-up of each cash drawer session. Shown to people who use the cash drawer. See X and Z reports.
Choosing the period
At the top of every report:
- Today, Yesterday, Last 7 days, This month, Last month, or Custom dates (choose From and To, then Apply). People with business-wide reports also get Last 30 days.
- A report covers up to 31 days at a time, or up to 366 days with Business-wide reports. A longer custom period keeps its most recent days.
- The period never goes past today.
The heading under the report title shows the outlet and the exact period, for example "Spice Place · 1 Oct 2026 – 31 Oct 2026".
Business day: why a 2 am bill counts on the day before
Every report counts in business days, like order numbers, the Orders page and the Z report. A business day starts at the time set in Settings → Outlet → Business day ends at (midnight unless you changed it): the moment one business day ends, the next one starts.
For example, a bar with 04:00 counts a bill settled at 02:30 on 13 October on 12 October, the night it belongs to. Day-wise sales then has one row per business day, and the rows add up to the period.
Covering one shift: start and end times
The times button (it reads Whole day until you set a time) narrows the period:
- Start time (first day): the report starts at this time on the first day.
- End time (last day): the report ends at this time on the last day.
- Leave both empty for the whole business day. Times go in 15-minute steps.
- A time before the business day start belongs to the night after that date. With a 04:00 day start, Today with an end time of 01:00 runs until 01:00 tonight.
For a lunch shift, choose Today, a start time of 12:00 and an end time of 16:00. For several days, the start time applies only to the first day and the end time only to the last day; it is not a daily shift filter.
Outlets and order types
- Outlet: people with business-wide reports and more than one outlet get an outlet button with All outlets. All outlets adds them up into one report (reports that list rows, such as Bill-wise sales, Refunds and the Order report, get an Outlet column). Outlet comparison is always across all outlets: open from the Reports page it already has All outlets chosen. Outlets that use different currencies can't be added up, so the report asks you to choose one outlet at a time. Everyone else sees their current outlet.
- Order types: Bill-wise sales, Day-wise sales, Hourly sales, the four item reports, Staff sales & collection, the Order report and Discounts & complimentary bills have an order type button (All order types by default). Tick Dine-in, Takeaway and/or Delivery to see only those.
Every filter is kept in the page address, so you can bookmark a report or send the link to someone who has access to Reports.
What counts in Reports
Reports use the same rules as the X / Z report:
- Sales are settled bills, counted when they were settled. Open checks and cancelled orders are not sales.
- Payments count when they were taken and refunds when they were given, whatever day the bill was settled.
- Sales returns (refunds), the refunds given on bills that were already paid, are taken off Net sales on the day they were given. The day the bill was settled is not changed.
- Voided items count at the time they were ordered, whether the whole line or only part of it was voided, and cancelled orders at the time they were cancelled. A check merged into another is not a cancelled order.
- The Order report is the exception: it counts every order by when it was created, whatever its status.
- Bills opened by a person and payments taken by a person are separate: AirQR records who opened a check and who took each payment, not which waiter served it. See Staff reports.
- Offline sales from a till that lost its connection count at the till's own time, once they sync. A report you opened before the sync changes when you open it again.
- Prices include tax: at an outlet whose prices include tax, Gross sales, discounts and charges are shown without the tax inside them, so Net sales is without tax, and the row reads Taxes (included in prices).
What each term means and how the lines add up (Gross sales − Discounts & complimentary − Sales returns = Net sales, and so on down to Total sales) is in What these numbers mean.
Downloading and printing a report
The buttons at the top right of each report:
- Excel: an .xlsx workbook with the AirQR banner, the report heading, outlet, period and when it was generated, then each table with a bold total row. Amounts are real numbers, so you can sum and filter them in Excel.
- CSV: UTF-8, so ₹ and Hindi or other Indian-language names open correctly in Excel. Like every AirQR CSV it has the AirQR attribution column (Powered by AirQR | airqr.in).
- PDF (Executive summary, Payment modes, Settlement by counter and Outlet comparison): an A4 page with the AirQR mark, ready to file or send.
- Print: your browser's print window, A4 landscape. You can also choose Save as PDF there.
Downloads cover exactly the period, outlet and order types on screen. File labels are in English, like all AirQR exports, so accountants and spreadsheets can read them. The screen shows up to 2,000 rows; when there are more, it says so, and the download has up to 100,000. Downloads keep working for a while after a plan ends, like your other data exports. See Exporting your data.
Common questions about Reports
In the AirQR app
Owners, managers and accountants with See analytics and sales totals can open More → Reports in the AirQR app. It lists the same reports as the website (except the outlet comparison and the Routes reports) for the outlet you are working in. Choose Today, Yesterday, 7 days, 30 days or This month: the figures and rows are the website's, counted the same way, so they match the Z report. On a tablet the list and the report sit side by side.
The app is for looking. Excel, CSV and PDF downloads, custom dates beyond 92 days and All outlets stay on the website. A long report shows its first 500 rows and says so.
Why don't Reports match Analytics? They use the same rules: settled bills counted when they were settled, in business days, refunds on the day they were given, and sales without tax. For the same period and outlet Net sales is the same figure. They can differ in the period you pick (Analytics offers Today, 7, 30 or 90 days), and Busy times in Analytics counts orders by when they were placed. See Analytics.
Why don't Reports match GST & accounts? GST reports count bills by their invoice (bill) date: when the check was settled and its bill numbered. Reports and the Z report count when the bill was settled. For a day the totals can differ. File GST from GST & accounts, not from Reports. See GST reports.
Do Reports match the Z report? Yes, for the same period and outlet. The Executive summary is built with the Z report's own calculation. A Z report covers one drawer session (from opening to closing the drawer), so choose the same start and end times to compare.
Why is Collected different from Total sales? Total sales is what settled bills came to, without tips, after sales returns. Collected is the money taken in the period, tips included. They differ by the tips, when an open check was paid in part, when a bill was paid on another day, and for platform orders where the platform collected the money. Net collected is Collected minus Refunds paid.
Why don't I see Reports in the menu? Your role doesn't have See analytics and sales totals. Ask the owner to change it in Team → Staff → Roles.
Why don't I see Tips or Outlet comparison? Tips needs See pay rates and labour cost besides the report access, and Outlet comparison needs Business-wide reports and a business with more than one outlet. Ask the owner to change it in Team → Staff → Roles.
Why can't I choose All outlets or more than 31 days? That needs Business-wide reports. Owners and accountants have it by default; owners can turn it on for managers in Team → Staff → Roles → Manager → Choose what managers see.
The screen says it is showing the first 2,000 rows. Download the report for every row, or choose a shorter period.
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.