How Virtuo reduced the time spent on budgeting preparation by 50%

With Tristan Gasté, Finance & BI Analyst · Virtuo

With , · Virtuo

“Our Management team uses Pigment to measure the impact of hiring on growth and budget, as well as to make key hiring decisions - optimal time to hire."

Tristan Gasté
Finance & BI Analyst
Tristan Gasté
Finance & BI Analyst
Number of employees
201-500
Used by
Finance teams
Headquarters
Paris, France
Industry
Travel & Hospitality
Implementation time
4 weeks
Integrations with
Looker, Google Suite
A few seconds
in Pigment vs weeks in Excel for establishing base in a new country
-50%
Time spent on the Budgeting process
4 weeks
of implementation and training time
5 applications
Data Hub, Budget, Staff Costs, Car Costs, Actuals

At a glance

Through Pigment, Virtuo has been able to:

  • Cut the time dedicated to data aggregation by running imports from Looker
  • Shorten the update of budget files: one month with Google Sheets vs two weeks with Pigment 
  • Reduce financial preparation to reforecasting time from three weeks with Google Sheets to two days with Pigment by reforecasting faster and more frequently with the scenarios feature
  • Add more granularity in business analysis
  • Enable stakeholders to make better decisions
“From copying and remodeling our P&L to consolidating the data after the setting up of operations in a new country, it used to require weeks of work on Google Sheets. Today, with Pigment, we can run the same process in seconds through multidimensional calculations." 

Tristan Gaste, Financial & BI Analyst at Virtuo

Virtuo is the new generation of car rental companies. The company’s mission is to offer the best car rental experience that frees people and cities from the burden of car ownership. It operates in six countries: the United Kingdom, France, Italy, Spain, and new offices in Germany and Portugal.

Having multiplied its headcount by two and its turnover by four over the last two years, Virtuo was looking for an FP&A planning tool that could scale with changing models and support exponential database growth.

When Excel can’t scale, your FP&A process is broken!

By looking at Virtuo's path over the last two years, you can envision an incredibly fast-growing company:

2x 4x 15x 160%+
Headcount Turnover #Suppliers Cars Fleet

And with that growth came the inherent challenges of an FP&A team working with Google Sheets, that couldn’t scale as fast as the business.

  • Google Sheets frequently crashed trying to handle enormous data volumes
  • Time to update budget files was growing increasingly
  • The sheer volume of Google Sheets files quickly grew unreasonable
“We are a data driven company, we aspire to keep the granularity of our analysis while growing. We were reaching a limit by doubling or tripling the size of our databases each year with Google Sheets." 

Tristan Gaste, Financial & BI Analyst at Virtuo

The time was ripe for a scaled FP&A process. Virtuo deployed Pigment to save more time for actionable analysis. As a result, the company was able to drive the business by providing fast, up-to-date insights to the leadership team.

Evolve your business planning to sustain your rate of growth

For fast-growing companies, agility is key. And the function of agile business planning is to:

  • Evolve as fast as the business
  • Give fast and accurate answers to stakeholders
  • Help align the whole organization

By using Pigment, Virtuo has been able to:

  • Cut the time dedicated to data aggregation by running imports from Looker
  • Shorten the update of budget files: one month with Google Sheets vs two weeks with Pigment 
  • Reduce financial preparation to reforecasting time from three weeks with Google Sheets to two days with Pigment by reforecasting faster and more frequently with the scenarios feature
  • Add more granularity in business analysis
  • Enable stakeholders to make better decisions
“From copying and remodeling our P&L to consolidating the data after the setting up of operations in a new country, it used to require weeks of work on Google Sheets. Today, with Pigment, we can run the same process in seconds through multidimensional calculations." 

Tristan Gaste, Financial & BI Analyst at Virtuo

How to leverage Google API to win agility

Virtuo loves the stability and agility of the product. Presenting their numbers with Google Slides, they faced the limits of Google Suite.

Before using Pigment, creating new scenarios to analyze the sensitivity of one particular assumption was very time-consuming. It required them to create a new file and thus a new presentation if they wanted to keep track of both scenarios.

Now, with Pigment connected through an API to Google Sheets (itself connected to Google Slides), there is no longer a need for manual updates. They can create a new scenario on Pigment and reload it to Google Sheets in one click by running the script to update their Google slides presentation.

Implement a business planning platform in four weeks

After just one month of implementation and training, Virtuo has been able to run its entire Budgeting process on Pigment at a granular level.

The FP&A team has enabled C-suite executives to identify the best growth opportunities for the business by deploying Pigment throughout the organization. This is achieved through a dedicated application with key drivers and scenario features that handle complex assumptions and data points.

The C-suite executives also use dedicated applications to evaluate multiple hiring hypotheses related to headcount and staff costs.

“Our Management team uses Pigment to measure the impact of hiring on growth and budget, as well as to make key hiring decisions - optimal time to hire." 

Tristan Gaste, Financial & BI Analyst at Virtuo

As a next step, the FP&A team is revamping their reporting processes. The team aims to empower stakeholders with access to aggregated inputs and dedicated dashboards to drive their decisions.

Virtuo’s top 3 favorite features

  • "Transactions list" is super useful to manage massive historical data. By loading transactions items they're able to quickly map each item to specific properties (month, versions, country, etc.) which allow them to compare past hypotheses and versions of the database
  • "Clone data to" and "What-if scenarios" allow the team to analyze assumptions and identify the best business opportunities
  • "Show value as" percentage of another metric allows leadership to switch from consolidated views to the corresponding ratios in one click, in order to easily understand and monitor the KPIs