How to build a rolling 52-week forecast that survives your quiet months
Seasonal swings can make a profitable business feel cash-starved. This guide shows retailers, hospitality, tourism, events, wedding suppliers, garden centres, landscapers, sports clubs, tutors, holiday lets and farm shops how to build a rolling 52-week cash flow forecast and smooth tax and payroll spikes before they hit.
🎁 Free download: 52-Week Rolling Forecast Template (Excel). pre-built with VAT/PAYE/CT calendars, card-settlement lags, deposits/vouchers logic and scenario toggles.
Get the template (instant download)
Why seasonal businesses feel short of cash (even when sales look great)
- VAT lands at the wrong time. The deadline to submit and pay each VAT return is 1 calendar month + 7 days after the period ends. If your quiet month sits right after a busy quarter, the VAT bill lands when cash is thin. GOV.UK
- Corporation Tax sneaks up. Smaller companies pay CT 9 months + 1 day after the year end. If your year end is 31 March, the CT is due 1 January — deep in winter for many seasonal firms. GOV.UK
- Payroll never stops. PAYE/NIC is due by the 22nd if you pay electronically (monthly). If you usually owe under ~£1,500 a month, you can ask to pay quarterly — helpful if your staff costs spike only in the season. You still file FPS on or before payday each time. Use the “irregular payment pattern” flag if a worker won’t be paid for 3+ months, and submit an EPS ‘no payment’ in months with no pay. GOV.UK
- Deposits, cancellations and vouchers create VAT earlier than you think. Retained deposits and “no-show” charges are subject to VAT when you take the payment. Single-purpose vouchers are taxed when issued; multi-purpose vouchers are taxed when redeemed. Model these in your weekly VAT line. GOV.UK
The seasonal playbook: build a simple rolling 52-week forecast
1) Start with facts
Pull the last 104 weeks of bank in/out. Mark peaks (Golden Quarter, Easter, summer), gross margin, and card-settlement delays (e.g., T+2). This gives you a base to project the next 52 weeks.
2) Add all statutory dates (so nothing blindsides you)
Layer in:
- VAT due dates (1m+7d rule). GOV.UK
- PAYE/NIC (22nd each month; or quarterly if HMRC agrees). Keep FPS on or before payday regardless. GOV.UK
- Corporation Tax (9m+1d after year end). GOV.UK
- Self Assessment (director-owners) — switch on an HMRC Budget Payment Plan to drip-feed weekly or monthly towards January/July. GOV.UK
Prefer a ready-made calendar? The 52-Week Rolling Forecast Template has VAT, PAYE and CT dates pre-mapped.
Download the template
3) Pick the VAT scheme that suits seasonality
- Cash Accounting Scheme — you pay/reclaim VAT when cash moves. Join if estimated VAT-taxable turnover is ≤ £1.35m; you must leave > £1.6m. Often best when customers pay you later. GOV.UK
- Annual Accounting Scheme — 9 monthly or 3 quarterly instalments towards one annual return; same £1.35m/£1.6m join/leave thresholds. Great for smoothing VAT outflows across the year. GOV.UK
- Flat Rate Scheme — simple but can distort margins in seasonal models. Join at ≤ £150k VAT-taxable turnover; leave > £230k. Test inside your forecast before switching. GOV.UK
- VAT bad debt relief — plan the inflow when debts hit 6 months overdue (claim within 4 years 6 months). Add a monthly check in your forecast. GOV.UK
- VAT Payments on Account — niche for SMEs, but know it exists: HMRC requires advance POA if your 12-month VAT liability exceeds £2.3m. GOV.UK
Related: Cashflow Clarity, how to choose and review VAT schemes in practice (with step-by-step testing inside your model). (Internal)
4) Model deposits, cancellations and vouchers properly
- Retained deposits/no-shows: VAT is due when you take the money. You can’t re-label it as “compensation” to avoid VAT. Build a weekly VAT line for deposits taken. GOV.UK
- Vouchers:
- Single-purpose (rate and place known): VAT on issue and on each paid transfer.
- Multi-purpose: VAT on redemption.
Add simple flags in your forecast so VAT falls in the right week. GOV.UK
5) Plan seasonal staffing without RTI headaches
Keep FPS on or before payday every time, even if you pay HMRC quarterly. Mark workers as “irregular payment pattern” if they won’t be paid for 3+ months, and send an EPS “no payment due” in months you pay no one. GOV.UK+1
Building a team for peak season? See NIC, PAYE & Pension Costs (UK 2025/26) for budgeting rates and thresholds. (Internal)
6) Smooth the director’s tax
Turn on the Budget Payment Plan for SA to drip-feed weekly/monthly. If profits fall after a tough season, reduce Payments on Account (SA303); if needed, consider Time to Pay. GOV.UK
Worked example (retail: Christmas peak)
Scenario: Independent gift shop. Golden Quarter spike (Nov–Dec). Card settlement T+2. VAT quarterly. Monthly PAYE. Year end 31 March.
| What changes? | Baseline (Standard VAT; monthly PAYE) | With Cash Accounting + Annual Accounting + SA Budget Plan |
|---|---|---|
| January cash trough | –£32k | –£12k (VAT spread via AA instalments; SA drip-fed) |
| VAT outflow timing | One hit on 7 Feb (1m+7d) GOV.UK | 3 instalments during the AA year + final balancing payment GOV.UK |
| SA in January | Full POA due | Plan pays weekly Oct–Jan via Budget Payment Plan GOV.UK |
| CT date | 1 Jan (9m+1d) GOV.UK | Unchanged; scheduled in the model |
Takeaway: For many seasonal retailers, Cash Accounting + Annual Accounting flattens VAT outflows when sales dip, and Budget Payment Plan stops the January SA shock.
Quick start checklist (plain English)
- Download the 52-Week Rolling Forecast Template and import the last 104 weeks.
- Mark peaks, card lags, stock build, and seasonal staffing.
- Switch on the VAT calendar (test Cash Accounting, Annual Accounting, or Flat Rate against your numbers). GOV.UK
- Set PAYE to monthly or request quarterly if you qualify; keep FPS on or before payday either way. GOV.UK
- Add deposit/no-show and voucher rules to the VAT lines. GOV.UK
- Enable a Self Assessment Budget Payment Plan; note you can reduce POA after a poor season. GOV.UK
- Agree cash guardrails (minimum days’ cash; stock caps; hiring gates) and review weekly.
FAQs
1) Should seasonal businesses use the VAT Cash Accounting Scheme?
Often, yes — if customers pay later, Cash Accounting means you pay VAT when the money arrives, not on the invoice date. You can join at ≤ £1.35m taxable turnover; you leave at > £1.6m. Model it first. GOV.UK
2) Can I smooth VAT with the Annual Accounting Scheme?
Yes. You make 9 monthly or 3 quarterly instalments and then a balancing payment when you submit your single return. Join at ≤ £1.35m; leave at > £1.6m. GOV.UK
3) We shut down for winter — should we close PAYE?
Usually no. Keep the scheme open, file FPS on or before payday when you do pay, set “irregular payment pattern” for staff unpaid 3+ months, and send an EPS ‘no payment’ for gaps. GOV.UK
4) Can I reduce my January/July Self Assessment Payments on Account after a poor season?
Yes. Use SA303 (or the online option) to reduce POA if profits fall or reliefs rise. You can also Budget Payment Plan weekly/monthly to avoid spikes. GOV.UK
5) Are “no-show” charges and retained deposits subject to VAT?
In general, yes — the chargeable event is when you take the money; VAT is due even if the customer doesn’t show. GOV.UK
6) When is Corporation Tax due for smaller companies?
9 months + 1 day after your accounting period ends. Larger and very large companies pay by instalments; most seasonal SMEs don’t fall into that regime. GOV.UK
Related guides (internal)
- Cashflow Clarity Guide — how we keep customers cash-positive through peaks and troughs.
- Lender Readiness Checklist — if you’ll need an overdraft or stock finance ahead of peak.
- NIC, PAYE & Pension Costs (UK 2025/26) — plan seasonal staffing with confidence.
- Director Pay & Dividends (2025/26) — drawings that respect cash and tax timing.
Strong next steps
Download: 52-Week Rolling Forecast Template (Excel), map every VAT/PAYE/CT date, card lag, deposits/vouchers VAT timing, and SA Budget Plan track in one place.
Prefer help? Book a 20-minute planning call, we’ll build your first 52-week view on a live screen-share and leave you with a 90-day rollout.
