Area E—Clinical & Commercial Ops
Radiologist & Facility Payment Engine
Finance tooling · fail-loud by design
A monthly spreadsheet ordeal turned into one auditable click — that refuses to price what it can't.
- rate-card sheets, one pass
- 26
- rate-card sheets, one pass
- auditable monthly report
- 1-click
- auditable monthly report
01/Problem
Every radiologist has their own rate sheet per facility and modality; contractors and partners are billed differently; inputs arrive with test rows and inconsistent naming. In Excel that meant hundreds of manual lookups a month and silent errors.
02/Approach
A Streamlit engine encoding the real billing rules — pricing paths, site inclusions, exclusions and name normalization — computing per-(radiologist, facility) payouts. A sentinel makes it fail loudly: anything without a rate is flagged as unpriced rather than reported as zero. Output is a multi-sheet Excel report bundled with its inputs for record-keeping.
03/Outcome
- Monthly manual reconciliation reduced to a one-click, auditable report.
- ~1,600 exam rows against a 26-sheet rate workbook in a single pass.
- A class of silent billing errors eliminated.
04/My role
- Required correctness over convenience: in a financial system, a visible gap is safer than an invisible error.