Five Reports Every Cafe Owner Should Run Weekly

Dashboard fatigue is real

Modern tools love dashboards. Twelve widgets. Twenty chart types. Metrics everywhere. The problem is not a lack of data. It is a lack of focus. When everything is highlighted, nothing stands out. When you can see thirty metrics at a glance, you end up acting on none of them.

Running a cafe does not require a wall of charts. It requires a small number of reports, reviewed consistently, that answer the questions that actually drive decisions. Five reports, thirty minutes per week, and you will know more about your business than most multi-location operators with dedicated analytics teams.

The key is discipline: same reports, same day, same time, every week. Monday morning before the rush starts, or Sunday evening after close. Pick a time that works and protect it. This is not busy work. It is the half hour that makes every other hour of the week more effective.

Report 1: Sales summary with week-over-week comparison

What it shows: Total revenue, transaction count, average ticket, total tips, and total discounts for the past seven days, compared to the same seven days from the prior week.

What to look for: Revenue trending up or down? Are you selling more transactions at lower average tickets (volume play) or fewer transactions at higher tickets (value play)? Tip percentage can indicate service quality and customer satisfaction. Discount amount shows how much you are giving away and whether promotions are working.

The action it triggers: If revenue is down and transactions are flat, your average ticket dropped, which means customers are ordering less per visit. Check whether a popular high-margin item fell off, or whether discounts are cannibalizing revenue. If revenue is up but tips are down as a percentage, explore whether rush-hour service quality is suffering from higher volume.

Review time: 5 minutes.

The week-over-week comparison is critical. A single week's numbers in isolation tell you almost nothing. The same numbers compared to last week tell you whether things are improving, stable, or declining. Over time, the weekly comparison becomes your early warning system. Two consecutive weeks of declining average ticket is a signal. Three weeks is a pattern that needs action.

Report 2: Product mix and margin analysis

What it shows: Your top sellers ranked by volume and by margin contribution. The product mix breakdown (what percentage of sales comes from each category: espresso drinks, drip coffee, specialty, pastries). Modifier impact on margins (how much oat milk swaps, extra shots, and flavored syrups affect your average drink cost).

What to look for: Are your highest-volume items also your highest-margin items? Often they are not. A cafe might sell 50 drip coffees a day at an 85% margin and 40 oat milk lattes at a 45% margin. The drip coffee is more profitable per cup, but the lattes drive more total revenue. Understanding this mix is essential.

Also check modifier economics. If 60% of lattes swap to oat milk and your upcharge does not cover the cost difference, every latte you sell is less profitable than your recipe costing suggests. This report makes that visible.

The action it triggers: Consider adjusting pricing on items with margins below your target. Promote high-margin items more visibly on the menu board. If a modifier is consistently margin-negative (costs more than you charge), either adjust the upcharge or accept it as a marketing cost and account for it in your planning.

Review time: 8 minutes.

Report 3: Labor cost as percentage of revenue

What it shows: Total labor hours, total wages paid, total tips earned, and labor cost as a percentage of revenue. Broken down by day of week and ideally by team member.

What to look for: Industry benchmarks for labor as a percentage of revenue in specialty coffee run 28-35%. If you are above 35%, you are likely overstaffed during slow periods. If you are below 25%, you might be understaffed during rushes, which hurts service quality and tips.

The day-of-week breakdown reveals overstaffing on specific days. If Tuesday's labor cost is 42% of revenue but Saturday's is 26%, you have a scheduling opportunity. The per-team-member breakdown shows whether labor distribution is balanced or if one person is carrying a disproportionate number of hours.

The action it triggers: Adjust scheduling for days where labor percentage is too high. Add a shift on days where it is too low and tips confirm the team is stretched thin. Over multiple weeks, track whether scheduling changes are moving the percentage toward your target.

Review time: 5 minutes.

Report 4: Inventory consumption vs. purchases

What it shows: For each major ingredient category, compare two numbers. First, the predicted consumption based on sales times recipes (what you should have used based on what you sold). Second, the actual spend based on supplier invoices and purchase orders (what you actually bought to replace it).

What to look for: The gap between predicted consumption and actual purchases is your waste and inefficiency metric. If recipes predict you consumed $800 of oat milk this week but you purchased $1,050, that $250 gap is waste, over-portioning, spoilage, or recipe inaccuracy.

Some gap is expected. Waste buffers exist for a reason. But a persistent gap above 15-20% on a major ingredient signals a problem worth investigating. Is portioning inconsistent? Are batches being dumped too frequently? Is the recipe wrong?

The action it triggers: For items with large consumption-to-purchase gaps, investigate the root cause. Observe portioning during a rush. Check batch waste logs. Update recipes if the specified quantities do not match actual practice. Even reducing the gap by 5% on a high-volume ingredient saves hundreds of dollars per month.

Review time: 7 minutes.

This report is the one most cafes skip because it requires connecting two data sources (sales-based consumption and purchase-based spend). But it is also the report with the highest ROI. The waste it reveals is pure profit recovery.

Report 5: Supplier spend breakdown

What it shows: Total spend with each supplier for the past week (and month to date). Trending up or down compared to the prior period. The split between your major suppliers: Metro Supply Co (paper goods, supplies), Fresh Dairy Co (milk, cream), Bean Source Roasters (coffee beans), and specialty vendors (matcha, chai, syrups).

What to look for: Sudden spikes in spend with a single supplier could mean a price increase you missed, an accidental double order, or a shift in consumption patterns. A gradual upward trend in dairy spend might reflect the growing popularity of oat milk (which is more expensive than whole milk per ounce).

Compare supplier spend to revenue. If your Metro Supply Co spend is growing faster than your revenue, your cost-per-transaction on paper goods is increasing. This might be fine (you switched to higher-quality cups) or it might be a problem (you are over-ordering and wasting).

The action it triggers: Question any spend that increased more than 10% week over week without a clear explanation. Check invoices for price changes you need to account for in your recipe costing. If a supplier's spend is trending up while the items you order from them have stable consumption, contact them to verify pricing. Consolidate orders where possible to hit volume discounts.

Review time: 5 minutes.

The 30-minute weekly review

Add up the review times: 5 + 8 + 5 + 7 + 5 = 30 minutes.

Half an hour. That is the investment. In return, you know whether your revenue is growing or shrinking, which products carry your margins, whether labor is in line, where waste is hiding, and how supplier costs are trending.

The discipline is not in the complexity of the reports. It is in the consistency. The owner who reviews these five reports every Monday morning for three months will understand their business at a level that most operators never reach. They will spot problems before they become crises. They will see opportunities before competitors do. They will make pricing, staffing, and ordering decisions grounded in evidence rather than intuition.

You do not need a data science degree. You do not need twenty dashboards. You need five reports, thirty minutes, and the commitment to show up every week. That is how smart cafes are run.