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 settle8-wk cash
$41,200▲ $5.0Kpast 60 days — 3 accounts8-wk past-60 — climbing
91%▬ −3 ptscrew hours billed vs. logged (682 of 748)8-wk % billed
Jobs — margin against the 25% target, straight from the job sheets
Sample — illustrative numbers
Job
Billed to date
Cost to date
Margin 25% target
Note
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.
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.