Showcase GROUP Forecast

Collect monthly financial statements and rolling forecasts from your subsidiaries

Use this showcase to test data1.io for decentralized collection of financial statements from your group subsidiaries on a monthly basis.
Show the actuals from last month und enter actuals for the current month plus 6 months rolling forecast.
Create as many forecast versions as you want/need.
You can use both the Web Client as well as the Excel Client in this showcase.

Getting Started with the Excel Client

Every subsidiary belonging to the group of companies gets monthly an invitation mail for the current collection workflow and then they enter their monthly financial statements (actuals) including a 6 month rolling forecast.
The subsidiary can get access to all of its own historical data (read-only). Data for the current period can be / must be entered as long as the current collection workflow is open. The workflow is individually closed by every single collection user pressing the “FINISH” button.
This way, the group controller knows which companies have already finished their data delivery and then uses the real-time aggregation functionality of data.1io to get the financial statements of all subsidiaries summed up. She/he checks the final results and can re-open some single subsidiaries in order to update their data.
The data can be connected via the ODATA-API to a dashboarding service like Microsoft Power BI and/or into a legal consolidation solution like SAP®.