Supplier Price Tracker for Spirits & Ingredients
What it is
A practical supplier price tracker for bar purchasing. Log pack prices by supplier and date, auto calculate comparable unit costs, and get clear variance and impact flags so costing and purchasing stay anchored to current supplier prices.
What it solves
Most venues notice price increases only after margin drops. Quotes and invoices are inconsistent, history is messy, and cost changes do not turn into decisions. This toolkit standardizes the data and surfaces what changed, how much, and what it affects. It helps surface price drift before it turns into silent margin loss, slow renegotiation, or outdated costing decisions.
Why teams use this tracker
-
Track supplier price history by item, supplier, and date
-
Auto calculate comparable unit costs from pack price and pack units
-
Flag increases and decreases with clearer variance thresholds
-
See which high value items need renegotiation or repricing first
-
Keep a cleaner supplier and item reference without digging through emails
Best for: beverage managers and operators who buy from multiple suppliers and want a simple weekly price control habit.
Not for: buyers looking for a fully custom procurement consulting service instead of a structured ready to use supplier price system.
Select a package
Compare the options below before choosing the right fit.
Packages and turnaround
Starter
(Instant download)
You receive the Supplier Price Tracker file (USD home currency). You add suppliers, build your item library, and log quotes. The file automatically converts currencies to USD, flags price changes, and shows Best Buy per item. Includes filled examples data you can clear quickly.
Best for teams that want the full tracker ready to use and prefer to manage their own supplier inputs internally.
Standard
(2 days delivery)
I configure the tracker for your venue and validate your setup. I set your FX rates, alert thresholds, and “Best Value” penalties (lead time and reliability). I also check your item units so supplier comparisons stay apples-to-apples.
Best for venues that want cleaner setup, aligned comparisons, and more reliable supplier benchmarking from the start.
Advanced
(4 days delivery)
Full done-for-you service. You send your supplier list, your items, and your latest quotes or price lists. I populate the tracker, normalize units, validate comparisons, and deliver a ready-to-use purchasing system with Best Buy, tier pricing where relevant, and a clean dashboard view. Advanced requires: supplier list (name, currency, lead time, reliability), item details (pack size, units per case, compare quantity), and quotes (case price, shipping, discounts, availability, dates). If you have CSV exports, you can send those.
Best for operators who want faster implementation, less data cleanup, and a more decision ready purchasing system.
What’s inside
-
Supplier Directory: contacts, currency, lead time, reliability, and scoring fields
-
Item Library: pack size, units per case, and a compare quantity that makes prices comparable
-
Quotes & Alerts: one row per quote with USD conversion, net case price, compare unit price, and alert flags
-
Compare tab (Best Buy): latest price by supplier, delta vs best, plus Best Tier Price at your order qty
-
Price Breaks: tier pricing and promos with validity dates and active status
-
Contracts & Terms: optional renewal reminders and commercial terms snapshot
-
Supplier Scorecard: optional performance scoring (on-time, fill rate, response, issues)
-
PO Log: optional order tracking to validate real supplier performance
-
Dashboard: read-only overview of key KPIs and most recent alerts
-
Settings: FX rates (USD home), alert thresholds, stale quote days, and value-penalty controls
-
EXAMPLE data included: clearly labeled “EXAMPLE” so you can delete and start clean
Each section is designed to make weekly quote review, supplier comparison, and purchasing decisions clearer and easier to repeat.
License & Support
This toolkit is licensed for internal use by a single user or business. It is designed to be practical, ready to use, and easy to adapt within your own operation, but it may not be resold, redistributed, shared outside your business, or repackaged for resale. If you need help with setup, formulas, or functionality, support is available for reasonable usage-related questions. Any genuine technical issue will be reviewed and corrected where applicable.
Delivery format
This toolkit is delivered as a single ZIP download. Inside the ZIP you will find:
• Excel master workbook (.xlsx)
• Google Sheets import file (.xlsx)
• README import checklist (step by step)
• PDF User Guide (Quick Start + workflow notes)
After purchase, you receive a clear ZIP download with the workbook, import file, and guide, so setup feels straightforward from the start.