PMS Semantic Mapping / Reporting Overlay
“Do not start by ripping out five ERPs. Start by creating one trustworthy EBITDA, cash, and KPI view across all of them.”
WebPT
142 accounts
Clinicient (Legacy)
218 accounts
Manual / Excel
87 accounts
| Normalized Account | Coastal PT (Main — 8 clinics) | Coastal PT (3 clinics) | Add-On #3 (Sports Medicine — 3 clinics |
|---|---|---|---|
| Patient Revenue — Commercial | Revenue — Commercial Insurance 97Mapped | Rev_CommIns_All 82Mapped | Insurance Payments (Column D) 45Review |
| Patient Revenue — Medicare | Revenue — Medicare Part B 98Mapped | Rev_Medicare_PartB 88Mapped | Medicare Payments (Column E) 42Review |
| Patient Revenue — Medicaid | Revenue — Medicaid MCO 95Mapped | Rev_Medicaid_MCO 85Mapped | Medicaid (Column F) 38Unmapped |
| Patient Revenue — Self-Pay | Revenue — Self-Pay / Patient Responsibility 94Mapped | Rev_SelfPay 90Mapped | Cash Payments (Column G) 52Review |
| Provider Compensation | Salaries — Licensed Providers 96Mapped | Provider_Salary_Expense 78Mapped | Payroll — Providers 65Review |
| Clinical Staff Compensation | Salaries — PTAs, Techs, Admin 93Mapped | Staff_Salary_All 72Review | Payroll — Staff 60Review |
| Facility Rent & Occupancy | Rent Expense — Clinics 99Mapped | Rent_Occupancy_All 91Mapped | Rent (Column J) 70Mapped |
| Medical Supplies & Equipment | Supplies — Clinical / Rehab Equipment 92Mapped | Supplies_Clinical 76Mapped | Supplies + Equipment (mixed) 35Unmapped |
| Malpractice Insurance | Insurance — Professional Liability 98Mapped | Ins_Malpractice 95Mapped | Insurance (mixed line) 40Review |
| Billing & Collections Costs | Revenue Cycle — External Billing 90Mapped | Billing_Service_Fees 82Mapped | Not tracked separately 0Unmapped |
| PMS/EMR License Fees | Software — WebPT Subscription 99Mapped | Software_Clinicient_License 97Mapped | N/A — No PMS 0Unmapped |
| Depreciation — Clinical Equipment | Depreciation — Rehab Equipment 95Mapped | Depr_Equipment 88Mapped | Not tracked (cash basis) 0Unmapped |
| Marketing & Patient Acquisition | Marketing — Digital + Print 91Mapped | Marketing_All 80Mapped | Marketing (Column K) 55Review |
| Accounts Receivable — Net | AR — Net of Allowance for Doubtful 94Mapped | AR_Net 86Mapped | Outstanding Bills (manual tracking) 30Unmapped |