Skip to main content

Documentation Index

Fetch the complete documentation index at: https://help.kwentra.com/llms.txt

Use this file to discover all available pages before exploring further.

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
Where: Reports → BO → GI → Profit and Loss Detailed
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
ColumnDescriptionExample
[Prior Year Month] – MTD AmountSame month last year — month-to-date actual revenue amount761,355.64
[Prior Year Month] – MTD %Prior year MTD as a percentage of total department revenue85.43%
Budget – Current AmountBudgeted revenue for the current month0.00
Budget – Current %Current month budget as a percentage of total0.00%
Current Month AmountActual revenue posted for the selected month0.00
Current Month %Current month amount as a percentage of department total0.00%
AccountAccount or line item name, grouped by categoryRooms:Groups
YTD AmountYear-to-date actual revenue as of the selected month0.00
YTD %YTD amount as a percentage of department total0.00%
Budget – YTD AmountYear-to-date budgeted revenue0.00
Budget – YTD %YTD budget as a percentage of department total0.00%
[Prior Year Month] – YTD AmountSame period last year — year-to-date actual amount891,240.52
[Prior Year Month] – YTD %Prior year YTD as a percentage of department total100.00%