BOM Compare
How to compare two BOM revisions.
The cleanest workflow is original BOM, revised BOM, confirmed columns, comparison report, then review of rows that are not trusted for ordering yet.
Start with identity columns
Part number is usually the safest identity column. Avoid assembly names or row labels when a real part number column exists.
Consolidate before comparing
Repeated rows and split breakdowns can inflate totals. Consolidate by part, unit, and breakdown mode before making procurement decisions.
Export a reviewable report
The output should show source context and rows needing review so the buyer can ask focused questions instead of rebuilding the spreadsheet.