A wholesale coffee price list template, and how to price a kilo
A wholesale price list is a small document that decides most of a roastery's margin. This page gives you a template to copy, the terms that belong under it, and the arithmetic for pricing a kilo from what the green actually cost.
Published 15 September 2026
Short answer. A good wholesale coffee price list has one line per coffee and bag size, prices without VAT, a price per kilo so cafés can compare sizes, at most one volume break, a date the prices hold until, and the terms underneath: minimum order, delivery days, cutoff, delivery charge and payment terms. Download the CSV template.
The template
Copy this into a spreadsheet, or download the CSV, which opens in Excel, Numbers and Google Sheets. The prices are an example worked out with the calculator further down. Replace them with your own.
| Coffee | Origin, process | Size | Price ex VAT | Per kg | From 10 kg | RRP |
|---|---|---|---|---|---|---|
| House espresso | Brazil and Colombia, natural and washed | 1 kg | €18.20 | €18.20 | €17.30 | |
| Seasonal single origin | Ethiopia, washed. Until 31 December | 1 kg | €24.50 | €24.50 | €22.90 | |
| Decaf | Colombia, sugarcane decaf | 1 kg | €21.00 | €21.00 | ||
| House espresso | Retail bag for the café shelf | 250 g | €5.40 | €21.60 | €8.50 | |
| Seasonal single origin | Retail bag for the café shelf | 250 g | €6.90 | €27.60 | €11.00 |
What each column is for
- Coffee, origin and process
- Name it the way the café will ask for it on the phone. Origin and process go in a separate column so a head barista can scan for what they want without reading tasting notes.
- Price ex VAT
- Always without VAT, and say so at the top. Trade buyers reclaim VAT and compare net prices; a list that mixes the two gets you a phone call asking which it is.
- Per kg
- The number a café actually compares, between your sizes and against the roastery down the road. Showing it yourself stops a 250 g bag looking cheap next to a kilo.
- From 10 kg
- One volume break, on the coffees where volume is real. More than two breaks and nobody can tell what they will pay; a break on the decaf rewards nobody.
- RRP
- Only on retail bags the café resells. It protects your own web shop price and tells the café its margin on the shelf.
- Available until
- Seasonal coffees end. Writing the date on the list saves the email where a café finds out on the day it orders.
The terms that go under the list
Most arguments with a wholesale account are about something that was never written down. Put these under the prices, on the same page:
- Prices valid until a date, and how much notice you give before a change. Thirty days is common and fair when green prices move.
- Minimum order, in kilos or euros, and whether it applies per delivery.
- Delivery days and cutoff. "Order by Monday 12:00 for Wednesday delivery" is a sentence that prevents a Tuesday-night WhatsApp.
- Delivery charge, and the order size above which delivery is free.
- Payment terms. Net 15 or Net 30 by bank transfer is normal in café wholesale. If you take cards, know what they cost you.
- Equipment, if you lend grinders or espresso machines: the minimum monthly volume that goes with the loan.
- Who to call for orders, and who for quality problems.
How to price a kilo
Start from what the coffee costs in the bag, not from what the roastery down the road charges. Four inputs:
- Green price per kilo, landed: including shipping and import costs.
- Roast loss. Water leaves the bean, so a kilo of green does not make a kilo of roasted. 15% is the middle of the usual range; weigh a few batches and use your own.
- Packaging per bag: bag, valve, label, and its share of the box.
- Labour per bag: roasting, packing and the time spent on the account.
Green in the bag = green price ÷ (1 − roast loss) × bag weight. Cost = green in the bag + packaging + labour. Price = cost ÷ (1 − target margin).
Worked example: green at €8.00 a kilo with 15% roast loss is €9.41 of green in every roasted kilo. Add €0.60 packaging and €0.90 labour and a 1 kg bag costs €10.91. At a 40% target gross margin the price is €10.91 ÷ 0.60 = €18.19, which is where the house espresso above comes from.
Round the result to a price you are happy to say out loud. Edit any field.
One list, or one per kind of client?
Most roasteries end up with two to four: cafés, restaurants, offices that order less and less often, and shops that resell retail bags. More lists than that and nobody remembers which café is on which. Special prices for your biggest accounts belong as exceptions on that account, not as another list.
Mistakes that cost margin
- Pricing once and never again. Green prices move. A price set on last year's green can be under cost this year while the price list still looks healthy.
- Discount codes instead of prices. A code on the retail store is a price anyone can find and share.
- A PDF sent once. Six months later half your cafés are ordering from an old one. Send the current list with every change, and date it.
- Breaks nobody reaches. A price for 50 kg an order that no café orders is a line that makes the list harder to read.
- No notice on a price change. A café that finds out from the invoice starts looking at other roasteries. That is how accounts go quiet.
Where Order Book fits
A price list in a spreadsheet works until the cafés are ordering from different versions of it. In Order Book the list is the catalog each café orders from: one template per kind of client, a different price for any single account, and volume breaks applied as the café fills the order. When green moves, you write the price change once with the date it starts, and every café affected is told its own new prices before that date. Each coffee can carry its green price and roast loss, so the cost per bag follows the green, and the insights page shows the margin you are actually making.
Start free for 30 days, no card, or read what it costs.