
Energy

Reduction in invoice processing / reconciliation time
Improvement from pricing optimisation
52%
Coal depots consolidated into the unified dashboard
Automating coal tariff lineage and multi-depot price reconciliations gave our operations and finance teams total clarity.
Dinesh Singh Lodhi
Commerce Department
Apraava Energy

About
An Indian power generation company cut coal invoice reconciliation time 72% with one ETL dashboard tracking coal invoices, rates and grades across its depots.
Industry
Energy
Company size
1,000+ employees
Founded
2020
Business Context
Business context and operating model
A Commerce Department buying coal across multiple depots The client's Commerce Department procures raw coal from a network of depots to supply its generation assets. Each depot invoiced independently, in its own format, making it difficult to build a single, current view of pricing and quality across the network.
Problem Definition & Framework
Current State
Failure Modes
Decision Criteria
KPI Baseline
Problem definition and framework
Invoices and coal-quality data that never lined up Invoices arrived from various coal depots in inconsistent formats, requiring manual reconciliation before the Commerce Department could see accurate landed pricing. Coal rate and grade data lived separately from the invoicing data, so spotting a shift in quality or price meant pulling numbers from multiple sources by hand.
Decision framed: How can depot invoices, coal quality data, and pricing changes be reconciled into one current view for commerce and procurement decisions?
Framework used: Procurement data lineage, invoice reconciliation, and coal grade/rate exception taxonomy
Baseline mapped: current process, failure modes, handoffs, data owners, and decision latency.
Success criteria tied to business KPIs, adoption behavior, and operating cadence changes.
How it works
Before / After

Architecture

Process Flow

Data Pipeline

Results

Delivery Timeline

Engagement Method & Process Diagram
01 Discovery
02 Data Audit
03 Baseline
04 Prototype
05 Pilot
06 Production
07 KPI Monitoring
Engagement method and process diagram
Process diagram: Depot invoices + coal-quality data + procurement records -> ETL normalization -> reconciliation checks -> pricing/grade dashboard -> exception review -> pricing optimization support
Engagement method: Invoice format inventory; depot-data mapping; ETL and validation rules; pricing dashboard design; exception workflow; commerce-team adoption review.
Delivery pattern: discovery, data audit, baseline measurement, prototype, pilot workflow, production rollout, and KPI monitoring.
An ETL pipeline from raw depot data to a live pricing dashboard We streamlined invoice intake from the various coal depots, built an ETL pipeline moving raw procurement and coal-quality data into a unified warehouse, and layered a dashboard on top so the Commerce Department can track coal rate and grade changes and support pricing optimisation from one current view.
Architecture, Results & Measurement
Solution architecture, results, and measurement
A single, current view across every depot The Commerce Department now tracks coal rate and grade changes across depots from one dashboard instead of reconciling invoices by hand, with pricing optimisation built directly on top of the unified data.
Measured outcome: 72%: Reduction in invoice processing / reconciliation time
Measured outcome: 100%: Improvement from pricing optimisation
Measured outcome: 52%: Coal depots consolidated into the unified dashboard
Measurement loop: compare weekly operating behavior against baseline, surface exceptions, and review model/workflow drift with business owners.
We finally have one number for what coal is costing us, instead of a dozen spreadsheets that never quite agreed.
Commerce Department, Indian power generation company
KEEP READING
Explore more studies on AI, analytics, and enterprise intelligence.








