Real-time anomaly dashboard showing reconciliation status across 40+ clients
The Problem
Energy companies manage consumption data, invoices, and payments across disconnected systems. Reconciling these sources manually takes hours every cycle—and errors still slip through.
Finance teams spend more time chasing discrepancies than analyzing trends.
The Solution
An automated pipeline that consolidates three data sources, cross-references every transaction, and surfaces anomalies before they become problems.
How It Works
1. Data Ingestion
Consumption records, invoices, and bank payments are pulled automatically from their respective systems.
2. Reconciliation Engine
A custom n8n workflow merges records by client and period, then runs validation rules against the consolidated dataset.
3. Anomaly Detection
The system flags three types of issues:
- Consumption without invoice (orphan records)
- Payment-invoice mismatches (amount discrepancies)
- Overdue invoices without payment
4. Operational Dashboard
Results flow into an Airtable Interface where the operations team can triage, assign, and resolve each case.
The n8n workflow handling data merge and anomaly detection logic
Stack
Results
Anomaly breakdown by type and severity, with actionable next steps