Im interested
contact tab
requirement fit buttonrequirement fit flyout

RollupSheets facilitate the Budgeting, Forecasting and Monthly Reporting Solution for Esorfranki limited

About Esorfranki Limited

Esorfranki is one of South Africa’s benchmark civil engineering and construction groups providing specialist geotechnical services, roads and earthworks, civils and pipeline construction. Two strategic acquisitions in 2008 saw Esorfranki diversify into the civil engineering construction sector, expanding its services from sub-surface foundation work to include above-surface civil engineering and pipeline construction services. Esorfranki has been streamlined into three core divisions, namely; a) Esorfranki Civils, b) Esorfranki Pipelines and c) Esorfranki Geotechnical, housed under a single legal entity - Esorfranki Construction, a wholly owned subsidiary of Esorfranki Limited. It operates throughout South Africa, sub-Saharan Africa and the Indian Ocean Islands.

The requirement

Realising that the capabilities of financial reporting in excel spreadsheets were limiting and the process of planning, modelling and consolidating various models, using these tools were more complex and error-prone than necessary, Esorfranki made the decision to implement a comprehensive software system to assist them with:

  • Statutory reporting;
  • Budgeting;
  • Rolling Forecast;
  • Monthly Reporting and
  • Weekly Cash Flow.

The software solution had to meet the following requirements:

  • be simple and time efficient to implement (they had less than two months due to stringent year-end and budgeting deadlines);
  • self-maintainable;
  • user friendly;
  • allow for faster, more efficient and accurate consolidations with drill down capabilities;
  • format of reporting must be controlled and updated centrally;
  • the system should have the ability to integrate directly with BuildSmart (the Esorfranki ERP system) to integrate monthly trial balances without any manual intervention;
  • incorporate currency conversions;
  • simplify data analysis and deliver reliable information to all decision-makers.

The solution

Esorfranki engaged RollupSheets, for its expertise in financial reporting and scoped the solution according to client appropriate implementation methodology, resource availability as well as stringent reporting deadlines. The first phase was implemented for monthly reporting and budgeting within a 4 week time frame and within scope and rolled out and used by all business units. Furthermore integration between BuildSmart and RollupSheets was rapidly achieved, which enables the import of trial balances directly into ever evolving reporting templates. The final reporting phase included the RollupSheets Statutory reporting application which went live for the February 2013 Year-end.

The result

Due to the RollupSheets and Esorfranki partnership a comprehensive reporting solution that includes a stable, dependable platform, improved control and increased transparency has been achieved. Consolidation results are more accurate, quicker to obtain and finalise. The ease of creating reports and drilling down into data within RollupSheets makes reporting to various Management layers much more efficient to fulfil operational tasks and outcomes.

  Download this case study