This article describes the Phone Activity Report, which lists the phone calls recorded against each PABX extension within a selected date range, with the charge and number of calls for each extension or the details of each call.
Overview
The Phone Activity Report shows the phone calls RMS has recorded from your property's telephone system (PABX) for each extension within the selected date range. The Summary layout shows one row per extension with the total charges and the number of calls. The Detailed layout shows one row per call with the call's date, time, dialled number, duration and amount.
The report reads the extensions set up in Setup > PABX Extensions and the call records RMS receives from the property's PABX system. To set up extensions, see Set up PABX extensions. Front office and night audit teams run the report to review call activity for each Area, and accounts teams run it to check call charges.
Please Note! Before you run this report, ensure that you have activated the PABX module with the RMS Sales team and that you have set up your extensions in Setup > PABX Extensions.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. For more information, see Understanding RMS Help Centre Articles.
Use Cases
- Daily call review - the night audit team runs the Summary layout for the previous day to see which extensions made calls and the total charges for each.
- Guest call query - when a guest queries a call charge, the front office runs the Detailed layout with the guest's extension entered in Specific Extensions to list each call with its time, dialled number, duration and amount.
- Staff phone use - a manager ticks Include Admin Lines to include the reception, office and other admin extensions, whose calls are not charged to guest accounts.
How to Access
In the side menu of RMS, go to Reports > Daily > Phone Activity.
Tip! Select Add Report to Favourites Menu to add the Phone Activity Report to your Favourites, or select Schedule to have it generated and emailed automatically. See Scheduled Reports.
Report Options
The report options on the Phone Activity Report control the date range, the layout, the row order and which extensions are included. All options are visible on the Report Options panel; this report has no More Options panel.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Phone Calls Between | Date range | Today | Includes calls whose call date falls on or between the From and To dates. Printed in the report header. |
| Property | Multi-select | All Selected | Limits the report to extensions in the selected properties. Shown on multi-property databases only. |
| Summary | Radio | Selected | Shows one row per extension with the total charges and number of calls. |
| Detailed | Radio | Not selected | Shows one row per call with the date, time, dialled number, duration and amount. |
| Sort By | Dropdown | Extension |
Sets the row order. Options:
|
| Specific Extensions (Comma Separate multiple Entries) | Text | Blank | Limits the report to the extension numbers entered, separated by commas (for example 101,102). Accepts digits and commas only. |
| Include Admin Lines | Checkbox | Off | Adds admin extensions, which are shown under Admin. |
| Show All Ext | Checkbox | Off | Lists every extension, including extensions with no calls in the date range. |
In the Summary layout, choosing Reservation, Account No or Call Date in Sort By sorts the rows by Name. The Area and Reservation options follow your property's System Labels.
Please Note! Ticking Include Admin Lines changes how the other filters apply. Specific Extensions then filters only the admin extensions, so every extension in the selected properties is still listed. On a multi-property database with only some properties selected, the other properties' extensions are also listed under Admin. Leave Include Admin Lines unticked when filtering by extension or by property.
Column Headers
The Phone Activity Report has two layouts, chosen with the Summary and Detailed options. Both layouts show the extension's Name, Area and Ext. The Summary layout adds totals for each extension, and the Detailed layout adds the details of each call. Where a value depends on how the extension is set up, the Source / Calculation column points to Data Sources & Calculations.
Summary layout
| Column | Description | Source / Calculation |
|---|---|---|
| Name | The name of the latest guest checked in to the extension's Area, surname first. Blank for admin extensions. | The extension, not the call. See Guest, reservation and account. |
| Area | The Area the extension is linked to. Shows Admin for admin extensions. | Setup > PABX Extensions. See Extensions and admin lines. |
| Ext | The extension number. | Setup > PABX Extensions. |
| Total Charges | The total charge for the extension's calls within the date range. | Sum of the charge on each call. See Phone call records and charges. |
| Total Calls | The number of calls from the extension within the date range. | Count of call records. See Phone call records and charges. |
The Summary layout groups extensions by property. A Total row after each property and a Grand Total row at the end show the number of extensions listed, the total charges and the total calls.
Detailed layout
| Column | Description | Source / Calculation |
|---|---|---|
| Name | As in the Summary layout. | See Guest, reservation and account. |
| Area | As in the Summary layout. | Setup > PABX Extensions. |
| Ext | The extension the call was made from. | Setup > PABX Extensions. |
| Date | The date of the call. | Call record. |
| Res No | The reservation currently checked in to the extension's Area. Shows 0 after check-out. | The extension, not the call. See Guest, reservation and account. |
| Account No | The account of the reservation currently checked in to the extension's Area. Shows 0 after check-out. | The extension, not the call. See Guest, reservation and account. |
| Dialled Number | The phone number dialled. | Call record. |
| Time | The time of the call, on a 12-hour clock (for example 09:15:PM). | Call record. |
| Duration | The length of the call in hours, minutes and seconds. | Call record. |
| Amount | The charge for the call. | Call record. See Phone call records and charges. |
The Detailed layout is not grouped by property. A single Grand Total row shows the number of rows, the total duration and the total amount.
Data Sources & Calculations
The following concepts govern more than one column or option on the Phone Activity Report.
Extensions and admin lines
Each row on the Phone Activity Report belongs to an extension set up in Setup > PABX Extensions, where each extension is linked to a Category and Area. An extension set up with the Admin option is an admin extension, used for staff phones such as reception, and has no Area. The report shows admin extensions under Admin in both the Area column and the property heading, and leaves them out unless Include Admin Lines is ticked.
Extensions with no calls in the date range are left out of the Phone Activity Report unless Show All Ext is ticked. In the Detailed layout, each of those extensions then appears as one row with no call details, and that row is counted in the Grand Total.
Phone call records and charges
Phone Activity Report call records are the calls RMS receives from the property's PABX system, each stored with its date, time, duration, dialled number and charge. The report includes a call when its date falls within Phone Calls Between. In the Summary layout, Total Charges adds up the charge on each of the extension's calls and Total Calls counts them; in the Detailed layout, Amount is the charge on the individual call. You set up the charging rules for each extension, such as the cost multiplier and cut off, in Setup > PABX Extensions. You set where the call charges are posted on the reservation in Accounting Options - Account Screen Tab.
Guest, reservation and account
The Name, Res No and Account No on the Phone Activity Report come from the extension, not from the call itself. RMS records the guest, reservation and account against the extension when a reservation is checked in to the extension's Area or moved into it. When the reservation is checked out or moved out, RMS sets the extension's reservation and account back to 0 but keeps the guest's name until the next check-in. On a report covering past dates, every call therefore shows the extension's latest guest, which may not be the guest who made the call, and Res No and Account No show 0 once that guest has checked out.
Please Note! When no extension or call matches the report options, the report does not show an empty table. It shows a single row of placeholder values (for example a Date of 01 Jan 0001 and a Time of 12:00:AM in the Detailed layout) and the totals show a count of 1. This row is not a call; widen the date range, tick Show All Ext, or check the Specific Extensions entered.
Related Reports
- In House report - lists in-house reservations and can show each Area's PABX extension with the Include PABX EXT option.
- Audit Trail Report - lists accounting transactions; set Trans Source to PABX to see the call charges posted to accounts.
Related Articles
- Set up PABX extensions - create extensions and set the admin, cost multiplier and cut off options.
- PABX extensions list - print the list of extensions set up for the property.
- Troubleshooting Boomgate and PABX Issues via MFI - what to check when calls or extension updates are not reaching RMS.
Comments
0 comments
Please sign in to leave a comment.