Welcome to Revelwood’s Knowledge Center
FP&A Done Right: A Complex Approach to Allocations
An allocation is defined as “the action or process of distributing something.” In business terms, this typically entails the movement of costs. Some companies have a rather straightforward approach to allocations. Others need to incorporate a level of complexity to their allocations. A Revelwood…
November 16, 2021
FP&A Done Right: What is Zero-Based Budgeting?
This is a guest blog post from our partner Workday Adaptive Planning on zero-based budgeting, which enables companies to align spending with business goals. Many businesses are shifting into recovery mode after the economic disruption caused by COVID-19. While it’s too soon…
November 12, 2021
Workday Adaptive Planning Insights
What-if Analysis in Workday Adaptive Planning
What-if analysis – or scenario planning – is a critical part of every finance team’s job. It enables the team to model any number of factors – from normal seasonal changes in business to massive disruptions. Workday Adaptive Planning has extremely strong…
November 10, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAx Writeback Mode
As of version 2.0.68 of IBM Planning Analytics for Excel (PAx), a new toggle was added to the IBM Planning Analytics ribbon that allows users to decide how DBRW formulas are treated when data is entered. Prior to version 2.0.68, this option was…
November 9, 2021
Financial Close & Consolidation
Modern Accounting: 4 Best Practices for your Month-End Close
This is a guest blog post from our partner BlackLine, explaining how to build a best practices checklist for your month-end close. A month-end close checklist is critical to ensuring a smooth and successful close process. Its purpose is to provide visibility into…
November 4, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Using IF With a Counter
I recently worked with an IBM Planning Analytics client to optimize a model that uses a check value to determine when to do further calculations. The check typically resulted in either a one or a zero and a series of rules were written…
November 2, 2021
FP&A Done Right: Is Your Data Trapped in a Legacy ERP System?
This is a guest blog post from our partner Workday Adaptive Planning, highlighting the challenges Finance leaders have with legacy ERP systems. In late 2019, Mercer surveyed business leaders about their expectations for the next three years. Nearly three out of four…
October 29, 2021
The Office of Finance Should Make the Most of a “Use it or Lose it” Budget Policy
Does your company have a “use it or lose it” budget policy for this year or a situation where next year’s budget shrinks if you don’t spend all of this year’s budget? Losing budget this year is just as bad as having…
October 28, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: TM1Ellist
Have you ever wanted to use Excel to create a list of elements within an IBM Planning Analytics dimension? If so, the TM1ELLIST function is your answer! This function is used to return a list of elements with parameters to define the look of…