Cash flow management plans and monitors the timing of cash receipts and payments. A practical forecast starts with a reconciled opening balance, uses realistic collection dates and includes known commitments. It differs from a profit forecast because credit sales, asset purchases, loan movements and other items affect cash and accounting profit in different ways.
Start with the cash question you need to answer
A cash forecast should support a decision. Can the business meet the next payroll? How much room is available before ordering stock? What happens if a large customer pays two weeks late? Defining the question helps choose the time horizon and level of detail. A weekly forecast may be useful for near-term pressure, while a monthly view can support planning further ahead.
Start with the correct business and bank accounts. Separate unrestricted operating cash from amounts with specific conditions or commitments, and show overdraft facilities clearly rather than treating them as sales. Reconcile the opening position to reliable records. If the starting balance is wrong, even careful assumptions about future receipts and payments can create a misleading picture of available funds.
Keep the purpose distinct from a financial statement. The forecast is a management tool based on assumptions about future events. It is not evidence that customers will pay, funding will be approved or the business can lawfully make a distribution. Decisions involving solvency, liquidity, financing covenants or directors' responsibilities may require additional analysis and professional advice. A positive closing figure in one spreadsheet cannot settle those questions on its own.
Separate profit, cash and working capital
A credit sale may contribute to reported revenue before the customer pays. Buying equipment may require an immediate cash payment while its accounting cost is recognised over time under the applicable framework. Loan proceeds increase cash but are not ordinary trading revenue. These differences explain why a profitable business can experience cash pressure and why a large bank balance does not necessarily represent profit.
Receivables, inventory and payables help explain working-capital movements. More stock may absorb cash before it is sold. Customers taking longer to pay can increase reported sales without increasing current cash collections. Supplier terms can change the timing of outflows, but do not remove the underlying commitment. Review these movements alongside the forecast instead of relying only on the income statement.
For external reporting, IAS 7 distinguishes operating, investing and financing cash flows where that standard applies. A short-term management forecast need not mimic every presentation rule to be useful, but the categories can help explain why cash moved. Keep the labels consistent and avoid presenting a planning spreadsheet as a compliant statement of cash flows unless it has been prepared for that purpose under the relevant reporting requirements.
Build receipts from realistic collection assumptions
List confirmed customer balances and estimate when each material amount is likely to be collected. Use agreed due dates, actual payment behaviour and the status of disputes or delivery conditions. An invoice due next week is not automatically a guaranteed receipt next week. Where a customer has promised a payment, record the assumption and keep it under review rather than quietly treating it as certain.
Forecast new sales separately from the existing debtor book. Estimate the timing of invoicing, deposits, credit terms, returns and collection. This avoids counting the same customer amount once in opening receivables and again in projected sales. For card or online sales, consider settlement delays, fees and refunds. The gross sales number is not always the amount or date that reaches the bank.
Keep uncertain receipts visible. A proposed loan, insurance claim or asset sale should not appear as confirmed cash merely because it would solve a shortfall. Use a separate scenario or clearly labelled assumption. If the business depends on one major receipt, discuss the consequence of delay before the payment fails to arrive. A useful forecast exposes that dependency so that management has time to consider practical alternatives.
Map outflows using obligations and operating needs
Include supplier payments, payroll, rent, finance repayments, tax commitments, insurance and other recurring costs. Add known once-off items such as equipment, repairs or annual subscriptions. Use the actual payment dates and terms where available. A monthly expense budget divided equally into weeks may miss a large debit order that falls before customer collections, even if the month looks comfortable in total.
Show tax and statutory commitments using the business's actual registrations and current information. Confirm amounts and due dates with the responsible adviser. Avoid calculating a generic percentage of sales as if it were a complete tax provision. VAT, employee deductions, provisional tax and other obligations have different bases and timing. Keeping a separate tax-planning line can help, but it must connect to the relevant calculations rather than replace them.
Do not make the forecast balance by postponing payments without a credible basis. If a supplier has not agreed to changed terms, show the contractual expectation and a separate proposed action. Identify which outflows are unavoidable, which are discretionary and which require negotiation. This gives management a realistic view of decisions available, rather than a comforting closing balance created by assumptions that nobody has authorised or discussed.
Test a small number of meaningful scenarios
A base forecast should represent the business's best supported expectation. Then test a few changes that could materially affect cash: a late customer, slower sales, a stock purchase or a delayed project. Change one or two assumptions at a time so that the effect is understandable. A large model with dozens of unexplained scenarios can be harder to use than a simple, clearly labelled comparison.
For each scenario, identify the lowest cash point and the date it occurs. A positive balance at month-end may conceal a shortfall in the middle of the month. Note the action needed, who must approve it and when a decision is required. Options might include collecting overdue amounts, agreeing a payment schedule, delaying discretionary spending or discussing finance. Their availability depends on the actual business circumstances.
Treat financing as a separate decision with costs and conditions. An unused facility may not be available on the date or terms assumed, and borrowing does not repair an unprofitable operating model. A forecast can inform a funding conversation, but it is not a recommendation to take a particular financial product. Discuss affordability, contractual restrictions and legal responsibilities with the appropriate advisers before making commitments.
A practical example: a profitable month with a tight week
Imagine a hypothetical business starting a month with R40,000 in operating cash. It expects R100,000 from customers during the month and has R110,000 of planned payments. The monthly view suggests a R30,000 closing balance. However, R60,000 of customer receipts are expected only in the final week, while payroll and a supplier payment fall in the second week. The business may face pressure before the month-end receipt arrives.
A weekly view reveals the timing gap. Management can check the collection assumptions, confirm payment dates and decide whether any discretionary spending can move. If a supplier is asked to accept a later payment, that is a proposed action until agreed. The forecast should not silently assume approval. This illustration ignores VAT and other details to isolate timing; a real forecast needs the business's actual obligations and records.
Suppose the largest customer then indicates a possible delay. The forecast can show a separate downside case and the date by which action is necessary. That does not mean the delay will happen, but it gives management a way to prepare. The value is in the early conversation and documented assumptions. A forecast that is updated only after the bank runs short loses much of that practical benefit.
Compare actual cash with the forecast and learn
At each update, replace elapsed forecast periods with actual receipts and payments. Explain the significant differences: an amount changed, a payment moved, a customer was missed or the original assumption was unrealistic. Keep enough history to learn from the comparison. Rewriting the old forecast to match reality removes the evidence that helps improve the next one.
Classify differences by cause. A timing variance may reverse next week; a lost sale may not. A once-off repair has a different implication from a recurring cost increase. Review whether the change affects later periods and whether the business needs to adjust operating plans. This links cash management to budgeting and management accounts without pretending they are interchangeable reports.
Use a regular review rhythm and a single current version. Name the person responsible for updating the forecast and the people supplying sales, payroll and purchasing information. Record major assumptions and decisions in plain language. A spreadsheet that only one person understands becomes fragile when they are absent. A proportionate, transparent model is easier to challenge and maintain, which usually makes it more useful than unnecessary complexity.
Prepare a useful cash-planning discussion
Bring reconciled bank balances, aged customer and supplier reports, payroll dates, finance schedules and known tax commitments. Add a list of large expected sales, purchases and unusual transactions. Explain seasonal trading patterns and any uncertainty about collection. The better the starting information, the less time the conversation needs to spend reconstructing basic balances.
Agree the forecast's purpose, horizon and update frequency. Decide which amounts require detailed scheduling and which can sensibly be grouped. Identify the decisions that the owner wants to make from it and the limits of the available information. If the records are incomplete, acknowledge that uncertainty rather than give the forecast an appearance of precision it cannot support.
Axia Finance can help connect cash planning with bookkeeping, customer and supplier balances, management accounts and budgets. The aim is a clearer view of commitments and choices. It does not remove trading risk or guarantee a particular cash result. Start with a dependable opening position, realistic dates and a short list of assumptions that management can explain and revisit as the business changes.
Common questions.
Why can profit increase while cash falls?
Sales may be recorded before customers pay, stock can absorb cash and equipment or loan repayments can create outflows with different effects on profit. Review receivables, inventory, payables, asset purchases and financing movements. A cash forecast and income statement answer different questions and should be read together rather than used as substitutes for each other.
How far ahead should a cash forecast look?
Choose a horizon that supports the decision. A business under near-term pressure may need a weekly view, while a stable business may also use monthly planning for a longer period. Keep enough detail to identify the low cash points and major commitments. The forecast should be updated as actual trading and collection information changes.
Can I treat expected finance as available cash?
Only with clear assumptions about approval, conditions, drawdown timing and restrictions. An application or informal discussion is not the same as funds received. Show unconfirmed finance separately or in a scenario so that the base forecast does not depend on money that may not arrive. Obtain appropriate advice before entering a financing commitment.
Support for your next step.
Axia Finance supports individuals and businesses across Greater Cape Town, the Cape Winelands and the Cape West Coast. Explore our accounting & bookkeeping services or discuss your circumstances with us.
Continue with the accounting knowledge collection for related practical guides.
Sources and further reading.
Official references consulted for this guide. Rules and administrative processes can change; check the applicable period and your circumstances.
General educational information, current to 5 November 2026. This guide does not determine the legal, tax or accounting treatment of a particular person or transaction. Obtain advice appropriate to your facts before acting. Read our editorial approach.
