Profit and Loss Statement Template Restaurant

Standard Operating Procedure: Restaurant Profit & Loss (P&L) Statement Generation

1. Document Control Block

---

2. Executive Summary & Purpose

The objective of this SOP is to standardize the reporting of financial performance for Template Registry clients in the hospitality sector. This protocol ensures uniform categorization of COGS (Cost of Goods Sold), labor, and overhead, enabling accurate margin analysis and operational decision-making.

---

3. Scope & Prerequisites

• Scope: Monthly financial reporting cycle.
• Required Tools: Template Registry P&L Master Template (Excel/.csv), POS Export, Payroll Summary, Invoice Management System.
• Software: Microsoft Excel (v.2019+), Accounting Software (QuickBooks/Xero/Sage).
• PPE: N/A (Digital environment).

---

4. Roles & Responsibilities (RACI)

---

5. Step-by-Step Procedure

Phase I: Data Aggregation

• Export Gross Sales from POS (Categorized by Food, Liquor, Beer, Wine, N/A Bev).
• Import Payroll Summary (Segregated by FOH, BOH, Management, and Taxes/Benefits).
• Aggregate all vendor invoices for the reporting period.

Phase II: Categorization & Computation

• Calculate COGS: (Beginning Inventory + Purchases - Ending Inventory).
• Calculate Prime Cost: (COGS + Total Labor).
• Input Fixed Costs: Rent, Insurance, Utilities, Licenses.
• Input Variable Costs: Marketing, Repairs, Maintenance, Credit Card Fees.

Phase III: Review & Validation

• Verify that Net Profit reflects (Total Revenue - Total Expenses).
• Perform variance analysis against the previous month and the same period last year (YoY).
• Audit for unclassified transactions ("Misc" or "Other" expenses must be < 2% of total).

---

6. Quality Assurance & Pro-Tips

Key Performance Thresholds (Industry Benchmarks)

• Prime Cost: Should ideally track between 55%–60% of total sales.
• COGS: Food (28–32%), Liquor (18–22%), Beer (20–25%).
• Occupancy Costs: Must remain below 10% for long-term viability.

Pro-Tips

• The "Zero-Tolerance" Rule: Never use the "Miscellaneous" expense category. If an expense is recurring, create a new line item.
• Accrual vs. Cash: Always utilize the Accrual Basis to match expenses to the period the revenue was generated, regardless of payment date.

---

7. Frequently Asked Questions

Q: Why does my Prime Cost fluctuate drastically month-to-month? A: Usually, this is due to inconsistent inventory counting intervals. Ensure your beginning and ending inventory counts are synchronized with the first and last day of the calendar month.

Q: How do I handle "comped" meals or staff discounts? A: These should be logged as "Promotional Expenses" or "Staff Meals" rather than simple COGS reductions, to prevent skewing your actual food cost percentage.

---

Julian Vance Chief Architect, Template Registry