Pipeline overview
Revenue consolidated from seven source systems across five Lumen Aesthetics clinics. Unattended, every fifteen minutes.
1 control failingRun history
The money
Revenue, Dec 2027
$981,500
through 29 Dec · Nov 2027 closed at $1,056,041
Contribution marginNov 2027
39.3%
$415,273 on $1,056,041, after $640,769 of spend
Owed back in treatments
$2,674,656
2,024 sessions still to deliver, plus $1,681,510 against packages with no schedule yet
Waiting on a person$4,192,070
4,383
open exceptions, not records — some cover a whole clinic-month
Cleared without review
97.08%
at least this much, of 150,170 records
The clinics
No-show rate85 missed
3.7%
$48,080 of booked value did not turn up
Cancellation rate
12.9%
294 cancelled · 163 the booking system cannot classify
Average ticket
$530
booked value per completed visit · $512 last month
Completed visits
1,902
of 2,281 booked so far · 2,124 in all of Nov 2027
What happened to every booking
All bookings →Dec 2027 · month to date
Completed — 1,902Cancelled early — 85 · notice given, no fee dueCancelled late — 46 · inside the notice window, a fee is dueCancelled, unclassified — 163 · the booking system cannot say whichNo-show — 85 · nobody arrived and nobody called
By clinic · all months
| Clinic | Booking system | No-show | Cancelled | Unclassified |
|---|---|---|---|---|
| Irvine | acquired | 4.1% | 14.1% | none |
| La Jolla | acquired | 4.1% | 14.2% | none |
| Scottsdale | legacy | 3.9% | 14.2% | 2,768 |
| Tempe | legacy | 3.8% | 14.3% | 1,973 |
| Tucson | legacy | 4.2% | 13.5% | 1,481 |
Revenue recognised against cash collected
by calendar monthRevenue recognisedCash collectedCash standing above revenue is unearned package value, held as a liability. The right-hand month is still open, so both of its bars are short.
Open exceptions
Full register →| State | Kind | Exceptions | Amount |
|---|---|---|---|
| contested | visit_unexplained | 3,503 | $1,972,715 |
| contested | package_allocation_contested | 318 | $840,025 |
| contested | package_unidentified_buyer | 231 | $680,705 |
| contested | vendor_unresolved | 1 | $443,572 |
| contested | package_awaiting_redemption | 55 | $160,780 |
| contested | cancellation_log_vs_processor | 139 | $49,260 |
| contested | reversal_parent_unknown | 101 | $42,188 |
| contested | cancellation_total_mismatch | 28 | $2,125 |
| quarantined | payment_unexplained | 7 | $700 |
By clinic
Dec 2027 · month to dateRecognisedOf which contested
Recent runs
rows loaded38d agosucceeded
4,113 rows · 33/34 checks · tick 2064
38d agosucceeded
3,990 rows · 33/34 checks · tick 2063
38d agosucceeded
362 rows · 33/34 checks · tick 2062
38d agosucceeded
4,015 rows · 33/34 checks · tick 2061
38d agosucceeded
3,934 rows · 33/34 checks · tick 2060
38d agosucceeded
4,089 rows · 33/34 checks · tick 2059
38d agosucceeded
340 rows · 33/34 checks · tick 2058
38d agosucceeded
4,082 rows · 33/34 checks · tick 2057
38d agosucceeded
4,015 rows · 33/34 checks · tick 2056
38d agosucceeded
3,935 rows · 32/34 checks · tick 2055
38d agoblocked
329 rows · 30/34 checks · tick 2054
38d agoblocked
369 rows · 30/34 checks · tick 2053
Scheduled every 15 minutessystemd timer