Pricebook Guide
Pricebook Rate Validation Checklist for HVAC/R Contractors
Pricebook rate validation is the work of checking that the costs in your price book match current approved vendor pricing. It is simple to describe and easy to put off, because it is detailed, item-level work that never fully finishes.
This checklist breaks it into steps your team can follow, whether you do it in-house or have someone do it for you.
What Rate Validation Is (and Is Not)
Rate validation compares the cost on each active item record to an approved source of vendor pricing, such as a supplier price file, account price list, or recent invoices your team trusts.
It is not the same as setting prices. Markups and selling prices are pricing decisions. Rate validation makes sure those decisions start from accurate costs.
It is also not a one-time project. Vendor costs keep changing, so validation works best on a regular cadence.
Before You Start
- Decide which sources count as approved vendor pricing. Agree on this in advance so nobody is validating against an unofficial number.
- Decide who can authorize cost changes to item records.
- Export or list your active items with part number, vendor, unit of measure, and cost on file.
- Identify your most-used items. Start there.
The Checklist
1. Match each item to the right vendor part
Confirm the item record points to the correct supplier part number. A cost comparison against the wrong part is worse than no comparison.
2. Confirm the unit of measure
Check that the vendor price and the item record use the same unit: each, box, case, foot, roll. Convert where needed before comparing.
3. Compare the cost on file to the approved cost
Note the difference for each item. Record the source and date of the approved cost.
4. Check for superseded or discontinued parts
If the vendor shows a replacement part number, the active record may need to point to the new part and its cost.
5. Look for duplicates
If the same part exists as more than one active item, costs may differ between them. Flag duplicates for a decision about which record stays active.
6. Separate clear matches from exceptions
Clear matches, same part, same unit, approved source, can be updated when authorized. Anything ambiguous goes on an exceptions list.
7. Update approved records
Apply cost changes only to clearly matched items, under whatever approval process you set. Keep a record of what changed.
8. Route exceptions for a decision
Send the exceptions list to the person who owns those decisions. Do not guess on unclear matches.
9. Share what moved
Give purchasing and pricing owners a short summary of which items and vendors changed most.
10. Set the next review date
Decide when the next validation happens, and who owns it.
Common Exceptions to Expect
- The vendor part number has changed and the item record has not.
- The vendor sells by the case and the item record stores each.
- Two suppliers price the same part differently and the item record names neither.
- A cost increase is large enough that someone should confirm it before it is applied.
- The item appears to be obsolete but is still active.
Exceptions are normal. The point of validation is to find them, not to force them through.
How Often to Validate
The right frequency depends on how many items you carry, how often your suppliers change pricing, and how much your most-used parts move. See how often to review HVAC vendor costs.
Where Software Fits
Many platforms can import supplier pricing or sync costs for mapped items. That can reduce manual entry, but the steps above still apply: items must be mapped correctly, units must match, and exceptions still need human review.
When to Get Help
If rate validation keeps slipping because nobody has time for it, that is a common situation, not a failure. Margin Defense Co. performs manual, line-by-line vendor-cost review against your active item records, updates clearly matched cost fields when authorized, and flags exceptions for your direction, inside the price book or ERP you already use.
Learn more about vendor price book maintenance and master item list maintenance.
The Takeaway
Validation is ten simple steps repeated across many items. Doing it consistently, with clear ownership and a clear exceptions process, is what keeps your pricebook costs current.
Want a Second Set of Eyes on Your Costs?
Schedule a short cost review to talk through how your pricebook costs are maintained today.