Business reporting cases & case studies
Financial consolidation cases & case studies
Examples and Cases
HB Software develops an initial basic reporting set (a profit and loss account and balance sheet) and helps you to configure the database. You and your colleagues will receive a three-day training in application management and form creation, after which you can get started on your own. HB Software will then step aside and provide support for creating and adjusting your own sets.
Project Consolidation and Prognosis
A Dutch construction company relies on its ERP system for its operational processes. However, forecasts of regionally implemented projects and financial consolidation are done through Exsion Corporate. Exsion Corporate thus constitutes the financial reporting axis of the company: Forecasts are assessed each month and future profitability is monitored.
Consolidation of Floating Equipment
A towing company operating internationally uses Exsion Corporate to collect data on the daily operation of vessels sailing world seas. Each month, the holding knows the result of each individual vessel and its future development.
An investment company has global investments in the mining industry and companies that produce raw materials. Local accountants draft quarterly financial statements and submit reports that are consolidated through Exsion Corporate, which in turn generates overviews. Investment managers are able to perfectly monitor performance of operating companies. The investment company itself can implement changes in reporting packages.
Consolidation and Forecasts
The cooperative society has branches in 22 countries. There is a single ERP system, used to manage products, inventory and accounting, with the exception of financial planning and reporting. Exsion Corporate supports inter-company elimination, budgeting, forecasts and financial consolidation. Reports for the Supervisory Board are generated automatically.
Consolidation in Buy-and-Build Strategies
For years already, Exsion Corporate has been running smoothly and stable, providing financial and management consolidation to 350 European companies. The mother company, quoted on the stock exchange, decides to proceed with the biggest acquisition in its history. Within two months, an additional 180 companies must be consolidated and 150 additional users must (automatically) provide figures. The deadlines are met and after two months the new daughter’s data are incorporated in the consolidation.
Consolidation That Continues After Spin-Off
A UK company is acquired by an investment company. To continue reporting, Exsion Corporate, the consolidation system of the mother company, is purchased. Its reporting set is largely endorsed. The investment company transfers other US companies to the aforementioned company and partially lists the group on the stock exchange. Exsion Corporate demonstrates flexibility in handling these changes and acts as the reporting backbone of this international corporation.
Approach & Benefits
Time for Things That Really Matter
With Exsion Corporate, you no longer have to chase figures to get complete overviews. In Exsion Corporate’s back-end database, all group reports are automatically processed and consolidated. Cutting and pasting is therefore a thing of the past, thus ensuring correct data the first time. Exsion will even put together your presentation form, for example, a beautiful digital book or hard copy. Now you can spend time on things that really matter.
One Solution for All Reporting
Exsion takes work off your hands when entering data and/or performing a consolidation. Smart checks and validations ensure that all data retrieved from the source is correct. Upon consolidation, Excel will perform all calculations relevant to your reports. You can easily create reports yourself, so you will not need a consultant for each change you want to implement. Exsion Corporate’s flexibility – it basically is suitable for any digital source – is the reason that many clients also use the software for security reports, liquidity forecasts and environmental footprint reports.
The software was created using Microsoft technology and common Office products (such as Excel and Outlook. The database is provided in SQL Server Express format (the free version). To run Exsion Corporate, you will need a relatively light-weight server. Hardware and software investments are modest and easily scalable. Exsion Corporate is also available as a cloud-based solution.
Examples and Cases
The strength of Exsion Reporting is that it allows you to quickly and easily create reports, exactly like you want them. A list, management report or a dashboard with KPIs, and much more. You can create custom reports yourself, there is no need to hire expensive consultants.
Faster and Cheaper Audits
More and more companies are facing increasing and changing regulation, as well as increasing audits. Think of, for example, accountants and banks that require overviews, but also clients who want know precisely which batch contained which product(s). And, preferably, as soon as possible. You have not even finished the current accounting statement yet, so to speak, and are already expected to present the next one. With Exsion, you can quickly change reports and have them printed at the press of a button. One of our clients told us that the use of Exsion resulted in a reduction of accounting costs of 50 per cent.
Easily Modifiable Debtor Statements
Every company pays attention to its liquidity position. After all, you want to know if you are still able to pay your bills. To do so, you need to quickly determine who your debtors are, in other words, those clients who have not paid. You can find a debtor statement in BC/NAV. You can also create one in Exsion, the big difference being that you can easily modify it in Exsion. For example, adding a phone number in a separate column to facilitate follow-up calls to clients is easy, and if you would like to commence with those most overdue, it is just a matter of simply configuring a different filter and the list will be presented in front of you.
Weekly Sales Overviews for the Trade Sector
International trading companies want to know the profit margins of their products. Often, it seems simple, but complex in practice. For example, in the case of compound products, or if products are available in different variants. Vendors have their General Terms and Conditions, as do clients, who often also insist or have agreed on quantity discounts. In order to calculate the profit margin of a given product, Business Central/NAV must be configured properly. With Exsion, for example, you can easily determine the top 10 of products with the highest profit margin or turnover rate.
Overview of Construction Projects
Construction companies generate income through the construction projects they carry out. Procurement of materials, temporary workers, hours worked by staff members, all of the aforementioned are expense items. As profit margins in construction are low, you want to know whether the margins made suffice, or adjustment is required. The advantage of Exsion is that you can easily retrieve data from Business Central/NAV, as well as calculate forecasts within Excel. As a result, dozens of construction companies currently use Exsion.