Bank Statement to QuickBooks for Coffee Roasters: Convert PDF Statements to QBO

Raw green beans bought from an importer are a capitalized inventory asset, not a cost you expense the day the payment clears. Roasting is manufacturing: green becomes finished roasted goods, and the accumulated cost only hits cost of goods sold when the bag actually sells. So a large green coffee wire is inventory on the balance sheet, not a cost of the month it left your account.

Green is usually bought on purchase orders, either spot lots ready to ship or forward booking contracts against future delivery, and the timing rarely lines up with your sales. Booking a five-figure green wire to a COGS or supplies account the moment it clears understates inventory and wrecks your margin for that month. Import the full transaction first with the PDF to QBO converter, then code it to inventory.

Green coffee loses roughly 15% to 18% of its weight to moisture during the roast, so a finished pound of roasted coffee costs more than a pound of green. That yield loss is approximate and varies by bean, moisture, and roast level, so set the exact factor from your own roast logs rather than a rule of thumb.

Your COGS and inventory costing need to reflect that shrinkage. If you value finished bags at the green cost per pound, you overstate inventory and understate COGS. Work the yield factor into your finished-goods cost with your roast records and your CPA so the numbers that flow out to COGS are the real cost of what you shipped.

A roaster runs three different sales engines through the same bank account, and the statement blends them. First, wholesale to cafes and grocers, sold on terms: recognize the revenue when the coffee ships and record an accounts receivable, then the payment that lands weeks later clears that open invoice. It is not new income; booking it as fresh revenue double counts the sale. Second, DTC ecommerce and subscriptions: a single online order is recognized at fulfillment, but a prepaid subscription (a 3-month or 6-month coffee plan, say) is deferred revenue that you recognize as each shipment goes out. Third, the retail cafe or tasting counter, which settles a daily card batch net of fees.

Each behaves differently on the statement, so treating all three as one lump of deposits is where roaster books usually break. The same logic that ties a distributor payment to an open invoice for restaurants applies to your wholesale accounts.

Shopify, Stripe, Square, and marketplace payouts do not arrive as your gross sales. They land net of processing and platform fees, so one deposit bundles several things. Split it: gross sales to income, the processing or platform cut to a merchant or platform fee expense, and any sales tax collected to a sales tax payable liability. Only the gross sales are revenue.

Sales tax treatment differs by channel. Wholesale sales to a reseller are usually exempt when the cafe or grocer gives you a resale certificate, while retail and most DTC sales are taxable. The rules and nexus thresholds are state-specific, so confirm what you owe and where with your CPA rather than assuming one rate covers everything.

Bags, one-way valves, labels, and shipping boxes are either inventory or a packaging cost of goods sold line, not a lump office-supplies expense. If you buy them to pack product you sell, they belong close to the product they wrap, not in general overhead. The same goes for freight-in on green coffee: the cost to get green beans to your roastery is part of the landed cost of that inventory, not a standalone shipping expense.

A roaster, grinder, or packaging line bought on a loan or equipment finance agreement is a capitalized fixed asset that you depreciate over its useful life, not a cost you expense in full when you buy it. When you finance it, each monthly payment splits into two parts: the principal portion reduces the loan liability on your balance sheet, and only the interest portion is an expense. Posting the whole payment to one expense account overstates costs and hides the real debt you still owe.

Part-time baggers, farmers-market and event help, and delivery drivers are often paid as 1099 contractors rather than employees. The 1099-NEC reporting threshold is $2,000 for payments made on or after January 1, 2026, and it is indexed for inflation after that. Worker classification and the threshold both have gray areas, so confirm how you are paying people and what you need to file with a CPA before year end.

How do I record green coffee inventory in QuickBooks?

Record a green coffee purchase to an inventory asset account, not an expense, when the wire or ACH clears. The beans stay in inventory as you roast and until the finished bag sells, at which point the cost flows to COGS. Because green is often bought on forward contracts, the payment and the eventual sale usually fall in different months, so capitalize it.

How do I account for roast loss in QuickBooks COGS?

Build the yield loss into your finished-goods cost so COGS reflects the real cost per roasted pound. Green loses roughly 15% to 18% of its weight to moisture in the roast, which is approximate, so set your exact factor from roast logs. A finished pound costs more than a green pound; if you cost bags at the green rate, you overstate inventory and understate COGS.

How do I record wholesale coffee sales in QuickBooks?

Recognize wholesale revenue when the coffee ships and record an accounts receivable for what the cafe or grocer owes. When their payment lands weeks later, apply it against that open invoice rather than booking it as new income, which would double count the sale. Wholesale to a reseller with a resale certificate is usually sales-tax exempt, but confirm state rules with your CPA.

How do I handle a coffee subscription in QuickBooks?

Treat a prepaid subscription as deferred revenue. When a member is charged for a 3-month or 6-month plan before shipments go out, record the amount to a deferred revenue liability, because you have been paid for coffee you have not delivered. As each shipment ships, move that portion out of deferred revenue and recognize it as sales income for that period.

Do I charge sales tax on wholesale coffee?

Usually no, if the buyer is a reseller who gives you a valid resale certificate, because the tax is collected further down the chain. Retail counter sales and most DTC orders are taxable. The specifics, including nexus and which items are taxable, are state-specific and change, so keep resale certificates on file and confirm your obligations with a CPA.

How do I import a bank statement into QuickBooks?