How to Track Green Coffee Inventory and Roasting COGS in QuickBooks

Short answer: Green coffee is an inventory asset in QuickBooks, not an expense, and it stays on your balance sheet until the roasted bag sells. Only then does its cost move into cost of goods sold (COGS). Because green coffee loses roughly 15% to 18% of its weight to moisture during roasting, the cost of a finished (roasted) pound is higher than the cost of a green pound, and your inventory costing has to account for that yield loss or your gross margin will read wrong.

Last updated July 2026.

If your books currently expense the whole green wire the month it clears, this guide walks through the cleaner path. You can also convert a coffee roaster bank statement to QuickBooks and split the green, freight, and packaging lines into inventory instead of a single lump expense.

Green coffee is inventory, not an expense

A large green purchase is not an operating cost the day the money leaves your account. When you wire or ACH an importer, or draw down against a forward booking contract, that cash converts into an asset you still own: green beans sitting in your warehouse. In accounting terms it capitalizes to inventory. It does not become an expense until you roast it, bag it, and sell it, at which point its cost lands in COGS and shows up against the revenue from that sale.

Booking the entire green wire as a cost of the month it clears distorts margin in both directions. The month you pay looks unprofitable because a big expense hit with no matching sales. The following months look artificially fat because you are selling coffee that appears to have cost you nothing. Matching the cost to the sale is the whole point of inventory accounting, and it is what lets you actually see whether your pricing works.

Roast loss and yield: why finished pounds cost more

Green coffee carries around 10% to 12% moisture when it goes into the roaster. Roasting drives most of that moisture off, along with some carbon dioxide and volatile compounds, so the beans come out lighter. The typical shrink is roughly 15% to 18% of the starting weight, though the exact figure depends on how dark you roast and the density and moisture of the lot. Treat 15% to 18% as an approximate industry range and set your own precise yield factor from your roast logs, because that is the only number that reflects your beans and your roast profiles.

The practical consequence: you buy by the green pound but you sell by the roasted pound, and roasted pounds are scarcer. Here is a simple worked example (illustrative round numbers, not a real supplier quote):

1. Green landed cost: $5.00 per green pound.
2. Roast loss: 16% (so yield is 84%, meaning 100 green pounds become 84 roasted pounds).
3. Finished cost per roasted pound: $5.00 divided by 0.84, which is about $5.95 per roasted pound.

So a bean that cost you five dollars green actually costs almost six dollars once it is roasted and ready to sell, before you add packaging. If you price off the green cost, you undercharge by roughly a dollar a pound on this example and never understand why the bank account feels tighter than the profit and loss suggests.

These figures are examples to show the math, not benchmark prices. Plug in your own landed cost and your own logged yield.

Freight-in and landed cost belong in inventory

The price on the importer's invoice is rarely your true per-pound cost. Inbound freight, import duties, customs and brokerage fees, and any other cost of getting the green into your warehouse are part of the cost of that inventory, not a separate operating expense. Accountants call the all-in number the landed cost, and it is the figure your per-pound costing should use.

If you book the beans to inventory at the invoice price and dump the ocean freight into a generic Freight expense, two things break. Your inventory value is understated, and your COGS is missing the freight that genuinely belongs to those beans. Capitalize the freight and duties into the inventory cost so the pound cost you carry is the landed cost. That said, exactly which incidental costs you capitalize can get nuanced, so confirm your treatment with a CPA.

Costing methods: average cost versus FIFO

Coffee arrives in lots, and lots almost never cost the same. A Colombia you booked in spring lands at one price; a Guatemala you buy on the spot market three months later lands at another. How you value what you sell depends on your costing method. Under average cost, QuickBooks blends your green into one running average cost per pound, which smooths out lot-to-lot swings. Under FIFO (first in, first out), the oldest lot's cost flows to COGS first, so your margins track the actual price history of your buying.

This is where lot tracking earns its keep. If you want to know the true margin on a single-origin offering, you need to tie its cost to the specific lot it came from, not a blended average across every coffee in the warehouse. Some roasters run item-level detail per lot for exactly this reason. There is no single correct answer here, and the method has tax and reporting implications, so pick your costing method with your CPA rather than defaulting to whatever the software opens on.

From green to finished goods

Roasting is a manufacturing process, and the cleanest mental model follows the beans through three stages: raw materials (green coffee), work in process (green committed to a roast batch), and finished goods (roasted, bagged coffee ready to sell). Green is bought on purchase orders or booking contracts, so many roasters formalize each buy the way any manufacturer would and issue a purchase order to their green coffee importer to lock quantity, price, and delivery before the beans ship.

Finished goods cost is more than roasted beans. Packaging is a real material cost: bags, one-way degassing valves, labels, tape, and boxes all attach to the finished product and should roll into the cost of the bag you sell, not sit in office supplies. If your accounting stops at the roasted bean, your COGS understates what each bag truly costs to put on the shelf.

How it all reconciles off the bank statement

Your bank and card statements are where all of this shows up as cash movement: green wires to importers, freight and customs charges, packaging orders, and wholesale or retail payouts that arrive net of processor fees. Those lines do not announce which ones are inventory and which are expense; they are just dollars in and out.

The practical approach is to import the full statement first, then split each line to the right account, rather than trying to cherry-pick transactions by hand. Bring in every transaction, then code the importer wire and freight to inventory, packaging to its material account, and the deposit gross with the processor fee broken out. That way inventory and COGS both stay clean and the account still reconciles to the penny. The same PDF to QBO converter handles this whether you run a wholesale roastery or a cafe, and if you also operate a coffee bar, the same discipline shows up in restaurant and cafe bookkeeping where food cost and merchant fees get split off the same deposits.

If you pay green importers or freelance help by check or transfer, note that the reportable 1099-NEC threshold is $2,000 for 2026, not the old $600 figure, and talk to your CPA about who actually needs a form.

Frequently asked questions

Is green coffee inventory or an expense in QuickBooks?

Green coffee is an inventory asset. When you buy it, the cost sits on your balance sheet as inventory, not on the profit and loss. It only becomes an expense (cost of goods sold) when the roasted, bagged coffee actually sells. Expensing the whole green purchase up front distorts your monthly margin.

How do I account for roast loss in COGS?

Roasting removes roughly 15% to 18% of the green weight, so fewer roasted pounds carry the same total cost. Divide your green landed cost per pound by your yield (for example, cost divided by 0.84 at 16% loss) to get the finished cost per roasted pound. Set your exact yield from your roast logs.

Should freight on green coffee be capitalized?

Generally yes. Inbound freight, duties, and import fees are costs of acquiring the inventory, so they belong in the inventory cost rather than a separate expense account. Your per-pound cost should be the landed cost, all in. Because the details can vary, confirm exactly what you capitalize with your CPA.

What costing method should a coffee roaster use?

Common choices are average cost, which blends all green into one running cost, and FIFO, which moves the oldest lot's cost to COGS first. FIFO with lot tracking gives cleaner single-origin margins when lots land at different prices. There are tax and reporting effects, so choose the method with your CPA.