Coffee Shop Operations
Independent coffee shops and cafes
For cafe owners and baristas: drink margins, dial-ins, pars, waste, orders, machine care.
Use this templateCoffee Shop Operations
Dashboard
Start here
Opening and closing checklist
Dialing in and training baristas
Waste and ordering routine
Machine care and service
Menu
What the shop sells, with price, cost and margin.
| Drink or food | Status | Category | Build | Cup size | Price (USD) | Cost to make (USD) |
|---|---|---|---|---|---|---|
| Flat white | Core | 18 g in, 36 g out; 4 oz steamed whole milk | $4.75 | $1.05 | ||
| Oat milk latte | Core | 18 g in, 36 g out; 9 oz steamed oat milk | $5.50 | $1.40 | ||
| Americano | Core | 18 g in, 36 g out; 8 oz hot water | $3.50 | $0.40 | ||
| Pour-over, single origin | Core | 22 g coffee, 350 g water, 3 minutes 30 | $5 | $1.20 | ||
| Cold brew | Core | Batch steeped 18 hours at 1 to 8, served 1 to 1 over ice | $4.75 | $0.90 | ||
| Iced chai | Seasonal | 4 oz chai concentrate, 6 oz milk, ice | $5.25 | $1.10 | ||
| Earl grey | Core | One sachet, 3 minutes at 205 degrees | $3.75 | $0.35 | ||
| Brown butter croissant | Core | Baked from frozen dough, 22 minutes | $4.25 | $1.30 |
Supplies
Everything stocked, counted against par.
| Supply | Category | Counted in | On hand | Par level | Cost per unit (USD) | Last counted |
|---|---|---|---|---|---|---|
| House blend beans | lb | 38 | 60 | $9.80 | Nov 17, 2026 | |
| Single origin, Guatemala | lb | 14 | 20 | $13.50 | Nov 17, 2026 | |
| Whole milk | gallon | 12 | 18 | $4.60 | Nov 17, 2026 | |
| Oat milk | case | 3 | 5 | $38 | Nov 17, 2026 | |
| Vanilla syrup | bottle | 4 | 4 | $11 | Nov 17, 2026 | |
| Chai concentrate | carton | 2 | 6 | $7.50 | Nov 17, 2026 | |
| Croissant dough | tray | 3 | 6 | $42 | Nov 17, 2026 | |
| Banana bread loaves | loaf | 5 | 6 | $9 | Nov 17, 2026 |
Waste log
Everything thrown away, with the reason and the value lost.
| What was wasted | Date | Quantity | Reason | Value lost (USD) | Menu item | Logged by |
|---|---|---|---|---|---|---|
| Unsold croissants | Nov 18, 2026 | 6 | $7.80 | Brown butter croissant | Wilhelmina Tan | |
| Banana bread slices | Nov 16, 2026 | 4 | $3.80 | Seeded banana bread | Wilhelmina Tan | |
| Milk shot dropped | Nov 16, 2026 | 1 | $1.10 | Flat white | Cyrus Delacroix | |
| Wrong drink made, iced chai | Nov 15, 2026 | 2 | $2.20 | Iced chai | Dexter Halvorsen | |
| Cold brew batch off taste | Nov 14, 2026 | 3 | $18 | Cold brew | Anaya Petrovic | |
| Egg sandwiches unsold | Nov 13, 2026 | 5 | $14 | Egg and cheddar sandwich | Wilhelmina Tan | |
| Oat latte remakes | Nov 12, 2026 | 3 | $4.20 | Oat milk latte | Cyrus Delacroix | |
| Croissants unsold | Nov 11, 2026 | 9 | $11.70 | Brown butter croissant | Wilhelmina Tan |
Equipment
The machines that make the coffee, with service dates.
| Machine | Condition | Kind | Last serviced | Water filter changed | Next service due | Technician |
|---|---|---|---|---|---|---|
| Two-group espresso machine | Working | Sep 9, 2026 | Aug 30, 2026 | Dec 8, 2026 | Bellwether Coffee Service | |
| Main grinder | Needs service | Jun 11, 2026 | — | Nov 8, 2026 | Bellwether Coffee Service | |
| Decaf grinder | Working | Aug 20, 2026 | — | Feb 16, 2027 | Bellwether Coffee Service | |
| Batch brewer | Working | Oct 4, 2026 | Aug 30, 2026 | Nov 22, 2026 | In-house | |
| Undercounter fridge | Working | May 2, 2026 | — | May 2, 2027 | Coldline Repair | |
| Pastry oven | Out of order | Nov 3, 2025 | — | Nov 3, 2026 | Coldline Repair | |
| Walk-in cooler | Working | Jul 21, 2026 | — | Nov 18, 2026 | Coldline Repair |
Orders
Orders sent to vendors and when they arrive.
| Order | Status | Placed | Arrives | Arrived on | Order total (USD) | Vendor |
|---|---|---|---|---|---|---|
| Weekly milk and dairy | Placed | Nov 17, 2026 | Nov 19, 2026 | — | $286 | Cascadia Dairy |
| Cups and lids restock | Draft | — | Nov 24, 2026 | — | $410 | Greenware Packaging |
| Roastery beans, wall and bar | Placed | Nov 16, 2026 | Nov 20, 2026 | — | $640 | Fernwood roastery |
| Syrups and chai | Draft | — | Nov 19, 2026 | — | $198 | Lantern Beverage |
| Cleaning supplies | Arrived | Nov 10, 2026 | Nov 13, 2026 | Nov 13, 2026 | $74 | Tidy Supply Co. |
| Weekly milk and dairy, last week | Arrived | Nov 10, 2026 | Nov 12, 2026 | Nov 12, 2026 | $301 | Cascadia Dairy |
| Bakery standing order, short three trays | Placed | Nov 15, 2026 | Nov 17, 2026 | — | $126 | Fernwood bakery |
Dial-in log
Every espresso dial-in, so the next barista starts from the last good setting.
| Dial-in | Dialed in on | Dose (g) | Yield (g) | Shot time (seconds) | Grind setting | Taste |
|---|---|---|---|---|---|---|
| House blend, opening dial-in | Nov 18, 2026 | 18 | 36 | 29 | 2.8 | |
| House blend, after the lunch rush | Nov 18, 2026 | 18 | 38 | 26 | 2.7 | |
| House blend, new bag opened | Nov 17, 2026 | 18 | 36 | 31 | 2.9 | |
| Guatemala, new bag | Nov 17, 2026 | 17 | 38 | 28 | 3.1 | |
| House blend, humid morning | Nov 16, 2026 | 18 | 35 | 30 | 2.8 | |
| Guatemala, second day | Nov 16, 2026 | 17 | 40 | 25 | 3.0 | |
| House blend, training session | Nov 14, 2026 | 18 | 36 | 28 | 2.8 |
Margin, waste and machines at a glance.
| Drink or food | Status | Category | Build | Cup size | Price (USD) | Cost to make (USD) |
|---|---|---|---|---|---|---|
| Flat white | Core | 18 g in, 36 g out; 4 oz steamed whole milk | $4.75 | $1.05 | ||
| Oat milk latte | Core | 18 g in, 36 g out; 9 oz steamed oat milk | $5.50 | $1.40 | ||
| Americano | Core | 18 g in, 36 g out; 8 oz hot water | $3.50 | $0.40 |
| What was wasted | Date | Quantity | Reason | Value lost (USD) | Menu item | Logged by |
|---|---|---|---|---|---|---|
| Unsold croissants | Nov 18, 2026 | 6 | $7.80 | Brown butter croissant | Wilhelmina Tan | |
| Banana bread slices | Nov 16, 2026 | 4 | $3.80 | Seeded banana bread | Wilhelmina Tan | |
| Milk shot dropped | Nov 16, 2026 | 1 | $1.10 | Flat white | Cyrus Delacroix |
| Machine | Condition | Kind | Last serviced | Water filter changed | Next service due | Technician |
|---|---|---|---|---|---|---|
| Two-group espresso machine | Working | Sep 9, 2026 | Aug 30, 2026 | Dec 8, 2026 | Bellwether Coffee Service | |
| Main grinder | Needs service | Jun 11, 2026 | — | Nov 8, 2026 | Bellwether Coffee Service | |
| Decaf grinder | Working | Aug 20, 2026 | — | Feb 16, 2027 | Bellwether Coffee Service |
| Supply | Category | Counted in | On hand | Par level | Cost per unit (USD) | Last counted |
|---|---|---|---|---|---|---|
| House blend beans | lb | 38 | 60 | $9.80 | Nov 17, 2026 | |
| Single origin, Guatemala | lb | 14 | 20 | $13.50 | Nov 17, 2026 | |
| Whole milk | gallon | 12 | 18 | $4.60 | Nov 17, 2026 |
Counted in the last 3 days
| Supply | Category | Counted in | On hand | Par level | Cost per unit (USD) | Last counted |
|---|---|---|---|---|---|---|
| House blend beans | lb | 38 | 60 | $9.80 | Nov 17, 2026 | |
| Single origin, Guatemala | lb | 14 | 20 | $13.50 | Nov 17, 2026 | |
| Whole milk | gallon | 12 | 18 | $4.60 | Nov 17, 2026 |
Service due in the next 30 days
| Machine | Condition | Kind | Last serviced | Water filter changed | Next service due | Technician |
|---|---|---|---|---|---|---|
| Two-group espresso machine | Working | Sep 9, 2026 | Aug 30, 2026 | Dec 8, 2026 | Bellwether Coffee Service | |
| Main grinder | Needs service | Jun 11, 2026 | — | Nov 8, 2026 | Bellwether Coffee Service | |
| Decaf grinder | Working | Aug 20, 2026 | — | Feb 16, 2027 | Bellwether Coffee Service |
Arriving in the next 3 days
| Order | Status | Placed | Arrives | Arrived on | Order total (USD) | Vendor |
|---|---|---|---|---|---|---|
| Weekly milk and dairy | Placed | Nov 17, 2026 | Nov 19, 2026 | — | $286 | Cascadia Dairy |
| Cups and lids restock | Draft | — | Nov 24, 2026 | — | $410 | Greenware Packaging |
| Roastery beans, wall and bar | Placed | Nov 16, 2026 | Nov 20, 2026 | — | $640 | Fernwood roastery |
How to read the numbers
Latest dial-ins
| Dial-in | Dialed in on | Dose (g) | Yield (g) | Shot time (seconds) | Grind setting | Taste |
|---|---|---|---|---|---|---|
| House blend, opening dial-in | Nov 18, 2026 | 18 | 36 | 29 | 2.8 | |
| House blend, after the lunch rush | Nov 18, 2026 | 18 | 38 | 26 | 2.7 | |
| House blend, new bag opened | Nov 17, 2026 | 18 | 36 | 31 | 2.9 |
Opening, 45 minutes before doors
During the day
Closing, after the last order
Times
If the opener is late
The first person in starts the machine and the oven before anything else; everything else on the list can wait 20 minutes, but a cold machine cannot. Keep the opening list printed by the door.
Who does what
The opener owns the dial-in and the pastry par; the closer owns the clean and the counts. Write their names on the shift plan so it is clear.
Weekly deep clean
Pick the quietest afternoon: pull the fridge out and clean behind it, descale the kettle, wash the syrup pumps, and clean the grinder burrs with grinder cleaning tablets.
Example
The closer counted 3 trays of croissant dough against a par of 6, so the morning order includes three more trays, and the waste log shows 6 unsold croissants, which suggests the par for that weekday is too high.
The house recipe
How to dial in
When to dial in
Milk
Steam to 140 to 150 degrees; never reheat. Stretch less for a flat white than for a latte. Oat milk needs a lower temperature to avoid a burnt taste.
Training a new barista
Consistency checks
Once a week, the lead tastes a flat white from each barista. Note what to adjust, kindly and specifically.
Example
The Guatemala on its second day ran 25 seconds and tasted thin at 40 grams out. The barista should have cut the yield to 36 grams before changing the grind, and the log now shows that for the next person.
Logging waste
Reading the log weekly
Pars and ordering
Order days
Late or short deliveries
An order still Placed after its arrival date shows under Overdue. Call the vendor the same morning and decide what to swap or take off the board.
Receiving
Check the delivery against the order, look at dates on milk, and put new stock behind old stock. Set the order to Arrived with the date.
Example
Unsold croissants appear twice in the last week. The owner drops the croissant par on Mondays from 24 to 18 and watches whether they sell out before 2 pm.
Daily
Weekly
Water
Hard water damages machines faster than anything else. Change the water filter on schedule, often every three to six months, and write the date on the equipment.
Scheduled service
The equipment list shows Days to service; anything past due is on the overdue list.
When something breaks
Cleaning products
Use the cleaner the machine maker recommends, at the strength on the label. Too much leaves a taste; too little leaves oils that turn rancid and make every shot bitter.
Spare parts on the shelf
Group gaskets, shower screens, a steam wand tip, grinder brushes, a spare portafilter basket, and the technician's number on the wall.
Example
The main grinder is 10 days past its service date and now drifts during the rush. Service is booked; until then the decaf grinder is set up with the house blend as a backup.
The lists
How the numbers work
Your first week
The daily rhythm
Weekly
Count supplies, check what to order, compare waste by item, and look at the dashboard for margin and sales.
Example
After the lunch rush the house blend ran fast and tasted sour at 26 seconds. The barista tightened the grind one step and logged it, and the afternoon shots came back to balanced.
What's inside
7 tables · 21 views · 1 form · 2 row actions · 1 agent7 pages
- Coffee Shop Operations
- Dashboard
- Opening and closing checklist
- Dialing in and training baristas
- Waste and ordering routine
- Machine care and service
- Start here
6 tables
- Menu2 views · 13 sample rows
- Supplies2 views · 11 sample rows
- Waste log4 views · 9 sample rows
- Equipment6 views · 7 sample rows
- Orders6 views · 7 sample rows
- Dial-in log1 view · 7 sample rows
Questions
- What is included in the Coffee Shop Operations template?
- 7 pages (Coffee Shop Operations, Dashboard, Opening and closing checklist, Dialing in and training baristas, Waste and ordering routine and 2 more) and 6 tables (Menu, Supplies, Waste log, Equipment, Orders and 1 more), filled with 54 sample rows so every view opens with realistic data.
- Who is the Coffee Shop Operations template for?
- Independent coffee shops and cafes.
- Is the Coffee Shop Operations template free?
- Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
- Can I change the template after I use it?
- Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.
Related workspaces
Boutique Hotel DeskFor innkeepers: rooms, reservations, housekeeping status, repairs, occupancy and ADR.
Brewery Taproom DeskFor brewers and taproom managers: batches, tanks, kegs, tap list, distributor orders.
Catering Business DeskFor caterers: proposals, event orders, prep and pack lists, food and labor cost per event.
Food Truck OperationsFor food truck owners: stops, sales, menu food cost, permits, commissary prep, bookings.
Restaurant Operations HubFor chefs and restaurant owners: recipe costs, food cost, pars, prep lists, inspections.
Small Bakery DeskBake to par and pre-orders, cost recipes, take cake orders and run wholesale accounts.