Customer story · Organizational consulting

Peers Group produces 10 monthly reports across 9 subsidiaries without Excel

Peers Group, an organizational consulting group with 9 subsidiaries in France, Switzerland, Turkey and Morocco, connected Sage to EMASPHERE. Its CFO now produces 10 monthly reports without reworking them in Excel.

· Updated · By

In short

Peers Group's project in 30 seconds

  • Challenge

    Ten monthly reports were built by hand in Excel, and one missing entry meant redoing every step.

  • What changed

    Sage feeds EMASPHERE, which produces group and subsidiary views with intercompany flows eliminated automatically.

  • Result

    The CFO produces his 10 monthly reports without Excel rework, and directors log in to see their own results.

  • 10 monthly reports, with no Excel rework
  • 9 subsidiaries in four countries

About Peers Group

Founded in 2012, Peers Group supports companies across all sectors with organizational consulting. It has more than 180 employees and 9 subsidiaries in France, Switzerland, Turkey and Morocco.

The group connects its Sage accounting software to EMASPHERE.

Consultants working together around a wooden table

Peers Group at a glance

Fact Detail
Organization Organizational consulting group
Founded 2012
Subsidiaries 9 (France, Switzerland, Turkey, Morocco)
Employees 180+
Systems connected Sage (accounting)
Used for Consolidation, intercompany eliminations, subsidiary reports, drill-down
Spokespeople Thierry Guelfi (Group CFO, HR & Legal)

Now everything is online, and everyone works from the same information to analyze and make decisions.

Thierry Guelfi Group CFO, HR & Legal, Peers Group

Why did Peers Group stop building its reports in Excel?

Because ten manual reports a month left no room for error. Every month, Thierry Guelfi sends a consolidated report to executive management and one report to each subsidiary director. In Excel, that meant several Sage extractions and hand-built files for every entity.

“Once my 9 reports were built, I combined them in a new file to get a consolidated view. But if an accounting entry was missing, I had to repeat every step, which was tedious. Some files also had several thousand rows, so processing took a long time. It was all the more stressful when my management committee met an hour later and I had to present up-to-date results.”

“As soon as I make a change in my accounts, it shows up in my EMASPHERE reporting in a few clicks, without any extracts or data manipulation. So my reporting always matches my accounts.”

Illustration: three entities consolidated into one group view

How does Peers Group work with its subsidiaries now?

From one shared, validated source. The CFO switches in one click between the group view and any subsidiary, with intercompany transactions eliminated automatically in sub-consolidations.

“We have many companies in France and abroad. In EMASPHERE, we can switch in one click between a consolidated group view and a view of one specific subsidiary. The solution also separates out intercompany transactions, so each entity has its own line for flows between companies.”

“By clicking on any figure, I can see the detail right down to the accounting entry, which lets me check that the data entered in the accounts is reliable.”

No more report versions by email

“Today, once I’ve validated the reporting in the platform, I make it available to the right people. Each director gets a notification and can log in to EMASPHERE to view their results.” Every version is archived, so the group can return to any past situation.

Illustration: validated monthly results shared with directors, the CEO and the board

Questions about Peers Group's project

Which accounting software does Peers Group connect to EMASPHERE?

Peers Group connects its Sage accounting software to EMASPHERE.

How many reports does Peers Group produce each month?

Ten: a consolidated report for executive management and one report for each subsidiary director, with no Excel rework.

How are intercompany transactions handled?

EMASPHERE separates them out by entity and eliminates them automatically in group and sub-consolidated views.

How do subsidiary directors get their figures?

Once the CFO validates the reporting, each director receives a notification and logs in to EMASPHERE to view their results.