Cash flow forecast example: an 8-week forecast for an ecommerce brand

A worked cash flow forecast example for an ecommerce brand that holds stock: 8 weeks, a supplier order, payroll and VAT, plus a slow-sales scenario.

Illustration for Cash flow forecast example: an 8-week forecast for an ecommerce brand

The short answer: a cash flow forecast example is a week-by-week table that starts with today's bank balance, adds the money you expect to land each week, takes off the money you expect to leave, and shows the closing balance. The number that matters is the lowest closing balance, because that is the week that decides whether the plan is safe.

Below is a full example for a UK Shopify brand that holds stock, with every number shown so you can copy the method. If you want the background first, start with what cash flow forecasting is.

The example business

These figures are illustrative.

  • Opening bank balance: £12,000
  • Shopify payouts: £9,000 a week on average
  • Ad spend: £2,500 a week
  • Software, fulfilment and other running costs: £1,500 a week
  • Average weekly net from trading: £9,000 − £2,500 − £1,500 = +£5,000

The lumpy items, placed on the week the money actually leaves the account:

  • Payroll: £6,000 in weeks 2 and 6
  • Supplier deposit on a stock order: £4,000 in week 3
  • VAT bill: £7,500 in week 4
  • Supplier balance on the same order: £9,000 in week 7

The base case

WeekTrading netLumpy itemsClosing balance
Start£12,000
1+£5,000£17,000
2+£5,000Payroll −£6,000£16,000
3+£5,000Supplier deposit −£4,000£17,000
4+£5,000VAT −£7,500£14,500
5+£5,000£19,500
6+£5,000Payroll −£6,000£18,500
7+£5,000Supplier balance −£9,000£14,500
8+£5,000£19,500

The lowest closing balance is £14,500, in weeks 4 and 7. On this view the business looks comfortable. One forecast, though, is a single guess.

The slow-sales scenario

Now run the same weeks with payouts 20% lower, which is £7,200 a week. Trading net drops to £7,200 − £2,500 − £1,500 = +£3,200 a week. Everything else stays the same.

WeekTrading netLumpy itemsClosing balance
Start£12,000
1+£3,200£15,200
2+£3,200Payroll −£6,000£12,400
3+£3,200Supplier deposit −£4,000£11,600
4+£3,200VAT −£7,500£7,300
5+£3,200£10,500
6+£3,200Payroll −£6,000£7,700
7+£3,200Supplier balance −£9,000£1,900
8+£3,200£5,100

The base case never fell below £14,500. With sales 20% lower, week 7 falls to £1,900, which is close enough to zero that one late payout would cause a problem. That gap between the two tables is the reason to run more than one scenario.

What the example shows

  1. Put every payment on its real date. The supplier order is not a £13,000 event in week 3. It is £4,000 in week 3 and £9,000 in week 7, which is what the bank sees.
  2. Find the low week, not the total. The order looks affordable in both tables. Only the slow-sales table shows how thin week 7 is.
  3. Decide before you commit. If you are about to place the order, you can still move the balance payment, shrink the order, or ask the supplier for different terms. After the deposit has gone, you have fewer options. The affordability check walks through that decision step by step.

How to build your own

  1. Start from your actual bank balance, not a projected one.
  2. Estimate average weekly net from trading using the last 8 to 12 weeks of payouts, ad spend and running costs.
  3. List payroll, tax, loan payments and every supplier payment with its real due date.
  4. Build the table for 8 to 13 weeks. The 13-week rolling method is the standard version for Shopify brands.
  5. Duplicate the table and lower sales by 20%. Compare the low weeks.
  6. Update it weekly with what actually cleared.

If your supplier orders are the biggest item, size them first with the reorder point calculator and the stock order calculator, then drop the payments into the forecast.

FAQ

How far ahead should a cash flow forecast go? For an ecommerce brand, 13 weeks is a common choice. It is long enough to see payroll, tax and a full supplier order cycle, and short enough that the numbers are still reliable.

What is the difference between a cash flow forecast and a budget? A budget is what you plan to spend. A forecast is when the money will actually move, based on payout timing, supplier terms and due dates.

Do I need software, or is a spreadsheet enough? A spreadsheet works while you have a few suppliers and one or two sales channels. It becomes hard to keep current once stock orders, lead times and several payment dates change every week.

How often should I update it? Weekly. Replace the forecast figures for the week that has passed with what actually cleared, then move the table forward by one week.

Filed underForecastingCash Flow
Rory McLaughlan
Written by

Rory McLaughlan

Runs a Shopify store selling mystery football shirt boxes across the UK, EU and US. Built Cushion after years of joining up a cashflow sheet, a stock sheet and a sales forecast in his head every Sunday night.

See whether the next reorder leaves enough cash

Cushion puts your cashflow, stock and sales forecast on one screen, with read-only connections to your store, your books and your bank.