Total people cost ran $540.3K across H1, averaging $90.1K/month, with a low of $74.4K in April and a high of $120.4K in January.
January is the outlier month — annual/one-time items load into the January Gusto run the way they do on the P&L side, pushing payroll net to $66.1K and contractor spend to $24.9K in the same month.
Contractor (Gusto CND) spend has fallen sharply — from a $31.3K peak in February to $7.5K in June, a ~76% drop from peak. Payroll tax and benefits/REM stayed comparatively flat month to month.
June's payroll net ($53.0K) is the highest since January, consistent with the "three payroll-adjacent Gusto runs" noted on the Financial Dashboard for that month — even though June's contractor line was the lowest of H1.
Three new sections below join this cost data with the Athena billing feed: Headcount (active billing providers by month), Per-Provider Detail (visits & collections by provider), and Cost per Visit (revenue, all-in cost — every operating expense plus card spend — and people cost, all per visit). See the Notes tab for what these can and can't tell you.
| Category | Jan | Feb | Mar | Apr | May | Jun | H1 |
|---|---|---|---|---|---|---|---|
| Payroll (net) | 66,086.89 | 45,128.81 | 43,561.85 | 44,170.83 | 45,399.37 | 53,009.87 | 297,357.62 |
| Employer payroll tax | 26,842.35 | 18,293.10 | 17,383.18 | 18,635.41 | 16,632.14 | 18,906.87 | 116,693.05 |
| Contractors (Gusto CND) | 24,905.20 | 31,280.94 | 19,195.52 | 9,781.56 | 16,133.39 | 7,488.93 | 108,785.54 |
| Reimbursements (REM) | 1,585.11 | 5,845.42 | 610.78 | 871.54 | 1,234.95 | 972.00 | 11,119.80 |
| Benefits | 952.06 | 818.60 | 1,533.81 | 967.32 | 1,012.49 | 1,092.66 | 6,376.94 |
| Total people cost | 120,371.61 | 101,366.87 | 82,285.14 | 74,426.66 | 80,412.34 | 81,470.33 | 540,332.95 |
| Pay period | Pay day | Gross earnings | Employee taxes | Employer taxes | Net pay |
|---|---|---|---|---|---|
| 05/18/2026 – 05/31/2026 | 06/05/2026 | 8,922.21 | 1,581.02 | 886.14 | 7,185.83 |
| 06/01/2026 – 06/14/2026 | 06/18/2026 | 8,893.38 | 1,549.11 | 822.60 | 7,208.50 |
| 06/15/2026 – 06/28/2026 | 07/03/2026 | 9,298.45 | 1,670.22 | 851.19 | 7,470.43 |
| 06/29/2026 – 07/12/2026 | 07/17/2026 | 9,037.41 | 1,653.36 | 811.26 | 7,222.66 |
| 4-period total | 36,151.45 | 6,453.71 | 3,371.19 | 29,087.42 |
| Period | Regular hrs | OT hrs | Total hrs |
|---|---|---|---|
| 6/1/26 – 7/29/26 | 3,937.90 | 52.63 | 3,990.53 |
Payroll (net) is the largest single line at 55% of H1 people cost, followed by employer payroll tax (22%) and contractors (20%). Reimbursements and benefits together are under 4%.
People cost as a share of total operating expense runs highest in January (73%) when annual items load into the Gusto run, and settles into the high-50s to mid-60s for most other months.
As a share of revenue, people cost is heaviest in January (>100% of that month's revenue, matching the seasonal January net loss on the Financial Dashboard) and lightest in April (38%), as revenue ramped faster than payroll that month.
| Provider | Jan | Feb | Mar | Apr | May | Jun |
|---|---|---|---|---|---|---|
| Mayrsohn, Brian | ||||||
| AlFarra, T. | ||||||
| Rosario, Lisa | ||||||
| Timoney, Rebecca | ||||||
| Beall (unconfirmed) | ||||||
| Ullger, Cory (unconfirmed) |
"Beall" billed Jan–Mar only (3, 5, then 1 visit, tapering to $0 paid in March) then disappears from the feed entirely. Worth confirming whether this is a covering/locum provider who stopped, or a data-entry variant of another name.
"Ullger, Cory" bills exactly 1 visit at a flat $29 every month (2 in June) — that pattern looks more like a supervising or incident-to billing code artifact than an actual separate clinician. Flag for the payroll-register review rather than counting as a 7th provider.
The 4-provider core panel (Mayrsohn, AlFarra, Rosario, Timoney) is stable across all six months — no adds or drops among the named clinicians the Analytics Dashboard already tracks.
| Provider | Jan | Feb | Mar | Apr | May | Jun | H1 |
|---|---|---|---|---|---|---|---|
| Mayrsohn, Brian | 492 | 548 | 618 | 606 | 655 | 542 | 3,461 |
| AlFarra, T. | 79 | 52 | 52 | 28 | 24 | 19 | 254 |
| Rosario, Lisa | 58 | 63 | 62 | 70 | 66 | 47 | 366 |
| Timoney, Rebecca | 15 | 17 | 35 | 40 | 25 | 30 | 162 |
| Beall | 3 | 5 | 1 | 0 | 0 | 0 | 9 |
| Ullger, Cory | 1 | 1 | 1 | 1 | 1 | 2 | 7 |
| Unattributed | 25 | 18 | 17 | 18 | 25 | 121 | 224 |
Mayrsohn carries ~77% of H1 visits (3,461 of 4,483) and the large majority of collections, consistent with a physician-led solo-heavy panel supported by three PAs.
AlFarra's volume and collections both fell steadily through H1 — 79 visits/$11.7K in January down to 19 visits/$115 in June. That's the sharpest drop of any provider on the panel and is worth a direct check on hours, status, or a data-attribution issue before reading it as a real production decline.
Timoney's volume grew through Q1 into Q2 (15 → 40 visits Jan→Apr) before pulling back in May–June — worth cross-checking against the ramp assumptions in the forecast model's new-PA scenarios.
The June spike in "Unattributed" visits (121, vs. 17–25 in every other month) is worth a data-quality check — that's a lot of claims without a clean provider match in one month.
| Month | Visits | Revenue | All-in cost | Bank opex | People cost | Rev/visit | All-in cost/visit | Bank opex/visit | People cost/visit | All-in net/visit |
|---|---|---|---|---|---|---|---|---|---|---|
| Jan | 673 | 118,162.56 | 180,840 | 163,802.52 | 120,371.61 | 175.58 | 268.71 | 243.39 | 178.86 | (93.13) |
| Feb | 704 | 133,435.49 | 139,347 | 126,005.37 | 101,366.87 | 189.54 | 197.94 | 178.98 | 143.99 | (8.40) |
| Mar | 786 | 182,658.46 | 139,545 | 124,568.20 | 82,285.14 | 232.39 | 177.54 | 158.48 | 104.69 | 54.85 |
| Apr | 763 | 193,527.93 | 138,460 | 119,640.28 | 74,426.66 | 253.64 | 181.47 | 156.80 | 97.54 | 72.17 |
| May | 796 | 170,013.85 | 142,028 | 116,499.50 | 80,412.34 | 213.59 | 178.43 | 146.36 | 101.02 | 35.16 |
| Jun | 761 | 157,970.22 | 173,133 | 145,608.70 | 81,470.33 | 207.58 | 227.51 | 191.34 | 107.06 | (19.92) |
| H1 | 4,483 | 955,768.51 | 913,353 | 796,124.57 | 540,332.95 | 213.20 | 203.74 | 177.59 | 120.53 | 9.46 |
The all-in net per visit is barely positive across H1 — $9.46 — and that blended figure hides real swings: January (–$93.13) and June (–$19.92) lost money on the average visit once card spend is counted, while March and April cleared $55–72 per visit. This is the per-visit version of the Financial Dashboard's "two nets" finding (bank-basis $159.6K net vs. all-in $42.4K net).
People cost is only 59% of the all-in cost per visit ($120.53 of $203.74 H1-blended) — the rest is rent, supplies, insurance, EHR/RCM, marketing, and card spend. A dashboard that only tracked payroll would have overstated how much cheaper April/May visits were, since non-labor costs move on a different rhythm than Gusto runs.
Visit volume was fairly steady (673–796/month) while total cost swung much more — so month-to-month cost-per-visit changes are driven by expense timing (January loading, June's buildout invoices and heavier card cycle), not by patient volume changes.
This is a company-wide blended figure, not a per-provider cost per visit — a true per-provider version would need per-employee compensation (still not available; see Notes) allocated against the Per-Provider Detail tab's visit counts.
APPOINTMENTS_LAST_60_DAYS.xlsx — a raw Athena appointment-status export, June 1–July 29, 2026 (2,915 scheduled appointment records). This is more current and more granular than the Jan–Jun billing feed used elsewhere on this dashboard, but covers a shorter, partly overlapping window — treat the two as complementary, not directly stackable.| Appointment type | Kept | Lost | Total | Cancel rate |
|---|---|---|---|---|
| No Fault 15 | 170 | 172 | 342 | 50.3% |
| NEW PATIENT 30 | 131 | 101 | 232 | 43.5% |
| FOLLOW UP 15 | 329 | 252 | 581 | 43.4% |
| Psychotherapy 60 min follow-up | 121 | 90 | 211 | 42.7% |
| New Patient No Fault | 50 | 36 | 86 | 41.9% |
| Virtual Visit New Patient | 28 | 20 | 48 | 41.7% |
| New Patient Workers Comp 30 | 35 | 24 | 59 | 40.7% |
| Workers Comp 15 | 205 | 137 | 342 | 40.1% |
| Psychotherapy Initial Visit | 62 | 35 | 97 | 36.1% |
| ESI | 100 | 43 | 143 | 30.1% |
| VIRTUAL VISIT 15 | 266 | 96 | 362 | 26.5% |
No Fault 15 is the single worst-performing appointment type — 172 of 342 scheduled visits (50.3%) never happen as booked, and it's also one of the highest-volume types. That's roughly one lost No Fault slot every day across the 60-day window.
Virtual visits hold up best — VIRTUAL VISIT 15 loses only 26.5% of bookings, well below the 38.3% overall average, and below every in-person type with meaningful volume.
Most "lost" time is rescheduling, not true attrition — 578 of 1,116 lost appointments (51.8%) are patient reschedules, meaning the patient is still coming, just not on that date. True no-shows (143, 12.8% of losses) and outright patient cancellations (236, 21.1%) are the harder losses.
The cancellation rate improved slightly from June to July (39.6% → 36.9%), though July is a partial month (through the 29th) so the comparison isn't quite apples-to-apples.
This connects to the Cost per Visit tab: every cancelled or no-show slot is a scheduled provider hour that still carries labor cost but produces no visit and no revenue. No Fault and Follow Up 15 slots — the two highest-volume, highest-cancel-rate types — are the biggest concentration of that risk.
| Category | What it is |
|---|---|
| Payroll (net) | Net Gusto payroll run amount — employee take-home pay, direct deposits. |
| Employer payroll tax | Employer-side FICA/FUTA/SUTA and related payroll tax withholding remitted through Gusto. |
| Contractors (Gusto CND) | 1099 contractor payments run through Gusto's contractor module. |
| Reimbursements (REM) | Employee expense reimbursements processed through Gusto. |
| Benefits | Employer-paid benefits contributions processed through Gusto. |
| Headcount (this dashboard) | Count of distinct providers billing at least one claim in Athena that month — a clinical-panel proxy, not total employee headcount. |
| People cost / visit | Total monthly people cost (Gusto categories, bank-basis) ÷ total unique visit-days that month (Athena billing) — labor only. |
| Bank-basis opex / visit | Total monthly Included operating expense (all categories, per the Financial Dashboard's Monthly P&L tab) ÷ visits — excludes card spend. |
| All-in cost / visit | Bank-basis opex + card spend (business + mixed) + US Bank/Amex proxy ÷ visits — the most complete cost figure the current data supports; matches the Financial Dashboard's Consolidated tab scope. |
| All-in net / visit | Revenue / visit minus all-in cost / visit — can go negative in months where fully-loaded cost exceeds revenue per visit. |
| Expected revenue / visit (history case) | Lag-adjusted: each billing line under 12 months old valued at the mature average actually paid for that CPT × payer class (denials included, backtested against 2025 cohorts, calibrated). Immune to the 2026 chargemaster repricing. Conservative floor — use externally. |
| Expected revenue / visit (accrual case) | History case, plus: unpaid No-Fault/WC lines valued from date of service at the empirical NF fee schedule (average paid-when-paid for that CPT) ×1.40 statutory interest (2%/mo, ~20-month award timeline) × arbitration win rate (80% shown; $279–$323/visit across 60–100%). Unpaid PI-lien at 15% of charges (owner-set; chargemaster-sensitive). Percent-of-billed-charges was tested and rejected — 2026 NF charges run 8–25× fee schedule, so awards don't scale with them. Validation: mature-month collections should rise toward the accrual line as Angelo's awards post. |
| Gap | What it would take |
|---|---|
| Actual per-employee payroll (name, role, pay, hours) | The Gusto payroll register — per the Ruotolo deal-state notes, this is still a physical file, not yet digitized. This is the real blocker on a true per-employee dashboard. |
| Total company headcount (not just billing providers) | A Gusto employee roster export, so front desk/RCM/BD staff are counted alongside clinicians. |
| Per-provider cost per visit | Per-employee compensation (above) joined to the per-provider visit counts already on the Per-Provider Detail tab. |
| Pay-period-level (semi-monthly) view instead of monthly | A Gusto pay-run-level export instead of monthly bank categorization. |