CASE STUDY- CONSOLIDATION REPORT

Enabling Bonhill Group plc to strengthen the financial reporting of its corporate group with a Power BI (addon) solution that combined the financial statements of its subsidiary companies.

CASE STUDY- CONSOLIDATION REPORT

Enabling Bonhill Group plc to strengthen the financial reporting of its corporate group with a Power BI (addon) solution that combined the financial statements of its subsidiary companies.

CLIENTS:

TECHNOLOGIES INCLUDED:

ABOUT BONHILL

Bonhill Group plc is a leading B2B media company providing business information, live events and data & insight propositions to international Technology, Financial Services, and Diversity Business Communities. It strives for excellence in everything it does and takes pride in being entrepreneurial, creative, and thrives on generating new innovative solutions.

PROJECT SUMMARY

  • Bonhill Group Plc has many subsidiary companies. As a group, it was looking for a solution to meet its corporate financial reporting requirements. Together, the companies had the challenge of dealing with international markets, plus a variety of tax and accountancy procedures. They were initially managing their financial reporting in disparate systems. This meant that they could not drill down on their data in a centralised, integrated dashboard.
  • Preparing multiple reports for all its subsidiary companies took a lot of time and effort and the data was often vulnerable. Bonhill wanted a system that not only had better reporting capabilities but also worked smoothly with its current system implementations.
  • After mapping the requirements, Dogma Group proposed a solution which would centralise Bonhill’s scattered reports: Balance Sheet, Company-wise detail, G/L wise detail etc- in one interactive dashboard.
  • Bonhill selected Dogma Group as its partner for the project. We understood its critical business issues and could implement the right solution and within its timeframe. This meant it didn’t have to look for multiple partners for specific solutions.
  • Dogma Group scoped Bonhill’s requirements and identified a ‘best-fit’ solution that worked effortlessly with its CRM implementation and mitigated the need for any third-party solution. We developed the ‘Consolidation Report’ solution which integrated with PowerBI and strengthened its reporting capabilities.
  • Consolidation Report helped Bonhill combine financial statements of its parent company and its subsidiaries for fast and efficient statutory reporting.

PROJECT OUTCOMES

  • Dogma Group was able to meet Bonhill’s requirements with Consolidation Report. We also helped Bonhill ensure excellent user adoption and engagement as the solution is easy to use and efficient.
  • These apps were developed quickly and cost-effectively. Plus, the one-time setup ensured no future costs or issues, keeping Bonhill aligned to Microsoft’s bi-annual upgrade path for Dynamics 365.
  • This solution combined Bonhill’s financial reports, balance sheet, company-wise detail, G/L wise detail, and more in one interactive dashboard. This meant that the companies didn’t have to communicate for each individual detail as everything was accessible from a single interface.
  • Consolidation Report helped Bonhill improve its financial visibility, data accessibility and quality.
  • Bonhill’s companies run across multiple regions. They were able to better manage currency conversions, accounting standards, tax structures, compliance, and reporting requirements.
  • Strong dashboard and powerful visualisation of PowerBI provided easy data visibility. Bonhill was able to elevate its reporting with the power of visualisation using charts, graphs, and grids.
  • With Consolidation Report, Bonhill was able to record historical data on its finances to help its teams analyse trends and make better decisions.
  • This system architecture also provided multiple benefits in terms of being able to easily add other regions such as China without massive re-design and further development costs.
  • Teams functioning in silos meant the reporting was slow, manual, and often error-prone. With a 360-degree view of its financials, Bonhill was able to ensure better cross-team collaboration.

Contact Us

Do you have a question for us?
We would be happy to answer your queries. Contact us and we will get back to you as soon as possible.