Coffee Shop P&L Template

Download the .xlsx file and open it in Excel or Google Sheets — no macros, no plugins, no setup beyond entering your numbers. Start with the Monthly P&L sheet and review the pre-loaded revenue and expense categories. Most coffee shops can go live with 80–90% of the line items unchanged; the most common adjustments are adding or removing revenue channels (wholesale, catering, merchandise) to match your specific model. The initial setup typically takes 15–20 minutes.

Once the structure looks right, enter your monthly revenue and expense figures. Pull revenue from your POS system's monthly sales report — most modern cafe POS platforms (Square, Toast, Lightspeed) can export a channel breakdown directly. For expenses, use your supplier invoices and bank statements. The Beverage Cost Analysis sheet is worth filling out separately: enter your coffee and dairy purchases by category and it will calculate beverage cost percentage automatically, broken down by ingredient type. This is where most cafe operators find the clearest picture of where margin is being lost.

Come back at the close of each month — it usually takes 20–30 minutes once you're in the habit. After a few months, the Annual P&L sheet becomes your most useful view: you can scan 12 months of cost percentages and spot the months where bean costs rose, labor crept up, or your wholesale revenue offset a slow retail period. Coffee shops that review their P&L monthly tend to catch margin problems — a wholesale account that isn't covering its costs, a milk price increase that hit beverage margins — well before they show up as a bad quarter.

Coffee shops operate with gross margins that look healthy on paper — typically 60–70% after beverage and food costs — but net margins are rarely better than 5–15% once labor, rent, and equipment are accounted for. Morning rush hours drive the majority of daily revenue in a window that's often 4 hours long, which means a slow Tuesday or a broken espresso machine can meaningfully change the month's outcome. Without a P&L to track these patterns, most cafe owners only discover margin problems at tax time, when the numbers are already history.

A coffee shop P&L has a different structure than most generic templates assume. Revenue needs to separate retail drink sales from wholesale bean sales and catering, because they have very different margin profiles and require different decisions. COGS should split beverage costs from food costs — and within beverage, espresso beans and specialty coffees should be tracked separately from dairy and alternative milks, since dairy is often the biggest variable in a cafe's COGS line and price increases hit quickly. Labor should distinguish barista hours from management, because they scale differently across the week and across seasons. When these categories are set up correctly, the P&L shows you not just whether the business is profitable, but which revenue streams and cost lines are driving the result.

The operational value of a coffee shop P&L comes from using it to make decisions, not just record history. Beverage cost percentage running above 30%? The P&L will show which category is driving it — whether it's bean costs from a new supplier, a milk alternative that's more expensive than it looks on the menu, or a drinks menu that doesn't account for actual pour costs. Labor percentage creeping above 35%? You can see whether it's the morning shift overstaffed relative to covers, or whether you're paying management hours on weekends that aren't earning their cost. This template is structured to surface those patterns monthly, so adjustments happen before they compound.