What these numbers mean (net sales, refunds, total sales)
What Gross sales, Net sales, Refunds, Total sales, Tips and the other sales numbers mean on the home screen, Analytics, the Z report, Reports and exports, how they add up, and which day each one counts on.
13 min read
AirQR uses the same words, in the same order, on the home screen, Analytics, the X / Z report, Reports, the exports and the AI Analyst. This article explains them in plain words first. The last part, For your accountant, has every term, the exact lines and the dating rules.
The small ⓘ beside a headline number opens a one-line explanation and a link to this article.
The short version
- Gross sales: what your dishes sold for at menu price, before anything is taken off, and without tax.
- Take off Discounts (manual discounts, offers, loyalty points, free bills) and Refunds (money you gave back on bills that were already paid). What is left is Net sales.
- Add what the bill charged on top (Service charge, Delivery & packaging, Card charges), the Tax and Round off. That is Total sales: what the bills came to.
- Tips are shown on their own line. They are never part of sales.
| Example | |
|---|---|
| Gross sales | ₹10,000 |
| − Discounts | −₹500 |
| − Refunds | −₹300 |
| = Net sales | ₹9,200 |
| + Service charge | ₹460 |
| + Delivery & packaging | ₹100 |
| + Taxes | ₹480 |
| = Total sales | ₹10,240 |
| Tips (separate) | ₹200 |
A refund comes off on the day it is given
Guests sometimes ask for money back after paying. AirQR never changes the day the bill was paid. The refund is a new event: it is taken off on the day you gave it.
Example: a bill of ₹1,000 food plus ₹50 GST (₹1,050) is paid on Monday. On Wednesday you refund ₹525, half of it.
| Monday | Wednesday | |
|---|---|---|
| Net sales | ₹1,000 | −₹500 (the refund's share of the food) |
| Tax | ₹50 | −₹25 |
| Total sales | ₹1,050 | −₹525 |
Wednesday can show a negative number when more was refunded than sold that day. That is correct: it is not hidden or set to zero. This is how other billing systems and accounting standards treat a refund too: see the sources at the end.
Only money given back on a bill that is already paid is a refund in the sales numbers. Money given back while a check is still open (for example a payment you entered wrongly) is a payment correction. It changes what was collected, not the sales.
The words, one by one
| You see | It means |
|---|---|
| Gross sales | What your dishes sold for at menu price, before discounts and tax. |
| Discounts | Money taken off bills: manual discounts, offers, loyalty points and free (complimentary) bills. Reports and exports call it Discounts & complimentary. |
| Complimentary | Bills given free: paid with nothing left to pay after discounts. Shown under Discounts as "of which complimentary bills". |
| Refunds | Sales value given back on bills already paid, on the day the refund was given, before tax. Reports, the Z report and exports call it Sales returns (refunds). |
| Net sales | What you sold after discounts and refunds, before tax. |
| Service charge | Service charge on bills, after refunds. Not part of net sales. |
| Delivery & packaging | Delivery and packaging charges, after refunds. |
| Card charges | Surcharge for paying by card, after refunds. |
| Tax | Tax charged on bills, less tax on refunds. Reports and exports call it Taxes. |
| Round off | Rounding of bill totals to a whole amount. |
| Total sales | Net sales plus charges, tax and round off: what bills came to, without tips. |
| Tips | Tips received, less tips given back. Never part of sales. |
| Voided items | Items removed from a bill before it was paid. Not sales. |
| Cancelled orders | Orders closed without payment. Not sales. |
| Collected | Money received by every payment mode, including tips. |
| Refunds paid | All money given back, including corrections on open bills. |
| Net collected | Collected minus refunds paid. |
Why is my Net sales lower than before?
Since this change the home screen and Analytics use the same rules as the Z report. Compared with what they showed before:
- Net sales is without tax, so it is lower by about the tax. It is also without service charge and tips.
- All discounts are taken off: manual discounts, offers, loyalty points and item offers. Before, some of them were missed.
- Refunds are taken off on the day they were given.
- A bill counts when it is paid (settled), not when the order was opened.
- The day is your business day, which starts at the time set in Settings → Outlet → Business day ends at, not at midnight.
At an outlet whose prices include tax, sales, discounts and charges are shown without the tax inside them. The tax is shown on its own line, Taxes (included in prices) on reports.
Which day does each thing count on?
| What | Counts on |
|---|---|
| A paid (settled) bill | The time it was paid, on the outlet's business day |
| A refund on a paid bill | The day the refund was given. The day of the original bill is not changed |
| A payment or a refund of money | The time it was taken or given |
| A voided item | The time it was ordered |
| A cancelled order | The time it was cancelled. A check merged into another is not a cancellation |
| Open checks | Not sales until they are paid |
The business day starts at the outlet's day start. With a 04:00 day start, a bill paid at 02:30 counts on the day before. Each outlet uses its own day start and time zone.
Where you will see them
- Home: Net sales today compared with the same time last week, the sales by the hour bills were paid, and Bills settled today.
- Analytics: Net sales with the waterfall Gross sales, Discounts, Refunds, Net sales, Service charge, Delivery & packaging, Card charges, Tax, Round off, Total sales, Tips. See Analytics.
- X / Z report: the same lines for a drawer session. See X and Z reports.
- Reports: the sales, items, staff, payment and outlet reports. See Reports.
- Orders page: Settled is what the listed bills came to without tips. It is a lookup of those orders, not the period's sales. Refunded on these orders is the refunds on them, whenever they were given. See Orders page.
- Exports: the columns follow the same lines in the same order. See Exporting your data.
- AI Analyst: "sales" means net sales. See AI Analyst.
Common questions
Why doesn't Total sales equal what I collected? Collected includes tips and money for bills paid on another day, and leaves out checks not yet paid, platform orders the platform collected for, and refunds you gave. Net collected is Collected minus Refunds paid.
Why isn't service charge in Net sales? Net sales is what you sold from the menu. Service charge is a charge on top, so it has its own line. See the reasons below.
Why do the GST page and Net sales show different figures? They answer different questions. See "GST page" below.
A refund was given today for a bill from last month. Which month changes? Today's. Last month's figures stay as they were.
For your accountant
The lines, in order
The Z report, the Executive summary, Day-wise sales and the exports show these lines in this order:
Gross sales − Discounts & complimentary (Manual discounts, Offers, Loyalty points; memo: of which complimentary bills) − Sales returns (refunds) = Net sales + Service charge + Delivery & packaging + Card charges + Taxes (each tax line above it) + Round off = Total sales (without tips) Tips (separate) Not in sales: Voids (count, value) · Cancelled orders (count, value) Payments: Collected → Refunds paid (of which sales returns / payment corrections) → Net collected
Identities, which hold on the Z report, the Executive summary, Day-wise sales, the Analytics waterfall and the exports:
- Gross sales − Discounts & complimentary − Sales returns (refunds) = Net sales.
- Net sales + Service charge + Delivery & packaging + Card charges + Taxes + Round off = Total sales.
- Net collected = Collected − Refunds paid.
- The day rows add up to the period, and the outlets add up to all outlets.
- For the same business day, Analytics and the Z report show the same Net sales.
Terms and their report labels
Screens use the plain word and reports, the Z report and exports use the accountant's label. The meaning is the same.
| Screen | Reports, Z report, exports | Meaning |
|---|---|---|
| Gross sales | Gross sales | What dishes sold for at menu price, before discounts and tax. |
| Discounts | Discounts & complimentary | Manual discounts, offers, loyalty points, item offers and complimentary bills. |
| Complimentary | Complimentary bills | Settled bills with an item value above zero and nothing left to pay after discounts. |
| Refunds | Sales returns (refunds) | Sales value given back on settled bills, on the day it was given, before tax. |
| Net sales | Net sales | Gross sales less discounts and sales returns, before tax. |
| Service charge | Service charge | Service charge on bills, after the returns' share. |
| Delivery & packaging | Delivery & packaging | Delivery fee and packaging charge, after the returns' share. |
| Card charges | Card charges | Card surcharge, after the returns' share. |
| Tax | Taxes | Tax on bills less the returns' share, per tax line. Tax recorded on platform orders the platform invoiced itself has its own row on the Z report. |
| Round off | Round off | The rounding of the bills (the sum of each settled bill's round off). Shown when it is not zero. |
| Total sales | Total sales | Net sales plus charges, taxes and round off. Tips are not in it. |
| Tips | Tips | Tips received, less tips given back with a refund. Never part of sales. |
| Voided items | Voids | Items removed before payment. Not in gross sales. |
| Cancelled orders | Cancelled orders | Orders cancelled without payment, with their items value before discounts and tax. Not in gross sales. |
| Collected | Collected | Payments taken in every mode, with tips. |
| Refunds paid | Refunds paid | Every refund given: sales returns and corrections on open checks. |
| Net collected | Net collected | Collected − Refunds paid. |
How a refund is split
A refund is one amount that can include tax and a tip. AirQR splits it from the original bill:
- The tip part. If you enter Of which tip in the refund window, that part is a tip given back. If you leave it empty, anything above the bill's invoice value (the bill total without tip) is taken as the tip. A tip is never part of sales or tax, and a tip-only refund is not a sales return.
- The rest is shared between net sales, service charge, delivery & packaging, card charges and tax, in the same proportions as on the bill. Round off has no share of its own: it is spread over the others. The parts add up to the refund exactly (largest remainder, whole paise).
- Tax is split per tax line, so each line's tax goes down by its share.
- Tax recorded on a platform order the platform invoiced itself goes down on the platform tax row, not on Taxes.
Each refund on a settled bill is also a numbered GST credit note (see GST credit notes). On the India GST page the credit note is more exact than these proportions: items you pick under Which items? come off at their own tax class and rate, and a refund of everything that is left reverses the original bill exactly, round off included. The tip rule is the same everywhere.
Dating
- Settled bills at the time they were settled, on the outlet's business day (its day start, in its time zone). An offline sale counts at the till's own time, once it syncs.
- Sales returns at the time the refund was given. A day that has only returns gets its own row, with negative figures if returns are larger than sales.
- Payments and refunds of money at the time they were taken or given.
- Voids at the time the item was ordered, for a whole line or a part of it.
- Cancelled orders at the time they were cancelled. A check merged into another is not a cancellation and is not counted. The lines of a cancelled order stay as they were, so voids and cancellations never count the same item twice.
- Open checks are not sales until they are settled.
A Z report closed before sales returns were added to the report keeps its old layout: it still reads Total billed, with tips above it and no returns row, and Total collected and Refunds total in the payments and refunds blocks. A closed Z report is never rewritten.
Tax-inclusive outlets
Where prices include tax, the stored subtotal, discounts, service charge and charges contain the tax. Sales reports take the tax out of each of them, class by class, and show it on the Taxes line (reports label it Taxes (included in prices)). So Gross sales − Discounts & complimentary − Sales returns = Net sales is without tax in every outlet. Item reports show item values without tax too, and can differ from Gross sales by a few paise from rounding.
Why service charge is outside Net sales
- Systems differ. Toast counts service charges inside gross sales, Square lists them in their own section, and Shopify keeps fees outside net sales.
- Indian practice is to show item sales separately from the service charge, container charge and delivery charge. Under the Central Consumer Protection Authority's guidelines of July 2022, a service charge is voluntary and often passed on to staff.
- GST still taxes it as part of the value of supply. That is why the GST page's taxable value includes it.
- So Net sales is the item sales figure. Total sales includes every charge. Both are shown, so either reading is available.
GST page and Net sales differ by design
GST & accounts (India) is for filing and follows tax rules, not the sales summary:
- It counts bills by their invoice date: when the check was settled and its bill numbered. The sales reports count the settle time on the business day.
- Its Sales under GST card is the whole taxable value of the bills that carry GST: items less discounts plus service charge, delivery & packaging and card charges. Net sales leaves those charges out.
- Refunds come off in the month their credit note was issued (the day of the refund), split into taxable value and GST. The two headline cards, Sales under GST and GST to pay, are shown after credit notes, with a "Credit notes netted off" line under GST to pay. The sales register, the other summaries and the Tally export are not changed. Liquor at state VAT is in its own card, Non-GST sales (liquor), and is never added to the GST figures. The page works by GSTIN: outlets that share a GSTIN are added together.
So use GST & accounts to file and the sales reports to run the business. See GST reports.
How this compares with other systems
Gross sales − discounts − returns = net sales, with tax and tips outside, is the usual layout. Refunds are taken off on the day they are given, and the original day is not restated.
- Toast: Sales Summary FAQ and how refunds affect sales reports.
- Shopify: Finances report, where sales reversals come off net sales.
- Lightspeed: Z and X reports: sales, discounts, returns, then net sales.
- Square: glossary.
- Accounting: returns and discounts are contra-revenue, net sales = gross sales − discounts − returns (OpenStax, Principles of Accounting).
- India GST: a credit note goes in the return of the month it is issued (within the time limit of 30 November after the bill's financial year), and B2C small supplies are reported net of credit notes (GSTR-1 FAQ).
Related: Reports, Sales reports, X and Z reports, Analytics.
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.