AirQR
Reports & analytics

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

  1. Gross sales: what your dishes sold for at menu price, before anything is taken off, and without tax.
  2. 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.
  3. 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.
  4. 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.

MondayWednesday
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 seeIt means
Gross salesWhat your dishes sold for at menu price, before discounts and tax.
DiscountsMoney taken off bills: manual discounts, offers, loyalty points and free (complimentary) bills. Reports and exports call it Discounts & complimentary.
ComplimentaryBills given free: paid with nothing left to pay after discounts. Shown under Discounts as "of which complimentary bills".
RefundsSales 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 salesWhat you sold after discounts and refunds, before tax.
Service chargeService charge on bills, after refunds. Not part of net sales.
Delivery & packagingDelivery and packaging charges, after refunds.
Card chargesSurcharge for paying by card, after refunds.
TaxTax charged on bills, less tax on refunds. Reports and exports call it Taxes.
Round offRounding of bill totals to a whole amount.
Total salesNet sales plus charges, tax and round off: what bills came to, without tips.
TipsTips received, less tips given back. Never part of sales.
Voided itemsItems removed from a bill before it was paid. Not sales.
Cancelled ordersOrders closed without payment. Not sales.
CollectedMoney received by every payment mode, including tips.
Refunds paidAll money given back, including corrections on open bills.
Net collectedCollected 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?

WhatCounts on
A paid (settled) billThe time it was paid, on the outlet's business day
A refund on a paid billThe day the refund was given. The day of the original bill is not changed
A payment or a refund of moneyThe time it was taken or given
A voided itemThe time it was ordered
A cancelled orderThe time it was cancelled. A check merged into another is not a cancellation
Open checksNot 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.

ScreenReports, Z report, exportsMeaning
Gross salesGross salesWhat dishes sold for at menu price, before discounts and tax.
DiscountsDiscounts & complimentaryManual discounts, offers, loyalty points, item offers and complimentary bills.
ComplimentaryComplimentary billsSettled bills with an item value above zero and nothing left to pay after discounts.
RefundsSales returns (refunds)Sales value given back on settled bills, on the day it was given, before tax.
Net salesNet salesGross sales less discounts and sales returns, before tax.
Service chargeService chargeService charge on bills, after the returns' share.
Delivery & packagingDelivery & packagingDelivery fee and packaging charge, after the returns' share.
Card chargesCard chargesCard surcharge, after the returns' share.
TaxTaxesTax 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 offRound offThe rounding of the bills (the sum of each settled bill's round off). Shown when it is not zero.
Total salesTotal salesNet sales plus charges, taxes and round off. Tips are not in it.
TipsTipsTips received, less tips given back with a refund. Never part of sales.
Voided itemsVoidsItems removed before payment. Not in gross sales.
Cancelled ordersCancelled ordersOrders cancelled without payment, with their items value before discounts and tax. Not in gross sales.
CollectedCollectedPayments taken in every mode, with tips.
Refunds paidRefunds paidEvery refund given: sales returns and corrections on open checks.
Net collectedNet collectedCollected − 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.

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.