On this page
Receipts and payments are not always independent. Fewer new orders may reduce later material purchases, while delayed payment for completed work may leave every related supplier bill unchanged. A useful cash scenario explains the event connecting its changes. Applying the same percentage reduction to receipts and all payments can create an unrealistically comfortable forecast when much of the spending is already committed.
Start with a traceable operating case
Assume a hypothetical period begins with $10,000 of cash. Expected customer receipts are $40,000. Payments include $16,000 of variable purchases tied to those orders and $18,000 of other committed costs, totaling $34,000. Base closing cash is $16,000. This simplified example assumes the base order receipts and related purchases occur within the same period.
Change in closing cash = change in receipts − change in related payments − change in other payments
| Scenario | Receipts | Variable purchase payments | Other committed payments | Closing cash |
|---|---|---|---|---|
| Base | $40,000 | $16,000 | $18,000 | $16,000 |
| Orders fall 25% before purchases commit | $30,000 | $12,000 | $18,000 | $10,000 |
| Same receipts fall after purchases commit | $30,000 | $16,000 | $18,000 | $6,000 |
| $10,000 receipt delayed, no order loss | $30,000 | $16,000 | $18,000 | $6,000 |
The first downside case loses $10,000 of receipts but avoids $4,000 of variable payments, reducing closing cash by $6,000. Both 25% changes use their own original bases: $40,000 of receipts and $16,000 of variable purchases. The $18,000 commitment does not fall because the scenario provides no way to avoid it.
Distinguish the cause behind identical totals
The second and third cases both close at $6,000, but their future implications differ. Lost orders after purchases commit may leave unsold inventory or unused work. A delayed receipt for completed work may still arrive later without changing revenue or delivery cost. Identical current-period cash numbers do not make those scenarios economically interchangeable.
If a supplier payment can move only after an agreed date change, enter that specific change as another scenario. Do not assume a customer delay grants the business an equivalent supplier extension. Similarly, a large new order may bring a deposit while also requiring an earlier purchase payment; the receipt and payment dates must be modeled together rather than netted at the order date.
Use dependency evidence before statistical labels
Map which order, invoice, approval, or demand event drives each row. Historical receipts and payments can move together simply because both trend upward with business size. That pattern does not prove a stable correlation that will protect cash in a downturn. This worksheet models explicit causal assumptions and does not estimate a statistical correlation coefficient.
Avoid adding two stress adjustments that describe the same missing customer payment. If one scenario delays $10,000 and another independently reduces the same invoice by $10,000, combining them without reconciliation double-counts the cash loss. Keep shared triggers, separate triggers, and timing assumptions visible. The exercise identifies a coherent operating scenario; it does not assign probabilities, guarantee a reserve is adequate, or recommend financing for any resulting gap.
Method references: OpenStax: Prepare Financial Budgets. Accessed October 22, 2026. All dollar figures are hypothetical worked examples.
Related calculators & guides
- Project Backlog vs Available Delivery Capacity
- Retainer Rollover: Track Future Hour Obligations
- Milestone Acceptance Delays and Cash Timing
- Price Billable Travel Time and Trip Expenses
- Build a Client Meeting Cost Budget
- Project Handoffs: Review and Rework Costs
- Scope Reduction vs a Price Discount
- Fixed-Fee Cancellation Cost Scenarios
- Time and Materials with a Not-to-Exceed Cap
- Build a Blended Team Billing Rate
- Subcontractor Markup vs a Management Fee
- Billable Write-Offs: Trace Lost Fee Value
- Service Software Seat Costs and Client Work
- Outsourcing Admin: Required Sold Hours
- Client Concentration and Receipt Timing
- Project Work in Progress and Cash Committed
- Annual Contract Renewals and Cash Commitments
- Delayed Project Starts and the Cash Schedule
- Analyze Cash Forecast Errors by Cause
- Project Backlog Capacity Calculator
- Blended Team Billing Rate Calculator
- Client Receipt Concentration Calculator
- Cash Forecast Error Calculator
- Backlog and Deadline Capacity Reference
- Cash Forecast Error Reconciliation Table
- Worked Example: Backlog Capacity and Collection Delay
- Service Delivery and Cash Operations Workbook
- Cash Flow and Scenario Planning
Report an error
Thank you! Your feedback helps us make this page better.
Could not send. Please try again.