Revenue by Date Report - kwentra Help Center

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

Running the Report

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

Revenue by date filters with the Room number list open and rooms 302 and 304 selected

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.

Revenue by date report showing all columns, group totals and the Grand total

Download a sample report (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.