Home Resources Blog

Set and forget budgets don’t cut it. Business success demands budget forecasting.

3 mins to read
Set and forget budgets don’t cut it. Business success demands budget forecasting.

When expectations built into budgets are not delivering, then it’s time to revise. Often business people don’t realise there is an issue for weeks because viewing budget vs actual numbers can involve a lot of manual work - so it’s put in the too hard basket.  Finance obtains the actual numbers from the ERP to close the month end then manually add them to the budget figures in spreadsheets and do the comparison. It’s the same team who has spent two months bedding down a budget, who aren’t keen to poke the ‘budgeting’ bear so soon after it has been approved yet the budget is rapidly becoming  out of date.

Complex business conditions are precipitating the need to share regular budget performance companywide and to be able to reforecast based on these results. Set and forget budgets using historical data and some generic percentage change formulas don’t suffice anymore. These static budgets also renders a business plan to be ineffective to which your business partners pay little attention to - which is the opposite you want from a budget.

Fortunately, business planning  and analytics platforms are making companywide budgeting and forecasting more efficient. The platform automates the flow of data, enables finance to collaborate with business partners throughout the development of  the budget model then connect to financial statements. When all elements of the plan integrate. finance can share  regular results and  budget forecasting can be done each month.

What is Budget Forecasting?

So, what is budget forecasting? The simplest way to explain the term is the intersection between actual/current, budget and forecast numbers at any point within the fiscal year. It is more useful when business people can view these three metrics together:

  • Actuals - represent the real numbers achieved to date
  • Budget - is a company’s financial plan of intent for 12-months
  • Forecast - is a more detailed financial plan for for a set amount of time such as for the last 6 months or 3 months of the financial year

Budget forecasting benefits

Phocas Budgets and Forecasts allows your business to create a connected and collaborative budget as well as regularly track how it is performing in real-time. To do budget forecasting on this platform, a template is selected for  the budget model providing flexibility to represent the detail and complexity of your business and then   finance can easily roll it forward for continuous monthly forecasting.

Budget forecasting is a massive step-up from annual budgets that often act as a barrier to quick and direct action.

Phocas Budgets and Forecasts provides a simple way of using actual data and budgeted values to compare actual performance to budget and re-forecast the remainder of the budget period. Budgeting this way reflects the nuance of your business and encourages greater buy-in and support.

Building a model and forecasting with consolidated data 

In the below video, Dan, a business owner, chartered accountant and subject matter expert to Phocas, provides an overview of how finance might approach building a budget model in Phocas for the first time showing how the data automation works and the built-in tools for collaboration. 

 


There are also some extra total columns and buttons where the user can select;

  1. total budget and see budgeted values for the entire period
  2. actual + budget and see up-to-date actuals and use the flagpole to see the budgeted numbers for the rest of the period
  3. actual and forecast where cells turn yellow and can be edited for the future period.

Forecasting-explainer-1

Review, understand budget variance and adjust on the fly

When creating the forecast for the next 6 months, the user can review key actuals and see how they are performing to budget. It is straightforward to compare actual results to budgeted values but the most useful information comes from the analysis of the budget variances. 

In some instances, income might be doing better than planned, if this is a result of a unsustainable activity you can choose to bring the forecast back to the budget totals using the Snap back to budget button. This aligns the forecasting period with the original budgeted values.

You may alternatively decide that the increased income achieved in the early months of the year is indicative of how the business will continue to perform and therefore decide to use the Follow actuals which averages out the new performance or positive variance for the remaining period.

Once you are happy with the new forecast you can publish it with a new name and do further analysis of the new figures in your Financial Statements. Importantly you can analyze performance against budget and forecast and see how revenue targets and sales targets are also tracking.

Budget forecasting and variance analysis helps you adapt quickly, make changes when necessary and align your goals across the entire organization.

Featured eBook

Companywide financial planning and analysis

Download now
Companywide financial planning and analysis
Written by Katrina Walter
Katrina Walter

Katrina is a professional writer with experience in business and tech. She explains how data can work for business people without all the tech jargon. She is always on the look out for new ways data is being used by business people to know more and be sustainable.

Related blog posts
What is financial modeling and common models to know

What is financial modeling and common models to know

Different types of budgets for financial planning

Different types of budgets for financial planning

Why budgeting is important for businesses chasing cost control

Why budgeting is important for businesses chasing cost control

The power of consolidated financial statements

The power of consolidated financial statements

Browse by category
Key data in one easy to understand view
Get a demo

Find out how our platform gives you the visibility you need to get more done.

Get your demo today