Automation System at Al Kabeer Group

Challenge

The sales and finance teams at Al Kabeer were manually preparing daily and monthly reports by consolidating data from multiple branches due to decentralized system. This process was time-consuming, error-prone, and often led to delays in decision-making due to inconsistent reporting formats and late submissions. Additionally, routine data entry and report distribution tasks consumed valuable time from key staff.

Solution

Developed a fully automated reporting workflow using Python and Excel, tailored to Al Kabeer’s multi-branch structure.
Key components included:

• Automated ingestion and cleaning of daily sales and stock files

• Dynamic generation of SKU-wise sales and inventory reports

• Automated data entry into pre-formatted Excel templates

• Scheduled email distribution of reports to leadership and regional managers

• Cloud integration using Google Drive for centralized data access and historical backups

Result

• Reduced manual reporting workload by over 80%

• Enabled real-time access to accurate sales and inventory data

• Improved reporting consistency across the whole Group (6+ countries).

• Empowered executives with timely insights, accelerating decision-making and reducing data-related bottlenecks