Your best-selling drink is not always your most profitable one. To find your money-makers, open your cafe sales report and list how many cups each drink sold. Then subtract the ingredient cost from the price to get the profit per cup. Finally, multiply that profit by the cups sold. Drinks with high sales and high profit per cup are your true stars.
It is Friday morning at your cafe. The line reaches the door, and the milk steamer never stops. Your team pulls shot after shot.
Yet at month end, the profit looks smaller than that busy crowd promised. Why?
Busy does not always mean profitable. Some drinks sell in huge numbers but leave very little money per cup. Others earn well but hide at the bottom of your menu. Your cafe sales report can show you which is which. This guide explains how to read it in plain language.
Why Your Best-Selling Drink May Not Be Your Most Profitable
Every drink has two numbers that matter: how often it sells and how much you earn each time.
Cost changes a lot from drink to drink. A filter coffee needs only beans and water. A vanilla latte with oat milk needs more milk, syrup, a bigger cup, and extra shots. Bellwether Coffee's profit margin guide shows this in its sample figures, where blended drinks earn a gross margin of about 70% and drip coffee about 88%. Your own drinks may sit above or below those numbers. Only your data can tell you.
What Is a Cafe Sales Report?
A cafe sales report is a summary of everything you sold in a set period. It shows each item, the number of units, the revenue, and the time of sale.
When you use cafe POS software, every order is recorded automatically. The report builds itself, so you never count receipts by hand.
What to Look for in Your Coffee Shop Sales Report
Start with these five numbers:
- Cups sold per drink. This shows popularity.
- Revenue per drink. This shows which items bring in the most cash.
- Sales by hour and day. This shows when each drink sells best.
- Add-ons and modifiers. Extra shots, oat milk, and syrups can add real profit.
- Discounts and voids. These show where money leaks out.
If you run more than one outlet, compare each branch too. A multi-store dashboard helps you see which location sells which drinks.
How to Find Your Most Profitable Drinks in 5 Steps
Step 1: Pull four weeks of item sales
One week can mislead you. Four weeks smooth out slow days and rush days. Open your Reports & Analytics and export cups sold for every drink.
Step 2: Work out the true cost of each drink
Add up everything that goes into the cup. That includes coffee, milk, syrup, and the cup, lid, and sleeve. Intermix's guide to latte costs shows how to cost a drink by adding up every item in it, such as the cup, lid, milk, flavoring, and espresso.
Tracking this by hand is slow. With inventory management that works at the ingredient level, your software can deduct the exact milk, beans, and syrup used per recipe.
Step 3: Find the profit per cup
Use this simple formula:
Profit per cup = selling price minus ingredient cost
Finance teams call this the contribution margin. NetSuite explains that contribution margin matters more than food cost alone, because it shows the actual profit per dish.
Step 4: Multiply by cups sold
Profit per cup times cups sold gives you the total profit from each drink. This is the number that pays your rent.
Step 5: Sort your drinks into four groups
Compare each drink to your menu average for sales and for profit per cup. Then place it in one of four groups. The next sections show how.
Cafe Sales Report Example: Which Drinks Earn the Most?
These numbers are made up to show the method. Your own report will look different.
In this example, the average drink sells about 223 cups a week and earns about $2.95 per cup. Here is how each drink compares.
Latte (Star). It sells for $4.50 and costs $1.10 to make, so it earns $3.40 per cup. It sells 400 cups a week, which adds up to $1,360 in weekly profit. It sells well and earns well, so it makes the most money overall.
Filter coffee (Plowhorse). It sells for $2.50 and costs $0.30 to make, so it earns $2.20 per cup. It is your busiest drink at 500 cups a week, and it brings in $1,100 in weekly profit. It earns less per cup than average, but it still makes the second-highest profit, so keep it.
Vanilla oat latte (Plowhorse). It sells for $5.00 and costs $2.20 to make, so it earns $2.80 per cup. It sells 250 cups a week for $700 in weekly profit. Guests order it often, but its ingredients cost more, so it earns a little less per cup than average.
Cold brew (Puzzle). It sells for $4.00 and costs $0.60 to make, so it earns $3.40 per cup. That matches the latte. However, it sells only 90 cups a week, so it brings in $306 in weekly profit.
Matcha latte (Puzzle). It sells for $5.50 and costs $2.20 to make, so it earns $3.30 per cup. Only 60 cups sell each week, so it makes $198 in weekly profit.
Caramel frappe (Dog). It sells for $5.50 and costs $2.90 to make, so it earns just $2.60 per cup. It sells only 40 cups a week, which gives you $104 in weekly profit. It struggles on both sales and profit.
So what does this report tell us? Filter coffee is your busiest drink, but not your richest. Cold brew and matcha are hidden gems, because they earn more per cup than the vanilla oat latte but few guests order them.
Without the report, you might push the vanilla oat latte because it sells well. The data shows you have better options.
Menu Engineering for Cafes: Stars, Plowhorses, Puzzles, and Dogs
This method is called the menu engineering matrix. It began in 1982, when hospitality researchers Michael Kasavana and Donald Smith published their guide to menu analysis. NetSuite's menu engineering guide explains that the matrix sorts dishes into Stars, Puzzles, Plow Horses, and Dogs by popularity and profit, which guides what to promote, rework, or cut. Here is how to use each group in a cafe.
Stars: High Sales, High Profit
Protect them. Keep quality steady and list them first on your menu board.
Plowhorses: High Sales, Low Profit
These bring guests in, so do not cut them. Instead, try a small price rise. You can also check for waste, such as extra syrup pumps. A suggested add-on can lift the profit too.
Puzzles: Low Sales, High Profit
These are your biggest opportunity. Ask baristas to suggest them. Give them a catchy name. Feature them on the menu board or in a combo.
Dogs: Low Sales, Low Profit
Rework the recipe to lower the cost. If that fails, remove the drink. Slow items also leave ingredients sitting on the shelf, which is the same trap as dead stock in a supermarket.
Sales by Hour and Add-ons: The Hidden Profit in Your Report
A good cafe sales report shows more than drink names.
First, check sales by hour. If cold drinks peak at 3 PM, you can prep and staff for it. Next, check add-ons. Item modifiers such as extra shots, oat milk, and syrups often carry a good margin. Finally, look at what your regulars order. A loyalty program can reward the drinks you want to grow.
5 Mistakes to Avoid When Reading a Cafe Sales Report
- Judging by sales alone. Volume hides low profit.
- Using old ingredient costs. Milk and bean prices change, so update costs often.
- Forgetting small costs. Cups, lids, and syrup pumps add up.
- Checking only one week. Use at least four weeks of data.
- Reading reports too rarely. A weekly habit beats a yearly panic. Our guide on measuring business performance with POS software can help you build one.
How LithosPOS Cafe POS Software Simplifies Sales Reports
With LithosPOS, you can track sales and inventory in real time on the dashboard. It works on iPhones, iPads, Android devices, and PCs, so you can check your numbers from the counter or from home. The Dashboard App puts your key data in one place, and ingredient-level tracking helps you see the true cost of each drink.
Still choosing? Read our guide to compare POS software before you buy.
Cafe Sales Report FAQs
What is the most profitable drink in a coffee shop?
Simple drinks such as filter coffee, espresso, and cold brew usually have the lowest ingredient cost, so they earn a high margin per cup. However, the most profitable drink overall depends on how many cups you sell. Multiply profit per cup by cups sold to find out.
How do I calculate profit per drink?
Subtract the ingredient cost from the selling price. For example, a latte sold at $4.50 with $1.10 of ingredients earns $3.40 per cup. That is about a 76% margin.
What is a good cost of goods percentage for a cafe?
One industry guide lists 25% to 35% of revenue as a typical benchmark for cafe cost of goods, and you can read it in The Restaurant Warehouse's coffee shop profit margin guide. Individual drinks vary. To check yours, divide the drink's cost by its price. In our example, the latte costs $1.10 and sells for $4.50, so its cost is about 24%.
How often should I check my cafe sales report?
Take a quick look every week. Then do a deeper review once a month, using at least four weeks of data.
What is menu engineering?
It is a method that uses sales data and profit per item to decide what to promote, rework, or remove. It sorts items into Stars, Plowhorses, Puzzles, and Dogs.
Can cafe POS software track ingredient costs?
Yes. LithosPOS tracks inventory at the ingredient level. It deducts the milk, beans, and syrup used in each drink recipe, which helps you see real costs and reduce waste.
Should I remove drinks that sell slowly?
Not always. A slow drink with high profit is a Puzzle, and better promotion can help it. Remove a drink only when both its sales and its profit are low, and a recipe change does not fix it.
Find Your Most Profitable Drinks with a Free Trial
Stop guessing and start reading your numbers. Start your 14-day free trial or book a demo to see how LithosPOS reports work in a real cafe. You can also view pricing.