Coffee shop budget template: plan labor by day part

A free coffee shop budget template for Excel that keeps labor in step with sales at every day part: sales per labor hour, an overtime check and a monthly P&L.

Jonan Junwikul in a light linen blazer over a black T-shirt, on a city street

Jonan Junwikul

Author ·

Reviewed by Jamie Rosenberg

Product, Kronto

A coffee shop lead on a phone call, holding a tablet behind the counter.
Kronto's labor budget table turning each day's sales forecast into budget hours and dollars.

Free download

Free coffee shop budget template for Excel

Plan labor by day part, with sales per labor hour, an overtime check and a monthly P&L. Every result is a formula, so the sheet recalculates as you type in your own numbers.

Download the templateExcel file (.xlsx)

How do you make a coffee shop budget?

Forecast sales by day and by day part, set targets for food costs, labor and marketing as shares of sales, and add rent and utilities in dollars. Then schedule against the labor dollars. Toast's coffee shop breakdown is a fair starting point: food costs 30-35%, labor 24-40%, marketing 3-6%.

Those ranges are from Toast's coffee shop cost guide.⁠[1] The free template puts them on the Monthly P&L tab as editable defaults. Toast doesn't break out cups and lids; the template counts them in the food line, which is our own choice. Download the coffee shop budget template (.xlsx).

Kronto budget tooltip for a Saturday showing forecasted sales, the labor budget estimated from the company's labor percentage, scheduled spend, the amount over budget, and budgeted versus scheduled hours

Key takeaways

  1. Toast estimates a coffee shop's monthly operating costs at 75-85% of sales, with labor at 24-40%.
  2. Budget labor by day part, because one daily labor percentage hides an overstaffed afternoon.
  3. The sales per labor hour you need is your hourly rate plus payroll taxes, divided by your target labor percentage.
  4. At $15 an hour plus 7.65% in employer payroll taxes and a 30% target, every labor hour needs about $53.83 in sales.
  5. Open with the fewest people who can safely run the bar, then time a second barista to the first rush.
  6. Budget rent and insurance as fixed dollars and the other costs as percentages, so the budget scales with sales.

How much does it cost to run a coffee shop each month?

About 75-85% of monthly sales, by Toast's estimate of a coffee shop's total operating costs. That covers cups, milk, beans and food; labor with payroll taxes; rent; utilities; marketing; insurance, card fees and repairs. Budget rent and insurance as fixed dollars and the rest as percentages, so the budget scales when sales move.

Toast's breakdown also lists utilities at about $1,000-$1,200 a month.⁠[1] Your lease, not a benchmark, sets rent.

Why budget coffee shop labor by day part?

Because sales aren't spread evenly through the day. Many shops do much of their business before late morning, then sit quiet for hours. One daily labor percentage hides that: the morning looks fine while the afternoon bleeds. Sales per labor hour by day part shows exactly which hours to add or cut.

The template splits each day into three parts: open to 11am, 11am to 2pm, and 2pm to close. Change the labels to match your hours.

What sales per labor hour does a coffee shop need?

Divide your hourly labor cost, the wage plus payroll taxes, by your target labor percentage. At $15 an hour plus 7.65% in employer payroll taxes, a 30% target needs about $53.83 in sales for every labor hour, and a 25% target about $64.59. A day part below that has more hours than its sales pay for.

The $15 figure is the BLS median for fast food and counter workers, $15.00 an hour in May 2025.⁠[2] The 7.65% is the employer's share of Social Security and Medicare taxes;⁠[3] add state payroll taxes, workers' comp and benefits if you pay them. On wages alone the same targets come out at $50 and $60, which is why leaving taxes out makes every day part look better than it is. The template calculates the SPLH you need and turns any day part below it red.

Kronto day view comparing required staff from the sales forecast with scheduled staff for each half hour, above the day's shifts

How do you cover early opens without blowing the coffee shop budget?

Open with the fewest people who can safely run the bar, often one opener, then time a second barista to the first rush. Setup tasks like dialing in the grinder and stocking pastry belong before the doors open. Check the open-to-11am sales per labor hour weekly to see whether that second start is early.

Kronto forecasts each store's sales in half-hour steps from its own POS history, which shows when the rush really starts. Required staff per half hour comes from your staffing ratios and rules, such as never leaving a barista on without a shift lead.

Kronto dashboard comparing a store's daily sales with the forecast, labor as a percent of sales against forecast, last week and last year, and a sales heat map

What's in the coffee shop budget template

  • Day-part labor. Sales and labor hours for each day part of each day, then total sales, labor budget, scheduled cost, labor %, over or under, and sales per labor hour by day part, plus the SPLH your target needs.
  • Overtime check. Regular and overtime hours and pay for each person, at time and one-half over 40 hours in a workweek.⁠[4]
  • Monthly P&L. Food and cups, labor, rent, utilities, marketing and other costs as shares of sales, actuals at month end, prime cost and profit margin.
  • Sources. Each benchmark default with its link and the date we checked it.

How to read the profit line

Compare your margin with published figures once every cost line is filled in. Square, citing the Specialty Coffee Association, says non-roaster coffee retailers can make as much as a 6.9% profit margin, and it quotes Sharpsheets, a seller of financial models, for a 13.7% average operating margin at U.S. coffee shops in 2024.⁠[5] An operating margin comes before owner pay and loan payments, so compare like with like. For more published margins and why they disagree, see how much a coffee shop makes. If you're well below them, labor by day part is the first place to look.

Coffee shop budgeting mistakes to avoid

  • Staffing the afternoon like the morning. Same headcount, a fraction of the sales.
  • Forgetting the opener's prep time. The first hour before doors is paid labor with no sales against it. Budget it.
  • Leaving payroll taxes out. Fill in the labor load cell or every labor percentage reads low.

Kronto's labor budget shows each day's budget and over or under while you schedule the shop.

Frequently asked questions

How do you calculate a coffee shop's profit margin?

Subtract every cost for the month, including labor with payroll taxes, from that month's sales, divide by sales and multiply by 100. $1,800 left from $30,000 in sales is a 6% margin. The template's Monthly P&L tab does this for you. For published margins to compare against, see what coffee shops make and keep.

Is the coffee shop budget template free?

Yes. Download it with no sign-up. It opens in Excel and in Google Sheets.

Can I change the day parts?

Yes. Rename the column headers to your own hours; the formulas don't depend on the labels.

How does Kronto help with a coffee shop budget?

Kronto shows each day's labor budget, scheduled cost and over or under while you build the schedule, from a half-hour sales forecast built on your own POS history.

Sources

  1. How Much Do Coffee Shops Make? (2026 Data), Toast. Read October 23, 2026. ↩
  2. Occupational Outlook Handbook: Food and Beverage Serving and Related Workers, U.S. Bureau of Labor Statistics. Read November 10, 2026. ↩
  3. Topic no. 751, Social Security and Medicare withholding rates, Internal Revenue Service. Read November 10, 2026. ↩
  4. Overtime Pay, U.S. Department of Labor, Wage and Hour Division. Read October 23, 2026. ↩
  5. How to Start a Coffee Shop: A Guide to Success (2025), Square. Read October 23, 2026. ↩

Benchmarks checked against Toast, Square, BLS and DOL sources on Oct 23, 2026, and the IRS payroll tax rate on Nov 10, 2026. Template formulas tested in Excel. Last reviewed November 18, 2026.

Reviewed by Jamie Rosenberg, Product, Kronto, on November 18, 2026.

One app for your whole cafe

Kronto is one app for scheduling, the time clock, tips and payroll, so the barista hours in your coffee shop budget are the hours you schedule, the hours people clock and the hours you pay.

Free for up to 10 people