Skip to content

Track Supplier Price Changes Before Price Creep Eats Your Food Cost

By USA AI Corp · · 6 min read

The short answer

To track supplier price changes at a restaurant, record every invoice line, convert each item to one comparable unit such as cost per pound or per each, and compare it with both the last price you paid and any contract or quoted price. Flag changes above thresholds you set, update the plate cost of every dish that uses the item, and check deliveries for shorts and substitutions so the credits actually arrive.

Picture a 90-seat bistro. In March, the chef costed the braised short rib at a comfortable margin. By June, the owner can see food cost creeping up on the P&L but can't say why, and the short rib is still the most popular thing on the menu.

The answer is sitting in a folder of signed delivery invoices. The short rib price rose a little most weeks. One week a substitution arrived in a smaller pack at a higher price per pound.

And a short case of shallots, noted to the driver at the back door, was never credited. No single invoice looked wrong. The pattern only shows up line by line, over time.

Why price creep hides in plain sight

  • Invoices show case prices, and pack sizes change without warning.
  • Proteins are often billed by catch weight, so the total changes even when the price per pound doesn't, and the reverse.
  • Substitutions arrive under a different item code, so nothing looks like an increase.
  • Fuel surcharges and delivery fees sit outside the item lines.
  • The person who signs for deliveries isn't the person who costs the menu, and the invoice goes to accounts payable, where only the total gets entered.

Step 1: Build a price book

A price book is one row per item you buy, in your own words, tied to each supplier's item code. It's the reference every invoice line is checked against. A spreadsheet is fine to start.

Price book columns, with one hypothetical row
ColumnExample
Your item nameChicken thighs, boneless
Supplier and item codeBroadline supplier, code on the invoice
Pack size4 × 10 lb (40 lb case)
Comparison unitPer pound
Last price per unit$2.40 per lb
Contract or quoted price$2.35 per lb, from the current agreement
Recipes that use itThigh skewers, staff meal, chicken salad

Don't try to load every item on day one. Start with the thirty or forty items you spend the most on, usually proteins, dairy, fryer oil and a handful of produce. A month of invoices will show you which they are. Everything else can be added as it turns up on an invoice.

Before you photograph a single invoice, ask each distributor's rep what electronic data they can give you: order history, price exports or invoices in a spreadsheet format through their ordering portal. Clean line data beats a photo of a crumpled page, and it may already come with your account. Keep photos for the suppliers who only hand you paper.

Step 2: Convert everything to one unit

Comparing case prices is how creep gets past you. Convert every line to the unit your recipes use, and the substitutions and pack changes stand out at once. These worked examples use made-up prices:

Converting invoice lines to a comparable unit (hypothetical prices)
Invoice linePackBilledComparable cost
Yellow onions50 lb sack$32.00$0.64 per lb
Crushed tomatoes6 × #10 cans$39.00$6.50 per can
Chicken thighs (usual)4 × 10 lb$96.00$2.40 per lb
Chicken thighs (substitution)4 × 5 lb$54.00$2.70 per lb: cheaper case, dearer pound
Short rib, catch weight41.2 lb shipped$405.82$9.85 per lb; check the weight against your scale

Flowchart

One invoice line, from the back door to plate cost

  1. StartBroadline delivery at 9:20 AM; the signed invoice is photographed at the back door
  2. StepEach line read: item code, description, pack size, quantity, price and extension
  3. DecisionItem and pack size already in the price book?
    No
    A personChef maps it: same item in a new pack, a substitution, or something new
    Yes
  4. StepConverted to cost per pound, per can or per each
  5. DecisionAbove the last or contract price by more than your threshold?
    Yes
    A personOwner or chef decides: accept it, call the rep or switch suppliers
    No
  6. StepPlate cost recalculated for every recipe that uses the item
  7. DoneWeekly report: what moved, which dishes it touched, which credits are still owed
Known items flow through automatically; new pack sizes and real increases go to the people who decide.

Step 3: Compare against two prices, not one

The last price you paid tells you about creep. The contract or quoted price tells you whether you're getting the deal you agreed to, whether that's a cost-plus arrangement, a locked price on key proteins or this week's produce quote. Check every line against both.

If you buy on a cost-plus arrangement, the invoice may show only your price, not the distributor's cost. Ask your rep what documentation they'll provide so you can check the markup, and keep it with the price book.

Then set thresholds so you hear about what matters and nothing else. The numbers below are starting points to adjust, not rules.

Sample alert thresholds by category
CategoryAlert whenWho hears about it
ProteinsUp 3% on last price, or anything over contractChef and owner, same day
ProduceUp 10% on last week, or over this week's quoteChef, in the weekly report
Dairy and dry goodsUp 5% on last price, or over contractWeekly report
New item, pack change or substitutionAlwaysChef, before it's mapped
Fees and surchargesAny new fee, or a change in an existing oneOwner

Before and after

Supplier invoices, before and after

Invoices in a folder

  1. 01Driver's copy signed and dropped in a folder
  2. 02Only the total is keyed for accounts payable
  3. 03Recipe costs updated once or twice a year
  4. 04Shorts mentioned to the driver; credits rarely chased

ResultFood cost rises, and nobody can say why

Line-by-line tracking

  1. 01Every line read and matched to the price book
  2. 02Prices converted to a common unit automatically
  3. 03Increases over threshold flagged the same day
  4. 04Plate costs refreshed whenever an ingredient moves
  5. 05Open credits listed until they show up on a statement

ResultYou see creep within days, dish by dish

Line-level tracking turns a vague rise in food cost into specific items and specific dishes.

What a price change does to a plate

Plate cost is simply each ingredient's quantity times its unit cost, added up. Take the thigh skewers: six ounces of chicken is 0.375 lb.

At $2.40 per lb, that's $0.90 a plate. After the substitution at $2.70 per lb, it's about $1.01. Eleven cents looks trivial until you multiply it by every plate you sell in a month, which is exactly what the weekly report should do for you.

Shorts, substitutions and the credits you're owed

Price tracking only works if the invoice reflects what actually arrived. At the back door, count cases and weigh catch-weight items, write shorts and substitutions on the driver's copy, and photograph the signed page. Each short becomes an open credit that stays on the weekly list until a credit memo or statement shows it.

Substitutions get two checks. The first is price per unit, as above. The second is ingredients: a different brand can contain different allergens, so any substitution on an item that matters for allergies goes to the chef, not just through the price check.

What software does, and what stays with the chef

Automation handles the tedious part: reading every line from a photo or PDF, converting units, comparing prices, updating recipe costs and keeping the credit list. Photos of crumpled invoices and handwritten notes from the driver are read too, but anything uncertain is shown to a person with the image beside it.

Mapping a new item or pack size, judging whether a substitute is acceptable, and deciding what to do about an increase stay with the chef and owner. The system tells you what moved and what it costs you. What to do about it is a kitchen decision.

There are three ways to run all this. A spreadsheet price book, updated from invoices, costs nothing but staff time each week. Restaurant back-office or inventory software that captures invoice lines and tracks recipe costs means a subscription plus the time to map your items and recipes. A custom setup makes sense when your suppliers, units or recipes don't fit what the off-the-shelf tools expect.

A 15-minute weekly review

  1. 01Open the report and sort increases by dollar impact: the price change times what you buy in a week.
  2. 02Look at dishes whose margin fell below your target.
  3. 03Check open credits, and call about anything older than two deliveries.
  4. 04Decide for each big mover: accept it, call the rep, change the spec, try another supplier or reprice the dish.
  5. 05Note the decision in the price book, so next week's alert has context.

For context on whether an increase is market-wide or just your supplier, the USDA Economic Research Service publishes a Food Price Outlook with forecasts by food category, updated regularly. It won't tell you what your rep should charge, but it helps you tell the difference between a market and a margin problem.

The same invoices also need to be paid correctly; our guide to automating invoice processing covers matching and approvals. For how this fits with calls, catering and reviews, see our page for restaurants.

Doing this with Document Processing Factory

  1. Supplier invoice
  2. Item, pack size, quantity, price
  3. Price book database
  4. Weekly review

Building the price book means reading every supplier invoice line by line. Document Processing Factory can do that reading: train it on your suppliers' invoices, extract item, pack size, quantity and price, and save the lines to a database your weekly review can query.

Book a call and bring a week of supplier invoices.

Sources

Common questions

Quick answers.

How do restaurants track supplier price changes?

Keep a price book of every item you buy, record each invoice line against it, convert to a common unit like cost per pound, and compare with your last price and any contract price. Flag increases above a threshold and update the plate costs that use the item.

What does catch weight mean on a restaurant invoice?

It means the item is billed by the actual weight shipped rather than a fixed case weight. The price per pound is set, but the total changes with each delivery, so weigh catch-weight items at receiving and compare with the billed weight.

How often should I update recipe costs?

Ideally whenever an ingredient's price moves past your threshold, which automated tracking makes practical. If you're doing it by hand, update your highest-volume dishes and their main proteins at least monthly.

What should I do when a supplier raises prices?

Check it against your contract or quote first, then the market context. Then decide: ask the rep for an explanation, change the spec or pack size, get a competing quote, adjust the portion or reprice the dish. Record the decision so the next alert has context.

Put it to work

AI document processing

AI document processing: invoices, forms, contracts and email attachments read, checked and filed, with the key details pulled into your systems for review.

See how it works

Most relevant for restaurants.

Keep reading

Ready when the work is.

Show us what is slowing your business down.

Book a call

Not ready to talk?

Written brief

Skip the call.
Send a brief.

A few sentences is plenty. We read every brief and reply by email within one business day.

Try it free. If you love it, keep it. If it's not for you, we take it back, no questions asked.

We only use this to reply to you. Privacy policy