DataBrosFTW.
Sample — illustrative numbers

The Monday Packet

Week of Aug 10–16 · prepared for the owner of a ~$14M commercial roofing contractor (fictional). This lands in your inbox every Monday at 7am, built from your QuickBooks, crew timecards, and job sheets. Nobody assembles it.

Three things that need you this week

Hold the supply-house payment on Job 2417 — the shingle-rerun invoice posted twice.Serious · ~$6,900

Margin slipped under 20% for the second straight week; the rerun ate 4 points (~$6,900 on billed-to-date). Worth a call before paying.

Approve the Kestrel reminder letter — $24,900 crossed 60 days this week.Watch · $24,900

Kestrel Properties paid at 71 days last cycle. The letter is queued in the packet; the call goes out Tuesday on your OK.

Sign off the 2428 change order — 58 crew hours are sitting unbilled behind it.Watch · ~$8,700

All 58 hours are on the County Annex built-up job; at the blended rate that's ~$8,700 of finished work not yet invoiced.

The week in four numbers — with the eight weeks behind them
$196,300▲ 9% billed this week (invoices 3308–3321) 8-wk billing
$1.12M▲ 2% cash after payroll & the supplier draft 8-wk cash
$52,800▲ $24.9K receivables now past 60 days — 3 accounts 8-wk past-60 — jumped
88%▬ −2 pts crew hours billed vs. logged (612 of 696) 8-wk % billed
Jobs — margin against the 25% target, straight from the job sheets
Sample — illustrative numbers
JobBilled to dateCost to dateMargin 25% targetNote
2411 · Airport Hangar B — TPO reroof$388,400$274,100
29.4%
on plan
2417 · Mesa View HOA — shingle, ph. 2$172,600$141,800
17.8%
shingle rerun ate 4 pts — see item 1 above
2423 · Fairgrounds — metal retrofit$91,200$63,500
30.4%
closes this month; warranty registration drafted
2428 · County Annex — built-up$47,900$34,200
28.6%
see item 3 above
Money owed — $400,300 total, by age
$271,300CURRENT–30
$76,20031–60
$52,80060+
  • $182,400 collected this week; $196,300 newly billed.
  • Kestrel $24.9K crossed 60 — call goes out Tuesday (item 2).
  • 31–60 is two invoices, both GC pay-when-paid — normal pace.
Crew hours — 696 logged
612 billed · dark84 unbilled · amber

58 of the unbilled hours are on Job 2428, waiting on the change-order signature (item 3). At the blended rate that's ~$8,700 of work done and not yet invoiced.