• 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

Budgeting

The Role of Finance Reimagined: A Manifesto

April 12, 2017 by Brian Combs Leave a Comment

FP&A Done Right

Our world is in the midst of a transformative technological revolution that is impacting every nation, industry, enterprise and human being on this planet. It is a revolution because it is radical and happening so fast. It is transformative because it is so pervasive and fundamentally changing the way we live.

We’re seeing changes in business and technology never before imagined. For example:

  • Ten years ago, the Internet of Things (IoT) consisted of approximately 500 million connected devices. Today that number is 9 billion. At the end of this decade that number is projected to be 50 billion. And, not long after that? One trillion.
  • Self-driving cars are no longer a dream. They’re real and very close to becoming the standard. Did you ever consider Google a car company? It is projected that the soon-to-arrive proliferation of self-driving cars will increase the capacity of our roads and highways by a factor of 10-15 times. Imagine the impact on safety, quality of life… even real estate prices.
  • Crowdfunding means that institutional investors are no longer needed to fund startups. In fact, you can now validate new products without even creating them yet.
  • The largest hotel company in the world—Airbnb—doesn’t own a single hotel room. It has disrupted the business model by reducing both the cost of demand and supply to next-to-nothing.
  • 50% of all business ground transportation costs in the U.S. are paid to Uber. And, it doesn’t own a single vehicle.
  • Jeff Immelt, CEO of GE, said in a recent interview with McKinsey and Company, “We can’t be an industrial company anymore. We need to be more like Oracle. We need to be more like Microsoft.”

Given these changes—and those to come—what role must the Office of Finance play as organizations change? How can it best support corporate strategy and operational effectiveness? How can Finance be viewed as a strategic partner to the business in its quest to disrupt itself and transform organizational behavior?

We explore how the Office of Finance is changing in our Manifesto. We invite you to download it, consider how your organization is changing, and how the Office of Finance needs to transform to facilitate that change.

Consider what Charles Darwin told us, “It is not the strongest or the most intelligent who will survive but those who can best manage change.” Does your Office of Finance have a strategy for managing today’s—and tomorrow’s—changes?

Home » Budgeting » Page 18

Filed Under: News & Events Tagged With: Budgeting, Financial Performance Management, Planning & Reporting, Transforming Finance

My Mission to Transform FP&A

April 11, 2017 by Brian Combs Leave a Comment

News and events

After spending almost 13 years in various global, domestic and corporate FP&A roles at Hertz Rent-a-Car, I’m nearly one year into my position as a managing consultant at Revelwood. The turning of the year, if you will, into year two at Revelwood, gives me an opportunity to reflect on the state of FP&A in many organizations today.

When I first started at Hertz, I was a participant in the company’s Advanced Management Development Program. This was a six-to-nine month rotational “fast track” program that had me doing assignments with city managers, fleet operations, back office management, employee relations and customer service. The goal was that when I ultimately ended up working in the finance department, I’d have a “bigger” view of the organization than one that was just comprised of “numbers.” That experience helped shape my career, as it gave me a true appreciation of the importance of people and process. Throughout my FP&A career, I focused on the upstream and downstream impacts of my actions.  It is difficult to add value without an understanding of the entire process. This is the essence of a FP&A professional.

At the beginning of my career, FP&A (then Business Planning) was all about numbers. It was largely reactive and, while many hours were (are) consumed working on it, the value it added, and still adds, could, and can, sometimes be questioned. After you gather the data, create/format/validate the fancy Excel charts, and complete multiple iterations, it is too late to enact change in any meaningful way. But that’s changing, and changing drastically, in many organizations.

What’s really exciting today is that FP&A is emerging as a proactive team that is an integral part of the business. As they gather data from all the siloed departments and units, they are being recognized as the single source of a potentially complete view of what’s going on in the organization, what the cause and effects of various actions are, and where strategic changes can be made for maximum impact. In fact, according to research from The Hackett Group, “more than 90 percent of finance organizations believe that digital transformation will fundamentally change the way finance services are delivered, including the way it serves internal and external customers, suppliers and partners, as well as the talent and leadership roles it must develop.”

That probably sounds very lofty and hard to achieve in many places – especially in established businesses with codified processes. But I believe it is achievable, and that it starts with examining, understanding, and changing (where needed) processes. Not simply for the sake of change itself, but because of the importance of continuous improvement and its impact on the business and the team.

I believe the FP&A group can and should be the most empowered group within an organization. When they have access to analyze the right data, they can uncover the root cause of not just finance issues, but operational issues and stumbling blocks. They are able to do this since they understand the synergies between various aspects of operations, and how process changes or process inertia create ripple effects or institutional bottlenecks. Armed with this knowledge, they can create and execute corrective action plans.

So you might ask, why would this passion lead me to a company known for its stellar reputation as an implementation and consulting firm for IBM analytics technology? After all, I’ve not said a single thing about technology.

Analytics technology is the enabler for the transformation of FP&A. Here at Revelwood, we’re working with our clients to help them make this transformation. And it’s certainly an exciting time for all of us. I look forward to speaking with you about your processes and how Revelwood can help.

Home » Budgeting » Page 18

Filed Under: News & Events Tagged With: Budgeting, Financial Performance Management, Planning & Reporting

Revenue Recognition’s Technical Aspects Make Adoption Difficult

March 14, 2017 by Stu Fisher Leave a Comment

News & Events

This is a guest blog post by RGP Director of Client Service, Stuart Fisher.

It’s official. The adoption of ASC 606 – the new Revenue Recognition accounting standard, is not going to be fun. Forty percent of finance professionals surveyed by Intaact would rather stand in line at the DMV than go through the process of preparing and implementing the new standard. The technical aspects, which are enough to make anyone cringe, raise many questions. Among them:

  1. How many performance obligations do you have?
  2. What are the impacts of contract modifications?
  3. Will you recognize revenue over time or at a specific point in time? Which recognition method is appropriate for your organization?
  4. What is your stand-alone selling price?
  5. Are you the principal or the agent?

Beyond these technical uncertainties, plenty of implementation challenges may affect a number of functions within your organization. For example … How many contracts need to be reviewed? Are current systems sufficient to accommodate the new requirements? How will reporting disclosures be affected? Is the data needed to comply available, and if so, is it available to the appropriate users? How will internal controls be revised or implemented to accommodate the need for new data and calculations? Who in your organization has the time and skillset to meet the aforementioned needs?

While there are a number of activities we would rather do, implementing the new revenue recognition standard is something many of us will need to do. In fact, the SEC has publicly stated that they are expecting more robust disclosures in upcoming filings. Through impact assessments, companies have learned how the standard will affect their organizations and will be sharing this information in their filings to update investors. To facilitate transparency and the timely absorption of the information by market participants, the SEC suggest incorporating an impact discussion into investor outreach activities.

If you have any questions about how your company should handle the new standard or how RGP can help you, please contact me at 973-401-2565 or stuart.fisher@rgp.com.

Stuart Fisher is the director of client service at RGP, a global consulting firm that provides advice and execution to clients of all shapes and sizes in more than 70 countries—including 87 of the Fortune 100. With a Big Four heritage, its 3,000+ accomplished professionals offer deep expertise across a broad range of integrated services. RGP provides its clients the agility to expand capacity and increase capability. And the support they rely on to help them achieve all that’s possible.

Home » Budgeting » Page 18

Filed Under: News & Events Tagged With: Analytics, Budgeting, Financial Performance Management, Planning & Reporting

Introducing IBM Planning Analytics Local

December 15, 2016 by John Pra Sisto Leave a Comment

News & Events

IBM Planning Analytics Local, the convergence of TM1 on-premise with Planning Analytics on the cloud is now available! This new release brings many of the great enhancements and performance improvements that IBM has been making in the cloud environment available to on-premise TM1 customers.

I recently hosted a webinar with Dan Bernatchez, our FPM practice leader and Chief Solutions Architect for TM1, to review the new features of the solution and provided a live demo of Planning Analytics Local.

One highlight of the webinar included Dan showcasing Planning Analytics Workspace, which is a completely transformed user experience. This new “face” of TM1 provides a rich, interactive workspace that is visual, intuitive, insightful, social and mobile.

Dan also explained how Planning Analytics Local uses hierarchies for deeper analysis of TM1 data. Essentially it turns attributes into virtual dimensions, saving RAM, increasing query performance and adding flexibility. This enables users to have smaller, faster cubes, to introduce hierarchies to queries as needed, and to do dimension versioning.

Since Planning Analytics Workspace is the one new component that comes at an additional cost, IBM is offering a special 75% discount for existing TM1 customers who purchase it before year-end 2016. For information on this pricing deal, contact me and I can help you.

This webinar was the first in a three-part series showcasing IBM Planning Analytics. Stay tuned for the dates and topics of the next two webinars coming in early 2017.

Home » Budgeting » Page 18

Filed Under: News & Events, Videos Tagged With: Budgeting, Financial Performance Management, IBM Planning Analytics, Planning & Reporting, TM1

Revenue Recognition Is More Than a Finance & Accounting Issue

November 30, 2016 by Stu Fisher Leave a Comment

News & Events

This is a guest blog post by RGP Director of Client Service, Stuart Fisher.

On May 28, 2014, the Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB), also known as the Boards, issued converged final revenue recognition standards, which eliminate most industry-specific GAAP and significantly changed revenue recognition. Now that the one year delay proposed by the Boards is finalized, the standards will become effective in fiscal years beginning after December 15, 2017 (calendar year 2018) for public U.S. companies, which is essentially the same for companies reporting under IFRS. Private companies are allowed a one-year delay.

Implementing these changes will be complex and time consuming. In a recent survey RGP conducted, 82% of respondents said they anticipate implementation will be somewhat challenging to very challenging. Even companies not expecting drastic changes to the amount or timing of revenue recognition will likely be affected by necessary changes in documentation and information systems to track new data requirements and support the additional disclosures, estimates, and increased use of management judgment.

Our Revenue Recognition experts offer the following tips to companies affected by the new standards:

  1. Assess the impact:
    Organizations can avoid costly implementation issues and/or delays by assessing the cross-functional impacts that ASC 606 and IFRS 15 will have on their operations. Understanding what the enterprise-wide impacts are early on can help develop a clear roadmap with appropriate actions that are needed for a smooth implementation.
  2. Select a transition method:
    If you haven’t already done so, now is the time to choose a transition method and implement a plan to capture contract data. The full retrospective method is a popular choice because it is preferred by the investor community.
  3. Evaluate significant revenue streams and key contracts:
    Identifying required changes, and the specific business units where these changes may have the greatest impact, will be a necessary step.
  4. Establish a Project Management Office (PMO):
    Revenue recognition implementation doesn’t have to be a burden. It can be an opportunity to open communication among departments and business units, and to improve processes. Ensuring your revenue recognition project is efficiently managed and successfully executed leads to sustainable results.
  5. Determine the impact on your systems and data:
    From sales compensation to closing the books, your company depends on critical systems and accurate data. The system and data impacts may be greater than anticipated.
  6. Establish a suitable contract management process:
    Analyzing current requirements, and creating a contract management process that fits the needs of your organization, will help reduce risk and improve efficiency.

Implementing the new revenue recognition standard is a complex and time-consuming initiative. If you have any questions about how your company should handle the new standard or how RGP can help you, please contact me at 973-401-2565 or stuart.fisher@rgp.com.

Stuart Fisher is the director of client service at RGP, a multinational consulting firm that helps leaders execute internal initiatives. RGP was founded in 1996 within a Big Four accounting firm and today it is a publicly traded company with more than 3,300 professionals, annually serving over 1,800 clients from 70 global locations.

Home » Budgeting » Page 18

Filed Under: News & Events Tagged With: Budgeting, Financial Performance Management, Planning & Reporting

How will Brexit Impact your Financial Planning & Analysis

August 23, 2016 by Lisa Minneci Leave a Comment

News & Events

It’s been several weeks since the historic and disruptive Brexit vote, where the UK voted yes to a referendum deciding to leave the European Union. Stock markets around the world immediately had a knee-jerk reaction, and there has been speculation that banks—particularly U.S. banks—will move their London operations to other locations. As the dust around Brexit is settling and the world is beginning to comprehend and work through what a UK exit from the EU looks like and how and when it will happen. We sat down with Don Cole and Lee Lazarow at Revelwood to understand how Brexit could impact your Fx conversions.

First, let’s look at how Fx currencies are handled in typical ERP systems. Since these are tools that are modeled to reflect a company’s operating structure, many companies handle their Fx conversions as simply conversion rate times base currency. This provides a one-dimensional view of the data and provides no insight into the true financial impact.

Revelwood takes a different approach when working with our clients on Fx conversions. We develop a variety of conversions to provide real insight into the operating results. This approach enables companies to correctly analyze whether a loss in a region was the result of currency fluctuations, or actually sales or service losses. These conversions include each of the respective currencies (e.g. USD, EUR and GBP) at the following rates:

  • Current Year Actual Rate
  • Current Year Budget Rate
  • Current Year Forecast Rate
  • Prior Year Actual Rate
  • Prior Year Budget Rate

With a system such as described above in place, companies can easily adjust their planning assumptions to reflect the fall of the pound sterling since the Brexit vote. This level of visibility can help companies to understand what changes they can and should make to their current assumptions and/or sales strategies to make up for the financial loss due to the dropping currency rates, or how to at least avoid a big surprise at the end of the fiscal year.

In the longer term, once Brexit happens, there is likely to be major changes to pricing in the UK, and possibly in other regions. One of the key aspects of Brexit is it will decouple the UK market from the EU market, meaning that the UK will need to renegotiate many trade agreements with other nations. And while the UK is still a large nation, in theory it will have less bargaining power than that of the EU. But, that is still many years out. In the meantime, now is the time to re-examine how your company handles Fx conversions and make some changes to better manage the financial fluctuations in the world market.

Home » Budgeting » Page 18

Filed Under: News & Events Tagged With: Analytics, Budgeting, Financial Performance Management, Planning & Reporting

Creating IBM Planning Analytics Workspace Content (Part 2)

August 1, 2016 by Don Cole Leave a Comment

Tips & Tricks

This blog is intended to continue and build upon the previous blog How to Create IBM Planning Analytics Workspace Content. In this blog, I will provide an overview on building the remaining content (second and third row of visualizations) in the Dashboard below.


Dashboards


Create or Open a Book

  • Open up Planning Analytics Workspace, create a new Book or open up an existing book.


Steps to Create Units by Month

  • Drag and Drop a view from the Revenue Cube onto your canvas (we are using Revelwood’s Big Apple demo database for these examples).
  • Update the View so the Rows are the Products and the Columns are the Months that you want to report on.
  • Click on the amounts in your view, and select ‘Edit the Title’ from the blue Toolbar above your View and type in ‘Units by Month (000’s)’. The results will look like the following:


Steps to Create Units by Region

  • Click on the amounts in your view, and select ‘Duplicate’ from the Toolbar.
  • Drag and Drop that view to the right of the first view.
  • Swap the Product Dimension with the Region dimension, so the Regions are on the Columns.
  • Edit the Title to be ‘Units by Region (000’s)’. The results will look like the following:


Steps to Create Gross Margin by Period

  • Navigate to the Applications Folder of Revelwood’s Big Apple demo database.
  • Select the ‘Gross Margin by Period’ report.
  • Drag and Drop that report below the Units by Month (000’s) view.
  • Align and Size it as required.
  • The results will look like the following:
  • Click the amounts in your Units by Region view and select ‘Change Visualization’ from the blue toolbar above your View and select ‘Column’.


The result will be:


Summary

We’ve walked through the steps to create a simple Dashboard that includes Cube Views, Visualizations and Excel TM1 worksheets. Additional items that can be added to a Dashboard include; Media, Action Buttons, Web pages, Images and more. In short, IBM Planning Analytics Workspace is a powerful reporting tool providing you with new ways to analyze data, plan and access your content.

Want to learn more about IBM Planning Analytics? Email us and we’ll show you how powerful it can be for your company.

Read other Tech Tips blog posts:

Important Things to Consider When Changing your COA Structure

Securing Data from IBM Cognos TM1 On-Prem to IBM Planning Analytics

How to use IBM Planning Analytics Workspace

How to Create IBM Planning Analytics Workspace Content (Part 1)

Home » Budgeting » Page 18

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Financial Performance Management, IBM Planning Analytics, Planning & Reporting, TM1

QUBEdocs Streamlines TM1 Documentation

June 24, 2016 by John Pra Sisto Leave a Comment

Tips & Tricks

Understanding and documenting existing IBM® Cognos® TM1® models can be a time-consuming process. When making changes to complex models, it is challenging to fully understand the implications of these changes to ensure issues or inaccuracies won’t arise. Having made the changes, documentation must be also updated.

I recently sat down with our partner, Scott Felten, General Manager of QUBEdocs, to talk about the benefits of using QUBEdocs for TM1 documentation.

Q: What is QUBEdocs?
Scott: QUBEdocs is a proven solution for addressing the everyday challenges of TM1 analysts, developers and administrators. By delivering meaningful documentation of TM1 models, it virtually eliminates many of the time-consuming tasks associated with managing and making risk-free changes to TM1 models.

Q: How does it work?
Scott: QUBEdocs automates and centralizes the documentation of TM1 models, by allowing you to tag model constructs such as business rules, models, processes and applications. Integrating closely with TM1, it pulls information from vast numbers of underlying TM1 source files enabling you to organize your model and delivering an otherwise-unavailable consolidated view:

  • Depicting models visually
  • Delivering hard to find information to developers, administrators and end users in a meaningful way
  • Displaying comprehensive model dependencies
  • Enabling impact analysis of proposed changes
  • Highlighting errors through integrity checks
  • Tracking changes to meet corporate governance requirements
  • Capturing and reporting on changes over time or between environments
  • Maintaining documentation as changes are made

Q: What benefits can an organization expect from using QUBEdocs?
Scott: QUBEdocs significantly decreases the cost of managing your TM1 implementation, adding significant value to your business. QUBEdocs automatically generates documentation for TM1 models and uses a simple framework for translating the technical aspects in TM1 into your own business language ‘as you go’ resulting in time and resource savings. Presenting comprehensive TM1 model information in a meaningful way, QUBEdocs empowers users to logically and visually interrogate their model – making them less likely to make errors that result in support costs. Users and developers can clearly see dependencies within complex models, depict the models visually and search entire models. This allows them to effectively anticipate the impact of changes before making them.

Want to learn more about QUBEdocs? Contact John Pra Sisto.

Read other Tech Tips blog posts:

IBM Planning Analytics: Using the Full Power of MDX

Important Things to Consider When Changing your COA Structure

Securing Data from IBM Cognos TM1 On-Prem to IBM Planning Analytics

How to use IBM Planning Analytics Workspace

Home » Budgeting » Page 18

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Financial Performance Management, QUBEdocs, TM1

Cash Flow Modeling with IBM TM1

March 15, 2016 by Don Cole Leave a Comment

Tips & Tricks

As a senior consultant with Revelwood for nearly seven years, I’ve had the opportunity to design and develop a large number of TM1 models for various aspects of budgeting, planning and forecasting. Some client engagements are very straightforward – simply transition the business from spreadsheet-based budgeting to TM1. This gives them greater flexibility and visibility while significantly reducing the amount of time spent on the budgeting process. All good and necessary stuff to properly manage an organization’s finances in today’s fast-paced business environment.

But every now and then, I’ve also had the opportunity to design and develop a TM1 model that’s completely new – not just a “standard” financial accounting activity, or a modification required for a specific industry. And that’s when my job is really fun.

One recent client engagement is a perfect example of doing something new in TM1. We developed a cash flow model designed specifically to reflect the reality of the business situation along with addressing the complexity of a multi-billion dollar business. Often, finance executives and analysts look at a forecast and focus on net income, sales or profitability. But what’s equally important is the impact those variables will have on cash.

On one hand it’s pretty simple. The more net income you have, the more cash you are going to have. However, our client wanted to say, “Based on our forecast, if I keep $100 million in cash, how much will I need to borrow or repay on my debt?” To get to this, we needed the model to reflect the entire business, including the forecast net income, capital expenditures and shareholder dividends. It needed to include everything we know about all the transactions, and how they impact the end result.

This may sound very different from “traditional” forecasting, but in fact, it’s just taking it one step further. At its simplest, it’s about taking all the known information and modeling that information so that the client can look at it in a different way. And that, to me, means there is always something more we can do with TM1. It’s not limited to basic budgeting and forecasting. In fact, operationally, you can measure any metric or KPI and create dashboards for them. Projects like this one – ones that push TM1 past the basics – are fun and engaging to work on.

Home » Budgeting » Page 18

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Financial Performance Management, Planning & Reporting, TM1

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 16
  • Page 17
  • Page 18
  • Page 19
  • 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.