In House Stay History Frequency Report (Cloud)
Every repeat stay is an opportunity to deliver a more personal experience. The In-House Stay Frequency Report shows each in-house guest along with their stay history—how many times they’ve visited, when they were last here, and how long it has been since their previous trip. With this insight, your team can recognize loyal guests and tailor their services accordingly.
Path: Front Office > Reports > Front Office > In-House Guests > In-House Frequency
Generating the Report
1. Choose the Report Type: Set the Report dropdown to In House Frequency.
2. Adjust the Filters to Refine Your Results. Use the filters to control which guests, groups, and folio details appear in the report.
- As Of: Select the date for which the in-house list should apply (defaults to today).
- Sort By: Choose how to order results (Guest Name, or Room Number).
- Include Groups: Choose how to handle group bookings using the drop-down options - Include, Exclude, or Groups Only. Then select a specific group from the list or keep All.
The Include C/O w/Bal option is visible in the filter panel, but does not apply to this report. It is used only with the primary In-House Guests & Groups report.
3. Refresh the Report. Click Refresh to load the results based on your filter choices.
Understanding the Report
This section helps you read the report more confidently by explaining the guest details, historical stay metrics, and visit patterns included for every in-house guest.
Guest & Stay Details
- Room: Current room number.
- Guest Name: Primary guest registered to the room.
- Arrive: Stay arrival date.
- Depart: Scheduled departure date.
Rate & Balance Information
- Rate: Nightly rate applied for the current stay.
- Balance: Current folio balance.
Stay History Metrics
- 1st (Stay): Date of the guest’s first recorded stay at the property.
- Stays: Total number of stays the guest has completed.
- Nights: Total number of nights the guest has stayed across all past visits.
- Room Revenue: Total room revenue the guest has generated from all past stays.
Tips & Use Cases
- Recognize Frequent Guests: Use the # Stays and Days Since Last fields to identify frequent visitors and tailor welcome messaging or amenities.
- Loyalty Program Opportunities: Spot guests hitting stay milestones and proactively engage them with loyalty promotions or upgrades.
- Operational Efficiency: Front-desk can view guest patterns to anticipate special requests, room preferences, or service needs for repeat visitors.
- Financial Review: Ensure high-frequency guests’ balances and payment methods align with their historical behaviour — anomalies may signal folk billing issues.
Still Need Help With This Topic?
Ask Yourself:
- Did I select the correct Report (Stay History & Frequency) and date filter?
- Is the guest current in-house (not a checked-out folio)?
- Do the # Stays and Last Arrive fields reflect the guest’s known history?
- Are the filters (Sort By, Group inclusion) set correctly?
- Are the balances and visit counts in line with expected guest behaviour?
Support May Ask You:
- Which date and filters did you apply, including group options and sorting?
- What are the numbers shown in the # Stays or Days Since Last fields for the guest?
- Is there a discrepancy between today’s stay and the guest’s last recorded departure?
- Did this issue appear before or after the audit?
Related Articles
Related Articles
FO Extended Stay Daily Occupancy Report (Cloud)
The Extended Stay Daily Occupancy Report provides a detailed breakdown of hotel performance by guest stay length. It separates short-term guests from extended stays, helping management analyze occupancy, revenue, and rate trends across different ...In House Guests & Groups Report (Cloud) 🎥
? Watch Video Managing who is currently staying at your property — and ensuring their folio information is accurate — is essential to smooth front-office operations. The report displays three distinct sections, each designed to highlight a specific ...In House Company Listing Report (Cloud)
Companies often play an important role in daily hotel operations, whether they provide negotiated business, direct billing, or regular corporate guests. The In-House Company Listing Report gives your team a clear view of all companies currently ...Room History Report (Cloud) 🎥
? Watch Video The Room History report provides a detailed overview of room postings, including room and tax charges, additional extras, early checkouts, and checked-in no-shows. It can be viewed for individual rooms or as an overall summary. Path: ...Locate In-House Guests (Cloud)
When you are managing front-office operations in Visual Matrix Cloud, having quick access to your list of in-house guests is essential for check-in/out workflows, room assignment changes, folio review or incident handling. This article shows you ...