To manage RO service customers, keep one complete record per customer, track each filter’s due date separately, remind before every due date, and link each visit to a ticket, stock and a GST invoice. Do this consistently and services, AMC renewals and payments stop depending on someone’s memory.
Why RO service customers matter more than the first sale
A sale happens once. RO and UV work keeps coming back as filter changes, AMC renewals, repairs and installations. Missed follow-ups are a common source of lost revenue, because a customer with no reminder may end up with a brand service centre or another local technician.
Notebooks, Excel and WhatsApp chats work for the first few dozen customers. They break down as numbers grow, or when a staff member leaves with the only copy.
What to record when you sell: a customer record template
A complete record on day one saves hours later. Use this as a template:
| Field | Example |
|---|---|
| Name / mobile / WhatsApp | Ravi Kumar / 98xxxxxx01 / same |
| Address and area | Flat 4B, Peelamedu, Coimbatore |
| Model and serial number | Model name / serial printed on unit |
| Install date | 15 Jan |
| Water source, TDS at install | Borewell, TDS reading in ppm |
| Warranty end date | As per brand warranty card |
| AMC plan | Type, start, end, amount, parts covered or not |
How to track RO service due dates filter by filter
One service date per customer is a common mistake. Each part has its own cycle, and cycles vary by brand and water quality, so check the brand’s guidance. Here is an example for a unit installed on 15 Jan, using assumed cycles:
| Part | Typical cycle (approximate) | Cycle assumed in example | Next due date |
|---|---|---|---|
| Sediment / carbon pre-filters | Roughly 3-6 months | 6 months | 15 Jul |
| RO membrane | Roughly 1-2 years | 12 months (high TDS) | 15 Jan next year |
| UV lamp | Roughly 1 year | 12 months | 15 Jan next year |
| Pump, adapter, solenoid valve | On failure | None | No fixed date |
Hard or high-TDS borewell water shortens membrane life, so use shorter cycles there. Water quality varies by district and even by street, so verify with TDS readings from your own visits.
Send service reminders customers respond to
- Remind 7-15 days before the due date, and again on the due date.
- Use WhatsApp or a call. Some customers prefer a call.
- Keep it short: name the part and offer a visit slot.
A sample Tanglish message:
Vanakkam Ravi sir, ungal RO-vin sediment filter service 15 July-kku due. Intha Thursday morning or evening visit slot irukku. Confirm panna “1” nu reply pannunga. – ABC Aqua Services
If you automate through the WhatsApp Business API, message templates need approval and charges apply. Check Meta’s current policy and pricing.
Service tickets and technician routes
Log every scheduled or complaint visit as a ticket. An example ticket: Customer, model, issue or scheduled service, area, technician, visit date, parts used, TDS before/after, payment mode, customer sign-off.
Group tickets by route. For example, a Coimbatore technician might cover Peelamedu, Saravanampatti and Gandhipuram on Tuesdays, while another covers Singanallur and Ukkadam. In Chennai, split by suburb clusters. Review repeat complaints per model and each technician’s weekly load.
Apartments and commercial customers
Treat these separately. Keep one contact person, but record each unit (serial number, location) with its own filter dates. Agree whether AMC is per unit or per site, and note the customer’s GST number if they need an input-credit invoice. Offices, schools and clinics usually want fixed visit slots, so schedule those first.
How to manage AMC and price it
- Basic AMC: usually labour and scheduled visits.
- Comprehensive AMC: includes parts. State exactly which parts are covered.
Avoid one flat rate. Approximate ranges, which you should verify locally: basic domestic AMC about ₹1,500-4,000 a year, comprehensive about ₹3,000-6,000+, a single visit about ₹300-800. Parts vary widely: pre-filters about ₹150-600, membrane about ₹800-2,500, UV lamp about ₹300-900, pump about ₹1,200-2,500.
A simple pricing logic: base price for the model + water-condition add-on + distance add-on. Illustration only: a comprehensive base of ₹3,500, plus ₹500 where TDS is high enough to need membrane changes yearly, plus ₹200 for a far route, gives ₹4,200. Set your own figures from your parts cost and travel time.
Send renewal reminders at 30, 15 and 7 days before expiry, since a silent lapse forces renegotiation. Brand-owned service networks compete on AMC, so timely visits and personal follow-up are your edge.
Link service to stock and GST billing
- Deduct parts from stock when used, and set reorder levels for fast-moving filters.
- Issue a GST invoice or AMC receipt at the visit. Service and AMC are often taxed at 18%, but rates and SAC/HSN codes change, so confirm with your CA.
- If you are unregistered or under the composition scheme, billing rules differ. Ask your CA before invoicing.
- Record cash, UPI or pending payment per technician.
- Follow up on pending payments and quotations at 2, 7 and 15 days.
More on this in what dealers need beyond GST invoices.
Common mistakes to avoid
- Records only in one person’s phone or notebook
- One generic service date per customer
- Not recording parts usage, which causes stock leakage and disputes
- Flat AMC pricing regardless of water quality
- Assuming the lowest possible TDS is always best. Avoid health claims and follow brand or expert guidance.
- Mixing GST and non-GST billing without a CA’s advice
Monthly review checklist
- Overdue services
- AMCs expiring in the next 30 days
- Pending payments and quotations
- Repeat complaints per model
- Technician workload and collections
- Low-stock filters
Doing this with software: where Nixie CRM fits
Nixie CRM by Shiny Software Services is built for water purifier dealers in India. It covers customer management, sales tracking, inventory, GST invoices, AMC management, service tracking, quotation and payment follow-ups, and WhatsApp API reminders.
A connected workflow looks like this: a customer’s due date nears, a WhatsApp reminder goes out, the visit is logged as a service ticket, parts used are deducted from inventory, and a GST invoice or AMC receipt is raised with payment status recorded. We have not confirmed Tamil-language support, offline mode or revenue gains, so do not assume them. Check any feature in the trial.
Start small. Move active customers first, then AMC customers, then older records. See also our guides on RO AMC management software and RO service management software.
FAQ
How often should RO filters be changed?
Pre-filters are roughly every 3-6 months, the membrane roughly 1-2 years and the UV lamp about yearly. High-TDS water shortens these, so follow brand guidance and your TDS readings.
How do I remind customers about RO service on WhatsApp?
Send a short message 7-15 days before the due date and again on the due date, naming the part and offering a slot, as in the Tanglish example above. For automation, the WhatsApp Business API needs approved templates and has charges.
What should an RO AMC record include?
Customer details, model and serial number, AMC type, start and end dates, amount, number of visits, parts covered or excluded, and payment status.
How can I track AMC renewals for many customers?
Keep expiry dates in one searchable place, review those expiring in 30 days, and remind at 30, 15 and 7 days. Software helps once you have hundreds of customers.
How do I assign technicians by area for RO service visits?
Group the week’s tickets by area, for example Peelamedu, Saravanampatti and Gandhipuram for one technician and Singanallur and Ukkadam for another. Put the same-day visits for one route together, and check workload weekly.
Can I manage RO service customers in Excel, and when should I move to software?
Yes, for a small base. Move when reminders get missed, several staff need access, or stock, billing and AMC no longer match.
Want customers, AMC, service, stock and GST billing in one place? Start your 7-day free trial at https://app.nixie.in, or explore the product at https://nixie.in.