Not authenticated — some data may not load
 

UK Energy Industry Guide

Complete guide for energy brokers working with UK electricity, gas, and water markets

Back to Wiki

🆕 Multi-Utility Meter & Quote System (Nov 4, 2025)

The system now supports comprehensive meter tracking and quote comparison for all UK utility types:

⚡ Electricity
  • MPAN tracking (13 digits)
  • Profile class (00-08)
  • HH/NHH identification
  • Day/Night/Weekend EAC splits
  • kVA demand tracking
  • Day/Night/Weekend rates
  • Standing charge (p/day)
🔥 Gas
  • MPRN tracking (6-10 digits)
  • Annual consumption (kWh)
  • Unit rate (p/kWh)
  • Standing charge (p/day)
  • CCL tracking
  • Contract terms
💧 Water
  • Meter serial tracking
  • Annual consumption (m³)
  • Water rate (£/m³)
  • Wastewater rate (£/m³)
  • Standing charge (£/year)
  • Regional suppliers
Key Features: Per-meter tracking with current supplier data, Day/Night/Weekend consumption splits, kVA demand for HH meters, RPI & Volatility clause tracking, Multi-utility quote comparison, Professional PDF generation.

🆕 Unified Quick Actions & Activity Tracking (Nov 4, 2025)

Streamlined workflow with unified modal and comprehensive activity logging:

Unified Quick Action Modal

One modern modal handles all quick actions with dynamic fields:

  • 📞 Log Call - Duration, outcome, next action (follow-up/quote/LOA/contract)
  • ✅ Create Task - Type, status, priority, due date
  • 📄 Request Document - LOA, energy bill, contract, custom documents
  • ⏰ Set Reminder - Today, tomorrow, next week, custom date
Benefits: 50% less code, consistent UX, activity auto-tracked, professional interface
Activity Tracking System

Complete audit trail of all customer interactions:

  • Auto-Logging - Every action logged automatically
  • Timeline View - Icon-coded, color-coded, chronological
  • Entity Linking - Links to tasks, LOAs, quotes, contracts
  • Filter & Search - By type, date, or keywords
  • Activity Types - Calls, tasks, documents, LOAs, quotes, contracts, sites, meters
Compliance: Full audit trail, GDPR ready, complete customer history
Bulk Quote Entry

5x faster quote entry - Add multiple supplier quotes in one spreadsheet-like interface:

  • Table interface with dynamic rows
  • Add/remove quotes instantly
  • Sample data for testing
  • Real-time validation
  • Live Statistics: Quote count
  • Lowest day rate (best deal)
  • Average day rate
  • Total commission
Time Savings:
Old: 10 min for 5 quotes
New: 2 min for 5 quotes
80% faster!
User Experience: Unified modal = consistent interface across all quick actions. Activity tracking = complete customer history at a glance. Bulk quotes = professional workflow for comparing 3-5 supplier proposals in minutes instead of hours.

✨ Latest Enhancements (Nov 5, 2025) - v3.0

Major productivity improvements and complete commission management:

Global Search

Google-style autocomplete search across the entire system:

  • Live suggestions as you type
  • Searches: Customers, Suppliers, Sites, Tasks, Contracts
  • Keyboard navigation (↑↓ arrows)
  • Color-coded icons
  • Metadata display (email, MPAN, MPRN)
80% faster navigation
Commission Center

Complete commission invoice tracking and automation:

  • To Send: Draft invoices ready
  • Awaiting Payment: Tracking with days until/overdue
  • Paid: Historical records
  • Reconciliation: Missing payments, variances
  • Automation: Supplier payment patterns
Complete money management
Document Management

Enterprise document repository with version control:

  • 10 document types (LOA, Bills, Contracts, etc.)
  • Link to Customers, Suppliers, Sites, Contracts
  • LOA expiry tracking (30-day alerts)
  • Version control with parent-child
  • Search, filter, tag, archive
Central file repository
Broker Productivity:
  • Global Search: Find any customer, supplier, or contract in seconds
  • Commission Tracking: Never lose track of payment due dates or supplier patterns
  • Document Management: All LOAs, bills, contracts in one searchable location
  • Supplier Auto-Logos: Professional branding automatically fetched

MPAN - Electricity Meter (13 digits)

S 00 111 222
   12 3456 7890 345
Profile Classes
Class Type Settlement Data Frequency
00 Half-Hourly (HH) Half-Hourly 48 readings/day
01 Domestic Unrestricted Non-Half-Hourly Monthly
02 Domestic Economy 7 Non-Half-Hourly Monthly
05-08 Non-Domestic Must upgrade to HH P272 Regulation
HH Mandatory: Businesses using >100,000 kWh annually or >100kW peak demand must have Half-Hourly metering.

MPRN - Gas Meter (6-10 digits)

1234567890
  • Simpler than MPAN - no profile classes
  • Found on gas bills
  • Required for switching suppliers

Half-Hourly vs Non-Half-Hourly

✅ Half-Hourly (HH)
  • Automatic 30-min readings
  • Accurate billing
  • Time-of-use tariffs
  • Peak/off-peak rates
  • Cost optimization
  • No back-billing
⚠️ Non-Half-Hourly (NHH)
  • Manual/monthly readings
  • Estimated billing
  • Risk of back-billing
  • No time-of-use optimization
  • Limited tariff options

HH Data Format

Half-Hourly data contains 48 readings per day (every 30 minutes):

Date,Period,MPAN,Consumption_kWh
2025-11-03,1,1234567890123,45.2
2025-11-03,2,1234567890123,42.8
...
2025-11-03,48,1234567890123,52.1
  • Period 1-48: Each 30-minute slot
  • Period 1: 00:00-00:30
  • Period 48: 23:30-00:00

P272 Regulation

Introduced: 2017 by UK Government

Requirement: Profile classes 05-08 must upgrade to Half-Hourly (00) metering

Affected Industries: Electricity-intensive sectors (manufacturing, food processing, etc.)

Action Required: If you see profile class 05-08, advise client to contact their meter operator for upgrade to HH metering.

Broker Recommendations

When Onboarding New Client
  1. Check MPAN Profile Class
    • If 00 → Request HH data access
    • If 05-08 → Advise HH upgrade
    • If 01-04 → Standard NHH process
  2. Assess Annual Consumption
    • <70,000 kWh → NHH suitable
    • 70,000-100,000 kWh → Consider HH upgrade
    • >100,000 kWh → HH mandatory
  3. Data Requirements
    • HH clients: Request 12 months HH data
    • NHH clients: Request 12 months bills
    • Analyze peak usage patterns

Value-Add Services

Energy Audits
  • Analyze HH data for waste
  • Identify peak shaving opportunities
  • Recommend equipment upgrades
Demand Management
  • Shift usage to off-peak
  • Load balancing strategies
  • Battery storage recommendations
Renewable Integration
  • Solar PV sizing
  • Export tariff optimization
  • Battery storage ROI
Compliance Support
  • LOA management
  • P272 compliance
  • GDPR consent tracking

Dernetz System Features

✅ Currently Implemented
  • MPAN validation with profile class extraction
  • Auto-detect HH vs NHH from profile class
  • P272 compliance warnings
  • MPRN validation for gas
  • 4-step site wizard
  • Real-time MPAN analysis
🚀 Coming Soon
  • HH data CSV upload
  • Consumption visualization dashboard
  • Peak demand analysis
  • Cost optimization alerts
  • Automated reporting

Commission Control Center (NEW)

Production Ready! Complete commission tracking and invoicing system now available.
📊 What It Does
  • Track Commission Contracts: Manage agreements with suppliers (uplift per kWh or fixed monthly)
  • Record Usage: Import monthly consumption data for all MPANs/MPRNs
  • Calculate Commission: Automatic calculation: (usage/100) × uplift
  • Generate Invoices: Professional invoices with line items for each MPAN
  • Track Payments: Monitor sent, paid, and overdue invoices
  • Learn Patterns: System learns each supplier's payment behavior
  • Detect Issues: Reconciliation engine flags missing/incorrect/late payments
🎯 Quick Start
1. Create Service Connection (MPAN/MPRN) 
POST /api/commission/service-connections
{
  "site_id": "site_123",
  "customer_id": "cust_456",
  "service_type": "Electricity",
  "meter_number": "1200010029773"
}
2. Create Commission Contract 
POST /api/commission/contracts
{
  "customer_id": "cust_456",
  "supplier_id": "supp_789",
  "uplift_amount": 3.5,
  "start_date": "2025-01-01",
  "end_date": "2027-12-31"
}
3. Record Monthly Usage 
POST /api/commission/usage
{
  "service_connection_id": "...",
  "year": 2025,
  "month": 10,
  "usage_kwh": 10000
}
// Commission: £350 (auto-calculated)
4. Generate Invoice 
POST /api/commission/invoices/generate
{
  "supplier_id": "supp_789",
  "year": 2025,
  "month": 10
}
// Creates invoice with all line items
🖥️ Access Points
Main Dashboard
Open Dashboard

Energy + Commission tabs

Commission Only
Open Commission

Full invoice management

API Documentation
Open API Docs

20 commission endpoints

🤖 Intelligent Automation

System learns each supplier's payment behavior:

  • Payment Lag: Tracks if supplier pays immediately, 1 month behind, or 2 months behind
  • Payment Frequency: Monthly, quarterly, or annual patterns
  • Reliability: On-time payment rate (%) and average days to pay
  • Optimization: Automatically adjusts invoice timing based on learned patterns
📚 Documentation
  • COMMISSION_CONTROL_CENTER.md - System overview
  • COMMISSION_SYSTEM_ARCHITECTURE.md - Data architecture
  • CODE_ORGANIZATION.md - Developer guide
  • QUICKSTART_COMMISSION.md - 5-minute setup
  • README_COMMISSION_SYSTEM.md - Complete reference
  • DEPLOYMENT_CHECKLIST.md - Deployment guide
  • COMMISSION_COMPLETE.md - Final summary
  • Changelog - All updates
Key Feature: No data duplication - MPAN/MPRN stored ONCE in service_connection, referenced everywhere. Complete traceability from usage → invoice → payment.

External Resources