You have got to the end of the budget business planning process. The P&L has been drafted, all the department managers have their budgets, the sales team have their targets and you deserve a huge pat on the back for getting through the process for another year.
Is that where your business planning ends? Or do you prepare a budgeted cashflow forecast to show the peaks, troughs, pinch-points, or timing when resources are available for dividends or investments?
Building a Cashflow Forecast on excel is a complicated thing to do. Everyone outside of the Finance department expects you to have a model that just does it. But building it yourself on excel is hugely time consuming, difficult and very frustrating when it does not balance. It is easy to spend more time creating the model than on the numbers themselves and what they are telling you.
One further aspect that is tricky is that you need to forecast the remainder of this year before you have the starting cash position for the budget cashflow forecast.
Awesome Forecast is cashflow forecasting software that allows you to create a P&L, Balance Sheet and Cashflow Forecast for up to five years. You can create a budget cashflow forecast or update your results monthly in a rolling cashflow forecast. All this in your chart of accounts customizable to your format too, giving you a central place for all your numbers.
No Comments