Staff reports (sales and collection by person, tips)
What the Staff sales & collection and Tips reports show, who is credited for a bill and a payment, why there is no per-waiter sales, and who can open Tips.
5 min read
The Staff reports in Reports show who handled the money: Staff sales & collection and Tips. Both can be viewed on screen and downloaded as Excel and CSV. For the period, times and outlet filters, see Reports.
Who opened the bill and who took the payment
AirQR records two people on a sale:
- Who opened the check: the person who started the bill at the POS.
- Who took each payment: the person who recorded the payment.
There is no assigned waiter on a bill. AirQR doesn't record which waiter served a table, so these reports are not "sales per waiter". A waiter who opens the check and a cashier who takes the payment each appear under their own name.
A bill or payment with no person belongs to a guest's own order or payment (a QR order, a kiosk order, an online payment) or to a staff account that has since been deleted. It shows as Guest / QR / kiosk (bills) or Guest / online (payments).
Staff sales & collection
Downloads: Excel and CSV. It has the order type filter (All order types, or tick Dine-in, Takeaway and/or Delivery). The cards at the top show Bills settled, Net sales and Collected. There are two tables, each with a total row.
Sales by who opened the bill counts settled bills by the time they were settled, like the sales reports. Columns: Staff, Role (their role in your business; a custom role shows its own name), Bills, Covers, Sales returns (refunds), Net sales, Taxes, Total sales, Tips and Average bill (without tips). A refund on a bill that was already paid is taken off the person who opened that bill, on the day the refund was given. The totals are the Executive summary's: the same bills, sales returns, net sales, taxes and total sales.
Collection by who took the payment counts payments by the time they were taken, whatever day the bill was settled. Columns: Staff, Payment mode, Payments, Amount, Tips and Collected (amount plus tips). The total is Collected on the Payment modes report and Collected on the Executive summary and the Z report.
With an order type chosen, the first table counts bills of that type and the second the payments taken on bills of that type.
Because bills count when they are settled and payments when they are taken, Collected can differ from Total sales: tips, an open check paid in part, a bill paid on another day, or a platform order the platform collected for. See Payment reports.
Tips
Tips taken in the period. Downloads: Excel and CSV. The cards show Tips and Payments with a tip. Two tables, each with a total row:
- Tips by who took the payment: Staff, Payments with a tip and Tips.
- Tips by table: Table (a delivery or takeaway shows No table (takeaway, delivery); with All outlets there is an Outlet column), Payments with a tip and Tips.
A tip counts when its payment was taken, whatever day the bill was settled. Both totals equal Tips on the Executive summary and the Z report for the same period.
The report shows who received the tip payment and which table it was on. It does not share tips out. To share tips by hours worked, use Tips split under Team (see Tips split and payroll export); AirQR doesn't move any money.
Who can open Tips
Tips is the one report that also needs access to staff pay, because it shows what each person received. You need See analytics and sales totals and See pay rates and labour cost (the same access as Tips split). By default owners, managers and accountants have both. Cashiers, waiters, captains and other roles don't have Reports at all. If the owner switches off See pay rates and labour cost for managers (Team → Staff → Roles → Manager → Choose what managers see), a manager keeps the other Reports but not Tips, and its download is refused too. See Staff roles: who sees what.
When Tables is off
The Tips report shows tips by table only while Tables is on at an outlet in the report. With Tables off everywhere in the report, only Tips by who took the payment is shown. The total is the same.
Common questions about staff reports
Is this sales per waiter? No. AirQR records who opened a check and who took each payment, not which waiter served the table. If your waiters open their own checks at the POS, the first table shows what each opened.
Why is a person's Collected different from their Net sales? One counts the bills a person opened, the other the payments a person took. A waiter may open bills that a cashier collects.
Why is there a row for Guest / QR / kiosk? Bills a guest placed by QR or on a kiosk have no staff member.
Why can't I see Tips? Your role doesn't have See pay rates and labour cost. Ask the owner to change it in Team → Staff → Roles.
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.