> ## 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.

# Profit and Loss Detailed Report

> 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 p...

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**

| **Column**                       | **Description**                                            | **Example**  |
| -------------------------------- | ---------------------------------------------------------- | ------------ |
| \[Prior Year Month] – MTD Amount | Same month last year — month-to-date actual revenue amount | 761,355.64   |
| \[Prior Year Month] – MTD %      | Prior year MTD as a percentage of total department revenue | 85.43%       |
| Budget – Current Amount          | Budgeted revenue for the current month                     | 0.00         |
| Budget – Current %               | Current month budget as a percentage of total              | 0.00%        |
| Current Month Amount             | Actual revenue posted for the selected month               | 0.00         |
| Current Month %                  | Current month amount as a percentage of department total   | 0.00%        |
| Account                          | Account or line item name, grouped by category             | Rooms:Groups |
| YTD Amount                       | Year-to-date actual revenue as of the selected month       | 0.00         |
| YTD %                            | YTD amount as a percentage of department total             | 0.00%        |
| Budget – YTD Amount              | Year-to-date budgeted revenue                              | 0.00         |
| Budget – YTD %                   | YTD budget as a percentage of department total             | 0.00%        |
| \[Prior Year Month] – YTD Amount | Same period last year — year-to-date actual amount         | 891,240.52   |
| \[Prior Year Month] – YTD %      | Prior year YTD as a percentage of department total         | 100.00%      |