Coffee Shop Budget Template

Getting started takes about 15 minutes. Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins needed. Start with the Monthly Budget sheet and review the pre-loaded revenue and expense categories. Most coffee shop owners keep the structure as-is and just adjust a few line items: rename a revenue stream if you don't have a wholesale program, or add a specific equipment expense. Once you're happy with the categories, enter your projected numbers for the current month. If you're starting from scratch, use your last three months of bank statements to estimate a realistic baseline.

Build out the remaining months by copying the current month's structure and adjusting for what you know about your seasonal patterns. Fall and winter typically see higher hot-drink volume; summer may shift revenue toward cold brew and iced drinks. If you have a wholesale account or office coffee service, enter those revenue projections separately so you can track how much of your total revenue comes from each channel. The Annual Summary and Dashboard sheets update automatically as you fill in each month.

Come back each month and enter your actuals in the Budget vs Actual sheet. This is where the template earns its keep. You'll see whether your beverage cost percentage — the combined cost of beans and dairy as a share of drink revenue — is tracking to your target, whether labor is running over, and which overhead categories are creeping. Most cafe owners who stick with a monthly check-in routine say it takes 20–30 minutes and is the single most useful financial habit they've built.

Coffee shops operate on thin margins that leave almost no room for cost surprises. Gross margins look healthy at 60–70%, but after labor, rent, and overhead, net margins typically land between 5% and 15%. The difference between a profitable cafe and a break-even one often comes down to whether the owner is watching beverage cost percentage, labor cost percentage, and average ticket size on a regular basis — or only finding out the numbers are off when the bank account gets low.

A cafe budget needs to reflect how a coffee shop's costs actually behave. Beverage cost — beans plus dairy and alternative milks — is your most important variable cost line and should typically sit between 25% and 35% of drink revenue. Dairy is easy to overlook but adds up fast, especially as oat milk and other alternatives, which cost 2–3x more than dairy, become a larger share of orders. Labor is typically the largest single expense, often running 35–45% of total revenue for smaller cafes, and needs to be tracked against sales volume, not just dollar amount — overstaffing a slow Tuesday morning is where the margin goes. Rent should ideally sit under 15% of revenue, which makes location economics a critical variable when you're projecting.

The best way to use a budget template is as an ongoing operational tool, not just a one-time planning exercise. Set your targets at the start of each month, enter actuals at the end, and spend 20 minutes reviewing the variance. The goal is to catch a beverage cost spike early enough to adjust your ordering, identify a labor inefficiency before it compounds across a quarter, and build a clear picture of which revenue streams are actually carrying the business versus which ones are nice-to-have. Over time, a 12-month history of actual vs. budget gives you the data to negotiate a lease renewal, apply for a small business loan, or make a confident decision about opening a second location.