This integration automatically imports budgeted labor hours and wages from ProfitSword into Hotel Effectiveness. This allows for real-time comparison of actualized labor data against budgeted goals in your Labor Summary reports.
Why Use RevSync Budget?
By default, labor reports compare actuals to your internal "Labor Standards." Activating this integration allows you to populate the "Budget" columns in the following reports:
- Labor Performance vs Budget
- Labor Performance vs Budget (Portfolio)
Sync Schedule: Data is retrieved from ProfitSword once daily at 4:00 AM ET.
Before You Begin (Prerequisites)
To activate this integration, your account must meet the following criteria:
- Subscriptions: Active subscriptions to both Hotel Effectiveness and ProfitSword.
- Actuals & Forecast: RevSync Actuals and RevSync Forecast must be active.
- Sync Dependencies: Actual Labor Sync or Scheduled Labor Sync must be configured prior to activating the Budget sync.
Reference: Integrated Data Points
The system retrieves the following specific fields from ProfitSword:
| Data Point | Description |
|---|---|
| Hotel ID | Unique property identifier. |
| Budget Date | The specific day the budget applies to. |
| Hours | Total budgeted labor hours. |
| Wages | Total budgeted labor wages (dollars). |
| Standard Position Code | The mapping key used to align ProfitSword roles with Hotel Effectiveness positions. |
Solver: Required Administrator Actions
1. Configuration in ProfitSword
Hotel Managers or ProfitSword Admins must ensure data is prepared for retrieval:
- Activate Budgeting Module: Ensure the hotel is actively using the ProfitSword budgeting module.
- Enter Daily Data: Revenue data must be entered by day.
- Spread Labor Data: Budgeted labor data must be spread by day (manually or via SQL schedule).
2. Configuration in Hotel Effectiveness
Account Administrators must verify position mapping to ensure data lands in the correct buckets:
- TimeSync Users: If you import punch data from a 3rd party, verify that all positions are mapped correctly in Hotel Effectiveness.
- Internal T&A Users: No additional mapping is required if your hotels utilize the Hotel Effectiveness Time & Attendance system.
Frequently Asked Questions (Reference)
Q: Which budget dataset is pulled from ProfitSword? A: The integration pulls the Primary Budget (FCID 2). This is currently the only supported dataset.
Q: What is the difference between the Revenue and Labor budget? A: Revenue Budget predicts how busy the hotel will be (money coming in). Labor Budget predicts how much you expect to spend on staffing to support that revenue (money going out).
Q: My report shows "Unmapped Budget Labor." How do I fix this? A: This usually indicates that multiple positions are mapped to the same GL code in ProfitSword. Contact your ProfitSword administrator to review your labor mapping assignments.
Q: Will this work without Actual Labor Sync? A: No. Labor budgets can only be retrieved if Actual Labor Sync or Scheduled Labor Sync is already active and mapped.
Success Check:
- Navigate to Reports > Labor Summary > Labor Performance vs Budget.
- If the sync is successful, the "Budget" columns will be populated with data from the previous 12 months (366 days).
Comments
0 comments
Please sign in to leave a comment.