Monthly management report
Cedar Plaza Builders
Retainage outstanding climbed to $214K — the Maple Street mixed-use job hit substantial completion but the 10% retainage won't release until the punch list closes in Q3. That cash is earned but uncollectable for ~60 more days; the 13-week forecast now models the release in week 11, not week 4.
01 · Executive summary
Three conclusions, and the decisions they imply
- Retainage outstanding climbed to $214K — the Maple Street mixed-use job hit substantial completion but the 10% retainage won't release until the punch list closes in Q3. That cash is earned but uncollectable for ~60 more days; the 13-week forecast now models the release in week 11, not week 4.
- Costs ran ahead of billings on the Cedar Plaza job — $186K of work-in-progress is unbilled because the April draw missed the owner's pay-app cutoff. The worker called it a one-cycle timing slip; the supervisor flagged a pattern of late pay-apps on this GC, so it routed to your inbox.
- Blended gross margin held at 18.0% vs the 16.8% bid plan — the Riverside change orders were approved at full markup and the self-perform concrete crew beat the subcontracted estimate on two pours.
Scorecard
Scorecard
Cash status
Cash-positive
Revenue
$2,180,000
+$120,000 · +5.8% vs plan
Monthly outflow
$2,036,000
+$96,000 · +4.9% vs plan
Gross margin
18.0%
DSO / DPO (days)
58 / 44
P&L summary — vs prior month, last year and plan
P&L summary — vs prior month, last year and plan
Month over month — vs prior period — Apr 26 vs Mar 26
| Line | Apr 26 | Mar 26 | Δ | Δ% |
|---|---|---|---|---|
| Revenue | $2,180,000 | $2,057,959 | +$122,041 | +5.9% |
| Cost of revenue | $1,787,600 | $1,687,526 | +$100,074 | +5.9% |
| Gross profit | $392,400 | $370,433 | +$21,967 | +5.9% |
| Operating expense | $248,400 | $246,142 | +$2,258 | +0.9% |
| Operating profit/(loss) | $144,000 | $124,291 | +$19,709 | +15.9% |
| Ending cash | $918,000 | $774,000 | +$144,000 | +18.6% |
Year over year — same month last year — Apr 26 vs Apr 25
| Line | Apr 26 | Apr 25 | Δ | Δ% |
|---|---|---|---|---|
| Revenue | $2,180,000 | $1,573,831 | +$606,169 | +38.5% |
| Cost of revenue | $1,787,600 | $1,290,542 | +$497,058 | +38.5% |
| Gross profit | $392,400 | $283,290 | +$109,110 | +38.5% |
| Operating expense | $248,400 | $222,617 | +$25,784 | +11.6% |
| Operating profit/(loss) | $144,000 | $60,673 | +$83,327 | +137.3% |
| Ending cash | $918,000 | $453,717 | +$464,283 | +102.3% |
Next month forecast $2,240,000
Trends
Monthly revenue — last 14 closed months
Mar 25 — Apr 26 · $1,262,866 … $2,180,000
Ending cash at each month close
Mar 25 — Apr 26 · $370,188 … $918,000
03 · Cash & working capital
Cash & working capital
Opening cash $774,000 net for the month +$144,000 closing cash $918,000
$918,000 today → $924,332 in week 13 · lowest point $477,538 (week 6) · no cash-floor breach
View weekly schedule
| Week | Opening | Receipts | Disbursements | Ending |
|---|---|---|---|---|
| 1 | $918,000 | $503,464 | $576,875 | $844,590 |
| 2 | $844,590 | $503,464 | $576,875 | $771,179 |
| 3 | $771,179 | $503,464 | $576,875 | $697,769 |
| 4 | $697,769 | $503,464 | $576,875 | $624,359 |
| 5 | $624,359 | $503,464 | $576,875 | $550,948 |
| 6 | $550,948 | $503,464 | $576,875 | $477,538 |
| 7 | $477,538 | $503,464 | $470,208 | $510,794 |
| 8 | $510,794 | $503,464 | $470,208 | $544,051 |
| 9 | $544,051 | $503,464 | $470,208 | $577,307 |
| 10 | $577,307 | $503,464 | $470,208 | $610,563 |
| 11 | $610,563 | $717,464 | $470,208 | $857,820 |
| 12 | $857,820 | $503,464 | $470,208 | $891,076 |
| 13 | $891,076 | $503,464 | $470,208 | $924,332 |
What changed and why
What changed and why
Retainage outstanding climbed to $214K — the Maple Street mixed-use job hit substantial completion but the 10% retainage won't release until the punch list closes in Q3. That cash is earned but uncollectable for ~60 more days; the 13-week forecast now models the release in week 11, not week 4.
✓ second model confirmed · General ledger · Retainage Maple Street · Apr 2026 · QuickBooks · AIA G702 Maple · April
Costs ran ahead of billings on the Cedar Plaza job — $186K of work-in-progress is unbilled because the April draw missed the owner's pay-app cutoff. The worker called it a one-cycle timing slip; the supervisor flagged a pattern of late pay-apps on this GC, so it routed to your inbox.
second model disagrees — review · General ledger · WIP Cedar Plaza · Apr 2026 · QuickBooks · Payapp Cedar · April
Blended gross margin held at 18.0% vs the 16.8% bid plan — the Riverside change orders were approved at full markup and the self-perform concrete crew beat the subcontracted estimate on two pours.
✓ second model confirmed · General ledger · Change Orders Riverside · Apr 2026 · QuickBooks · CO Log Riverside · April
04 · Decisions & follow-ups
Decisions & follow-ups
Retainage outstanding climbed to $214K — the Maple Street mixed-use job hit substantial completion but the 10% retainage won't release until the punch list closes in Q3
Open · outcome pending · You · Review by 05 Jun 2026
Unbilled work in progress on the Riverside job crossed 24 days — move the June progress-billing cut-off to the 25th so the draw lands in the owner's July pay-app cycle?
Open · outcome pending · Controller · Review by 20 May 2026
push the Maple Street punch list to close by Q2 to release the 10% retainage two cycles earlier.
Reviewed · Sofia Reyes (PM) · Review by 20 Jun 2026
Forecast reliability
Forecast reliability Inferred
Your revenue forecasts have run 6% pessimistic over the last 6 months.
How we measure it: every past monthly forecast is scored against the month that actually closed — out-of-sample, never fit to the answer.
Sources & evidence
- General ledger · Retainage Maple Street · Apr 2026
- QuickBooks · AIA G702 Maple · April
- General ledger · WIP Cedar Plaza · Apr 2026
- QuickBooks · Payapp Cedar · April
- General ledger · Change Orders Riverside · Apr 2026
- QuickBooks · CO Log Riverside · April