Revised practical article; source details and figures are dated to their cited filing or event, with current evidence reviewed through 24 September 2026.
A cash forecast is most useful before there is a crisis. For a small business, the working version does not need to predict the whole year with false confidence. It needs to answer a simpler question: if the expected customers pay when promised, and the bills on the calendar are paid when due, when does the bank balance become uncomfortable?
A rolling 13-week cash forecast gives an owner a practical weekly view. Each week begins with the prior week’s closing cash. The business adds dated receipts and subtracts dated payments. The closing number becomes next week’s opening number. Repeat weekly and update actuals as they arrive.
Closing cash = opening cash + receipts − payments
This forecast is about timing. It does not say the business is profitable. A loan advance appears as a financing receipt and its repayments appear later as financing payments. It should never be mixed into customer collections. For each forecast line, record the source: invoice, purchase order, payroll calendar, rent clause, loan agreement, or an explicitly marked estimate.
Four jobs for the weekly routine
1. See the cash trough
List confirmed customer receipts by expected bank date, not invoice date. Separate confirmed orders from hoped-for new sales. For customers who regularly pay late, show an expected date that reflects the observed pattern, and keep the contractual due date beside it. A receipt becomes less dependable if delivery, acceptance, or a missing document can delay payment.
Payments should have the same specificity: payroll date, rent date, tax payment, supplier payment terms, loan instalment, delivery fuel, and committed stock purchases. Avoid a single “other costs” line so large that it hides an action.
The owner can compare the forecast low point with a minimum cash floor. That floor is not a universal number of weeks. It reflects payroll, cash volatility, supplier alternatives, customer concentration, seasonality and access to committed facilities. A facility counts as available only if the agreement is signed, the draw conditions can be met, and it is not already used.
2. Learn where contribution comes from
Sales are not all equally useful. Contribution margin estimates what remains from a sale after variable costs that move with that sale. For a product line:
Contribution per unit = selling price − variable cost per unit
Break-even units = fixed costs over the period ÷ contribution per unit
Include variable costs that belong to the sale: product cost, payment processing, delivery, commissions, consumables, and relevant returns or spoilage. If labor is fixed within a period but varies with output at a higher level, explain that boundary. The equation is a decision aid, not a substitute for checking capacity and cash timing.
A fictional bakery sells a loaf for KSh 100. Flour, packaging, and incremental fuel total KSh 62 per loaf. Contribution is KSh 38 before fixed costs. If weekly fixed costs are KSh 76,000, the simple break-even volume is 2,000 loaves a week. But if the oven can produce only 1,600, then the break-even result is physically impossible under the current setup. If supermarkets pay 45 days after delivery, a profitable order can also create a cash shortage.
3. Watch the invoice and stock clocks
DSO, DIO and DPO can help describe the timing of money through a business. Compute them consistently and compare the business with itself over time before comparing it with others. For a seasonal shop, use weekly or monthly detail to explain why a year-end number moved.
An ageing list is often more actionable than a single average. For receivables, show invoice number, customer, amount, original due date, days overdue, dispute status, promised payment date, and the person responsible for follow-up. For inventory, show SKU, quantity, last movement, reorder lead time, open purchase order, expiry or damage exposure, and annual usage value.
ABC analysis can rank stock by usage value. It does not mean that every “C” item should be removed. A low-value spare part can prevent a costly machine stoppage. A reorder point can start with expected demand during supplier lead time plus safety stock. The safety stock depends on demand variability, supplier reliability, and the service level the business chooses. There is no safe universal rule that every MSME should carry three times its average stock or write off an item after an arbitrary number of days.
4. End each review with decisions
A weekly meeting should leave a small action log. For example: “Call customer A about invoice 184, due last Friday; confirm whether the delivery note is accepted by Tuesday; owner: Sam; expected receipt date: 4 October.” Or: “Hold the optional equipment order; check the repair quote and next two weeks’ receipts by Thursday.”
Separate facts from assumptions. “Invoice issued” is a fact. “The customer will pay on Friday” is an estimate unless the customer confirms it. The owner should compare forecasts with actuals each week, not to punish a forecast that was wrong, but to learn which customer or payment type is repeatedly mis-timed.
Research on SMEs supports treating cash and working capital as connected operating choices. García-Teruel and Martínez-Solano found relationships between shorter collection/inventory periods and profitability in their Spanish SME panel [1]. Afrifa’s study of UK SMEs found that incorporating cash flow changed the modeled relationship between working capital and performance [2]. These findings motivate monitoring; neither supplies an ideal DSO or cash reserve for a Nairobi wholesaler. Deloof studies a separate Belgian-firm sample, while Nicolas examines short-term financial constraints and SME investment through the working-capital channel [3], [4]. Different settings and research questions are a reason to use this literature as context for measurement, not as a universal operating threshold.
Do not confuse a ratio with a policy
A widely repeated LTV:CAC ratio, a gross-margin target, or a stock-holding rule can be useful in a narrow setting only when the terms are defined and the business economics fit. “Customer acquisition cost” might exclude owner time, failed trials, or sales commissions. “Lifetime value” might assume customers stay much longer than they do. A healthy ratio on a spreadsheet cannot rescue a business that pays for inventory months before customers pay.
Likewise, shortening payables can harm the business if a key supplier stops offering credit. Delaying tax, payroll or a secured loan is not a harmless cash-management tactic. The forecast should show the consequences and the contract terms, not simply call every delayed payment “working-capital optimization.”
Turn the 13-week view into a weekly operating ritual
A cash forecast works when the people closest to each event update it. Finance owns the ledger; sales owns customer commitments; procurement owns supplier dates; operations owns stock and delivery; the owner resolves trade-offs. Ask each person to bring evidence: remittance advice, signed purchase order, supplier statement, payroll schedule, tax deadline or loan notice. A forecast entry should carry an amount, date, source and confidence status. This is often more valuable than adding more rows or formulas.
Use a rolling window. At the end of each week, archive the prior forecast, enter actual cash, move the horizon forward by one week and add newly known events in week 13. Never overwrite last week’s expected date because it was missed; retain the variance. This gives the owner a short record of forecast accuracy. If a customer is normally 10 days late, after several observed delays the forecast can use a later date and the credit policy can change. If one storm created a unique delay, keep it in the downside case instead of making every customer appear permanently unreliable.
Separate confirmed from conditional receipts. A cleared mobile-money settlement is confirmed. A customer promise by phone is conditional. An unsigned order is pipeline and belongs in a sales forecast, not a cash forecast. If management wants to include pipeline as a scenario, show probability and the week cash would realistically arrive after delivery, invoice and terms. Do not let the current sales target masquerade as a bank deposit.
Create two cash lines: unrestricted cash and restricted or committed cash. The latter can include tax collected for remittance, customer deposits due for fulfillment, security deposits, lender reserve accounts and grant funding with restrictions. The business may have the funds in its account but not have the right or practical ability to spend them on payroll. Likewise, show a committed overdraft separately from cash and record draw conditions, borrowing base, renewal date and required clean-down.
A useful weekly meeting ends with named actions, not a spreadsheet tour. Identify the next low-cash week, the three receipts or payments most likely to move it, what evidence will arrive before the next review, and who will respond. If the lowest projected balance remains above the reserve floor, the meeting can focus on margin and stock quality. If it falls below the floor, the owner decides now whether to collect, reduce orders, defer optional capex, negotiate a payment schedule or draw committed funding. The decision and expected cash impact are recorded, then tested against actuals next week.
Measure burn without inventing runway
For a young or loss-making firm, define operating burn from recurring operating cash after customer collections and ordinary supplier payments. Report gross cash operating outflow separately if it helps show the cost base. Exclude financing proceeds from the operating measure. Identify one-off restructuring, asset purchase and growth expansion separately so a temporary buildout is not mislabeled as normal burn. Also show debt principal, tax, capex and owner withdrawals because these consume cash even if they are not in a chosen operating-burn definition.
A runway quotient is useful only when net cash burn is positive and reasonably stable. If a company has KSh 3 million unrestricted cash and burns KSh 500,000 monthly, a simple six-month quotient is an initial signal. But if KSh 2 million of supplier payments fall in month two or a seasonal collection arrives in month three, the dated cash forecast gives a different answer. If net burn is zero or positive, do not display infinite runway. Say that the quotient is not meaningful in that period, then show the minimum projected cash and major upcoming obligations.
Separate operating cash, expansion cash and one-off cash needs. A new branch may make the forecast negative even though mature units generate cash. Conversely, positive gross margin may not cover central staffing or old debt. Show how many weeks of runway remain if growth hiring is paused, then compare it with the fully funded plan. This reveals whether a financing round is buying expansion or merely covering recurring losses. For lender review, also calculate CFADS under the contract’s definition and debt-service dates. Do not include an unsigned equity round as a committed receipt.
Unit economics need both contribution and cash
For each product, route or service, start with collected or collectible net revenue after discounts, refunds and indirect taxes where relevant. Subtract costs that change with delivery: stock, packaging, payment fee, delivery, commissions, spoilage, customer support and variable labor. The remainder is contribution. Add fixed costs at the level where the decision is made: route, store, branch or the whole company. Keep shared costs transparent rather than assigning all head-office expense to a new unit.
Consider an order sold for KSh 3,000 net. Direct product cost is KSh 1,600, packing KSh 120, payment costs KSh 60, delivery KSh 250 and expected returns or damage KSh 70. Contribution is KSh 900. If the channel spends KSh 180 per first order to acquire a new customer, initial contribution after acquisition is KSh 720 before fixed cost. If repeat orders arrive without the same acquisition cost, cohort contribution can improve. But if the customer does not repeat or pays after 45 days while suppliers require payment in 14, acquisition payback may be cash-negative. Show repeat frequency, retention and collection dates, not only lifetime-value estimates.
Calculate volume break-even as fixed cash cost divided by contribution per unit. Then calculate cash break-even by adding debt service, maintenance investment and any required tax or reserve. For example, fixed monthly operating cost of KSh 240,000, maintenance of KSh 40,000 and debt service of KSh 50,000 divided by KSh 800 contribution per delivery requires 413 deliveries per month. That threshold moves if price, discounts, delivery density or variable input costs change. Run an adverse case with lower average basket and fewer stops per route before assuming scale solves it.
When a unit has positive contribution but negative allocated profit, ask whether the contribution covers avoidable costs and whether it helps support shared capacity. When contribution is negative, additional sales generally deepen losses unless there is a clearly timed learning or launch investment with a stop rule. A new unit should have an investment gate: minimum contribution, utilization, service quality and cash payback date. Review those conditions after launch rather than letting the forecast continue unchanged.
Make AR aging a collection plan
An invoice ledger should include customer, invoice ID, work or goods delivered, invoice amount, balance, invoice date, due date, dispute status, evidence of acceptance, last contact, promised payment date, collector and credit limit. Aging is based on days past the agreed due date, not days since invoice if terms allow 30 days. Divide balances into current, 1–30, 31–60, 61–90 and over 90 days, and put disputed or not-yet-accepted balances in their own categories.
A simple DSO is average trade receivables divided by credit sales for the matched period, multiplied by period days. If a retailer also makes cash sales, total revenue will understate DSO by inflating the denominator. If sales are seasonal, compare like periods and show opening and closing balances. DSO is an average and can hide one buyer with a large late amount, so show the top five customers, concentration and overdue balances relative to weekly payroll and critical supplier needs.
The collection ladder can be proportionate: confirm delivery and invoice receipt before the due date; send a statement on the due date; ask for a specific remittance date after a miss; agree a partial payment plan if the customer is viable; stop new exposure at the credit limit; escalate to the owner or insurer; and use formal collection remedies when appropriate. A discount should have an approval limit and be compared with financing cost, bad-debt probability, margin and customer precedent. Record whether the payment actually cleared.
Stock control that protects service and cash
For each SKU, record quantity, unit cost, last sale, units sold per week, lead time, open orders, expiry or obsolescence, gross margin and supplier minimum. ABC analysis sorts by annual consumption value, but a high-value category should not automatically receive all managerial attention. A low-cost item that stops a repair or an essential service may deserve a minimum safety stock. Pair annual consumption value with criticality, uncertainty, substitution and lead time.
Turnover is cost of goods sold divided by average inventory; DIO is average inventory divided by matched-period cost of goods sold times period days. Calculate by category and compare similar seasons. Add ageing buckets and stockout days. An item that has not sold for 60 days may be normal for a seasonal product or a serious warning for fresh food; no universal dead-stock day applies. Estimate carrying costs from actual storage, insurance, spoilage, financing and markdown experience. The 20–30% holding-cost figure in the supplied notes remains an unverified lead, not a default assumption.
A reorder point can be estimated from average daily usage times supplier lead days plus safety stock for demand and lead-time variation. Validate with actual purchase-to-receipt dates. If lead time is uncertain, keep a low/base/high estimate and establish an emergency alternative. Before marking down or returning inventory, compare expected net recovery with carrying cost, expiry risk, supplier credit and the effect on customer availability. A markdown that releases cash but loses more contribution than it saves may be the wrong move.
AP aging must distinguish agreement from distress
For each supplier, record the contracted term, invoice date, due date, amount, dispute, amount paid, next delivery, alternative source and business criticality. Split current, 1–30 days overdue, 31–60, 61–90 and over 90. Reconcile ledger totals to supplier statements. An unresolved difference can indicate missing invoices, credit notes, goods received not invoiced or a genuine dispute. DPO should use credit purchases and an average payable balance for the same period; it does not certify that payments were made on terms.
Prioritize suppliers by operational dependence, lead time, quality, substitution and exposure, not simply largest balance. A written extension can be a negotiated financing source. Silence and missed due dates are not consent. If a critical supplier moves to cash-on-delivery, update the forecast immediately and estimate the stock or sales affected. When asking for relief, provide a credible payment calendar and update the supplier before each date. The business may preserve a relationship by being precise even if it cannot pay the full amount immediately.
Turn action choices into comparable scenarios
Put collection, discount, return, markdown, reorder pause, supplier plan and facility draw in the same scenario table. For each, show cash released and date, margin impact, future service risk, relationship effect, legal or contract implications, and accountable person. If a KSh 300,000 invoice can be collected 35 days earlier for a 2% discount, the discount costs KSh 6,000. At 18% annual financing cost, the simple carrying cost avoided is about KSh 3,107 before default risk and administrative effort. The discount is not justified by financing alone, but may make sense if default risk or payroll impact is substantial. State the true reason.
For stock, compare markdown proceeds with expected future net sale proceeds and carrying cost. For supplier settlement, compare a prompt-payment discount with borrowing cost and operational continuity. For a return, include restocking fees and future stockout risk. After each action, reconcile actual cash and contribution. A dashboard that never compares expected and actual impact is a reporting page, not an operating tool.
Start the weekly system with six measures: next cash trough, contribution per order, aged receivables, aged inventory, overdue critical payables and confirmed borrowing headroom. Add a metric only when a decision owner and response are clear. This keeps the operating process usable by a small team and directs attention to the cash or margin problem that can still be changed.
A weekly operating meeting that connects the numbers to action
A small firm does not need a complicated dashboard to make better decisions. It needs a short meeting with the people who can change collections, purchasing, production and customer service. Keep one page and review the same measures each week: opening cash, lowest forecast cash, collections due and collected, overdue receivables, stock-outs, slow stock, supplier commitments, payroll and statutory payments, completed orders, gross margin and work not yet invoiced.
For each measure, show current value, recent direction, owner, next action and deadline. Avoid a red-yellow-green score with no underlying amount or customer. “Collections are behind” is not an action. “KSh 420,000 from three invoices is six days past the agreed date; Amina will call the customer finance lead by Tuesday and confirm the payment reference” is. If the customer disputes delivery, assign someone to provide proof of delivery and resolve the dispute; do not continue sending generic reminders.
The meeting should last 30 to 45 minutes. Begin with the cash forecast and critical obligations. Review exceptions rather than reading every line aloud. Agree which orders to accept, defer or renegotiate based on contribution after direct costs, collection risk and capacity. End by writing decisions into an action log. The next meeting opens by checking whether each action happened and whether it changed the underlying measure.
Worked example: a wholesaler with rising sales and falling cash
Imagine a small building-supplies wholesaler whose monthly sales rise from KSh 4.0 million to KSh 4.8 million. The owner celebrates 20% growth, but the bank balance falls. A practical review finds that average customer collection has lengthened from 30 to 45 days, stock has grown by KSh 450,000 because the team bought several slow-moving lines, and suppliers have been paid promptly despite agreed 30-day terms. The company may be earning a positive gross margin while financing customers and holding stock before the cash arrives.
Start with a 13-week forecast. List the ten largest receivables by invoice and expected date, not a single assumed collection ratio. Split stock into committed fast movers, seasonal items and lines with no movement. Call customers about disputed invoices and confirm delivery documents. For new credit sales, require a limit and a named approver. For slow items, decide whether to return, discount, bundle or stop replenishment. Speak to suppliers before changing payment timing; agreed terms are a relationship and contract constraint, not free financing.
Then compare two actions. A blanket credit freeze may preserve cash but lose reliable customers and sales. Continuing current terms may preserve volume but worsen the cash gap. A narrower policy could retain terms for customers with reliable payment history while requiring a deposit or shorter terms for new and overdue accounts. Measure both the cash effect and the contribution lost or protected. Working-capital evidence in SMEs links liquidity needs, financing constraints and investment decisions, so management should evaluate the effect on operations instead of treating a lower balance as automatically superior [1, 2, 4].
Use triggers as questions, not universal rules
A trigger is a prompt to investigate. For instance, if one customer becomes a large share of overdue receivables, review concentration, dispute history and the cash effect of losing that customer. If gross margin falls, test purchase prices, discounting, product mix, waste, returns and theft before concluding that sales staff need to sell more. If stock cover rises, inspect the item-level age and supplier lead time before stopping all purchases.
Set the trigger from the business's own history, contract terms, service promise and tolerance for a missed obligation. Record the baseline, the threshold, the action it triggers and who can override it. An override should have a reason and an expiry date. This lets the owner learn whether the trigger is useful without mistaking a convenient number for an industry law.
Keep a simple control trail
Every significant number on the dashboard should lead to a source: ledger, bank statement, invoice, delivery record, stock count or signed supplier term. Mark estimates separately from actuals and record when they were last checked. Limit who can create a supplier, approve a payment or change a customer's credit limit. Where a small team cannot separate duties, use a second-person review and monthly bank reconciliation as compensating controls.
A practical toolkit is not a miniature listed-company reporting pack. It is a repeatable routine that gives the owner enough warning to act while there is still time to negotiate, collect, slow a purchase or arrange financing. The weekly meeting should produce fewer surprises over time, not simply more charts.
Workbook map
The Project 1 workbook puts the 13-week cash forecast, low-cash point, net burn and indicative runway together on Cash13W. In its fictional route case, KSh6.0m opening cash reaches a KSh5.58m low under Base but falls to a KSh3.49m deficit under the combined downside receipts and supplier schedule. That is a warning to change the forecast or financing plan, not a claim about a real business. Receivables and Payables calculate outstanding balances and ageing from due dates; Inventory calculates stock value, ABC share, days since sale and a lead-time reorder review; Unit Economics calculates contribution and break-even; Action Log records an owner, deadline, cash or margin effect and outcome. Evidence Vectors maps the 13 forecast periods and the invoice/SKU schedules to their cells and marks the case as fictional; the forecast has explicit week starts, while the other scenario dates are tied to their own schedules and as-of date. Replace sample ledgers with dated customer, stock and supplier records.
Technical appendices
The worked calculations and source boundaries below extend this article's examples. They keep assumptions and unresolved inputs visible so readers can reproduce the steps without mistaking an illustration for an issuer or sector estimate.
References
[1] P. J. García-Teruel and P. Martínez-Solano, “Effects of Working Capital Management on SME Profitability,” International Journal of Managerial Finance, vol. 3, no. 2, pp. 164–177, 2007, https://doi.org/10.1108/17439130710738718.
[2] G. A. Afrifa, “Net Working Capital, Cash Flow and Performance of UK SMEs,” Review of Accounting and Finance, vol. 15, no. 1, pp. 21–44, 2016, https://doi.org/10.1108/RAF-02-2015-0031.
[3] M. Deloof, “Does Working Capital Management Affect Profitability of Belgian Firms?” Journal of Business Finance & Accounting, vol. 30, no. 3–4, pp. 573–588, 2003, https://doi.org/10.1111/1468-5957.00008.
[4] T. Nicolas, “Short-Term Financial Constraints and SMEs’ Investment Decision: Evidence from the Working Capital Channel,” Small Business Economics, vol. 58, pp. 1885–1914, 2022, https://doi.org/10.1007/s11187-021-00488-3.
Companion resources
The workbook and technical appendices are available with research membership. The video production guide maps this article to a planned episode; a published video is not yet available.
No public comments yet. The first thoughtful question can start the discussion.