DataBrosFTW.
Sample — illustrative numbers

The Monday Packet

Week of Aug 10–16 · prepared for the owner of a ~$12M commercial services company (fictional). Lands in your inbox every Monday at 7am, built from your QuickBooks, timecards, and job sheets. Nobody assembles it.

Three things that need you this week

Hold the supply-house payment on Job 2417 — one invoice looks duplicated.Serious · ~$8,300

The materials rerun posted twice. Margin is under 20% for the second straight week; a call before Friday's check run recovers most of the slip.

Approve the Kestrel reminder letter — $22,400 just crossed 60 days.Watch · $22,400

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

Sign the 2428 change order — 66 crew hours are sitting unbilled behind it.Watch · ~$9,900

All of last week's unbilled hours trace to this one signature. County has had it since Wednesday.

The week in four numbers — with the eight weeks behind them
$228,400▲ 22% billed this week (inv. 4181–4197) 8-wk billing
$1.42M▲ 3% cash after payroll & fuel-card settle 8-wk cash
$41,200▲ $5.0K past 60 days — 3 accounts 8-wk past-60 — climbing
91%▬ −3 pts crew hours billed vs. logged (682 of 748) 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$412,800$291,400
29.4%
on plan
2417 · Mesa View Phase 2$186,200$152,900
17.9%
see item 1 above
2423 · Fairgrounds Reroof$97,600$68,100
30.2%
closes this month
2428 · County Annex$54,000$39,700
26.5%
see item 3 above
Money owed — $431,400 total, by age
$301,700CURRENT–30
$88,50031–60
$41,20060+
  • $196,000 collected this week; $228,400 newly billed.
  • Kestrel $22.4K crossed 60 — reminder queued (item 2).
  • 31–60 is two county invoices, both normal pace.
Crew hours — 748 logged
682 billed · dark66 unbilled · amber

Every unbilled hour is on Job 2428, waiting on the change-order signature (item 3). At the blended rate that's ~$9,900 of work done and not yet invoiced.