Every coffee shop decision — price, size, a free alt-milk swap — is secretly a cost-per-cup decision. This tracker gathers beans, milk, cups, and fees into that single figure, then lets you manage the business from it.
A coffee shop sells a four-dollar-to-seven-dollar product hundreds of times a day, which means its economics are decided in cents. Ten cents of extra milk per drink, a lid count that never matches cup sales, a grinder drifting out of calibration — each is invisible alone and decisive in aggregate. Expense tracking for a cafe therefore has to resolve to the cup, not just the month.
Waste is the category no supplier invoices you for. Milk steamed and discarded, shots pulled to dial in, pastries that miss their day — these costs were purchased and recorded as inventory, and without a waste habit in the tracker they simply evaporate from the analysis, leaving menu prices built on theoretical yields.
Count what enters the cup weekly, waste included, and the per-cup figure builds itself.
Ingredients first, then the vessel, then the machinery and fees that put the drink in a customer's hand — the order of the categories is the order of the cost build-up.
Coffee beans and espresso. Whole-bean purchases for espresso and drip, including decaf and featured roasts, tracked by delivery and drawn down by usage.
Milk and alt-milks. Dairy milk plus oat, almond, soy, and other alternatives as one tracked family with alt-milks subtotaled — the fastest-moving cost line in most modern cafes.
Syrups, powders, and flavorings. House and commercial syrups, matcha, chai, cocoa, and seasonal ingredients whose cost concentrates in specialty drinks.
Cups, lids, and disposables. Hot and cold cups, lids, sleeves, straws, napkins, and takeaway trays — the per-cup cost that applies even when ingredients are wasted.
Food and pastry purchases. Baked goods, breakfast items, and grab-and-go food bought for resale, with expired unsold items visible through the waste log.
Equipment maintenance and smallwares. Espresso and grinder servicing, filtration, portafilters, tampers, pitchers, and replacement glassware.
Card, app, and loyalty fees. Payment processing, mobile-order platform charges, and the cost of loyalty rewards redeemed — the toll on every transaction.
Labor and payroll costs. Barista and counter wages with employer taxes, recorded weekly so labor per drink can sit beside ingredient cost per drink.
Occupancy and utilities. Rent, the substantial water and power a cafe consumes, trash and grease services, and insurance — the fixed floor under the cup.
Whether to charge for alt-milk is a values question that still deserves accurate inputs. With alt-milks subtotaled in the tracker, a shop can state its position precisely: alt-milks run a known cost per ounce, appear in a known share of drinks, and therefore add a known number of cents to the average cup. Absorbing that knowingly is a policy; absorbing it unmeasured is just a leak with good branding.
The same logic governs size pricing. Once cost per cup exists by size — small drinks carry nearly the same cup, lid, and fee as large ones, but less milk and coffee — the margin ladder across sizes stops being folklore. Shops routinely discover their most popular size is their worst-margin one, which is exactly the kind of discovery a tracker exists to produce.
A cafe serving about 1,340 drinks in a week with $8,215 in gross sales records the following week of costs from deliveries, the waste log, and fee statements:
The tracked rows total $1,947. Tracked variable costs of $1,947 sit alongside $100 of waste logged at ingredient cost — about 7.0% of the week's $1,423 of ingredient purchases — which the owner now watches as its own trend line rather than an extra expense. Fees of $274, at roughly 20 cents per drink, earn their place in the per-cup build-up next to the 13 cents of cups and lids.
| Category | Amount |
|---|---|
| Coffee beans | $386 |
| Milk and alt-milks | $512 |
| Syrups and flavorings | $94 |
| Cups, lids, and disposables | $168 |
| Food and pastry purchases | $431 |
| Equipment maintenance (weekly share) | $82 |
| Card and order-app fees | $274 |
| Total tracked | $1,947 |
The close is where cafe data is born; keep its asks tiny and consistent:
The Coffee Shop Profit and Inventory Tracker carries these categories, a waste log, and automatic cost-per-cup views in Excel and Google Sheets.
Start with milk only, estimated in pitchers, for two weeks. One habit, honestly kept, beats a nine-line form abandoned on day three; add drinks remade and food expired once the milk habit holds.
In the all-in figure, yes — spread monthly. Keep a second, ingredients-only per-cup figure for daily pricing decisions, and use the all-in figure when judging the menu as a whole.
POS theoretical costs assume perfect portions and zero waste. Use them gladly, and reconcile them monthly against the tracker's actual purchases and waste — the gap between theoretical and actual is the number this page exists to manage.
Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you.
Adams Guest Check Pads, 2-Part Carbonless, 10-Pack — for restaurants and food trucks: order pads that leave a copy for the kitchen and the books.
Brother Genuine DK-2205 Continuous Label Roll — Brother's continuous DK roll for QL label printers — cut labels to any length.
Casio HR-170RC Printing Calculator — a compact printing calculator with reprint and check-and-correct functions.
Logitech MX Brio 4K Webcam, Graphite — a 4K webcam for client calls that need to look professional.
More books and gear live on the Resources page.