Benchmark Negotiated Rates

You can benchmark a negotiated rate by filtering the same service to a comparable payer, provider, location, and rate type, then comparing the observed commercial rate with the local distribution of published rates and a Medicare reference point. Start with one CPT or HCPCS code, identify the insurer and the provider or facility, set the geographic market, and compare the rate against the median and percentile range for similar records.

Every useful benchmark is built on four fields:

1. Insurer or plan network: the payer, meaning the health plan or issuer that negotiated the rate.
2. Provider, facility, or billing entity: the organization or clinician holding the contract.
3. CPT or HCPCS code: the standard billing code that defines the item or service.
4. Geographic market: the ZIP code, metro area, county, or state you are comparing within.

Gigasheet provides nationwide healthcare price transparency data across payers and providers, with commercial negotiated rates alongside Medicare benchmarks, analysis in a spreadsheet-like interface, downloadable datasets, and APIs.

How do you benchmark a negotiated rate by insurer, provider, CPT code, and location?

A useful negotiated-rate benchmark compares the same billing code within a defined market, then separates results by insurer, provider or facility, and negotiated-rate type. A negotiated rate is the in-network amount a plan and provider have agreed to for a covered service.

A repeatable method:

1. Select the service code. Pick one CPT or HCPCS code and confirm its definition.
2. Choose the location definition. Use a ZIP code, metro area, county, or state, and apply it consistently.
3. Filter to the payer or network under review.
4. Identify the provider, facility, or billing entity.
5. Separate dollar rates from percentage-based arrangements. Never mix the two in one calculation.
6. Compare against reference points. Place the selected rate against the local median, lower and upper percentiles, and a Medicare reference point.
7. Document your inputs. Record the file date, payer, code, location, and rate type for every comparison.

This is an analysis method, not a regulatory requirement. Its purpose is to make sure two numbers you compare actually describe the same thing.

What fields should a negotiated-rate benchmark include?

The minimum benchmark record is the billing code, payer, provider or facility identifier, location, negotiated rate, negotiated-rate type, and file date. Adding a Medicare reference gives the result context.

• CPT or HCPCS code: defines the item or service being compared.
• Insurer or plan network: separates commercial reimbursement by payer.
• Provider, facility, TIN, or NPI: identifies the contracted entity when available. The TIN is the Taxpayer Identification Number of the billing organization. The NPI is the National Provider Identifier of an individual or organization.
• Location: keeps comparisons local enough to be useful.
• Negotiated rate: supplies the commercial dollar amount or percentage.
• Negotiated-rate type: prevents dollar rates and percentage arrangements from being mixed.
• File date: shows when the published rate was observed.
• Medicare reference: gives a second, independent benchmark for context.

Expect some records with an NPI of zero. According to CMS technical guidance, when a contract exists only at the TIN level and NPIs are unknown or unavailable, plans should report 0 in the NPI field. Benchmark those records at the TIN level rather than discarding them.

How should you compare commercial negotiated rates with Medicare?

Compare commercial rates with Medicare only after confirming that the service definition, billing setting, geographic basis, and rate format are comparable. A Medicare benchmark is the amount Medicare pays for the same service, used here as a reference point rather than a target.

The common way to express the comparison is as a percentage of Medicare. In a hypothetical example, a $300 commercial rate compared with a $150 Medicare amount for the same code, setting, and locality is 200% of Medicare. The math is simple. The hard part is making sure both numbers describe the same service in the same setting and place.

CMS draws a reporting distinction that matters here, per its technical clarification:

• Percentage of Medicare: if payment is based on a determinable percentage of another rate, such as Medicare reimbursement, the plan should report the calculated dollar amount as the negotiated rate.
• Percentage of billed charges: plans can use the "percentage" negotiated-rate type, entered as a whole number. A rate of 37.5% of billed charges is reported as 37.5, not .375.

So a percentage in the file is not a percentage of Medicare. Treat it as a share of a provider's billed charges, and keep it out of any dollar-based median or percentile.

What do Transparency in Coverage machine-readable files tell you about negotiated rates?

Transparency in Coverage machine-readable files publish in-network negotiated-rate data, but the records need normalization before they can support payer, provider, code, and location comparisons. Machine-readable files are the large, structured data files that plans and issuers post publicly under the Transparency in Coverage rules.

Common issues to handle before benchmarking:

• Different payer and network structures. One payer may publish many plans and networks with different rates.
• Multiple provider identifiers. A rate may tie to a TIN, one or more NPIs, or both.
• TIN-level contracts with unavailable NPIs. These appear as NPI 0.
• Dollar rates versus percentage-based arrangements. Check the negotiated-rate type on every record.
• Professional versus institutional rates. CMS guidance describes a billing class field that flags whether a rate is based on a professional or institutional claim. Do not combine the two unless your analysis calls for it.
• File dates and schema changes. Rates can shift when files refresh or the reporting format changes.
• Geographic definitions. Provider locations may not map cleanly to how you define your market.

Available fields vary by file. Inspect the rate type and provider identification fields before comparing records. For a broader walkthrough, see our guides to analyzing price transparency data and comparing insurer negotiated rates.

How often should negotiated-rate benchmarks be refreshed?

Refresh negotiated-rate benchmarks when new machine-readable files are published, and record the file date in every comparison.

CMS requires plans and issuers to update the files monthly and clearly show the date of the most recent update. CMS describes monthly as reasonably consistent periods of about 30 days, without a specific day of the month. CMS also says a negotiated rate in effect at any time during a monthly reporting period must appear in that month's file.

The file format changes too. CMS stated that files for February 2026 posted on or after February 2, 2026, should follow schema version 2.0, and that files for March 2026 onward should also use version 2.0 unless CMS says otherwise. When your benchmark spans file dates on both sides of a schema change, confirm the fields mean the same thing before comparing.

How can Gigasheet support negotiated-rate benchmarking?

Gigasheet helps teams analyze nationwide negotiated-rate data by payer, provider, billing code, and location without building their own data infrastructure.

Gigasheet provides:

• Nationwide negotiated-rate data across payers and providers.
• Commercial negotiated rates alongside Medicare benchmarks.
• Analysis in a spreadsheet-like interface.
• Downloadable datasets and APIs for repeatable benchmarking.
• Licensed bulk nationwide price transparency data.

Teams use it to review rate ranges before contract reviews, repricing analysis, network assessments, and cost-containment projects. See pricing, explore Gigasheet, or Request a Demo.