← Reports Hub 📚 Library

Revenue by Month + Service Type REPORT 4

Monthly revenue rollup by service category. Read-only. Revenue filtered on job_status='completed' (phantom revenue rule).
💎
Implications (per memory rule 1)
🎯 Bucket touchedHCP era (2021-09 to 2025-07) + ST era (2025-07+)
⚠️ ProblemNaive sum of HCP $5.76M + ST $4.72M = $10.48M is wrong by ~$5.4M because 4,024 migrated customers carry revenue in both systems.
💰 $ at stake$5.4M overcounting risk if presented to Stephanie as combined LTV.
✅ Action unlockedUse per-era split: HCP jobs before 2025-07-15 + ST jobs after. See BSP_HCP_Intelligence_Report ⚠️ Double-count trap callout.
📊 Full bucket diagram + 4 data-integrity findings: BSP HCP Intelligence Report (📊 The Buckets · 📅 Timeline · 💸 LTV · 🔍 Why this matters · 🎯 The 4 Findings)
Grand Total Revenue
...
Completed Jobs
...
Months Covered
...
Uncategorized Revenue
...

Date Range Filter

Loading data quality...

Stacked Bar: Revenue per Month by Category

Category Totals (whole range)

Category Revenue Jobs Avg Ticket
Loading...

Month x Category Matrix