--- title: (Opera) Creating an Arrivals Report description: Configure and schedule Opera PMS arrivals reports for UpsellGuru to automate reservation imports, guest data updates and targeted upsell campaigns. --- [Skip to content](https://support.upsellguru.com/help/portal/en/kb/articles/opera-creating-an-arrivals-report-in-opera#main-content) ![USG Logo-cropped](https://support.upsellguru.com/hs-fs/hubfs/USG%20Logo-cropped.jpg?width=400&height=57&name=USG%20Logo-cropped.jpg) - Home - Products - Pricing - Blog - Company Open main navigation Close main navigation - Home - Products - Pricing - Blog - Company - [Create a Ticket](https://share-eu1.hsforms.com/2H9mDR2qdRqmpd-arcRxZ5A2fnvvd) [Create a Ticket](https://share-eu1.hsforms.com/2H9mDR2qdRqmpd-arcRxZ5A2fnvvd) How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://support.upsellguru.com/help?hsLang=en) 2. [Integrations](https://support.upsellguru.com/help/integrations?hsLang=en) 3. [Opera](https://support.upsellguru.com/help/integrations?hsLang=en#opera) # (Opera) Creating an Arrivals Report ## Configure and schedule Opera PMS arrivals reports for UpsellGuru to automate reservation imports, guest data updates and targeted upsell campaigns. ![Info](https://support.upsellguru.com/hubfs/Knowledge%20Base%20Import/info-Jun-09-2026-06-49-23-4078-AM.png) ### This step-by-step guide demonstrates how to set up a report in Opera PMS and schedule it to UpsellGuru on a daily basis. The report will contain the following fields of information: ### Reservations Number, Guest name, Email address, Stay dates, Room type booked, Booked Add-ons, Rate Code, Market Segment, Booking Source, Profile Language and Reservation status. If you require to provide us any other information you see valuable for your up-selling strategy, please contact [support@upsellguru.com](mailto:support@upsellguru.com) ### **I. Configuring the Report** 1\. [Download this file](https://eu-upsellguru-public-docs.s3-eu-central-1.amazonaws.com/osr/upsellguruarrivalsreport.osr) to an accessible directory in your computer.  2\. Login to Opera Configuration and go to: **Setup \> Report Setup \> Reports** ![1](https://support.upsellguru.com/hs-fs/hubfs/1.png?width=273&height=142&name=1.png) 3\. In Reports, select **New** and complete as below (it is essential that you check the field for **Simple Report**) ![2](https://support.upsellguru.com/hs-fs/hubfs/2.png?width=366&height=192&name=2.png) 4\. Click on **Customize** and you will see the following report set up screen: ![3](https://support.upsellguru.com/hs-fs/hubfs/3.png?width=670&height=460&name=3.png)   5 Click on **Import** and select the file that you have saved to an accessible directory. ![4](https://support.upsellguru.com/hs-fs/hubfs/4.png?width=420&height=274&name=4.png) 6\. Click on **Open** and you will see the following: ![5](https://support.upsellguru.com/hs-fs/hubfs/5.png?width=354&height=118&name=5.png) 7\. Select **Upload.**  8\. Go to **Filters** and make sure **Arrival Date between From Date and To Date** is a report filter. If not, click on **Modify** and add the filter.    ![](https://support.upsellguru.com/hubfs/Knowledge%20Base%20Import/edbsn8788645b7612fb210fdde7eddb0f9f56d8dabc259e8b68fc9c81fc1938733b8d2f0149d7c9f4c85435fea4bd43dd4f81d7b8c790a98f88e533349882044d79f4.png)   9\. Click on **OK** and then close. ---   ### II. Scheduling the report 1\. Login to Opera PMS and go to **Miscellaneous \> Report Scheduler** 2\. Click on **New** and then search for the UpsellGuru Report as shown below. You need to ensure that **Print to File** is checked, File Format is **Delimited** and Delimiter is a **comma.** Click **Ok.** ![1-1](https://support.upsellguru.com/hs-fs/hubfs/1-1.png?width=380&height=350&name=1-1.png) 3\. Setup the Scheduler from today's date (select a time in the AM) and for the report to repeat every 1 day.   ![2-1](https://support.upsellguru.com/hs-fs/hubfs/2-1.png?width=340&height=312&name=2-1.png) 4\. Click on **OK** and you will see a date parameter field like the one below (this will default to today’s date). Click on **File** and **Close**. ![3-1](https://support.upsellguru.com/hs-fs/hubfs/3-1.png?width=348&height=179&name=3-1.png) 5\. Your screen will look something like the below (depending on whether you have any other reports scheduled): ![4-1](https://support.upsellguru.com/hs-fs/hubfs/4-1.png?width=592&height=397&name=4-1.png) 6\. Click on **New** and enter the email address provided by UpsellGuru in the field (this is an unique email that will be used for this property only). You will find the email address in the UpsellGuru Extranet under the INTEGRATIONS tab.  ![5-1](https://support.upsellguru.com/hs-fs/hubfs/5-1.png?width=397&height=138&name=5-1.png) ![](https://support.upsellguru.com/hubfs/Knowledge%20Base%20Import/edbsnc4cb1bff246005400090eedf749bb0617a4a1f98ce0d44e2efce31e03e3d1690a333e6e64feef2d88913e79ef8d5d2a7f8c95106ef7eefc29155c12886cf808e.png)   ---   ### **III. Setting the date parameter** 1\. Highlight the UpsellGuru Report and ensure that the radio button for **Parameters** is set as shown below:   ![7](https://support.upsellguru.com/hs-fs/hubfs/7.png?width=670&height=21&name=7.png)  2. Highlight the **To Date** and click on **Set date**. Using the numeric pad select **+3** \* as shown below. *(\** *The date set above is based on an assumption that you are looking at the report date plus 3 days. This means that UpsellGuru would send out the up-sell emails 3 days prior to guests'arrival. Any permutation can be achieved using the plus or minus buttons on the numeric pad).* ![8](https://support.upsellguru.com/hs-fs/hubfs/8.png?width=358&height=368&name=8.png) 3\. Click on OK and your result will be like the following: ![9](https://support.upsellguru.com/hs-fs/hubfs/9.png?width=670&height=67&name=9.png) 4\. Click **Ok** and you are all done. ---   ### **(Optional): Schedule a 2nd report**   **Schedule a 2nd report to capture more reservations.**  If your 1st report was scheduled 3 or more days in advance of arrival, it can be worth (depending on your average booking window) to schedule a 2nd report closer to the arrival date (e.g. 1 or 2 days). ![Info](https://support.upsellguru.com/hubfs/Knowledge%20Base%20Import/info-Jun-09-2026-06-49-23-4078-AM.png)   1\. Go back  **Miscellaneous \> Report Scheduler and s**tart at step  **II. Scheduling the report**.  2\. Complete the scheduling part exactly as done previously. 3\. Once you reach step  **III. Setting the date parameter, select a date closer to arrival (e.g. +1 or +2).**   ---   ### **(Optional): Room Type Availability** ![Info](https://support.upsellguru.com/hubfs/Knowledge%20Base%20Import/info-Jun-09-2026-06-49-23-4078-AM.png)   If you require for UpsellGuru to check availability, please also schedule an Availability Report.  1\. Login to Opera PMS and go to **Miscellaneous \> Report Scheduler** 2\. Click on **New** and then search for **Detailed Availability Report**. File Format is **Delimited** and Delimiter is a **comma.** If available, select  **Print to File.** Click  **Ok.** ![10](https://support.upsellguru.com/hs-fs/hubfs/10.png?width=427&height=407&name=10.png)   3\. Setup the Scheduler from today's date (select same time as the reservations report) and for the report to repeat every 1 day.   ![11](https://support.upsellguru.com/hs-fs/hubfs/11.png?width=353&height=324&name=11.png) 4\. Filter for ALL ROOMS and display AVAILABILITY.    ![12](https://support.upsellguru.com/hs-fs/hubfs/12.png?width=401&height=335&name=12.png)   5\. File and close.    - [Pre-Arrival](https://support.upsellguru.com/help/pre-arrival?hsLang=en#main-content) - [Daily Management](https://support.upsellguru.com/help/pre-arrival?hsLang=en#daily-management) - [Room Setup](https://support.upsellguru.com/help/pre-arrival?hsLang=en#room-setup) - [Extras Setup](https://support.upsellguru.com/help/pre-arrival?hsLang=en#extras-setup) - [Email Setup](https://support.upsellguru.com/help/pre-arrival?hsLang=en#email-setup) - [On-Arrival](https://support.upsellguru.com/help/on-arrival?hsLang=en) - [In-Stay & Reg Card](https://support.upsellguru.com/help/in-stay-reg-card?hsLang=en#main-content) - [In-Stay](https://support.upsellguru.com/help/in-stay-reg-card?hsLang=en#in-stay) - [Registration Card](https://support.upsellguru.com/help/in-stay-reg-card?hsLang=en#registration-card) - [Integrations](https://support.upsellguru.com/help/integrations?hsLang=en#main-content) - [Opera](https://support.upsellguru.com/help/integrations?hsLang=en#opera) - [RMS](https://support.upsellguru.com/help/integrations?hsLang=en#rms) - [Protel](https://support.upsellguru.com/help/integrations?hsLang=en#protel) - [Guestline](https://support.upsellguru.com/help/integrations?hsLang=en#guestline) - [OTA Integrations](https://support.upsellguru.com/help/integrations?hsLang=en#ota-integrations) - [Reports](https://support.upsellguru.com/help/reports?hsLang=en) - [General](https://support.upsellguru.com/help/general?hsLang=en) - [System Health Check](https://support.upsellguru.com/help/system-health-check?hsLang=en#main-content) - [Setup](https://support.upsellguru.com/help/system-health-check?hsLang=en#setup) - [Integration](https://support.upsellguru.com/help/system-health-check?hsLang=en#integration) - [Emails](https://support.upsellguru.com/help/system-health-check?hsLang=en#emails) - [On-Arrival Program](https://support.upsellguru.com/help/system-health-check?hsLang=en#on-arrival-program) - Home - Products - Pricing - Blog - Company [mailto:support@upsellguru.com](mailto:support@upsellguru.com) Copyright © 2026, upsellguru.com