A roast log has one row for each roast: which green coffee and lot, the weight in, the charge temperature, the time of first crack, the time and temperature at the drop, and the weight out. Two numbers come from those. Roast loss is one minus the roasted weight over the green weight: 11.0 lb in and 9.35 lb out is a 15.0% loss. Development is the time after first crack as a share of the whole roast. Together they tell you whether today's roast matched last week's without tasting it. Below are the columns, four roasts with one that ran dark, and a file that works out both numbers.
The short version
- One row a roast, filled in at the roaster.
- Weigh green in and roasted out, every time.
- Roast loss = 1 − roasted weight ÷ green weight.
- Development = (drop time − first crack) ÷ drop time.
- Give roasted coffee a lot that leads back to its green lot.
- TaroStack records each roast as a batch, with the green lot it used and the weight it lost. More below.
What to record
| Column | Why |
|---|---|
| Date, roast number | Which roast |
| Coffee and green lot | Two lots of the same origin can roast differently |
| Green in | The start of the loss sum, and what comes off stock |
| Charge temperature | Where the roast began |
| First crack, drop time, drop temperature | The shape of the roast |
| Roasted out | The end of the loss sum, and what goes into bags |
| Roast level, roasted lot | What's on the bag |
| Notes | Anything that wasn't the plan |
Four roasts
A made-up roastery with a 5 kg roaster. Times are minutes from the charge.
| Roast | Coffee | Green lot | In | First crack | Drop | Drop temp | Development | Out | Loss | Check |
|---|---|---|---|---|---|---|---|---|---|---|
| R-1116-1 | Guatemala | G-2231 | 11.0 lb | 8.5 | 10.4 | 412°F | 18.3% | 9.35 lb | 15.0% | OK |
| R-1116-2 | Guatemala | G-2231 | 11.0 lb | 8.6 | 10.5 | 413°F | 18.1% | 9.33 lb | 15.2% | OK |
| R-1116-3 | Ethiopia, natural | G-2240 | 11.0 lb | 8.0 | 9.4 | 402°F | 14.9% | 9.57 lb | 13.0% | OK |
| R-1116-4 | Sumatra | G-2198 | 11.0 lb | 9.2 | 12.1 | 432°F | 24.0% | 8.91 lb | 19.0% | CHECK |
Reading it
The two Guatemala roasts match. 15.0% and 15.2% loss, development within a fifth of a point. That's what a repeatable roast looks like on paper, and it's why they can share one roasted lot, GT-1116.
The Sumatra ran dark. This roastery expects losses between 12% and 18%. At 19.0%, with development at 24%, the sheet says CHECK, and the note says why: dropped 20 seconds late. Whether that coffee goes into the usual bag is a decision, and the log makes sure it's made on purpose.
Loss is money. Most of what's lost is water. Eleven pounds of green at $6.00 a pound is $66.00, whichever way it roasts. At 15% loss that's $7.06 a pound roasted, and at 19% it's $7.41. The sum is worked through in roast loss and cost per bag.
Lots: green in, roasted out
The green lot is the supplier's, or yours from the day the sacks arrived. The roasted lot is yours, and it's what goes on the bag with the roast date. Keep the link between them on the row. If a green lot turns out to have a defect, the log lists every roasted lot made from it, and the bags lead to the customers.
A simple roasted lot is the coffee's code and the roast date: GT-1116. More on codes in how to create lot numbers. How long roasted coffee keeps is in coffee beans shelf life.
Get the log
Download the coffee roast log. One row a roast; development and loss work themselves out, and the loss check says CHECK outside the range you set on the Limits sheet. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. For green and roasted stock, see coffee roaster inventory spreadsheet.
Where this stops working
The log has the roasts. The green stock is on another sheet, and the bags on a third. After 40 roasts in a week, does the green sheet still agree with the sacks? Which bags on the shelf were roasted more than three weeks ago? The log can't say, because it only knows what happened at the roaster.
How TaroStack does it
TaroStack treats a roast as a batch: green coffee in, roasted coffee out.
Recording the roast moves the stock. The green comes off the lot you used and the roasted goes on under its own lot code, in one step. The batch record notes the green lot automatically.
The loss is kept. Each batch records what went in and what came out. Recipe truth, from your own batches, shows whether a coffee really loses what its recipe says.
Your own fields. Charge temperature, first crack, drop time and drop temperature go on the batch-record form.
Roast dates on every lot. Bagged coffee carries its date, the oldest sells first, and an alert flags lots getting old.
Cost follows the green. Each roast is costed from the green lot it used, loss included.
| The job | Roast log and two more sheets | In TaroStack |
|---|---|---|
| Green used | Subtract by hand | Comes off the lot with the roast |
| Roast loss over time | Scroll and compare | Recipe truth |
| Which green lot is in this bag | Look it up | On the batch record |
| Bags getting old | Read the dates | An alert |
Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
