Free Template
Coffee Shop Daily Sales Spreadsheet
A clean CSV template for logging daily sales — transactions, drinks, food, tips, average ticket and labor hours. Built so you can spot the days that actually pay rent.
| Date | Day | Transactions | Drinks sold | Food sold | Gross sales | Tips | Discounts | Refunds | Net sales | Avg ticket | Labor hours | Weather | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-06-01 | Mon | 212 | 238 | 61 | 1,842.50 | 184.00 | 12.00 | 0.00 | 1,830.50 | 8.63 | 38 | Sunny | Smooth open |
| 2026-06-02 | Tue | 198 | 221 | 52 | 1,704.20 | 162.00 | 8.00 | 6.50 | 1,689.70 | 8.53 | 36 | Cloudy | |
| 2026-06-03 | Wed | 245 | 274 | 70 | 2,108.40 | 201.00 | 14.00 | 0.00 | 2,094.40 | 8.55 | 40 | Sunny | Local event |
| 2026-06-04 | Thu | 221 | 248 | 63 | 1,902.10 | 175.50 | 10.00 | 4.50 | 1,887.60 | 8.54 | 38 | Rain | |
| 2026-06-05 | Fri | 289 | 318 | 84 | 2,486.30 | 240.00 | 18.50 | 0.00 | 2,467.80 | 8.54 | 44 | Sunny | Strong PM rush |
| 2026-06-06 | Sat | 342 | 381 | 104 | 2,994.20 | 298.00 | 22.00 | 8.00 | 2,964.20 | 8.67 | 46 | Sunny | |
| 2026-06-07 | Sun | 298 | 326 | 92 | 2,612.40 | 260.00 | 16.00 | 0.00 | 2,596.40 | 8.71 | 42 | Cloudy | Brunch heavy |
The four numbers that matter most
- Transactions: demand signal, independent of pricing.
- Average ticket: reveals upsell health (target +$0.50 YoY).
- Sales per labor hour: the most honest productivity metric.
- Net sales: after refunds and discounts — the only line that pays bills.
How to use it (5-minute closeout)
- Pull the day's totals from your POS Z-report.
- Drop them into the row for today.
- Log labor hours from the schedule (actual, not scheduled).
- Add one weather + one notes word — patterns emerge in a month.
When the spreadsheet stops scaling
At about 60 days of logging, the spreadsheet stops being a closeout tool and starts being a chore. Coffee Shop Dashboard pulls these numbers from your POS automatically and turns them into the same view — minus the typing.