The In-House Guest Ledger Report displays the guest, booking and folio details for all In-house (active) guests. This means that guests must be checked in and active to appear on this report.
Because it is a running list of in-house guests, the report does not provide a date picker and will show all guests with status "active" regardless of arrival date. When the guest checks out and is no longer in-house, the booking will drop off this report.
The In-House Guest Ledger Report is useful for seeing a summary of current balances due and can be used in conjunction with Managers and Accounting Reports. For example, Use the In-house Guest Ledger Report with theTransactions Report to help account for the difference between any amounts charged and payments received on a specific date. This is typically due to things like advanced deposits made, payment of a booking at check in and advanced charge made to a future booking. These transactions often occur on different dates than the actual room rent for the booking is charged.
This report is also helpful to identify Long Term Stay and Extended Stay guests needing additional payments. For example, if the Folio Balance is negative, then the property is in fine shape with a balance the guest is still 'working off'. But as this negative gets closer to $0, the property visually sees who needs their Folio paid or approached for a follow up payment to get extra 'credit'.
To create an In-House Guest Ledger Report:
- Go to REPORTS | DAILY REPORTS
- Click on In-House Guest Ledger
- Choose Sort Term: Sort the Report by Room, Room Type, Booking # or Arrival Date
- Choose the report format: HTML, Excel or Text.
- Click Generate Report
The In-House Guest Ledger Report displays the following information:
- Room #: Room assignment of booking
- Room Type: Description of Room Type.
- Name: Name of Guest
- Payment Type: Payment method chosen in Guaranteed by
- Avg Nightly Rate: Average Rates for all nights of the booking.
- Adults: # of Adults
- Children: # of Children
- Infants: # of infants
- Confirmation #: Confirmation # of booking
- Group: Group Name if part of a group booking
- Grp Master Balance: Balance of Group Master Folio if part of a group booking
- Proj Income: Projected total of booking including tax.
- Deposits Paid: Any deposits made or payments taken
- Folio Balance: Current balance of folio
- Second Bal: Balance of additional folios if added.
- Auth Amount: (MyCard Users) Amount authorized on credit card if applicable.
- Arrival Date: Arrival date of booking
- Departure Date: Departure date of booking
See an example: In House Guest Ledger Report
Overview
Content Tools
