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

The Hook: Use this workflow to map revenues, business reports, and ledger comparisons using HMS PMS data.

Prerequisites: 

• Required Reports: Revenue Report, Daily Business Report, and Hotel Ledger Comparison.

The Steps:

1. Navigate to the Daily > Import PMS screen.
2. Map room revenue lines using the Revenue Report; map the "Stat" line to Stat and the "Amount" line to Amount,.
3. Map additional revenue found on the Daily Business Report.
4. Map F&B revenue using POS interface data if available; if chosen, do not map the HMS data.
5. Map cash and settlement transactions (which import as negative numbers/credits) using the code -AMT to reverse the sign.
6. Map receivables (Deposit Ledger, AR Ledger, and Guest Ledger) found on the Hotel Ledger Comparison report.
7. Map the Beginning Balance of receivables using the code -AMT.
8. Map the Ending Balance of receivables using the code AMT.

The Result Validation: 

• Success: Revenue totals match the Daily Business Report.

Troubleshooting: 

• Note: Data may pull in multiple times; map the line item only once and mark duplicates as "NA" to prevent double counting.