Vendor price book + weekly invoice audit

Vendor price book

One row per item. Start with your 20 most-ordered items from the last two weeks of invoices.

The 10 minute weekly invoice audit

Same time every week. Ten minutes, ten steps, one checkbox each.

1. 1. Pull this week's invoices into one stack, paper or PDF.
2. 2. Check each invoice's totals: quantity times unit price for the 5 biggest lines.
3. 3. Compare unit prices against your price book baseline for your top 10 items.
4. 4. Flag anything up more than 5 percent with no notice from the vendor.
5. 5. Check you were not charged for credits, returns, or shorted deliveries.
6. 6. Log new prices in the price book and date the entry.
7. 7. Call or email the vendor about every flag. Ask for the old price or a credit.
8. 8. Note the outcome in the price book so next week's call has receipts.
9. 9. Move any repeat offender's items out for a quote from a second vendor.
10. 10. Total the flags you caught. That number is your raise this week.

From smoothopsapp.com/free-tools/price-book-template. Smooth Ops keeps this book automatically from your invoices. 30 days free, no credit card