How to Make a Live Forecast to Help You Manage Your Business Better

Like the majority of business owners, you begin the new fiscal year with an updated annual budget and forecast. You project the future as best you can, manage your expenses appropriately, and communicate your goals and projections to your team. And we are all aware of what comes next. Actually, nothing ever goes as planned. In just one month, sales have exceeded projections. You miss a couple of your goals the next time. Then unforeseen costs come up and you have to reallocate other expenses.
Quite quickly, your initial projection and budget become so disconnected from the reality of your company that you have to cease utilizing them and begin operating on the spur of the moment. Regarding your cash flow and potential for profit, you make educated predictions and expect to be correct. It's a disorganized and taxing method of managing a company.
Thankfully, there is a superior approach. You can switch to using a prediction that changes as your firm does from a static, fixed budget and forecast for the entire year. This is a live forecast, meaning it takes into account your company's actual state and provides you with a more precise and grounded vision of the future, enabling you to confidently manage it.
A live forecast offers you a clearer picture of the future together with a financial roadmap to help you make realistic decisions. It's the most effective approach to maintain control over your company and make informed decisions that genuinely encourage growth. This post will walk you through the steps of developing a live forecast for your company and show you how to use it to improve business operations.

Start with a plan vs. actual analysis

The foundation of a live forecast is a plan vs. actual analysis. This is a monthly process where you compare your sales forecast and expense budget to your actual results. Most companies do this analysis a few weeks after the end of the month when the books for the previous month are closed. 
The process is pretty straightforward. Take a look at each of your forecasted revenue streams and compare them to your actual results. Did you meet or exceed your sales goals? Maybe you missed a goal? It’s a good idea to take some time to ask what went right and what went wrong, and what you might change moving forward. You’ll follow the same process for expenses. Look for areas where you were over budget and places where you spent less than expected.
Of course, you can do this process in Excel and by exporting reports from your accounting software. However, if you use a tool like LivePlan, you can greatly simplify this process and get plan vs. actual reports automatically without having to do any work.

What to look for in your plan vs. actual analysis

Changes in the timing of expected revenue and expenses
When conducting a plan vs. actual analysis, use the differences between forecast and accounting numbers to understand if you need to make adjustments to your business operations, or if your projections in the forecast were simply wrong. 
For example, let’s say you see a sharp dip in sales for a premium-tiered product category. Did you introduce a new product line recently that’s eating up those sales? Perhaps you increased pricing too much which impacted demand? Or maybe your competitors cut prices or added new features?
Another factor to consider is timing. Perhaps sales are in the pipeline but just haven’t closed yet. Or, maybe planned expenses got delayed. 
Try to uncover the underlying cause for any under or over-performance. You may find that decreased sales volume was picked up somewhere else. Or that by raising prices you sell fewer items, but bring in greater revenue overall. 
Once you determine exactly what occurred, you can put a plan in place to fix the problem. Either fix the business area or enter a more useful projection going forward.

The problems that static forecasts and budgets create

With your plan vs. actual analysis in hand, you probably have some ideas about shifts you may want to make with your business. You might want to increase your marketing spending or perhaps consider hiring more employees. Or perhaps you’re looking to trim spending in a few places.
But, if your budget and forecast from the beginning of the fiscal year are static and unchanging, it’s hard to see how the changes you’re planning on making will impact your business financially. It’s also hard to communicate the changes you’re planning to make to the rest of your team.
Static budgets don’t adjust to new situations and in fact, they become more and more outdated as the year goes on. What may have been small variances at the beginning of the year can become larger and larger as actual results naturally differ. 
Once a budget is stale and outdated, it’s easy to ignore because it doesn’t reflect the current situation your business is in. And especially during a crisis, when things can fluctuate rapidly, you don’t want budgets and forecasts that you just ignore. Having them up to date can mean the difference between survival and growth, or mismanagement and dwindling performance.

Live forecasts to the rescue

A live forecast, on the other hand, is a forecast and budget that you update as you go. It responds to changes in your business and adapts to more accurately predict your future financial situation. This includes your end-of-year profits and how much cash you’ll have in the bank.
As your year progresses, a live forecast blends your actual results from the past with your forecast and budget for the future, creating a more accurate view of where your business is headed. Your cash forecast will become more realistic and you can adjust your revenue goals and expenses to reflect your current situation. Providing you with a much more accurate picture of where your fiscal year will end up.
Building a live forecast is a much better way to forecast and thankfully it’s not that hard to do.

How to create a live forecast

To build a live forecast, you’ll need at least a sales forecast and expense budget to start with. If you have a complete forecast, including a cash flow forecast and balance sheet, that’s even better.
1. Start by making a copy of your existing forecast. It’s not often that you’ll refer back to your original forecast, but it’s good practice to just keep a record of it.
2. Now, for any month that’s in the past, replace the forecasted numbers with your actual results — you’ll get these from your accounting software. 
3. Be sure to retain the formulas you have that total up year-end results.
4. You’ll see that your historical actual results plus your forecast create new year-end totals from what you originally forecasted.
5. The final step is to revise your forecast and budget going forward to reflect the current reality of your business. For example, if you’re consistently beating your sales goals, you should consider raising your targets for the rest of the year. If you need to adjust your expense budget, make those adjustments and see what your new year-end results look like.
If you have a complete financial forecast with a cash flow forecast and balance sheet, you can do the same thing there and get a more accurate view of how much cash you’ll have in the bank in the future.
While you can do all of this by hand, forecasting tools like LivePlan can do this for you automatically. If you use QuickBooks or Xero accounting software, you can import and sync your actual results and LivePlan will transform your static forecast into a live forecast automatically.

Getting the most out of your live forecast

If you ever hear on the news about large companies “adjusting guidance” for the future, they’re talking about a version of live forecasting. They’re telling you that they’re adjusting their sales targets and planned expenses due to changes in the market.
Live forecasting takes this toolset that corporations use and makes it easy for small businesses to get the same benefits. With a live forecast, you’ll get more accurate forecasts and expense budgets and a better view of how much cash you’ll have on hand in the future.
To get the most out of your live forecast, make sure that you set up a regularly scheduled review meeting with your team to go over your plan vs actual results and make changes to your forecast for the remainder of the year. Try and do this monthly, although quarterly can be a good place to start if monthly is too much initially.
Be sure to share your live forecast with your team. They need to know what the new targets are so that they can make their own adjustments to meet the new goals. 
Live forecasting will make your business more dynamic and nimble. Start with your initial forecasts, set up a review process, and get started. It’s a small amount of effort to invest with a sustainable impact, helping you run your business better.