Cash Flow Forecast Template for Coffee Shops

A café lives on hundreds of small sales a day and margins of a few cents per cup. That makes cash flow feel steady until a quiet month, a rent review or an espresso machine repair arrives at the same time. A simple forecast shows how much of the till is really yours to spend.

Why coffee shop cash flow is different

• High volume, low ticket. Daily takings look healthy, but a $4.50 latte might leave well under a dollar once beans, milk, cups and labour are paid.
• Supplies scale with sales. Beans, milk, pastries and cups are bought weekly, so their cost moves with footfall.
• Card fees add up. When most sales are contactless, processing fees are a real cost line, not a rounding error.
• Equipment is expensive. Espresso machines and grinders are often leased or financed, and repairs are urgent.
• Weather and seasons matter. Summer holidays can empty a commuter café while a high-street shop gets busier.

A worked example

A café takes about $42,000 a month. Coffee and milk cost 22 percent of drink sales, food 10 percent, cups and packaging 3.5 percent, and card fees 2.2 percent.

The quiet summer month still makes money, but with less than half the cushion. If the grinder needs replacing in August, the café is short. Knowing that in spring is the difference between planning a repair fund and borrowing in a hurry.

How to build a café cash forecast

1. Start with average daily sales by month and multiply by trading days.
2. Split counter, mobile order and any wholesale or catering sales, since they pay at different times.
3. Link beans, milk, food and packaging to sales as percentages.
4. Add barista payroll, rent, equipment finance and utilities.
5. Add card fees as a percentage of card sales.
6. Keep a buffer for equipment repairs and slow months.

If you’re just starting out, the free 12-month template is enough to see your first year.

Common mistakes

Forgetting that loyalty top-ups and gift cards are drinks you still owe. Ignoring milk price rises. And paying yourself from a good week’s takings without checking what’s due next month.

What the template gives you

The Café & Coffee Shop template adds a Cost of Sales tab that ties beans, milk, food, cups and card fees to the sales they come from, so costs move automatically when you change your sales forecast. Scenarios show what a wet summer or a new competitor nearby would do to your balance.

Key assumptions built into the Café & Coffee Shop template

• The Cost of Sales tab calculates coffee and milk at 22% of counter sales, mobile order payouts and catering orders, bakery and food at 10% of counter sales and mobile order payouts, card fees at 2.2% of counter sales, mobile order payouts and gift cards and loyalty top-ups and cups and packaging at 3.5% of counter sales and mobile order payouts. Change a percentage once and every month of the forecast updates, so costs rise and fall with the sales that drive them.
• 5 cash in lines and 8 cash out lines are already named for café & coffee shop businesses, and every one can be renamed or extended.
• The example figures follow a typical café & coffee shop year, busiest in December and October and quietest in July and August, so the tight months show up where they usually fall.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Café & Coffee Shop template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Café & Coffee Shop cash flow forecasting: questions

What percentage of sales should coffee cost in a café?

Many cafés aim for total drink cost (coffee, milk, cups) of around 20 to 30 percent of drink sales. Specialty coffee and oat milk push it higher.

How do I forecast sales for a new coffee shop?

Estimate customers per hour for each part of the day, multiply by average spend, and check the result against rent and staff costs. Build a worst case at 60 percent of that.

Should equipment finance go in my cash flow forecast?

Yes. Lease and finance payments are fixed monthly cash out, even in quiet months, so they belong in every month of the forecast.