SAMPLE OUTPUT

Cash Position

Sample Restoration Co. · Margin, receivables and cash on hand · Week over week movement · Pulled live

The Three Numbers

Gross margin
38.2%
+1.4 pts vs week 25
Outstanding AR
$322,140
−$18,900 collected
Cash on hand
$96,400
+$11,200
Margin moved on mix, not on pricing: three water jobs closed at above-average margin and no bio work billed this week.

The Gap

Cash improved and receivables came down, and both were driven by two payments. Strip those out and the week was flat. The concentration is the finding, not the direction: 72% of your outstanding AR sits with four accounts, so your cash position is really four phone calls, not a trend.

Where The Money Is Sitting

AccountJob typeOutstandingAge
Commercial account AWater$94,80061 days
Carrier B, two claimsFire$71,20047 days
Commercial account CMold$43,50038 days
Carrier DWater$22,40029 days
All other, 19 accountsMixed$90,240under 30
Commercial account A is the single largest lever on cash this month and is now past your 60 day terms.

What Moves It Next Week

Collecting on commercial account A alone puts cash on hand above $190,000 and takes AR under $230,000. Nothing else on this list moves the position as much, and it is the only one already past terms, which means it is the one call that is both the biggest and the easiest to justify making.