The five spreadsheets I’d set up in your first week if you hired me.
A P&L with benchmarks on every line, a labor schedule tied to your forecast, food cost variance, break-even, and a 13-week cash forecast. Built from the models I ran as a chain CFO, cut down for one to ten stores. Excel, no macros, $67 once.
P&L Template
Full restaurant P&L with budget, actual, and variance, revenue by channel, and a benchmark range beside every line. Prime cost, controllable profit, and 4-wall EBITDA calculate themselves. 232 formulas. You see which line is the problem without hunting for it.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Line | Actual | % Sales | Benchmark |
| 2 | Net Sales | $182,400 | 100.0% | — |
| 3 | Food COGS | $52,110 | 28.6% | 28-30% |
| 4 | Bev COGS | $8,940 | 4.9% | 18-22% |
| 5 | Total COGS | $61,050 | 33.5% | 30-33% |
| 6 | Labor Hourly | $41,900 | 23.0% | — |
| 7 | Labor Salary | $12,800 | 7.0% | — |
| 8 | Total Labor | $54,700 | 30.0% | 28-32% |
| 9 | Prime Cost | $115,750 | 63.5% | 60-63% |
| 10 | Occupancy | $14,600 | 8.0% | 8-10% |
| 11 | 4-Wall EBITDA | $28,300 | 15.5% | 15-20% |
Labor Scheduling & Cost Model
Weekly schedule for up to 15 positions, tied to your sales forecast, with sales per labor hour and labor % by daypart. A 13-week tracker with benchmarks by concept, and an overtime calculator that shows what one point of labor is worth in dollars. 219 formulas.
| Day | Fcst Sales | Target Hrs | Labor $ | Labor % | |
|---|---|---|---|---|---|
| 1 | Mon | $4,200 | 92 | $1,240 | 29.5% |
| 2 | Tue | $4,800 | 105 | $1,415 | 29.5% |
| 3 | Wed | $6,100 | 130 | $1,752 | 28.7% |
| 4 | Thu | $7,400 | 158 | $2,128 | 28.8% |
| 5 | Fri | $11,200 | 225 | $3,030 | 27.1% |
| 6 | Sat | $13,800 | 265 | $3,570 | 25.9% |
| 7 | Sun | $8,900 | 180 | $2,425 | 27.2% |
| 8 | Week | $56,400 | 1,155 | $15,560 | 27.6% |
| 9 | 1-pt improvement = | $564 | |||
Food Cost Calculator
Weekly food cost with ideal-versus-actual variance by category, a recipe costing sheet for plate-level margin, and a waste log. It shows where the slippage is coming from, not just that it exists. 135 formulas.
| Category | Theo COGS | Actual COGS | Variance | |
|---|---|---|---|---|
| 1 | Proteins | $8,420 | $9,110 | +$690 |
| 2 | Produce | $3,150 | $3,280 | +$130 |
| 3 | Dairy | $1,890 | $1,875 | -$15 |
| 4 | Dry Goods | $1,620 | $1,660 | +$40 |
| 5 | Bar / Alcohol | $2,340 | $2,390 | +$50 |
| 6 | Total | $17,420 | $18,315 | +$895 |
| 7 | Flag | Protein variance > 5% → audit portioning + waste log | ||
Break-Even Analysis
The sales you need each week to keep the lights on, with what-if tables for check average, food cost %, and labor %, and a 12-month actual-versus-break-even tracker. 210 formulas.
| Input | Value | |
|---|---|---|
| 1 | Monthly Fixed Costs | $42,800 |
| 2 | Variable Cost % | 65.5% |
| 3 | Contribution Margin % | 34.5% |
| 4 | Monthly Break-Even | $124,058 |
| 5 | Weekly Break-Even | $28,635 |
| 6 | Daily Break-Even | $4,091 |
| 7 | Current MTD Sales | $91,200 |
| 8 | Gap to Break-Even | $32,858 |
| 9 | Days Left in Month | 11 |
| 10 | Required Daily Sales | $2,987 |
13-Week Cash Flow Forecast
A rolling 13-week cash forecast with runway alerts, a 12-month forecast with seasonality, and a 30-vendor AP aging tracker. 281 formulas. The full treasury version, with debt service and covenants, is the separate 13-Week Cash Flow Model.
| Wk | Opening Cash | Inflows | Outflows | Closing Cash | |
|---|---|---|---|---|---|
| 1 | Wk 1 | $48,200 | $41,800 | $37,600 | $52,400 |
| 2 | Wk 2 | $52,400 | $44,100 | $42,900 | $53,600 |
| 3 | Wk 3 | $53,600 | $46,300 | $52,100 | $47,800 |
| 4 | Wk 4 | $47,800 | $45,900 | $61,400 | $32,300 |
| 5 | Wk 5 | $32,300 | $44,200 | $58,100 | $18,400 |
| 6 | Wk 6 | $18,400 | $47,800 | $42,600 | $23,600 |
| 7 | … | continues for 13 weeks with covenant + WC ratio dashboards | |||
Buy the tools
One-time payment. Yours forever. 30-day money-back guarantee.
Restaurant Financial Toolkit
- ✓ P&L Template
- ✓ Labor Scheduling & Cost Model
- ✓ Food Cost Calculator
- ✓ Break-Even Analysis
- ✓ Cash Flow Forecast (simplified)
Both Together
- ✓ Everything in the Toolkit
- ✓ Everything in the 13-Week Cash Flow Model
- ✓ Covenant + working-capital dashboards
- ✓ Lifetime updates
- ✓ 30-day money-back
13-Week Cash Flow Model
- ✓ 13-week rolling forecast
- ✓ Working capital ratios
- ✓ Covenant Dashboard
- ✓ Weekly Rollup
What these are built to catch
3-Unit Fast-Casual. The Cash Flow Model is built to surface a working-capital gap about 60 days out, which is the time an operator needs to renegotiate vendor terms before it becomes a payroll problem. Operators typically spot this kind of gap 4 to 8 weeks earlier with a rolling 13-week view than with a monthly P&L alone.
Single-unit full-service. The Labor Model is built to find a two-point labor slip by day. In the reviews I ran, the cause was usually Wednesday and Sunday overstaffing, not the servers the manager thought were slow. A reset from 30.1% to 27.8% inside a month is a typical result.
Mid-market chain. The P&L Template is built to be the standard weekly review across units. Every GM plots against the same benchmark column. It ends the argument that “our costs are structurally different”, because the benchmark is in the sheet.
Frequently asked
What format do these come in?
Every tool is a standard Excel file. No add-ins, no macros, no subscriptions. They open in Google Sheets, though some formatting may shift.
Will it work for a single location?
Yes. Built to work for one location and to scale to multi-unit reporting.
Mac or PC?
Both.
Is this a subscription?
No. One payment, yours forever, including future updates.
What if it isn’t for me?
Thirty days, full refund, no questions. Email admin@restaurantbottomline.com and it’s done.