June 24, 2024


Me And My Business

Creating Cash Flow Forecasts

If you are looking to for advice on creating a cash flow forecast then here are a few tips and pointers. Firstly you need to distinguish between what is ‘Revenue and Expenditure’ and what is ‘Cash Inflows and Cash Outflows’. Let me explain this by way of an example:

When you raise a sales invoice to one of your customers there are differences between how this transaction affects profit and how the same transaction affects your bank balance and when. Let us say you raised the invoice on 28 November 2009 and the invoice was for £1,000 (net of VAT or Sales Tax). For profit and loss purposes you would include £1,000 in the November profit and loss account, which is very straight forward and quite obvious really. However, when it comes to recording the ‘Cash-effect’ of this same transaction you have to put a little more thought into how you record it.

Firstly, if you are a business that has to charge VAT or Sales Tax then the amount that you will receive (the Cash-Inflow) will be more than the £1,000. If the rate of VAT or Sales Tax was 15{bcb10712eadb32c7e50a15bcbfb14ed4d7108a9fa2a5dcafffbff4bd1d9a4f28} then the amount of ‘Cash’ you will receive into your bank account will be £1,150 and not the net amount of the invoice. Also, not all customers pay you straight away and in some cases customers can take months to pay you. So let us say that this particular customer pays you in 30-days time, which would be on 26 December 2009 (forgetting for the minute that this is in fact Boxing Day!). Therefore for cash flow purposes you would include £1,150 in the December cash flow forecast – giving you a timing difference.

Finally, you would then need to include the £150 as a ‘Cash-Out’ part of your forecast when you paid the VAT/Sales Tax to your Government, which might not be until February 2010. There are other complications that might come into play with your profit and loss versus your cash flows and you will have a similar complications associated with business expenditure and how these interact with ‘Cash-outflows’. The best way to prepare a cash flow forecast is to spend a bit of time planning it and reviewing what actually goes on within your business. You will also need to consider any capital expenditure you might be planning and how this impacts on your cash flow and how the depreciation of these assets impacts on your profit and loss account.

For easy to use software on creating cash flow forecasts.