How to Map 3rd Party Revenue (RevSync)

Use this workflow to link incoming revenue data from your PMS or external revenue system to the appropriate Business Driver fields in Hotel Effectiveness. This ensures that your Night Audit Entry and Scheduler Forecasts are populated with accurate, automated data.

Before You Begin

• Permissions: Requires Account Administrator or Hotel Admin permissions with "Edit Hotel Settings" enabled.
• Service Requirement: The hotel must be subscribed to the RevSync importing service. If you see the message "Sorry, this hotel is not setup for this importing service," contact support to activate the integration.
• Dependencies: Revenue Sync Actuals and Forecast must be active before mapping can be completed.

Solver: Reviewing Raw Source Data

Before mapping, you must verify the format and descriptions of the data arriving from your 3rd party system.

1. Hover over the Username Menu (top right) and select Settings.
2. Under the Standards/Business Drivers heading, select 3rd Party Revenue Sync Mapping.
3. Review the Source Description and Raw Source Data columns.
4. Identify which fields need to be mapped and note any negative numbers (e.g., -250.00) that require a sign reversal to appear as a positive entry.

Solver: Mapping Revenue Items to Business Drivers

After reviewing the source data, you must link it to the correct fields in your Night Audit Entry.

1. On the 3rd Party Revenue Sync Mapping page, choose one of two options for a data line:
   • Edit: Select this to map the item to an existing Business Driver.
   • Add New Business Driver: Select this if no applicable driver currently exists for the hotel.
2. In the mapping window, select the desired HE Business Driver.
3. If the source data appears as a negative incorrectly, select Yes for Reverse Sign?.
4. Click Save.

Solver: Bulk Mapping (Portfolio Edit)

Use this workflow to update mappings for multiple hotels simultaneously to ensure portfolio-wide consistency.

1. From the settings menu, select 3rd Party Revenue Mapping (Portfolio).
2. Check the boxes next to the hotels you wish to update.
3. Click Edit.
4. Select the new HE Business Driver Mapping from the dropdown menu.
5. Click Save Changes.

Reference: Mapping Logic & Validation

Feature	Behavior Logic
Sign Reversal	Used when a PMS sends revenue as a negative value (common in some accounting exports). Selecting "Reverse Sign" converts -100 to +100 for reporting.
Custom Drivers	When using "Add New Business Driver," the system auto-populates the name based on the source metadata. You can manually override this name during the setup.
Retrospective Application	Once mapping is saved, the system will apply the logic to newly arriving data. To confirm, visit Business Driver Setup to see paired items.