Customer payment patterns can differ sharply from the work delivered. A deposit may arrive before costs begin, a milestone payment may depend on approval and a subscription may renew only while the customer remains active. A useful forecast reflects those conditions rather than placing total sales into convenient weeks.
In this article
- Identify each payment arrangement
- Separate service dates from receipt dates
- Allow for refunds and late payments
- Reconcile expected receipts with the bank
Start with the agreement and the actual payment process. Identify what triggers each receipt, who approves it, how money is collected and whether refunds or deductions may apply. Keep the cash forecast separate from revenue recognition and VAT reporting.
Deposits: connect the advance to remaining work
Record the expected deposit date, amount and collection method. Identify the work and costs still to be funded. The receipt may improve the bank balance immediately, but it comes with delivery and possibly refund obligations under the actual agreement.
Illustrative example: a fictional contract totals £12,000, with a £3,000 deposit and £9,000 balance. Forecasting £12,000 at completion plus the £3,000 deposit would double-count £3,000. The cash plan should show the deposit and only the remaining balance, at supported dates.
Check whether the deposit has actually been paid and allocated. An invoice requesting an advance is not an advance already available to spend. Keep cancelled bookings and refundable amounts visible rather than combining them with unrestricted receipts.
Staged payments: test the milestone process
For each stage, record the delivery requirement, evidence, approval owner, expected invoice date and payment terms. A completion date is not necessarily the collection date.
If a customer has to inspect or sign off work, allow for that process using evidence from current correspondence and prior experience. Separate confirmed approval from an assumption that approval will occur on time.
| Payment type | Key forecast condition |
|---|---|
| Deposit | Cleared receipt and remaining delivery commitments |
| Milestone payment | Stage achieved, accepted and invoiced appropriately |
| Final balance | Completion, deductions and agreed payment terms |
| Retention | Contractual release event and supported timing |
| Subscription | Active customers, renewal and collection success |
Illustrative staged scenario: a payment expected in week six depends on customer acceptance. A two-week approval delay moves collection later while labour costs continue. Show that delay in the downside case instead of assuming the milestone date guarantees cash.
Do not infer a right to invoice or collect from a project schedule alone. Check the contract and resolve any disputed conditions before treating the receipt as reliable.
Subscriptions: model active customers and collection quality
Use current customer records, billing cycles and renewal dates. Identify cancellations, paused accounts, failed payments and discounts that affect actual receipts. A subscription list may include accounts that no longer pay.
Distinguish monthly billing from an annual advance payment. The annual receipt can create a strong cash month while the business still carries delivery costs for the rest of the year. Forecast those continuing costs and relevant refund exposure separately.
For automated collections, check payout timing, processing fees and failures. Review how quickly failed payments are followed up and whether recovered amounts arrive within the forecast period.
Avoid assuming all customers renew indefinitely. Use a base case supported by current evidence and a downside for realistic cancellations or weaker renewals. Explain the assumptions rather than inserting an arbitrary growth rate.
Keep accounting and VAT questions separate
Receiving cash before delivery does not automatically mean the full amount is current-period revenue. Equally, the cash date may have consequences for VAT that differ from the management reporting pattern. HMRC’s VAT guide explains tax-point rules; the actual supply and payment arrangement need review.
Give the accountant the contract, invoice, payment evidence and delivery schedule. Do not apply one deposit or subscription treatment to every arrangement merely because the payment descriptions match.
Reconcile and update the schedule
Link each receipt to the customer and agreement. Track total agreed consideration, cash collected, valid adjustments and amounts still expected, without presenting uncertain future collections as an established debt.
Review milestones and renewals each week where they affect near-term cash. Update cancellations and refunds promptly. Compare forecast collections with actual settlement reports so timing assumptions improve.
Discuss EPOS cash flow services around your contracts and collection patterns. VAT support may also be relevant where advances or recurring supplies create timing questions. Agree scope using pricing information, rather than relying on a generic payment calculator.