Tracking how $130.7K in revenue moves through invoicing and collection to expose exactly where value fails to complete its journey. May – December 2025.
Period May – Dec 2025
Work Orders 268
Clients 5 (MCS, Service Link, Five Brothers, MSI, Safeguard)
Total Revenue
$130.7K
268 work orders invoiced
Profit Leakage
$24.0K
18.4% of revenue lost
Outstanding Receivables
$45.4K
34.7% uncollected
Income Ratio
1.35×
Received ÷ contractor cost
Cash Inflow vs Outflow Trend
Monthly receivable, received & contractor payments — May to Dec 2025
Revenue Distribution
Where did the $130.7K go?
Leakage Root Causes
$24.0K total leakage by type
Client-Level Cash Efficiency
Payment received vs paid to contractor vs leakage — all five clients
Outstanding Receivables — Aging View
All $45,391 outstanding, bucketed by days since invoice
Client
Total Due
0–30d
31–60d
61–90d
90+ Days
Profile
Service Link
$25,800
—
—
—
$25,800
Safeguard
$6,950
—
—
$6,950
—
MCS
$6,730
—
—
$560
$6,170
Five Brothers
$3,650
—
—
$2,200
$1,450
MSI
$2,261
—
—
$2,000
$261
Aging Distribution
$45,391 total outstanding by bucket
Received Amounts by Month
Cash actually collected — strong Jul, collapse from Aug onward
Paid to Contractor by Month
Contractor disbursements remained steady while collections collapsed
Retention Gap
Of $130.7K invoiced, only $58.3K has been received (44.6%). Revenue looked healthy through July — $21K collected that month — then collections collapsed to under $1K/month from September onward. Meanwhile contractor payments held steady at $3–7K/month. The business is now funding contractor costs from prior cash reserves.
Receivables Concentration Risk
100% of outstanding receivables sit beyond 61 days. Service Link alone holds $25,800 — all 90+ days old, representing a single-client concentration risk of 56.8% of total outstanding. If this balance remains uncollected, it will directly wipe 19.7% of total revenue.
Data source: Project.xlsx Main sheet — 268 work order records, May–December 2025. No proprietary client data is disclosed. Analysis prepared by Insight Gaps Forensic Data Journalism Bureau.