Thirty years after its debut, Microsoft Excel is still the preferred tool for budgeting and planning projects. However, its popularity is declining, due in most part to the rise of technology and subscription-based pricing for a myriad of SaaS-based products.
A survey in 2018 identified that the majority (63%) of U.S. organisations still use Excel as their primary budgeting and planning tool but that figure has fallen six points in a year. The report, 2018 Benchmarking the Accounting & Finance Function, a joint effort of Robert Half and the Financial Executives Research Foundation (FERF), shows how Excel is losing its supremacy as the go-to tool of choice for budgeting.
The report leads with an overview of technology trends impacting accounting and finance functions and says “digital transformation continues at warp speed in the world of accounting and finance.” These rapid changes transforming finance departments all over the world can be put down to data analytics, cloud-based computing, and artificial intelligence (AI) all converging to reduce manual processes and make accounting and finance functions more efficient.
Financial leaders now know that the key benefits to digitalizing processes include flexibility, scalability and cost savings. With automated business controls planning projects are not only easier and faster but allow for better control and produce higher quality information, so it’s of little surprise then that more businesses are inspired to search for digital solutions for their budgeting and planning processes, which have always traditionally been a time-consuming and costly exercise.
By observing industry benchmarks, executives can learn how other businesses are using technology and thus update their own processes to keep pace with the changing landscape. Once a business has started digitizing a positive domino effect occurs in many accounting and finance functions. Leveraging of digital technology can create new business models, drive innovation and increase competitive advantage, this makes other teams take notice and search for more automation opportunities.
Excel is still the go-to tool for budgeting and planning, but more finance teams are embracing ERP and cloud-based solutions with similar capabilities, and as a result, fewer firms now identify Excel as their top tool.
Image source - 2018 Benchmarking the Accounting & Finance Function report
The benefits of cloud use in accounting and finance departments now outweigh entrenched reservations about cloud security concerns. Slow, complex and costly legacy systems are being gradually phased out with digital cloud solutions and these solutions are the best option for resource-strapped teams.
The 2018 Benchmarking the Accounting & Finance Function report, reveals that more than half (55 %) of U.S. respondents are using some or only cloud technology in their accounting and finance functions, and 20% plan to do so in the future. Only one-quarter of U.S. financial executives said they have no plans to adopt the technology, down from 28% last year.
Most organisations are still wrestling with multiple spreadsheet environments to address financial and operational reporting. Budgeting, planning and forecasting remain siloed and unconnected across many businesses and reliant again on spreadsheets or legacy systems.
Forward-thinking finance chiefs need to be cautious and thorough in their search for the right technology. First of all, they must define the business case and ensure there are enough resources for it. Define your business needs first, then, get the right technology. Getting the right fit for the business can take time and requires some extensive research. Choosing the wrong solution with the wrong fit for the business could cost be detrimental to the business and swallow a lot of investment.
Image source - 2018 Benchmarking the Accounting & Finance Function report
In your search for budgeting, forecasting and reporting solutions consider the primary market-leading solutions and the ones that can consolidate planning and reporting in a single system.
Mercur Solutions has developed and delivered advanced and high-quality solutions for planning, reporting and analysis for over 40 years. Its’ corporate performance management and business intelligence software can support different technical environments and very diverse requirements for customers across the globe.
One such customer is Hellmann Worldwide Logistics. Mercur has partnered with Hellmann for more than two decades to plan and monitor its performance around the world. As a leading global supplier of logistics services, Hellmann has increasing demands for supporting larger data volumes. Mercur Business Control provides a comprehensive budgeting, reporting and analysis tool to support the companies 600 users across 56 countries.
Mercur Business Control is the main tool for Hellmann’s budgeting, reporting and analysis and it enables a central controlling department to create an accurate picture of the company’s business performance on all levels.
Spreadsheets often start as just a list for storing information and there is minimal process documentation, support or maintenance for these worksheets. Despite the fact that desktop applications such as Microsoft Office are included in the standard configuration of users' PCs, very little formal training is ever given to spreadsheet users.
Budgeting sits at the heart of sound financial management. This is why choosing the right technique is crucial for CFOs – it shapes resource allocation, cost control and strategic agility. Incremental and zero-based budgeting are two leading methods that offer distinct approaches.
Scenario planning gives you a clear, practical way to test assumptions, spot risks and opportunities, and make better strategic choices so your organisation stays resilient when conditions change.
Artificial Intelligence (AI) can support decision making in key areas such as budgeting, capital allocation and even corporate strategy and as a result, it is increasingly being deployed in corporate performance management tools (CPM).
Spreadsheets were never designed for collaboration, yet they are the single most used program among teams and co-workers. They often start out as a quick document for storing, formatting or calculating information but evolve into important documents and are often the core records for an organisation.
Without solid financial planning and analysis (FP&A), businesses operate in the dark. In this post we go deeper into the process of FP&A and why it’s important for businesses.
In today's post we'll break down why KPIs matter, which ones offer the most insight for finance and executive teams and how to ensure they're actually driving results.
Choosing budgeting software is partly a finance and partly a strategic decision. The right tool helps organisations organise planning cycles, adapt as the market changes and increase accountability across departments. But not every platform will be a good fit.
Today's finance leaders steer more than just budgets and reports. The digital transformation ramps up with the increase of corporate complexity, and so does the role of CFOs.
The newest iteration of planning, analysis and reporting systems is a powerful game-changer that unites company departments and boosts competitiveness. It’s called xP&A – the abbreviation of extended financial planning and analysis.
In many organisations manual budgeting processes over-burden staff and create masses of data which overwhelms department heads and stops them seeing the bigger picture.
CPM, or Corporate Performance Management, is a process within corporate management aimed at measuring and optimizing the performance of an organization. CPM encompasses a range of activities, including budgeting, planning, forecasting, reporting, and analysis.
In this post, we explore how AI is evolving from a theoretical concept into a valuable resource for decision-making. Get useful insights for finance teams at any stage, from early exploration to actively using AI-powered solutions.
Financial planning has changed. Traditional annual budgets can’t keep up with rapid shifts in the market, evolving customer needs, and internal performance dynamics. That’s why many finance teams are turning to a rolling forecast model.
Spreadsheets are an essential tool for all types of organisations and businesses rely on them heavily, particularly for financial computations. The most popular spreadsheet program globally is, of course, Microsoft Excel, it’s used by an estimated 750 million people.
Senior executives are demanding more detail in their management reports. The amount of data available to finance departments has exploded and decision makers see this as an opportunity to get more insight into how the business is performing.
If you’re working in a large organization, you’re probably aware of how time-consuming the budget process can be. In this article we’ll give you tips on how to save time and still create a successful budget process
Traditional models of forecasting rely on historical data and beliefs. It uses techniques that identify patterns, which are simple to use. However, with these methods, there are some challenges because they are not dynamic with today’s market, and can’t effectively analyse complex data.
Artificial Intelligence (AI) has significant potential to enhance decision-making for Chief Financial Officers (CFOs) by providing data-driven insights, automating routine tasks, and enabling more accurate forecasts.
A business’s success heavily relies on having a strong strategy. However, what's even more important is implementing that strategy while tracking and measuring the performance. This can easily be done by investing in enterprise performance management (EPM) software.
Planning, budgeting and forecasting are rarely static. Shifts in the industry often require you to revisit assumptions, adjust targets and adopt new processes. Learn how to strengthen your approach and stay ahead of change.
The real challenge today isn’t collecting data, it’s making sense of it and fast. Organisations turn to business intelligence (BI) to convert raw data into insight.But how do you actually do it right?
We know it can be challenging to succeed with your planning, budgeting, and forecasting process. Therefore, we have gathered our best tips for you to succeed!
Struggling to keep plans aligned in a changing market? Discover how EPM helps finance teams move faster, stay accurate and lead with real-time insights.
In today’s fast-paced business environment, effective reports and dashboards are crucial for decision-making. Our user study using eye-tracking technology revealed seven key insights into what captures attention.
Financial forecasting is critical for any business that wants to adapt to change. But finance teams keep usingfragmented models and manual processes. The 3-statement financial model is the solution.
Excel has long been a target for hackers; just one click on a malicious attachment can infect your entire network. So, how can you keep using spreadsheets while not sacrificing your safety?
Where many businesses start small, a simple spreadsheet can adequately perform the limited tasks required of it. As the company grows, your spreadsheets can get more complex and harder to manage, by which point it feels like it will be too difficult to move to a different reporting tool.
Artificial Intelligence and Machine Learning, what is it, and what is the difference?
When done well, budgeting helps organisations stay financially on course, even when things don’t go exactly as planned. Learn how to keep things on track so you avoid surprises and stay focused on your goals.
Traditional budgeting has long been the cornerstone of financial planning in businesses. But today it can become more of a limitation than a strength. That’s where the concept of Beyond Budgeting comes in.
How can you make your budget process more successful and maximise the effort that was invested in creating it? Of course, there are many factors to consider but we’ve chosen to highlight five key areas that will enable and help you create a smoother, value-creating and collaborative budget process.
The ability to process information swiftly is essential. If your business can’t manage your data efficiently, your company’s financial performance will surely underperform. At Mercur we have developed our own database Veloxic which helps Financial Planning and Analysis.
Uncertain times create the need for more frequent forecasts and time for analyzing and comparing different future scenarios. We give you 5 tips on how to simulate future scenarios using scenario planning
Management reporting helps you see what’s really happening in your business. In this guide, we’ll explain what managerial reporting looks like and share practical tips.
Management Reporting refers to the process of creating, analyzing, and presenting information about various aspects of an organization's performance to enable decision-makers to make well-informed decisions about the future.
Explore the top PowerBI alternatives for 2025. Discover how Mercur delivers integrated planning, budgeting and reporting without the high cost and complexity.
This blog explores what IBP is and the typical IBP process. We highlight business benefits and how the right software can be a game-changer for your organisation.
Inaccurate cash flow forecasting can be a costly mistake for companies. In today’s volatile market, relying on static annual budgets or manual spreadsheets leaves financial leaders without the agility to respond to uncertainty.
Many organisations cope with fragmented planning and data quality issues, which slow down their forecasting cycles. This forces organisations to take practical steps to turn ambition into execution.
Budgeting aligns resources with strategic goals, and there are two primary approaches: top-down and bottom-up. Which method wroks best?