Payment reports (payment modes, settlement by counter and refunds)
What the Payment modes, Settlement by counter and Refunds reports show, how they match the Z report, and why collected can differ from billed.
5 min read
The Payments reports in Reports count money when it was taken and refunds when they were given, whatever day the bill was settled. For the period and outlet filters, see Reports.
Payment modes
Money collected in the period by Cash, Card, UPI, Online (prepaid) and Other. Downloads: PDF, Excel and CSV. The cards at the top show Collected, Refunded and Net collected.
Columns: Payment mode, Payments (how many), Amount, Tips, Collected (amount plus tips), Refunds (how many), Refunded and Net collected (collected minus refunded), with a total row.
The figures match Payments and Refunds on the X / Z report for the same period. Refunds paid by bank transfer are listed with Online (prepaid).
With the Credit & dues module in use, bills put on a customer's credit and credit notes that reduce dues are not money collected or paid out, so they are not in these figures. They are shown below the table under Not money collected. See Give credit and collect dues.
The part of a bill paid from an advance (Paid by advance), and a refund that put it back on the advance, aren't money collected or paid out either: the advance's money was counted the day it was received. They are under Not money collected too. See Advances.
Use it to check the day's UPI and card totals against your bank or payment app, or to see how much cash came in.
Settlement by counter
The same payments and refunds as Payment modes, broken down by counter, staff member and payment mode. Downloads: PDF, Excel and CSV. The cards show Collected, Refunded and Net collected, which are the Payment modes figures for the same period.
Collection by counter and staff has one row per counter, person and payment mode. Columns: Counter (the POS device that recorded the payment, for example Counter 1 (C1)), Outlet (with All outlets), Staff (who took the payment), Payment mode, Payments, Amount, Tips and Collected.
- A counter is a POS device registered at the outlet, the browser or till the cashier signs in on. A payment taken in a browser that isn't a registered counter, or made by a guest online, shows Browser / no counter (and Guest / online for no staff member).
- A payment from a till that was offline counts at the till's own time and keeps its counter, once it syncs.
Refunds by who recorded them has one row per person and refund method, with Refunds and Refunded. Refunds aren't tied to a counter.
Use it to check what each counter and cashier should have collected at the end of a shift, next to the X and Z reports.
Refunds
Every refund given in the period, one row each, with a total row. Downloads: Excel and CSV.
Columns: Refunded (date and time), Outlet (with All outlets), Bill no, Order, Refunded by (the method: cash, card, UPI, bank transfer or other), Amount, Kind, Reason, Reference and Recorded by (the person who recorded it).
Kind is one of:
- Sales return: money given back after the bill was settled, with Record refund. It comes off Net sales (as Sales returns (refunds)) on the day it was given, and reduces GST in the month of the refund (see GST reports and What these numbers mean).
- Payment correction: money given back on a check that was still open, for example a payment taken twice. It only corrects what was paid; it is not a sales return.
See Recording payments and closing bills for how to record a refund.
Why is collected different from total sales?
Total sales (on the sales reports) is what the settled bills in the period came to, without tips and after sales returns. Collected is the money taken in the period, tips included. They differ when:
- tips were paid (they are collected but are not sales),
- an open check was paid in part (the payment counts now, the bill when it is settled),
- a bill was paid on another day than it was settled, or
- the platform collected the money for a Swiggy, Zomato or other platform order you recorded.
Refunds count on the day they were given, even for a bill settled earlier. Refunds paid is every refund given, and Net collected is Collected minus Refunds paid. Only the refunds on bills that were already paid (sales returns) also come off Net sales.
Common questions about payment reports
Does Cash collected equal the cash in my drawer? Not exactly. The drawer also has the opening float, cash in and cash out, and cash refunds paid from it. Use the Z report for the cash count. See X and Z reports.
Why does a refund show on a day with no sales for that bill? Refunds count when they were given, whatever day the bill was settled.
Why don't these match GST & accounts? GST reports count bills by invoice date, and only sales returns change GST. Use GST & accounts for filing. See GST 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.
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.