CFO Nightmares

CFO Nightmares

Nightmares are expected on Halloween, but they shouldn’t be part of your financial processes. If you’ve ever experienced these common financial nightmares, Planful can help!

Halloween is a time for telling scary stories and watching horror films. The scenes of witches and vampires usually spark some unwelcome nightmares. Luckily, Halloween only comes once a year.

For finance teams, however, the nightmares seem to come every month—right when it’s time to close the books—and then again for quarterly board meeting reports and the annual planning season. Late hours can leave finance teams feeling like zombies with the deluge of spreadsheets and pending deadlines adding to the stress.

Leading up to Halloween, we’ve been posting some of finance’s biggest nightmares, from noticing a broken spreadsheet formula at 2 A.M., to finishing your budget after January 1st, to trying to decipher other people’s spreadsheet models. Those are scary nightmares, for sure, but also the unfortunate reality for many of us in finance.

But it doesn’t have to be that way.

Here’s How Planful Can Banish Your CFO Nightmares Forever

Overloading Excel and being forced to rebuild hours of work due to a freeze or crash is a scary thought. But with Planful’ cloud-based solutions, projections and forecasts are always backed-up and saved – and never susceptible to a crash. Because Excel spreadsheets weren’t built to handle the complexities of an organization-wide financial planning process, they aren’t great at creating connected models across an organization. Simply put, they are the wrong tool for today’s modern and complex financial processes.

Many CFOs fear the discovery of formula errors just hours before a critical meeting. But with Planful’s purpose-built modeling and forecasting solutions, finance teams can ensure calculations are always correct and never unintentionally edited. With Planful’ MyPlan, CFO’s can focus on making strategic business decisions instead of consolidating and deciphering other people’s budgets. Automated alerts and reminders can help budget owners stay on-track and on-task and avoid scary surprises as deadlines approach.

CFO Nightmares not only keep finance specialists up at night but also drag down a company’s performance. A faulty formula or crashed spreadsheet can crush your productivity and, worse yet, can cost the team its credibility with the rest of the organization, just as a missed deadline or a spreadsheet with out-of-sequence rows can impact strategies and decisions.

This can all be easily avoided.

In some ways, the nightmares feel like the cliche horror movies where petrified characters wander into the obviously haunted house, despite moviegoers yelling warning calls at the screen. The movie characters are doomed to meet a ghastly end because they ignored the warning signs.

When to comes to end-of-period financial processes, finance teams may be dooming themselves with the same fate. By continuing to rely on Excel, even after so many frightful moments and close calls, finance teams are sure to know what the outcome will be. The only true savior is good common sense.

This Halloween, put a stake through the spreadsheets and start using Planful’ cloud-based enterprise performance management software to automate and accelerate the planning, reporting, and consolidation processes. By identifying the 5 Signs You Are Abusing Excel and learning how to move to a better, faster, more reliable solution, finance teams can finally stop those financial nightmares and start getting a good night’s sleep again.

Related Posts

CFO Success
Part 2 – Self-Disrupt or Self-Destruct: Keys to Being a Market Disruptor

Organizations may differ in their disruptive approach, but they do share some common traits that enable them to out-innovate their competitors. Learn how to become a market disruptor with Planful....

Read More
CFO Success
The Progressive CFO: Planning for the Future vs Looking at the Past

Find out how effective communications and measuring the lifetime customer value metric are now central to CFO success in podcast interview with Ian Charles....

Read More
CFO Success
The Modern CFO – Mission Possible or Impossible?

A recent article ponders the evolving role of CFOs and whether it's wise to pull them away from mission-critical finance functions....

Read More
National Spreadsheet Day

National Spreadsheet Day

October 17, 2018 is National Spreadsheet Day, a remembrance of the first shipment of the VisiCalc spreadsheet program for the Apple II computer back in 1979.

The milestone is an important one because the spreadsheet has been the one piece of software that has seen consistent widespread adoption by business users over the last four decades. What’s even more amazing in an age of constant upgrades is that the simple formula language and user experience from VisiCalc have remained fundamentally unchanged over the years and has carried over into the modern-day Excel and Google Sheets applications, as well as the robust cloud-based financial planning applications that are widely used today.

For finance professionals today, it’s nearly impossible to imagine what it must have been like to crunch numbers before the days of spreadsheets. Back then, finance teams worked with rigid applications to perform basic functions. And many of those required the assistance of computer programming specialists to perform the most basic of calculations.

Simply said, the ability to autonomously tabulate data and perform calculations has defined the way finance and other business users work today – especially in a world where those processes are fundamental to every budget, plan, and forecast. For example, the ability to utilize standard spreadsheet formula language doesn’t just benefit those who create budget templates. The budget holders also benefit because they’re able to use the same spreadsheet formulas to get a jump start on budget submissions.

Still, the agility and autonomy that spreadsheets have given finance and business professionals have come at a cost.

As part of the business operations, the finance process has clearly-defined roles and responsibilities, approval workflows and requirements around auditing. Yet, the spreadsheet itself has never really evolved to offer support for user roles or approvals. Organizations resort to emailing files around the organization to get approvals, often resulting in version control issues. And data is often loaded into spreadsheets manually from the general ledger, a process that can be both time consuming and prone to user input error.

To address those potential short-falls, Enterprise Performance Management applications were created to ensure that planning, budgeting, and forecasting processes were supported by software, instead of email. Once implemented, many of those applications did a good job of supporting the business process.

The problem was that very few of those applications adopted the spreadsheet formula language and user experience. Rather than simple point-and-click formulas that any finance user could define in a few moments, these specialty applications introduced proprietary scripting languages that were more suited to computer programmers than business people, making finance teams once again dependent on specialists and third parties to perform their core duties.

It’s unclear why these applications went that route but based on our own survey of hundreds of finance professionals, we know that a large majority prefer to use spreadsheet formulas over proprietary scripting languages. Only 19 percent expressed a preference for scripting languages.

We believe that’s because users should be telling computers what they want them to do, not how to do it. The computer can figure out the details while your FP&A staff works on other projects that can benefit the organization.

At Planful, we have adopted the widely used spreadsheet formulas because we believe the spreadsheet formula language is a better way to express the calculations that FP&A professionals need. At the same time, we understand the importance of the business processes – something that spreadsheets alone do not handle – and the need for applications that address that.

As we commemorate National Spreadsheet Day, it’s OK to recognize and point out the limitations of spreadsheets in supporting mission-critical business processes. That’s because we can also celebrate the convenience and familiarity of the formula language and user experience that spreadsheets have given us and continue to provide at the heart of a new generation of cloud-based budgeting, planning, and forecasting applications.

Download our white paper, 5 Signs You’re Abusing Excel for Planning to learn more.

Download White Paper

Related Posts

Office of Finance
Culture and Technology – Top 5 Reasons To Rethink Your Mix

We’re a technology company, obviously. Getting customers excited about our technology and how it can transform finance and evolve their business is something we love to do. In conversations with thousands of organizations over many years, we’ve noticed some clear signs indicating when a finance team needs to first focus their efforts on how their ....

Read More
Office of Finance
Top 5 Career-limiting Mistakes Everyone in Finance Should Avoid

We all make mistakes. But the expectation is that we learn from our mistakes and try to avoid repeating them. Of course, that’s not always the reality. So when mistakes tend to pop up again and again it might be time to seek out some help. For those of us in finance, mistakes can result ....

Read More
Accounting
Why Cash Is Still King

Cash flow reporting is an essential piece for any business. Planful Automated Cash Flow Reporting automates this complex process for you....

Read More