← Back to blog
Business Growth

Best Practice Cash Forecasting: 90-Day Visibility for UK SMEs

CRA
Chamara Ranathunga, ACCA
Jan 5, 2025 · 9 min read

Why 67% of UK Small Businesses Fail Due to Cash Flow

Profitability doesn't keep businesses alive—cash flow does. You can be profitable on paper but go bust if you can't pay this month's bills.

The problem? Most UK SMEs have zero visibility beyond "what's in the bank today." By the time you realize there's a problem, it's too late to fix it.

90-day rolling cash forecasting solves this. Here's how to implement it.

What is a Rolling Cash Forecast?

A rolling cash forecast predicts your cash position for the next 90 days (roughly 3 months) by forecasting:

  • Expected cash coming in (customer payments, other income)
  • Expected cash going out (supplier payments, salaries, VAT, tax, loan repayments)
  • Your projected bank balance at end of each week

It's called "rolling" because you update it weekly: drop the past week, add a new week at the end. Always maintaining a 90-day forward view.

Why 90 Days?

90 days gives you enough time to react:

  • 30 days out: Too late to fix big problems. You need cash NOW.
  • 60 days out: You can take some action (accelerate collections, delay payments)
  • 90 days out: You have real options (arrange overdraft, adjust pricing, change payment terms)

Beyond 90 days, accuracy drops significantly. The sweet spot is 13 weeks.

Step 1: Start With Opening Balance

Your starting point is today's bank balance. Simple. If you have multiple accounts, total them.

If you have credit cards, overdrafts, or loans, decide whether to include them. I recommend starting simple: just track main operating account first.

Step 2: Forecast Cash Inflows

What money is coming IN over the next 90 days?

Customer Payments

  • List all outstanding invoices and when you expect payment
  • Factor in your average payment terms (30 days? 45 days?)
  • Be realistic—if customers typically pay 45 days even when terms are 30 days, use 45
  • Estimate new sales you'll invoice in next 90 days and when those will be paid

Other Income

  • VAT refunds due
  • Government grants or credits
  • Loan proceeds (if applicable)
  • Any other expected cash receipts

Pro tip: Be conservative. If in doubt, assume payment comes later rather than earlier.

Step 3: Forecast Cash Outflows

What money is going OUT over the next 90 days?

Recurring Expenses (Predictable)

  • Salaries and wages (including PAYE/NI)
  • Rent
  • Software subscriptions
  • Insurance
  • Loan repayments
  • Regular supplier payments

Variable Expenses (Estimate)

  • Materials and supplies
  • Marketing spend
  • Professional fees

Lump Sum Payments (Don't Forget These!)

  • VAT payments (quarterly)
  • Corporation tax payments
  • Annual insurance renewals
  • Equipment purchases

These lump sums are what kill businesses. Your forecast must include them.

Step 4: Calculate Weekly Closing Balances

For each week:

Opening Balance + Cash In - Cash Out = Closing Balance

The closing balance of Week 1 becomes the opening balance of Week 2, and so on.

Plot this on a simple line chart. You'll visually see when cash dips below your comfort zone (or worse, below zero).

Step 5: Identify and Fix Problems Early

When you see a future cash crunch (closing balance going negative or uncomfortably low), you have options:

Accelerate Cash Inflows

  • Invoice immediately (don't wait)
  • Offer early payment discounts
  • Follow up on overdue invoices
  • Request deposits on large projects

Delay Cash Outflows

  • Negotiate extended payment terms with suppliers
  • Delay non-essential purchases
  • Spread large expenses over multiple months

Arrange Funding

  • Set up or increase overdraft facility
  • Apply for business loan
  • Arrange invoice financing

The key: you're making these decisions 8-12 weeks BEFORE the crisis, not during it.

Step 6: Update Weekly

Every Monday (or Friday), update your forecast:

  • Enter actual cash in/out from the past week
  • Adjust future weeks based on new information
  • Drop the past week, add a new week at the end

This takes 15-30 minutes once you're in the habit. Small time investment, massive peace of mind.

Real-World Example

Construction company in Manchester implemented 90-day rolling forecast. Week 8 showed they'd be £30k short when a large VAT payment hit.

With 7 weeks' notice, they:

  • Accelerated invoicing on completed work
  • Negotiated payment plan for one large supplier
  • Arranged a temporary overdraft increase

Crisis averted. Without the forecast, they'd have missed payroll.

Tools You Can Use

  • Spreadsheet: Google Sheets or Excel. Simple, flexible, free. Start here.
  • Accounting software: Xero and QuickBooks have built-in cash flow forecasting features
  • Dedicated tools: Float, Fluidly, Futrli integrate with accounting software for automated forecasting

Most businesses start with spreadsheet, graduate to accounting software tools as they scale.

Common Mistakes

  • Being too optimistic: Assume payments come late, not early
  • Forgetting lump sums: VAT and tax payments must be in the forecast
  • Not updating weekly: Stale forecast is useless
  • Over-complicating: Start simple, add detail later

Getting Started Today

You can build your first 90-day cash forecast in under 2 hours using a spreadsheet. Here's the process:

  1. List opening bank balance
  2. List all outstanding invoices with expected payment dates
  3. List all recurring expenses with payment dates
  4. Add any known lump sum payments (VAT, tax, etc.)
  5. Calculate weekly balances
  6. Chart it visually

If you need help setting up your first forecast, book a free operations assessment. We can build it with you in a single 90-minute session.

Expert insights

Get more finance tips like this

Join 500+ UK business owners. No spam.

Share this article:

Tags:

cash flow forecasting
90-day cash forecast
cash flow management
UK small business cash flow
working capital management

Need expert guidance?

Book a free strategy session with our finance team.

Book free call

About author

Chamara Ranathunga, ACCA

Ready to transform your business finances?

Get personalized advice tailored to your situation.

Book your free strategy session