Armanino Blog
Article

Reforecasting for Sudden Changes Using Adaptive Insights

by Mark C Wagner
March 30, 2020

During these unpredictable times, you might have to switch around your normal processes. We've been hearing from our clients about the need to do quick forecasts in Adaptive Insights. Here are some step-by-step instructions with screen shots to show you reforecasting for Sudden Changes for your business.

  1. Roll Out a Live Forecast Version
    • Confirm you are copying from the correct Original Budget Version.
    • Select the boxes for: Copy All Data, Copy Formulas, Copy Splits, Copy Modeled Rows and Copy Audit Trail History.
    • Update the Start of Plan setting to pull in Actuals through the prior month.
    • Review the user access settings.
      • Does this version need to be hidden for certain users?
    Reforecasting for Sudden Changes Using Adaptive Insights
  2. Update Input Sheets
    • Review and update the Personnel Sheet for Headcount impact and updates to Personnel Assumptions (i.e. merit and bonus attainment assumptions).Update Input Sheets
      Reforecasting for Sudden Changes Using Adaptive Insights
    • Review marketing, conference and event budgets looking at the impact of cancelled events and tradeshows as it relates to both Revenue Pipeline and Operating Expenses.
    • High-Level Adjustments: set up custom or assumption accounts to hold management increase/decrease % adjustments to incorporate into current modeled or cube formulas.High-Level Adjustments
    • Review Impact of New Forecast Version.Review Impact of New Forecast Version.
  3. Utilize Weekly Forecasting
    • Always keep Live Forecast open as working forecast.
    • At the start of each week, clone this version and rename the previous Live Forecast to [Date] - Flash and name the new version Live Forecast.Review Impact of New Forecast Version.

Have questions or need some help? Don't hesitate to reach out to our experts. For more information on how to keep your business running through disruption, visit our COVID-19 Resource Center.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Author
Mark Wagner, Consulting, Armanino
Senior Manager
Resources
Related News & Insights
IPO Prep & SOX Compliance: Instacart & Armanino Share Hard-Earned Knowledge
Webinar
Know your compliance requirements today to avoid obstacles tomorrow.

December 16, 2021 | 11:00 AM - 12:00 PM PT
General Contractor Trends to Consider in 2022 Webinar
Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Why COP26 Matters for Your Business Webinar
Webinar
Get informed of COP26 developments and how you can act now.

December 15, 2021 | 10:30 AM - 11:00 AM PT