How to build a cashflow forecast that survives a slow summer month

How to build a cashflow forecast that survives a slow summer month

Summer can be a double-edged sword for small businesses. While tourists swell footfall for some, others — particularly B2B service providers and seasonal retailers — see revenue thin out. Over the years I’ve helped clients survive (and sometimes thrive) through slow months by building cashflow forecasts that are realistic, flexible and actually used. Here’s the practical, no-nonsense approach I use and teach so you can build a forecast that survives a slow summer month.

Start with what you actually have: a clean opening cash balance

The most common forecasting mistake I see is starting with a guessed bank balance. Before you forecast, get your opening cash position right. Pull your latest bank statement and reconcile it to your bookkeeping. If you use Xero, QuickBooks or FreeAgent, run the bank reconciliation — don’t rely on the balance your bank feed shows until you’ve cleared outstanding items.

Make sure to include:

  • Available business bank balances (current account, savings linked to the business)
  • Undeposited receipts or petty cash
  • Committed but not yet drawn lines of credit (if you plan to use them)
  • Escrow or client trust balances if they can’t be used for operating expenses
  • Project conservatively on income

    When summer is slow, optimistic revenue forecasts are the fastest way to create a shortfall. I encourage clients to build two revenue scenarios into their forecast:

  • Base case: Revenue equal to the lowest average from the past 12 months (or the same month last year if you’re seasonal).
  • Stress case: Revenue 20–40% below the base case — enough to force operational changes if it happens.
  • Use your bookkeeping to break down revenue by client, product and channel. Some streams are predictable (like retainers) and can be treated as near-cash, while one-off sales or late-paying clients should be discounted or time-lagged in your cashflow.

    Map timing, not just amounts

    Cashflow is about timing. A sale booked in July might not translate into cash until August—or September—depending on invoice terms and customer behaviour.

    When I build forecasts I add columns for:

  • Invoice date
  • Payment terms (e.g. 30, 60 days)
  • Expected collection date
  • Probability of on-time payment
  • If you invoice monthly on the 1st with 30-day terms, expect most payments around the 1st–10th of the following month. For clients who regularly pay late, shift projections to reflect their actual payment habits.

    List every outgoing — and be brutally honest

    It’s tempting to only include big visible costs like rent and salaries, but small regular payments add up. When I help clients model a slow period we make sure to include:

  • Payroll (including employer NICs and pension contributions)
  • VAT payments and PAYE liabilities
  • Supplier payments (accounting for negotiated payment terms)
  • Subscriptions and software fees (Xero, Stripe, Shopify, Zapier, etc.)
  • Loan repayments and overdraft interest
  • Irregular but committed costs (annual insurance, licence renewals)
  • Use your past 6–12 months of bank statements and a supplier master list to avoid missing recurring payments. For lump-sum expenses like insurance, spread them across months in the forecast or show them clearly when they fall due.

    Build an actionable forecast template

    I usually construct a simple month-by-month table for the next 6 months. Keep it simple enough to update weekly but detailed enough to make decisions. Here’s an example layout you can copy into a spreadsheet:

    Month Opening Cash Expected Receipts Expected Payments Net Cash Flow Closing Cash
    June £12,500 £9,000 £15,000 -£6,000 £6,500
    July £6,500 £6,000 £10,000 -£4,000 £2,500
    August £2,500 £5,000 £9,000 -£4,000 -£1,500

    That table gives you an immediate visual of where you go negative and when you’d need to act. I also add a column for "actions" where I track mitigating steps (e.g., chase client A, delay supplier payment, draw on overdraft).

    Plan and prioritise responses

    A forecast is only useful if it triggers actions. For each month that shows risk I map specific, ranked interventions:

  • Short-term income measures: run a summer promotion, incentivise early payment with a small discount, or offer prepaid packages (I’ve helped salons sell discounted blocks of sessions that bring in cash now).
  • Cost deferrals and reductions: negotiate extended payment terms with suppliers, pause non-essential subscriptions (Zapier or paid stock photo libraries are common targets), or move contractors to project-based payments.
  • Financing options: overdraft, invoice finance, a short-term credit card, or an authorised director loan. I prefer pre-arranged options—calling your bank at the first sign of trouble often gets better outcomes than emergency applications.
  • Review and update weekly

    Cashflow is dynamic. I run a quick weekly review with clients during slow months: update actuals, check for late payments, confirm supplier negotiations and revise the forecast. That weekly habit often prevents surprises and keeps decision-making calm and deliberate rather than reactive.

    Use tools that save time and surface risks

    Cloud accounting platforms like Xero, FreeAgent and QuickBooks all have simple cashflow reporting tools that can automate parts of this work. For more advanced needs, I use forecasting add-ons such as Float or Pulse that sync with bookkeeping and let you model scenarios quickly. If you prefer spreadsheets, set up formulas for rolling sums and conditional formatting so negative balances stand out.

    Finally, communicate with stakeholders early. If you have a landlord, supplier or lender, a transparent conversation with a sensible plan is almost always better than silence. I’ve seen landlords accept short-term reduced rent with a small top-up later when presented with a straightforward forecast.

    Building a cashflow forecast that survives a slow summer month isn’t about predicting the future perfectly — it’s about giving you early warning and practical options so you can steer rather than react. With a clean opening balance, conservative income assumptions, realistic timings, and weekly updates, you’ll be in a much stronger position to keep the business steady through the heatwave and back into growth when autumn arrives.


    You should also check the following news:

    Bookkeeping Tips

    How to set up bookkeeping for a one-person retail shop with under £50k turnover

    02/12/2025

    I run into this situation a lot when I advise one-person shop owners: you’re brilliant at your product and customer service, but bookkeeping feels...

    Read more...
    How to set up bookkeeping for a one-person retail shop with under £50k turnover
    Tax & Compliance

    What to do if HMRC opens an enquiry: first steps for small business owners

    02/12/2025

    Getting a letter from HMRC saying they’re opening an enquiry is one of those moments every small business owner dreads. I’ve supported many...

    Read more...
    What to do if HMRC opens an enquiry: first steps for small business owners