Our own product · water utilities

AguaMap: water billing without lines or spreadsheets

AguaMap is the customer-roll, billing and collections system we built for municipal water utilities in Mexico. It organizes accounts, meter readings, rates, cashiering and arrears so every peso collected has a receipt number and every customer has a full history.

Request an AguaMap demo
What is billing software for water utilities, and what should it include?

It's software that keeps the roll of customers and service connections, calculates what each account owes every period (metered or flat rate), takes payments at the counter with numbered receipts and reports revenue and arrears. AguaMap includes the customer roll, accounts, metered and flat rates, meter-reading entry, billing by period, fast cashiering, thermal-printer receipts, payment plans, a delinquent-accounts list and cash closeouts, with users and role-based permissions.

In many small and mid-size Mexican municipalities, water billing still runs on an old desktop system, spreadsheets or handwritten receipts. The results are familiar: long lines at the counter, customers who don't know what they owe, cash closeouts that don't balance and arrears nobody can measure accurately. AguaMap grew out of a real project with a water utility, and it's designed so a cashier can take a payment in seconds and the director can see the day's revenue without asking for a report.

The system is web-based, built with PHP and MySQL, and runs in any browser, on the utility's own network or on a cloud server. Every user has a role: the administrator sets up rates, cash registers and users; the supervisor sees revenue from every register and the delinquent list; the cashier only sees fast checkout and their own closeouts. We implement it with migration of your current customer roll, on-site training and support through launch.

01Modules

What's included

Customer roll

Account holders with tax details, address and phone, plus bulk import from Excel or CSV with validation first.

Accounts and connections

Each connection with its account number, service type (residential, commercial or industrial), sector and billing type.

Rates and meter readings

Metered or flat rates, and meter-reading entry by sector to calculate each period's consumption.

Billing by period

Generate the month's charges for the entire roll in one step, with pending, paid or canceled status.

Fast cashiering

Search by account or name, pick the months to pay, calculate change and accept cash, card or bank transfer.

Numbered receipts

Thermal-printer tickets with a sequential yearly number, cashier, register and a breakdown of the periods paid.

Payment plans and arrears

A delinquent list filtered by months owed, and payment plans to bring overdue accounts current.

Reports and cash closeouts

Closeouts by cashier and payment method, revenue by date and register, and cancellations only an administrator can approve.

03Tech stack and status

Built to last

PHP 8MySQLBootstrapJavaScriptThermal printingRoles and permissionsCSV / Excel import
  • Municipal water utilities. Drinking-water systems in small and mid-size municipalities that need to organize their customer roll and collections without an expensive government ERP.
  • Rural water boards and committees. Communities that charge a flat fee and keep records in notebooks or a spreadsheet today.
  • Utilities with several payment counters. A main office plus payment points in neighborhoods or communities, each with its own cashier and closeout.
  • Administrations that want to measure arrears. Directors and treasurers who need to know how much is owed, who owes it and since when.

In production

04FAQ

What people ask us

Does AguaMap handle both metered and flat-rate billing?
Yes. Each account is set up as metered or flat-rate service. For metered accounts, readings are entered each period and the system calculates consumption with the matching rate; for flat-rate accounts the charge is generated directly. One utility can have both types, with different rates for residential, commercial and industrial use.
Can we migrate the customer roll we already have?
Yes. AguaMap imports customers and accounts from Excel or CSV with a validation step that flags duplicate or incomplete records before loading them. If your roll comes from another system, we extract the data, clean it up with your team and also load outstanding balances so arrears are correct from day one.
What do we need to install AguaMap?
A computer with a browser at each register, a thermal printer for receipts and a server, which can be a machine at your offices or a cloud server we manage with daily backups. Implementation includes rate setup, customer-roll migration and training for cashiers and supervisors.
How much does it cost to implement AguaMap?
It depends on the size of the customer roll, the number of registers, the data migration and whether you need customizations such as special payment plans, official receipt formats or online payments. We quote it after a 30-minute call and, if the utility is in La Laguna, a visit to see how the counter operates.
Message us on WhatsApp