SUPPLIER PRICE LIST GUIDE
How to compare two supplier price lists.
Use the previous and updated list from the same supplier. Keep both in the same currency and tax basis. A reliable comparison needs a stable product identifier, not a product description that may have been rewritten.
1. Check the inputs
Put one product on each row. Identify the product-code and listed-price columns. If both files contain units per pack, map that field on both; otherwise compare listed prices only and review pack changes separately.
2. Match by product code
Preserve codes exactly as supplied, including leading zeroes. Duplicate or blank codes should remain visible for review rather than being merged or discarded. Different codes should not be treated as the same product merely because their descriptions look similar.
3. Separate each result
Classify matched products as increased, decreased or unchanged. Keep products found only in the updated list as added, and products found only in the previous list as removed. Invalid prices and duplicate codes belong in a review queue, not a zero-value calculation.
4. Retain source references
Record the source file, worksheet and row for every result. That makes a supplier discussion auditable and allows a reviewer to verify the comparison before catalogue prices are changed.
Try the complete workflow
PriceTern performs this comparison in your browser for CSV and XLSX files up to 10,000 products per list. The worked example is synthetic and requires no account.
Need someone to check the exceptions?
The assisted invoice-audit pilot compares one supplier invoice with one agreed price list or purchase order, then returns a human-checked exception set with source-row evidence. It is a fixed A$149 including GST for the published pilot scope, with no subscription. PriceTern confirms file suitability before requesting files or payment.
Review the assisted pilot scope
Also read: auditing supplier price and pack-size changes.