Every water can distributor loses cans. The question is whether they know it — and whether they can stop it before the losses compound into thousands of rupees per month.
Most distributors track empty cans informally: a mental note, a WhatsApp message, or a rough count in a notebook. These methods work when you have 20 customers. They break down completely at 100 customers and become expensive at 200+.
This guide explains the systematic approach used by water can distributors who keep their can losses near zero.
Why Empty Cans Go Missing
Missing cans rarely disappear all at once. They slip away gradually, across three predictable failure points:
- Unrecorded returns. The rider picks up an empty at the doorstep but doesn't write it down. The customer's balance stays at "1 can owed" even after they returned it. When the distributor follows up, the customer correctly says they already returned it — and the can is lost in the ledger permanently.
- Stale records. Paper ledgers and Excel sheets go days without being updated. By the time anyone reviews them, the balances are 5–10 days out of date and nobody can tell which entries are accurate.
- No follow-up system. Even when the ledger is accurate, distributors have no process for contacting customers with outstanding empties. Cans sit at customer premises for weeks, then months, then get repurposed or discarded.
The fix is a three-point ledger with discipline at every step.
The Three-Point Ledger Method
At any moment, every 20-litre can in your operation is in exactly one of three places:
- In the plant — in your warehouse, waiting to be filled or dispatched.
- On a rider vehicle — loaded for delivery, either full or empty.
- At a customer's premises — delivered full, awaiting return as empty.
Your total can count is the sum of all three. If your total drops without explanation, a can is missing. Tracking all three points simultaneously is what makes the system work.
Step-by-Step: How to Set Up Empty Can Tracking
Create a per-customer can ledger
For each customer, create a record that tracks: total cans delivered (cumulative), total empties returned (cumulative), and the difference (outstanding empty balance). This is the customer's "can debt." New distributors can start with a notebook column or an Excel row per customer.
Record every delivery at the doorstep
Every time a rider delivers a full can, log the delivery against that customer's account immediately — not at end of day. Each delivery adds 1 to the customer's outstanding balance. Skipping this step for "regular customers" is where most leakage starts. Every delivery counts.
Log every empty collected at the same stop
When a rider picks up an empty at the same stop, log the return immediately. This subtracts 1 from the customer's outstanding balance. If riders batch-log returns at end of day, the precision is already lost. The return must be recorded at the doorstep.
Reconcile each rider's stock at end of day
At end of day, verify: cans loaded on each rider at start of day, minus deliveries made, plus empties collected, should equal what they brought back. If the number doesn't balance, a can is missing from that rider's run. Find it before the next morning.
Follow up on outstanding balances older than 7 days
Every week, review customers whose outstanding empty balance is 7 days or older. Call the customer, send a collection rider on their next delivery, or add a due-can note to their next order. Balances older than 30 days have a significantly lower recovery rate.
Rule of thumb: If a customer has had an outstanding empty for more than 14 days and you haven't contacted them, the probability of recovery drops sharply. The ledger tells you who to call. The value comes from acting on it immediately — not at month end.
What Changes When You Use Software
The five steps above can be done manually. The failure point is always discipline and speed — paper records are slow to update, Excel sheets require manual sync, and WhatsApp messages introduce transcription errors.
Distribution management software automates the ledger:
- When a rider logs a delivery in the app, the can moves from plant inventory to the customer's account automatically.
- When a rider logs an empty return, the customer's balance reduces and the can moves back to plant inventory in real time.
- The admin sees outstanding balances per customer, per rider, and plant-wide — without waiting for end-of-day reconciliation.
- Customers with outstanding empties are visible at a glance, without reviewing every page in a notebook.
The ledger logic is identical to the manual method. The difference is that every step happens in real time, with zero transcription errors, and the admin can review the full picture from any device at any moment during the day.
How WaterWave App Handles Empty Can Tracking
WaterWave App is built specifically for 20-litre water can distributors. Its can tracking system implements the three-point ledger natively:
- Plant inventory shows total cans in the warehouse at any time.
- Rider stock shows how many cans each rider has loaded, and how many empties they've collected during the day.
- Customer balance shows each customer's outstanding empty count, updated the moment the rider completes a delivery in the rider app.
Distributors who switch from paper records to WaterWave App typically see their missing can count drop to near zero within the first two weeks — not because the software catches the cans, but because real-time recording eliminates the gaps that made cans untraceable in the first place.
See the full empty can tracking feature →