How-to

How to Forecast Seasonal Cashflow for Your Business

A twelve-month cashflow forecast that accounts for seasonal revenue patterns and fixed cost obligations lets you plan borrowing and staffing decisions months in advance rather than reacting to a crisis.

3 min read

13-weekRolling cashflow horizon recommended for active working capital management
3 scenariosBase, optimistic, and downside — the minimum for useful forecasting
Debtor daysAverage time from invoice to receipt — key variable in any cashflow model
Fixed vs variableSeparating cost types is essential for accurate trough modelling

Map your historical revenue pattern month by month

Start with at least two years of monthly revenue data from your accounting software. Plot each month as a percentage of annual turnover to identify your typical seasonal shape. Most businesses have clear peak and trough months that repeat year on year, even if the absolute figures grow over time.

If you are a new business without two years of history, use industry benchmarks, trade association data, or the revenue pattern of comparable businesses you are aware of as a starting assumption — and flag it explicitly as an estimate.

Build your monthly receipts and payments schedule

Separate your forecast into two streams: receipts (when cash actually arrives, not when you invoice) and payments (when cash actually leaves, not when you accrue a cost). The gap between revenue earned and cash received is driven by your debtor days — if you invoice in November but your customer pays in January, the cash lands in a different month to the revenue.

Common payment timing considerations include PAYE and NI (monthly, on the 22nd), VAT (usually quarterly), corporation tax (nine months and one day after your year-end), annual insurance premiums, and lease payments. Map all of these by calendar month.

Identify your cashflow trough and its timing

Once you have mapped receipts and payments by month, calculate the running cash balance. The point at which this balance is lowest is your cashflow trough. For seasonal businesses this is typically one to two months after your slowest trading period, because fixed costs continue while revenue has not yet recovered.

Knowing the depth and timing of your trough in advance allows you to arrange a revolving credit facility or a short-term working capital loan before you need it, rather than approaching a lender when your balance is already under pressure — which is a weaker negotiating position.

Run three scenarios — base, upside, and downside

Your base case uses your most realistic revenue estimate. An upside scenario might model revenue 15–20% above base, which is useful for planning how you would handle rapid growth (you may need more working capital, not less). A downside scenario — perhaps 20–25% below base — tests whether your business can survive a weaker-than-expected season without breaching its banking covenants or running out of cash.

The downside scenario is the most important. If it shows your cash balance going negative, you need either a contingency facility, cost reductions, or a plan to accelerate collections before you reach that point.

Update your forecast every month with actuals

A forecast that is not updated is just a budget. Replace forecast figures with actuals as each month closes and roll the horizon forward. Significant variances — revenue coming in faster or slower than forecast, a large unexpected cost — should prompt you to rerun the model for the remaining months.

Most accounting packages (Xero, QuickBooks, Sage) allow you to export monthly actuals in a format that feeds directly into a spreadsheet forecast. If your finance team or bookkeeper is not producing an updated 13-week cashflow view each month, that is worth addressing.

Frequently asked questions

How far ahead should a seasonal business forecast its cashflow?

A minimum of 12 months is recommended for seasonal businesses, because the full cycle needs to be visible in one view. Within that, maintain a rolling 13-week (quarterly) detailed forecast updated monthly with actuals. Lenders will typically want to see a 12-month cashflow when assessing a working capital facility.

What if my revenue is too unpredictable to forecast reliably?

Project-based or lumpy businesses should model using their pipeline weighted by probability rather than a smooth revenue curve. Even an imperfect forecast is more useful than none — it forces you to articulate your assumptions and identify which variables matter most to your cash position.

Funding for UK limited companies

Credicorp lends to your company, not to you personally — short-term working capital with no personal guarantee. See what your business could access.