The client needed a more efficient way to control and reconcile daily cash collections across its nationwide petrol station network. MY Synergy developed a centralized solution built on Microsoft Power Apps and integrated with SAP, replacing fragmented spreadsheets and manual reconciliation with automated data consolidation, validation and real-time monitoring.
The Challenge
Daily cash generated across petrol stations is collected by an external provider and reconciled by the company’s accounting team. The process previously relied on spreadsheets, manual comparisons and information from several disconnected systems. As transaction volumes increased, accounting teams spent significant time validating figures, checking deposits and transport records, and identifying discrepancies. The manual process also limited visibility into the performance and SLA compliance of the third-party cash collection provider.
The Solution
MY Synergy developed a centralized Daily Cash Collection platform using Microsoft Power Apps, bringing together data from station reports, ORPAK deposit data, BODU collection records and third-party cash transport information. The platform automatically consolidates and reconciles daily cash data, identifies exceptions and missing information, triggers threshold-based alerts and provides centralized dashboards for accounting and retail teams. Direct SAP integration automates financial reporting and maintains consistent accounting information.
Business Value
The automated cash collection control process delivered measurable improvements across accounting and financial operations:
5 FTEs of administrative workload saved per month
20% increase in overall accounting efficiency
Real-time visibility into cash collection SLA performance
Faster identification and resolution of discrepancies
Stronger financial control across the petrol station network
The client now operates a scalable, data-driven process that provides continuous visibility into daily cash collection and supports more efficient financial operations across its nationwide network.
Project Information
Industry
Energy
Client type
Fuels Provider
Project type
Automation Developmen
Outcome
20% increase in overall accounting efficiency
