SNF Cost-Report Wage Data: Reconcile Paid Hours, Salaries and Benefits

Test a pay-period calculation before trusting the annual export

A fictional SNF's payroll export converts overtime pay into “equivalent regular hours.” The annual cost-report workpaper imports that column as paid hours. Every total reconciles to payroll, but the denominator is wrong for the intended wage calculation.

The CMS-2540-24 instructions, section 4901.42 for Worksheet S-3, Part II, distinguishes salaries, wage-related costs and hours. Transmittal 3 applies to periods ending on or after June 30, 2026. Overtime paid at time and a half counts as one hour. The worked example below concerns Part II only; it assumes the stated paid leave belongs in the corresponding adjusted salaries and paid hours. It does not establish leave treatment for Part V or another reporting program. The applicable worksheet also controls treatment of paid leave, on-call time, contract labor and home-office amounts; a staffing report cannot supply those conclusions by itself.

Work the hours and dollars separately

This original example uses a simplified employee population and assumes the listed categories belong in the selected reporting line. It is not an official worksheet or payroll-policy recommendation.

The simplified salary-per-paid-hour figure is $36,900 ÷ 1,180 = $31.27. If the export converts 100 overtime hours to 150 equivalent hours, the denominator becomes 1,230 and the figure falls to $30.00. The dollars still reconcile; the definition error changes the result.

A PBJ-style worked-hours population could differ again because it serves a different reporting purpose. The correct response is to reconcile the definitions, not to force the two hour totals to match.

Bridge the payroll population to the selected section

The finance lead records which cost-report section is being prepared and the exact payroll period covered. The mapping distinguishes W-2 salaries, wage-related costs, contract labor, excluded services and supported home-office allocations. A single “labor expense” ledger group can contain several of these.

Suppose the general ledger contains $42,900 for the example population: $36,900 salary plus $6,000 of wage-related costs. The salary schedule should not silently absorb the extra $6,000. The preparer records the benefits separately and applies the relevant worksheet treatment.

If a central employee's salary is allocated to two facilities, preserve the allocation and associated hours. An allocated dollar amount without reliable hours may require different treatment under the instructions. Do not invent hours by dividing an invoice by an assumed wage.

Keep wage-related reporting and allowable cost distinct

CMS directs use of GAAP for specified wage-related-cost reporting while maintaining Medicare payment principles for other allowable fringe-benefit determinations. That means a cost may appear in one analytical schedule without automatically establishing its allowable cost-finding treatment.

The workpaper should state the purpose of each column. “Included in wage-related reporting” and “allowable cost” are separate conclusions with separate source references. If the preparer adjusts a cost for one purpose, identify whether the other schedule changes rather than copying the adjustment everywhere.

For agency or other contract labor, reconcile the contract, invoice period, services and any supported hours to the applicable reporting instructions. An agency invoice can include nonlabor charges or services outside the selected category. The invoice total is not automatically the wage-reporting numerator.

Review the exception population before annualizing

Run the same tests on employees with overtime, paid leave, bonuses, on-call compensation, department transfers and shared services. These are targeted definition checks, not a demand to duplicate every payroll calculation manually.

For the fictional facility, the reviewer corrects the overtime mapping, separates $6,000 of benefits and documents the paid-leave treatment. The annual extract is regenerated from the corrected mapping, and the original version remains available to explain the change.

The final output includes the payroll-to-ledger bridge, section-specific mapping, hours reconciliation, wage-related schedule and unresolved exceptions. During a platform evaluation, use the 1,180-hour example to test whether an export preserves actual hours separately from pay multipliers. A total that agrees with payroll is necessary but insufficient for a defensible cost-report submission.