Edge modulesSettlement Module
Settlement without the headaches
Settlement in the water retail market shouldn’t be a monthly struggle. No more disputes, no more manual reconciliations: just clarity, control and improved margins.
With the Edge Settlement Module, retailers gain
Accuracy at scale
Automatic SPID-level settlement calculations.
Revenue protection
Detect mismatches between wholesaler invoices and customer billing.
Cashflow confidence
Forecast wholesale charges with precision.
Audit-ready transparency
Every calculation is traceable and defensible.
Automated settlement data, matched to billing
Automatic retrieval and secure storage of CMA/MOSL files removes manual uploads and ensures consistency.
Captured at SPID level
- Settlement period (monthly/year)
- Service type (water, wastewater, drainage)
- Settlement values (£)
- Settlement run type (P1, R1, R2, RF)
Billing data is broken down to SPID/month level for accurate comparisons. Edge captures Estimated (E) or Actual (A) status, and invoiced values alongside settlement data.
Reconciliation and reporting
Easy validation of invoicing accuracy and tracking of profitability trends.
- Side-by-side display of settlement vs invoiced values
- Automatic SPID margin calculation (Invoice – Settlement)
- Monthly Settlement Reports
- KPI dashboards showing invoiced vs settled values over time
Frequently asked questions
Questions retailers ask about Settlement
How does Edge automate wholesale settlement reconciliation?
Edge automatically retrieves and ingests central market settlement files from MOSL (in England) and the CMA (in Scotland). It matches central market charges against the billed revenue for every individual SPID and month, eliminating manual spreadsheet reconciliations.
How does Edge catch margin leakage in wholesale charges?
By comparing wholesale charges line-by-line against customer invoices, Edge immediately highlights discrepancies—such as unbilled meter volumes, incorrect tariff application, or restated settlement runs (e.g. R1, R2, R3, RF)—so disputes can be raised before paying erroneous wholesaler charges.
Can Edge forecast wholesale settlement charges?
Yes. Edge models expected wholesale charges using validated consumption trends and applicable wholesale tariffs, giving finance teams reliable forecasts for future cashflow and working capital requirements.
Works with
Modules that pick up where this one leaves off
Explore How Edge Could Support Your Retail Operation
If you’d like to understand how Cloudwater Edge could support your business, we’d be happy to talk through your current setup, challenges and plans.
Book a conversation