What the month adds that the week can’t see
Weekly prime cost runs the engine. It tells you whether food and labor — the two numbers you can move from week to week — are in the band that lets the rest of the model survive. Whatever lands at 60% prime cost on Tuesday morning has done its job for the week.
The month adds the rest. Rent and CAM and property tax. Insurance premiums and the licenses you renew once a year and amortize across twelve months. The salaried bookkeeper. The credit-card processing fees that follow your sales mix. Utilities that run hot in summer and quiet in spring. The accountant’s monthly invoice. None of those land on the weekly worksheet because they don’t move week to week — but they’re what turns a healthy 60% prime cost into either a profitable month or a flat one.
The monthly P&L is the sheet that pulls all of those lines back onto the page. The weekly verdict tells you the engine works. The monthly verdict tells you the building can keep the doors open.
The three numbers operators conflate
Most independent operators look at one number every month and call it “profit.” The number is usually wrong because three different things are wearing the same word.
Operating profit is what the sheet returns — sales minus prime cost minus variable costs minus fixed costs, before taxes. It’s the answer to the question “did the restaurant earn money this month.” A healthy independent full-service restaurant lands here at 8–15% of sales; coffee bars and counter-service can run higher. Numbers below 5% are warning territory; negative numbers are the signal to act.
Cash flow is what hit the bank account. It is not operating profit, because timing is real. A month where you bought ten cases of wine on Net 30 has cash flow that looks healthier than its operating profit; a month where the lease renewal landed alongside an insurance premium has cash flow that looks worse. Operators who confuse the two end up surprised by either how much cash is in the account (and spend it) or how little (and panic). The sheet returns operating profit; your bank statement returns cash flow. Read both.
Owner’s pay is what you took out. If you are the operator-owner and you draw a salary, that salary is in the labor line of the P&L — it’s a cost. If you also took distributions, those are not in the P&L — they’re cash out of the business after profit. The most common silent error in independent restaurants is treating distributions as if they were a cost (so they reduce the “profit” you report) or treating the operator’s salary as if it weren’t (so the labor line under-counts what the business actually pays). Pick one rule and run it consistently. The sheet’s convention is salary in labor, distributions are cash flow.
The four lies in monthly costing
Like the weekly worksheet, the monthly snapshot has its own list of common silent errors. The shape is similar, the lines are different.
Skipping the slow lines. Insurance, license fees, accountant retainer, the website host, the POS support contract, the monthly bank fees. None of them are big; together they run 2–4% of sales for most independents. Operators who skip them produce a P&L that looks 3% more profitable than it is, and three percent over a year is the difference between hiring a sous chef and not.
Mis-allocating depreciation. The walk-in you bought for $14,000 last year isn’t a $14,000 expense the month you bought it — it’s about $230 a month for five years. Operators who book the full $14,000 in the buying month produce a wildly negative month and then a falsely-bright year. Talk to your accountant once and set a depreciation rule for big purchases; the sheet’s “other fixed” line is where you put the monthly amortized share.
Ignoring the rent reset. Most leases include an annual or biannual rent escalation. The clause is in the lease; the operator forgot it. The first month of the new rate is the operating-margin event you didn’t see coming. The rent slider on the sheet is the way to surface this scenario early; if your lease renews this October at +6%, slide it now and read what the next quarter looks like at the new rate.
Calling owner-pay “profit.” The chef-owner who pays themselves $5,000 a month and books that as a distribution rather than salary is hiding a real cost. If you took the chef-owner out of the kitchen tomorrow, would you have to hire a chef? Yes. The chef-owner’s pay is labor. The same is true for the GM-owner who runs the floor. Counting your own labor at zero makes every other number lie.
Reading the bands and the breakeven number
The sheet returns three numbers: prime cost as a percent (the same one the weekly worksheet returns, just over a longer window), contribution margin as a percent, and operating profit in dollars and as a percent.
Prime cost on the monthly should match the four-week trailing average from your weekly worksheets — if it doesn’t, somebody’s arithmetic is off, and the monthly is usually right because it pulls from receipts. Use the discrepancy as a check on the weekly cadence; the gap should be under 1.5 percentage points.
Contribution margin — what’s left after prime cost and variable costs — tells you how much of every sales dollar is available to cover fixed costs. Healthy contribution runs above 30%; below 25% is yellow band, below 20% is red. Contribution margin is the lever you have most control over (it tracks prime cost) and the one most worth watching when fixed costs are about to move.
Operating margin is the verdict. The sheet also returns a breakeven sales-per-day number — the number you have to do every operating day to cover fixed costs at this contribution rate. The breakeven number is the most useful single metric on the sheet, because it tells you what bad days actually mean. If your breakeven is $3,800 a day and Tuesdays do $2,400, your Tuesdays are losing you $1,400 each. The fix isn’t marketing on Tuesday; the fix is closing on Tuesday, or running a lighter Tuesday menu, or adjusting your fixed costs so the breakeven moves.
The lease-renewal scenario
The rent slider is the sheet’s most important control. Most independent restaurants close because the rent reset they didn’t plan for hit a model that was already running tight. Slide the rent up 8% and read the operating margin that comes back; if it goes red, you have time to do something about it.
The thing to do depends on how much warning you have. Six months out, the move is to renegotiate the lease — landlords on commercial property are not eager to lose a paying tenant, and a phone call with “the math at the proposed rate doesn’t support staying” usually opens a conversation about a smaller bump or a longer term in exchange for the rate. Three months out, the move is to harden the contribution margin: tighten the menu, raise the three highest-volume prices to the charm-up number, run the recipe-cost-card on the next quarter’s ingredients before vendor drift compounds. One month out, the only move is to cut a fixed-cost line you can actually cut — the cheaper insurance broker, the smaller marketing subscription, the bookkeeper’s hours.
The sheet doesn’t make the lease decision for you. It tells you what the lease decision actually costs.
Open the sheet: Monthly P&L Snapshot →
Pull last month’s receipts. Run the rent slider. The math runs in your browser; your numbers never leave the page.