It’s a common misconception that businesses fail because of bad ideas. They fail because the money arrives later (and leaves earlier) than expected.
That gap between expectation and reality is exactly what a cash flow projection is designed to expose.
It shows how much cash you are likely to have over a specific period of time, when pressure points are coming, and whether growth will stretch your business finances or support them.
For established small to medium-sized enterprises (SMEs), this matters more than ever.
Expansion brings upfront costs, delayed payments and higher operating expenses long before profits catch up.
Without a clear projection, even healthy businesses can end up short of working capital at the worst possible moment.
In this guide, we break down what such a projection really is. This will include how to calculate your cash-flow projections using practical examples and templates, and how to use them to make better financial decisions.
The goal here is simple: to help small business owners like you stay in control of your cash, and plan growth with confidence rather than guesswork.
What is Cash Flow Projection?
A cash flow projection is a simple way to estimate how much cash your business will have over a specific period of time.
It tracks when money is expected to come in and when it needs to go out, so you can see whether you will have enough cash to cover shortfalls and operate. It’ll also give you an idea of how ready you are to grow your business.
Unlike a cash flow statement, which looks back at what has already happened, a projection looks forward.
You could say that one explains the past, while the other helps you avoid repeating past business mistakes.
A cash flow forecast usually focuses on the short term, like the next three or 12 months. Longer-term projections, such as three-year views, are more strategic and based on market trends rather than detail.
Regular updates are also key, regardless of whether it’s a monthly, quarterly or yearly projection.
“For SMEs, cash flow projections only work if they’re part of the weekly routine, not a once-a-year spreadsheet,” says Welly Mulia, founder of CartMango, a digital checkout tool, and fractional CFO-style adviser.
“The owners who stay afloat use projections to plan launches, time payouts and decide if they can hire next quarter, because they always keep a short-term view of expected cash in and cash out.”
At its core, a projection subtracts cash outflows from cash inflows to calculate your net cash flow.
This shows your expected cash position at the end of each month and how much liquidity your business is likely to have available.
When done properly, a cash flow projection becomes one of the clearest indicators of your business’s financial health.
Think of it as a financial weather forecast – not perfect, but far better than being caught in the rain without an umbrella.
Cash flow projection vs profit
This is where many business owners get caught out. Profit on an income statement does not mean you have cash in the bank.
Your accountant may be celebrating, but your bank account might still be having a quiet month.
For example, you issue a R100,000 invoice this month. On paper, that looks like strong performance.
But if the client pays in 60 days, your accounts receivable are high while your cash balance stays at R0. In the meantime, you must still cover operating expenses, raw materials and salaries.
That gap creates negative cash flow, even in profitable businesses.
This is why cash flow projections matter more than profit figures when managing working capital and day-to-day liquidity.
What a Good Cash Flow Projection Actually Shows
A useful cash flow projection does not need to be complicated.
At its best, it gives you a clear picture of where your cash starts, where it’s coming from, where it’s going and what’s left at the end.
Here’s a breakdown of the data the projection will give you at a glance:
1. Opening balance
This is the cash you have available in your bank account at the start of your chosen timeframe.
It is your starting point and the number on which every other calculation depends. If this figure is wrong, the rest of your projection is basically a very confident guess.
2. Cash inflows
These are all the sources of money coming into the business:
- Sales revenue
- Funding
- Loans
- Owner or investor injections
It’s better to be realistic here and base estimates on actual performance where possible, not best-case scenarios.
Optimism is great for motivation, but less great for cash planning.
3. Cash outflows
This covers everything your business needs to pay for. Typical outflows include:
- Operating expenses
- Supplier payment terms
- Salaries
- Tax
- Raw materials
These often feel more predictable than inflows, which is exactly why they can catch you off guard when cash is tight.
4. Closing balance
This is your expected cash balance at the end of each month, after subtracting total outflows from inflows.
It shows your net cash flow and whether your cash position is improving or heading into risky territory. It is also the number that tends to ruin your mood first when things are not going well.
Together, these four elements give you a practical snapshot of your financial reality, not just what you hope will happen.
How to Prepare a Cash Flow Projection in Six Steps
This is where cash flow projections stop being a concept and start becoming useful.
You do not need complex models or advanced accounting software to get started. You do, however, need a clear structure, realistic numbers and the discipline to update it regularly.
“Most companies prepare one cash flow projection and then never touch it again,” says Melissa Pedigo, CPA and owner of Your Accounting Hero. She adds, “To be useful, it needs to be updated regularly. Without that, the projection quickly becomes irrelevant.”
With that in mind, here’s how to set up a cash flow projection that’s easy for you to update regularly:
Step 1: Choose your timeframe
Start by deciding how far ahead you want to project. For most SMEs, a 12-month cash flow projection is the sweet spot.
It’s long enough to support financial planning and funding decisions, but short enough to stay grounded in reality.
Monthly projections work well for most businesses.
Weekly views can be helpful if your cash position changes quickly or you operate with tight margins. Looking only at next month helps with short-term control, while longer-term projections support strategic decisions.
Always remember that the further you look ahead, the more accurate the projection will be.
Step 2: Set your opening balance
This is simply your current bank account balance. It sounds obvious, but many cash flow projections start with outdated figures. Always use real numbers, not last month’s memory.
Step 3: Estimate cash inflows
List all expected money coming in, such as sales, funding or loans. Use actual performance as your base and apply conservative assumptions. If you are choosing between the optimistic version and the realistic one, always pick the realistic one. Your future self will thank you.
Step 4: List cash outflows
Now capture everything your business needs to pay. This includes operating expenditures, supplier payments, accounts payable, tax and raw materials. These costs often arrive more reliably than income, which is why good cash flow management focuses heavily on outflows.
Step 5: Calculate net cash flow
Knowing how to create your cash flow projection means knowing your net cash flow.
To get this, you simply subtract total outflows from inflows to get your net cash flow. This tells you whether you will have enough cash or whether your balance is shrinking.
Step 6: Identify shortfalls
Scan for months with negative cash flow and flag potential shortfalls. These are your pressure points. Think of them as early warning signs, not personal failures.
This process gives you a practical view of your cash position and highlights risks before they become problems.
A Cash Flow Projection Example For a Real-World SME
Let’s bring this to life with a simple example.
Imagine a retail business opening a second branch. The owner has R50,000 in cash and expects higher sales, but also faces new upfront costs for rent, stock and staff.
Here’s what a six-month cash flow projection might look like.
At first glance, the business looks healthy.
Sales are growing every month, and revenue is trending in the right direction. On paper, everything feels encouraging; however, the bank account tells a different story.
Month three is the problem. Despite rising inflows, the business runs into negative monthly cash flow because expenses for stock, marketing and staff arrive before new business sales fully materialise.
The cash position dips below zero and stays tight until month five.
How the projection flags funding needs early
Without this projection, the owner might only realise there’s a problem when payments start bouncing. With it, the funding gap is visible months in advance. That is the real value of a cash flow projection. It shows you the cliff before you drive over it.
This allows the business to plan by securing a short-term loan, adjusting expenses or delaying expansion costs, instead of reacting in panic later.
Cash Flow Projection Templates
Knowing how to create a cash flow forecast template will take you a little time and effort to learn, but the benefits of doing so could last for years.
Here are some of the best options for going about this important task:
1. Use a Cash flow projection template
Many businesses start with a simple and free cash flow forecast template in Excel. This approach works well if you want full control and the ability to customise your model around your own numbers.
The main advantage is flexibility. You can adjust formulas, add extra categories and tailor the layout to match your business. It also forces you to engage closely with your figures, which can be useful when you are still getting comfortable with cash flow management.
The downside is that Excel is entirely manual.
Every update relies on you entering financial data correctly, which makes it surprisingly easy to build a very professional-looking spreadsheet full of very inaccurate numbers.
Errors can creep in and projections can quickly fall out of sync with reality.
2. Opt for accounting software and dashboards
Modern accounting software gives you a live view of cash flow, instead of just a historical report.
Dashboards pull data directly from your bank account and bookkeeping systems to show income and expenses side by side, over time, so you don’t have to guess what might happen next month.
Many modern tools offer visual cash flow charts that make patterns obvious at a glance. You can see which months generate strong inflows and how your cash position changes as the months roll on.
That makes it far easier to spot pressure points early, rather than discovering them when the balance drops unexpectedly.
Forecasts adjust as real transactions land because the data updates automatically.
This lets you automate a lot of manual work and reduces the risk of decisions being based on outdated numbers.
For growing businesses, cash flow stops being something you review once a month and becomes something you can monitor continuously.
Having this kind of real-time visibility turns cash flow from an admin task into a practical decision-making tool, whether you’re deciding to hire or take on extra funding.
How to Use Cash Flow Projection as a Growth Tool
A cash flow projection shouldn’t be an accounting task you tick off once a year. Instead, it’s a practical planning tool that helps you make better decisions and grow with more control – not to mention avoid unnecessary stress.
When you know your future cash flow position, you can spot negative cash flow before it happens and understand exactly how much funding you actually need. This is an amount that will keep the business moving without putting pressure on day-to-day operations.
It’s the difference between using funding as a tool and using it as a panic button.
This is where cash flow projections really earn their keep. They turn vague funding questions into clear answers, including:
- How much do you need?
- When do you need it?
- How will you repay it?
With those numbers in place, finding the right business funding becomes far easier.
The final step is choosing a provider that understands how small businesses really operate, like Lula. We offer flexible access to capital and support growth without rigid structures or unnecessary friction.
Accurate cash flow projections can help you make better funding decisions, and better funding decisions make growth easier to sustain.
