Best Practice Cash Forecasting: 90-Day Visibility for UK SMEs
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:
- List opening bank balance
- List all outstanding invoices with expected payment dates
- List all recurring expenses with payment dates
- Add any known lump sum payments (VAT, tax, etc.)
- Calculate weekly balances
- 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.
Get more finance tips like this
Join 500+ UK business owners. No spam.
Tags:
Related reading
Companies House Filing Updates: What You Need to Know for 2028
Major changes are coming to how UK companies file their accounts. Here is a breakdown of the upcoming software-only filing requirements and the latest regulatory updates.
Streamlining Your Obligations: The Move Toward 'Tell Government Once'
The UK government is actively exploring ways to reduce administrative burdens for small businesses, with a new focus on integrating HMRC and Companies House filing processes.
Companies House Reforms: Preparing for the April 2028 Filing Changes
Significant changes to how UK companies file accounts are coming in 2028. Here is what you need to know about the upcoming transition to software-only filing.
About author
Chamara Ranathunga, ACCA
Ready to transform your business finances?
Get personalized advice tailored to your situation.
Book your free strategy session