Small team, big results: How this global tech company levelled up their FP&A

See how a global tech company moved from manual Excel to Workday Adaptive Planning with QMetrix to automate reporting and scale FP&A.

A blue cursor icon overlapping a yellow circle above the text “Global technology company”

This global technology company empowers working teams to drive improvements. Their mobile-first operations platform gives teams the knowledge, tools, and processes they need to work safely and meet higher standards. Their platform is used in 180+ countries by 85,000 organisations, with 1 billion checks completed per year.

man-at-desk-laptop-smiling

The Company’s finance team consists of three people who were tasked with setting up a new process across the company. At that time, they were using Excel spreadsheets for budgeting and planning. Processes were lengthy, manual and cumbersome, and for a rapidly growing business, it was not scalable.

The team decided to explore options and compared several Financial Planning and Analysis (FP&A) tools.

They eventually chose Workday Adaptive Planning, with one of the key reasons being the out-of-the-box features it had. This would enable their small team to kick-start things more easily.

Working with QMetrix as implementation partner, one of the first things was to set up Workday Adaptive Planning to ingest NetSuite data and bring allocations in.

The team considered how to engage the different departments in the process and build it in a way that it would be scalable. Now, it is easy to upload any information into Adaptive Planning as required.

Over time, there have been software changes in other departments, and the team have been able to map it to Adaptive Planning with no issues.

From Excel headaches to easy reports

With many different arms of the business, from software to hardware, and marketplace to insurance, there are many budget owners at the Company.

They used to do monthly week-by-week forecasts. It was a repeated cycle of “click, crash, merge, unmerge” in Excel – and this was even before they could get to the stage of reforecasting or getting actuals to the GL level. There was a lot of volume to get through and they also had to group many expenses together – it was “a headache”, as they describe it.

Now, with Adaptive Planning, it is easier for budget owners to access the data. Report layouts are customised so they can see the current month’s budget, the variance, the difference to last month’s forecast, and also have a view of their whole Financial Year by month, budget, new forecast, and actuals. They can easily visualise how the actuals are tracking to forecast spend, and it keeps them accountable.

During weekly executive meetings where costs are discussed, people are now across what they have spent. There is no longer a black hole where people say, “I’m not sure what was in this cost”. Instead, they can easily drill-through to specific transactions, provide confident answers, and have meaningful discussions.

The finance team also report financials to investors and other stakeholders.

A blue cursor icon overlapping a yellow circle above the text “Global technology company”

Trusting the data and going deeper into the details

With Workday Adaptive Planning, the Company has been able to get more granular in terms of variance analysis. Instead of grouping items into big buckets in Excel, they can now slice and dice in several ways, and discuss what is truly driving variances.

For example, when it comes to travel, they can break it down by flights, accommodation and meals. It also saves them having to validate the totals match on every rolling spreadsheet, for every subsidiary and region.

Their FP&A Analyst says, “There are so many checks you can build in Excel, but it’s not possible for a team of three to be running all these checks every month end. With Adaptive Planning, we don’t have to worry about the accuracy of the numbers. There is a lot more trust in the data, and this has also freed up our time to do analysis”.

Building on a solid foundation, to now managing things in-house

One of the key criteria when selecting a Financial Planning and Analysis tool was that it needed to be easy to use and managed in-house eventually. Workday Adaptive Planning met this criteria.

A fundamental aspect in QMetrix’s implementation methodology is to use best practice and share knowledge during the project, so finance teams can manage the solution themselves moving forward, should they choose to.

Their FP&A Manager says, “None of our team had used Adaptive Planning before, but the way QMetrix set it up provided a solid foundation. The sheets and levels were done as we needed, and also allowed us to play around and build on it”.

“They also provided knowledge transfer and training materials which helped us especially at the beginning so we knew what to look for to achieve what we wanted.”

The Company continued on a support plan with QMetrix for a short while after the initial implementation project, and now they run things on their own completely.

“There is so much you can do with Adaptive Planning. The platform is evolving even as we speak. Their out-of-the-box features do well in getting the basics in place. It’s easy enough to learn things like putting in different accounts and values that need to be forecasted. From there, it depends on how far you want to take it. For our team, we like to learn on the go and experiment a lot. Now, we’re taking things to the next level, like figuring out how to scale things and introduce automation,” says their FP&A Manager.

A blue cursor icon overlapping a yellow circle above the text “Global technology company”
  • Greater visibility and accountability across the business as budget owners can access real-time, detailed financial insights
  • Teams can drill into cost drivers and uncover true reasons behind variances, enabling more informed discussions
  • Significant time savings and scalability for finance, due to seamless integration and automated processes
  • Improved data accuracy and trust as automation has reduced manual checks and errors – this frees up time for value-adding analysis
  • Finance owns the tool and does not rely on external support – they now manage Workday Adaptive Planning in-house completely
Faith Luo

Faith Luo

B.A (Comm & Soc), Dip.Vis.Comm

CONNECT