How to map RevSync business drivers

Use this workflow to link revenue codes from your PMS or BI system (e.g., ProfitSword, Hilton OnQ) to Hotel Effectiveness Business Drivers for automated Night Audit Entry.

Before you begin...

• Requires "Edit Settings" permissions.
• Requires RevSync to be active and receiving data.

1. Access Revenue Mapping

1. Hover over the Username Menu and select Settings.
2. Under "Standards/Business Drivers," select 3rd Party Revenue Sync Mapping.
   
3. Select the Hotel from the dropdown menu.

2. Review Raw Data

1. Review the Raw Source Data column to see the values sending from your PMS (e.g., "12500.00").
2. Identify which item corresponds to Rooms Revenue, Rooms Sold, or F&B Revenue.

3. Map to Business Drivers

1. Click Edit next to the item you wish to map.
2. Select the matching Hotel Effectiveness Business Driver from the dropdown (e.g., Map "PMS_ROOM_REV" to "Rooms Revenue").
3. Reverse Sign: Select Yes if the data imports as a negative number but should be positive (e.g., "-250.00" for Room Rental).
4. Click Save.
    

4. Create New Drivers (If Needed)

1. If a specific revenue line item does not have a matching driver, click + Add New Business Driver next to the row.
2. Name the new driver (e.g., "Spa Revenue") and click Save.

The Result Success: Data populates in the Night Audit Entry fields automatically during the next sync cycle (typically hourly).

If this fails...

• Note: If you mapped an item but the data is not appearing, check the Reverse Sign setting. Some accounting systems send revenue as credits (negative numbers), which need to be reversed to display correctly in reports.