Complete List of Reports Available in Visual Matrix (Cloud)

Complete List of Reports Available in Visual Matrix (Cloud)

THIS ARTICLE IS IN PROGRESS

Before Going through each Report

Before we go through all the reports that are available in Visual Matrix, it is important to define 2 terms:
- Dynamic: the report is updated with the activity in Visual Matrix;
- Static: once the report is created, it won't change.

Also, if you see Refresh on a report page, you need to click it, even if you already have some data on the screen.
That will make sure you have the most accurate and adjusted data.

Front Office > Reports > Front Office

Arrivals (Dynamic)

Shows any arrivals at a given period.
The report can also be:
- Groups only
- Specific Group(s)
- Pre-Reg only
- CRS only

You can choose to include or exclude the following:
- Already checked in rooms
- Groups
- Arrivals already checked in
- Rates
- CRS Comments
- Pre-Reg Notes

The report can be printed and exported as Excel, Word, or PDF.
By default, the report is set on the current day but you can choose another day.

Packages (Dynamic)

Shows any packages booked at a given period.
By default, the report is set on the current day but you can choose another day.
You can choose to include or exclude packages from groups and filter for specific packages.
You can choose to include or exclude any reservation already checked in.

The report can be printed and exported as Excel, Word, or PDF.
By default, the report is set on the current day but you can choose another day.

Departures (Dynamic)

Shows any departures at a given period.
You can choose to include or exclude already checked-out rooms.
The report can include or exclude groups or be group(s) only or for a specific group.

The report can be printed and exported as Excel, Word, or PDF.
By default, the report is set on the current day but you can choose another day. As a dynamic report, to show as a departure, a reservation needs to be checked in. It will not show future reservations that will be departing on a specific date.

In House Guests (Dynamic)

Shows any in-house room at a given period.
You can also choose to see the following reports:
- In house frequency
- Company Listing
- Parking Lot
- Charge verification
- Extra Locator
- Market Segment
- Driver's License

The report can be sorted by guest name or by room number.
The report can include or exclude groups or be group(s) only or for a specific group.
You can choose to include or exclude guest comments.
You can choose to include the rooms checked out with balance (recommended) (C/O w/Bal - To understand what are those checkouts, click HERE).

The report can be printed and exported as Excel, Word, or PDF.
By default, the report is set on the current day but you can choose another day. As a dynamic report, to show in-house, a reservation needs to be checked in. It will not show future reservations that will be in-house on a specific date.

Over Credit Limit (Dynamic)

Will show any rooms that have a balance not covered by a credit card authorization at a given period.
The report can be sorted by guest name or by room number.
You can choose to include or exclude any room with cash as a payment method and with a balance over 0.

The report can be printed and exported as Excel, Word, or PDF.

Two Weeks Forecast (Dynamic)

Shows a forecast for the next 2 weeks.
The report will show you:
- Number of arrivals
- Number of departures
- Total of rooms sold
- Occupancy percentage
- Number of adults
- Number of children
- Any included package

By default, the report will start on the current date but you can choose to start it at any future date.
The report can be printed and exported as Excel, Word, or PDF.

Operator Cash Out (Dynamic)

Shows all payments posted by each user and overall in the current day. The date is static and cannot be changed.
By default, the report is set on the logged-in user.
If you choose "all", it will give you the full report.
If you choose "multiple", it will give you to choose between the users who have posted some payments.
The report can be generated by:
- Operator ID (user)
- Category of payment (cash, check, or credit card)
- Payment Type Accounting Code

The report can only be printed.

Trans Log (Dynamic)

Trans Log for Transaction Log Report.
Shows all transactions posted on a given period.
By default, the report is set on the current day but you can choose another day.
The report can be generated by:
- User or for all users
- Type of posting: Payment, Revenue, Guest Ledger Balance
- Category: cash, check, credit card, movie, misc, room, tax, ...
- Accounting Code

The report can be printed and exported as Excel, Word, or PDF.

Downtime Reports (Dynamic)

This will print the following reports:
- Arrivals
- Departures
- In House
- Room Rack

Those reports are printed automatically.

Airport Schedule (Dynamic)

Shows all the drop-offs and pick-ups schedule for a given period.
You can choose to run for both or only drop-offs or only pick-ups.

The report is set on the current day by default, but you can choose another day or a longer period.
The report can be printed and exported as Excel, Word, or PDF.

Activity Schedule (Dynamic)

Shows all activities schedule for a given time.
You can run for all activities or specific activities.
You can include guest reservations for each activity and show the rates tax inclusive or not.

The report is set on the current day by default, but you can choose another day or a longer period.
The report can be printed and exported as Excel, Word, or PDF.

Front Office > Supervisor > Reports

Reservations by Operator (RES By Operator)



Reservation Modification Logs (RES Mod Log)




Rate Override




Marketing Arrivals

Shows all arrivals by Marketing Segment. You can narrow it down by segment for each market.
It will show the following:
- Guest name
- Status of the reservation
- Arrival date
- Number of nights
- Rate and applicable discount
- Any attached package or part of a group
- Marketing segments
- Company name
- VM confirmation number

The report is set on the current day by default, but you can choose another day or a longer period.
The report is dynamic and can be printed and exported as Excel, Word, or PDF.

Occupancy Forecast




Yield Management Forecast




Adv/Delq Deposits




Advance Sellout




Room History




Housekeeping > Reports

Arrivals




Supply Usage Analysis




Time Allotment Analysis




Service History




Discrepancy




Room Status




Room Assignment



Maintenance > Reports

Work Order Analysis



Preventative Maintenance Analysis


Accounting > City Ledger

Account Listing




Statements (Print)




AGING (Report)




Over Credit Limit




Transaction Log (Trans Log)




Accounting > Travel Agents

Commissions Payable



AGING (Report)



Transaction Log (Trans Log)




Accounting > Night Audit > Run Audit

Pre-Room and Tax



Operator Cash out 



Operator Transactions



Two Way Error Log




Accounting > Night Audit > Reprint Report

Operator Transactions (Static)



Transaction Log (Static)



Room and Tax (Static)



Credit Card Batch (Static)



Daily Report (Static)



General Ledger Journal (Static)



Market Segment (Static)

This will give the following numbers for each segment of the Market Segment:
- Revenue
- Total of rooms posted with that segment
- Average Daily Rate of that Segment (ADR)
- % Base: 
- % Sold: 

It will give the numbers for the day, for the month (to date), and for the year (to date).

Reason for Stay (Static)

This will give the following numbers for each segment of the Reason for Stay segmentation:
- Revenue
- Total of rooms posted with that segment
- Average Daily Rate of that Segment (ADR)
- % Base: 
- % Sold: 

It will give the numbers for the day, for the month (to date), and for the year (to date).

Referral Method (Static)

This will give the following numbers for each segment of the Referral Method segmentation:
- Revenue
- Total of rooms posted with that segment
- Average Daily Rate of that Segment (ADR)
- % Base: 
- % Sold: 

It will give the numbers for the day, for the month (to date), and for the year (to date).

BWR Elite Recognition (for BW Properties)



Management > Reports

Hotel Status




Management > Reports > Forecast

Occupancy Forecast



Revenue Forecast



Market Mix Forecast



Yield Management Forecast



Management > Reports > History

Statistic Recap



Room Type Popularity



Yield Management (Mgmt)



Revenue Summary



Operator Deposits



Daily Recap



Census




Management > Reports > Audit

Same reports as in Accounting > Night Audit > Reprint Reports



Revenue Management Live! > Reports

Estimated Occupancy Forecast



Forecast Trend Adjustment Analysis



Rate History



High Occupancy Report (High Occ Report)



Action Log




Point of Sale > Point of Sale > Reports

POS Reports




    • Related Articles

    • Open a Group Rooming List (Cloud | Video)

      What is the Rooming List The rooming list is a convenient tool that gives you an easy way not only to have a big and complete picture of your group but also to update several of the guest information all in one place, like room number or guest(s) ...
    • Rebuild the Reservation (Res) Matrix (Cloud)

      This article refers to the Cloud version. For the Desktop version, click HERE. What is Res Matrix? Res Matrix is essentially the collection of all the rooms and their statuses for the hotel which is what contributes to your Availability screen. What ...
    • Rebuild the Reservation (Res) Matrix (Desktop | Video)

      This article refers to the Desktop version. For the Cloud version, click HERE. What is Res Matrix? Res Matrix is essentially the collection of all the rooms and their statuses for the hotel which is what contributes to your Availability screen.   ...
    • Setting up Visual Matrix to Export Accounting Data (Cloud)

      Setting up Visual Matrix to Export Accounting Data Last Modified on 09/27/2018 9:18 am CDT Visual Matrix can be setup to export accounting code information to a file. This file can then be imported into accounting software such as Quickbooks. Visual ...
    • Add a New Group Hot List Task (Cloud | Video)

      This article refers to the Cloud version. For the Desktop version, click HERE. What is a Hot List? A Hot List is an organizational tool for front desk personnel. Go to Front Office > Group > Hot List. Create a new Hot List Click on Add; Click on ...