Help Center

Free Restaurant Profit & Loss Template

Enter your monthly revenue and expenses to instantly see your profit & loss breakdown, prime cost percentage, and net margin.

Download a free Excel template with a built-in 12-month tracker.

Revenue
$
$
$
Cost of Goods Sold (COGS)
$
$
Labor Costs
$
$
$
Operating Expenses
$
$
$
$
$
$
Monthly P&L Summary
$0
Total Revenue
$0
Total COGS
$0
Total Labor
$0
Prime Cost %
Revenue $0 100%
Food & Bev Cost (COGS) $0 0%
Gross Profit $0 0%
Labor Costs $0 0%
Operating Expenses $0 0%
Net Profit / Loss $0 (0%)
Menubly Logo

Create Free Online Menu for Restaurants

Turn your paper menu into an interactive online menu that your customers can browse and order from anywhere.

What You Can Do With This Restaurant P&L Template

  • Calculate your net profit or loss — Enter your monthly revenue and all expense categories to see exactly what you’re keeping after every bill is paid.
  • Track prime cost in real time — The template auto-calculates your prime cost (food + beverage cost + labor), so you always know if you’re inside the healthy 55–65% range.
  • Break down costs as a percentage of revenue — Every line item shows as both a dollar amount and a % of sales, making it easy to spot which costs are eating into your margin.
  • Compare food vs. beverage performance — Revenue and cost are split by category so you can see which part of your menu is most profitable.
  • Identify problem areas instantly — Color-coded results flag when your labor, food cost, or prime cost is above industry benchmarks so you know exactly where to act.
  • Copy and share your P&L summary — Hit the Copy Results button to grab a clean text summary you can paste into a report, email to your accountant, or save for your records.

How to Use the Restaurant P&L Template

  1. Enter your monthly revenue: Fill in your food sales, beverage sales, and any other income (catering, merchandise, private events) for the month. Pull these numbers from your POS system’s sales report — use net sales (after discounts and comps), not gross sales. If your POS breaks down food vs. beverage sales separately, use those exact figures. If not, check your product mix report or estimate based on your menu categories.
  2. Enter your cost of goods sold (COGS): Input your actual food cost and beverage cost for the month. The most accurate way to calculate this is: beginning inventory + purchases during the month − ending inventory = actual COGS. Don’t just use your total food orders — that’s what you bought, not what you used. If you haven’t done an inventory count yet, start with your total purchases as an estimate, then switch to the inventory method next month for accuracy.
  3. Enter your labor costs: Add front-of-house wages (servers, hosts, bartenders, bussers), back-of-house wages (line cooks, prep cooks, dishwashers), and payroll taxes/benefits separately. Pull wage totals from your payroll processor. For payroll taxes and benefits, include FICA (7.65% of gross wages), federal and state unemployment tax, workers’ compensation insurance, and any health benefits you provide. A common mistake is entering just the wage amount and missing 10–15% in additional payroll costs.
  4. Enter your operating expenses: Fill in rent, utilities (gas, electric, water, trash), insurance (property, liability, liquor), marketing and advertising, supplies and disposables (napkins, to-go containers, cleaning supplies), and any other monthly overhead. Pull these from your bank statements or accounting software. If you pay any expense quarterly or annually (like insurance), divide by the number of months it covers and enter the monthly amount so your P&L reflects the true monthly cost.
  5. Review your P&L breakdown: Hit Calculate P&L to see your gross profit, net profit or loss, prime cost percentage, and a visual breakdown of every major cost category. Pay special attention to three numbers: your food cost percentage (target: 28–35%), your total labor percentage (target: 28–35%), and your prime cost percentage (target: under 65%). If any of these are outside the healthy range, that’s where to focus your attention first.
  6. Download the Excel template: Click Download Excel Template to get a professional spreadsheet you can save and reuse. The Excel file includes three tabs: a Monthly P&L (pre-filled with your numbers), a 12-Month Tracker for year-round monitoring, and a How to Use guide with industry benchmarks. Yellow cells are editable — all other cells auto-calculate with built-in formulas.
  7. Set up a monthly routine: The real value of a P&L comes from consistency. Schedule 30 minutes at the end of each month to update your numbers. Compare this month’s percentages to last month’s — if food cost jumped from 31% to 36%, investigate whether it’s a pricing issue, waste problem, or supplier price increase. Over time, you’ll build a clear picture of your restaurant’s financial trajectory and can make data-driven decisions about menu pricing, staffing levels, and expense cuts.

What Is a Restaurant P&L Statement?

A restaurant profit and loss statement (also called an income statement or P&L) is the financial document that shows your total revenue, total expenses, and net profit or loss for a specific period — usually a month or a year. It’s the single most important financial report you can run on your restaurant.

Unlike a bank balance, which only tells you what’s in your account right now, a P&L tells you how your business made or lost money. It shows which cost categories are in line and which are out of control. A restaurant owner who reads their P&L monthly can catch a food cost creeping above 35% before it becomes a profitability crisis — one who doesn’t often only finds out when cash is already short.

Every restaurant P&L is built around four core components:

  • Revenue — All money coming in: food sales, beverage sales, catering, merchandise, and any other income streams.
  • Cost of Goods Sold (COGS) — What you paid for the ingredients and beverages you sold. Subtract COGS from revenue to get your gross profit.
  • Labor Costs — Wages, salaries, payroll taxes, and benefits for all staff. Combined with COGS, this is your prime cost.
  • Operating Expenses — Everything else: rent, utilities, insurance, marketing, supplies, repairs, and miscellaneous overhead.

Net profit (or loss) is what’s left after all four categories are accounted for. That’s the number that determines whether your restaurant is sustainable — or whether changes need to happen fast.

Restaurant P&L Benchmarks: What the Numbers Should Look Like

Knowing your numbers is only useful if you know what good looks like. Use these industry benchmarks as a guide when reviewing your P&L. If any line is significantly outside the typical range, that’s your signal to dig deeper.

P&L Line ItemTypical Range (% of Revenue)Red Flag
Food Cost28–35%> 35%
Beverage Cost18–24%> 28%
Total Labor (all-in)28–35%> 38%
Prime Cost (COGS + Labor)55–65%> 68%
Occupancy (rent + utilities)5–10%> 12%
Net Profit Margin3–9%< 2%

Quick-service and fast casual restaurants tend to land on the more favorable end of these ranges because labor is leaner and rent-per-cover is often lower. Full-service restaurants typically operate closer to the upper limits on labor. If your prime cost is above 68%, profitability becomes very difficult to sustain regardless of revenue volume — that’s where most struggling restaurants find themselves.

Use the free food cost calculator and restaurant profit margin calculator to dig deeper into individual line items after reviewing your monthly P&L.

How to Read Your Restaurant P&L (And What to Do With It)

Running the numbers is step one. Acting on what you see is what actually changes the business. Here’s how to work through a P&L result and turn it into decisions:

Start with revenue. Is this month’s revenue up, down, or flat compared to last month and last year? If revenue is down, understand why before blaming costs — a slow month in sales makes every cost percentage look worse even if nothing changed operationally.

Check your prime cost first. Add your total COGS and total labor and divide by revenue. If that number is above 65%, you have a prime cost problem. The fix lives in one of two places: your food cost, your labor cost, or both. Use the labor cost calculator to see where labor hours are running high.

Look at gross profit next. Gross profit (revenue minus COGS) tells you how much you have left to cover labor and overhead. If gross profit is healthy but net profit is thin, your operating expenses — rent, utilities, or admin — are likely the culprit.

Segment revenue streams. If you track food and beverage sales separately, you can calculate the cost ratio for each. A food cost of 32% might be acceptable, but if your beverage cost is running at 30% when it should be under 24%, that’s a specific target to address.

Compare month over month. A single P&L snapshot is useful. A series of monthly P&Ls is powerful. Trends tell you whether improvements are sticking or whether seasonal dips are expected. Keep a simple tracker — even just saving your monthly results from this tool — to build a picture of your restaurant’s financial health over time.

Once you know your numbers, pricing decisions become much clearer. Use the recipe cost calculator to make sure your menu items are priced to hit your target food cost percentage, and check the revenue calculator to understand what sales volume you need to hit your profit targets.

Common Restaurant P&L Mistakes

  • Only looking at the bank balance. Cash in the bank does not equal profit. A restaurant can be cash-positive one week and operating at a loss for the month. Your P&L gives you the real picture — the bank balance just shows what’s left after timing differences in payments.
  • Forgetting to include all labor costs. Many owners track wages but forget to add payroll taxes (typically 7–15% of gross wages), workers’ comp insurance, and health benefits. Leaving these out makes your labor cost look much lower than it really is — and your profit look much higher.
  • Mixing personal and business expenses. If personal expenses run through the business account, your P&L is useless for decision-making. Keep business finances completely separate, and only include operating expenses that are legitimately part of running the restaurant.
  • Using revenue instead of cost of goods for food percentage. Food cost percentage should always be calculated as food cost ÷ food revenue — not food cost ÷ total revenue. Mixing beverage sales into the denominator will make your food cost look better than it is and mask actual purchasing or waste problems.
  • Only running the P&L at year-end. Annual P&Ls are for tax time. Monthly P&Ls are for managing your business. A problem that shows up in October’s P&L can be fixed before the year is over. A problem you only see in March for the prior year is money already lost.
  • Not benchmarking against your own history. Industry benchmarks are a useful reference, but your own trend line matters more. If your prime cost was 62% last month and is 67% this month with the same revenue, something changed — and a month-over-month comparison will tell you what to investigate.

Putting Your P&L to Work: A Monthly Routine

The restaurants that stay profitable long-term aren’t necessarily the ones with the best food or the highest sales — they’re the ones with owners who review their numbers regularly and act on what they find. Here’s a simple monthly P&L routine that takes about 30 minutes:

  • Pull all revenue figures from your POS system at month-end.
  • Reconcile your COGS using your invoices and inventory count — not just what you ordered.
  • Pull total labor from your payroll processor, including taxes and benefits.
  • Add up all fixed and variable operating expenses from your bank statements.
  • Enter everything into this P&L template and note one thing that improved and one thing to address next month.

Once you’re tracking your P&L monthly, the next step is making sure your revenue side is as strong as possible. Menubly helps restaurants increase revenue without increasing overhead — by letting you take direct online orders with zero commission fees, so every dollar your customers spend goes directly to your bottom line, not to a delivery app. At $9.99/month, it’s one of the lowest-cost ways to add a new revenue channel that actually improves your P&L. Try it free for 30 days — no credit card required.

Free Restaurant P&L Template FAQs

A restaurant P&L (profit and loss) template is a structured format for recording your restaurant's total revenue and expenses over a set period — usually one month — to calculate your net profit or loss. It typically includes sections for food and beverage revenue, cost of goods sold, labor costs, and operating expenses.

Monthly is the minimum recommended frequency for a restaurant P&L. Many experienced operators run a simplified P&L weekly to catch cost spikes early. Running it only at year-end is a common mistake — by then, months of overspending can't be recovered.

Prime cost is your total cost of goods sold (food + beverage cost) plus your total labor cost. It's typically 55–65% of revenue. If your prime cost is above 65%, it's very difficult to cover overhead and still turn a profit.

Most restaurants target a food cost percentage between 28–35% of food revenue. Fine dining often runs 30–38%, while fast casual concepts target 25–30%. Anything consistently above 35% usually signals a pricing, portion control, or waste problem.

The average restaurant net profit margin is 3–9%. Full-service restaurants typically land between 3–5%, while fast casual concepts can reach 6–9%. A margin below 2% leaves very little buffer for slow periods or unexpected expenses.

A P&L shows revenue and expenses over a period to calculate profit or loss. A cash flow statement shows when actual cash moved in and out of your business. A restaurant can show a profit on the P&L but still have cash flow problems if large bills are due simultaneously.

The most effective methods are: align scheduling with forecasted covers, cross-train staff, reduce overtime with advance scheduling, and analyze sales-per-labor-hour by day-part to identify overstaffed periods.

Yes — this P&L template works for any food business including food trucks, cafes, bakeries, bars, and catering operations. The core expense categories apply to all, though benchmarks vary by business type.

Menubly is a free online menu builder for restaurants, cafes, food trucks, bakeries, bars, and service businesses. You can create an interactive digital menu, share it with a link or QR code, and accept online orders with built-in payments — all from one platform. Sign up at menubly.com to get started.