Coffee Shop KPI Dashboard Template

Start by setting up the Goals & Benchmarks sheet with your targets for the year — total revenue goal, average ticket size you want to hit, daily cups sold target, and your cost percentage ceilings for beverages and labor. If you've been open for at least a few months, use your POS averages as a starting point and adjust for any menu changes or pricing updates you're planning. Then move to the Monthly Input sheet and enter your most recent completed month: total transactions, revenue by category, beverage and food costs from supplier invoices, and labor hours and dollars by role. The first data entry takes about 20 minutes; subsequent months are faster once you know where to pull each number.

Coffee shops operate on tight margins — gross margins of 60–70% sound healthy until you account for labor, rent, and overhead, which together push net margins down to 5–15% for most independent operators. The difference between a shop that makes money and one that slowly bleeds is almost entirely captured in two numbers: beverage cost percentage and labor cost percentage. Beverage cost above 35% means you're either over-pouring, dealing with significant waste, or your pricing doesn't reflect ingredient costs. Labor cost above 35% usually means your schedule doesn't match your transaction volume — too many hours in slow periods, or too few in the morning rush. Tracking both numbers monthly, not quarterly, is how owner-operators catch these problems while they're still fixable.

Key Performance Indicators