Project Overview

PT Komatsu Indonesia is an organization that engages in heavy equipment. As organizations grow in size, difficulties in financial consolidation and reporting often grow. Challenges include multiple currencies, different accounting standards, wide range of reporting and compliance regulations and many more. These challenges trigger organizations to work more for a better result. The company trusted WGS to develop an application for their process business. It is a system to consolidate financial report for KI Group Companies to produce KI Group Financial Consolidation Report. Generally, each subsidiary will receive excel template to be filled. Then, they should input directly the report (excel file) through internet to KI Consolidation Server. Report from all subsidiaries will be consolidated to be Consolidation & Disclosure Report. The system itself consists of two layers:
1. Consolidation Portal System.
The system becomes the starting point for users to begin activities related to the data collection that will be used as the basis of the consolidation process. The portal also can be used as the tools for communication from KI to its subsidiaries.
2. Consolidation Application System.
The system is used to consolidate all reports and data from KI’s subsidiaries that have been collected through the consolidation portal system. It is used by PT KI and Group to make the KI consolidation financial statement bound together with the notes on the report.

Business Issue

The client wanted a customized software, which can ease their financial consolidation system.

Business Solution

Develop a new modern and fast system, which replaced client’s existing software.

Lesson Learned

Our developers learned a new technology. It is to process xlsx file using Ruby on rails, with the customized big report templates as the reference.

Benefits

Overall the system helps the central office in simplifying data collection from all branch office to be processed to the final reports.