Visiting Consultant and Surgeon Fee-Split Engine: Package Deduction Waterfalls, Multi-Surgeon Allocation, and TDS Payout Reconciliation

Why Spreadsheet Doctor Payouts Bleed Hospital Margin and Erode Physician Trust?

Hospital physician compensation rarely follows a single flat percentage. A single tertiary hospital typically manages five simultaneous contracting models across 150 to 400 consultants:

1. Pure Fee-for-Service (Visiting Consultant): Receives 70%–85% of OPD consultation fees, 60%–75% of inpatient bedside visit fees, and a negotiated share of surgical procedure charges.
2. Minimum Guarantee (MG) + Revenue Share: A newly onboarded full-time retainership consultant receives a fixed monthly retainer (e.g., ₹4,50,000/month) OR 25% of net generated surgical/OPD revenue, whichever is higher (with or without quarterly deficit clawback).
3. All-Inclusive Fixed Surgical Packages (Cash & TPA/Insurance): When a patient undergoes a Total Knee Replacement (TKR) or Percutaneous Coronary Intervention (PCI) under a bundled ₹2,80,000 package, paying the surgeon a flat 25% of the gross ₹2,80,000 invoice is a severe financial error if the package includes a ₹95,000 imported knee implant, ₹32,000 of OT pharmacy/consumables, and 2 unbundled extra ICU days caused by a complication.
4. Accrued Billing vs. Realized Cash Realities: If finance pays the visiting surgeon at the end of Month 1 based on *billed* invoice value, and the Third-Party Administrator (TPA) subsequently applies a 12% tariff deduction or ₹18,000 non-payable consumable disallowance in Month 3, recovering the overpaid share from a visiting consultant is operationally painful.

*Figure 1: End-to-end visiting consultant fee-split waterfall architecture from bundled surgical package carve-outs through TPA collection release and Section 194J TDS ERP settlement.*

Mathematical & Accounting Waterfall Model

1. Net Distributable Surgical Package Waterfall ($P_{\text{net}}$) For any bundled inpatient surgical package with gross invoiced package value $G_{\text{pkg}}$ and approved patient/corporate discount $D_{\text{approved}}$, let the hospital bears-proportion of the discount be $(1 - \alpha_d)$ and the consultant bears-proportion be $\alpha_d \in (0, 1)$ (per contract). Before applying any physician share percentage, the doctor payout software deducts actual barcode-consumed material and institutional floor costs:

$$P_{\text{net}} = \max\left(0,\; G_{\text{pkg}} - \alpha_d D_{\text{approved}} - C_{\text{implants}} - C_{\text{OT\_consumables}} - C_{\text{pharmacy}} - C_{\text{blood}} - C_{\text{diagnostics\_floor}} - C_{\text{room\_floor}}\right)$$

Alternatively, for procedures governed by a Surgeon Tariff Carve-Out Model, the package header explicitly defines a baseline Surgeon + Anesthesia Pool $B_{\text{surg\_pool}} = \beta_{\text{pool}} \times (G_{\text{pkg}} - C_{\text{implants}} - C_{\text{high\_cost\_consumables}})$, which is automatically reduced dollar-for-dollar if actual OT consumable consumption $C_{\text{OT\_actual}}$ exceeds the standard package bill-of-material cap $C_{\text{OT\_cap}}$:

$$P_{\text{net\_carveout}} = B_{\text{surg\_pool}} - \gamma_{\text{overrun}} \max\left(0,\; C_{\text{OT\_actual}} - C_{\text{OT\_cap}}\right)$$

2. Multi-Surgeon Role Split & Bilateral/Multiple-Procedure Scaling When a single surgical sitting includes $M$ procedures sorted in descending order of complexity ($m = 1, 2, \dots, M$), standard surgical billing and payout rules scale secondary procedures inside the same incision/sitting by $\lambda_1 = 1.00$ (100%), $\lambda_2 = 0.50$ (50%), and $\lambda_{\ge 3} = 0.25$ (25%). Across the operative team roles $r \in \{\text{Primary}, \text{CoSurgeon}, \text{Anesthetist}, \text{Assistant}\}$ with weights $\sum_r w_r = 1.00$, the gross earned share $E_{d,k}$ for doctor $d$ in role $r$ on case $k$ after collection realization ratio $\rho_{\text{realized},k} \in (0, 1)$ is:

$$E_{d,k} = P_{\text{net},k} \times w_r \times \rho_{\text{realized},k}, \qquad \text{where } \rho_{\text{realized},k} = \frac{\text{Cash Received} + \text{TPA UTR Settled} - \text{Disallowances}_{\text{clinical}}}{\text{Net Billed Invoice Value}}$$

3. Minimum Guarantee (MG) vs. Revenue-Share & Section 194J TDS Equation For a consultant on a monthly Minimum Guarantee $MG_d$ with cumulative monthly earned share $E_{d,\text{month}} = \sum_{k} E_{d,k}$, gross payable compensation $Y_{\text{gross},d}$ and net bank disbursement $Y_{\text{net},d}$ after statutory Income Tax Section 194J withholding ($\tau_{\text{194J}} = 10\%$ for independent professional services, or 20% under Section 206AA if PAN is invalid/unlinked) are:

$$Y_{\text{gross},d} = \max\left(MG_d,\; E_{d,\text{month}}\right) - R_{\text{clawback},d}$$

$$Y_{\text{net},d} = Y_{\text{gross},d} \times \left(1 - \tau_{\text{194J}}\right) - D_{\text{facility\_recoveries},d}$$

*(Note: GST is strictly 0% on clinical healthcare services rendered by doctors to hospitals/patients under Indian GST Notification No. 12/2017-Central Tax (Rate) Heading 9993, whereas non-clinical retainership/administrative director fees attract 18% GST reverse/forward verification).*

Worked Illustrative Example: Bilateral Total Knee Replacement (TKR) Package Waterfall & Payout

Consider an illustrative cash + TPA co-paid Bilateral Total Knee Replacement package (Case IPD-2026-99210) under Senior Orthopedic Visiting Consultant Dr. A. Mehta (Contract: 28% of Net Package ex-Implant/Consumable Overrun; Primary Surgeon = 75% of Surgical Pool, Anesthetist Dr.

S. Nair = 18%, Assistant Surgeon Dr. R.

Verma = 7%):

1. Gross Package & Waterfall Deductions:

• Gross Bundled Bilateral TKR Package ($G_{\text{pkg}}$): ₹4,20,000
• Approved Corporate/Hospital Discount ($D_{\text{approved}}$, `50%` doctor-borne $\alpha_d = 0.50$): ₹20,000 ($\rightarrow$ ₹10,000 deducted from package base).
• Barcode-Scanned Orthopedic Knee Implants (`2 × GS1-128 Femoral/Tibial/Insert sets`, $C_{\text{implants}}$): ₹1,50,000
• High-Cost OT Pharmacy, Bone Cement & Consumables ($C_{\text{OT\_consumables}}$): ₹42,000
• Diagnostics, Blood Bank & Ward Room Floor ($C_{\text{floor}}$): ₹58,000
• Net Distributable Package Base ($P_{\text{base}}$):

$$P_{\text{base}} = 4,20,000 - 10,000 - 1,50,000 - 42,000 - 58,000 = \mathbf{₹1,60,000}$$

• Surgical Team Distributable Pool (`60%` of Net Distributable Base):

$$P_{\text{net}} = 0.60 \times ₹1,60,000 = \mathbf{₹96,000}$$ *(Compare this against a naive spreadsheet that accidentally applied a 28% surgeon share to the gross ₹4,20,000 package = ₹1,17,600 to the primary surgeon alone—an immediate `₹45,600` hospital margin leak on a single surgery!)*

1. Multi-Surgeon Role Allocation & TPA Realization Check:

• The TPA settles 95% of the admissible surgical bill via NEFT UTR (5% tariff deduction on procedure lines; $\rho_{\text{realized}} = 0.95$).
• Realized Surgical Team Pool: $₹96,000 \times 0.95 = \mathbf{₹91,200}$:
• Primary Surgeon (`Dr. A. Mehta`, `75%`): $0.75 \times ₹91,200 = \mathbf{₹68,400}$
• Anesthetist (`Dr. S. Nair`, `18%`): $0.18 \times ₹91,200 = \mathbf{₹16,416}$
• Assistant Surgeon (`Dr. R. Verma`, `7%`): $0.07 \times ₹91,200 = \mathbf{₹6,384}$

1. Section 194J TDS Withholding & Net NEFT Disbursement (`Dr. A. Mehta`):

• Gross Payout on Case: ₹68,400
• Less Section 194J Professional TDS (10%): -₹6,840 (posted automatically to GL-210410 TDS Payable — Sec 194J)
• Net Bank NEFT Transfer (`Dr. A. Mehta`): `₹61,560`, accompanied by an interactive drill-down statement showing the exact patient MRN, package waterfall, implant serial deduction, TPA UTR date, and Form 16A certificate mapping.

*Table 1: Financial and operational comparison of manual spreadsheet physician payouts versus automated package-waterfall and collection-linked payout software.*

Control & Exception Governance Matrix

*Table 2: Governance controls for OT-to-billing surgeon attribution, discount allocation, TPA disallowances, Section 194J/206AA TDS, and global package readmissions.*

Bounded Pilot Scope, Baseline Window, and Stop/Recovery Criteria (BOFU Implementation Gate)

To transition safely from legacy Excel sheets without disrupting monthly physician disbursements, deploy the doctor payout software under a bounded 60-day parallel pilot:

• Bounded Pilot Scope: Encompasses 3 surgical/procedural departments (Cardiology, Orthopedics, and Surgical Oncology — ~85 visiting and MG consultants) across 2 monthly payout cycles (`60 days`), integrated read-only with HIS billing, OT implant consumption, and TPA bank UTR settlement feeds.
• Baseline Comparison Window: Compare pilot calculations against the prior 90-day (`3-month`) historical manual spreadsheet payouts and external statutory audit adjustments for the exact same 85 consultants.
• Explicit Stop / Recovery Exit Criteria:

1. Zero Variance on Audited Contract Rules: Parallel-run reconciliation between the software waterfall and independent finance internal audit sample (100 complex surgical packages) must achieve `100%` mathematical concordance (`₹0` unexplained formula error) before disabling manual Excel sign-off.
2. Rollback Trigger: If >1.0% of settled cases fail to map OT role attribution (Primary / Anesthetist / Assistant) or if ERP GL accrual-to-payable journal vouchers show any trial-balance imbalance, halt automated NEFT bank file generation immediately, revert disbursement batching to the verified shadow ledger, and resolve master-tariff mapping within 24 hours.

Observable Acceptance Tests

• ACT-HC-118-01 (Implant & High-Cost Consumable Carve-Out Accuracy): Process a ₹4,20,000 Bilateral TKR package containing ₹1,50,000 of GS1-128 scanned knee implants, ₹42,000 of OT consumables, ₹58,000 of ward/diagnostic floor costs, and a ₹20,000 50%-shared discount. Verify that the doctor payout software calculates the Net Distributable Base as exactly ₹1,60,000 and prevents any percentage fee split from applying to the ₹1,50,000 implant line.
• ACT-HC-118-02 (Credit TPA Suspense Hold & Pro-Rata UTR Release): Generate a credit TPA surgical invoice on October 18 (Month 1) and run the October 31 payout batch before the TPA pays. Confirm that the consultant's share posts to Accrued Suspense GL (excluded from October bank disbursement), and upon posting a 95% settled TPA bank UTR on November 14 (Month 2), automatically moves 95% of the share into the November Verified Payable Pool.
• ACT-HC-118-03 (Minimum Guarantee (MG) vs. Revenue Share Higher-Of Switch): For a consultant with MG = ₹4,50,000/month, simulate Month 1 net earned revenue share of ₹3,80,000 and Month 2 net earned share of ₹5,40,000. Verify that the system pays ₹4,50,000 gross in Month 1 (logging ₹70,000 MG subsidy) and ₹5,40,000 gross in Month 2.
• ACT-HC-118-04 (Section 194J `10%` vs. Section 206AA `20%` TDS Enforcement): Run a payout batch for Consultant A (Verified Active PAN) and Consultant B (Unverified/Inoperative PAN flag). Confirm the system deducts 10% TDS under Section 194J for Consultant A and automatically enforces 20% higher-rate TDS under Section 206AA for Consultant B.

Next Steps

1. Digitize All Physician Contract Archetypes into Structured Tariff Rules: Encode consultant-specific OPD/IPD visit splits, surgical package deduction waterfalls, slab thresholds, MG retainer floors, and discount-sharing ratios (α_d) in the contract master.
2. Enforce Mandatory OT Operative Role Sign-In: Link the intraoperative WHO Time-Out nursing record directly to the billing invoice so Primary Surgeon, Co-Surgeon, Anesthetist, and Assistant Surgeon shares allocate automatically without manual finance data entry.
3. Activate Collection-Linked Suspense Accounting for Credit Payers: Separate Billed Accrued Doctor Share from Realized Cash Payable Share using automated TPA/Corporate UTR reconciliation feeds.
4. Launch the Self-Service Consultant Mobile/Web Payout Portal: Give every visiting consultant real-time visibility into their daily billed cases, pending TPA settlements, package waterfall deductions, and downloadable quarterly Form 16A TDS certificates.

Frequently Asked Questions

How should multi-specialty hospitals automate visiting-consultant fee-for-service splits across cash vs TPA/CGHS tariff packages, co-surgeon deductions, consumables caps, and Section 194J TDS settlements?

Teams should govern doctor payout software by linking every transaction to its source evidence, timestamp, and assigned owner before permitting downstream posting. Distinct from HC-008 (patient IPD final bill generation); HC-118 resolves complex doctor revenue-share rules where fixed-price surgical packages must first deduct high-cost implants/stents and hospital bed overruns before computing surgeon shares. Rather than relying on informal spreadsheet overrides, the workflow enforces a documented verification gate and preserves the original observation whenever a correction is recorded.

How does hospital billing software handle exceptions and mismatches?

When a discrepancy occurs during hospital billing software, the system routes the blocked record into an owned exception queue rather than silently dropping or auto-adjusting the balance. Assigned operational, quality, and finance owners must review and approve exceptions before posting. Each exception retains the original quantity, date, and counterparty reference until the designated reviewer resolves the variance with supporting evidence.

What should teams test before automating healthcare erp?

Before scaling healthcare erp, run a bounded pilot using historical records that include partial receipts, late updates, duplicate messages, and rejected lines. Verify that the integration preserves idempotency, maintains a clear segregation of duties between operational entry and financial approval, and produces an auditable trail for every state transition.

Next actions

1. Audit one recent week of visiting consultant doctor fee split surgery package tds payout (HC-118) records across HIS, billing, and departmental registers to baseline exception rates.
2. Define mandatory fields, role-based approval gates, and hold reasons for HC-118 before automating handoffs.
3. Run a supervised two-week pilot for visiting consultant doctor fee split surgery package tds payout on one hospital unit and verify that every override preserves an auditable timestamp and owner.

Topics: visiting consultant doctor fee split surgery package tds payout · hospital erp workflow · nabh audit trail