Opinions and Legal Insights

Excel Template: 13-week cashflow projection to manage Covid-19 lockdown

“In our opinion, this will be the most important management tool you will have. It can help you to manage your fee earners remotely; with team leaders asking each fee earner on a weekly basis for the work they are doing, when it will be done by and what cash will be received and when. This information can then be inputted into the 13 week cash flow template and, notably, once fee earners have put their names to an expected cash receipt, they are then more likely to do the things that are needed to generate that cash commitment.”     

Andy Poole, Armstrong Watson

In order to assess the financial stability of your firm, you should prepare a 13 week short-term cash flow forecast to identify the position of your firm’s cash on an ongoing basis. This should be a rolling document that is used as a management tool, not only to assess what payments can/should be made, but also to identify the timing of any funding being received. 

The use of this document will also assist with a regular review of staffing needs to assist with furlough decisions, and conversely, the need to bring people back into the business from furlough.

If you would like any support with preparing an initial version for your practice, for you then to use on an ongoing basis,

please contact Andy Poole

or a member of Armstrong Watson’s specialist legal sector team

Please note

: we are aware of various grant funding packages that may even pay towards the costs.

Steps you should take to assist with cash flow continuity:

  • You should ensure that your debt management is strong and that you are in regular contact with your clients about any monies owed to the practice.

  • You should ensure that fee earners are regularly reviewing WIP and billing on a regular basis to ensure cash collections continue.

  • Your finance function should review the outstanding invoices due for payment and pay essential and business critical suppliers first and, where possible, negotiate alternative credit terms for non-essential spend.

  • You should consider negotiating a time to pay arrangement for your PAYE, NIC and Corporation Tax liabilities – HMRC have set up a dedicated helpline for queries such as these 0800 024 1222.

  • You may be able to change your year end, which could result in lower/deferred tax payments. This is not a straightforward area and you should contact us for advice for your circumstances, particularly around the impact of overlap profits.