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

# Revenue Report

> Report Business Value This report helps you see all the revenue flow produced from both Front Office and POS modules combined under the department groups of all the departments marked as debit. * V...

Track all revenue generated across Front Office and POS departments — with Actual vs. Budget comparisons for Today, Month-to-Date, Year-to-Date, and Last Year, in a single report.

**Business Value**

* View total revenue across all FO and POS departments grouped by department group.
* Compare Actual vs. Budget for Today, Month-to-Date, and Year-to-Date in one view.
* Benchmark this year's performance against the same period last year.
* Filter by department to focus on specific revenue streams.
* Export as XLS, XLSX, ODS, or PDF for finance and operations teams.

**Use Cases**

* Night Auditor runs the report after posting to verify all revenue departments balanced correctly for the day.
* Finance Manager reviews Month-to-Date actual vs. budget at mid-month to flag departments falling behind.
* Revenue Manager exports the Year-to-Date view to compare this year's Room Revenue against last year.

**How It Works**

**Running the Report**

**Where:** Home → Reports → Income → Revenue Report

| **Parameter**         | **Description**                                                       | **Example**         |
| --------------------- | --------------------------------------------------------------------- | ------------------- |
| **Date**              | Posting Audit Date — the date you want to view revenue for.           | 2025-09-18          |
| **Department**        | Optional — filter the report to show specific department(s) only.     | Room Revenue, F\&B  |
| **Include Last Year** | Yes / No — show or hide the Last Year comparison columns.             | Yes                 |
| **Show Budget**       | Show / Hide — display or collapse the Budget columns in each section. | Show                |
| **File Type**         | Choose the export format.                                             | XLS, XLSX, ODS, PDF |

Available actions: Download — Preview — Print

**Reading the Report**

The report is grouped by department group. Each group shows its member departments as individual rows, followed by a bold Total row. The Grand Total row at the bottom consolidates all groups.

**Column groups displayed in the report:**

* Today — Actual and Budget for the selected Posting Audit Date.
* Month T.D — cumulative Actual and Budget from the 1st of the month to the selected date.
* Year T.D — cumulative Actual and Budget from 1 January to the selected date.
* Last Year — Day, Month, and Year comparisons (Actual and Budget) from the previous year.

Note: The Last Year section only appears when "Include Last Year" is set to Yes.

Note: Budget columns only appear when "Show Budget" is set to Show.

**Report Columns**

| **Column**                     | **Description**                                                           | **Example**                   |
| ------------------------------ | ------------------------------------------------------------------------- | ----------------------------- |
| **Dept. Code**                 | Unique code identifying the revenue department or group.                  | RO, FB, LAU                   |
| **Department**                 | Name of the department or department group row.                           | Room Revenue                  |
| **Today — Actual**             | Total actual revenue posted for the selected Posting Audit Date.          | 2,903.21                      |
| **Today — Budget**             | Budget target for the selected date (daily budget).                       | 0.00                          |
| **Month T.D — Actual**         | Cumulative actual revenue from the 1st of the month to the selected date. | 45,985.52                     |
| **Month T.D — Budget**         | Cumulative month-to-date budget target.                                   | 0.00                          |
| **Year T.D — Actual**          | Cumulative actual revenue from 1 January to the selected date.            | 84,295.77                     |
| **Year T.D — Budget**          | Cumulative year-to-date budget target.                                    | 0.00                          |
| **Last Year — Day**            | Actual revenue for the same day in the previous year.                     | 0.00                          |
| **Last Year — Day (Budget)**   | Budget for the same day in the previous year.                             | 0.00                          |
| **Last Year — Month**          | Month-to-date actual for the same period in the previous year.            | 0.00                          |
| **Last Year — Month (Budget)** | Month-to-date budget for the same period in the previous year.            | 0.00                          |
| **Last Year — Year**           | Full-year actual for the previous year (Jan 1 – Dec 31).                  | 987,111.79                    |
| **Last Year — Year (Budget)**  | Full-year budget for the previous year.                                   | 0.00                          |
| **Total \[Group]**             | Subtotal row for each department group (bold).                            | Total Room Revenue: 32,083.08 |
| **Grand Total**                | Sum of all department groups across all columns.                          | 32,083.08                     |

Note: All values use the base currency of the system. Currency conversion is applied automatically when needed.

## ***Update: 19 Feb 2026***

The Revenue Report now reflects Hijri daily budgets — showing accurate Today, Month T.D, and Year T.D budget figures per department.

**Hijri Daily Budget — Budget Column Behaviour**

When a Hijri daily budget is imported for a month, the Budget columns (Today, Month T.D, Year T.D) update their calculation as follows:

**When only a monthly budget is imported:**

* Today (Budget) = monthly budget ÷ number of days in the month
* Month T.D (Budget) = total imported monthly budget
* Year T.D (Budget) = sum of all months + days from 1 January to the selected date

**When a Hijri daily budget is imported for the month:**

* Today (Budget) = the imported budget for that specific day
* Month T.D (Budget) = sum of all imported daily budgets for that month
* Year T.D (Budget) = cumulative sum from 1 January, using Hijri daily budgets where available

**Example — Ramadan (30 days), Room Revenue department:**

**Monthly budget only:  Imported budget = 150,000**

→ Today (Budget) = 150,000 ÷ 30 = 5,000

→ Month T.D (Budget) = 150,000

**Hijri daily budget imported:**

Days 1–20: 5,000/day   |   Days 21–30: 6,000/day

→ Today (Budget) = the imported value for that specific day (5,000 or 6,000)

→ Month T.D (Budget) = (5,000 × 20) + (6,000 × 10) = 160,000

## ***Update: 27 Apr, 2026***

### **Multi Currency Support**

The Revenue Report now supports multi-currency output, converting all department amounts to any configured currency at the current exchange rate.

**Business Value**

* View revenue totals in any currency configured on the system — not just base currency.
* Speeds up reporting for multi-currency properties and international ownership groups.
* Includes Exchange Factor in the report output for full transparency on conversion rates used.
* Applies in both the standard Revenue Report and the Insights App Revenue Report.

**How It Works**

Where: Reports → FO →  Income → Revenue Report

**New Currency Parameter**

A Currency dropdown has been added to the report parameters:

* Single-select dropdown listing all currencies configured on the system.
* Defaults to the property's base currency — no change to existing behavior unless a different currency is selected.
* Help text displayed below the field: "Currency selected will be based on current exchange rate at time of report generation."

<img src="https://mintcdn.com/kwentra/eCGOv-HfyhNmBRpw/images/front-office/reports/income-reports/revenue-report/0c5880467c.png?fit=max&auto=format&n=eCGOv-HfyhNmBRpw&q=85&s=6dd5fa41b2c6c1f2a9fb4770cfb2bd30" alt="" width="1484" height="391" data-path="images/front-office/reports/income-reports/revenue-report/0c5880467c.png" />

**Effect on Report Output**

When a currency other than the base is selected:

* All department amounts — Today, Month T.D, Year T.D, Last Year — are converted to the selected currency.
* Conversion uses the current exchange rate at the time the report is generated.
* The report header now includes two additional parameter lines: Currency (selected currency name) and Exchange Factor (rate applied at generation time).
