SurveyCompletion& Cost Mapping
We handle the allocation and data entry so you don't have to.
Learn More
Service Benefits
Optimal Resource Use
Populating detailed survey forms requires significant analyst time. Outsourcing the allocation process allows your finance staff to focus on internal priorities while ensuring timely survey completion.
Methodological Consistency
Most health plans have unique internal classification systems. As the authors of the benchmarks, we ensure your data is mapped precisely to standard definitions, facilitating true peer-group comparability.
Ease of Future Use
We deliver a mapped template tailored to your chart of accounts, so future-year participation is faster and easier. Your team can reuse our structure and focus on updates rather than rebuilding the mapping each cycle.
The Harmonization Process
Sherlock Company analyzes cost center descriptions and staffing logs to allocate expenses to the appropriate functional areas. We adjust for shared resources and carve out overhead (such as facilities or IT support) to align with the benchmark methodology.
Example: Allocation of a "Center of Excellence" Cost Center
Input: Client Data
Source: General Ledger/Trial Balance & Staffing Logs
Description: Enterprise-wide Business Process Improvement.
Note: Includes 2 FTEs focused on Provider Education.
Output: Harmonized Allocation
Source: Sherlock Benchmark Definitions
Engagement Timeline
Typical project duration is approximately 2.5 months from receipt of complete data.
Initiation
Week 0
Data Request Sent
Data Receipt
Week 2
GL & Staffing Received
Harmonization
Weeks 2–8
Classification & Populating Forms
Validation
Week 10
Review with Health Plan
Final Report
Week 12
Submission Complete
Data Requirements
To facilitate the harmonization process, we request the following standard data extracts:
- Member months or members by product
- Premium revenues & health care costs by product
- Cost center GL data & activity descriptions
- Audited Financial Statements
- FTE counts & descriptions
- Fully-loaded staffing costs by function
Ready to Get Started?
For detailed information regarding service fees, licensing options, or participation in the upcoming study, please contact us directly.
Contact UsSubscribe and receive insights into the metrics and trends shaping health plan performance.