How to Calculate and Improve Your Cash Flow Forecast
Cash flow is the difference between breathing and drowning. You can be profitable on paper — invoices sent, revenue recorded — and still run out of cash to pay rent, staff, or suppliers next month. A cash flow forecast is the tool that prevents that. It's how you calculate when money actually arrives and leaves your business, weeks or even months ahead of time. Once you see the problem coming, you can improve your position before it becomes a crisis.
The Federation of Small Businesses research consistently identifies late payment and cash flow shocks as the leading causes of SME failure. The UK has statutory remedies — charging statutory interest on late commercial debts — but the real solution is knowing your position in advance.
This post walks you through how to calculate a cash flow forecast (yes, a spreadsheet, or your accounting software), how to read it, and practical tactics to improve your forecast so you're never caught flat-footed.
What is a cash flow forecast?
A cash flow forecast is a projection of the money you expect to receive (inflows) and the money you expect to pay out (outflows) over a future period. The difference between inflows and outflows is your net cash position for each period.
Here's the crucial bit: it's based on when cash actually moves, not when you invoice or record an expense. An invoice issued in March but paid in May? That's a May inflow. A supplier invoice received in April but paid in June? That's a June outflow. Most small businesses confuse this with profit and loss reporting, which deals with revenue and expenses when they're earned or incurred, not when they're paid. Those are entirely different things.
Your cash flow forecast doesn't care if you're profitable. It only cares about timing. And timing is everything.
How to calculate a cash flow forecast: a step-by-step approach
Step 1: Choose your time horizon and intervals
Most small businesses forecast 12 months ahead in monthly intervals. If cash is tight — or your business is seasonal — go weekly for the next 13 weeks. Weekly forecasts for a quarter give you granular control when you need it most. The US Small Business Administration recommends exactly this.
Pick the interval that matches your cash stress. If you're sleeping well, monthly is fine. If you're not, go weekly.
Step 2: Start with your current cash position
Open a spreadsheet (or your accounting software). Write down how much cash you have right now: your current bank balance plus any literal cash on hand. That's your opening balance for month one.
Step 3: Forecast your cash inflows
List all the money you expect to receive:
Sales receipts — Usually your biggest inflow. Base this on your actual sales pipeline and your historical payment patterns. This is where most forecasts derail: we forecast optimistically. If your average client pays invoices 35 days after receiving them, use 35, not the "Net 30" on your invoice. Reality wins.
Other income — Interest, rental income, grants, tax refunds, loan proceeds, or any other cash in.
One rule: use data, not hope. If you're forecasting a big sales jump, you should have a concrete reason (a signed contract, a new client relationship). Optimistic projections are the most common reason cash flow forecasts fail.
Step 4: Forecast your cash outflows
Fixed costs — Rent, insurance, loan repayments, salaries. Same amount every month, so these are easy to forecast.
Variable costs — Supplier payments, materials, shipping, commissions. These should be linked to your revenue forecast. If sales go up 20%, your supplier costs probably go up too (though maybe not 20%).
One-off costs — Equipment purchases, annual subscriptions, tax payments. Check your calendar and last year's records. HMRC payments are a classic: most small businesses forecast quarterly or annual tax bills separately, then get blindsided when the due date arrives.
Tax payments — Do not bury this. HMRC's guidance on difficulties paying explains Time to Pay arrangements, but the better move is simply including the full tax bill in your forecast months before it's due.
Step 5–6: Calculate your position
For each month, net cash flow = Total inflows minus total outflows. Then, closing balance = Opening balance + Net cash flow. The closing balance for January becomes the opening balance for February, and so on.
Step 7: Spot the problem months
Look for any month where your closing balance goes negative or drops uncomfortably low. These are your danger zones. February in the example below is tight. If one client pays late or an unexpected bill arrives, you're in trouble. Knowing this in March lets you prepare.
Here's a simple example:
| Jan | Feb | Mar | Apr | |
|---|---|---|---|---|
| Opening balance | £10,000 | £8,000 | £3,000 | £7,500 |
| Inflows | ||||
| Sales receipts | £15,000 | £12,000 | £18,000 | £16,000 |
| Other income | £0 | £0 | £500 | £0 |
| Total inflows | £15,000 | £12,000 | £18,500 | £16,000 |
| Outflows | ||||
| Rent | £2,000 | £2,000 | £2,000 | £2,000 |
| Salaries | £8,000 | £8,000 | £8,000 | £8,000 |
| Suppliers | £4,000 | £5,000 | £3,000 | £4,000 |
| Insurance | £0 | £2,000 | £0 | £0 |
| Tax payment | £3,000 | £0 | £0 | £0 |
| Equipment | £0 | £0 | £1,000 | £0 |
| Total outflows | £17,000 | £17,000 | £14,000 | £14,000 |
| Net cash flow | -£2,000 | -£5,000 | £4,500 | £2,000 |
| Closing balance | £8,000 | £3,000 | £7,500 | £9,500 |
February is the problem child. The closing balance drops to £3,000. One late payment, one unexpected bill, and you're underwater. The forecast gives you time to act: accelerate collections, delay non-urgent payments, or arrange a credit facility with your bank.
How to improve your cash flow
Good news: once you have a forecast, improving your cash position becomes a math problem. You either increase inflows, decrease outflows, or time them better.
Accelerate inflows
Invoice today, not tomorrow — Send invoices the same day you complete work. Every day you delay is a day you don't have the cash.
Shorter payment terms — If you offer Net 30, try Net 14 for new clients. Shortening by even a week changes your forecast significantly. Read more on invoice payment terms if you need to set client expectations.
Early payment incentives — A 2% discount for payment within 7 days sounds generous. It is. But if it gets you paid two or three weeks earlier, you've bought cash flow at a 2% price. Do the math.
Chase overdue invoices immediately — Do not wait three weeks to send a reminder. Follow up within 48 hours. Automated payment reminders (email or SMS) work better than nothing, but a phone call works better still.
Request deposits on large projects — Rather than invoice everything at the end, ask for 25–50% upfront. The client gets started, you get cash before the work is done.
Accept multiple payment methods — Cards, bank transfers, PayPal, payment links. The easier you make it to pay, the faster you get paid.
Delay outflows (wisely)
Negotiate longer terms with suppliers — If you pay Net 60 but your clients pay you Net 30, congratulations: your suppliers are financing your business. Do not give that up. If it's the other way around, that's a problem. Push back.
Time your large purchases — When you have a choice, buy when cash is plentiful, not when it's tight.
Pay on the due date, not early — Early payment is generous but not smart when cash is constrained. You're lending the supplier your money interest-free.
Reduce outflows
Audit subscriptions and recurring costs — List every subscription, every service, every recurring charge. Kill what you don't use. Negotiate better rates on what you keep.
Manage inventory carefully — Do not tie up cash in stock sitting on a shelf. Order based on demand, not optimism. Stock is cash that's not in the bank.
Control discretionary spending — Marketing, travel, entertainment. These go up and down with cash availability. Review them monthly.
Build a buffer
Keep a cash reserve — Aim for one to three months of your fixed costs sitting in the bank as a buffer. This absorbs late payments and unexpected expenses without a crisis. It is boring and it is essential.
Arrange a credit facility before you need it — A business overdraft or line of credit is a safety net. But banks lend based on your financials when you ask, not when you're in trouble. Set one up when you're healthy. When you're not, it's too late.
Keeping your forecast current
A forecast is only useful if it's accurate. Accuracy requires updates:
- Weekly — if cash is tight or managing seasonal business
- Monthly minimum — as part of your regular financial review
- Immediately — when something big changes (a new contract, lost client, unexpected expense)
Each month, compare your forecast to actual results. Where were you right? Where were you wrong? This feedback loop improves future forecasts. After three or four months, you'll notice patterns.
Modern accounting software generates cash flow reports based on your actual data: outstanding invoices, upcoming bills, recurring payments. You get a real-time view without building spreadsheets from scratch.
Common cash flow forecasting mistakes
Overly optimistic sales projections — Use historical data. If you're forecasting a big bump, have a concrete reason. Targets are not reasons.
Forgetting irregular expenses — Annual insurance, quarterly taxes, equipment replacements. Review last year's records to catch what happens only occasionally.
Confusing invoiced revenue with cash received — When you expect to invoice is not when you expect to be paid. Use payment history, not invoice dates.
Forecasting too far ahead with false precision — A 12-month monthly forecast is useful. A daily forecast three years out is not. The further you go, the less accurate you are. Do not waste time on excessive detail.
Assuming your supplier terms match your customer terms — If you buy Net 60 but sell Net 30, that's a problem. If you buy Net 30 but sell Net 60, that's great. Know the gap.
Frequently Asked Questions
Q: How far ahead should I forecast? A: Start with 12 months. But if cash is tight, focus on the next 13 weeks weekly. Longer forecasts are less accurate, but they're still useful for spotting seasonal patterns and planning large expenses.
Q: What if my forecast shows I'll run out of cash? A: That's exactly why you're doing this. Now you have time to act. Accelerate invoicing, negotiate supplier terms, cut discretionary spending, or arrange a credit facility with your bank. A forecast is worthless if you ignore it.
Q: Should I use spreadsheets or accounting software? A: Spreadsheets work, but accounting software is faster and less error-prone. If your accounting software can generate cash flow reports from your actual data (outstanding invoices, scheduled bills), use that.
Q: How do I account for seasonal business? A: Build a full 12-month forecast so you can see where the tight months are. Read more on managing seasonal cash flow for tactics specific to your industry.
Q: What's a safe cash buffer to keep? A: Aim for one to three months of your fixed costs. If rent and salaries are £10,000 a month, keep £10,000–£30,000 in reserve. This protects you from late payments and unexpected costs.
Q: Can I improve my forecast by raising prices? A: Yes. Higher prices mean higher inflows, same outflows. But only if your customers accept them. A more immediate move is often to tighten up collections (shorter terms, early payment discounts, faster invoicing). Check your break-even point to see how much pricing power you actually have.
Q: What accounting method should I use for forecasting? A: Cash flow forecasting is simpler than choosing between cash and accrual methods: you forecast based on when cash moves, full stop. This is true regardless of which method you use for tax or accounting purposes.
Q: How often should I update my forecast? A: Minimum monthly. Weekly if cash is tight. After each update, compare forecast to actual results so you learn where you're off.
Get your forecast in place
Cash flow forecasting is not fortune-telling. It is arithmetic. Even a rough forecast beats no forecast. Most small businesses that run out of cash saw it coming — they just did not bother to look.
Start with a simple 12-month spreadsheet this week. Write down your opening balance, list your recurring income and costs, and calculate the months where cash gets tight. Then pick one tactic from the "improve your cash flow" section and implement it. You do not need perfection. You need to see the problem coming.