Decision rule: forecast the date of each credible receipt and committed payment, reconcile every cash location, and act before the projected balance crosses the approved operating buffer.
Turn the guide into a working forecast
Build a practical 13-week and 12-month small-business cash flow forecast using real payment dates, mobile money, stock purchases, payroll and tax.
Open the Cash Flow Forecast Tool →Cash flow is not the same as profit
Profit records income earned minus costs incurred. Cash flow records money that entered or left the business during a period. A credit sale may increase profit today while producing no cash until the customer pays. Buying six months of stock may consume cash immediately even though the stock becomes an expense only as it is sold.
This distinction explains why a busy shop, agency, farm-input dealer or contractor can show a positive margin and still miss payroll. IAS 7 classifies cash flows into operating, investing and financing activities. A small-business forecast does not need to imitate a formal financial statement, but the categories help owners separate routine trading from equipment purchases, loans and owner funding.
Use two forecasting horizons
Use a rolling 13-week cash flow forecast for immediate control and a 12-month forecast for seasonality and strategy. The weekly view should show the opening balance, expected receipts, scheduled payments, net movement and closing balance. The monthly view should show the larger pattern, including school seasons, harvest cycles, holiday trading, annual licences, insurance, rent renewals and loan instalments.
The 13-week model should be specific enough to name major customers and supplier dates. The annual model can work with sensible monthly groups. Update the weekly view every week and roll the monthly view forward whenever a major assumption changes.
Start with money you can verify
Begin with cleared bank, cash and mobile-money balances. Do not include unused credit facilities or customer promises in opening cash. Reconcile merchant wallets and payment gateways separately because settlement delays and withdrawal fees can make their displayed balance different from usable cash.
List receivables by the date cash is reasonably expected, not by the invoice date. If a customer regularly pays 20 days late, use the observed payment pattern. Mark disputed invoices and uncertain tenders as scenarios rather than base-case receipts.
Forecast cash in by channel
Separate cash sales, mobile-money collections, bank transfers, marketplace settlements, deposits, subscription receipts and loan proceeds. This makes timing errors visible. A card or marketplace sale may settle after fees. A wholesale customer may pay only after delivery approval. A grant or loan is financing cash, not recurring revenue.
For each channel, use volume, price, collection rate and settlement delay. Avoid a single optimistic sales-growth percentage. If the business is seasonal, compare the same period in prior years and document why the next period should differ.
Forecast cash out without hiding irregular costs
Map stock purchases, direct labour, payroll, rent, utilities, transport, data, platform fees, debt service, taxes, owner drawings and repairs to expected payment dates. Split fixed commitments from costs that move with sales. Include annual and quarterly payments in the week or month when cash leaves.
Create a separate line for foreign-currency purchases and update it when the supplier quote or exchange basis changes. Do not bury duties, clearing, delivery and payment fees inside a vague miscellaneous line. Those costs are often where an apparently healthy margin loses cash.
Build a base case, downside and action case
The base case should reflect the most supportable timing. The downside case can delay large receipts, reduce sales volume or increase an exposed input cost. The action case should show management responses such as collecting deposits, reducing purchase quantities, negotiating supplier terms or postponing a non-essential asset.
Scenarios are useful only when they change a decision. Define a minimum cash buffer and highlight every period below it. Assign an owner and action date to each projected shortfall.
Read the forecast as an operating document
A negative week is not automatically a failed business. It is an early warning. Ask whether the cause is slow collection, excess stock, a one-off asset purchase, weak margin, owner drawings or a structural gap between customer and supplier terms. The answer determines the response.
Review forecast versus actual every week. Record the variance by receipt timing, sales volume, cost, or unplanned payment. Repeated forecasting errors are management information: they show where records, pricing, collections or purchasing discipline need improvement.
Common forecasting mistakes
- Using invoice dates instead of realistic receipt dates.
- Counting approved loans, grants or tenders before cash is available.
- Ignoring mobile-money, gateway and marketplace settlement delays.
- Omitting tax, annual licences, repairs, owner drawings or debt principal.
- Forecasting sales growth without linking it to stock, capacity or customer evidence.
- Updating the model only when cash is already tight.
A practical weekly review routine
- Reconcile bank, cash and wallet balances.
- Confirm the five largest expected receipts and payments.
- Move delayed items to realistic dates.
- Compare last week’s forecast with actual movement.
- Review every week below the cash-buffer threshold.
- Agree actions, owners and deadlines.
- Save the revised forecast as the new operating view.
Source and decision boundary
IFRS Foundation, IAS 7 Statement of Cash Flows. The accounting standard supports the distinction between operating, investing and financing cash flows. This guide is an operating-planning explanation, not accounting, tax, credit or investment advice. Use local tax rules, lender terms and professional advice where the decision requires them.
How to structure the spreadsheet
Keep one row per cash-flow category and one column per week or month. Put assumptions in a separate area rather than typing unexplained totals into the forecast. For major receivables, maintain a supporting schedule with customer, invoice, expected date, confidence and collection action. For payables, keep supplier, commitment date, due date and payment priority.
Protect formulas and use simple version names so one person does not overwrite another person’s assumptions. The model should be readable on a phone or printable for a weekly meeting. Complexity that nobody updates is less useful than a disciplined, transparent table.
How sales, stock and cash connect
A sales forecast should drive stock and fulfilment cash requirements. More sales can require earlier inventory deposits, delivery riders, packaging, temporary labour or marketplace advertising. If those payments occur before customer settlement, growth increases the funding gap.
Link each important sales assumption to the purchasing plan and gross-margin check. This prevents a forecast from showing rising receipts while ignoring the cash needed to earn them. For service businesses, replace stock with the people, contractors, travel and software capacity required to deliver the work.
Collections are a process, not a forecast assumption
Make invoice accuracy, delivery evidence and follow-up part of the cash plan. Send invoices promptly, confirm the customer received the required documents and investigate disputes before the due date. Segment customers by payment behaviour and exposure rather than applying the same collection expectation to everyone.
Deposits, milestone billing and shorter validity periods can reduce risk where commercially appropriate. Do not disguise unaffordable terms or pressure vulnerable customers. The objective is a clear agreement that matches delivery and payment.
Questions for the management meeting
- Which three receipts have the greatest effect on the next four weeks?
- Which payments are legally or operationally non-negotiable?
- What is the earliest projected breach of the cash buffer?
- Which assumption changed since last week, and why?
- Which action improves timing without destroying customer or supplier trust?
- Does the annual view expose a seasonal financing need that should be addressed now?
Frequently asked questions
What is a 13-week cash flow forecast?
It is a rolling weekly view of opening cash, expected receipts, expected payments and closing cash across roughly one quarter.
How often should a small business update its cash flow forecast?
Weekly for the short-term view, and whenever a material customer, supplier, loan or cost assumption changes.
Should profit be included as a cash receipt?
No. Forecast the actual receipts and payments that create cash movement. Profit is a separate accounting measure.
What should I do when the forecast shows a cash shortage?
Identify the cause, test realistic actions, set a minimum buffer and assign each collection, purchasing or financing action to an owner.