Coffee Shop Sales Forecast Template

Start with the Assumptions sheet — it drives everything else. Enter your current daily customer count for each month (you can pull this from your POS), your average ticket size for beverages and food separately, and your rough product mix (what percentage of transactions are espresso drinks vs. drip vs. cold brew vs. food). If you have wholesale or office accounts, enter those as a flat monthly revenue figure. The whole model builds from these numbers, so spending 20 minutes getting them right pays off for every sheet downstream.

Once your assumptions are in, the Monthly Forecast and Annual Summary populate automatically. Review the numbers month by month — they should look roughly like your recent actuals, with seasonal variation. Fall and winter months should show stronger espresso and hot drink revenue; summer should show a higher share of cold brew and iced drinks, plus potentially lower overall transaction volume depending on your location and foot traffic patterns. Adjust your mix percentages and seasonal traffic multipliers until the model reflects how your shop actually behaves.

After the first month of actual operations, start filling in the Actual vs Forecast sheet. This is where the template earns its cost. You'll quickly see whether your traffic assumptions were optimistic, whether food attachment is tracking to your projections, or whether your wholesale revenue is growing faster than expected. Use those gaps to update your Assumptions sheet and re-run the forecast. Coffee shop operators who revisit the model monthly tend to catch revenue shortfalls two to three months earlier than those who only look at the numbers at year-end.

Coffee shops fail at a higher rate than most food service concepts, and the most common reason isn't bad coffee — it's poor revenue visibility. Most operators know their daily sales figure from the POS, but few have a forward-looking view of where revenue is heading month to month. When rent goes up 8% at renewal or a new competitor opens across the street, owners who have a working forecast can model the impact within minutes. Those who don't are making staffing and purchasing decisions based on gut feel.

A coffee shop sales forecast works differently from a generic revenue model because of how granular the revenue drivers are. Beverage cost runs 25–35% of drink revenue, so the mix between a $3.50 drip coffee and a $6.50 oat milk latte matters enormously to profitability — and your forecast should reflect that. Similarly, food attachment rate (the percentage of transactions that include a pastry or sandwich) can swing total revenue by 10–15% without changing customer count at all. Modeling these drivers separately gives you levers to pull, not just a number to stare at.

The seasonal planning angle is where a forecast pays for itself fastest. Coffee shops see their strongest revenue in Q4, when hot drink demand peaks and holiday gift card sales add a one-time boost. Summer can be flat or negative at some locations depending on foot traffic patterns. If you know that February is historically your softest month and you model it accurately, you staff down before the slow period rather than cutting hours reactively. That's the difference between managing your business and reacting to it. This template gives you the structure to do the former.