AirQR
AirQR Routes

AirQR Routes containers, packs and returnables

How 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.

8 min read

Crates, jars, trays and bottle racks are lent to shops and come back. They are never sold, so they are not products and they are not on the bill as an item. AirQR keeps a count of every one: how many are at the godown, on each van and with each shop. The Containers section holds every type. Individual records and custody counts keep their own names. Goods sold in crates or cartons are product packs; returnable carriers are counted separately.

The Containers page

Stock → Containers has three tabs:

  • With shops: one row per shop and container type with Given, Collected, Holding now, Deposit value and Last movement, the overdue shops first. A shop is marked Overdue when it holds containers and has given none back for 7 days (since its last collection, or since its first container if it never gave one back). Given and collected count every bill to date; for a period, use Containers by shop report. The shop's name opens its page.
  • On vans: what each van holds now per container type, with the van's Latest trip (date, driver and status). A van shows here until its trip is settled and the containers are counted back to the godown.
  • Types: the container types you lend out, where you add and change them.

The page opens on With shops; a business that has no container types yet opens on Types.

Set up the types (Stock → Containers → Types)

Open Stock → Containers, choose Types and press Add. For each kind enter:

  • Name (one) and Name (many), for example Crate and Crates.
  • Deposit for one (optional): what you ask a shop to keep with you for one. AirQR only records this figure; see "Deposits and lost charges" below.
  • Charge if lost (optional): what one lost empty is worth to you.

Edit changes them and Hide takes a type off your list without deleting anything (Show hidden brings it back). Changing a deposit or a lost charge is recorded in the change history. Owners can set empties up; managers need the owner to allow it in Team → Staff → Roles.

Create separately named container types when you need separate custody counts, such as Small crate and Large crate. Set product capacities under Stock → Products → Pack sizes. A capacity belongs to a product, not every container of that name. This permits different products and sizes without fixing every crate at 24. If you sell a container itself, add it as a product; this section tracks carriers that are lent and returned.

Then tell each product what it comes in. Open the product (Stock → Products), and under Comes back as pick the type. The default product pack supplies a suggested container count. With several pack sizes, check the physical number of containers; selecting a goods pack does not automatically charge a deposit or move an extra container. A product with no pack, such as a 20 litre jar, counts one empty per unit. If the product is not lent in anything, leave Nothing comes back.

If a shop already holds some of your crates or jars when you start, enter the number on its customer page (Edit), or use the opening_… columns when you import your customers. See Customers, route stops and regular orders.

The path of an empty

  1. Load. On Home or Trips, choose Load a van. In the second step, Containers on the van is filled in from the crates you load; with multiple pack sizes, count the actual carriers. Check the counts, go on to When and press Confirm load. They move from the godown to the van together with the goods. Edit load and Top up move the difference.
  2. Start trip. The driver checks the empties on the van along with the goods and changes a number if it differs, with a note. You are told about any difference.
  3. At the shop. On each bill the driver records how many empties were Left here (a suggestion for a single default pack; multiple pack sizes need actual counts; for a product with no pack, such as a jar, the driver types the number) and how many were Taken back. The shop's count goes up by what was left and down by what was taken back, and the van's the other way. A shop's page and the driver's customer list show how many it holds.
  4. End day. The driver counts the empties on the van under the heading with your word (for example Crates on the van). The count starts at zero, so the driver types what is really there.
  5. Settlement. You count what came home to the godown and AirQR compares it with what should have come back.

If a bill is cancelled, its empties go back to where they were: the shop's count and the van's are corrected.

Settling the empties

On Home, press Settle on the trip under To settle (it opens Close the day), or on Trips press Settle (under To settle). For every kind the table shows how many went out, how many were Left at shops, how many were taken back, Expected back, and a Counted box for what you count at the godown.

Expected back = went out on the van − left with shops + taken back from shops.

If you count the same, it says Matches. If you count fewer it says Missing, and you choose:

  • Charge to the driver: the missing number times the type's Charge if lost is posted as a due on the driver's own account (it appears under Drivers in Owes the business). If no lost charge is set for the type, the choice says so and nothing is charged.
  • Charge to a customer: pick the shop that lost them. AirQR records the empties as lost by that shop and takes them off what the shop is shown as holding. It does not add money to the shop's account: if you want the shop to pay for them, bill or collect that yourself.
  • Mark lost (no charge): the empties are written off with no charge to anyone.

If you count more than expected it says Excess; the extra ones are recorded as found. The empties you counted go home to the godown. Press Approve settlement as usual; after that the trip is locked. See Settling the day, driver dues and the Routes home.

Deposits and lost charges

  • A deposit is a figure on the type. AirQR does not add it to a bill and does not collect it for you. It is used in the Containers report to show the Deposit held, which is your deposit times the containers shops hold now, and as the Deposit value on With shops and in Containers by shop. If you take a deposit from a shop, record that money yourself the way you do today.
  • A lost charge is used only when you choose Charge to the driver at settlement.
  • Ask your CA how a deposit or a charge for a lost crate is treated for GST. AirQR does not decide that for you. See GST for distributors.

Where you see who holds what

  • Customers: the Has empties filter lists the shops that hold some, and each row shows how many.
  • The customer's page shows what they hold and, in its history, the opening count and later changes.
  • A shop that still holds empties cannot be hidden. Take them back or settle them first.
  • Stock → Containers → With shops lists every shop holding containers, and On vans what each van holds now (see "The Containers page" above).
  • Reports → Containers (on both Routes plans; it was called Empties) has three tables: per type, Sent out, Collected back, With shops now, Deposit held and Lost; every Lost containers entry with the date, the type, the driver, the number lost and Charged to (Driver or Customer); and Per van, what each van loaded, left at shops, collected, brought back to the godown and had missing. It can be narrowed to one driver.
  • Reports → Containers by shop (on both Routes plans) is the With shops list for a period, with a Route and a Shop filter.
  • Reports → Trip sheets shows Crates out and Crates back for each trip. See Routes reports.

In the AirQR Routes app

Under Setup → Containers the app has the same three tabs as the website. With shops lists each shop with what it holds now, overdue shops first and marked Overdue, under a line such as "3 shops hold 42 containers · Deposit ₹2,100 · 1 overdue"; tap a shop for Holding now, Given, Collected, Deposit value and Last movement per type. On vans shows what each van holds, and Types shows each kind with how many are In the godown, On vans and With shops, the deposit and the charge if lost. People who work at only some outlets do not see the shops' balances. The kinds are added and changed on the computer. It needs a connection.

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.