Coronavirus support

Forecast your cash flow

In this guide, we explain how to improve your cash flow position by creating a cash flow forecast.

Understand your business and what the future looks like with our interactive cash flow forecasting tool

A cash flow forecast is critical for businesses still in lockdown or preparing to go back to work.

You should consider:

  • What would happen if you lost your biggest customer?
  • How long would cash reserves last if your revenues decreased by 10%, 20%, 30%, 40% as you return to business?
  • At what point will your business be in danger of running out of cash?
  • How do you need to adjust your costs in order to make your cash last longer?

The interactive tool will provide you with the ability to forecast how much cash your business has for different scenarios around sales, margins and overheads as the business adapts and moves forward. This has been built in partnership with FreeAgent, award-winning* online accounting software available free to Ulster Bank business current account customers. *Most Outstanding Accounting Software of the Year, SME News Business Elite, 2019

This document is a forecasting guide for illustrative purposes only and VAT amounts are purely indicative. None of the content should be construed as advice on tax or financial matters.

We have listed some of the options that might be available to you below, but please remember this is not advice or a recommendation of any kind and there may be other options available to you and so it is important that you do your own independent research. You can refer to your own accountant, or if you don't already have an advisor, eligible FreeAgent customers can find an accountant to work with directly within their account.

How to create a dynamic cash flow forecast

Use our simple Excel template (XLSX, 2,852KB) to help you populate your cash flow.

Guidance is provided within each tab but here is an overview of what you will need to do.

Have you identified potential issues with your cash flow in the near future?


Pay It Forward by Crowdfunder is a donation and reward-based service. It allows you to generate funds for your business without releasing equity. £5m has been raised so far across 1.5k businesses.


FreeAgent is the small business accounting software that does it all. Manage expenses, fire off an invoice, check your cash flow and stay on top of your taxes on the go.

Related guidance and support you may find useful

Bring your business online

Selling online can be a great way to regenerate revenue in this challenging time. Use our guide to see if this is right for your business.

Coronavirus hub

We’re here to support your business. See our latest guidance and find out how we might be able to help you.