How to Map the Income Journal for Properties Using the Opera PMS System

The Hook: Use this workflow to map revenues, trial balance data, and receivables using Opera reports to ensure accurate financial balancing.

Prerequisites: 

• Required Reports: Market Code Statistics Report, Daily Manager Flash, and Trial Balance Report (or Matrix Trial Balance). 
• Note: Ensure the Market Code Statistics report is run in the same format (by code, class, etc.) as it is pulled into the system.

The Steps:

1. Navigate to the Import PMS screen.
2. Map room revenue lines using the Market Code Statistics Report; map the "Stat" line to Stat and the "Amount" line to Amount for each segment.
3. Verify room revenue totals using the Daily Manager Flash report.
4. Map additional revenue using the Trial Balance or Matrix Trial Balance report.
5. Map F&B revenue using POS interface data if available; if using POS data, do not map the Opera F&B data.
6. Map cash and settlement transactions (which import as negative numbers/credits) using the code AMT.
7. Map receivables (Deposit Ledger, AR Ledger, and Guest Ledger) found on the Trial Balance report.
8. Map the Beginning Balance of receivables using the code -BAL.
9. Map the Ending Balance of receivables using the code BAL.

The Result Validation: 

• Success: The Revenue numbers in the Income Journal Summary match the Daily Manager Flash report.

Troubleshooting: 

• Note: If "Miscellaneous" revenue appears in the market segment breakdown, update posting codes to reflect miscellaneous revenue rather than rooms revenue. 
• Note: If one-penny errors occur with taxes, these are likely rounding issues and can be manually adjusted. 
• Note: If market segments are duplicated or missing, ensure the correct grouping is used in the report settings.