Skip to main content
View detailed revenue and budget performance by department, comparing current month, YTD, and prior year figures in one report. Business Value
  • Monitor each department’s revenue against budget and prior year in one report.
  • Compare current month, YTD, and prior year MTD/YTD side by side.
  • Filter by department to focus on Rooms, F&B, Laundry, or other areas.
How It Works Running the Report Set the following parameters before running the report:
  1. Date — Select the month and year (e.g., 04/2026). The report shows data for that full month.
  2. Department — Select one or more departments (e.g., Food & Beverage Dep, Guest Laundry Dep.). Leave blank to include all departments.
  3. Zero Balance — Choose Don’t Show (default) to hide accounts with no activity, or Show to include all GL accounts.
  4. Detail Level — Select Detailed for a full line-by-line breakdown, or Summary for department totals only.
  5. File Type — Select XLS, XLSX, ODS, or PDF.
Available actions:
  • Download — saves the report in the selected file format.
  • Preview — opens the report in the browser without downloading.
  • Print — sends the report directly to the printer.
Report Layout The report is organized by department. Each department section repeats the same column structure:
  • Rows show individual revenue accounts (e.g., Rooms:Groups, Food:Extra Lunch, LND:Guest Laundry).
  • Accounts are grouped into categories with subtotals (e.g., Total Rooms Revenue, Total Food & Beverage Extra).
  • Each department closes with a total row (e.g., Total Rooms Dep, Total Food & Beverage Dep).
  • The report ends with Total Hotel Revenue, Total Hotel Expenses, and G.O.P. (Gross Operating Profit = Rev - Expense).
Report Columns