Green Coffee Inventory Tracker: Free Spreadsheet Template
Know what green coffee you have left, where it came from, and what to roast next. Free spreadsheet template with a worked example — plus when to skip the sheet entirely.
Green Coffee Inventory Tracker (Free Spreadsheet) — Plus a Better Way
If you home-roast, green coffee piles up fast: sample bags, bulk kilos, a natural you loved and a washed you haven't opened. Without an inventory list you either overbuy, roast the wrong bag first, or forget which lot was the berry-forward one. This guide gives you a free green coffee inventory tracker — CSV and printable PDF — with the twelve fields that actually matter, a worked example, and an honest path out of the spreadsheet when you want stock tied to roast batches.
Watch the short
Why Track Green Coffee Inventory?
Green beans are not like roasted bags on a grocery shelf. They sit for months, come from different suppliers with different data quality, and only become "what you drink" after you choose a profile and a charge weight. Inventory tracking answers three questions every session:
- What can I still roast this week? Remaining weight beats a mental count of half-open bags.
- What should I roast next? Origin, process, and altitude tell you which profile family to open first.
- What should I reorder? Supplier + name + notes close the loop when a lot runs out mid-bracket.
A short sheet turns "I think I have some Ethiopia left" into a decision you can trust.
How long will your green coffee last?
Enter what you have on the shelf and how often you roast.
- Lasts
- About 4 weeks
- Batches left
- 8
- Roasted each week
- ~204 g
That is inside six months, a comfortable window for green coffee stored cool, dry and sealed. Roasted weight assumes a 15% roast loss.
Track your green coffee stockThe Free Green Coffee Inventory Template
Download the template below, or copy the table into Google Sheets, Excel, Notion, or a notebook. Log each bag when it arrives; update Remaining (g) after every roast.
| Field | Example | Why it matters |
|---|---|---|
| Name | Ethiopia Guji Grade 1 | Human label you search and sort by |
| Origin | Ethiopia | Country drives profile family and expectations |
| Region | Guji | Narrows altitude/process norms for planning |
| Process | Natural | Biggest lever for heat/fan profile choice |
| Variety | Heirloom | Flavor potential and density clues |
| Altitude (m) | 1700-2200 | Density proxy; pairs with profile altitude packs |
| Grade | Grade 1 | Defect/sieve signal when comparing lots |
| Supplier | Green Bean Roasters | Reorder path and lot consistency |
| Weight (g) | 1000 | Starting bag size for stock math |
| Remaining (g) | 760 | What you can still roast this week |
| Target roast level | 2.0 / medium | Where you want this bean to land |
| Notes | Berry-forward; try F-NAT first | Cupping cues and first-pass profile ideas |
Remaining (g) is the column most people skip — and the one that stops surprise empty bags mid-session. After a 120 g charge, subtract 120 from remaining. Reconcile with a scale when the number gets fuzzy.
Download the template
- Spreadsheet (CSV) — open in Google Sheets, Excel, or Numbers (header row + worked example)
- Printable PDF — field reference plus blank rows for handwritten stock logs
Where Spreadsheets Break Down
A template like this is enough for a few bags and your first months of roasting. Past that, the cracks show:
- Stock drifts. Miss one roast or charge size and Remaining (g) lies to you until you reweigh everything.
- No link to batches. The sheet never knows which roast used which bag, so you cannot answer "what did I run on this Guji last month?"
- No profile context. Origin and altitude sit as text; they do not open a matching Kaffelogic profile or level for you.
- Nothing compounds. History never becomes a recommendation for the next roast or a reorder prompt when stock is low.
Mobile roast-control apps are useful at the machine; inventory and planning live better in a dedicated workspace. If you already log roasts in a coffee roast log template, green inventory is the other half of the loop — beans in, batches out.
The Better Way: Inventory Next to Your Roasts
BrewedLate Roasting keeps green coffee inventory alongside roast batches so supplier data, remaining stock, and profile planning stay in one place:
- Log each bag — origin, process, altitude, weight, and remaining stock
- Tie roasts to the green coffee they used, so history is searchable
- Plan the next session from what you still have, not from memory
- Demo mode works without signup if you want to try it with sample data first
See when your green coffee will run out
The tracker counts what is ready to drink, what is still resting and how long your green stock lasts, then draws the supply you will have day by day.
Forecast your own coffee supplyThe free CSV and PDF above work today with zero signup. The app is for when you want stock, roasts, and AI planning on the same page.
Track green stock next to your roasts
Log every bag of green coffee — origin, process, altitude, and remaining weight — then plan roasts from real inventory instead of a half-updated spreadsheet.
Related Reading
- Where to Buy Green Coffee Beans — suppliers, prices, and what to check before you order
- Coffee Roast Log Template (Free) — the batch-side companion to this inventory sheet
- Home Coffee Roasting: Beginner's Guide — equipment, green beans, and first roasts
- Home Coffee Roasting Hub — profiles, logging, software, and workflows in one place
Frequently Asked Questions
What should I track in a green coffee inventory?
How do I track remaining green coffee weight?
Is a spreadsheet good enough for green coffee inventory?
How long does green coffee stay good?
Should inventory include price and lot numbers?
Related Articles
How Long Do Green Coffee Beans Last? Storage Guide for Home Roasters
Green coffee keeps its quality for 6 to 12 months in a sealed bag in a cool, dark cupboard, and longer in hermetic liners or the freezer. Here is how to store it, how to tell it is ageing, and how to buy so you never roast a stale bag.
Home Coffee Roasting: Beginner's Guide
Learn how to roast coffee at home with this complete beginner's guide. Covering equipment, green beans, roast levels, and your first roast walkthrough.
Coffee Roast Log Template: Free + Better Tracking
A roast log is how you turn one good roast into a repeatable one. Here's a free template with the fields that matter, a filled-in example, and an easier option for Kaffelogic owners.
Kaffelogic Nano 7 Profiles: Library & Download Guide
The complete guide to Kaffelogic Nano 7 roast profiles: what the families mean, the community's most-downloaded profiles, and how to choose the right one for your bean.