Sunday, 13 May 2012

Help I'm running out of cash!….How KPIs and a Flash Forecast can quickly help to know how you are doing and get control….

A client rang me a couple of weeks ago and said “I persistently seem to have no money, I need your help. Sales are up but I’ve got no money”.

I quickly asked about a few areas which were directly relevant to the business:
¨      What are your stock levels like now compared to before?
¨      Are you paying other businesses quicker?
¨      Have you bought any large items of capital for use in the business recently?
¨      I then discussed a comment he made earlier concerning prices: what are your margins on sales. He confirmed that they had dropped
¨      I also asked whether he had increased spend on labour, marketing or on other overhead costs in running the business. I was advised that marketing spend had risen but everything else was static

I could quickly see that the Balance Sheet was under control but I wondered from the conversation whether the business was in fact losing money.

I next suggested he undertook the following actions to get a quick handle of the situation:
1.      Immediately run his profit and loss accounts from his bookkeeping software for the last few months and compare the costs to previous accounts both in terms of actual spend and in terms of % of sales and then look at recent monthly trends
2.      Then start measuring weekly the key numbers in the business, the KPIs, in this case – bank balance, sales, purchase costs, marketing & labour costs and compare these to year to date and prior year figures, both actual cost numbers and as a % of sales. Finally estimate fixed costs from past accounts, which shouldn’t vary significantly. From this a “Flash” result can quickly be obtained which if done well should be close to the actual result; “close” is enough for a Flash result
3.      Finally prepare a forecast firstly for the next month and then for the next year for these KPIs and the rest of the fixed costs to give a target to measure against for Flash and actual management accounts results. Before preparing management accounts, at the end of each month an initial Flash result can be obtained for that month and compared to the forecast

By using KPIs and Flash forecasts combined with an understanding of their Balance Sheet, a business can quickly gain information as to how they are performing and take immediate action to control an adverse situation. Why wait for management accounts to be prepared to know how you are doing?

Contact Jan to find out how we can help get quick control of your business performance
07890 239442