Coffee Shop Invoice Template

Setup takes about 20 minutes. Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins required. Start with the Products & Rates sheet: enter your wholesale bean varieties with per-lb prices, any catering packages, equipment rental rates, and delivery fees. Then populate the Client Accounts sheet with your active wholesale buyers and office service accounts. Once those two reference tables are in place, creating any invoice is a matter of selecting from dropdowns rather than typing from scratch — client details and product prices fill in automatically.

To create an invoice, go to the Invoice sheet, enter the invoice number and order date, and select the client from the dropdown. In the line items section, pick each product from the Products & Rates dropdown, enter the quantity or weight ordered, and the unit and price fill in automatically. If the client has a standard delivery fee, add that as a flat line item. Enter any prepayment already received and the balance due updates immediately. Print or export to PDF to send — the layout is formatted cleanly for email or printing.

After sending, log the invoice in the Invoice Log and set the status to Outstanding. Update to Paid when payment clears. For standing office service accounts, use the Recurring Orders sheet to track which clients are due for invoicing each week or month — the sheet flags accounts whose invoice date has passed without a corresponding entry in the Invoice Log. A 15-minute weekly check of the Invoice Log and Recurring Orders sheet keeps your receivables current and catches any account that slipped through the billing cycle.

Most coffee shops think of invoicing as something restaurants do, not cafes. But any shop that sells wholesale beans to restaurants, delivers weekly to office accounts, or caters corporate meetings is running a B2B revenue stream that needs a proper invoicing system. The problem is that generic invoice templates are built for service businesses billing by the hour. They have no concept of per-lb pricing, recurring weekly orders, or the difference between a wholesale account on Net 30 and an office service client who prepays monthly. The result is that most coffee shop operators invoice these accounts from memory or a Word document, which means inconsistent pricing, missed billing cycles, and receivables that go untracked for weeks.

Coffee shop invoicing has a few moving parts that don't apply to typical service businesses. Wholesale pricing is usually tiered — your per-lb rate for a restaurant buying 20 lbs a week is different from a direct consumer buying a 1-lb bag, and those negotiated rates need to be stored somewhere they won't get confused. Green coffee prices fluctuate, which means your roasted bean costs change seasonally and your invoice pricing needs to reflect current rates rather than prices you set a year ago. And for office coffee service accounts, the billing cycle is the critical piece — a client on a 10-lb weekly subscription who doesn't get invoiced for a month is effectively getting free coffee while you carry the inventory cost.

The operational workflow for coffee shop B2B invoicing is straightforward once the reference tables are in place. Set up your products and client accounts once, then create invoices from dropdowns in 5 minutes per client. Log each invoice in the Invoice Log as you send it, and use the Recurring Orders sheet to make sure standing accounts get invoiced on schedule. Check the Invoice Log weekly to catch anything past due — most small wholesale accounts will pay within a few days of a polite follow-up, but only if someone is actually watching the list. For shops with 10+ active B2B accounts, having a structured system versus an ad-hoc process typically recovers the cost of this template in the first missed invoice it catches.