MA!N as a data hub for reporting and management information
We get tons of questions about reporting and BI with MA!N. Although the information need differs strongly between companies. Recently we have implemented a global reporting solution for a customer which perfectly represents the endless possibilities that MA!N offers. I really like our approach in these matters and would like to share this case with you.
In 2016 we have started the roll out of MA!N for a global customer. While writing this, MA!N is live in over forty countries for this customer, with more than five hundred users. Beside these countries MA!N also collects data from twenty additional countries that are not using MA!N actively (yet).
One of the main objectives for the customer was reducing risk by gaining insights in trends and customers from a global perspective, without having to analyse each country separately.
In this case MA!N collects data from sixty countries. It spreads the data across fifty database and each country works from its own environment within MA!N. Credit managers can easily gain an overview of their country and see the latest status regarding customers, invoices and risk.
There’s a separate environment that collects data on a global level. This database collects key figures from all sixty countries. This is information regarding bad debt, action bad debt, overdue end of month (this is a predictive value) and more.
Besides collecting key figures on a global and regional level, the same thing is done for corporate customers. A company like Sony, for example, can be a customer in fifty countries. All these “individual” Sony customers are merged into one global customer account. This enables the company to create an overview of cost of credit an customer credit risk within a few clicks. Previously an employee had to collect all the information from individual customers manually.
KPI’s, trends and reporting
At regular intervals certain data sets are saved for reporting purposes. Weekly, KPIs are collected on a corporate level regarding countries, regions and customers. It allows the company to analyse trends and compare periods with each other. At lower levels, such as for collectors, KPIs are saved on a daily basis. This is used by managers and collectors for operational management.
The KPIs that are calculated, range from something as general as a DSO, but also the percentage of automation. The latter examines what part of the activities is carried out without the intervention of an employee which is also calculated for individual customers.
By using MA!N as a global reporting tool, the company has achieved results like:
- Much less time is needed for reporting. MA!N generates standard reports and sends them to the right people without human intervention.
- The people who previously we’re collecting data and reports, are now analysing and benchmarking data.
- Savings in FTE.
- Better risk control.
- Lower DSO.
This case is one example of how you can use MA!N as a reporting tool. As a customer, you will decide which set-up suits your organisation best.