Using forecasts to prevent cash flow issues

2. Pick a tool to use
Our favourite for small businesses is CrunchBoards.  It has an excellent interface that allows for quick production of your first forecast and also provides powerful options to really build in detail as you go.  Unlike many other cloud options it provides 3 way forecasting (Profit & Loss, Cash Flow and Balance Sheet).

3. Keep it simple (at least at the start)
There’s no doubt detail is key to getting a really accurate forecast.  Having detail behind the headline numbers is also useful in the future, when trying to analyse where/how you varied from your forecast. However, I’ve seen too many businesses abandon forecasts because they’ve become too bogged down in complex calculations, keep it simple and build in detail over time.

4. Start with revenue
Costs tend to be the easier part, so start with revenue.  There are a number of techniques to use but as above, start simple.  If you have trading history already, use that.  Look for trends in growth that can help you forecast.  Don’t forget seasonality, it can make a huge difference when forecasting for cash flow.  We’ve helped a number of businesses who had plentiful profits over a financial year but always seemed to struggle for cash at certain times of year, sound familiar?  If your accounts are already in Xero, CrunchBoards can produce an initial forecast based on the trading history you have, which you can then edit and build upon.

5. Consider costs needed to realise your sales forecasts
Do you have any costs that increase with the volume of sales or personnel.  The increase in use of cloud solutions tends to reduce upfront costs for businesses but increases variable costs.  For example, the increasing use of hosting solutions like AWS rather than traditional data centres, means costs usually increase with increasing sales.  Operation software such as cloud CRM solutions may have a cost per user that will increase as you hire more staff.  Take some time to consider how your forecast would impact these costs.

6. Don’t forget the one-off costs
If your plan for domination of your market includes rapid growth, consider the incidental one-off costs that might be associated.  Have you doubled your staff head count, if so, have you included recruitment costs?

7. Analyse
So you’ve completed your forecast, definitely time for a cup of tea but not quite time to rest yet.  Time to analyse your forecast, look for the trends, where are the pinch points and how can you look to protect against them?

8. Review
Remember to review your performance against your budget on a regular basis. CrunchBoards is excellent at this, it allows you to highlight and examine differences against expected performance. Don’t forget to make notes on what you find.

9. Repeat!
Create a new forecast every year.  Use CrunchBoards to roll over your previous forecast or use your actual data as a starting point.  Use the notes you’ve made on the variances you witnessed to improve your budget each time.  Each year try to add a little more detail to improve accuracy.