How should I plan cash flow when customers pay later than agreed?

Keep the contractual date and expected receipt date

The invoice due date states when the customer should pay under the agreed terms. The cash forecast needs the date on which funds are realistically expected to clear. Keep both dates in the collection schedule. Replacing one with the other loses the distinction between contractual entitlement and planning judgement, and makes it harder to see how late the customer actually is.

Start with an accurate debtor age analysis. Reconcile customer payments, credit notes and disputed balances before forecasting collections. An invoice that was already settled but not allocated should not appear as future cash. A duplicate customer entry can create false confidence even when the formula in the forecast is correct. Resolve these bookkeeping issues before debating which week to use.

Find the reason for the delay

A customer may be waiting for a purchase order reference, delivery acceptance, an internal approval or a corrected invoice. Another may accept the debt but have a funding problem. These situations require different actions and different expectations. Contact the relevant payment or procurement person through a verified channel and record the actual blocker rather than using a generic note that payment is being processed.

Ask what must happen next, who owns it and whether there is a confirmed payment run. A promise from a project contact who cannot approve invoices is weaker evidence than confirmation from the responsible accounts team after acceptance. Neither guarantees settlement. Record the source and date of each update so the forecast does not preserve a month old promise as if it were current.

Classify receipts by evidence, not optimism

These are planning categories, not official credit ratings. Choose labels your team can use consistently and explain them in the forecast. Avoid automatically assigning a percentage likelihood without evidence; the apparent precision can hide a weak assumption.

Illustrative example: the promised receipt moves

A fictional service company begins a week with R40,000 available cash. It expects a R60,000 customer receipt and has R70,000 of scheduled outflows that week. The expected closing balance is R30,000. The customer then confirms that the invoice has missed its payment run and will be considered the following week. Without the receipt, the same week closes at negative R30,000 in the forecast.

The example uses invented amounts and omits other transactions for clarity. It does not assume a negative bank balance is permitted. The negative forecast is a warning that the proposed payment plan is not funded. The owner needs an action before the affected payments are due: confirm another supported receipt, agree revised terms, reduce an uncommitted purchase or arrange approved funding.

Moving the R60,000 receipt to the next week must remove it from the original week. Keeping it in both places is a common spreadsheet error. If only R20,000 is expected as a part payment, split the remaining R40,000 explicitly and record the basis for its later date. The customer ledger remains the control total for the invoice balance.

Build a short term plan that shows the difficult dates

Use daily or weekly periods where timing is tight, then a broader view for later months. Start from the actual available bank balance and distinguish existing customer debt from projected new sales. Include payroll, supplier payments, taxes, finance commitments and other outflows using their real dates. A forecast of receipts alone cannot establish whether the business can meet commitments.

Mark outflows that are already committed separately from proposed spending that can still be changed. An owner may be able to defer a new equipment purchase but cannot simply ignore a contractual payment. Discuss the consequences before changing a commitment. Keep the original due date, proposed revised date and agreement status visible so an unaccepted proposal does not become the base assumption unnoticed.

Test delay where it matters most

Create an expected case and a slower collection case for significant or unreliable balances. Move particular receipts to plausible later dates based on the customer history or unresolved issue. Identify the lowest projected cash point and which commitments create it. A business dependent on one large invoice needs a different discussion from one with many small customers paying at varied intervals.

Also test whether the invoice may be reduced by an agreed credit or retention. Timing and amount are different risks. Do not count a disputed portion as both a doubtful receipt and a confirmed amount available to pay wages. The forecast should show how the business responds if the uncertain amount is delayed or not collected within the planning period.

Connect collection activity with the forecast

Give each important outstanding balance an action owner. Record the next contact, missing document, escalation route and expected update date. This need not become a complex system. A short, maintained schedule is more useful than many spreadsheets with different balances and no owner. Keep communications factual and consistent with the contract and the business’s collection policy.

Before using formal recovery steps, interest charges, service suspension or other remedies, check the actual agreement and obtain appropriate advice. Do not invent a penalty or threaten action the business cannot take. The forecast should reflect the expected effect of an agreed plan, while the collection process follows the proper contractual and legal route. Preserving customer correspondence also helps explain later accounting judgements.

Use actual receipts to improve assumptions

At each review, compare what was forecast with what cleared. Separate timing differences from amount differences and from missing data. If a customer reliably pays after its internal approval cycle, use that evidence for future planning while continuing to enforce agreed terms. If the payment pattern deteriorates, do not carry forward the old assumption merely because it makes the forecast positive.

Be careful with averages. A customer whose small invoices pay quickly but major invoices require extra approval can look reliable overall while creating serious pressure on a large project. Review important contracts individually. Equally, one exceptional delay does not prove every future invoice will be late. Use the relevant evidence and state where the business has limited history.

Keep new sales separate from existing invoice receipts

A forecast often combines two populations: invoices already issued and sales expected to happen later. Check the transition between them. When a projected sale becomes an actual invoice, remove or replace the original assumption so that the same expected customer payment does not appear twice. Assign a reference to significant opportunities and orders to make that transition visible.

Also check whether expected new sales require spending before collection. Winning another project can add supplier and payroll commitments before it adds cleared receipts. Use the contract’s invoicing milestones and likely approval process instead of assuming that an order immediately produces cash. A deposit improves the forecast only if the customer has agreed to it and the expected payment date is credible.

At the forecast review, reconcile existing invoice receipts to the debtor ledger and reconcile future sales assumptions to the sales plan. The two totals answer different questions, but their timing must work together in one cash schedule.

Make the forecast a decision record

Save dated versions with the major assumptions and approved actions. After a supplier agrees a revised payment date or a customer pays early, update the working forecast and retain the reason. This provides a useful record of what management expected and what it did when information changed. Do not rewrite old versions to make earlier forecasts appear more accurate than they were.

Vatco’s cash flow management service can help organise customer balances and commitments into a practical cash view. Bring the current debtor age analysis, recent collection correspondence, bank position and payment schedule. The related article on profit and supplier payment pressure explains why even a good margin does not remove the need to plan the dates.