3 min read
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.