Why Worksheet S-12 might take longer than expected
While the calculation process may be relatively straightforward, the harder work may involve gathering, validating, excluding, and documenting the data. As a new cost report worksheet, it will likely require some coordination across departments to ensure that data is properly set up.
This could include working with the following teams:
- Reimbursement
- Managed care contracting
- Revenue cycle
- Patient accounting
- Coding
- Finance
- Decision support
- IT
- Data analytics
- Cost reporting
In addition to this coordination, the data itself may require multiple files, manual validation, rate-to-discharge matching, exclusion documentation, and reviews of crosswalk logic.
As providers navigate Worksheet S-12, they may experience several issues, including:
- MAO names not matching across systems. The payer name in the machine-readable file may differ from the payer or plan name in the patient accounting system.
- Contract terms may have changed between the cost reporting period and the filing date.
- A hospital may have discharges for an MAO during the cost reporting period, but no current negotiated charge in the most recent machine-readable file. Conversely, the machine-readable file may include an MAO rate for a payer that had no relevant discharges.
- Needing to exclude capitated arrangements and inpatient discharges paid on a capitated basis.
- If a hospital negotiates MAO charges using a different coding or payment structure, it may need to crosswalk those codes to MS-DRGs before completing the calculation. If discharges are not already classified to MS-DRGs, they need to be classified before they are included.
These are the kinds of issues that can turn Worksheet S-12 into a larger data alignment project.
What hospitals should do now
Hospitals preparing for Worksheet S-12 may want to start by identifying who will own the process. Because the worksheet depends on both rate data and discharge data, ownership may not sit neatly within one department.
A practical readiness plan may include reviewing the instructions, identifying the most recent machine-readable file as of the cost report filing date, gathering inpatient discharge data for the cost reporting period, reconciling MAO names and identifiers across systems, identifying capitated rates and discharges, determining whether crosswalks are needed, and building a calculation file that can be reviewed and repeated.
As hospitals approach Worksheet S-12, they should view it as an opportunity to develop a reliable data-gathering and calculation process that can be set up for future cost reporting periods.
The strategic implication beyond compliance
Worksheet S-12 sits at the intersection of several major healthcare finance trends: Medicare cost reporting, hospital price transparency, Medicare Advantage contracting, and IPPS rate-setting.
That’s why hospitals should be careful about treating it as a low-priority informational requirement. The worksheet may not affect the current settlement, but OMB materials indicate that the data is intended to support future market-based MS-DRG relative weight calculations beginning in FY 2029.
For finance leaders, this creates several considerations.
First, data quality matters. If the data may inform future payment policy, hospitals should be thoughtful about the accuracy of their source files, assumptions, exclusions, and documentation.
Second, the worksheet may give hospitals a clearer view into their Medicare Advantage payment landscape by MS-DRG. That information may be useful beyond the cost report itself, especially for organizations evaluating reimbursement trends, contract performance, or service-line economics.
Third, the requirement reinforces the need for stronger governance around price transparency data. If machine-readable file data is now feeding a Medicare cost report worksheet, hospitals may want to review whether that data is accurate, usable, and aligned with internal contract and reimbursement records.
Bottom line
Worksheet S-12 is manageable, but it shouldn’t be underestimated.
For many hospitals, the worksheet will require coordination across data sources and departments that may not normally come together during cost report preparation. The calculation itself can be repeated across applicable MS-DRGs, but the quality of the result depends on the quality of the data behind it.
Hospitals that start early may be better positioned to identify data gaps, resolve mapping issues, document exclusions, and support the final values reported on the cost report.