Restaurant Vendor Price List: Track Supplier Prices US 2026

The short version. A vendor price list — what the French call a "mercuriale" in professional kitchens — is the master list of every ingredient with its current supplier price and the date it was last confirmed. It is the foundation of your food cost calculation. If it is stale, you are flying blind. Here is how to keep it current without spending your Sundays on it.

What a vendor price list is and why it matters

Your restaurant vendor price list is a management tool that tracks every raw ingredient you purchase, with the current unit price from your supplier, the date last confirmed, and the unit of measure. It is the reference point for calculating the real cost of every recipe on your menu.

Most operators have something that functions as a vendor price list. The problem is it is not current. Prices move every month — sometimes every week on fresh proteins, produce, and eggs. A static price list is an illusion of control.

You think you are running 29% food cost. You are actually at 33%. You will not see the gap until your accountant sends back the quarterly numbers — by which time you have been operating at the wrong margin for three months.

What a complete vendor price list contains

Six columns minimum. If you use multiple suppliers for the same item, add a line per supplier and track which one is cheaper this week.

Contract pricing, spot pricing, and quarterly reviews

US food distribution has pricing structures that are different from other markets — and that create specific blind spots on food cost.

Contract pricing

When you have a standing relationship with Sysco or US Foods, most of your regular items are on contract pricing — a negotiated rate that holds for a quarter or until your next pricing review. Contract pricing gives you predictability on your high-volume items.

The risk: you may not know exactly when your contract prices roll over. If your rep quietly adjusts a contract price at a quarterly review and you do not update your vendor price list, your food cost math is wrong until someone notices.

Spot pricing

Items outside your contract are priced at market rate on the day of the order. This includes seasonal produce, specialty items, and anything your rep marks as "market price." If you are ordering spot items regularly — because your contract does not cover them — those prices fluctuate with the market and are never what you estimated.

Quarterly reviews

Most broadliner contracts include a pricing review every quarter. This is your opportunity to negotiate, but only if you walk into that conversation knowing what your current prices are and where they have drifted. A current vendor price list is your preparation for that meeting.

How to keep your price list current without burning hours

The right update frequency is every invoice received. Not monthly. Not quarterly. Every delivery.

In practice:

1. You receive the Sysco or US Foods invoice — PDF email or paper at the dock
2. You check which items have price changes — typically 2-8 lines per invoice
3. You update your price list — 5 minutes if structured, 30 minutes if in Excel with 150 SKUs
4. Your price list cascades to your recipe cards — automatic in software, manual otherwise
5. Your food cost recalculates — real-time or at your next review

The Excel version of steps 4 and 5 adds 20-40 minutes per update. For a restaurant receiving three to five supplier invoices a week, that is unsustainable.

Invoice OCR for US distributor invoice formats

US broadliner invoices — Sysco, US Foods, Gordon Food Service, Performance Food Group — have fairly consistent PDF formats. Invoice OCR (optical character recognition) can extract item names, quantities, and prices from a PDF invoice and push them directly into your vendor price list, flagging items where the price has changed.

The workflow: the invoice arrives by email as a PDF. You send it through the OCR tool. Items are matched to your price list. Changed prices are flagged for your review. You approve or reject. The cascade runs automatically to your recipe cards.

Result: a delivery of 25 invoice line items takes about 90 seconds to reconcile instead of 20 minutes.

Case study — La Verrerie, 2016

In 2016, at La Verrerie in Gaillac, I kept my vendor price list in Excel. I updated it every two or three months — already better than most operators, who had nothing at all.

At year-end, I reconciled actual purchase prices against what I had in the file. T55 flour had gone up 18% over the year. Not in one jump — in several 4-6% hikes that I had signed on delivery notes without ever transferring into the spreadsheet.

The math across every preparation using that flour — pastries, breads, stuffings — was roughly $2,000 of un-passed-on cost drift over 12 months. Nothing had flagged. No alarm. Just silent erosion.

Since then I understand that the problem is not discipline. Nobody can manually check 150 SKUs against every invoice that comes in. The problem is the tool. If your tool does not automatically detect the price change when the invoice arrives, you are exposed to that leak every month.

Vendor price list in a spreadsheet vs dedicated software

The rule: spreadsheets work up to about 25-30 SKUs. A casual dining operation with 30 menu items using 5-8 ingredients per dish is already past that. At that point, the time spent maintaining and propagating changes manually exceeds the tool cost by a significant margin.

On $600,000 of annual food revenue, recovering 2 points of food cost is $12,000 a year. Recovering 4 points is $24,000. That is not a promise — it is the order of magnitude of what a stale vendor price list costs a mid-sized operation.

Common mistakes

• No unit of measure specificity. If your price list says "flour" without specifying whether that is per pound, per 25 lb bag, or per 50 lb bag, every recipe calculation using it is wrong.

• Organizing by supplier instead of by ingredient. You want to know what ground beef costs you today — not what Sysco costs you. Restructure by ingredient reference, not by vendor.

• No price history. Without keeping old prices, you cannot see trends. An ingredient rising 3% per quarter is 12% in a year. Visible only if you tracked the prior quarters.

• Ignoring secondary ingredients. Oils, spices, dry goods — small per unit, easy to skip. Across 12 months and hundreds of recipe cards, they move your food cost more than you expect.

Conclusion

A vendor price list is a simple tool. But simple does not mean easy to maintain.

Three things to keep:

1. A stale price list is a fictional food cost. You are making decisions — menu pricing, supplier negotiations, quarterly reviews — on numbers that are wrong. Everything downstream is off.

2. Spreadsheets cap at 25-30 SKUs. Beyond that, the maintenance time and error rate make the file counter-productive. The tool becomes the problem.

3. Automatic price cascade is the real lever. It is not just knowing that butter went up 8%. It is that the information immediately recalculates every dish using butter, and you see the real-time impact on your margins. That is what lets you decide fast — adjust the menu price, substitute the ingredient, or absorb it knowingly.

On $600K of annual food revenue, 2-4 points of food cost recovered is between $12,000 and $24,000 a year. Not from magic — from a vendor price list that is current and a cascade that does the work for you.

Last updated 2026. Written by Cyril Quesnel, founder of Onrush. 20 years on the line in France, two restaurant turnarounds. Building food safety + food cost tools for US indie restaurants.