The Price File's Quiet Drift: A Quarterly Reconciliation for Ambulatory Buyers

Most clinic purchasing teams treat the distributor's price file as a reference document. It is better understood as a moving translation of a contract, one that is edited by item masters, unit-of-measure rules, freight tables, and effective-date logic. When those translations drift, invoices rarely announce the change. A glove that was priced by the box may appear by the case. A freight threshold may be applied before a contract discount. A new tier may take effect two weeks after the file says it should. The result is not usually one dramatic overcharge. It is a series of small, plausible line items that survive because no one compares them back to the agreement.

A quarterly price-file audit is not an exercise in distrust. It is a maintenance routine for the purchasing relationship. The goal is to catch translation errors while they are still small, recover what can be recovered, and correct the item master so the same error does not return on the next order.

Begin with the contract, not the invoice

The invoice is evidence of what was charged. The contract is evidence of what should have been charged. Starting with the invoice tends to produce a hunt for suspicious line items; starting with the contract produces a checklist of terms that must be verified. For each high-spend category, pull the current agreement, the distributor's current price file, and the invoices from the quarter. If the practice uses a group purchasing organization, include the GPO roster and any local agreements that modify it. If the distributor provides an EDI 832 price catalog, keep a dated copy; the file is a snapshot, not a permanent record.

Build a small contract matrix before comparing dollars. List the item description, manufacturer number, contract number, contracted unit of measure, contracted price, effective date, and any tier or volume condition. This matrix becomes the standard against which both the price file and the invoice are judged. It also exposes gaps in the agreement itself, such as items that are described in clinical language but not tied to a specific manufacturer number.

Convert units before comparing dollars

Unit-of-measure errors are the most common source of quiet drift in clinical purchasing. A contract may price a product by the case, while the price file lists it by the each. A distributor may convert a case to eaches using a factor that does not match the manufacturer's packaging. A custom procedure tray may be ordered as a kit but invoiced by component. These are not always errors in arithmetic; they are errors in translation.

For the audit, compare the unit of measure at three points: the contract, the price file, and the invoice. Where the unit differs, calculate the extended price both ways and record the variance. Do not accept a verbal explanation that the units are equivalent. Ask for the conversion factor in writing and confirm it against the packaging label or the manufacturer's specification. If the practice cannot verify the factor, treat the line as an exception until it is resolved.

Separate freight from product

Freight add-ons deserve their own review because they are often governed by rules that sit outside the item price. A distributor may apply a prepaid-and-add threshold, a minimum order charge, a fuel surcharge, or a special-handling fee for cold-chain or hazardous items. Some of these charges are legitimate. The audit question is whether they were applied according to the agreement and whether they were disclosed in a way the clinic could verify.

Pull a sample of invoices that include freight and compare the charges to the distribution agreement's freight schedule. Confirm the order subtotal used to calculate the threshold, the date the threshold was in effect, and whether any contract language exempts certain products or order types. If the practice is charged freight on an order that met the prepaid threshold, log it as an exception with the invoice number and the relevant contract clause. Repeated freight exceptions are a sign that the distributor's order-entry rules and the contract are not aligned.

Verify effective dates and tier triggers

Price files are dated documents, but invoices do not always respect the date. A new contract price may be loaded early, or an old price may linger after the effective date. Volume tiers introduce another layer: a clinic may qualify for a lower price only after a quarterly threshold is met, and the distributor may apply the tier retroactively or prospectively depending on the agreement. The audit should confirm which date governs and whether the invoice reflects it.

For each exception tied to a date or tier, record the effective date from the contract, the date shown in the price file, and the invoice date. If the agreement is silent on retroactivity, do not assume the clinic's preferred interpretation. Ask the distributor to document its practice and, if necessary, amend the agreement so the next quarter is unambiguous.

Build an exception log that recovers money

An exception log is more than a list of complaints. It is the clinic's institutional memory for purchasing errors. A practical log should include the invoice date and number, item description, manufacturer number, contract reference, price-file value, invoiced value, variance, root cause, recovery status, and owner. Root causes should be specific: unit-of-measure conversion, freight threshold, effective date, tier application, item-master mismatch, or duplicate line.

Do not net exceptions against one another. A ten-dollar overcharge on one line does not disappear because another line was undercharged. Keep each exception separate, attach the supporting invoice and contract excerpt, and submit them to the distributor's account manager in a single quarterly package. Ask for a credit memo or debit memo where appropriate, and track the resolution date. Overpayments that are recovered are useful; overpayments that are prevented are better.

Close the loop with the item master

The audit is not finished when the credit memo arrives. The final step is correcting the conditions that produced the exception. If the item master lists a case price as an each price, fix it. If a freight rule is misapplied, ask the distributor to update the account profile. If a contract lacks a manufacturer number, add one. If a new item was loaded without a unit-of-measure review, add that review to the new-item setup process.

Small teams can run this routine in a few hours per quarter by sampling high-spend lines rather than auditing every invoice. Choose a fixed week each quarter, pull the contract matrix and price-file snapshot, and review the invoices from the prior ninety days. The discipline matters more than the sample size. A price file will keep drifting; a quarterly reconciliation keeps the drift visible, documented, and correctable.