One report for the whole group
To know how much we have sold in total, we need three spreadsheets.
- What we do
- Data from each country's ERP flows into a single database, in one currency, mapped to the same reporting chart of accounts.
- How we do it
- First we decide with you what the group wants to see: sales, margins, whatever you ask each company for in a spreadsheet today. Then we write how each piece of data is read: how it is converted into the group's currency, at which exchange rate and under which account of the same chart of accounts. We connect the ERP of each country to a single database, check the dashboard against the figures of a month already closed and, once they match, the dashboard updates itself.
- What you receive
- A group dashboard that updates itself.
- What changes for you
- No one merges spreadsheets by hand to know what the group has sold. The figures of each country are read the same way and can be compared, and the dashboard is up to date without asking anyone.
- What we need from you
- Read-only access to each country's ERP, one person from the finance department to say which figures count and how they are read, and the spreadsheets prepared today, as a starting point.
- Who it is for
- CEO and CFO
- How you buy it
- A project, plus a recurring fee.
Example use cases
These are examples: they do not describe a real client.
A cosmetics group with companies in Italy, Spain and Chile
The situation
Every month each company pulls its sales out of its system and sends them in a spreadsheet, each with its own columns and its own currency. At head office someone merges them by hand, converts the Chilean pesos into euros and prepares the total. When someone asks for a figure mid-month, the answer is to wait for next month.
What we do
Data from the three systems flows into a single database, in euros, at the exchange rate the written rule sets and read through the same chart of accounts. The group dashboard updates itself: each company's sales and the total are up to date, and the monthly spreadsheet is no longer needed.
A wine group with companies in Italy, Spain and Argentina
The situation
Before each board meeting, the finance department prepares the margins of Italy, Spain and Argentina. Each company calculates them its own way: one includes transport and another does not, one counts discounts separately. The figures arrive, but they cannot be compared, and the meeting starts by arguing about the numbers instead of the decisions.
What we do
With the finance department we write how each piece of data is read in the same chart of accounts: where transport goes, where discounts go. The data of each country is read that way from the single database, and the board sees everyone's margins in one report, on the same basis.
Frequently asked questions
Do the companies have to change their accounting?
No. Each company keeps its accounts as it does today; the same chart of accounts is only used to read the group's data the same way.
What currency does the dashboard use?
A single one, chosen by the group, at the exchange rate the written rule sets.
Can more data be added later?
Yes. We start with what costs you most today, such as sales, and at each following stage we agree on the data to add.