Free Green Coffee Inventory Template
Use one row per lot and one consistent weight unit. Download the printable worksheet below, or use these fields as the starting point for your own spreadsheet. No email required.
Download Printable Inventory Worksheet
Updated
Record the purchase
Include purchase date, supplier, coffee name, origin, lot code, received weight in pounds, and landed cost per pound. Allocate freight consistently. Keep separate deliveries as separate lots even when the coffee name is the same.
Update each lot after roasting
Record cumulative green pounds used in roasts and other removals such as samples or spills. Expected remaining pounds = received pounds - green pounds roasted - other removals. Never subtract finished roasted weight from green inventory.
Reconcile physical stock
Record the count date and measured pounds on hand. Count variance = physical pounds - expected remaining pounds. Investigate differences before adjusting your record. Inventory value for this operational worksheet = remaining green pounds multiplied by landed cost per pound.
A worked lot example
Receive 100 lb at $5 landed cost per pound, roast 10 lb, and remove 0.5 lb for samples. Expected remaining inventory is 89.5 lb, valued at $447.50. A physical count of 89 lb produces a -0.5 lb variance. These are illustrative figures.
Move from a worksheet to connected records
When updating purchases, inventory, and roast records separately becomes difficult, try the same lot in RoastBase. Enter the purchase and record your next batch to connect inventory with yield and finished-product costs. The 30-day trial is free; the regular price is $29 per month with no per-pound fees.