- Before
- Runs monthly exception reports on billing and meter data, with no network map, and spends most of a day building the evidence for one back-bill.
- Now
- Opens the buckets that moved this week and the premises behind them on the map. “I don’t need more exceptions. I need the 186 premises that changed this week, and proof.”
One tower, from a silent rejection to 186 accounts and a back-bill
Lumina Utilities supplies electricity and water to 1,004,600 premises and billed AED 9,860.0M in the 12 months to 30 Sep 2026. On Monday 12 October the weekly run finds a new ring of premises on Saffron Bay Tower 7. Here is what happens next, screen by screen, in the working solution.
- 01Monday, 06:51
The year, drawn as one waterfall
Six agents · the weekly runThe run takes 06:10 to 06:51. The network tracer traces 1,004,600 premises to 9,412 transformers; the meter data reader reads 1,762,100 meters and finds 3,860 silent for 30 days; the account matcher runs 9 checks and files 17,607 gaps in 8 buckets. The waterfall runs from AED 9,922.3M delivered to 9,893.4M metered, 9,860.0M billed and 9,821.5M collected, each step down a named bucket.
“AED 62.3M delivered in the year never reached a bill” · root cause finder: “New: Saffron Bay Tower 7, 186 premises”
- 02Morning
Consuming, no account: up 186 this week
Priya Raman · Senior revenue assurance analystPriya opens the bucket that moved: 1,240 premises, AED 3.1M a year at tariff, AED 2.2M back-billable under rule BR-7. Every premise is a dot on the map of Lumina’s eight districts, and a new ring sits on Saffron Bay Tower 7 — 186 premises, AED 612k a year. Beside it, how the gap is found: network map connected and energised, meter data at least 30 kWh or 1,000 IG in 30 days, billing with no active account.
Top root cause in the bucket: “Developer handover file rejected silently” — AED 1.1M
- 03One premise
Unit 1407: connected, consuming, never billed
Network tracer and meter data readerThe trace runs from Saffron Bay 132/11 kV substation to feeder SB-11, transformer T-SB11-04 and rising main 7B to Unit 1407, energised 14 Mar 2026 under service order SO-26-031884. Its meters recorded 7,940 kWh and 21,600 IG since 15 Mar, 100 % actual reads. Billing shows no account, premise status “installed, not billed”, and handover file HO-CSD-0316 rejected on 16 Mar.
Priced at tariff v2026.07: AED 3,228 to date. “No month went above the first slab, so no higher rate applies.”
- 04The case
Case RA-2611, with the three-way join for every apartment
Case writerThe case opens on the join, premise by premise: every one of the 186 on transformer T-SB11-04, 158 consuming and 28 near zero (unlet), none with an account. Reads run from 15 Mar to 11 Oct 2026, priced at 29.5 fils/kWh and 4.1 fils/IG, with the unbilled value by month for electricity and water.
“186 premises · AED 612,000 a year at tariff · back-bill AED 370,600 for 14 Mar – 11 Oct 2026”
- 05The money
Priced at tariff, inside the rule
Revenue estimatorElectricity, 919,700 kWh: AED 271,300. Water, 2,422,000 imperial gallons: AED 99,300. The back-bill is AED 370,600, AED 352,070 of it recoverable at 95 % collectable, and AED 612,000 billed every year from now. Coralstone Developments is billed from energisation, because clause 9.2 of its connection agreement makes the developer the account holder until a tenancy is registered.
Rule BR-7: developer-held supply — “from energisation” · field check not needed: the largest premise is AED 3,228
- 06How it leaked
A handover file, rejected silently
Root cause finder14 Mar: Tower 7 energised, 186 premises. 15 Mar: the meters start reading daily. 16 Mar, 11:42: Coralstone’s handover file HO-CSD-0316 is rejected — the tenancy registration number is blank on 186 of 186 rows — and the rejection notice goes to a mailbox nobody reads. No account is created. The same cause sits behind 412 premises across 6 developments.
“Proposed fix: a rejected handover file raises a work item for billing operations within the hour.”
- 0707:18 · approved
Khalid approves — the checks on the same screen
Khalid Al Suwaidi · Revenue assurance managerPriya sends the case for approval. Khalid signs as revenue assurance manager for a back-bill of AED 370,600 to Coralstone Developments, and 186 accounts in its name until tenancies are registered. Before he signs, three checks: inside rule BR-7, evidence pack complete with trace, reads, account history and tariff v2026.07, and prepared by someone else.
Agents find, price and draft; only named people approve a back-bill.
- 0807:24 · co-signed
Two signatures, 186 accounts open
Marta Kowalczyk · Finance controllerAbove AED 250,000 a back-bill needs two signatures, so Marta co-signs after Khalid. The back-bill is posted to Coralstone Developments, billing operations reloads the handover file with the registration numbers, and 186 accounts open, billed from 12 Oct. The bucket falls back to 1,054 premises.
“Billed. Back-bill of AED 370,600 posted to Coralstone Developments; 186 accounts open, billed from 12 Oct. The bucket is back to 1,054 premises.”
- 09The cause
Fix the door, not just the room
Aisha Karim · Billing operations leadFixing a case recovers the money once; fixing its cause stops the bucket refilling. The root causes screen ranks 31 causes from 312 clusters by value a year and shows how much each refills a week. “Developer handover file rejected silently” refills 31 premises a week, worth AED 1.1M a year, and its owner is Aisha.
Root cause finder proposes causes and owners; it never closes a cause.
- 10Month end
Found is not recovered
Marta Kowalczyk · Finance controllerRecovery reconciles every case to billing for the audit committee: AED 49.7M found a year, AED 26.9M billed back in 2026 from 2,960 closed cases, AED 18.4M collected — 61 % of the AED 30M target — and AED 21.7M billed every year from causes that were fixed.
Wrong multiplier cases brought in the most: AED 7.4M paid.