Posts

Budgeting_Process_Best_Practices_White_Paper_Solver

The unexpected events of 2020 — and the resulting economic uncertainty — demonstrated that financial leaders across the globe must be able to operate with greater agility. But many finance leaders are still struggling to gain insight into their business futures.

Outdated processes, time-consuming input methods, and overly complex Standard Operating Procedures (SOPs) are just some of the many issues resulting in unclear decision making and a feeling that all future financial plans are simply “guesswork.” Added together, these issues are likely to result in unsuccessful and unrealistic Annual Budgets.

Savvy financial leaders understand that today’s rapidly and drastically changed business landscape requires rapid and drastic changes to the budgeting process in response… but it can be difficult to determine what the best steps are when the future is so uncertain.

If you are ready to transform your Annual Budgeting process to a more agile, more responsive, and more streamlined set of procedures that you can leverage for greater planning confidence, check out these budgeting process best practices compiled by experts.

cash flow trended rolling financial report

Cash Flow report that dynamically displays the past 13 months

What You Will Learn in This Document

After reading this document on budgeting process best practices, you will be prepared to handle uncertain economic futures with greater levels of confidence. You will know what steps to take, and in which order, to set the stage for a successful Annual Budget process – and you will have a good handle on the various approaches you can take for budgeting at your company.

This document is detailed and lengthy, meant to guide you every step of the way through this year’s Annual Budget process and beyond. You may prefer to print out the full document or save it directly to your tablet, so you can use it as a reliable reference piece for the next few months and years.

Ready to get started? Let us begin by talking about why having a strong process matters for your Annual Budget activities and what may be “broken” in your current process.

Year-End Forecast in the Solver Process Manager shows one example of how you can follow budgeting process best practices to stay ahead in uncertain economies

Situation Analysis and Year-End-Forecast sample budgeting process

Understand the Power of Strong Process Management

Processes are powerful. In fact, effective processes often form the essential difference that gives many of today’s leading companies their competitive advantage. When implemented properly, a strong process will lead to strong action and strong results.

Most companies can strengthen their Annual Budget process. Doing so leads to numerous benefits, including:

  • Faster, more informed decisions
  • Improved accountability
  • Significant resource and time savings
  • Revenue and profit acceleration

Do those benefits sound like a fantasy? They are actually relatively easy to achieve – as long as you and your team are ready to put in the work focusing on budgeting process best practices that help you develop strong processes.

Best practices recommend that you have:

  • Well-defined Corporate Performance Management processes
  • Clearly stated process owners
  • Precise due dates for tasks and/or processes
  • Transparency – meaning that processes are easy to access and view by stakeholders
  • Full accountability

This document will explain how you can set up a strong Annual Budget process for your company – but let us first look at the obstacles you may come up against while trying to set up your own processes.

budget accuracy comparison

Compare budgets from prior years to analyze ACCURACY before the new budget process.

Find Out Now: Is Your Annual Budget Process Broken?

No matter where your company is located globally, your finance department shares at least one commonality with every other finance department in the world: you are extremely busy.

Due to a massive workload, constantly looming month-end-close deadlines, and a staggering number of manual processes, finance departments often delay process and procedure reviews or updates. This means you may be maintaining cumbersome, outdated SOPs for far longer than necessary.

Traditional financial planning processes rely on analyzing historical records and trends, entering data manually into Excel, and running quarterly reports on what already happened to see what might come in the future. These processes are slow and, to be frank, today’s finance departments do not have the time or economic certainty to place much trust in sluggish processes.

Working in today’s rapidly shifting economic environment, slow processes are likely to “break” your budgeting process.

Is Your Budgeting Process “Broken?”

Find out if your budgeting process is broken when you check to see how many of the following warning signs your process exhibits:

  • You are using Excel almost exclusively
  • You do not have a central database for Annual Budget data
  • You run into broken links too often for comfort
  • You have limited security due to the ability to freely share Excel files
  • You have multiple versions of the same Annual Budget and have troubles determining which one is the final one
  • Your users and stakeholders miss deadlines (lack of accountability)
  • Your process delivers limited, if any, guidance on goals and strategies that impact the annual plan
  • Your input process does not allow supporting details to be entered for context
  • You experience a lack of communication between departments, leading to siloed planning in a synced-up world
  • You suspect that some department leaders may be focusing on their own interests and participating in gamesmanship or sandbagging

Did any of these warning signs sound familiar? By using a Corporate Performance Management solution like Solver, you can easily fix these problems with:

  • A cloud and web browser-based platform that encourages full collaboration
  • Line item detail and comments for context and other information
  • Capture and display of strategy and KPIs for clear guidance
  • Process management and workflow tools
  • Protected web forms for solid data security
  • Automation for scenarios and more
  • Top down/bottom up planning flexibility
P&L variance report with charts and KPIs profit & loss

P&L variance report with modern design gives users quick KPI highlights with charts.

9 Budgeting Process Best Practices

The key to solving issues and fixing your “broken” Annual Budget process is to be prepared to accomplish more agile, streamlined, and modern budgeting. Best practices suggest that you begin your preparations with clear steps, to be completed in precise order.

In the next sections, you will learn what each of those steps are.

1. Begin Your Preparation Checklist

Preparation_Checklist_Process_Manager

Make sure you complete a preparation checklist before starting on your annual budget

Success is much more likely if you have prepared for a successful outcome. When you feel you are ready to transform your budgeting process to achieve success in times of economic uncertainty, simply return to this section and write down each step in this Preparation Checklist.

Pave the way to success for your Annual Budget by following these steps:

  • Finalize and communicate your strategies, goals, timelines, and targets
  • Create a “project plan” for your Annual Budget
  • Complete an end of the year forecast (see the next section for details)
  • Empower managers with the ability to manage their own department financials
  • Modify and test any templates, and make sure they are available to all team members who need them
  • Add any new users and verify their security settings
  • Confirm all data is appropriately accessible
  • Start early – we all know that the early bird gets the worm!

You can do all this manually of course, but it is much easier and faster to complete these steps using a purpose-driven tool like the Solver Process Manager.

The Solver Process Manager makes it easy to create checklists, assign tasks to various personnel, and enjoy full transparency and access with secured, cloud-based checklists that are readily available to authorized users.

2. Complete Year-to-Date (YTD) Analysis and Forecasting

financial management software dashboard

P&L report with actual, budget, last year and variances.

To know where you are going, you must start by knowing where you are. In a time of economic uncertainty, this is easier said than done – but it is certainly not impossible.

When you take a deep look at your current performance, you can then gain a reasonably accurate initial glimpse into your future by forecasting potential scenarios and performing a fundamental analysis.

Not sure where to start with this process? Here are some tips drawn from best practices recommendations:

Look at Your Current Performance

  • Have department managers review their financials
  • Understand current and future headcount needs
  • Determine Sales team productivity
  • Dive into Marketing effectiveness

Run a Realistic Forecast

  • Perform a 7+5 forecast in August (with 7 actual + 5 predicted months)
  • Set corporate strategies and goals for next year (see the next section for details)
  • Forecast through next year to provide vision and insight
  • Check your forecast accuracy and identify any potentially overlooked areas

Perform a Fundamental Analysis

  • Start your analysis now to ensure that you are ready for your Annual Budget process in time
  • Review assumptions and the accuracy of your prior year’s budget
  • Review all contracts, especially ones for recurring revenue
  • Assess how current and future strategies may impact your new hires and promotions

When you are ready to begin your YTD Analysis and Forecasting, a Corporate Performance Management solution like Solver can assist by delivering a range of easy-to-use templates and reports, including:

3. Set Your Strategic Goals

budget strategy target goal KPI

Enter strategies and then enter the associated goals.

One of the most important budgeting process best practices tasks lies in setting strategic goals for the next year. This is a task largely for Executives and Board members, who must set goals based on strategies and initiatives and take various factors into account.

When setting strategic goals, Executives and Board members should make sure to carefully consider:

  • Revenue growth
  • Cash flow
  • Profitability
  • Investments
  • Unique critical financial areas

Once strategic goals have been set, they must all be clearly communicated to the management team and special care should be taken to ensure that all managers are on board. All feedback should be taken in by the Board and Executive team, with willingness to modify the goals as needed.

After goals are agreed to, the Executive team should work with the management team to set specific departmental goals based on corporate targets. Both groups are likely to gain more from this exercise if they concentrate on the “how” when determining initiatives, instead of simply focusing on the “what,” as they may have done in prior Annual Budgeting cycles.

Note: Budgeting process best practices recommend that Annual Budget planning should NOT start until this last step is finalized and agreed to.

It can be difficult to set executable strategic goals in times of deep economic uncertainty, but a Corporate Performance Management solution like Solver can help by providing various reports and forms that help you capture multiple scenarios (e.g. “High,” “Low,” “Mid”) and communicate your strategy and goals clearly and concisely.

When assessing a Corporate Performance Management (CPM) solution for your strategic goal-setting process, ensure that the tool you choose includes, at the very least:

budgeting software dashboard for businesses

KPI report for analysis of budgets vs strategic goals.

4. Select Your Best Budget Input Process

Once all prior steps and preparation tasks are complete, it will be time for you to officially begin your Annual Budget process.

You have two ways you can approach your budgeting process: top down or bottom up. It is important to note that neither of these approaches is “better” than the other – they each simply address different ways of looking at the same budget planning puzzle.

In best practices organizations, both methods are used:

  1. First the office of finance creates the top-down budget and disseminates it to department managers as a “baseline” budget.
  2. Then each department makes a bottom-up budget, either by revising the top-down budget or as a new budget version in the system. The latter is recommended, as managers can then later compare the two versions and see where there are differences.

Top Down

The “top down” budget process focuses on modeling expected outcomes at the senior management level and working down to the details from there. Top down forms a more “high level” view, which can be useful if departments don’t have the time or precise details to build a “bottom up” budget.

During situations of economic uncertainty, top down input can help senior management save significant time in generating a budget. By using top down methods, you can create an initial budget that reflects your initial assumptions, and then regenerate your budget quickly and repeatedly in response to fluid, rapidly changing circumstances.

Three important areas to focus on in a top down input method would be:

1. Workforce Modeling

payroll workforce headcount budget input

Enter key information and let the form calculate monthly salaries, benefits, taxes, etc.

In this modeling scenario, you would generate an analysis of your future workforce needs. In uncertain economies, it is of the utmost importance that you understand precisely how much staff you can and should afford, and that you know which staff members and functions are critical to your strategic goals.

Workforce modeling helps you achieve clarity on your workforce requirements by challenging your assumptions with hard data and presenting crystal-clear Profit & Loss reports based on specific workforce drivers.

2. Profit & Loss Modeling

Profit and loss P&L forecast revenue expense driver breakback

Enter target Net Income and the form’s algorithms automatically creates the forecast.

In this scenario, you would enter in your profit targets and then break them back into Revenues and Expenses, so you gain a clear understanding of whether or not your profit targets are realistic.

3. Cash Flow Modeling

Power BI dashboard liquidity cash simulation forecast

Simulation of cash flow with sliders where the user can increase/decrease any component.

In this scenario, you can use your Profit & Loss and Balance Sheet items to arrive at a target Cash Flow that can help you gain planning insight. The benefit of utilizing a scenario in this process is that you can easily reiterate your Cash Flow expectations based on your evolving strategy and likely outcomes.

Simplify your top down budget input process with a range of top down, driver-based forms from Solver, including:

corporate forecasting software dashboard

Input of expenses at the GL account level. Includes line item detail, spreading, etc.

Bottom Up

Bottom up budgeting includes more details and departmental input and can open the door for Zero-based budgeting at the micro level, which may be of significant benefit during times of uncertainty. The detailed numbers that go into a bottom up budget can help departments and management gain precise insight into exactly where spend is going and revenues are coming from, helping you to tighten margins while planning necessary expenditures with confidence.

There are two approaches you can take for your bottom up budget input. Of course, choose the method that works best for your needs.

1. Waterfall Approach

In this methodology, certain stages must be completed before others can be started. First, your Sales and Marketing plans will be completed, including your pipeline and headcount/expense data. After that, you’ll move to your Revenue plan.

Once all these plans are completed, you will have the data you need to accurately plan your department budgets, which you can review and revise as needed once they are finished.

The Waterfall method is more time consuming, but it has the potential to deliver deeper insight due to its comprehensive, staged approach.

2. Concurrent Approach

In this methodology, all departments enter their plans concurrently, based on strategies and goals.

As plans are entered, they are consolidated into one master version, which is opened up for review and revisions as needed.

The Concurrent method is faster to complete, but it may result in more superficial insight. This is not necessarily a bad thing. In fact, superficial insight may be more beneficial than taking the time for a deep dive if you are dealing with constantly changing numbers that you expect to update.

Whether you choose the Waterfall or Concurrent approach, a Corporate Performance Management solution like Solver can help make your bottom up budget input faster and easier with a range of input forms and workflow tools.

A good Corporate Performance Management solution should provide budget input resources for:

P&L estimate report forecast budget profit & loss

Compares actual to forecast and budget, and compares full year budget to actual + forecast.

5. Plan Carefully in Times of Uncertainty

Of course, there is an elephant in the room here as we discuss budgeting process best practices. Namely: Can a company expect accuracy from an Annual Budget process if they are basing all their numbers and planning on what seems like guesswork?

The answer, you will be pleased to learn, is YES.

In fact, following budgeting process best practices is even more important in times of economic uncertainty, or in times when it feels like you are relying on “guesswork.” Only by using the scientific method of critically thinking about the possibilities, modeling scenarios based on your assumptions, and using those models to plan for a range of possible outcomes can you prepare for success in an uncertain future.

In business, the future is often uncertain. A global pandemic is not the only economic uncertainty you will experience throughout the life of your company – in fact, it is simply one of many unexpected situations, including:

  • Heavy M&A activity
  • Paradigm shifts
  • War
  • Recessions

The key to “weathering the storm” no matter what the future may bring, lies in adequately planning for all possibilities. Therefore, best practices for your budgeting process should include the following stages:

  • Seek feedback from business units prior to setting targets.
  • Plan “static” items early and delay highly variable items. (It will be easier to guess the future with more accuracy when the future is closer.)
  • Allocate most of your time to high value areas, such as Revenue and Cash Flow.
  • Consider starting off with quick, high-level budgeting and then moving to monthly forecasting. This can lead to higher accuracy in your budgeting process.
  • Use contingencies for budget assumptions (e.g. if/then).

The great news is that, if you plan and prepare properly to transform your Annual Budget process, you can achieve phenomenal results, even in times of economic uncertainty.

kpi report budget last year forecast variances

Detailed KPI report with actual and budget variances.

6. Enjoy 4 Key Outputs of a Successful Annual Budget

As you know, you must make your own success. By following the budgeting process best practices in this document, you will be well prepared to ensure that your Annual Budget is successful even in times of economic uncertainty.

You will know you have transformed your Annual Budget process for the better when you achieve these 4 key outputs:

  1. Your managing team joins together in a “rally cry” to meet operating targets with a monthly review that keeps them accountable and on track for success.
  2. Your plans are aligned across the company and are fully executable on both a macro and micro level, and you achieve outcomes for the company and by department.
  3. You measure and address performance continuously using Key Performance Indicators (KPIs).
  4. You see positive results from your regular budget reports and analyses, including:
    • Profit & Loss, Balance Sheet, Cash Flow
    • Key Performance Indicators
    • Workforce plan
    • Departmental budget details (revenues and expenses)

With a market-leading Corporate Performance Management solution like Solver, you can track your success using targeted budget reports and KPI tools, including:

Budget_Process_Analysis_Process_Manager

Analyze your budget with reports and dashboards

7. Treat Your Annual Budget Like a Project

Considering the level of continuous measurement, tracking, and accountability involved in the budgeting process best practices covered in this document, you may think that the modern and resilient Annual Budgeting process sounds more like project management than pure financial management.

Guess what: It is!

In times of uncertainty as well as during “business as usual,” you have the opportunity to streamline your budget process, improving both accuracy and agility, if you follow good project management discipline.

Therefore, make sure you follow these best practices during your planning process:

  • Create a clear project plan using the Solver Process Manager or another tool.
  • Maintain short cycles for deliverables.
  • Hold stakeholders accountable for delivering by deadlines.
  • Complete weekly management team reviews on progress.

Make sure that you do not stop there. You must also keep a close watch on what the shifting numbers and weekly reviews indicate.

8. Always Challenge the Numbers

One of the best methods for maintaining Annual Budget planning agility is to keep all stakeholders engaged with the budget at all times. This means that your entire management team should stay active in not only meeting their own goals but should also be active in helping other departments across the company meet their goals better.

Increased cross-departmental engagement can reduce potential gamesmanship, sandbagging, and other competitive tactics within the company, helping the entire enterprise achieve success in the best, most holistic manner possible.

Encourage cross-departmental teamwork by having everyone challenge the numbers:

  • Managers should review their own department as well as interrelated departments.
  • Be sure to set up isolated initiatives to accurately assess granular incremental return (ROI) and track initiative results closely.
  • Question everything to ensure that everyone fully understands and agrees to the final budget and strategic tactics for meeting budget expectations.
  • Create different scenarios and assign probabilities to each. Try to align scenario probabilities to Board expectations, such as in the following examples:
    • High growth: 60%
    • Special event (like acquisitions, recessions, etc.): 30%
    • Break even (e.g. because of likely recession): 20%
Scenario_CFO_Board_Planning-SubscriptionSales-1

When you plan scenarios and challenge the numbers, make sure you keep a careful record of what you decided.

As you will see, using the tools included in Corporate Performance Management solutions like Solver will make challenging the numbers easier:

9. Invite Executive and Board Feedback Early On

These budgeting process best practices should help your finance team and the entire company create a better budget, more quickly and accurately than you would if you were using the “broken” processes and methods we mentioned earlier – but remember that creating the Annual Budget is only one part of your total task.

In times of economic uncertainty, it can be nerve racking to present your finished budget to the Board and Executive team and to elicit feedback from them. By following the best practices outlined throughout this document, you can improve your process, your outcomes, and your confidence levels… and with these final tips, you can also improve the success of your Board approval process.

Here are three tips that can help you better ensure that your Annual Budget will be approved:

  1. Be prepared with all of the numbers, as well as the “how” and the “why” behind those numbers.
  2. Include the Executive team and Board members early on in the process, using active communication to minimize noise at the approval stage.
  3. Accept Board and Executive challenges to revenue or expenses if you know that the “how” of achieving them can be developed once the budget is approved.

A Corporate Performance Management solution, such as Solver, can help you ease the Executive and Board feedback and approval process using a unique combination of software features and capabilities, including:

  • Executive comments
  • Department feedback
  • Status tracking
Budget_Comments_Resolutions-1

Plan for various scenarios, so you are more likely to be prepared for whatever happens.

Get Started Today with a Sample Budget Calendar

Ready to get started now? Smart choice.

Here is a sample budget calendar that you can use to begin setting up your streamlined process. Feel free to model your own calendar after this one. Make sure to include all applicable stakeholders and realistic deadlines to encourage full accountability.

Budget_Calendar_Example_Solver

Using the Solver Process Manager, Budget Managers can easily and quickly create reasonable budget calendars that hold staff accountable to deadlines.

Now Is the Time to Start Your Annual Budget Process

As they say, there is no time like the present. When it comes to crafting your Annual Budget in times of economic uncertainty, this advice is more important than ever before.

To ensure the most successful outcomes for your Annual Budget process, follow these summarized steps, in order:

  1. Start preparing now
  2. Execute your Annual Budget planning like any other internal project
  3. Challenge all assumptions, so you can align goals and expectations
  4. Communicate with all stakeholders at every step
  5. Ask questions early

And, of course, make sure that you ask for help when you need it so you can stay on track when you run up against unexpected obstacles.

For that last one, and for every step along the way, the budget planning experts at Solver have got you covered. With Solver, you will have access to hundreds of financial planning templates and reports, plus our extensive template glossary and experienced staff who are always happy to share their expertise.

If you have questions about how you can streamline and improve your Annual Budget process with budgeting process best practices, our support experts are ready to help you get the most out of Solver’s flexible and robust financial planning tools. Solver is committed to helping you set up your Annual Budgeting process for success, so you can maintain more certainty about your business’s financial future.

Reduce uncertainty and fix your budget – here’s how.

These days, more than ever, financial planning analysis (FP&A) managers need to deploy tools that can help them support their businesses with faster and more agile planning, reporting and analysis.

Whether it is functionality that supports forecasts with multiple scenarios or automated financials with self-service drill down, today’s managers need easy access to the right information so that they can make faster and better decisions.

So, many organizations that run legacy corporate performance management (CPM) tools like SAP BPC or massive, manual Excel models that are at the breaking point, are now looking to migrate to a modern cloud platform for their budgeting, forecasting, reporting and consolidations.

Current Trends are Driving Digitalization of the Office of Finance

Now, in the 2020s, there are a number of trends that are driving changes and technology upgrades in finance and accounting departments.

The most obvious change surrounds the turbulent economic climate. This environment has accelerated the trend towards working-from-home, which again has accelerated the need for users to have easy, browser-based access to their business applications, and for IT departments to get rid of their old servers and move to a cloud infrastructure that runs 24/7 with minimal down-time.

Many FP&A departments also face staff shortages due to cost-savings programs. This drives them to consider upgrading their legacy accounting and CPM tools to modern cloud tools that drive more automation and that are more user-friendly than their old, on-premise counterparts.

Benefits of Migrating from BPC…and A Little History

Companies that acquired SAP’s Business Planning and Consolidation (SAP BPC) solution in the past considered it a good investment. Outlooksoft as it was called in the beginning, was a young, agile Connecticut-based company founded in 1999. They had a number of people that came from Hyperion, its main competitor in those early days. Outlooksoft quickly rose to stardom on the CPM scene. In 2007, the company was acquired by SAP and its name changed to SAP’s Business Planning and Consolidation solution. Outlooksoft had a very good run as a general CPM solution from 1999 and up until its SAP acquisition. After that, BPC went from a mainstream CPM tool to a solution primarily sold to SAP’s ERP customers.

However, today, more than 20 years after SAP BPC was launched, its core, built-for-on-premise deployment, with a mostly Excel and OLAP architecture, is a far cry from modern, multi-tenant cloud solutions that run and are maintained in global, 24/7 accessible public clouds. Because of these limitations, a number of companies are now looking to migrate from SAP BPC to a new, agile and cloud-based CPM platform.

Where to Migrate your Planning and Reporting Processes to?

Generally, companies migrate from SAP BPC to cloud CPM solutions that are pre-integrated to their ERP solution. This ensures that a good, automated integration can be put in place quickly and that the integration is updated by the vendor whenever the ERP system may require changes.

For example, a company like Solver, specializes in cloud CPM for ERP solutions like SAP Business One, SAP ByDesign, Sage Intacct, Netsuite, Microsoft Dynamics 365 Finance, Microsoft Dynamics 365 Business Central, as well as the legacy Microsoft Dynamics ERPs AX, GP, NAV and SL.

Apart from ensuring that ERP connectors already exist for the ERP you are running, many companies usually also check that their new cloud CPM vendor has a good review in industry market studies like Dresner Advisory Service’s Wisdom of Crowds Enterprise Performance Management Study.

And, of course, the power users that will administer the new cloud CPM solution always want to make sure that they  can design all the budget models and reports they need for their users. Such discovery typically happens through demonstrations as well as research conducted by looking at videos and examples on the vendors’ websites.

Regardless of the journey you decide to take to prepare your planning and reporting processes for a more automated and digitalized office of finance, you have many good options to evaluate as you plan the replacement of SAP BPC and move to a modern multi-tenant cloud CPM solution.

Blog header image showing a woman with binoculars for the Solver blog on how to use monthly rolling forecasts to gain insight in unpredictable times

According to the 2020 Wisdom of Crowds Enterprise Performance Management Market Study, adoption of enterprise management software increased in 2020. Nearly half of all surveyed organizations now use enterprise performance management (EPM) / corporate performance management (CPM) software, and 78% of survey respondents rated this software as “critical,” “very important,” or “important” to their organization.

Of course, enterprise and corporate performance management software is always useful for Finance and Operations planning, especially during the annual budgeting process, but in a time of economic uncertainty, the budgets that your organization created 12-18 months ago can seem stale and out of date.

Flexible monthly rolling forecasts, which are almost exclusively found in market-leading EPM / CPM software, help keep your Finance and Operations planning fresh and on track throughout unpredictable times, so you can enhance your budgeting agility and maintain your competitive edge.

View templates for forecasting and other critical planning processes.

Why Use Monthly Rolling Forecasts?

“Enterprise performance management software can help organizations manage short-term uncertainty and plan their strategies for the ‘new normal’…” – 2020 Wisdom of Crowds EPM Market Study

Rolling forecasts empower business leaders to continuously plan for the future with insight into the next 12-18 months. Using up-to-date historical data, rolling forecasts can help cultivate more agile organizational planning that helps illuminate how short-term disruptions and adjustments may affect long-term objectives.

In essence, monthly rolling forecasts help companies plan their strategy to overcome economic uncertainty by providing a continuously updating glimpse into the potential future.

Compared to the typical annual budgeting process — which relies heavily on assumptions generated in the past and marches steadily into an unknown future somewhere past the “fiscal cliff” — it is clear why rolling forecasts are critical to success in uncertain times.

Rolling Forecast Usage Is Likely to Increase Due to the Events of 2020

The Wisdom of Crowds study reports that 64% of respondents use rolling forecasts today, and 16% say they have now replaced annual budgets with rolling forecasts (an increase of ~15% YoY). Considering the ongoing disruption caused by COVID and global economic uncertainty, the adoption of monthly rolling forecasts is likely to increase more in 2020.

Would rolling forecasts be right for your organization? Here are a few reasons to consider utilizing this critical tool as a budget manager or executive:

  • Monthly rolling forecasts deliver timely insight based on the recent past.

When you planned your 2020 budget, no one had heard of a coronavirus – and you certainly did not expect a coronavirus to shrink the GDP, disrupt global supply chains, or quarantine your workforce in home offices. It is time to recalibrate your numbers.

Now that all this has happened, a monthly rolling forecast can help you strategize what to do next, whereas that annual budget will offer little to no help.

  • Rolling forecasts can report on current usage of allocated budgets.

Considering the myriad changes listed above, there is a high probability that your company expenditures have strayed significantly from expectations. For example, your company has probably spent less on conferences and travel. Can you re-allocate those budgets?

Department managers may be hesitant to initiate a conversation with you about the amounts still available in their allocated budgets, but a monthly rolling forecast can shine light onto usage (or lack thereof), so you can plan properly.

Why Not Use Rolling Forecast Tools Built into Your ERP System?

If you are running cloud ERP systems like Microsoft Dynamics 365 Finance, your company has a great accounting system. So, why not use the rolling forecast tools built into your ERP system? Simply put, there aren’t many available. That is why more than 90% of the organizations create their forecast models outside their ERP in manual Excel spreadsheet models.

Now, if it fills your needs, there is cash-flow forecasting and sales forecasting included with some ERP systems, including Dynamics 365 Finance implementations, but no forecasting is available on Government Community Cloud (GCC). If you are a Government agency or you want to use rolling forecasts for a wide variety of Operations and Finance areas, it is a smart idea to invest in a purpose-built, flexible and robust market-leading corporate performance management solution that can provide you with the in-depth insight you need immediately.

Next year’s annual budgeting process is here now, yet leaders across the globe still have few answers or concrete plans to address our uncertain future. The best way for you to plan your organization’s budget is to develop your own glimpse into the future… and the best way to do that is with monthly rolling forecasts.

Make Smarter Decisions Now Using Monthly Rolling Forecasts from Solver

With the current situation, you cannot wait to “see what happens.” Forecasting templates from Solver help you get started with this helpful tool quickly, so you can take a proactive role in your Finance and Operations planning processes.

Rolling forecasts from Solver are fully integrated with a number of ERP systems, including Microsoft Dynamics 365 Business Central and Microsoft Dynamics 365 Finance (f/k/a Microsoft Dynamics 365 Finance & Operations), and they provide an easy way for you to look forward into what you can expect next year, so you can plan appropriately.

 

Discover the facts on forecasting during economic uncertainty with this handy how-to from Solver.  

While mid-market and enterprise resource planning (ERP) vendors offer native financial consolidation software, their limitations often leave users still in search of a solution that can produce.

Here are a few reasons why it has been difficult for ERP vendors to deliver the financial consolidation functionality inside the ERPs itself.

Common Limitations in Current Financial Consolidation ERPs

  • Problematic to consolidate across subsidiaries with different ERPs
  • Clunky consolidation process with too many steps
  • Manual consolidation adjustments, which can be tedious to post
  • Inability to handle different chart of accounts
  • Weak auto-elimination functionality
  • Limited currency conversion functionality
  • Weak financial report writer to produce the consolidated reports
  • Lack of dynamic pro-forma consolidations
  • Inability to consolidate across subsidiaries with different fiscal calendars

Overall, consolidating within your ERP system remains a clunky process with too many steps. As a result, an organization’s finance team ends up carrying out the process in Excel, where they are likely comfortable using formulas.

Your ERP’s Current Consolidation Solution

Even with many popular ERP systems such as Microsoft’s Dynamics 365 Finance and Operations (D365 FO), SAP, Oracle or Workday, customers with significant consolidations and related financial reporting needs often end up depending on Excel, especially in the final steps of the process.

While ERP systems typically contain many consolidation features, and might even have a native Management Reporter that is an above-the-average report writer, it is increasingly normal that customers add on a “best-of-breed” corporate performance management (CPM) solution to simplify their financial consolidation and reporting software.

Modern cloud-based CPM solutions

Solver is an example of a CPM solution that comes with several added advantages, especially for Microsoft customers.

Advantages of Solver CPM for Financial Consolidation

  • Solution is cloud-based Azure
  • It’s configurable to general ledgers as well as sub-ledgers
  • It has a pre-built connector to Power BI for visualization

PowerBI_Dashboard_01

 

Some cloud-based CPM vendors like Solver now also offer an Excel add-in to give power users more flexible and familiar report design.  Additionally, in some CPM solutions, end users can still run the same reports in the cloud using their web browsers. They could do the same using their local Excel on the desktop connected to the CPM database in the cloud.

Additionally, modern cloud-based CPM solutions typically house advanced budgeting and workflow capabilities. This allows for a single solution and a single report/form designer for financial reporting, consolidations and budgeting.

Upgrade Your ERP System With Solver

To learn more about how modern CPM solutions integrate with popular ERP systems like D365 F&O and Business Central, Sage Intacct, SAP and Accumatica, click here.

LOS ANGELES, CA. – February 18, 2020 – Solver, a global leader in cloud and web-based Corporate Performance Management (CPM) for mid-market ERP systems, today announced the launch of its new Hybrid Cloud Connector for the Microsoft Dynamics GP ERP system.  Solver’s Hybrid Cloud Connector is a unique cloud-based solution which enables Dynamics GP users to run real-time financial reports in Solver’s cloud by directly connecting to their hosted or on-premise GP database.  With no intermediate loading and storing of data like the majority of cloud-based reporting solutions, Solver’s Hybrid Cloud Connector offers a flexible solution to Microsoft Dynamics GP users.

Solver’s Hybrid Cloud Connector consists of two unique technologies:

  • A pre-built integration to both general ledger (GL) and sub-ledger data with friendly field names users are familiar with from within Dynamics GP — instead of technical SQL table names.
  • A Gateway that securely connects reports run from the Solver Cloud Portal directly to the on-premise or hosted Dynamics GP database.

Solver is also excited to launch the Hybrid Cloud Connector for Dynamics GP in part because very few cloud-based reporting solutions today are capable of doing real-time reporting for an on-premise ERP system.  Beyond reporting, the Solver Hybrid Cloud Connector is also ideal for organizations looking for a General Ledger (GL) budgeting and forecasting solution which can save budget and forecast updates directly into Dynamics GP. With this new connector, Solver adds more flexibility and functionality to its CPM solution.

“In some ways, for customers using Dynamics GP, this is what almost all accountants want, which is a modern reporting solution with real-time connection to their GL and sub-ledger data” says Nils Rasmussen, CEO at Solver. He continues “And because the Solver solution is cloud-based, there is no software installation required for the end-user, just a web browser. This means that users can now run their GP reports from any web browser and drill down to detail from anywhere at anytime without VPN, Terminal Server or Excel add-ins. Anyone tired of Management Reporter/FRx, Excel add-ins or other on-premise report writers now has a modern cloud option without losing their real-time access to GP data.”

In the near future Solver will also release this real-time cloud-to-on-premise integration technology for other ERPs, including Dynamics NAV/D365 BC, Dynamics SL, and several SQL-server-based ERPs from Sage and SAP.  In the meantime, Solver expects its Hybrid Cloud Connector to further enable Microsoft Dynamics GP users to make better, faster decisions in their financial reporting.

 

About Solver

With a quickly growing community of thousands of global customers and hundreds of partners worldwide, Solver provides a leading cloud Corporate Performance Management suite for Microsoft Dynamics 365 Finance and Operations and Business Central, Acumatica, SAP Business One, SAP ByDesign, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, NetSuite and other ERPs. Solver is ranked in the leader quadrant in the Corporate Performance Management (CPM) Software Grid on G2, and as a Microsoft Gold ISV Partner, Solver has won countless awards, including the Microsoft BI Partner of Year Award, recognition on the Gartner Group CPM Magic Quadrant, and Best Places to Work for a workplace culture that celebrates customer service, integrity, and innovation. Solver is sold through its 12 global offices and a worldwide network of partners. For any questions, visit www.solverglobal.com or contact Solver at info@solverglobal.com.

powerbiandsolver

If you have ever tried to build and maintain financial reports inside a visualization tool, the answer should be simple. Power BI works well for dashboards, but modern cloud-based corporate performance management (CPM) solutions are the best option for your financial reports.

BI vs. CPM

Let’s elaborate. Power BI belongs to a category typically referred to as Business Intelligence (BI) tools. While purpose-built, financial reporting and consolidation tools belong to a category referred to as Corporate Performance Management (CPM) Software.

Business Intelligence:

In the business intelligence category, you also find other well-known solutions such as Tableau and Domo. For the most part, BI tools are purpose-built for dashboards with rich visualizations. Also, BI tools are increasingly infused with artificial intelligence (AI) capabilities.

Corporate Performance Management Software:

On the other hand, CPM solutions are specifically designed for accounting teams to consolidate financial data. CPMs often produce professionally formatted financial reports such as: 

  • Profit & Loss
  • Balance Sheet
  • Cash flow statements

Most CPM reporting tools offer budgeting modules. And in recent years, the ability to do sophisticated planning such as sales forecasting and modeling.

If the difference between BI and CPM is so clear, why is “Financial Reporting in Power BI or in a Corporate Performance Management Solution” even a topic worth covering in a blog? 

Well, with the rapid rise in popularity of Power BI for financial reporting and its key competitors, an army of “hungry” consultants have emerged.  And, given a strong and flexible tool like Power BI, a sales person with the right technical skills can make almost anything, including formatted financial reports, look good.  Many companies have fallen into this trap lately of using Power BI for financial reporting. And, when you ask a skilled, revenue motivated consultant: Can you do that? Chances are that you will get a “Yes!”  And after a few weeks…or a few months, and a sizable consulting bill, you may actually have good looking Power BI financial reports.  But, as excited as your executives may be to have a single cloud-based portal for both dashboards and financial reports, for most financial executives this has a tendency to turn into a small nightmare.  Why?

Because neither Power BI nor its BI competitors were designed to manage a financial reporting process.

A lot of hard coding and hacking is needed behind the scenes in Power BI’s modeling language. Of course, if you are ready to hire a technical expert or keep your Power BI consultant permanently retained to handle model changes as your chart of accounts grows, your roll-ups change or you need to write a new report, you could survive for a while. Eventually, we can say with certainty, you will be back in Excel to do your financial reporting where your accounting team is comfortable with formulas and formatting.

Alternatively, you can deploy a CPM solution that is built to streamline the financial process. Also, you can deploy a CPM tool to deliver professionally formatted financial statements.

With a CPM solution, you can also move your budgeting process into the CPM tool and run it all in the cloud.  Now, it does not have to be an either or.

The Best Way: Use BI Tools and CPMs Reporting Tools Together

An increasing number of CPM vendors offer pre-built integrations to leading BI tools like Power BI.

Two such vendors are Solver and Prophix. As an example, Solver is similar to Power BI in that it is an Azure cloud-based platform, and it comes with a pre-built connector to Power BI.  Below is an example of a comparison between Power BI and Solver. It clearly shows that companies looking for both dashboards and financial reporting should use a BI tool for their dashboards and a CPM tool for their financial reporting. Neither tool replaces the other.

power bi and solver

As organizations gear up for what can be the “Roaring Twenties,” having the right tools for the job might be one of the smartest strategic moves a management team can make. On the other hand, trying to fit a square peg in a round hole, could lead to frustration. The frustration is delayed reporting and wasted money. It is increasingly accepted that “data is the new gold.” When Power BI is integrated with a best-in-class CPM solution and both are running in the cloud, organizations are likely a step closer to success and industry leadership in the years ahead.

Consolidation_01

For many years it seems like every mid-market and enterprise resource planning (ERP) vendor has aspired to offer native financial consolidation software. However, they all seem to fall short, often to the disappointment of customers that were promised that their new ERP system easily could produce the consolidated financials from their individual subsidiary ledgers. 

So why is it so hard for an ERP vendor to deliver the necessary financial consolidation functionality inside the ERP system itself? There can be any number of reasons.

Limitations in Current Financial Consolidation ERPs

  • Lack of ability to handle different chart of accounts
  • Lack of ability of consolidating across subsidiaries with different fiscal calendars
  • Poor currency conversion functionality 
  • Weak auto-elimination functionality
  • Tedious to post manual consolidation adjustments
  • Weak financial report writer to produce the consolidated reports
  • Clunky consolidation process with too many steps 
  • Problematic to consolidate across subsidiaries with different ERPs
  • Lack of dynamic pro-forma consolidations

 

It would be a controller’s dream if all of these areas were elegantly handled within their ERP system. And, while most mid-market and enterprise ERPs typically can check all or most of the boxes for consolidation features, almost always, consolidating in the ERP it is simply too clunky with too many steps. Because of this, the finance team ends up doing it in Excel where they at least are comfortable with formulas and they can produce professional report layout. 

 

overloaded manager

Microsoft Dynamics 365 ERP

But what about Microsoft’s Dynamics 365 Finance and Operations (D365 FO) ERP system? 

While it clearly can be considered one of the top cloud solutions on the market today- alongside SAP, Oracle and Workday– customers with significant consolidations and related financial reporting needs, often end up in Excel in the final steps of the process. 

While there are plenty of ERP consolidation features in D365 FO, and its native Management Reporter is an above-the-average report writer, it is increasingly normal that customers add on a “best-of-breed” corporate performance management (CPM) solution to streamline their financial consolidation and reporting software.  

Modern cloud-based CPM solutions

Solver is an example of a CPM solution that comes with several added advantages for Microsoft customers.

Advantages of Solver CPM for Financial Consolidation

  • Solution is cloud-based Azure like D365 FO
  • Its configurable to D365’s general ledger as well as sub-ledgers
  • It has a pre-built connector to Power BI for visualization

PowerBI_Dashboard_01

 

Some cloud-based CPM vendors now also offer an Excel add-in to give power users more flexible and familiar report design. 

End users can still run the same reports in the cloud using their web browsers. They could do the same using their local Excel on the desktop connected to the CPM database in the cloud.

Consolidation_01

 

An added advantage of modern cloud-based CPM solutions is that they typically also house advanced budgeting and workflow capabilities. This allow for a single solution and a single report/form designer for both financial reporting, consolidations and budgeting. 

Level Up Your Dynamics 365 Finance & Operations With Solver

In the next decade, enabling faster and better decisions will be one of the key competitive advantages. This advantage differentiates successful, growing companies from others. 

Dynamics 365 Finance and Operations, a leading ERP solution, is a great cloud-based transaction platform because it drives better data and accounting processes. A modern CPM solution with a snug fit on top of D365 FO and that compliments visualization in Power BI checks the boxes that a finance team needs to take their ERP financial consolidations and reporting processes to the next level.

Payroll-Now-Blog-Picture-1200×675
BudgetingForecasting_01

This article will provide insight into some of the key features you could expect from modern corporate performance management (CPM) solutions.

Cloud-Computing-Concept.-The-Future-Everything-from-Socket

This article focuses on modern cloud-based reporting using BI360 as an example of a solution that is affordable and enables companies to make better business decisions.