This weekend — through Sunday at 11:59 PM: BUNDLE-NOV21 takes 10% off the Practice in a Box + Everything Vault bundle. VAULT-NOV21 takes 15% off the Everything Vault. WEEKEND15 takes 15% off everything else, and the new Close the Month + Close the Year bundle is $149.
Browse templates →

Coffee Shop Expense Tracker: Build Your True Cost Per Cup

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.

9 categoriesorganized around the cup
$1,947tracked costs in the worked week
Per cupthe unit every price depends on

Why coffee shop expenses need their own system

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.

How to track coffee shop expenses, step by step

Count what enters the cup weekly, waste included, and the per-cup figure builds itself.

  1. Enter bean and milk deliveries by category on arrival. Beans, dairy milk, alt-milks, and syrups each get their own row and category. Alt-milks in particular must never hide inside 'milk' — their cost per ounce and their share of drinks are both different stories.
  2. Log waste at close, in three lines. Coffee-specific rule: the closing routine records milk discarded, shots and drinks remade or comped, and food items expired, each estimated at ingredient cost. Thirty seconds at close buys the only honest yield numbers the shop will ever have.
  3. Track cups, lids, and sleeves as a paired category. Cup usage should shadow drink counts. When cups consumed outrun drinks sold by more than a small margin, the gap is breakage, staff drinks, or worse — and it is measurable only if disposables are their own line.
  4. Record card and app fees weekly, gross. Enter the week's gross sales and the processing and order-app fees as expense rows. On small average tickets, fee percentage is a pricing input, not an accounting footnote.
  5. Schedule equipment maintenance as a monthly line. Espresso machine servicing, grinder burrs, water filtration, and brewer descaling are predictable costs of serving coffee; entering them monthly spreads them across the cups they made possible.
  6. Compute cost per cup every Friday. Divide the week's ingredient, disposable, and fee totals by drinks served. Post the figure where the schedule is written — it is the context every staffing and menu decision deserves.

Nine coffee shop expense categories behind the cup

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.

The alt-milk question, answered with numbers

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.

Worked example: one week at a neighborhood cafe

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.

CategoryAmount
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

Cafe tracking habits for the closing shift

The close is where cafe data is born; keep its asks tiny and consistent:

  • Weigh or estimate discarded milk in pitchers at close rather than guessing weekly — the pitcher count is quick and surprisingly accurate.
  • Keep the delivery invoices in a dated folder by week so the Friday per-cup calculation needs no hunting.
  • Record staff and training drinks in the waste log as their own sub-line; they are a real, legitimate cost and hiding them distorts both waste and morale.
  • Note grinder calibration and equipment issues on the day they happen — a drifting grinder shows up as bean waste a week before it shows up as complaints.

Build cost per cup in a cafe-ready workbook

The Coffee Shop Profit and Inventory Tracker carries these categories, a waste log, and automatic cost-per-cup views in Excel and Google Sheets.

Frequently asked questions

How do I start tracking waste without slowing the close?

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.

Should equipment repairs sit in cost per cup?

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.

What if my POS already reports product costs?

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.

Gear we use

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.