Reconciliation: Fuel distribution’s N800 billion nightmare

Africa’s fuel distributors lose N800 billion annually to inventory discrepancies—terminal liftings that “disappear” en route, depot receipts shorter than trucks claim, station tanks dipping mysteriously. Manual Excel wars consume 14 days/month-end, disputes tie up cash, regulators fine unproven claims. 2.5% average variance = margin death.

ROCKEYE ERP eliminates this with digital threads from TAS terminals through depots to Smart Stations. Reconciliation drops from weeks to hours, accuracy hits 99.5%, recoveries average N250M Year 1.

Challenge 1: Terminal-to-Depot “Meter Magic”

The gap: Terminal meter reads 45KL. Depot dip shows 44.2KL. “Evaporation,” claims driver.

Root causes:

• Meter drift (0.5-2% between calibrations)
• Hose residue/nozzle drips
• Collusion (meter rollback)

ERP fix: TAS digital manifests mandate truck meter photos + seal timestamps. Depot scales verify gross weights. Inventory ML baselines variances by truck/route.

Scenario: Warri terminal dispatches 32KL AGO, sealed photo timestamped. Ibadan depot scales 32.1T, dip reads 31.8KL. ERP flags 0.3% anomaly, holds payout, inspection finds siphon. Recovered: N142K/load.

Network math: 500 trucks/month = N71M protected.

Challenge 2: Depot-to-Station “Dip Disappearances”

The gap: Depot receipt 28KL verified. Station tank shows 27.4KL after 2 days.

Culprits:

• Truck siphons mid-route
• Depot “measurement errors”
• Station pre-sale dips

ERP solution: Vehicle Tracking GPS correlates idle times with losses. Smart Station IoT hourly tank dips vs POS sales. RPA flags attendants with high “dips.”

Real case: Abuja station: Expected 4,500L delivery. IoT shows 4,320L received. GPS idle 2hrs Km45. Driver retrained, 180L x N950 = N171K recovered.

Chain-wide: 300 stations = N51M/month leakage stopped.

Challenge 3: Multi-Leg Variance Compounding

The cascade: Terminal 10KL → Truck 9.95KL → Depot 9.92KL → Station 9.85KL = 1.5% “normal” loss.

Compounder: Each handoff adds 0.3-0.5% error. Month-end “rounding.”

ERP chain-of-custody:

TAS lift cert → Digital manifest → Truck POD photos

Depot scale + IoT dip → Station IoT receipt + POS

RPA auto-reconcile 90% → Exceptions flagged

Transformation: Variances compound to 0.3% network-wide. NMDPRA audits clear instantly.

Challenge 4: Cash Sales “Vaporization”

The black hole: Station POS says N2.4M cash sales. Till N2.1M. “Customer walk-offs.”

Fix: Smart Station mandates POS before pump activation. IoT validates tank-to-sales match. ML flags high-cash attendants.

Impact: Cash leakage 12% → 1.2%. N120M recovered across 500 stations.

Challenge 5: Month-End Reconciliation Hell

14-day torture: 50 Excel sheets, terminal calls, depot emails.

ERP RPA: Daily auto-posts TAS liftings, depot receipts, station sales to Finance GL. Exceptions (0.2%) route to approvers via mobile.

Win: Close in 48 hours. CFO daily P&L.

Challenge 6: Regulatory Proof Demands

NMDPRA/EPRA: Prove every KL sourced, moved, sold compliant.

ERP audit armor: Immutable logs—meter certs, seal photos, dips, POS. Digital packs <5 mins.

Fines avoided: N300M+ annually.

ERP Reconciliation Arsenal

Layer 1: Digital proofs everywhere

TAS: Meter certs + tank IoT

Truck: GPS seals + POD photos

Depot: Scales + dip certs

Station: IoT tanks + POS mandatory

Layer 2: ML variance hunters

0.2% threshold flags

Route/driver baselines

Idle hotspot correlation

Attendant scorecards

Layer 3: Closed-loop enforcement

Unverified = payout hold

Repeat offenders = bans

Daily RPA (90% auto)

Deployed results: N342M average recovery

Leak Point	Pre	Post	Monthly Save
Terminal-Depot	1.8%	0.3%	N120M
Truck-Depot	1.2%	0.1%	N85M
Depot-Station	0.8%	0.1%	N42M
Station Sales	1.5%	0.2%	N95M
Total	5.3%	0.7%	N342M

Bonus: Month-end zero variance. Finance trusts data.

90-Day Reconciliation Revolution

Phase 1 (30d): TAS + 50 trucks digital manifests Phase 2 (60d): 20 depots scales + IoT Phase 3 (90d): Smart Stations + RPA live

Cost: N45M → N342M ROI Year 1.

Africa-ready: Offline PODs, solar scales, WhatsApp exceptions.

Reconcile to dominate

Manual reconciliation = margin suicide. Petroleum ERP digital chains recover N342M, free finance for strategy.

Lagos distributor: Disputes extinct, N420M back Year 1.

Start: Leak audit Monday. Petroleum Terminal Automation System pilot Week 4. Millions return.