Coffee Shop Income Statement Template

Start with the Monthly Income Statement sheet and review the pre-loaded categories. Most of the revenue and expense line items are ready to use — you'll likely want to rename or consolidate a few to match your specific setup, like separating cold brew from iced drinks, or adding a line for merchandise if you sell branded gear. Every cell is unlocked, so adjustments take a few minutes. Download the file and open it in Excel or Google Sheets — no macros or plugins required.

Enter last month's figures first before projecting forward. Pull your POS report for revenue by category and your bank statement for expenses — your rent, utility bills, payroll records, and supplier invoices will cover most of the cost side. Beverage cost is the trickiest to pin down accurately, so if you don't track it precisely, use your bean and dairy invoices as a proxy. Fill in one month completely before copying the structure forward. The Annual Summary and Dashboard sheets update automatically.

The income statement becomes most useful when you review it monthly alongside your actual operations. Beverage cost percentage is the metric to watch most closely — a 1–2% increase is easy to miss in raw dollars but shows up immediately as a ratio when your revenue is consistent. Labor is the second lever: compare it to your sales volume each month to catch scheduling drift. Most cafe owners who use the template monthly say the check-in takes under 30 minutes and makes quarterly reviews with their accountant much more productive.

Coffee shops operate on thin net margins — typically 5–15% — despite strong gross margins of 60–70%. The gap exists because labor, rent, and equipment costs are high relative to the product. What this means in practice is that a 2% increase in beverage cost or a few extra unscheduled labor hours per week can wipe out weeks of profit. Without a structured income statement, those shifts are nearly invisible until they show up as a cash shortfall at the end of the month.

A well-structured coffee shop income statement separates revenue by channel — espresso drinks, drip coffee, food, wholesale, and catering — and breaks COGS into beverage cost and food cost independently. This matters because the margin profile is completely different: a latte has a beverage cost of roughly 20–30% but food items like pastries sourced from a bakery might run 40–50% depending on your supplier. Mixing them into a single COGS line hides which part of your menu is actually making money. Labor should be split between baristas and management, since barista hours flex with volume while management is largely fixed.

The best way to use an income statement isn't as a retrospective document — it's as a monthly checkpoint. Set targets for beverage cost %, labor %, and net margin at the start of the year, then compare actuals against those targets each month. A cafe running at 32% beverage cost in January and 37% by March has a problem that started in February — catching it in March is still actionable. Catching it in June after half the year's margin has eroded is just an accounting exercise. This template is built to support that monthly review workflow, with the dashboard giving you the key ratios at a glance.