Restaurant Income Statement Template

Start by downloading the .xlsx file and opening it in Excel or Google Sheets — no macros or add-ins needed. Open the Monthly Income Statement sheet and review the pre-loaded categories. Most restaurants will keep the structure as-is: adjust the revenue line items to match your channels (add a line for gift card redemptions, remove catering if it's not applicable), and tweak any operating expense labels that don't match your chart of accounts. This initial setup takes 10–15 minutes and you only do it once.

Each month, enter your actual revenue and expense figures from your POS reports and bank statements. Start with revenue totals at the top, then work down through food cost and beverage cost, then labor by department, then the fixed and semi-fixed expenses at the bottom. The gross profit, prime cost, EBITDA, and net income lines calculate automatically. Once the monthly sheet is complete, the Annual Summary and Key Ratios sheets update without any extra steps.

The real value comes from reviewing the Key Ratios sheet after you enter each month. If your food cost percentage crept above 34%, you can trace it to a specific category and act — adjust ordering quantities, renegotiate with a supplier, or check for waste. If prime cost pushed past 65%, that's a signal to look at scheduling before the next pay period. Restaurant operators who review their income statement monthly rather than quarterly catch margin problems while they're still manageable, not after they've already hit the bottom line.

Restaurants operate on margins that leave almost no room for error. Average net margins in food service run 3–9%, which means that a food cost running 3 percentage points above target — $3,000 overspent on a $100,000 revenue month — can cut your net income in half. The income statement is where these numbers show up. Without one, you're flying on gut feel and bank balance, which is why so many restaurants that are busy and full still struggle at the end of the quarter.

A restaurant income statement follows a specific structure that's different from generic business P&Ls. Revenue is split by channel because food, beverage, catering, and delivery have different margin profiles. COGS is split between food cost and beverage cost because they're managed separately — a wine list running at 30% beverage cost is a different problem from proteins running at 38%. Below the gross profit line, labor is the biggest variable expense and needs its own breakdown by department. Prime cost — the sum of food cost and labor as a percentage of revenue — is the single number most operators watch most closely. Industry rule of thumb: prime cost should stay below 65% for full-service restaurants and below 60% for fast-casual.

The income statement becomes a management tool when you use it to set targets, not just record results. Before each month, project your expected revenue and set a food cost percentage target based on your menu mix. At month-end, compare actuals to those targets — not just dollar amounts, but percentages. If revenue came in 10% below plan, your fixed costs will hurt more than projected. If food cost percentage held but labor percentage jumped, you staffed up for a volume that didn't materialize. These are the patterns that a properly structured restaurant income statement makes visible, month after month.