Every January, a garden centre owner I know does the same thing: she opens her accounting software, looks at the December balance, and says "great, we're up on last year." Then she pays the January supplier invoices for spring stock, and the balance drops by more than her entire December profit. By March she's nervous. By April the money comes back. Three years running, same pattern, same panic.
That's the gap a cash flow forecast for a seasonal small business is supposed to close. Not predicting whether you'll have a "good year" — your P&L already flatters you about that — but knowing, in advance, which specific weeks you'll be short and by how much. Most seasonal businesses don't have a forecasting problem. They have a timing problem they never wrote down.
Key Takeaways
- Seasonal cash flow breaks because costs run year-round while revenue arrives in bursts — the forecast must be built weekly, not monthly, around the trough.
- Build your forecast from cash in and cash out dates, not from revenue and expenses on an accrual basis.
- Model stock purchases and pre-season hiring before you model sales; they hit the bank account two to four months earlier.
- Set a minimum cash floor and a coverage ratio, and treat them as tripwires, not as decoration.
- Sales season is when you build the reserve. The trough is when you discover whether you did.
Why seasonal cash flow forecasting quietly fails
The single most common mistake isn't a spreadsheet error. It's building the whole thing on a monthly grid.
A monthly view of a seasonal business hides the exact thing you need to see. Think about a shop that does 40% of its annual turnover in the six weeks before Christmas. On a monthly table, November looks fine, December looks spectacular, and the pain — the January and February supplier settlements — gets smeared across two columns where it looks manageable. In reality the money leaves the account in a five-day burst in the second week of January, right when nothing is coming in.
The revenue-versus-cash trap
Revenue is what you invoiced. Cash is what cleared. For a seasonal business, the distance between those two numbers can be brutal, because you tend to sell the most at the exact moment your customers are slowest to pay. Card takings settle in days. Trade accounts settle whenever they feel like it.
I'll be blunt here: if your forecast is built on "expected sales" rather than "expected bank deposits," it isn't a cash flow forecast. It's a wish list with dates on it.
Pre-season costs arrive when you're weakest
Stock, deposits on a market stall, seasonal staff hired and trained a fortnight before you open, insurance renewals, a van service before the busy run. All of it lands in the quiet months. Which means the trough you're trying to survive isn't caused by a lack of sales — it's caused by the investment required to have those sales.
Look, this is the part almost every guide glosses over. You don't smooth out seasonality by selling more in the off-season. You smooth it out by financing the build-up deliberately.
How do I create a cash flow forecast? A step-by-step build
Start with the calendar, not the numbers. Grab your last twelve months of bank statements and mark every week where the balance dipped below what felt comfortable. Those are the weeks the forecast exists to predict.
Step 1: Set your opening cash position honestly
Not your profit. Not your available credit. The actual cleared balance across every account, minus anything already earmarked for a supplier payment or a tax bill. I keep a separate line for VAT/sales tax and payroll taxes, because that money was never mine to spend and pretending otherwise is how businesses get surprised by a bill they technically already owed.
Step 2: Map the season by week, not month
For a seasonal operation, a 52-week grid beats twelve columns every time. You want to see the four to six weeks around each transition — the run-up to your peak and the run-down after it. Those are where the decisions actually get made.
Step 3: Model inflows by cohort, not by total
Split your receipts by how fast they convert to cash:
- Card and cash sales — settle within days, treat as near-immediate
- Online payouts — a fixed lag depending on your processor
- Trade/invoice customers — apply a realistic payment delay based on their actual history, not the terms you printed on the invoice
- Deposits and prepayments — the most valuable inflow you have, because it arrives before you spend anything
That last one deserves a paragraph of its own. If you can take deposits for peak-season bookings or pre-orders, you shift cash backwards in time and shrink the trough without borrowing a penny. I've seen a small events business go from needing an overdraft every spring to needing none, purely by moving from "pay on the day" to a 30% deposit at booking.
Step 4: Lay out outflows in date order
Fixed costs first — rent, loan repayments, insurance, software, base wages. These don't care what month it is. Then variable costs tied to the season, and above all stock. Stock is the expensive one: you pay for it weeks or months before the customer pays you.
Step 5: Calculate the trough in weeks of runway
Here's the number nobody puts on a dashboard, and it's the one that matters. Take your lowest projected balance and divide it by your average weekly cash outflow.
Example: lowest balance £18,000, average weekly outflow £9,000. That's two weeks of runway. Two weeks is not a comfortable buffer — one late customer payment and you're making phone calls. I'd want at least six weeks for a seasonal business, and ideally eight to ten.
Step 6: Stress-test it
Now rerun the whole thing with your two biggest customers paying a month late and your peak season coming in 15% under plan. If the answer is "we're fine," your forecast is probably too optimistic somewhere. If the answer is "we're insolvent in week 9," you've just found the thing worth fixing in advance rather than in a panic.
How to track cash flow for small businesses (and why tracking alone isn't enough)
Tracking tells you where you are. Forecasting tells you where you'll be. Most small businesses do the first obsessively and the second not at all, which is how you end up with a beautifully accurate record of the moment you ran out.
What to actually track, weekly
- Cleared bank balance, every account, every Monday morning
- Receivables aged by how late they are, not by invoice date
- Committed outflows for the next 30 days (supplier payments already scheduled)
- Peak-season revenue booked versus forecast to date — this tells you early whether the year is tracking
The tripwires worth setting
Two numbers. A minimum cash floor — the balance below which you stop discretionary spending, no debate — and a fixed-cost coverage ratio, which is your projected cash divided by your fixed costs for the next quarter. If it drops below 1.0, you have a structural problem, not a timing one. I check both on the same page as the forecast; separating them into different tabs means nobody looks at the second one.
A quick comparison of methods
| Method | Best for | Weakness | Effort |
|---|---|---|---|
| Spreadsheet, 52-week grid | Seasonal businesses with a clear peak | Breaks if you don't update it weekly | Medium |
| Accounting software cash report | Day-to-day tracking | Usually backward-looking; weak on seasonality | Low |
| 13-week rolling forecast | Managing a near-term trough | Too short to plan stock purchases | Medium-high |
| Scenario modelling (base / bad / worse) | Deciding whether to take seasonal finance | Useless without honest inputs | High |
Handling pre-season costs: stock, deposits, and hires
The question isn't "can I afford the stock?" It's "when do I have to pay for it, and when does it turn back into cash?"
Work out your stock funding need explicitly: peak-season stock value, multiplied by the gap in weeks between paying your supplier and collecting from customers. A business holding £40,000 of stock that turns over in ten weeks has a funding requirement of roughly £40,000 sitting in the business for those ten weeks. That number belongs in your trough calculation, front and centre.
Three levers, in order of preference based on what I've seen work:
- Negotiate supplier terms. Ask for 60 days instead of 30 on the pre-season order. It costs nothing and it's the cheapest finance you'll ever get.
- Take deposits from customers. Shifts cash forward, reduces how much stock you have to fund yourself.
- Use seasonal finance deliberately. An overdraft or short-term facility is fine — if you draw it on a schedule and repay it in the peak, rather than discovering it in April.
What doesn't work: funding the build-up out of peak-season profit that hasn't arrived yet. That's the move that turns a profitable year into a cash crisis.
Can ChatGPT make a cash flow statement?
It can build you the structure — a template, a formula set, a set of categories, a first draft of the layout. It cannot produce an accurate statement for your business, because it has no access to your bank feed, your receivables, or the payment behaviour of your three worst-paying customers.
Where it's genuinely useful: asking it to turn your messy list of monthly outflows into a categorised table, or to draft three scenario variants once you've supplied the assumptions. Where it fails: anything requiring your actual numbers. If you feed it invented figures you get an invented forecast, and a confident-sounding one at that, which is worse than no forecast because you'll trust it.
My rule: use it for structure and formatting, never for the data. The moment a model starts generating numbers you didn't type in, the output stops being a forecast and becomes fiction.
Is it true that 82% of small businesses fail due to cash flow problems?
No — and I'd stop repeating it. That figure circulates endlessly, usually attributed to a study that doesn't say what people claim, and the underlying research on business failure doesn't support a single clean percentage for cash flow as the cause.
What is both true and useful: running out of cash is one of the most common proximate reasons small businesses close, even when they're trading profitably. Cash flow is often the mechanism of failure rather than the root cause — a seasonal business with thin margins, a late-paying anchor customer, or a stock build funded on short terms will die of cash flow long before it dies of anything else.
The number is wrong. The instinct behind it is right. Build the forecast.
What I got wrong the first time
My first seasonal forecast was a thing of beauty and completely useless. Twelve monthly columns, colour-coded, formulas everywhere. It told me the year would end up fine — which it did — while completely missing that I'd be £11,000 short in the second week of February.
Two fixes changed everything. First, I switched to a weekly grid. Second, I stopped forecasting sales and started forecasting deposits into the bank account on specific dates. The forecast got uglier and less satisfying to look at. It also got accurate enough that I stopped being surprised, and being unsurprised is worth more than being optimistic.
The trough doesn't get shorter because you ignored it. It just arrives with less warning. Build the week-by-week picture now, while the sun's out and the account still looks healthy — because the version of you sitting in February with a supplier on hold won't have the patience to build it then.