Highway against mountains.

Removing Excel Roadblocks: How to Solve 3 Common Concerns in Financial Planning

You’ve been down this road before. The road where finance relies on Excel to travel into uncharted territory. The road where Excel’s usefulness as a data tool is mistaken for competence in planning and analysis. Plenty of finance departments demand of Excel more than it can handle. They’re simply not aware of its limitations or the alternatives, even though Excel, despite its reliability as a data aggregator, has shown time and again that it is error-prone and fragile as a planning system.

Look at your fuel gauge: Do you spend too much of your day tracking down and cross-checking data? Does your executive team argue over data authenticity or which piece of data is the single source of truth? Are you bogged down in the grunt work of data curation when your company (and your sanity) demands more big-picture analysis? If so, it’s time to embark on a new journey—one that not only affords you the familiarity of, but also complements, Excel. One with a user-friendly planning and analysis system that moves finance into the strategic role every high-performing organization needs.

Hitting the road
How can another system complement Excel? To answer that, let’s hit the road. Whether it’s a short drive to the market or a longer journey cross-country, when planning most trips you’re going to plot a course that avoids roadwork and traffic, sends you on the fastest route possible, and is a seamless experience. To achieve this, you need vision. You need clarity. You need speed. Do you need Excel?

Yes, and more. Excel is an old reliable for navigating local data routes, but take it on a road trip and it starts to show its age. The windows are cloudy, the tires are worn, and the miles per hour max out at 65. Worse, there’s no GPS on the dashboard, let alone built-in. Because your Excel vehicle doesn’t provide a clear view of the road ahead, you have no idea what to expect or whether your old reliable can navigate you through it.

In fact, a customer once shared an analogy with me at a conference. He said that planning in Excel is like driving a car with its headlights in the back; it can help you look back at what happened in the past, but does a poor job of letting you know what is coming up ahead.

Not convinced yet? Here are three key ways relying only on an Excel-based planning system hinders your productivity and profit.

  • Time sink: Excel devours time because it’s error-prone and requires a lot of manual care and feeding. Finance teams end up spending the majority of their hours in spreadsheets, wasting time that could be used for more strategic, high-value work. And if a company wants to scale up or collaborate, the slowness of Excel makes those tasks even more challenging. Tedious ad hoc reporting tasks, manual data aggregation, and hours spent validating formulas and spreadsheet cells leave little or no time for strategic, analytical, and collaborative work. Not surprisingly, CFOs consistently cite “not enough time” among their top challenges in a recent CFO Indicator report.
  • Unreliable data: Because Excel data is often siloed and department-specific, it reduces trust in data across the organization and makes a single source of truth all but impossible. For example, it’s not unusual for larger organizations to have multiple Excel formulas to achieve the same metric. The result: wasted time debating which data and metrics to use instead of discussing how key data and metrics can benefit the business into the future. Excel-based planning thus impedes an organization’s ability to be make quick, data-driven decisions in a fast-changing world.
  • Cloudy view: Excel offers limited and uneven visibility into the business operations and drivers that are central to the success of any organization. As a result, decisions remain gut-based instead of data-driven. At a time when business technology is rapidly changing, Excel simply doesn’t have the horsepower to generate dynamic and integrated insights that can help drive strategy and inform decision-making.

Going places
Now imagine, before your road trip, you upgrade your old-reliable car. Nothing too flashy, but maybe you add some kick, new glass so clear it’s invisible, a built-in GPS that never fails to keep you on track. You’d see roadblocks far enough in advance to avoid them, and you’d zip along to your destination in no time. The trip would be more enjoyable and more productive. You’d still know the car like the back of your hand—it’s still the ride you’ve come to trust—but now it’s also primed for long-distance visioning.

An integrated planning and analytics solution is this upgrade. It’s designed to complement Excel by freeing up valuable time for more strategic activities and deep visibility into your business. By creating a centralized repository that integrates all of your data, it provides a single source of truth that improves integrity and gives you confidence in planning. Now, instead of poring over spreadsheets, you can bring your Excel data to life with dynamic, customizable dashboards. This solution empowers finance to report, analyze, and produce a view of the KPIs in an accelerated and self-service way.  In other words, planning and analytics are no longer separate activities, but are seamlessly integrated. They tell a story the finance team can act on, and inform strategic decision-making that drives business performance.

This is not uncharted territory. Many modern finance teams have added a system that empowers finance to do efficient, long-range visioning, reaping significant benefits along the way. Case in point—one construction firm that integrated Adaptive Insights’ dashboards into its finance operations was able to develop a scenario analysis that determined the company was headed toward costly excess manpower in the final quarter of the year.

Relying on the analysis, the construction firm’s finance team partnered with the CFO to develop an action plan to get new projects in the pipeline for the fourth quarter. The plan worked, resulting in a positive swing of more than $1 million for the company. The finance team says it simply would not have been able to conduct the analysis and solve the problem if it had solely relied on Excel.

If you’re satisfied traversing life via a series of short jaunts to local spots like the coffee shop, the market, and the post office, keeping old-reliable as-is may be the right move for you. But if you want to strike out and see more of the world, adding those extra bells and whistles might be critical. And in today’s landscape, where the only economic certainty is uncertainty, isn’t it crucial for finance to be ready for any of the road’s twists and turns? After all, finance needs to be agile and efficient enough to quickly plan for multiple scenarios. Big data is only growing bigger, and with cloud-based planning tools to complement Excel, finance can now present the right insights to guide decision-making.

Just as cars compete on performance, today’s business competes on analytics. That’s why speeding ahead in this new economy may mean charting a new course for finance that adds to Excel with proven cloud-based planning tools. It’s the kind of upgrade that could very well put you on the road to success.

Sign up for the Adaptive Insights weekly live demo to test-drive this powerful, data-driven technology. 


Written by Maneesh Chhabra, director, value engineering and enterprise marketing, Adaptive Insights

Big Data: Technology Devices Uploading Or Downloading Data Into

The CFO 411: Disruption in the Finance Office

CFOs with a formal accounting background are becoming a rarer breed. Today, leadership and strategic chops trump CPA creds at many companies. That’s because the role of CFO is experiencing a major disruption, new research shows, with finance chiefs being stretched between more operational responsibilities and a more strategic business role. Savvy team building and a firm footing in data analytics are increasingly essential to not just assume the post—but thrive in it. Continue reading

Cfo Letters (or Chief Financial Officer) On The Card Held By A M

The CFO 411: The High Cost of a Failed Plan

Here’s a distinction that no one will be celebrating: There have been nearly $400 billion in failed mergers and acquisitions so far in 2016, making this a banner year in unsuccessful deals. Analysts point to picky regulators, hesitant targets, and the mercurial economy as three factors that have made M&As so troublesome recently. Another notable number that rocked the headlines this week: The Obama administration unveiled new overtime eligibility rules that would raise the pay threshold to $47,476—more than double the current cut-off for workers who are eligible for time-and-a-half pay. Continue reading

Carolee Gearhart, Senior Vice President, International Sales, at Adaptive Live

3 Leadership Lessons from a CRN Woman of the Channel

Being named even once to CRN’s Women of the Channel is no small feat—executives must demonstrate outstanding leadership and vision and play a unique role in driving growth and innovation in the IT channel. But when someone is named four times? Let’s just say the tech world tends to take notice. Carolee Gearhart, our senior vice president of customer success and global channels—and, yes, four-time title holder—has flexed some serious leadership during her career, and most notably since joining Adaptive Insights in 2013. We distilled her wow into three, try-this-now takeaways: Continue reading

Netsuite Suiteworld

700+ Reasons Why We Love SuiteWorld

This week more than 8,000 NetSuite attendees are gathered in San Jose for SuiteWorld 16. If you look around, you’ll see many of the same faces that attended Adaptive Live a few weeks ago. Why? We share more than 700 customer brands with NetSuite due to a relationship that started more than a decade ago.

What’s the secret to our longstanding relationship? NetSuite was among our first customers for Adaptive Planning in 2005. Since those early days, we’ve expanded our customer relationship into an OEM partnership—meaning that NetSuite “white labels” re-skinned Adaptive Insights products within their suite—as well as becoming a NetSuite Certified Partner. But the story doesn’t end there. Continue reading

Shocked and surprised boy on the internet with laptop computer c

Taming the Terror: Friday the 13th Advice for Preventing Excel Horror Stories

If you’re the superstitious or timid type, you might want to stay in bed today.

Why? It is the one and only Friday the 13th of 2016.

For many, this is a day that portends bad luck or, worse yet, visions of hockey-mask-wearing Jason wreaking deadly havoc in any number of ways in the Friday the 13th movie franchise. For finance types, the horror stories typically steer away from the blood and gore and instead focus on the more mundane, but potentially terrifying, number-related errors often spawned by an Excel spreadsheet gone rogue. Continue reading

Human Resources Interview Recruitment Job Concept

CFO 411: Finding the Right Talent—Right Now

The unemployment rate may be holding steady at 5%, but that flat line belies the turbulence many execs are feeling when it comes to recruiting and retaining talented workers. While it gets harder to find the right skilled workers, tenured employees in many areas are complaining of wage compression thanks to rising minimum rates. Many finance executives are getting laser-focused in response, homing in on openings that will buoy the company’s bottom line. Continue reading

Gold Medal On A Blue Background

Hats off to the CFO! Celebrating Finance Leaders Fueling Innovation

Planning is the underpinning of innovation. Having the right resources allocated means no momentum is lost during crucial moments. Taking the financial long view means no leap to a new market or a new product line sputters out, unsupported. It’s no surprise, then, that the finalists for the 11th Annual 2016 Bay Area CFO of the Year Award have a seat at the executive table of innovation powerhouses.

Adaptive Insights applauds all finance leaders using sophisticated tools and a strategic mindset to move companies forward. And we’d like to raise a glass to those San Francisco Bay Area finalists who are also part of the Adaptive Insights family—which turns out to be a staggering 40 percent of this year’s list. Here’s a glimpse at some of the other accolades and successes these customers can celebrate. Continue reading

General Rochambeau Statue Lafayette Park Autumn Washington Dc

Five Ways FP&A is Fueling the Finance Revolution

On this day—May 10—way back in 1773, the British Parliament passed the Tea Act, which taxed all tea in the U.S. colonies and ultimately sparked the American Revolution.

At Adaptive Insights, we can relate. We like to think that we are playing a key role in another, modern-day, global revolution—the Finance Revolution that is transforming the way financial planning & analysis (FP&A) and its partners do business. Adaptive Insights users are increasingly shifting from back-office tactical support roles to essential strategic partners, positioning organizations to be more nimble, competitive, and successful.

While we provide the tools, technology, and ongoing support in this insurgency, it is really our customers who are on the front lines of this dramatic movement toward operating more strategically, and with greater efficiency and accuracy. Continue reading

Chief Financial Officer - CFO - 3 wooden dice containing the letters CFO with charts on the background.

The CFO 411: Which Metrics Matter? Depends on Who You Ask

In the constant push and pull between what shareholders and activist investors want to know and what a company wants to disclose, an esoteric financial metric—return on invested capital—is gaining an odd amount of attention. At the same time, the Securities and Exchange Commission is putting novel earning measures under the microscope. Maneuvers that are outside of generally accepted accounting principles (GAAP) may paint a rosy picture for investors, but they’ll also garner more attention—and possible fines—from the commission. Continue reading