AirQR Routes reports, product sales, sales comparison, trip sheets, route sales, drivers, shops, collections, returns, van stock, losses, containers and the daily close
The fourteen reports of an AirQR Routes business (Product sales, Route sales, Shop sales, Sales comparison, Trip sheets, Driver performance, Van stock check, Product movement, Losses, Returns by product, Collection efficiency, Daily close, Containers and Containers by shop): where to open them, who can, the driver, route and shop filters, what every column means, how each figure is counted and how to download them as Excel or CSV.
20 min read
Analytics → Reports in the Routes menu gathers the reports you need to check your deliveries for a day, a week or a month: what each product earned, how this period compares with the one before, what each trip carried and brought back, what each route sold, how every driver did and how much they collected, what each shop bought and owes, how the products and the containers moved, what came back and why, what the vans came back short, and the whole business day by day. Every report shows on screen and downloads as Excel or CSV.
For one outlet and day, Trips shows actual fixed and open runs; open one for its elapsed time and the timeline of its bills and collections. Use Analytics → Reports for period comparisons and downloads. The trip’s duration ends when the driver ends the day, independently of when settlement was approved.
Where to find them
Open Analytics in the menu; the Reports tab next to it lists the reports of a Routes business under Routes, in four groups:
| Group | Reports |
|---|---|
| Sales | Product sales, Route sales, Shop sales, Sales comparison, Day-wise sales |
| Trips and vans | Trip sheets, Driver performance, Van stock check, Product movement, Losses, Returns by product |
| Money and dues | Collection efficiency, Daily close, Payment modes, Refunds, and the dues reports (Dues ageing, Credit and collections, Credit by staff) |
| Containers | Containers, Containers by shop |
The dues reports show only to people who can see credit, and a report your plan does not include is not listed. Restaurant reports such as tables and menus are not offered, because a Routes business has none of them.
The first card under Routes is GST and accounts. It opens Accounts, where GSTR-1, the HSN summary and the bill series are, by invoice date. There is no second GST report among the Routes reports. You see the card if you can open Accounts.
Choose the dates (and the outlet, if your business has more than one) at the top of a report. The reports count whole business days: a start or end time of day is not used. A day is the business day of the outlet, with its own day start, the same way as bills and the trip sheet.
Filter by driver, route or shop
Next to the dates, a Routes report offers the filters that make sense for it. Pick one name from the list (you can type to search); choose All drivers, All routes or All shops to take it off. The downloads keep the same filters.
| Report | Filters |
|---|---|
| Trip sheets, Van stock check, Losses, Collection efficiency | Driver, Route |
| Route sales, Product movement, Sales comparison | Route, Driver |
| Product sales, Returns by product | Route, Driver, Shop |
| Driver performance, Containers | Driver |
| Shop sales, Containers by shop | Route, Shop |
| Dues ageing | Shop |
| Daily close | none |
- On trip reports, a Driver or Route keeps only that driver's or that route's trips. Open trips in the route list keeps the trips that ran without a fixed route. While one of them is set, counter sales are left out, because the counter is not a trip.
- On shop reports, a Route keeps the shops that are active stops of that route, with all their bills (the counter's too). Not on a route keeps the shops that are on no route. Shop keeps one shop.
- On Product sales and Returns by product, Driver and Route keep those trips as on the trip reports, and Shop keeps that shop's bills (its counter bills too).
Who can open them
You need the See analytics and sales totals permission. By default owners, managers and accountants have it; drivers do not (they use the Driver app only). The owner can change this for each role in Team → Staff → Roles. See Reports for how periods, outlets and the limits per role work; they are the same for the Routes reports.
Six reports are part of Routes Plus: Route sales, Driver performance, Shop sales, Product movement, Sales comparison and Collection efficiency. On the Routes plan they are not offered, and during the free trial you have them. Product sales, Returns by product, Trip sheets, Van stock check, Losses, Containers, Containers by shop and Daily close are on both plans. See Routes plans and billing.
How the figures are counted
All the Routes reports follow the same rules, so they agree with each other, with the trip sheet at settlement and with the Routes home:
- Trips. A trip belongs to the business day it was loaded for, whatever its status except cancelled.
- Bills. Only route bills that were not cancelled are counted. The trip reports (Trip sheets, Route sales, Driver performance, Product movement, Product sales, Collection efficiency, Returns by product, Van stock check) count the bills attached to the period's trips. The day reports (Shop sales, Sales comparison, Containers, Containers by shop, Daily close) count a bill on the business day it was made.
- Sales is the bill total as billed, with tax included, before any credit note. Credit notes are shown separately (Daily close) and never taken off sales.
- Credit given is the credit part of a bill. Money collected later from a customer is collected or dues collected, never sales.
- Returns are goods a driver took back, counted in quantity on the trip that took them back (a Take back of goods sold on an earlier bill counts on today's trip), and returns inside a bill on that bill's trip. The money for them is a credit note on the bill the goods were sold on, counted as a refund on the day it was given.
- Found short is what an approved settlement found short: short stock at its value, short cash and the containers you charged. It is the same sum the Routes home shows. A trip that is not settled yet has no shortage.
- A driver's own dues (what a driver owes the business) are never part of a customer's figures.
A report shows its first 2,000 rows on screen; the download has all of them, or choose a shorter period. The totals row appears when the whole report fits on screen.
Counter bills count on the outlet business day when they were saved. Trip sheets and Daily close show a separate Counter table with bills, sales and cash, UPI, card and credit amounts. Route sales, Driver performance, Product movement, Product sales, Collection efficiency and Returns by product group counter sales under Counter (or count them in). Sales comparison counts them on their day. With a driver or route filter set, the counter is left out of all of them. Analytics separates Counter from No route, which includes open trips. Named customers count towards active customers. Walk-ins contribute sales and bills.
Product sales
One row per product, the product with the most net sales first, so the top of the sheet is your top movers. Both plans.
- Units sold, split into Crates and Loose as in Product movement.
- Gross is the lines as billed, before discount. Discount is the discount on them. Taxable value and GST come from each bill's own tax breakdown, shared over the lines of each tax class, so they add up to Sales by tax class and Tax in sales of Daily close.
- Net sales is each bill's total shared over its lines, so all the products together add up to the Sales of Route sales (Counter included) for the same period and filters. Share of sales is the product's part of that, and Average price for one is its net sales per unit.
- Units returned and Value returned are the goods taken back, as in Product movement, at the price they were billed at. Net after returns is net sales less that value, whether or not you have given the credit note yet.
Below it, Slow movers lists the products that still have stock in Main stock (as of now) and sold the least in the period, those with no sale first, with the units sold and the last day sold. Cost and margin are not shown yet: they wait until every product has a purchase cost.
Sales comparison
The period cut into rows, each set against the same stretch of the period just before (as long, ending the day before yours starts). Routes Plus.
- A period of up to 31 days has a row per day; up to 26 weeks, a row per 7 days from its first day; longer, a row per month.
- Bills, Shops billed (each shop once per row), Sales, Credit notes, Net sales (sales less credit notes), Dues collected and Credit given, then the same for the earlier stretch (Earlier from, Earlier to, Bills before and so on) and Change in net sales, which reads No sales before when there were none.
- Bills count on the business day they were made, as in Daily close; credit notes and dues collected on the day they were given. With no filter, Net sales for a day is the Total sales of Day-wise sales.
- In a row per month, the earlier stretch is the same days moved back by the length of your period, not the calendar month before.
- With a driver or route chosen, only the bills of their trips and the dues collected on those trips count, and the counter is left out.
Above the table you see the net sales of both periods and the change.
Collection efficiency
One row per driver, the driver who billed the most first, then the counter, and a second table Per route (open trips together, then the counter). Routes Plus.
- Trips and Billed (the trips' bills, tax included).
- Cash, UPI and Other payments are what the bills took when they were made, and Paid at billing is their share of what was billed. Credit given is the part put on the shops' accounts.
- Dues collected are the shops' payments against their dues that drivers took on these trips. Change in dues is credit given less dues collected: above zero, the shops owe more than before (before any credit notes).
- Cash expected, Cash counted and Cash difference are the trip sheet's, added up over the driver's trips; the difference covers only the trips that were counted, and reads Not counted when none was. The Counter row has no cash expected (its cash goes to the cash drawer).
With no filter, the cash and UPI add up to the Cash and UPI of Payment modes for the route bills of the period.
Returns by product
One row per product, condition and reason, the most units first, and a second table Per shop. Both plans.
- Condition is Good (it went back into stock) or Damaged, with its Reason (Damaged on the van or Expired or spoilt; older returns read No reason code).
- Units are the goods taken back on the period's trips, on the trip that took them back, and with no driver or route chosen those taken back at the counter: the same units as Taken back, good and Taken back, damaged of Product movement.
- Value is at the price the goods were billed at. Credited is the part you have given a credit note for; Waiting for a credit note is the rest. Share of units sold compares the units with the units of that product sold in the period.
- Per shop shows each shop's good and damaged units, their value, credited and waiting.
Trip sheets
One row per trip of the period, in the order of date, route and trip. It is the trip sheet of the settle screen as a table.
- Business date, Route, Trip (the saved trip name, such as Morning, School run or Round 3), Driver, Van and Status (waiting for the driver, on the road, day ended or settled).
- Start is when the driver started the trip (on older trips, when they accepted the load); it reads Not started until then. End is when the driver ended the day, or Not ended.
- Loaded is what the van took, including top-ups. Sold is the quantity on the trip's bills, and Bills and Sales are those bills.
- Crates out is every container that went onto the van with the load (after any load edits). Crates back is the number counted at the godown when the trip was settled; it reads Not settled until then.
- Cash expected is the cash bills of the trip plus the cash collected from customers on it, less recorded cash refunds on the trip’s bills: the same figure as on the settle screen.
- Cash counted is what you counted at the godown once the trip is settled, and before that what the driver counted when ending the day. It shows Not counted until one of them has counted. Cash difference is counted less expected, and also reads Not counted until then.
- UPI and On credit are the UPI and credit parts of the trip's bills.
- Found short is the shortage of the approved settlement, or Not settled while the trip waits.
Above the table you see the number of trips, the sales and the total found short.
Route sales
One row per route of the period's trips, the route with the most sales first, then one Open trips row for the trips that ran without a fixed route, then Counter. Routes Plus.
- Trips, Shops billed (each shop once per row), Bills and Sales of the route's trips. A trip's bills count on its route, whatever day each bill was made.
- Credit notes are those given on these bills, and Net sales is Sales less them: goods taken back count against the bills they were sold on, whichever trip took them back. Cash, UPI and On credit are what the bills took when they were made.
- Dues collected are shops' payments against their dues that drivers took on these trips.
Above the table you see the trips, the sales and the dues collected.
Driver performance
One row per driver who had a trip in the period, the driver with the most sales first. Routes Plus.
- Trips, Bills and Sales of the driver's trips.
- Stops planned are the active stops of the route that run on that trip (including custom trip names) and on that weekday, as set up on the route. Stops visited are the planned stops that were billed or marked as visited (a visit with no sale counts), and Stops skipped is the planned stops left. Unplanned shops are customers billed or visited who were not in the plan: a walk-in does not count as a visited stop.
- Returned and Damaged are the quantities taken back (all of them, and the damaged ones) as a share of the quantities sold.
- Credit given is the credit part of the driver's bills. Money collected on trips is what customers paid against their dues on the driver's trips (payments you undid are not counted).
- Settlements short is how many approved settlements found something short, and Found short is their value.
- Settled within a day is the share of the driver's ended trips whose settlement was approved within 24 hours of the day ending.
- Minutes between bills is the average gap between the driver's bills on one trip. It reads Under two bills when no trip had two bills.
Shop sales
One row per shop billed in the period, the biggest buyer first. Drivers' own accounts are not included. Routes Plus. (This report was called Customer sales.)
- Type is the kind of customer set on the shop (Shop, Business or Home), or Not set. Route lists the routes the shop is an active stop of today, or Not on a route.
- Sales, Bills and Average bill.
- Returned is the quantity taken back as a share of the quantity sold to the customer.
- Average days to pay covers bills put on credit that were paid in full: the days from the bill to the last payment. It reads No credit paid when there is none.
- Balance and Containers held are as of now, not as of the end of the period.
- Last order is the customer's latest route bill, even if it is outside the period.
- Sales against the days before compares the period's sales with the same number of days just before it, as a percentage. It reads No sales before when the customer bought nothing then.
Above the table you see the number of Shops billed.
Product movement
One row per product on one route with one driver, over the period's trips. Routes Plus.
- Loaded includes what was topped up. Sold is the quantity on bills that were not cancelled.
- Crates and Loose split what was sold as it was billed: Crates counts the packs on the bill lines (any pack size, such as a crate, a tray or a box), Loose the units sold outside a pack. A bill keeps the packs it was made with, so changing a product's pack sizes later does not change old rows. A line billed without packs is all loose.
- Taken back, good and Taken back, damaged are the goods drivers took back on bills.
- Damaged is the damaged quantity as a share of the quantity sold.
Van stock check
One row per product of each trip, in the order of date, route and trip: what should be left on the van and what was counted. Both plans.
- Business date, Route (or Open trips), Trip, Driver, Van and Product.
- Loaded, Topped up, Sold, Taken back, good and Taken back, damaged.
- Should be left = loaded + topped up − sold + taken back good.
- Counted left is the good count at the godown plus the damaged units that were van stock (damaged goods a shop gave back are not van stock). Difference is counted left less should be left: below zero is short. Value of the difference is the value the settlement used.
- A settled trip shows the figures its settlement recorded. A trip that is not settled yet shows what the system has so far, and Counted left, Difference and Value of the difference read Not settled.
Above the table you see the trips and the total found short.
Losses
One row for each shortage an approved settlement found: stock short, cash short or containers missing. Excesses are not listed. Both plans. Goods shops gave back damaged or expired are listed too, as Returned damaged, on the trip that took them back (and, with no driver or route chosen, those taken back at the counter): they never go back into stock, so they are always the business's loss, valued at the original bill's price, with their reason (Damaged on the van or Expired or spoilt).
- Business date, Route, Trip, Driver, What (Stock, Cash, Containers or Returned damaged) and Item (the product, Cash or the container type).
- Units short (cash reads Money). Value is what the settlement recorded for the row: stock at the price or the cost your settings used then, cash as counted, containers at their lost charge.
- Value at cost and Value at price show both values for settlements that record them. Older settlements read Not recorded (for cash both are the amount).
- Reason is the reason chosen at settlement (Missing, Damaged on the van, Expired or spoilt, Counting mistake, Other); older settlements read No reason code. Note is the note typed with it.
- Who pays: Driver (charged to the driver), Shop (containers charged to a shop), Business (written off or marked lost) or Not decided yet.
- Status: Decided, or Under review for a row left with Decide later that the owner has not decided yet. Decided by is the person who closed the day, or who decided a row left for later.
Above the table you see the number of losses, their value, what was charged to drivers and how many are under review.
Containers
Three tables for your returnable crates, jars and trays. (This report was called Empties.) A Driver filter narrows the bills, the losses and the vans to that driver's trips; With shops now stays the whole business.
- Per container type: Sent out and Collected back are the containers on the route bills made in the period. With shops now and Deposit held are as of now (the type's deposit times the containers shops hold). Lost is what settlements recorded as missing, counted on the day of the trip. A type you have archived shows only if it has movements.
- Lost containers: every loss with its business date, the Container type, the driver, the number lost and Charged to (Driver or Customer) and the shop's name when a shop was charged. Each lost container is one row, whoever it was charged to, and the number lost adds up to the Lost column of the first table.
- Per van, over the period's trips: Loaded on the van, Left at shops, Collected from shops, Back at the godown (counted home at settlement, or taken off a load), Missing, Found extra and On the van now (every movement of that van to date).
Containers by shop
One row per shop and container type, the overdue shops first. Both plans.
- Given and Collected are the containers left with and taken back from the shop on route bills made in the period.
- Holding now, Deposit value (holding times the type's deposit) and Last movement are as of now, whatever the period.
- Overdue marks a shop that holds containers and has given none back for 7 days, counted from its last collection (or from its first container, if it never gave one back). The 7 days are fixed for now.
Above the table you see the shops holding containers, how many they hold and the overdue shops. The same list, to date, is on Stock → Containers → With shops.
Daily close
One row per business day of the period that has trips, bills, collected dues or credit notes: the whole business of that day on one line. Use it to check the day against your books.
- Trips and Bills, and Sales split into Tax invoices and Bills of supply. Tax in sales is the tax contained in the sales.
- Cash, UPI, On credit and Other payments are what each route bill took when it was made.
- Dues collected are the customers' payments against what they owed, on the day they were recorded. The money of a cancelled bill that you kept as an advance on the customer's account is not a collection.
- Credit notes and refunds are on the day they were given, for bills that are still standing. A cancelled bill leaves the report: its sales, payments, refunds and advance net to nothing.
- Found short is what approved settlements found short, on the trip's day.
Below it, Sales by tax class adds up the taxable value of the bills for each tax class of the period: sales before tax, with the tax taken out when your prices include it. Above the tables you see the bills and the sales of the period.
Analytics
Next to Reports in the menu, Analytics shows the same business as charts and tiles for a period you pick: Sales, Bills, Active customers, Collection rate and Shortages, Sales by day (stacked by route, with a table view), Top products and Top customers. The driver comparison and the customers who have gone quiet come with Routes Plus. It needs the same permission as the reports.
Download
Press Excel or CSV on a report to download it with the same period, outlet and filters. The download has all rows, not only the first 2,000 of the screen, and a totals row where the report has one. The Routes reports download as Excel and CSV only, not as PDF.
Related
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
- AirQR Routes, bills, collections and ending the dayHow a driver bills a customer on the phone (with or without a network), collects money, notes a visit with no sale and ends the day, and how the owner sees, checks and cancels those bills in the dedicated Bills section.
- AirQR Routes, credit to shops, dues and what drivers oweHow credit works in AirQR Routes. Giving a shop credit on a bill, the credit limit and blocked shops, the balance and what is overdue, collecting dues on the phone and at the godown, how a driver's own dues are kept apart under Routes, Drivers, who may do what, and where the owner sees it all.
- AirQR Routes, customers, route stops and regular ordersAdd the shops and people you sell to, with an optional GSTIN for registered businesses, import your list from a sheet, put them on a route in visiting order, set what each usually takes, and note the empties and the balance they already hold. Each customer's page shows what they bought, their latest bills, top products and visits.
- AirQR Routes containers, packs and returnablesHow AirQR Routes follows returnable crates, jars and trays. Setting up the types with a deposit and a lost charge, how they go out with a load, are left at and collected from shops on a bill, counted at End day and counted home at settlement, who is charged when some go missing, and the With shops, On vans and Types tabs that show who holds what.