Detail Revenue Report : FAQ

Modified on Fri, 25 Apr at 1:54 PM

How to access the Manager Report ?

Please refer the below video :

What is the Detail Revenue Report?

The Detail Revenue Report provides a comprehensive breakdown of room-wise revenue data for a specific date range. It displays information related to each booking, including guest details, room charges, applicable commissions, and the final revenue recognized by the property.

What Information Does the Detail Revenue Report Include?
Each entry in the report includes the following:

Column	Description
Sr. No	Serial number for the list of bookings.
Guest Name	Name of the guest as per reservation or check-in details.
Source	The booking source (e.g., OTA, Direct, etc.).
Arrival/Dept.	Arrival and departure dates of the booking.
Nights	Total number of nights stayed.
Room	Room number and type.
Vou. No	Voucher number associated with the booking.
Rate Type	Meal plan or rate plan (e.g., EP, CP, AP).
Folio No	Folio number generated for billing purposes.
Room Rate (₹)	Base rate assigned per night.
Total (₹)	Gross total including any inclusions.
Commission (₹)	Commission deducted (if any, mostly for OTA bookings).
Total Revenue (₹)	Net revenue after deducting the commission. Revenue earned by the property.

What Do the Totals Represent?

Room Rate: Price assigned for the stay (per room, per night).
Total (₹): Sum of room rate and other applicable charges.
Commission (₹): Amount deducted as commission to OTAs or agents.
Total Revenue (₹): Revenue actually retained by the property.

Filters & Options

Filter / Option	Description
Date Type	Select `Booking`, `Stay`, or `Departure` to define how the date range is evaluated.
From - To	Choose the date range for the report.
Business Source	Filter data by the booking source.
Room	Filter by specific room numbers.
Show Only Unassign Rooms	Shows data for bookings without assigned rooms.
Discard Unconfirmed Bookings	Excludes unconfirmed reservations.
Show Unposted Inclusion	Includes unposted charges in the report.
Extra Charges	Filter by specific extra charges (e.g., Deposit, Extra Bed, Buffet).
Payment Method	Select which payment types to include (e.g., Cash, Card, Cheque).
Taxes	Select specific tax types like GST, CGST, IGST, etc.
Show Mobile No. / Email	Enable this if you want to export guest contact info.
Report Template	Use Default or customized templates.

Additional Notes

The Grand Total at the bottom reflects the cumulative Room Rate, Gross Total, Commission, and Net Revenue.
This report does not include payment details unless the "Include Payment Entries" option is enabled.( Option only Available in Stay Filter option )

Use Case

This report is essential for:

Auditing daily and period-based room revenue.
Analyzing channel performance and OTA commission impact.
Understanding net revenue received by the property.