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.

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:

1. What can I still roast this week? Remaining weight beats a mental count of half-open bags.
2. What should I roast next? Origin, process, and altitude tell you which profile family to open first.
3. 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.

The 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.

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 pack or NCT 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

The 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.

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