Water
Data and analytics
Data modelling

Finding £2.3m in an aged debt portfolio for a UK water retailer

Industry knowledge and data modelling refined debt collection strategy, improved data quality and identified a £2.3m uplift.

£2.3m
potential uplift identified
Client
A UK water retailer
Finding £2.3m in an aged debt portfolio for a UK water retailer

Overview

The retailer needed to know how much of its aged debt was really leakage, how to segment the rest, and how to get the best return from a planned debt sale.

What we delivered

  • Built an algorithm to separate debt likely caused by leakage.
  • Joined reading data back to invoice data lost in an earlier migration.
  • Re-segmented the portfolio and set a collection approach for each segment.
  • Recommended lower high-consumption thresholds so leaks are investigated earlier.

The value

  • Debt overstatement from leakage estimated at 6%, against the client's own 30% estimate.
  • 20% of closed accounts found to be linked to active customers.
  • An extra 18% of the portfolio opened up for collection.
  • A potential £2.3m uplift, £2m better than the original debt sale strategy.

Platforms and skills: Data modelling, debt segmentation, water retail expertise

Over an 8 week engagement, Clyde managed to clean and connect data we had struggled with for more than 5 years to create new insight that transformed the way we viewed and valued our debt sale portfolio.

Head of Debt, UK water retailer

More case studies

View all case studies

Want results like these?

Tell us what needs to change in your business, and we will show you how we would deliver and measure it.