Refillable Water Depot Management Software: Solving Deposit Gallons, Subscriptions, and Delivery Routes

Bu Ratna Kusumawati opened Depot Air Minum Tirta Segar, a refillable drinking-water depot in the Sukun district of Malang, back in 2019. Her business grew fast: what started as a small shop where neighbors dropped by with their own empty gallons turned into an operation with three couriers on basket-motorbikes delivering refilled gallons to homes and boarding houses within a five-kilometer radius. Most of her customers are monthly subscription customers who expect delivery twice a week without needing to call ahead. Every transaction, gallon count, and delivery schedule was tracked by Bu Ratna and her two staff in a large notebook, plus a family WhatsApp group used to coordinate couriers each morning.

The problem became painfully real in March 2026. One customer, Bu Sari, complained that eight of her deposit gallons — empty gallons she personally owned and had left at the depot to be swapped for full ones on each delivery — could no longer be found. Because Bu Ratna's notebook only tracked the daily total of gallons in and out, without separating which gallons belonged to a specific customer as a deposit and which were the depot's own stock, there was no way to prove who was right. The dispute dragged on for two weeks until Bu Ratna finally agreed to compensate Rp 800,000 for the eight gallons and their water content just to preserve the relationship. What hurt more was that Bu Sari and four neighbors on her street, who had also been regular subscribers, switched to a competing depot because they felt Tirta Segar's record-keeping was sloppy. The lost monthly subscription revenue from those five households alone came to roughly Rp 4.5 million per month. When Bu Ratna recounted her circulating stock three months later, she discovered around 120 gallons were simply unaccounted for, with an estimated capital loss in gallons and water of about Rp 3.6 million. This kind of situation is common among mid-sized refillable water depots in Indonesia that still rely on manual notebooks and WhatsApp groups to manage daily operations.

What is refillable water depot management software

Refillable water depot management software is a digital system that manages the entire operational cycle of a small retail water refill business — tracking gallon and bottle inventory, separating customer-owned deposit gallons from the depot's own stock, scheduling deliveries for subscription customers, planning daily delivery routes across multiple couriers, monitoring water filter and machine maintenance schedules to keep water quality compliant, and reconciling daily cash collected by each courier. This is distinct from a PDAM municipal water utility billing system, which handles piped water bills as a public utility at the city or regency level; a refill depot is a small-to-medium retail business that sells and delivers refilled gallon water to households and businesses nearby.

Unlike a manual notebook or an Excel spreadsheet that only records raw numbers without context, a centralized depot application gives every gallon and every customer a clear, traceable identity. Had a system like this been in place from the start, every one of Bu Sari's deposit gallons would have been logged with a customer ID, a deposit date, and a full swap history at every delivery — meaning that dispute could have been resolved in seconds by simply pulling up the transaction history in the app, instead of dragging on for two weeks and costing five households of subscribers at once.

The real cost of running a water refill depot without a centralized system

• Deposit gallons get mixed with depot stock. Without clear separation between customer-owned gallons and the depot's own stock, staff struggle to tell which gallons can be resold and which must be returned, triggering disputes and capital losses like the one Bu Ratna experienced.
• Subscription customer schedules slip or get missed. A manual notebook is easy to misplace or forget to check, so subscription customers who expect regular delivery can go days without service and eventually switch to a more reliable competitor.
• Courier delivery routes are inefficient. Without structured route planning, couriers often backtrack into the same area repeatedly or skip customers who should have been on that day's route, wasting fuel and working hours.
• Cash from multiple couriers never balances. Each courier carries cash from the day's deliveries, and without digital, per-transaction records, small shortfalls across several couriers can pile up undetected for weeks.
• Filter maintenance schedules get missed. Without automatic reminders, filter replacement and tank sanitation routinely slip past their due dates, risking water quality and customer trust in the product's hygiene.

Key features every water refill depot application needs

• Per-customer deposit gallon management. Every deposit gallon is logged with the customer's identity, deposit date, and swap status, so it never gets mixed up with the depot's own stock — preventing disputes like the one with Bu Sari from ever happening.
• Automated subscription customer scheduling. The system reminds couriers and admin staff exactly when each subscription customer is due for delivery based on their individual subscription pattern, cutting the risk of missed schedules that push customers toward competitors.
• Daily delivery route optimization. The app builds the most efficient route for each courier based on that day's customer locations, reducing travel time and fuel use while making sure every customer is served.
• Daily multi-courier cash reconciliation. Every cash transaction is logged directly by the courier from the mobile app at the point of delivery, so at the end of the day admin can match each courier's cash total against the system record without manually tallying anything by hand.
• Real-time gallon and bottle stock tracking. The system shows empty gallons on hand, filled gallons ready for delivery, and deposit gallons still circulating out in the field, so stock never runs short without an early warning.
• Filter maintenance and water quality reminders. Filter replacement, tank sanitation, and water quality testing schedules are set automatically with notifications, helping the depot maintain hygiene standards and avoid customer health complaints.
• Customer history and sales reporting. Admin staff can view each customer's purchase history, spot subscribers who have started ordering less frequently, and generate daily, weekly, or monthly sales reports for business decisions.

Buy an off-the-shelf app or build a custom system

For a small refill depot running with just one or two couriers and a limited service area, a generic point-of-sale or subscription-based inventory app is usually sufficient. These tools typically handle basic stock and transaction tracking, though they rarely offer depot-specific features like per-customer deposit gallon separation or multi-courier route optimization tailored to how a water depot actually operates.

A custom system becomes the better choice once a depot has a sizable base of subscription customers, runs three or more couriers, and needs delivery scheduling, cash reconciliation, and deposit gallon tracking to work together seamlessly in one workflow. For mid-sized depots in Indonesia looking to expand into a multi-branch network, a custom system also opens the door to consolidated cross-branch reporting and centralized courier management that generic apps simply do not offer.

Cost and timeline ranges in Indonesia

For a small depot, a subscription-based off-the-shelf point-of-sale and inventory app typically costs Rp 150,000 to Rp 500,000 per month depending on features. For a mid-scale custom system with deposit gallon management, subscription scheduling, and courier routing, development typically costs Rp 45 million to Rp 90 million with a build time of around 3 to 5 months. For a large-scale system covering multiple branches, complex multi-courier cash reconciliation integration, and a full analytics dashboard, costs can reach Rp 120 million to Rp 250 million with a build time of 5 to 8 months. Beyond the initial development cost, budget an annual maintenance cost of around 15-20% of the project value for system updates, bug fixes, and ongoing technical support.

Case study: Depot Air Minum Sumber Rejeki

As a composite illustration drawn from several mid-sized refillable water depots in Indonesia, Depot Air Minum Sumber Rejeki, which operates with four couriers, faced problems similar to Bu Ratna's: mixed-up deposit gallons, frequently missed subscription schedules, and courier cash that was hard to reconcile every day. After implementing a centralized depot management application, deposit gallon disputes dropped from an average of three cases per month to nearly zero within the first three months, since every gallon was now logged with a clear customer identity. Late deliveries to subscription customers fell from about 12% of scheduled deliveries missing their window to under 2%. Daily cash reconciliation, which used to take almost two hours each night to match four couriers' totals, now takes under twenty minutes. Overall, subscription customer retention rose by around 18% within six months of implementation, thanks to more consistent and reliable delivery.

Metrics to monitor after implementation

• Deposit gallon dispute rate per month, ideally trending toward zero within the first three months of full system use.
• Percentage of on-time subscription deliveries, targeting above 95% to maintain subscriber trust.
• Daily cash reconciliation variance per courier, targeting near-zero rupiah and detected the same day if any discrepancy appears.
• Average daily cash reconciliation time, which should drop significantly compared to the previous manual process.
• Monthly subscription customer retention rate, tracked quarterly to see how service consistency affects customer loyalty.

Implementation challenges and how to solve them

The first challenge that typically comes up is courier resistance to using a mobile app during deliveries, especially couriers who have relied on paper notes for years. The solution is to involve couriers early in designing the app's workflow, keep the interface as simple as possible with large buttons and minimal manual typing, and provide gradual training during the first few weeks of use.

The second challenge is migrating subscription customer and deposit gallon data that previously only existed in a notebook, which is often incomplete or inconsistently formatted. The way to handle this is to conduct a thorough physical audit of every deposit gallon currently in the field before going live, matching each one against customer records one by one, so the new system's starting data is genuinely accurate from day one.

The third challenge is ensuring stable internet connectivity for couriers delivering to outer-city areas with limited signal. The solution is to choose an app that supports offline mode, where transaction data stays saved on the courier's device and automatically syncs once an internet connection is available again, so operations are not disrupted even if signal drops mid-route.

Where to start

If your depot still relies on a notebook and a WhatsApp group to manage deposit gallons, subscription schedules, and courier cash, the kind of dispute and customer loss Bu Ratna experienced can happen at any time without warning. A good first step you can take right now is to count how many complaints about deposit gallons or late deliveries occurred in the last six months, then estimate the rupiah value of customers who eventually switched to another depot. That number is usually the strongest reason to start acting.

AFSS builds refillable water depot management systems tailored specifically to your business workflow, not a generic template forced to fit every kind of business. Check our pricing for development packages, or go ahead and submit a project to discuss your water depot system needs.