Dayend Close - Revenue Management

Setup > Configuration > Guest Ledger > Dayend Close Options > Revenue Mgmt tab

Revenue Management Yielding Extract is a separately purchased software package which interacts with roomMaster for Revenue Management. Past, present and future room revenue information is transferred to the software to help adjust your rates, getting the best possible Rate Yield.

Market Segments can be based on either UserField1, UserField2 or Rate Code.

See Internet FTP Settings for detailed information on FTP settings.

Please contact your local InnQuest Software sales office or reseller for information and cost of integrating RevPar Guru or IdeaS and roomMaster. This is a separately purchased add-on.

Set up the Configuration

First, go into Dayend Close Options / Revenue Mgmt tab, and set the options up the way the client needs them setup. The installer may need additional information from their IDEAS representative, especially the Account ID and how they want to base their segment information (Userfield1 or Userfield2 or by Rate Code) The default segment is used when there are override rates or missing rate and/or user fields for a particular reservation/folio.

Output Directory

The output will be two XML files placed inside of a ZIP file. For this folder, make sure the IDEAS user has read/write/delete access to that directory. In rare cases, you may need the Server/Host information if the file needs to be transmitted to another computer not on the local network.

Running it once versus night audit

Once you have it setup, you will first run the Extract manually from the Dayend Close Options setup screen. Once it runs, it will dump everything (one year past/present) once in a very large file. One the first extract is run (or any extract), the “Send 45 days of history instead of all days” will automatically be set to on/checked. This is because the first time you run the interface, it dumps everything and then at night, it only sends 45 days history at a time.

Going forward

The system then will extract as the very last/final part of the night audit. It creates the two extract files with an audit date and then ZIPs them up, so your Revenue Management Company knows which data goes with which audit date. Sometimes the file will be left in the directory and other times it will be sent through FTP.