Revelwood

Your SUPER-powered WP Engine Site

Planning & Reporting

Mastering Cash Flow Management with Enterprise Planning

by

In the ever-evolving landscape of financial planning and analysis (FP&A), effective cash flow management stands as a cornerstone for organizational success. A recent episode of FP&A Done Right – The Podcast on cash flow modeling delves into this critical topic, exploring how strategic planning can revolutionize the way finance teams approach cash flow forecasting and management.

The Imperative of Accurate Cash Flow Forecasting

Cash flow forecasting is more than just predicting inflows and outflows. It’s about enabling strategic decision-making and ensuring financial stability. This episode emphasizes the challenges organizations face with traditional forecasting methods, such as reliance on spreadsheets, which can lead to errors and inefficiencies.

Leveraging Company-Wide Planning for Enhanced Forecasting

Company-wide planning software is a powerful tool to address these challenges. We discuss how its real-time data integration and user-friendly interface allow finance teams to create more accurate and dynamic forecasts. Organizations can automate data collection and analysis, which enables finance teams and senior management teams to respond swiftly to financial changes and make informed decisions.

Core Principles for Effective Forecasting

  • Real-Time Data Integration: The importance of having up-to-date information for accurate forecasting.
  • Automation and Efficiency: How automating processes reduces errors and saves time.
  • Strategic Decision-Making: Utilizing accurate forecasts to inform business strategies and investments.
  • Scalability: Adapting forecasting methods to accommodate organizational growth and complexity.

This episode of FP&A Done Right provides valuable insights into modernizing cash flow management through technology. By adopting company-wide planning software, organizations can enhance their financial forecasting capabilities, leading to better strategic decisions and financial health.

For a deeper understanding, listen to the full episode.

Home » Planning & Reporting

A Better Way to Budget: FP&A for High-Growth SaaS Firms

by

In the fast-paced world of Software-as-a-Service (SaaS), the pressure on finance teams is constant. Saas businesses face unique financial planning challenges – managing recurring revenue models, fast growth expectations and investor scrutiny, to name a few.

A recent episode of FP&A Done Right – The Podcast, Streamlined Budgeting and Forecasting for SaaS Businesses, zeroes in on how SaaS companies can transform their budgeting and forecasting processes using company-wide planning.

The Complexity of SaaS Financial Models

Traditional budgeting methods often fall short in SaaS environments. Subscription billing, deferred revenue recognition, customer acquisition costs and churn all introduce planning complexities that require more than just static spreadsheets. Add in multiple departments, rapid hiring and shifting forecasts, and it’s easy to see why many SaaS finance teams feel like they’re constantly playing catch-up.

This episode of FP&A Done Right – The Podcast highlights the importance of having a dynamic, scalable planning solution built for the modern finance function. Enterprise planning software helps SaaS firms shift from reactive to proactive by providing real-time data, flexible modeling, and enhanced collaboration across teams.

Lessons from the Frontlines of SaaS Finance

  • Speed to Insight: SaaS companies can gain faster access to key metrics like ARR, CAC, and churn rates. Company-wide planning eliminates spreadsheet chaos and reduces the time it takes to update and analyze forecasts.
  • Modeling for Growth: One of the biggest strengths of strategic planning software is its ability to handle complex and evolving business models. SaaS firms can create driver-based models that reflect their unique KPIs and scenarios—whether planning for new pricing strategies, product launches, or funding rounds.
  • Team Collaboration: The episode emphasizes the importance of cross-functional alignment. With company-wide planning, budget owners across the company can contribute to the plan directly, reducing back-and-forth and increasing accountability.
  • Scenario Planning in Real Time: In an industry that evolves quickly, scenario planning is essential. Strategic planning software allows teams to test best-case, worst-case, and expected-case models on the fly—empowering CFOs to make confident, data-driven decisions.

Real-World Impact

Listeners hear firsthand how SaaS finance leaders are using enterprise planning to simplify their workflows, reduce forecasting errors, and spend more time on strategic analysis instead of wrangling data. This transformation not only increases efficiency but also elevates the role of FP&A within the organization.

This episode is packed with actionable insights and real-world strategies for SaaS CFOs, Controllers, and FP&A teams looking to scale with confidence.

Listen to the full episode.

Home » Planning & Reporting

FP&A Done Right – Season Two is Here!

by

If you’re in finance, planning & analysis (FP&A), FP&A Done Right – The Podcast is one of those podcasts you’ll want to follow. It focuses on real-world strategies and tools to help finance pros move beyond report generation and become strategic partners in their businesses. After a strong debut with Season One, Season Two is now here — and it’s pushing even further into transformation, automation and strategic value.

A Quick Look Back: Season One

Season One laid a solid foundation. It offered ten episodes covering core FP&A topics:

  • Implementation best practices in “10 Steps for a Successful FP&A Implementation.”
  • Scenario planning, headcount strategy, cash flow management, revenue & expense planning and more.
  • Case studies showing how organizations use Workday Adaptive Planning to gain visibility, streamline processes, reduce manual work and improve decision-making. 

Season One was practical. Each episode gave finance leaders and teams tools, checklists and examples you could start using right away. It set expectations: this podcast isn’t abstract—it shows how to do FP&A right.

What’s New in Season Two

Season Two picks up from that foundation and builds it higher. While still rooted in practice, the focus shifts even more toward:

  • Transformation at scale: How FP&A leaders can move from reactive, periodic reporting to being drivers of strategic decision-making.
  • Automation, AI, and smarter insights: Not just “we could do this someday,” but how finance teams are actually using modern tools now.
  • Short-er deep dives: More condensed episodes but packed with actionable takeaways.

For example, early in Season Two:

Season One of FP&A Done Right gave listeners the groundwork — fundamental concepts, core practices, tool overviews and practical case studies. Season Two is amplifying those lessons, focusing more on transformation, automation, AI, and helping finance teams step up.

If you haven’t yet listened to Season One, it’s worth starting there. Then let Season Two show you how to move beyond the basics, toward a finance team that can lead strategy, not just react to it.

Subscribe to Season One.

Subscribe to Season Two.

Home » Planning & Reporting

Cumulative Translation Adjustment Accounts

by

If your company has international operations, Workday Adaptive Planning provides you an easy to set up feature to track gains and losses from translating foreign currencies. Rather than having to create a calculated account with a formula, Adaptive makes it easy with just a click of a button to calculate the Cumulative Translation Adjustment.

Step 1: Navigate to Modeling and then Currencies

Step 2: Check the Enable Cumulative Translation Adjustment (CTA) box

This page allows you to add, edit, or delete any currencies that you will need in your Adaptive instance. Additionally, it allows you to choose the exchange rate type. Once you check the Cumulative Translation Adjustment box, it will give you an option to edit the CTA account details

Step 3: Edit CTA Account Details (Optional)

The edit page will allow you to change several different settings such as account name, roll-up, balance type, account attributes, and decimal places

Evaluated Formula

Above is the formula that is being evaluated for the Cumulative Translation Adjustment account. This formula could not be altered in any way.

Revelwood is more than just a Platinum Workday Adaptive Planning partner — we’re a trusted advisor to the Office of Finance. With 30 years of experience and award-winning expertise, we bring together powerful software, proven best practices and pre-built, ready-to-deploy solutions that accelerate time to value. Our team doesn’t just implement technology — we help finance teams transform the way they plan, analyze and make decisions. Discover how Revelwood can help you get the most out of Workday Adaptive Planning — and achieve results that matter.

Read more Workday Adaptive Planning Tips & Tricks:

Mastering Merged Cube Sheets in Workday Adaptive Planning

Account Modifiers in Formulas

Limiting the Scope of Calculated Accounts

Home » Planning & Reporting

Workday Adaptive Planning Tips & Tricks: Virtual Version – Report Toggling

by

Virtual versions are used mainly for constant currency reporting in Workday Adaptive Planning. However, there’s a hidden advantage of virtual versions that most customers don’t know! It is updating version selection in reports/dashboards. 

For example, say you have many reports that reference the forecast version and the version changes from time to time because you might have a new forecast version every month. Instead of updating it manually for each of the reports, you can use Virtual Version to update the selection once and it will automatically update all the reports. 

In this screenshot, I have a virtual version that’s called Current Forecast. It’s referencing the most recent forecast version. 

Then, instead of using the Forecast 1+11 version in reports, I used this Current Forecast virtual version for all my reports. See below. 

When the next forecast is ready and I need to change all my reports to Forecast 2+10, I will update the selection in the Virtual Version setup and all the reports will refresh with the Forecast 2+10 data.

Revelwood is more than just a Platinum Workday Adaptive Planning partner — we’re a trusted advisor to the Office of Finance. With 30 years of experience and award-winning expertise, we bring together powerful software, proven best practices and pre-built, ready-to-deploy solutions that accelerate time to value. Our team doesn’t just implement technology — we help finance teams transform the way they plan, analyze and make decisions. Discover how Revelwood can help you get the most out of Workday Adaptive Planning — and achieve results that matter.

Read more Workday Adaptive Planning Tips & Tricks:

Mastering Merged Cube Sheets in Workday Adaptive Planning

Account Modifiers in Formulas

Limiting the Scope of Calculated Accounts

Home » Planning & Reporting

Add Additional Years to your Time Strata

by

Managing time strata effectively is key to long-term financial planning in Workday Adaptive Planning. But what happens when your current calendar doesn’t extend far enough into the future? In this Workday Adaptive Planning Tips & Tricks video, we walk through the steps for importing additional years into your Adaptive instance.

Why You May Need to Extend Your Time Strata

Business planning doesn’t stop in the current fiscal year. Many organizations need to plan five, ten, or more years ahead. By adding new years to your Adaptive calendar, you ensure your models, versions, and reports remain aligned with your long-term financial goals.

Steps to extend your time strata

  1. 1. Navigate to the time settings
    • From the Adaptive home page, go to Modeling and select Time.
    • Depending on whether you’re using a legacy or newer instance of Adaptive, you may see different options.
  2. 2. Legacy instances: Quick extend option
    • Legacy instances allow you to simply select Extend five years forward (or backward).
    • This is the most straightforward approach when available.
  3. 3. Newer instances: Use the calendar export/import method
    • For newer environments where the extend option isn’t available, you’ll need to:
      • Export your current calendar.
      • Open the file in Excel and trim down to a manageable set of years.
      • Replace old years with the future years you want to add (for example, changing 2010 to 2032).
      • Double-check your edits to ensure they align correctly.
  4. 4. Re-import the adjusted calendar
    • Return to your Adaptive instance and select Import Calendar.
    • You’ll see a warning that changes may affect frozen or locked versions—be sure you understand the impact before proceeding.
    • For this task, select the Append option (rather than update or reload) and upload your adjusted file.
  5. 5. Confirm and finalize
    • Once imported, your Adaptive environment will reflect the additional years you’ve added.
    • This allows your planning processes to extend seamlessly into the future.

Extending your time strata ensures that Adaptive Planning continues to support your organization’s long-range forecasting. While the process differs slightly between legacy and newer instances, both approaches give you the flexibility to look further ahead and keep your planning future-ready.

Revelwood is more than just a Platinum Workday Adaptive Planning partner — we’re a trusted advisor to the Office of Finance. With 30 years of experience and award-winning expertise, we bring together powerful software, proven best practices and pre-built, ready-to-deploy solutions that accelerate time to value. Our team doesn’t just implement technology — we help finance teams transform the way they plan, analyze and make decisions. Discover how Revelwood can help you get the most out of Workday Adaptive Planning — and achieve results that matter.

Read more Workday Adaptive Planning Tips & Tricks:

Mastering Merged Cube Sheets in Workday Adaptive Planning

Account Modifiers in Formulas

Limiting the Scope of Calculated Accounts

Home » Planning & Reporting

Why Strategic Headcount Planning Is the Missing Link in FP&A

by

In a recent episode of FP&A Done Right – The Podcast, the focus is on strategic headcount planning. This episode delves into the critical role of aligning workforce planning with organizational strategy, emphasizing the importance of integrating financial planning and analysis (FP&A) with human resources to drive business success. 

Transforming Headcount Planning into a Strategic Advantage

Strategic headcount planning goes beyond filling roles—it’s about aligning your workforce with your organization’s long-term goals. This episode explores how incorporating workforce planning enables more agile decision-making, improves resource allocation, and ensures your people strategy keeps pace with business demands.

1. The Importance of Strategic Headcount Planning
Effective headcount planning is essential for aligning talent acquisition and management with the company’s strategic objectives. By forecasting workforce needs and understanding the financial implications, organizations can make informed decisions that support growth and adaptability.

2. Leveraging Workday Adaptive Planning
Enterprise planning solutions facilitate real-time collaboration between finance and HR departments. These tools enable dynamic modeling and scenario planning, allowing organizations to respond swiftly to changing business conditions and workforce requirements.

3. Integrating FP&A with HR for Better Outcomes
By integrating FP&A processes with human resources planning, you ensure that financial forecasts account for workforce trends and HR strategies are grounded in financial realities, leading to more cohesive and effective organizational planning.

4. Navigating Challenges in Headcount Planning
The episode addresses common challenges such as data silos, communication gaps between departments, and the complexities of modeling various workforce scenarios. It offers strategies for overcoming these obstacles, emphasizing the need for transparent communication and integrated planning systems.

5. Real-World Applications and Success Stories
We share practical examples of how organizations have successfully implemented strategic headcount planning. These success stories illustrate the tangible benefits of aligning workforce planning with financial strategies, including improved agility and resource optimization.

For finance professionals, HR leaders and organizational strategists, this episode offers valuable insights into the interplay between workforce planning and financial management. It underscores the necessity of integrated planning approaches to navigate the complexities of modern business environments effectively.

Tune in to this episode of FP&A Done Right – The Podcast to explore how strategic headcount planning can serve as a cornerstone for organizational success.

Home » Planning & Reporting

Mastering Merged Cube Sheets in Workday Adaptive Planning

by

Merged cube sheets are a powerful tool in Workday Adaptive Planning that combine data from up to three modeled or cube sheets. They enable advanced calculations, simplify data management, and enhance forecasting. Let’s dive deeper into understanding their purpose, characteristics, and how to build them.

Why Use Merged Cube Sheets?

Merged cube sheets are especially useful for:

  • Creating calculated accounts without requiring data presence in the sheet itself. This feature ensures that formulas calculate accurately, even when data is absent in the merged cube’s standard accounts. Usually, a lack of data in the cube’s standard accounts forces formulas to evaluate at zero. Merged cube sheets bypass this rule by using the data presence of the source sheets.
  • Building simpler source sheets that focus only on necessary dimensions, then merging them to manage complex data across multiple dimensions efficiently.

Additional benefits include:

  • Allocations across dimensions using formulas.
  • Serving as calculation identifiers for other cube sheets.
  • Chaining merged cubes, where one merged cube acts as a source for another.

*Disclaimer: Using merged cube sheets in these additional ways can increase complexity of your model and may cause unexpected behaviors.

Example of a Merged Cube Sheet

Suppose you need to calculate revenue based on quantity and price across dimensions like customer, region, and product. Instead of managing this in one massive sheet:

  1. 1. Create a modeled sheet with the Customer dimension for forecasting total product purchases without breaking it down by product.
  2. 2. Create a cube sheet with the Product dimension for forecasting prices and mix by product.
  3. 3. Build a merged revenue sheet that combines these two sources to calculate total revenue by multiplying quantities and prices for each customer and product.

Characteristics of Merged Cube Sheets

Merged cube sheets:

  • Are read-only with no data entry support.
  • Require at least one calculated account. Data entry overrides are not available for this account.
  • Only allow account groups, calculated accounts, and metric accounts.
  • Can merge up to three source sheets (modeled or cube).
  • Contain only dimensions already present in the source sheets.
  • Must include any common dimensions across all source sheets.
    • Ex: if both sheets contain the product dimension, the merged cube must also include the product dimension.
  • Cannot include cube restrictions.
  • Only calculate intersections where data exists in the source sheets.

Steps to Build Cube and Merged Cube Sheets

  1. 1. Create Dimensions, Attributes, and Levels you want to add to the sheet.
    • Follow standard procedures for adding these elements to your planning model.
  2. 2. Create Source Sheets for Merged Cube Sheets.
    • Source sheets can be either modeled or cube sheets.
  3. 3. Start a New Sheet.
    • Select cube sheet and check the box for a merged cube.
  4. 4. (For Merged Sheets) Select Source Sheets.
    • Identify the sheets you wish to merge. This is located in the settings under “Dimensions, Attributes and Levels.”
  5. 5. (Optional) Create Account Groups.
    • Organize accounts for easier navigation.
  6. 6. Create Cube Accounts.
  7. 7. Add general ledger and custom accounts to your sheet and ensure they are cube-entered in account settings.
    • You can add general ledger and custom accounts to the cube sheet after you make the accounts cube-entered. In the account settings, for Data Entry Sheet Type, click Cube.
  8. 8. Add Dimensions and Attributes.
    • Include necessary custom dimensions and attributes in your sheet.
  9. 9. Select Time Periods.
    • By default, all available time periods are included.
  10. 10. Add Levels, Accounts, Dimensions, and Attributes.
    • Optionally hide certain cube accounts to simplify the sheet view.
  11. 11. (Optional) Adjust Sheet Properties.
    • Set the initial view, remove the cube root account, set the time strata, and manage calculation scope as well as other settings to enhance usability.
  12. 12. Assign the Sheet to Users.
    • If the sheet requires user assignment, ensure permissions are correctly set.
  13. 13. Load Data into the Sheet.
    • Data can be imported via spreadsheets, integration loaders, or entered directly from the Sheets menu.
  14. 14. Monitor Usage and Performance.
    • Regularly review the sheet’s performance to ensure optimal functionality.

Merged cube sheets are a great feature for streamlining complex forecasting models. By combining data from simpler sheets, they improve calculation efficiency and enhance data visibility. Following these steps will help you create effective merged cube sheets tailored to your organization’s planning needs.

Revelwood is more than just a Platinum Workday Adaptive Planning partner — we’re a trusted advisor to the Office of Finance. With 30 years of experience and award-winning expertise, we bring together powerful software, proven best practices and pre-built, ready-to-deploy solutions that accelerate time to value. Our team doesn’t just implement technology — we help finance teams transform the way they plan, analyze and make decisions. Discover how Revelwood can help you get the most out of Workday Adaptive Planning — and achieve results that matter.

Read more Workday Adaptive Planning Tips & Tricks:

Account Modifiers in Formulas

Limiting the Scope of Calculated Accounts

Override Formula Settings on Calculated Accounts

Home » Planning & Reporting

Account Modifiers in Formulas

by

The Formula Assistant in Workday Adaptive Planning provides a provides a powerful way to customize how data is pulled and calculated in formulas

To enhance the flexibility of your formulas, you can use a variety of modifiers that adjust how the information is retrieved. These modifiers include time, level, dimension, and attributes, each serving a unique purpose to make your formulas more dynamic and accurate. By incorporating these modifiers, you can manipulate the data in various ways to meet specific reporting or analysis needs.

For instance, when referencing an account, you can apply these modifiers to retrieve data in a manner that fits your desired outcome. A common example would be when you want to reference trailing data, such as pulling the trailing 12 months of revenue. By modifying the formula to say 

ACCT.Revenue[time=this-12:this-1], 

you can ensure that it pulls revenue data for the previous 12 months, with the ending month being the one immediately preceding the current month you’re analyzing.

Beyond time-based adjustments, you can also use account attributes to fine-tune your calculations based on groupings or classifications associated with the data. For example, if you want to calculate revenue specifically for a particular region, you can apply an attribute filter like

 ACCT.Revenue[Region = North] 

to pull in all revenue data associated with accounts tagged with the “North” region. This allows you to create more granular and targeted reports, tailored to specific attributes or dimensions within your data.

These modifiers help ensure that your formulas are more flexible, powerful, and specific to your needs, providing deeper insights and more accurate reporting.

Revelwood is more than just a Platinum Workday Adaptive Planning partner — we’re a trusted advisor to the Office of Finance. With 30 years of experience and award-winning expertise, we bring together powerful software, proven best practices and pre-built, ready-to-deploy solutions that accelerate time to value. Our team doesn’t just implement technology — we help finance teams transform the way they plan, analyze and make decisions. Discover how Revelwood can help you get the most out of Workday Adaptive Planning — and achieve results that matter.

Read more Workday Adaptive Planning Tips & Tricks:

Understanding Drill Down in Web Reporting

Using Integration to Hard Code Calculated Values

Scheduled Report Notifications with Attachments

Home » Planning & Reporting