How We Automated Utility Billing for 4,000 Residents in Lahore
A housing society in Lahore was managing utility billing via Excel. Here's how we replaced it with a fully automated Odoo system and a mobile app.
The Problem
A leading housing society in Lahore — 4,000 resident units — was running its entire utility billing operation on Excel.
Every month, meter readers walked the property and wrote down readings on paper. Those readings were manually entered into a spreadsheet. Bills were calculated by hand. Disputes were handled through WhatsApp groups. And management had no idea how much revenue was actually collected versus outstanding at any given moment.
This is not unusual. Most housing societies in Pakistan operate this way. It works — barely — until it doesn't.
The breaking point for this client was a combination of factors: billing disputes with no audit trail to resolve them, meter readers submitting inaccurate readings with no accountability, and a finance team spending days each month on a process that should take hours.
They needed automation. We built it.
What Made This Hard
The standard Odoo billing module is built for invoicing businesses, not for utility billing in residential communities. It does not handle meter readings, consumption calculations, tiered billing rates, or the operational workflow of a field team walking a property.
We could not configure our way to a solution. We had to build one.
The other constraint: the field team. Meter readers are not technical users. Any mobile interface had to be simple enough that a reader could photograph a meter, submit the reading, and move on — without training, without errors, without a help desk.
What We Built
Custom Odoo Billing Module
We built a custom billing module in Odoo from scratch. It handles:
- Meter reading intake — reads arrive from the mobile app with a timestamp, geolocation, and meter photo attached to the record
- Consumption calculation — the module calculates consumption against the previous reading automatically
- Bill generation — bills are generated and dispatched without manual intervention
- Audit trail — every reading, every bill, every payment is logged with a full record
The module integrates directly with Odoo's accounting layer, so billing feeds the financial reports without manual reconciliation.
Mobile App for Meter Readers
The mobile app is the field interface. A meter reader opens the app, navigates to their assigned unit, photographs the meter, and submits. That is the entire workflow.
The photo is timestamped and geotagged at the point of capture. It syncs to Odoo immediately if there is connectivity, or queues and syncs when connectivity is available. The meter reader cannot submit a reading without a photo — this is the accountability mechanism.
From the Odoo side, the incoming reading triggers the billing workflow automatically. No human step is required between the photo being taken and the bill being generated.
Complaint Management System
We added a Complaint Management System inside Odoo. Residents can raise billing disputes through a defined channel. Each complaint is assigned to the responsible team member, tracked through to resolution, and closed with a documented outcome.
Before this existed, disputes were resolved — or not resolved — through informal channels with no record of what happened or when.
The Result
The billing cycle that used to take days of manual work now runs automatically. Management has a live dashboard showing collection rates, outstanding dues, and billing status across all 4,000 units. Disputes are resolved with reference to a timestamped meter photo rather than an argument about who wrote down what number.
The finance team's time on billing dropped from days to hours — most of which is now exception handling rather than data entry.
What This Means for Similar Operations
This solution is not unique to this client. Most housing societies in Lahore are running the same manual process. The same architecture — custom Odoo module, mobile app integration, automated workflow — applies wherever you have field-based data collection feeding a billing or operational system.
If your organisation manages a property and bills its occupants for utilities, maintenance, or services, the manual process is a liability. An audit trail is not optional when disputes are a monthly occurrence.
The technology to replace it is available. The implementation is not complex. The barrier is finding a team that has done it before in production — not just in a demo.
We have. Get in touch if you want to see how it applies to your operation.
Need Odoo help for your business?
Tell us about your operation and we'll map out a solution.