Case Study: Maximising Efficiency in Month-End Financial ReportingMajor Steel Distributor - Across Multiple Sites, Australia

In today’s fast-paced business environment, there’s a critical window of opportunity availability of raw data from each location and the final deadline for producing comprehensive month-end financial results.

However, when reporting from a geographically distributed network of locations is not perfectly synchronised, delays can occur in upward flow of key results —ultimately impacting timely reporting to stakeholders such as the ASX.

Moreover, inconsistencies in data across locations can lead to significant rework, wasting valuable time and resources.

By streamlining and standardising the reporting process, businesses can not only improve the speed of results delivery but also enhance the accuracy and consistency of their financial reporting, ensuring smoother communication with all stakeholders.

Lean Six Sigma tools were used to analyse process flow to uncover the root causes of these issues. 

The process was mapped using the Value Stream Mapping technique.

Value add/Non value add analysis was carried out to strip out the waste in extraneous steps.  

The Takt time for the overall process and each sub process step was determined and used to match demand and resource requirements.

A Kanban in the form of a spreadsheet template was developed in order to standardise the information and the format. 

The template was sent by e-mail at a particular time each month to all the businesses by the group financial controller.  Using the template (Kanban) any changes in timing requirements could be easily accommodated, as the signal was the arrival of the template.

This provided the pull signal to commence the process of compiling the data for reporting.

The completed template was then returned by each business.