FREE · NO ACCOUNT NEEDED
Construction Milestone Cash Schedule
Schedule project deposits, materials and labor payments by date. Compare all entered receipts with confirmed receipts only and inspect low cash points.
Enter your own assumptions, calculate and keep a backup. Load the fictional example to see a filled-in report.
Set up your worksheet
Your report
Enter your details, then calculate to review results.
Save or download your work
Work stays in this page until you choose Save on this device. Device saves belong to this browser and can be removed by clearing browser data. JSON keeps an editable backup; CSV and PDF keep a report.
Construction Milestone Cash Schedule: complete guide
What this worksheet does
Closing cash = opening + all entered receipts − all entered payments, including Expected records. The confirmed-only-receipts downside retains all payments. Lowest balance groups same-day movements and includes opening cash; it does not identify intraday shortages. No contract entitlement or legal payment right is inferred.
Keep up to 100 editable entries. The worksheet runs in your browser and does not send its entries to another service. The calculations use the inputs you provide; currency selectors label amounts without conversion.
How to use it
- Set a descriptive worksheet name and complete the settings for your planning period.
- Add one entry per record. Use consistent units and keep the evidence behind your assumptions.
- Calculate and inspect the report, including any review notes. Change an input and calculate again to replace the old result.
- Save an editable backup before changing a scenario. Use the related guide below for the wider operating workflow.
Inputs and units
| Field | Rule |
|---|---|
| Worksheet name | Required for calculation. Up to 160 characters. |
| Currency | Required for calculation. Choose USD, GBP, CAD, AUD, EUR, NZD. |
| Project start date | Required for calculation. Valid calendar date, 1900–2200; no timezone shift. |
| Project end date | Required for calculation. Valid calendar date, 1900–2200; no timezone shift. |
| Opening project cash | Required for calculation. 0–1000000; up to two decimal places. |
| Milestone / payment | Required for calculation. Up to 160 characters. |
| Expected cash date | Required for calculation. Valid calendar date, 1900–2200; no timezone shift. |
| Direction | Required for calculation. Choose Receipt, Payment. |
| Cash amount | Required for calculation. 0–1000000; up to two decimal places. |
| Status | Required for calculation. Choose Expected, Confirmed. |
| Dependency / next action | Optional. Up to 600 characters. |
Calculation and scope
Closing cash = opening + all entered receipts − all entered payments, including Expected records. The confirmed-only-receipts downside retains all payments. Lowest balance groups same-day movements and includes opening cash; it does not identify intraday shortages. No contract entitlement or legal payment right is inferred.
Fictional worked example
Load the fictional example to reproduce this report. The sample is an original illustration, not a customer result or a market benchmark. The dollar figures below use USD.
| Result | Sample value |
|---|---|
| Closing project cash | $2,300.00 |
| Lowest opening / day-end cash | -$700.00 |
| Confirmed-receipts closing | -$700.00 |
| Confirmed-receipts lowest cash | -$700.00 |
| Cash date | Milestone / payment | Direction | Status | Amount | Dependency / action |
|---|---|---|---|---|---|
| 2026-10-13 | Customer deposit | Receipt | Confirmed | $2,000.00 | Confirm collection before purchasing materials. |
| 2026-10-14 | Materials | Payment | Confirmed | $2,500.00 | Supplier payment date. |
| 2026-10-16 | Labour | Payment | Expected | $1,200.00 | Confirm the payroll date. |
| 2026-10-23 | Milestone collection | Receipt | Expected | $3,000.00 | Confirm approval and collection timing. |
Milestone cash schedule
| Date | All receipts | All payments | Base closing | Confirmed receipts only closing |
|---|---|---|---|---|
| 2026-10-13 | $2,000.00 | $0.00 | $3,000.00 | $3,000.00 |
| 2026-10-14 | $0.00 | $2,500.00 | $500.00 | $500.00 |
| 2026-10-16 | $0.00 | $1,200.00 | -$700.00 | -$700.00 |
| 2026-10-23 | $3,000.00 | $0.00 | $2,300.00 | -$700.00 |
Save, restore and export
Save on this device writes an explicit save to this browser; it does not download a file or sync across devices. Clearing browser storage can remove it. Download backup keeps an editable JSON file for this exact worksheet. Import previews the backup before replacing current entries; save again if you want to replace the device save. CSV contains the calculated report, not an editable import format. Print / Save PDF opens the browser print dialog; choose Save as PDF where available.
Questions and limits
Is the example my result?
No. It is fictional data. Replace its assumptions with your own records, then calculate again.
Does saving share my worksheet?
No. Device saves belong to this browser. Move an editable worksheet with its JSON backup and keep sensitive information out of a shared device.
Does a report establish that my plan is correct?
No. Arithmetic can be consistent while the input assumptions are wrong. Keep evidence, review the scope described above and check any decisions against your real records.
Continue the workflow
Cash Flow Forecast Template: Free 13-Week Excel Example. Construction Company Business Plan: Milestone Cash Example.
What changes if the milestone receipt is late?
Keep the fictional deposit and payments unchanged but move the $3,000 collection from October 23 to October 30. With no other movements, cash stays at negative $700 from October 16 through October 29, then rises to $2,300 on October 30. The lowest balance is unchanged, but the funding gap lasts seven additional days. Include October 30 in the planning window to see the receipt; do not treat the later positive balance as proof that earlier commitments are funded.
Choose your next planning step
- weekly cash commitments planner: Review dated commitments together and avoid allocating the same opening cash to several projects.
- invoice collection schedule: Record a follow-up when milestone approval or collection is uncertain.
Review cash across concurrent projects
Review Cashflow-13 OS for its documented company cash-planning workflow before combining project commitments. CashFlow 13 OS — Offline 13-Week Cash Flow Planner. Paid products are separate; the free JSON backup is not a paid-product import file.