Quidwise guides

How to build a 13-week cash flow forecast

Work out which week cash gets tight and test what changes if a customer pays late.

By CIJ Labs

Build the forecast

A 13-week cash flow forecast starts with the cash you can use today, adds what you expect to receive and subtracts what you expect to pay. Each week’s closing balance becomes the next week’s opening balance.

  1. Start with the cash available. Check the bank balance and set aside money already reserved for another purpose. If you exclude a tax pot from your starting balance, take care to avoid subtracting the same money again.
  2. Put receipts in the week you expect the money. Use payment promises, recent customer payment patterns and the due date as evidence. Put uncertain sales in a separate scenario.
  3. List payments by when they leave the bank. Include payroll, supplier bills, rent, tax and loan payments. Check large amounts and dates against the source.
  4. Compare the lowest balance with your buffer. Mark the first week below the amount you want to keep on hand. If a week is tight, check the exact dates inside it too.

Download the 13-week worksheet (CSV)

Open a fresh copy in your spreadsheet. Enter the opening cash, expected receipts and payments as positive amounts. The formulas carry each closing balance into the next week. Save as a spreadsheet file before editing.

Test a late payment

Suppose a business starts with £12,000, expects an £8,000 receipt in week one and has £14,000 of payroll and supplier payments that week. Week two has another £2,000 of payments. Moving the receipt by one week leaves the same week-two closing balance but changes whether the business can cover week one.

Fictional example. Closing cash in each scenario.
WeekPays on timePays a week late
Week 1£6,000−£2,000
Week 2£4,000£4,000

In the late scenario, week one is short by £2,000. If the business wants to keep a £3,000 buffer, the gap to that buffer is £5,000. That tells you how much timing matters even when all the money eventually arrives.

Review it each week

Replace last week’s estimates with what actually happened, add a new week at the end and update the payments that moved. Record why a big receipt moved so the next forecast starts from better evidence.

When cash looks tight, check the biggest payments and receipts first. Confirm when a customer can pay, which supplier bills are due and which dates you can agree to move. The overdue invoice guide has a short email you can use to ask for a payment date.

Further reading. British Business Bank’s guide to cash flow forecasting.

Try Ada’s example

Quidwise shows a 13-week cash forecast from the records it has. In the public demo, compare the example business’s cash position before and after Ada’s proposed plan. The figures are projections based on the example data and assumptions.

Try the cash forecast with example data