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