Person carrying a shopping basket

Cash flow forecast template for retailers

23 April 2019
All businesses need to keep an eye on their cash flow. Running out could mean that you run into financial difficulty or even have to temporarily cease trading, even if you're profitable.
To help you manage your cash flow more effectively, we’ve developed a cash flow forecast template specifically for SME retailers.

The objective of a cash flow forecast is to ensure you have enough accessible cash in your business to pay for the things that keep it going. Your cash flow forecast will reveal whether and when a shortage of cash is expected, giving you a chance to address this.

A cash flow forecast shows the expected monthly incoming and outgoing money of your business for a 12 month period (this could include; cash payments, bills, wages, direct debit transfers, cheques etc). It also shows your expected cash position (i.e. surplus or deficit) for each month.

Simply download our simple cash flow template to help you get started.

Every business will have its own bespoke cash flow forecast, as it will include income and outgoings that are specific to it alone. Therefore it is important to tailor the template to your business. Remember that a cash flow forecast relates to the actual monthly income and expenditure of your business, so only record items when money is received in or paid out.

Don’t file your cash flow forecast away once it’s complete. Look at the figures and think about what they tell you about your business. For example:

  • Does the closing cash balance at the end of each month meet the needs of the business in the following month? If not, what can you change about how and when cash will be coming into and going out of your business?
  • If there is regularly a cash flow surplus, have you considered adjusting your borrowing requirements, investing in additional stock or equipment or updating your retail space?
  • Regularly update your cash flow forecast with actual cash income and outgoings and revise your estimates for your business’s future cash flow. This will give you a good basis upon which to create your cash flow forecast next year.
  • Your cash flow forecast will also be useful in discussions with any potential lender or investor as a demonstration of how you manage your business’s finances.
It is important to make sure that you have the right insurance in place to protect the business that you have built. Every business is different and has its own business insurance needs, which is why we work with some of the UK’s most well-known insurers to ensure that you are getting the right insurance cover for your business.
The information and tools contained in this guide are of a general informational nature and should not be relied upon as being suitable for any specific set of circumstances. We have used reasonable endeavours to ensure the accuracy and completeness of the contents but the information and tools do not constitute professional advice and must not be relied upon as such. To the extent permitted by law, we do not accept responsibility for any loss which may arise from reliance on the information or tools in our Insight Hub.