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 6:30am, 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
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.