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.
| Column | Example |
|---|---|
| Your item name | Chicken thighs, boneless |
| Supplier and item code | Broadline supplier, code on the invoice |
| Pack size | 4 × 10 lb (40 lb case) |
| Comparison unit | Per pound |
| Last price per unit | $2.40 per lb |
| Contract or quoted price | $2.35 per lb, from the current agreement |
| Recipes that use it | Thigh 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:
| Invoice line | Pack | Billed | Comparable cost |
|---|---|---|---|
| Yellow onions | 50 lb sack | $32.00 | $0.64 per lb |
| Crushed tomatoes | 6 × #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 weight | 41.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
- StartBroadline delivery at 9:20 AM; the signed invoice is photographed at the back door
- StepEach line read: item code, description, pack size, quantity, price and extension
- DecisionItem and pack size already in the price book?NoA personChef maps it: same item in a new pack, a substitution, or something newYes
- StepConverted to cost per pound, per can or per each
- DecisionAbove the last or contract price by more than your threshold?YesA personOwner or chef decides: accept it, call the rep or switch suppliersNo
- StepPlate cost recalculated for every recipe that uses the item
- DoneWeekly report: what moved, which dishes it touched, which credits are still owed
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.
| Category | Alert when | Who hears about it |
|---|---|---|
| Proteins | Up 3% on last price, or anything over contract | Chef and owner, same day |
| Produce | Up 10% on last week, or over this week's quote | Chef, in the weekly report |
| Dairy and dry goods | Up 5% on last price, or over contract | Weekly report |
| New item, pack change or substitution | Always | Chef, before it's mapped |
| Fees and surcharges | Any new fee, or a change in an existing one | Owner |
Before and after
Supplier invoices, before and after
Invoices in a folder
- 01Driver's copy signed and dropped in a folder
- 02Only the total is keyed for accounts payable
- 03Recipe costs updated once or twice a year
- 04Shorts mentioned to the driver; credits rarely chased
ResultFood cost rises, and nobody can say why
Line-by-line tracking
- 01Every line read and matched to the price book
- 02Prices converted to a common unit automatically
- 03Increases over threshold flagged the same day
- 04Plate costs refreshed whenever an ingredient moves
- 05Open credits listed until they show up on a statement
ResultYou see creep within days, dish by dish
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
- 01Open the report and sort increases by dollar impact: the price change times what you buy in a week.
- 02Look at dishes whose margin fell below your target.
- 03Check open credits, and call about anything older than two deliveries.
- 04Decide for each big mover: accept it, call the rep, change the spec, try another supplier or reprice the dish.
- 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
- Supplier invoice
- Item, pack size, quantity, price
- Price book database
- 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.