> ## 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 by Date Report

> See revenue by department for a date range, with the gross value, each tax and the net value.

The Revenue by Date report shows revenue by department for a date range, with each tax split out.

### **Business Value**

* Shows the gross value, the tax and the net value for each department.
* Splits the tax into one column per tax, such as VAT and city tax.
* Can show the revenue of one room or a few rooms only.
* Totals each department group and the whole report.

### **Use Cases**

* An income auditor checks the tax on each revenue department for the month.
* A revenue manager reviews the revenue of a few rooms over a date range.
* An accountant checks the net revenue before posting it to the ledger.

### **How It Works**

| **Where:** [Reports → FO → Income → Revenue by date](https://manage.kwentra.com/reports/Income/Revenue%20by%20date/) |
| - |

#### **Running the Report**

1. **From date** and **To date**: pick the audit dates to cover. The Hijri date shows under each field.
2. **Room number**: choose one or more rooms. Leave it empty to include all rooms.
3. **Department**: choose one or more departments. Leave it empty to include all departments.
4. **File type**: **XLS** (the default), **XLSX**, **ODS** or **PDF**.
5. Click **Preview**, **Download** or **Print**.

<img src="https://mintcdn.com/kwentra/jqR1oXmrWUQvlL_W/images/front-office/reports/income-reports/revenue-by-date-report/revenue-by-date-report-room-filter.png?fit=max&auto=format&n=jqR1oXmrWUQvlL_W&q=85&s=4c05505e55afaa65ebd65c7882cdcf9a" alt="Revenue by date filters with the Room number list open and rooms 302 and 304 selected" width="1820" height="335" data-path="images/front-office/reports/income-reports/revenue-by-date-report/revenue-by-date-report-room-filter.png" />

#### **Report Layout**

* The rooms you picked show at the top, under **Room number**.
* Departments are grouped under their department group, for example **100 Accommodation**.
* Each group ends with a **Total** row, for example **Total Accommodation**.
* The last row, **Grand total**, adds up every column.

<img src="https://mintcdn.com/kwentra/jqR1oXmrWUQvlL_W/images/front-office/reports/income-reports/revenue-by-date-report/revenue-by-date-report-columns.png?fit=max&auto=format&n=jqR1oXmrWUQvlL_W&q=85&s=b538ca3c554b368479a36a1db6855188" alt="Revenue by date report showing all columns, group totals and the Grand total" width="1310" height="758" data-path="images/front-office/reports/income-reports/revenue-by-date-report/revenue-by-date-report-columns.png" />

[Download a sample report (XLSX)](/images/front-office/reports/income-reports/revenue-by-date-report/revenue-by-date-report-sample.xlsx)

| **Note:** The sample uses test data. The hotel and user names are not real. |
| - |

#### **Report Columns**

| Column | Description | Example |
| - | - | - |
| **Department code** | The department code. On a group row, the department group code. | 110 |
| **Department name** | The department name. On a group row, the department group name. | Room Groups |
| **Gross value** | The revenue including tax. | 3142.50 |
| *(one column per tax)* | The tax amount for each tax department, for example **City Tax 5%** or **Vat Output 15%**. | 130.12 |
| **Total** | The total tax: all the tax columns added up. | 540.02 |
| **Net value** | The revenue before tax: **Gross value** − **Total**. | 2602.48 |

| **Note:** The tax columns come from your hotel's tax departments. They are different for each hotel. |
| - |

For payments, revenue and tax on one page, use the [Income Summary Report](/front-office/reports/income-reports/income-summary-report).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.