Hotel Profit and Loss Statement Template

Standard Operating Procedure: Hotel Profit and Loss (P&L) Statement Generation & Financial Reconciliation

---

1. Executive Summary & Purpose

This Standard Operating Procedure (SOP) defines the institutional framework for generating, auditing, and reconciling the Profit and Loss (P&L) statement for hospitality assets managed under Template Registry operational standards. Adherence to this protocol ensures strict compliance with the Uniform System of Accounts for the Lodging Industry (USALI, 11th Revised Edition), eliminates reporting variance, and provides stakeholders with auditable, high-fidelity operational intelligence.

---

2. Scope & Prerequisites

2.1 Scope

This document governs all financial reporting cycles (daily flash, monthly close, and annual audit) across select-service, full-service, and luxury hospitality assets within the Template Registry portfolio.

2.2 Prerequisites & Tools

• Property Management System (PMS): Enterprise-grade interface (e.g., Opera Cloud, Infor HMS) for operational revenue extraction.
• Point of Sale (POS) Systems: Simphony, Revel, or equivalent for F&B revenue tracking.
• Enterprise Resource Planning (ERP) / Accounting Software: Infor SunSystems, Sage Intacct, or Oracle NetSuite configured to USALI departmental charts of accounts.
• Spreadsheet Environment: Microsoft Excel (Office 365) or Google Workspace with locked formula protection and Template Registry P&L Master Template v4.2.
• Hardware: Workstation equipped with dual-factor authentication (2FA) and encrypted local storage.

---

3. Roles & Responsibilities (RACI Matrix)

(Legend: R = Responsible, A = Accountable, C = Consulted, I = Informed)

---

4. Step-by-Step Procedure

Phase 1: Data Extraction and Night Audit Reconciliation

• 1.1 Execute the automated PMS End-of-Day (Night Audit) routine at 03:00 local time to lock room revenues, taxes, and ledger balances.
• 1.2 Export the Daily Revenue Report (Flash Report) detailing Rooms Revenue, F&B Revenue, Telecommunications, and Other Operated Departments.
• 1.3 Reconcile total PMS cash, credit card, and direct billing settlement drops against the General Cashier’s daily deposit log.
• 1.4 Flag any unassigned folios, routing errors, or out-of-balance city ledgers for immediate correction before posting.

Phase 2: Departmental Revenue & Expense Posting (USALI Compliance)

• 2.1 Post Rooms Department expenses (payroll, contract labor, operating supplies, guest amenities) to Accounts 6000–6999.
• 2.2 Post Food & Beverage Department revenues and cost of sales (COGS) based on daily inventory transfers and POS Z-reports to Accounts 7000–7999.
• 2.3 Aggregate Undistributed Operating Expenses across four core categories:
  • Administrative and General (A&G)
  • Information and Telecommunications Systems (IT)
  • Sales and Marketing (S&M)
  • Property Operations, Maintenance, and Energy (POMEC)
• 2.4 Verify that management fees, real estate taxes, insurance, and reserve for replacement (FF&E) are calculated in accordance with the underlying management and franchise agreements.

Phase 3: Month-End Adjustments and Accruals

• 3.1 Calculate and post month-end accruals for unbilled utilities, vendor invoices, and accrued payroll liabilities.
• 3.2 Run the monthly depreciation and amortization schedules for fixed assets and capitalized software.
• 3.3 Perform inter-departmental allocations (e.g., complimentary rooms, employee meals) via standard journal vouchers.
• 3.4 Lock the sub-ledgers (Accounts Receivable, Accounts Payable, Inventory) on Working Day +3 (WD+3) at 17:00.

Phase 4: P&L Statement Generation and Variance Analysis

• 4.1 Import trial balance figures into the Template Registry Master P&L Template v4.2.
• 4.2 Generate key performance metrics automatically:
  • GOP (Gross Operating Profit): Total Revenue minus Total Departmental & Undistributed Expenses.
  • AGP (Adjusted Gross Profit): GOP minus Management Fees and Non-Operating Income/Expenses.
  • EBITDA: Earnings before interest, taxes, depreciation, and amortization.
• 4.3 Conduct a budget-to-actual and prior-year-to-actual variance analysis for any line item exceeding a $\pm 5%$ and $\pm $5,000$ threshold.
• 4.4 Draft explanatory footnotes for all major variances to attach to the executive financial package.

Phase 5: Final Review, Sign-Off, and Distribution

• 5.1 The Financial Controller reviews all journal entries, reconciliation binders, and the drafted P&L statement.
• 5.2 The General Manager and Financial Controller execute digital sign-off within the ERP platform by WD+5.
• 5.3 Publish the final PDF and native Excel financial package to the Corporate Finance secure repository.

---

5. Quality Assurance & Pro-Tips

5.1 Critical Control Thresholds

• Trial Balance Variance: Must equal zero ($0.00). Unbalanced sheets will be automatically rejected by the ERP.
• Rooms Revenue Reconciliation: PMS-to-GL variance tolerance is strictly $0.00.
• F&B Cost of Sales Target: Maintain within $\pm 1.5%$ of budget benchmarks (typically 25%–30% of F&B revenue).

5.2 Pro-Tips & Best Practices

• Never Hard-Code: In the P&L template, all totals and KPIs must be driven by dynamic formulas referencing the trial balance import sheet. Hard-coded inputs will fail internal audit protocols.
• Pre-Close Reviews: Conduct a "mid-month flash review" on WD+15 of the prior period to catch tracking anomalies before the hard close.
• Maintain Audit Trails: Attach scanned vendor invoices and calculation worksheets directly to the journal entry line items in the ERP to streamline external audits.

---

6. Frequently Asked Questions (FAQ)

Q1: What should I do if the PMS revenue export does not match the General Ledger trial balance during month-end close?
A: Immediately halt Phase 3 execution. Run an audit trace in the PMS to identify unposted city ledger payments or late-night room charge routing errors. Check for inter-system interface timeouts between the PMS/POS and the ERP. Resolve the discrepancy and obtain Controller sign-off before reopening the sub-ledger.

Q2: How are undistributed operating expenses apportioned if a shared service supports multiple profit centers?
A: Apportionments must strictly follow the USALI guidelines—typically based on square footage, headcount, or direct departmental revenue ratios. Ensure the allocation methodology is documented in the property's annual accounting manual and applied consistently across all periods.

Q3: Where do we log non-operating income, such as damages recovered from guests or vending machine commissions?
A: Non-operating income must be segregated below GOP. Log guest damage recoveries as an offset to the respective repair/maintenance or room-supplies expense line, and record vending/atm commissions under "Miscellaneous Income" in the Non-Operating section per USALI standards.