• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

FP&A

FP&A Done Right: The Value of Scenario Planning

September 17, 2021 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, highlighting the value of scenario planning in modern finance.

Considering all that’s happened over the last year, the case for robust scenario planning has rarely been stronger. Scenario planning—the practice of establishing strategies for variables (possible futures) in key business factors—helps organizations thrive amid uncertainty. To put it simply, scenario planning arms finance with the ability to incorporate responses as changes happen.

Without the ability to adjust revenue and expense assumptions over time, model multiple scenarios simultaneously, or see the impacts of new markets, staffing changes, or regulations, companies won’t have the ability to weather whatever comes next—much less respond to changes in real time.

In a recent webinar by the Association for Financial Professionals, two panelists explored the value of scenario planning and management in modern finance.

“COVID-19 has been described as being the great accelerator and really has forced all of us to do some sort of scenario or contingency planning over the last year,” said Jack Alexander, a former CFO turned adviser, author, and coach. “And my hope is that finance and operating executives will utilize scenario planning broadly in the future and integrate those more into the key planning and management activities.”

Alexander described working with a client pre-pandemic that was facing two major uncertainties. “In this case, the company was unsure whether the economy would continue to expand or contract, and they also had a significant contract that was up for recompete. So they had basically four possible scenarios on a two-by-two matrix combining those two uncertainties,” he said. “And then I also encourage the development of a black swan scenario too—low-probability, high-impact events—and that sort of covers things including what happened with COVID.”

Kinnari Desai, vice president and head of corporate finance at Workday, described a multistep process for accelerating the scenario planning process.

Align leaders’ top priorities

First, organizations need to identify their top two or three priorities. “This could be top-line growth, margins, or cash flow, but it’s very important to be clear on those upfront,” Desai said. “We get perspectives from our executive team and align with them on what is important.”

It’s also critical to understand what is top of mind for business leaders, whether they’re in sales, services, G&A, technology, or other departments. “We need to ensure we have scenarios that are relevant cross-functionally and not only within finance,” she said. “This really helps us incorporate multiple perspectives and inputs into what is important, and we know where that knowledge belongs.”

Alexander echoed Desai’s process of speaking to the C-suite to understand competitive threats, market forces, and developing factors, as well as key personnel who have a view of such areas as critical raw materials and supply chains. “So it really has to be a broad participation across all functions,” he said.

Identify key drivers of sustained value creation

Another key step is to perform analyses to pinpoint the relevance of important factors and focus on the ones that matter. “How much could they influence the outcome? We also get an understanding of which variables and outcomes can be controlled in a short timespan versus ones that will take longer to pivot,” Desai said. “We do not try to optimize every variable but just focus on the ones that matter incrementally, and then we bring them all together in our scenarios.”

Bring in external data where relevant

Finance should develop a perspective that is informed by outside data. “It could be from industry, our peers, customers, economic data,” Desai said. “And at Workday, we use our software called Workday Prism Analytics, and that helps us marry this external data to our internal data, which informs our scenarios.”

Evaluate the frequency of scenario planning and adjust accordingly

“Not all variables, as we know, change on a similar cadence. Some need weekly attention, some monthly, or some even daily,” she said. “And our finance organization combines this power of scenario planning and continuous planning, which allows us to move in an agile fashion.”

Desai added that while there are many variables that impact the business, not all of them have a material impact. For her team, the top six variables garnered most of their attention. “And then we spent all our time understanding how they were going to shift,” she said. “Now, no one has a crystal ball, but the best we could do was to determine how those six variables would move. And those were the big rocks for us that were going to change our outcomes, not the 15 others.”

Three elements to enable agility

Alexander’s approach emphasizes three elements: vision, recognition, and response—all of which are aided by scenario planning and lead to better business agility.

“Even in terms of the vision, it helps because you’re going to be identifying critical assumptions, and you’re going to consider alternative outcomes other than the primary plan,” he said. “And if you combine that with business intelligence, external outlooks, a focus on customers and competitors, that really helps.”

As a year of uncertainty has shown, organizations better able to adapt to rapidly changing environments are often more optimally positioned to withstand crises or uncertainty. In order to build organizational resiliency, scenario planning performed correctly can help the enterprise identify its key business factors, take into account critical cross-functional needs, and create the agility necessary not only to survive, but to succeed.

This blog post was originally published on the Workday Adaptive Planning blog.

Home » FP&A » Page 2

Filed Under: FP&A Done Right Tagged With: enterprise performance management, Financial Performance Management, FP&A, FP&A done right, FP&A leadership, modern finance, what-if analysis

FP&A Done Right: Overcoming Obstacles to Collaboration in the Office of Finance

August 6, 2021 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, highlighting how to better improve collaboration in the Office of Finance.

As the role of CFO continues to become more strategic and collaborative, CFOs are expecting their teams to follow suit. As such, many finance leaders are requiring their teams to broaden their understanding of other functions and pushing them to communicate and collaborate more effectively, both internally and externally. According to our studies, collaborative work now consumes a significant portion of the finance team’s week.

The limitations of legacy tech

One of the primary obstacles to better collaboration is outdated technology. With many finance departments still relying on email and spreadsheets to drive their reporting process, collaboration is a time-consuming, frustrating task.

Think about this common scenario: A report identifies a variance and is emailed out to multiple stakeholders for review. This triggers a massive email chain of variance queries, change requests, and edits. Soon you have multiple versions of the spreadsheet existing on different computers. Which one is the right one? And if it’s not saved on the server, who can access it?

Of course, the other issue is accuracy. How does anyone know whether the numbers in the spreadsheet are correct in the first place? Manual-driven processes are susceptible to errors like entering data in the wrong cell, messing up a formula, or adding an extra digit by mistake. As stakeholders copy and paste information into spreadsheets and email them along, you lose the ability to easily track who is entering data or verify where that data originally came from.

The role of nonfinance managers in financial reporting

When some finance departments talk about collaboration, they think about ways of making it easier to collaborate within the department. While that’s important, true collaboration means making it just as easy for nonfinance managers to be able to access and make changes to a report.

Going back to spreadsheets, often the finance department works to get the report perfect before sending it off to an operational manager for review. If the operational manager adds a last-minute update, it can require a massive amount of work to incorporate, review, and verify.

While accurate data is obviously the top priority, something else to consider when collaborating with nonfinance managers is data visualization. Even after you have all the numbers together in a report, a spreadsheet can be difficult to interpret and understand. A report is only as good as the action your team can take from it; to improve collaboration, you must improve both access and understanding of the data.

The 3 steps to making reporting collaborative

If you wish to make your reporting a more collaborative process, here are three keys to keep in mind:

Step 1. Access
Instead of static spreadsheets and email, it’s critical to move your reporting process to the cloud using smart financial reporting software like Workday Adaptive Planning. Because it’s accessible through the web, all your stakeholders can work from the same set of numbers at the same time without confusion or delay. And since you can control and track at the user level who has access and who enters data, you can greatly increase transparency and accountability throughout the reporting process.

Step 2. Ownership
In addition, Workday Adaptive Planning can automatically import data from both your financial and nonfinancial systems. This not only saves time and reduces errors, but it also takes all your data out of departmental silos and brings it together to give your entire company a single source of truth to work from.

Step 3. Understanding
Once you’ve automated data collection, you can focus on delivering insights. Workday Adaptive Planning lets you easily distribute board reports, slice and dice management and financial reports for specific departments, and drill down into the details. Because it’s connected to all your systems, you can also easily create real-time, visually appealing dashboards that give nonfinancial managers instant insight into their department’s performance.

Collaboration is integral to today’s finance initiatives

The marriage of traditional accounting and analytic skills with interpersonal communication and collaboration skills reflects the changing face of today’s finance team and leaders. Data alone is not valuable to today’s organizations. But the ability to aggregate, align, and interpret company-wide data that guides corporate performance continues to separate the traditional from the modern CFO.

This blog post was originally published on the Workday Adaptive Planning blog.

Home » FP&A » Page 2

Filed Under: FP&A Done Right Tagged With: collaboration + finance, enterprise performance management, enterprise planning, Financial Performance Management, FP&A, FP&A done right, Office of Finance

IBM Planning Analytics Tips & Tricks: Depreciation

July 27, 2021 by Lee Lazarow Leave a Comment

P&L planning models consist of a variety of inputs, including revenue planning and various forms of expense planning.  In addition to these standards, we are often asked to develop other planning components. One of these components entails a depreciation process, which leads to the question: what is depreciation?

Depreciation is defined as “a reduction in the value of an asset due to wear and tear or obsolescence.” In business terms, this typically entails a calculation to determine your current asset’s value. 

There are various methods to calculate depreciation, all of which are taught in an Accounting 101 class. Most organizations, however, use a simple approach called “straight line” that spreads the reduction evenly over the course of a pre-defined asset life.

There are typically four components to a depreciation process:

  • Asset value – the original cost of the asset
  • Asset life – how long will it take for the asset to stop reducing its value
  • Salvage value – the amount you expect the asset to be worth at the end of the asset’s life (e.g., a resale value)
  • In service date – the time that you begin depreciating the asset, which is not always the same time as the purchase date

The calculation is relatively simple: subtract the salvage value from the asset value to determine the amount to be depreciated, then divide that amount by the asset life. Remember to ensure that the asset life uses the same level of time periods as your model … months, quarters, or years.

Once the depreciation calculation is performed you can easily view the original asset amount, the total allocated amount, and the current asset value. Want to learn more about depreciation details or recommended best practices? Contact us and we’ll help you.

IBM Planning Analytics, powered by TM1, is full of new features and functionality. Need advice? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. We post new Planning Analytics Tips & Tricks weekly in our Knowledge Center and in newsletters.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Scatter Chart vs Bubble Chart

IBM Planning Analytics Tips & Tricks: The Waterfall Chart

IBM Planning Analytics Tips & Tricks: 445

Home » FP&A » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Cognos TM1, depreciation, enterprise performance management, enterprise planning, Financial Performance Management, FP&A, IBM Planning Analytics, TM1

FP&A Done Right: 3 Strategic Skills for FP&A Leaders

July 9, 2021 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, recommending strategic skills for FP&A leaders.

You stay late to meet your deadlines. You triple-check your reports to keep them error-free. You turn around one-off requests at the drop of a dime.

But you still haven’t gotten that big promotion.

That may mean there’s a disconnect between the work you’re doing and the work your boss would like you to do. Research from Robert Half Management Resources has found that finance leaders want FP&A professionals who can look beyond the bottom line to see the big picture. A study found that 86% of CFOs said strategic thinking abilities are important for accounting and finance professionals, with 30% of those reporting that these skills are now mandatory.

And this demand is only expected to increase. In one popular Workday Adaptive Planning survey, CFOs predicted that the time spent by the FP&A team on strategic tasks will double—to as much as 50%.

To show that you’re ready to take on more strategic responsibilities, start by demonstrating that you can make smart decisions. Developing these three skills will help you highlight your potential—and get picked for the next promotion.

1. Study Every Angle

Strategic thinkers plan by identifying several potential paths forward and weighing their likely outcomes against each other. And according to another survey of ours, 48% of CFOs said that, during a market contraction, finance teams provide the most strategic value by planning for multiple scenarios.

That means FP&A professionals who can identify, model and analyze how different factors could impact the company are more likely to stand out as problem solvers. The right software can help you quickly create projections based on potential risks and opportunities on the horizon—and identify actions that could help your company meet its strategic goals. This type of proactive planning can give you the ammo you need to make well-informed recommendations when it’s time for your boss to make the next big decision.

2. Create Compelling Visuals

When making a presentation to your CFO or board, don’t make your numbers do all the talking. Data is an integral part of the conversation, but it doesn’t tell the whole story. Leaders need you to explain what metrics really mean.

Data visualization can help you cut through the clutter and deliver comprehensive, easy-to-digest analysis. And this is exactly the kind of presentation executive teams crave. According to published reports, 31% of CFOs indicated that improving visualization skills would help FP&A teams represent data more effectively.

Learning how to create visuals that explain variances, period-over-period performance and sales projections will help you deliver the wow factor that will put you in the leadership pipeline.

3. Build Bridges

Sometimes, sitting down with people from other departments is all you need to gain a fresh perspective or uncover a new approach to a common problem. And this type of collaboration is what execs are looking for from their finance team.

According to an off-cited EY report, when CFOs were asked about their top goals for the finance function over the next five years, 95% listed improving business partnering with other units as either critical (58%) or a significant priority (37%)—making it by far the most popular priority.

But collaboration doesn’t have to happen around a table, looking atspreadsheets and a whiteboard. If the company’s data exists in a centralized repository, collaboration can happen virtually. Different teams can drag and drop figures into sharable reports that others can comment on in real time, making it easier to get leaders the fast feedback they need to make more informed decisions.

FP&A needs to put itself in the business leaders’ shoes. Anticipate their needs, and creatively look for ways to add value by providing insights and unique perspectives, improving the efficiency of key activities and introducing frameworks, models and structure to enable these business leaders to better plan, manage and run their operational areas.

Grow next-gen FP&A skills

Modern finance teams are more than number crunchers; they’re key partners in support of a company’s strategic vision. But not every new hire (or, frankly, finance team member) is going to have strong strategic acumen from the start. That’s OK, as long as CFOs and finance leaders are willing to nurture those skills with hands-on coaching.

It’s one thing to hire someone and then give them a list of functions they’re responsible for. It’s another to really check in on them, give them guidance, help them avoid certain potholes, and really help them bridge any gaps. Starting early with leadership training, having team members give presentations to strengthen their communication skills, and emphasizing one-on-one coaching sessions over classroom trainings can all be effective ways to build up skills that stretch beyond classic FP&A duties.

Above we presented the top 3 skills that will help you highlight your potential. In closing, we present the top 8 skills needed in FP&A teams, according to a leading publication for finance professionals:

1. Strategic and critical thinking

Automation technology frees you from the manual work and allows you to have more time to think about data critically and strategically.

2. Communication

To be successful, an FP&A professional needs to ask questions, listen objectively to various viewpoints, consider the information at their disposal, and respond appropriately to various stakeholders across multiple communication channels.

3. Tech Savvy Data analytics

New technologies can benefit your organization in various ways. To recognize them, you need to develop an enthusiasm for new technological advances and intellectual curiosity about what’s coming next. Being a tech savvy finance professional gives you a competitive advantage.

4. Technical accounting and finance skills

Undoubtedly, FP&A professionals must be skilled in their areas of expertise. You need to continue working on your education by learning new aspects of the professional.

5. Innovation

Automation will require finance professionals to be innovative and creative when it comes to solving business problems. This is one of the ways to contribute value to your organization.

6. Anticipating and serving evolving needs

Modern FP&A is not only about mastering skills in data analysis. You will need to recognize emerging requirements around you.

7. Leadership

Finance does not work exclusively with numbers. If you have emotional and cross-cultural intelligence and empathy, it will be easier for you to understand the needs of those around you. There comes a time when finance must be the reassuring voice and visionary.

8. Collaboration

Cross-functional collaboration is playing a major part in the overall success of your organization. FP&A professionals need to learn how to work with colleagues who have other skills. Their expertise and specialties can help finance develop the big-picture ideas. It is also important to keep working on your virtual collaboration and management skills.

This blog post was originally published on the Workday Adaptive Planning blog.

Home » FP&A » Page 2

Filed Under: FP&A Done Right Tagged With: enterprise planning, FP&A, FP&A done right, FP&A leadership, FP&A skills, modern finance

FP&A Done Right: Volatile Business Conditions Require Agile Planning

June 4, 2021 by Revelwood Leave a Comment

FP&A Done Right: Collaborate More When Planning

This is a guest blog post from our partner Workday Adaptive Planning, explaining how to lay the groundwork for business agility.

Manual, spreadsheet-based planning may have worked well enough in a more predictable age. But today? Not so much. Volatile conditions demand a smarter approach to financial planning and analysis (FP&A), and more and more finance professionals are discovering that legacy planning processes don’t let you go there.

It’s not that spreadsheets aren’t great—we love them. But, let’s face it, spreadsheets break down if you’re trying to rely on them systematically to gather data from across the organization, roll up departmental plans, or do complex, collaborative planning.

Even traditional market forces have proven challenging to companies relying on old-world technologies and approaches. Technological advances, ever-increasing customer expectations, and smarter, data-driven decision-making put pressure on finance teams to find new ways to operate with agility.

But how do you plan in a way that allows you to respond to such events, from the predictable to the unlikely?

The answer begins—and ends—with a modern approach to planning.

Why old-world planning is a disadvantage

The traditional planning models finance teams relied on for decades aren’t just a questionable choice in times of disruption—they can leave your business at a grave disadvantage. Businesses hampered by outdated planning processes are often left scrambling to react to changes while more agile competitors outpace, outperform, and outmaneuver them. Look around you: The companies that are performing well at this minute have pivoted—sometimes substantially—in a matter of weeks, sometimes days. Their business agility has become their defining attribute for success.

It’s safe to conclude that many of these agile businesses aren’t weighed down by manual, episodic, and siloed planning. Rather, they’ve likely embraced a more modern approach to planning—planning that’s collaborative, comprehensive, and continuous. These businesses consistently minimize risk, maximize performance, and create competitive advantages because their planning empowers greater business agility.

The difference between static and modern planning can be stark. Legacy planning tools are typically bogged down by versioning headaches and siloed, instantly perishable data. In contrast, modern, strategic planning models allow teams to broaden planning data beyond finance, pulling in real-time operational and transactional data fromERP,HCM, and other slices of the enterprise stack—all to make better, data-driven decisions quickly.

Laying the groundwork for business agility

As many companies recognized even before the current crisis, agility is a business imperative—and this more modern approach to planning is the key to achieving it. These three milestones will get you started on your journey to achieving a new way to plan.

1. Assess the status quo

Before you map out where you’re going, you need to understand where you are. Take inventory of the current state of your company, more specifically the business planning obstacles keeping you from implementing a more modern and streamlined planning environment. More than likely, these obstacles will pertain to people, processes, or technology, or some combination thereof.

Assessing where you are means getting granular.

  • What do your current business planning processes look like?
  • How long does it take you to create a budget? A forecast? An annual plan?
  • Where are opportunities for improvement?
  • Who are your planning stakeholders?
  • What technology do you have in place, and how well is it serving you?
  • What data challenges need attention?
  • What are the bottlenecks?
  • What could be automated that isn’t?
  • Are there any opportunities for automated data integration?
  • What are you lacking in workforce planning?

Answering questions like these will help you get a clear sense of what you’re working with and where you can improve.

2. Get organizational alignment

Being a change agent is no easy task. That’s why you’ll need to recruit a savvy senior-level advocate to help champion planning as a worthy and necessary cause. Along with your senior advisor, you’ll need a task force representative of other departments outside of finance, including operations, sales, and HR. Don’t forget to include IT to help you navigate technology needs and coordinate various data sources.

The next move is to align these key people with the business agility cause you’re championing.

How? Build a business case.

You can do this by quantifying the impact that the organization’s current status quo has on the company. What are manual processes and bottlenecks costing your business in time and money? What opportunities are passing you by? Conversely, what would those measurement strategies and KPI models look like if you implemented a modern, or active planning model? Try to unearth more nuanced ROI measures—for instance, how cutting budget time in half could give your people more time to run critical what-if scenarios—to really drive home the meaningful change that a modern agility planning model would bring.

Once your team is in place and your pain points recognized and quantified, you can map out a plan for your initial project. Consider focusing your initial effort on a function within finance so you’ll have control over the rollout. Develop a multi-phased plan that clearly communicates goals, a concise and actionable plan, and the key metrics for your KPI model. The ability to effectively communicate the why behind this initiative will help secure any executive buy-in you need for the how. A comprehensive and well-thought-out plan will go a long way toward achieving that.

3. Expand across the business

As noted above, there’s a strong case for beginning the rollout of your new planning model in finance and focusing on low-hanging fruit to bring early and easy wins. You’re motoring along, mapping projects, tracking and communicating progress, analyzing KPI reports, and making necessary tweaks. Once a rhythm and familiarity are in place, broaden your scope beyond finance. Initiate planning projects that engage HR, sales, or marketing. This is where you begin to extend the use and impact of modern, company-wide planning.

The key in this phase is to strengthen cross-departmental communication and collaboration. Don’t fall into the trap of relying on your technology or tools to do the heavy lifting. It will be easier to realize and maintain success with regular stakeholder one-on-ones, identifying lessons learned along the way, uncovering opportunities for more ingenuity and improvement, and communicating success and congratulations when they’re warranted.

Doing this will help elevate the role of finance to a strategic force within your organization by orchestrating planning throughout the business. Finance will no longer be known primarily for gathering budget numbers and issuing reports. Instead, your business will look to finance to drive the change and innovation needed to not only weather times of uncertainty, but to thrive in them.

These three pillars lay the groundwork for creating a more agile planning environment—one that will help you plan for what’s coming, whatever that may be. With this foundation and the insights we’ll share in subsequent blogs, you’ll be much better equipped to map your way forward into that tomorrow.

The bottom line

It’s never been easier to define the main driver of business success. It comes down to how fast your business can identify and proactively respond to change. But if your business is mired in static planning —characterized by long planning cycles, immediately obsolete plans, siloed efforts, and hard-to-find errors—it won’t be operating with maximum speed or agility.

This is doubly true in today’s fast-paced, data-driven world. Businesses hampered by outdated planning processes are often left scrambling to react to changes while more agile competitors outpace, outperform, and outmaneuver them.

Wherever you are on your planning maturity journey, the tasks here will help you expand and accelerate business agility by:

  • Creating a new kind of planning mechanism that’s distributed, inclusive, and optimized for your strategic objectives.
  • Empowering finance to continuously deliver insights that help the business course-correct. To power better, faster decision-making in ever-shorter cycles based on rolling forecasts and real-time (and eventually, predictive) data.

The truth is, building a continuous one-to-one alignment between your strategic vision and your operational reality isn’t easy. It’s something very few businesses can claim. You won’t get there overnight and you will face hurdles.

But it only takes a few small steps in the right direction before momentum starts to build. Before long, those steps will amount to a giant leap forward and significant competitive advantage as business agility accelerates exponentially.

This blog post was originally published on the Workday Adaptive Planning blog.

Home » FP&A » Page 2

Filed Under: FP&A Done Right Tagged With: agile planning, business agility, FP&A, FP&A done right, modern FP&A, Rolling Forecasts, Workday Adaptive Planning

FP&A Done Right: 5 Ways Dashboards Empower The Office of Finance

April 23, 2021 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, exploring how to unlock hidden opportunities with dashboards & analytics.

Visualizing data is often the fastest way to identify trends and patterns that lead to insights and better decision making. That’s because the simple clarity of visualizing data via interactive dashboards can reveal hidden opportunities that likely would have been missed in more traditional analysis and sharing of data.

Here are five ways dashboards can help identify valuable insights that may have been overlooked in the past.

1. Dashboards encourage company-wide planning (or xP&A)

Simply making dashboards accessible to stakeholders throughout the organization represents a huge win in itself—and a significant step toward breaking down silos. Yet beyond that, increasing the number of people who have access to data presented in digestible formats exponentially increases the chances of those aha moments occurring. The production floor manager will surely have a different perspective than the CFO. When that perspective is informed with accessible data delivered via a dashboard, the stage is set for new efficiencies and improved productivity.

2. Dashboards show instead of tell

There’s a reason the phrases “go through the numbers” and “eyes glaze over” are often uttered in the same sentence. Traditionally, delivering financial information has largely been a one-way conversation with the finance team presenting mundane reports and data downloads. With the exception of the number crunchers in finance and accounting, many business partners get lost or disinterested when presented with a number or data overload. Dashboards avoid this challenge by elevating the data to the next level and using graphics and visualizations to clearly show data in formats that provide key context and clarity. When data gets presented in highly visual and familiar formats, business users can often quickly see challenges and opportunities that otherwise might have been missed.

3. Dashboards offer customized views for different thinkers

Different people consume information in a wide range of ways. Some may be more comfortable viewing data presented in standard bar, column, gauge, area, and doughnut charts. Yet others benefit from data presented in more engaging or interactive formats. Workday Adaptive Planning dashboards feature data visualization that includes funnels, dials, waterfalls, bubbles, histograms, radars, and Pareto charts. Users across locations and on any device can view data in the formats that connect with their unique way of learning and thinking.

4. Dashboards are ever-present

Even finance pros and business leaders who are adept at extracting insights from traditional reporting face the challenge of locating reports once they are filed away. And once people find the report, they have the time-consuming process of checking if the data is still accurate. Conversely, dashboards are continuously available via a wide range of devices with data updated in real time, assuring users that they are working with the latest available information. So if conditions change or a new opportunity arises, easy-to-access data visualization is there to support decision-making and reveal how an opportunity may be quickly leveraged.

5. Dashboards are inviting and simple to use

The simple power of dashboards is that they are easy to use and invite users to experiment, explore, and discover. By eliminating the complexity barrier, the odds of uncovering hidden opportunities expand dramatically. Ultimately, dashboards create the opportunity for self-service analysis for everyone. That allows any user to perform drilldown analytics, create period-to-period comparisons, and explore iterative what-if analyses that can effectively identify issues that need immediate attention while also identifying trends that could be leveraged through sales and targeted marketing efforts.

This blog post was originally published on the Workday Adaptive Planning blog.

Home » FP&A » Page 2

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Adaptive Planning, dashboards, FP&A, FP&A done right, Workday Adaptive Planning, xP&A

IBM Planning Analytics Tips & Tricks: MS Word AutoCorrect

March 30, 2021 by Lee Lazarow Leave a Comment

Tips & Tricks

Part of implementing IBM Planning Analytics is ensuring that users understand their model. This often entails documentation that is created as a Microsoft Word document. Most of us know how to use Word but get frustrated typing some of the complex OLAP terms that are required to explain the model. Did you know that Word has a feature which allows you to solve this?

The AutoCorrect feature in Word allows you to define an abbreviation which is replace when you complete a word. This is defined by going into the Word options and selecting Proofing, AutoCorrect Options.

IBM Planning Analytics Tips & Tricks: MS Word Auto Correct

In addition to the list of predefined abbreviations that Microsoft has set up, I use this for the following list of words:

Abbreviation   Full Phrase

consol              consolidation

consols            consolidations

dim                  dimension

dims                dimensions

hier                  hierarchy

hiers                hierarchies

scen                 scenario

I also use this to quickly set up arrows and bullets:

—                      → (an arrow)

*                      •   (a bullet point)

This approach will help you create documents, both notes and formal manuals, faster and easier vs. having to stop and correct the complicated words that arise in our OLAP world.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Learn the Excel CELL Formula

IBM Planning Analytics Tips & Tricks: Manipulating Text in Excel

IBM Planning Analytics Tips & Tricks: Excel Keyboard Navigation

Home » FP&A » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks, Uncategorized Tagged With: enterprise performance management, Financial Performance Management, FP&A, IBM Cognos TM1, IBM Planning Analytics, MS word autocorrect, Planning Analytics tips, Planning Analytics Tips & Tricks, TM1

FP&A Done Right: Collaborate More When Planning

March 12, 2021 by Revelwood Leave a Comment

FP&A Done Right: Collaborate More When Planning

This is a guest blog post from our partner Workday Adaptive Planning, recommending how to get other departments to collaborate with the Office of Finance.  

When it comes to business, collaboration is vital. After all, no single department can do its job for long without the other departments pulling their own weight. Sales is no good if shipping can’t deliver; marketing falls flat if customer service keeps alienating users; everything grinds to a halt if human resources doesn’t provide the appropriate staffing.

But for some reason, when it comes to the numbers, it can feel like every department is on its own. Data is often stuck in silos, making it difficult or even impossible for other departments to get the information they need to do their jobs well.

Nowhere is this more evident than in the department that makes numbers its business: finance.

But achieving a collaborative finance function can be difficult. That’s because FP&A often lacks the necessary time, direction, or clarity around KPIs to build the cross-functional relationships required to improve forecasting and reporting. So what should be a team effort becomes a finance exercise, and when numbers change, it becomes finance’s fault. In the end, we lose credibility as a business partner.

Make Your Data Everyone’s Data

So how do you get other departments to collaborate with finance? Start by empowering your business partners with more ownership and accountability in the data and your process. For example, many businesses still do most of their forecasting and planning with spreadsheets. Not only is this wildly inefficient (not to mention more likely to include errors), but it keeps all the information bottled up on one person’s screen until they’re ready to share.

We all have seen an Excel spreadsheet named finalV2 or Final V3, only to find out our business partners are using FinalV6. This is a leading cause of number mismatch. Using modern finance tools, a finance team can collect and report on the numbers without needing to send and receive Excel spreadsheets. Everyone is on the same version and making the changes together. This just makes the business partners a part of the overall process, not part of the problem.

The more you can modernize your process and increase visibility into KPIs across the company, the more others will think of “our numbers” instead of “finance’s numbers.” When you create a single source of truth and share it, collaborators will be able to move past arguing about the numbers and start working together to decide on next steps.

A Strategic Bonus to Collaborative Finance

As a bonus, automation and dashboards for self-service collaborative reporting can vastly reduce the amount of transactional work the finance team has to accomplish each day. This frees up our time for both increased collaboration and providing the strategic, high-level analysis that helps move the company forward.

The bottom line: Financial collaboration becomes easier when you stop relying on static spreadsheets. It starts with getting the entire team working with one, trusted set of numbers, and building on a foundation of accurate, up to date data.

This blog post was originally published on the Workday Adaptive Planning blog and appeared here.

Check out more FP&A Done Right posts here:

FP&A Done Right: Five Tips for Budgeting in the Age of COVID

FP&A Done Right: To Recover from Economic Shock, Are CFOs Envisioning Enough Scenarios?

FP&A Done Right: Three Driver-based Budgeting Tips for CFOs when Change is Imminent

Home » FP&A » Page 2

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Budgeting Planning & Forecasting, enterprise performance management, FP&A, FP&A done right, Planning & Forecasting, Planning & Reporting

FP&A Done Right: Achieve More Reliable Financial Forecasting

February 26, 2021 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, written by Gary Cokins. Cokins is an internationally recognized expert, speaker and author in enterprise and corporate performance management systems. In this piece Cokins outlines three steps for more reliable forecasting.  

When a company fails to meet its financial targets, business leaders want to know why. Was it the pandemic? Did sales underperform? Did operations overspend? Were their purchases more expensive than expected? Was productivity below established standards? Did finance develop a forecast that was wrong from the start?

Determining the causes of budget variances is an effective way to avoid similar missteps in the future, as well as during times of disruption. But many businesses struggle to understand the causes of variances and to define a process that will turn out accurate forecasts every quarter.

Finance and business teams must work together to identify the activities or data gaps that led to a missed forecast projection and caused price, cost, and efficiency variances. Whether poor decisions were made, the business landscape changed, or customer needs evolved, digging into the root cause starts with building relationships based on trust and transparency.

Companies need to continuously answer these three questions: What? So what? and Then what? Answering the first question—What happened?—requires good reporting with visibility. Answering the second question—So what?—involves separating the signal from the noise and determining what is relevant from the reporting. Arguably, answering the third question—Then what?—is the most important and critical part, because only these decisions impact the future.

Here are three tips that will help your finance team set performance targets and standards that company leaders can be confident in.

Step #1: Bring everyone to the table

Hitting a financial forecast isn’t just about meeting sales goals. Employee turnover, travel expenses, marketing costs, and other operational expenditures must be accurately projected to create a viable financial forecast.

But finance teams can’t analyze all these variables on their own. They need to work closely with sales, HR, marketing, operations, and executive teams to get a clear view of past performance, changes on the horizon, and potential risks and opportunities.

Centralizing financial information in a single shared database reduces the time it takes for finance teams to gather this information, giving them more time to focus on analyzing causes of variances and speculating on potential outcomes. Collaborative financial planning software also helps keep information up-to-date by making reporting easier for other departments.

It may take time to get the whole company on board with a new data collection, integration, and delivery process, but the payoff that comes with more reliable reporting is worth the effort.

Step #2: Plan for multiple outcomes

It’s impossible to know for certain what the future might hold. No one has a crystal ball for this. But there are ways to view the planning horizon. One way is to create multiple projections that account for different scenarios. This can include sensitivity analysis by changing some of the variables, such as the forecast sales volume and mix, to calculate projected profits. This can keep your company running on all cylinders—regardless of what comes its way.

Project for at least two possible outcomes—one optimistic and another cautious—so you can create proactive response plans. Look closely at the assumed factors and variables that are most likely to impact your projections. For instance, a change in the price of raw materials, in labor rates, or the emergence of a new competitor could create pricing pressure, which might lead to a decline in revenues.

Scenario planning can also help companies navigate regulatory changes that come with political transition or turmoil. According to a survey by KPMG, 77% of U.S. CEOs say they are focusing more on scenario planning to manage change in the current political environment.

However, with the increasing responsibilities falling on FP&A teams, many feel they don’t have enough time for this type of proactive planning. Sixty percent of CFOs estimate that ad hoc analysis, such as running a new scenario for the forecast, takes up to five days, according to a survey we published a few years back.

Planning and budgeting software can help FP&A teams speed up the time it takes to outline the financial implications of different scenarios and outcomes. The right tool lets teams run reports with the click of a few buttons, giving them more time to consider the risks, opportunities, and assumptions to create comprehensive response plans.

Step #3: Collect customer data

Understanding changing customer preferences, needs, and demands can also help improve the accuracy of financial projections—and boost a company’s overall financial health. However, a third of U.S. CEOs say the depth of their customer insights is limited by a lack of quality customer data, according to KPMG. So it’s no surprise that nearly two-thirds expect to invest in data analytics technology in the next three years.

“The whole idea of knowing what the customer wants before they want it is sort of the brass ring,” Tom Hayes, president and CEO of Tyson Foods, told KPMG. “We have real-time data from the shelf back to our supply chain. It takes out a lot of waste and helps us to more accurately forecast—a great benefit for products with a short shelf life.”

Taking the right steps to figure out where a missed forecast and associated assumptions went wrong will help keep business performance on target year after year.

This blog post was originally published on the Workday Adaptive Planning blog.

Read more FP&A Done Right posts:

FP&A Done Right: There is Life After December – The Fixed Forecast Dilemma

FP&A Done Right: Rolling Forecasts for More Strategic FP&A

FP&A Done Right: The Role of KPIs in Driver-Based Budgets

Home » FP&A » Page 2

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Budgeting Planning & Forecasting, enterprise performance management, Financial Performance Management, forecasting, FP&A, FP&A done right, Workday Adaptive Planning

  • « Go to Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Interim pages omitted …
  • Page 6
  • Go to Next Page »

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.