ACCOUNTING AND POWER BI MANAGEMENT FOR A LISTED COMPANY

Our client is a listed company, managing over 200 entities in France, Spain and Italy.

For 60 of these entities, the company called on Becouze to consolidate and harmonise accounting management, as well as to set up cost accounting to monitor the forecast budget established by the marketing department.

Equipe travaillant sur Power BI

Optimising company accounting

60 different entities, 60 different ways of keeping accounts.

In this context, our role is to secure the management of payments and harmonise the chart of accounts of these entities in order to control the budget and optimise taxation.

Faced with a complex set of specifications, the Becouze teams began by benchmarking the tools best suited to the company’s needs. They were then able to contribute to a number of different projects:

  • Bookkeeping and tax management using FULLL software,
  • Management of contribution calls, reminders and formal notices for outstanding invoices using MEG invoicing software,
  • Installation of YOOZ software to optimise the invoice validation workflow for the various entities,
  • Sending out invitations to General Meetings via the MAILEVA application and presenting the financial statements at General Meetings.

Installing a powerful account analysis solution

In addition to this accounting mission, the company wanted to provide its operators with the most accurate accounts analysis tool possible, so that they could visualise the company’s actual cash flows and compare them with their initial budget. Our IT team therefore suggested that the company use Power BI software to format and analyse all their financial data.

To achieve this, an RPA (robotic process automation) was first put in place to extract all the necessary files from the FULLL accounting production tool. This automation makes the process faster and more reliable, so that the accounting data can be updated quickly in Power BI.

Through this, Power BI users can compare the company’s budget and actual flows in an instant. But that’s not all: since the tool is based on general ledgers and aged balances, why not go one step further? By creating various tabs for monitoring cash flow and outstanding invoices, Becouze has enabled the company to easily complete its data analysis. A real revolution for the Finance team, who can now view the results and balance sheet of each of the entities as well as the 60 members of the Group… in just a few clicks!