Five Data Problems Quietly Draining Your Supply Chain Budget (And How to Fix Them)
Every supply chain leader knows the feeling: a provider calls because a critical implant scan failed at the point of use, or finance flags a massive pricing exception on a routine order that should have been under contract. These are not isolated human errors. They are the symptoms of a decaying item master, and they are happening in your organization right now whether you have mapped them or not. What most teams have not done is trace those symptoms back to their source, price the damage, and build a sequence to fix it. That is what this guide does.
Why Data Quality Degrades in the First Place
Item master data does not fail because of one large mistake. It erodes incrementally. A product description gets entered differently across two facilities. A manufacturer updates its packaging hierarchy without notifying procurement. A GTIN goes missing during a system migration. A HCPCS code that was valid last quarter has since been retired. None of these events triggers an alert. They accumulate quietly until they surface as a rejected claim, a failed scan, or a purchase that bypassed contracted pricing entirely. AHIMA research indicates that up to 30 percent of denied claims are tied to incorrect patient or product data, meaning supply chain data errors directly affect hospital cash flow, not just operational efficiency. The degradation rate for item master data without active maintenance compounds that problem: records become unreliable faster than most annual review cycles can catch. You are not starting from neutral. You are recovering ground that has been eroding for years.
The Healthcare Provider Data Cleansing Checklist
Work through these five areas in order. Each builds on the one before it.
Establish a Completeness Baseline
Before fixing anything, measure what exists. Pull a completeness report across your item master and count the percentage of records that contain each of the following fields: manufacturer name, manufacturer catalog number, GTIN, unit of measure, UNSPSC classification, HCPCS code (where applicable), and implantable status flag.
Any field below 80 percent completeness is a priority gap. Below 50 percent is a financial exposure that is actively costing the organization money today.
This baseline also establishes your internal business case. Cleansing initiatives that cannot point to a before-and-after measurement rarely hold budget through a full year. Document this number before any remediation work begins, then report against it quarterly.
Normalize Manufacturer Names and Supplier Codes
These are two separate problems that often get conflated, and it matters that you treat them separately.
Manufacturer name normalization lives in the item master. When the same manufacturer appears as "Medline," "Medline Industries," and "Medline Industries, Inc." across your product records, GPO compliance tracking cannot aggregate purchasing accurately, tier thresholds do not trigger, and contracted spend flows through at catalog price. The fix is to normalize all manufacturer names against a verified reference list, your GPO's product catalog or a Master Data Management (MDM) platform are the two most practical starting points, and flag every record where the manufacturer string does not match a canonical entry.
Supplier code validation is a separate step that lives at the intersection of the item master and your ERP's vendor master (Epic, Infor, Workday, and similar systems store this differently). Validate supplier codes against your active GPO and direct contract data and flag any item where the supplier in the item master does not correspond to the contract covering that product.
Getting these two right closes a significant share of the contract compliance gap that most health systems carry year over year.
Validate and Backfill GTINs
GTINs are the connector between physical products and digital records. When they are missing or incorrect, point-of-use barcode scans fail, staff revert to manual entry or skip documentation entirely, and consumption data understates actual usage. Replenishment triggers fire late, inventory runs short, and emergency freight fills the gap at premium cost.
The validation process starts with cross-referencing existing GTINs against the FDA's GUDID database and the GS1 global data network. A practical caution here: GUDID data is only as clean as what manufacturers submitted, and it contains gaps, typos, and outdated entries. Treat it as a starting reference, not a single source of truth. For items with missing or unresolvable GTINs, use manufacturer catalog numbers and item descriptions to contact manufacturers directly or cross-reference distributor databases. Prioritize high-velocity items and product categories with elevated scanning failure rates first. Accurate GTINs also support FDA unique device identification compliance for implantable devices, which carries its own regulatory implications.
Audit HCPCS Codes on a Quarterly Cycle
CMS updates HCPCS Level II codes quarterly, not just annually. Specific categories, including breakthrough devices and PLA codes, can be updated even more frequently. An item master that is audited only once per year carries retired codes for as many as nine months at a time, generating claim rejections on products that are legitimately billable. That revenue loss does not appear in the item master. It shows up in claims data, where it is typically attributed to billing performance rather than upstream product data quality.
Cross-reference every HCPCS code in your item master against the current CMS quarterly release. Retired codes need replacement. Missing codes on billable products need research and population. For high-cost implantable devices, verify that implantable status flags are accurate and triggering the documentation workflows that reimbursement requires. A quarterly calendar reminder is the minimum governance mechanism. Automated validation against each new CMS release is the more reliable path.
Resolve Duplicate Records
Duplicate item records fragment purchasing volume across multiple entries, which prevents volume-based tier pricing from activating and makes spend analysis unreliable. Equivalent products appear to be different items, which blocks standardization initiatives before they start.
Identify duplicates by comparing manufacturer catalog number, GTIN, and description across all item records. When merging confirmed duplicates into a single canonical record, map your ERP's historical purchase order data to the new canonical ID before completing the merge. Skipping that step breaks year-over-year spend analytics and creates a downstream data problem as large as the one you just fixed.
Maintaining What You Built
A cleansing initiative that is not followed by a maintenance program produces diminishing returns. Manufacturers update specifications. Products change. New items enter the catalog. Without active maintenance, the item master begins drifting back toward its prior state almost immediately.
Governance is the structural foundation: a defined owner for item master quality, clear standards for new item entry, and a quarterly review cycle timed to CMS updates. But manual governance does not scale for a mid-size health system processing thousands of product changes per year. Teams that rely entirely on spreadsheets and periodic projects spend their capacity on data corrections rather than the contract analysis and clinical value analysis the organization actually needs from them.
That is the problem Symmetric is built to solve. Symmetric's platform cleanses and enriches item masters at scale, normalizing manufacturer and supplier names against active contract data, validating and backfilling GTINs through FDA registration sources and the GS1 global data network, and validating HCPCS codes against each new quarterly CMS release. Clinical and operational attributes, including sterility, implantable status, packaging hierarchy, and substitute relationships, are populated and kept current so the item master supports purchasing decisions, clinical documentation, and reimbursement workflows simultaneously.
The gains from a cleansing initiative are only recurring if the data quality that produced them is also recurring. Symmetric's continuous enrichment model means manufacturer updates, code changes, and new item attributes are reflected automatically, not caught months later during the next manual project.
Where to Start
If the five-step checklist above represents more work than your current team can absorb at once, prioritize in this order: manufacturer name normalization for contract compliance, HCPCS validation for reimbursement, and GTIN completeness for inventory accuracy. These three generate the most direct financial return and the clearest before-and-after measurement to justify continued investment.
Symmetric offers item master assessments that benchmark your current completeness against each of these fields and identify where the largest financial gaps sit. If you want a clear picture of where your data stands before committing to a full cleansing program, that is the right starting point.
The item master is where supply chain strategy either takes hold or breaks down. Every dollar of contract savings, every clean claim, every scan that fires correctly traces back to a record that was accurate enough to do its job. That is where the work starts, and where Symmetric meets you.
