How to create a cash flow forecast for your small business
Most small businesses don’t fail because they’re unprofitable, they fail because they run out of cash. A simple cash flow forecast can help you see what’s coming before it hits.
If you’ve ever been caught off guard by a shortfall, unable to make payroll, pay a supplier, or take on a new order, you already know how important it is to see your cash position clearly. A cash flow forecast gives you exactly that: a forward-looking view of the money coming into and going out of your business over a set period.
The good news?
You don’t need to be a financial expert or invest in expensive software. With a simple spreadsheet and a few hours of focused work, you can build a cash flow forecast template for your small business that helps you plan ahead, avoid surprises, and make better decisions about spending, hiring, and growth.
Here’s how to do it, step by step.
1. Understand what a cash flow forecast actually is
Before you start building your forecast, it helps to understand what it is and what it isn’t. A cash flow forecast is not the same as a profit and loss statement. Your P&L tells you whether your business is profitable on paper. Your cash flow forecast tells you whether you’ll have enough actual cash in the bank to meet your obligations on any given week or month.
Think of it this way: profit is a concept; cash is a reality. You can show a healthy profit while simultaneously running out of money, especially if your customers pay late, your costs spike, or you’re investing in growth. A cash flow forecast bridges that gap by projecting when cash will actually arrive and when it will leave.
If your business has experienced any of the warning signs of a cash flow problem, a forecast is the first step toward getting back in control.
2. Choose your forecast period and format
Most small businesses benefit from a 13-week (quarterly) rolling forecast. This gives you enough visibility to plan ahead without the guesswork that comes with forecasting too far into the future. Once you’re comfortable with the process, you can extend it to six or twelve months for strategic planning.
Your forecast should include three core sections:
Opening balance: the cash you have on hand at the start of each period.
Cash inflows: all the money you expect to receive (sales revenue, loan disbursements, tax refunds, etc.).
Cash outflows: everything you expect to pay out (rent, salaries, suppliers, loan repayments, SARS, etc.).
The difference between inflows and outflows gives you your net cash flow for the period. Add that to your opening balance, and you get your closing balance, which becomes the opening balance for the next period.
A spreadsheet works perfectly for this. Set up columns for each week or month, and rows for each income and expense category. Keep it simple, you can always add complexity later.
3. Estimate your cash inflows realistically
This is where many business owners get tripped up. The temptation is to forecast based on what you hope will happen rather than what’s likely to happen. Your cash flow forecast is only useful if it’s grounded in reality.
Start with what you know:
Confirmed orders or contracts with expected payment dates.
Recurring revenue from retainers or subscriptions.
Historical sales data: what did the same period look like last year?
Then factor in what you can reasonably expect:
Pipeline deals that are likely to close.
Seasonal patterns (are certain months consistently slower?).
Payment behaviour: if your average debtor takes 45 days to pay, don’t forecast cash arriving in 30 days.
Be conservative. It’s far better to be pleasantly surprised by extra cash than to plan around income that doesn’t arrive. Understanding how working capital keeps your business running smoothly can help you think about inflows more strategically.
4. Map out your cash outflows in detail
- Rent and lease payments
- Salaries and wages
- Insurance premiums
- Loan repayments
- Software subscriptions
- Stock and raw materials
- Delivery and logistics
- Marketing and advertising spend
- Utilities (electricity, water, data)
- SARS payments (VAT, PAYE, provisional tax)
- Annual licence renewals
- Equipment maintenance or replacement
- Staff bonuses or year-end costs
Don’t forget the irregular expenses that catch businesses off guard. A good cash flow forecast accounts for the predictable and builds in a buffer for the unexpected. If you want to understand how rising costs might be eroding your margins, read our guide on how to make more profit in your business.
5. Calculate your net cash flow and closing balance
With your inflows and outflows mapped, the maths is simple:
Net Cash Flow = Total Cash Inflows – Total Cash Outflows
Closing Balance = Opening Balance + Net Cash Flow
Do this calculation for each week or month in your forecast period. What you’re looking for are the periods where your closing balance dips dangerously low or goes negative. These are your cash flow pinch points, and spotting them in advance is the entire point of the exercise.
If your forecast shows a shortfall three weeks from now, you have time to act: chase outstanding invoices, delay a non-essential purchase, negotiate extended terms with a supplier, or arrange short-term business funding to bridge the gap. If you only notice the shortfall when your account is empty, your options are far more limited.
6. Review, adjust, and use your forecast as a living tool
A cash flow forecast is not a one-and-done exercise. The most valuable forecasts are living documents that get updated regularly, ideally weekly. Each week, compare your actual cash position to what you forecasted. Where were you accurate? Where were you off? What changed?
Build these habits into your routine
Update your forecast every Monday with actual figures from the previous week.
- Extend the forecast by one week so you always have a 13-week rolling view.
- Flag any week where your projected closing balance drops below a comfortable threshold.
- Share the forecast with your accountant or financial advisor for a second set of eyes.
Over time, your forecasts will become more accurate as you learn your business’s cash flow patterns. You’ll start to anticipate the slow months, plan for big expenses, and make decisions from a position of knowledge rather than guesswork.
If you’re planning for growth, a solid cash flow forecast is essential. It helps you understand how much you can invest, when you’ll need funding, and whether your growth plans are financially sustainable. Read more about how to scale a business that’s working with the right approach.
7. Know when to bring in support
Building a cash flow forecast is something every business owner can learn to do. But if your cash flow challenges are deep-rooted, persistent shortfalls, mounting debt, or an inability to fund growth, a forecast will show you the problem, but you may need external support to solve it.
A good accountant can help you interpret your forecast and identify structural issues. And if your forecast reveals a timing gap between when cash goes out and when it comes in, business funding can drive growth when you need it the most. The key is not to wait until you’re in crisis. The best time to arrange funding is when your forecast shows you’ll need it, not when your bank balance hits zero.
Not sure if you’re ready? Learn how to prepare your business for funding so you can approach the process with confidence.
Take the guesswork out of your cash flow
Cash flow uncertainty is one of the biggest stressors for small business owners. But it doesn’t have to be. A simple, regularly updated cash flow forecast gives you clarity, control, and the confidence to make decisions that move your business forward.
Start with a basic spreadsheet. Keep it honest. Update it weekly. And when the forecast tells you that you need a bridge, don’t wait, act.
Need funding to solve a cash flow gap?
Genfin offers flexible business funding from R100K to R3 million, with offers in 24 hours and no hidden fees. Apply now or get in touch with a dedicated business funding analyst who can help you find the right loan solution for your business.
This article is for informational purposes only and does not constitute financial advice. Consult a qualified financial advisor for guidance specific to your business.