Coffee Shop Expense Tracker Template

The most effective workflow is to log expenses at the end of each day, not weekly or monthly. Keep your receipt stack or open your bank app, and enter each transaction in under a minute per row. For recurring costs like rent, payroll, and subscription services, enter them on the first of the month when they hit your account. The COGS Tracker works best when updated once a week using your supplier invoices — it takes about 10 minutes and gives you an accurate running gross margin you can act on in real time.

The categories that drive coffee shop profitability aren't the same as in a restaurant. Espresso beans and specialty coffee are your highest-variable COGS line — a 10% price increase from a roaster can meaningfully cut your margin if you're not tracking COGS percentage monthly. Milk and dairy is the second-biggest product cost, and it varies more than most operators expect given the range of non-dairy options that now make up 30–40% of drink volume at many cafés. Labor is typically 35–40% of revenue and the easiest place to lose control during slow periods if you're not watching it weekly against actual sales.