Settlement Intelligence

Clarity Reconciled.
Every meter.
Every month.

Settlement Intelligence matches your bought energy volumes against what customers are billed — surfacing every variance and exposure before it hits your P&L.

Book a demo Talk to the team
Total meters
4,218
3 periods loaded
Net variance
+2,104 kWh
Under bought
Cash exposure
£84k
At risk · £80/MWh
Clean match rate
90.5%
3,901 of 4,218 rows
Tolerance review
239
1–7% variance band
Large exceptions
21
Hard review required

Reconciliation engine

Every meter — clearly explained.

Upload your bought volume and billed data files. The engine joins on meter ID, calculates the variance, assigns a band and classifies every row into one of eight scenarios — ranked by cash exposure.

  • Outer join on pair ID and meter ID — missing meters are captured, not dropped
  • Variance calculated as kWh delta and converted to £ at £80/MWh
  • Eight scenario types in strict priority classification order
  • Fully deterministic — same input always produces the same output
  • CSV and Excel accepted. Any column order — the parser normalises automatically
settlement_ledger · May 2026 · Reconciled
Meter IDSiteVarianceScenario
MPR3302-A McDonald's, Manchester +44,100 Large Exception
MPR5512-A Sainsbury's, Bristol +11,230 Under Bought
MPR2841-A Tesco, Watford -8,412 Over Bought
MPR0091-C Pret, Canary Wharf +340 Timing Shift
MPR7741-B Costa, Leeds -210 Late Credit
MPR1033-B Greggs, Sheffield 0 Clean Match

Scenario classification

Multiple scenarios classified.

Every reconciled meter is classified deterministically — same input, same output, every time. Classification drives the expected action.

Meter Missing Bought
Priority 1
Billed data exists but no bought record was found for this meter and period.
Investigate unmatched meter
Meter Missing Billed
Priority 2
Bought record exists but no billed data was received for this meter.
Investigate unmatched meter
Late Credit
Priority 3
Net billed kWh is negative against a positive bought position — a credit has arrived late.
Restate effective month
Timing Shift
Priority 4
Delivery month and effective month are misaligned, or source note flags a timing issue.
Tolerance review
Large Exception
Priority 5 · >7% variance
Variance exceeds 7% of bought volume. Hard exception — escalate to trading or finance.
Hard exception review
Clean Match
Priority 6 · within 1%
Bought and billed volumes align within the 1% tolerance band. No action required.
Auto-pass
Under Bought
Priority 7 · 1–7% variance
Billed exceeds bought. Positive variance — supplier is short and exposed to spot prices.
Tolerance review
Over Bought
Priority 8 · 1–7% variance
Bought exceeds billed. Negative variance — stranded energy at sunk cost.
Tolerance review

How it works

Ingest. Reconcile. Understand.

Four steps from raw file to a fully reconciled settlement picture. Typically under 60 seconds for a full monthly load.

Step 01
Upload
Drop your bought volume and billed data files. CSV or XLSX accepted. Any column order — the parser normalises everything automatically.
Step 02
Parse
Schemas are validated, format errors flagged, and meter-level data extracted into a clean, reconcilable structure before any join is attempted.
Step 03
Reconcile
Every meter is joined on pair ID and meter ID, variance calculated in kWh and £, and classified into a scenario in strict priority order.
Step 04
Understand
Four views surface the results — Portfolio, Settlement, Reconciled and Admin. Scenario summaries and meter-level analysis available on demand. Export to branded Excel in one click.

Cash exposure

Your risks clearly surfaced.

Every kWh variance is converted to a £ figure at £80/MWh — the standard UK wholesale proxy rate. Your portfolio ranked by financial materiality, not just volume.

  • Under-bought positions flagged as highest risk — you are short and exposed to spot
  • Over-bought positions ranked separately — stranded energy at sunk cost
  • Variance bands of 1%, 3% and 7% drive the action classification
  • Export the full ranked ledger to branded Excel for finance and trading teams
cash_exposure · May 2026 · ranked by £
McDonald's, Manchester +44,100 kWh · £3,528
Sainsbury's, Bristol +11,230 kWh · £898
Tesco, Watford -8,412 kWh · £673
Pret, Canary Wharf +340 kWh · £27
Greggs, Sheffield 0 kWh · £0
Total portfolio exposure · May 2026 £84,210

See it working on your data.

We'll walk you through Settlement Intelligence using a real monthly load. No slide deck. No pitch. Just the platform working.

Book a demo Get in touch