An order can finish with cash left over and still push the business below its chosen minimum along the way. In the fictional job below, receipts exceed the specified cash costs by C$30,000. Yet the original terms require C$44,000 of incremental cash at the deepest point and leave the business C$14,000 below its cash floor.
Those are two different gaps. The first measures how much cash the order ties up before recovering it. The second depends on what else the business must fund at the same time. Calculate both before treating a deposit percentage as enough.
Give every payment a usable date
BDC’s purchase order financing overview describes a timing gap in which supplier costs may come due before the customer pays. BDC purchase order financing overview
For your order record, separate the bill date, contractual due date, expected receipt, cleared status and date the paying entity can actually use the money. Attach the evidence for any milestone, holdback or restriction. A billed amount belongs in the record, but it does not establish the usable cash date.
If accepted scope is unclear, use our guide to reconciling order backlog before dating cash movements.
Separate the order from the existing forecast
Begin with a dated no-order forecast for the same entity and currency. It starts with usable cash and includes existing non-order firm commitments. Do not subtract those commitments again when adding the prospective order.
Identify which receipts and cash outlays are caused by this decision. If the working forecast already includes them, separate them when building the no-order version, then add them once in the order column. Identify sunk or unavoidable amounts that remain in both versions. Keep the forecast version and event clock consistent across the comparison.
Run the baseline through the owner’s cash floor on its own. A shortfall already present without this order must remain visible. It cannot automatically be blamed on the new job.
Open the fictional December order
Northbank Fabrication is considering one custom order. Every amount, date, record and person in this example is invented. All amounts are Canadian dollars. The schedule runs from December 1 through December 29, 2026. No financing is assumed. Tax and other costs outside the specified order cash scope are excluded.
Original receipts are a C$25,000 deposit usable December 1, a C$35,000 milestone usable December 12 and C$65,000 final payment usable December 29. Incremental outlays are C$45,000 for materials on December 3, then C$24,000, C$18,000 and C$8,000 on December 7, 14 and 17. The deposit is stipulated to be usable in the entity making the payments.
Receipts total C$125,000 and the specified cash outlays total C$95,000. Their C$30,000 difference is cumulative net order cash at the end of this example. It is neither accounting profit nor an estimated margin, and it does not tell us the peak funding requirement.
The owner chooses a fictional C$35,000 minimum cash floor. The no-order forecast never breaches it: its lowest stipulated balance is C$65,000 on December 7, and it ends at C$78,000. The nine dates below are the complete event grid for this illustration. They do not establish balances between snapshots in a real business.
Follow the original terms through all nine dates
Start the order’s cumulative cash at zero. Add each usable receipt and subtract each incremental payment. At every event, add that running order balance to the same-time no-order cash. Compare the combined result with C$35,000.
December 1 — deposit received. No-order cash C$80,000. Order movement +C$25,000 brings cumulative order cash to C$25,000. Combined cash: C$105,000. Below the floor: C$0.
December 3 — materials paid. No-order cash C$70,000. Order movement −C$45,000 brings cumulative order cash to −C$20,000. Combined cash: C$50,000. Below the floor: C$0.
December 7 — incremental outlay. No-order cash C$65,000. Order movement −C$24,000 brings cumulative order cash to −C$44,000. Combined cash: C$21,000. Below the floor: C$14,000.
December 10 — no order movement. No-order cash C$70,000. Order movement C$0 brings cumulative order cash to −C$44,000. Combined cash: C$26,000. Below the floor: C$9,000.
December 12 — milestone received. No-order cash C$82,000. Order movement +C$35,000 brings cumulative order cash to −C$9,000. Combined cash: C$73,000. Below the floor: C$0.
December 14 — incremental outlay. No-order cash C$75,000. Order movement −C$18,000 brings cumulative order cash to −C$27,000. Combined cash: C$48,000. Below the floor: C$0.
December 17 — incremental outlay. No-order cash C$70,000. Order movement −C$8,000 brings cumulative order cash to −C$35,000. Combined cash: C$35,000. Below the floor: C$0.
December 19 — no order movement. No-order cash C$78,000. Order movement C$0 brings cumulative order cash to −C$35,000. Combined cash: C$43,000. Below the floor: C$0.
December 29 — final payment received. No-order cash C$78,000. Order movement +C$65,000 brings cumulative order cash to C$30,000. Combined cash: C$108,000. Below the floor: C$0.
On December 7, C$25,000 − C$45,000 − C$24,000 = −C$44,000 for the order. Adding the no-order C$65,000 leaves C$21,000. The floor gap is C$35,000 − C$21,000 = C$14,000. Cash remains positive, but below the owner’s chosen minimum.
The order stays at its C$44,000 maximum requirement on December 10. Because baseline cash has risen to C$70,000, the combined balance is now C$26,000 and the floor gap is C$9,000. Same order requirement, different whole-business shortfall.
Use two calculations: peak order requirement = max(0, negative of the lowest cumulative order balance). At each event, floor shortfall = max(0, floor minus combined cash). Report the largest shortfall and its date. Neither calculation establishes an overdraft, a drawable credit amount or a lender’s decision.
Test three changes without changing the order total
Earlier deposit: the floor holds, with C$4,000 at the low point
For the first alternative, suppose the customer agrees to move C$18,000 from the final instalment into the cleared December 1 deposit. The deposit becomes C$43,000 and the final payment becomes C$47,000. Keep the December 12 milestone and all outlays unchanged.
On December 7, cumulative order cash is C$43,000 − C$45,000 − C$24,000 = −C$26,000. Combined cash is C$65,000 − C$26,000 = C$39,000, just C$4,000 above the floor. The peak incremental requirement is C$26,000 on December 7 and 10. None of the stipulated events breaches the floor.
The change moves cash earlier. It adds no receipt to the C$125,000 total. This is a proposed alternative to confirm with the customer, not evidence of agreement or permission to start.
Supplier deferral: the gap moves to December 10
Start again from the original terms, not from the larger deposit. Suppose the supplier agrees to shift C$15,000 of the material payment from December 3 to December 10. December 3’s payment becomes C$30,000. Every other original receipt and outlay stays unchanged.
The December 7 order balance is −C$29,000, giving combined cash of C$36,000. When the deferred C$15,000 is paid on December 10, the order balance reaches −C$44,000 and combined cash falls to C$26,000. This is the first floor breach in this alternative. The largest shortfall is C$9,000, and the order’s peak requirement is still C$44,000. The deferral reduces the maximum floor gap but does not eliminate it.
Late milestone: the larger deposit no longer protects the floor
For the final alternative, use the C$43,000 deposit and C$47,000 final payment, but move the usable C$35,000 milestone from December 12 to December 19. Keep all cost dates unchanged.
December 12 brings no order receipt. After the December 14 outlay, cumulative order cash is −C$44,000 and combined cash is C$31,000: a C$4,000 floor gap. On December 17, cumulative order cash reaches −C$52,000. Combined cash is C$70,000 − C$52,000 = C$18,000, or C$17,000 below the floor.
The milestone lifts combined cash to C$61,000 on December 19. All four scenarios still finish with C$30,000 net order cash and C$108,000 combined cash on December 29. That common ending conceals four different timing results. One delayed-receipt test is not a complete assessment of every possible disruption.
Check the clock before relying on a dated row
When applying this worksheet, include every material baseline event and payment boundary, not just the order’s dates. If a supplier payment can leave before a receipt on the same day becomes usable, split that day into ordered subrows and test the lowest balance between them. A receipt later that afternoon cannot be treated as available for the morning payment.
If financing is being considered, keep it in a separate evidence record: commitment, amount actually drawable, availability date, restrictions, fees and relevant repayments. An unverified limit or proposed facility is not cash to add to a row. This example establishes neither financing eligibility nor a suitable funding product.
Turn the result into a start-or-hold record
In Northbank’s invented November 27 review, owner Amira keeps ORDER-01 beside FORECAST-01 and Cash Schedule v1. Finance lead Jo owns the no-order baseline and confirms which commitments it already includes. Operations lead Eli checks each incremental payment against the order’s cost scope and flags any amount already included elsewhere.
The original schedule is below the chosen floor on December 7 and 10. Amira records “terms or timing unresolved”. Jo requests evidence for the proposed deposit’s amount, availability date and restrictions. The customer contact must confirm the revised payment arrangement. The supplier deferral is recorded as a separate proposal requiring its own confirmation, not combined with the customer change by accident.
The next checkpoint is November 30, before the stipulated December 1 receipt. Jo will retain the old version, attach any confirmed changes and rerun every event. If a receipt date, payment restriction or material baseline event remains uncertain, Amira keeps the start decision pending rather than relying on the best-looking alternative.
Copyable blank worksheet
Order boundary: Entity ______. Order/version ______. Currency ______. Decision date ______. Receipt and cost scope ______. Exclusions ______. Record owner ______.
Receipt — repeat each: Amount ______. Bill date ______. Due date ______. Expected date ______. Cleared status ______. Usable date/time ______. Paying entity can use it? ______. Milestone/holdback/restriction ______. Evidence/version ______. Latest acceptable time and basis ______.
Outlay — repeat each: Amount ______. Payment date/time ______. Incremental to this decision? ______. Sunk or unavoidable amount ______. Already in baseline? ______. Counterfactual treatment ______. Evidence/version ______.
Event row — repeat each: Date/time/order within day ______. No-order baseline/version ______. Order movement ______. Cumulative order cash ______. Combined cash ______. Owner floor ______. Baseline-only gap ______. Combined headroom or gap ______.
Result and action: Peak order requirement/date ______. Largest floor shortfall/date ______. Confirmed or proposed change ______. Delay sensitivity ______. Separate financing evidence ______. Missing timing proof ______. Decision/status ______. Responsible person ______. Next checkpoint ______.
Keep the order’s eventual cash result beside its deepest requirement and the business’s lowest headroom. The next useful answer is the dated evidence that changes a payment or receipt row—not a larger deposit number without a confirmed usable date.
For general information and education, not legal, tax, investment or valuation advice. Examples are illustrative and do not predict your business’s value, financing terms or sale outcome. Consult qualified advisers about your situation.
Subscribe to Deal Flow Canada for practical owner guides and Canadian deal updates.


