PS: How to Map the Income Journal for MSI Cloud PMS

The Hook: Use this workflow to map revenues, cash, and receivables using MSI Cloud PMS reports.

Prerequisites: 

• Required Reports: Daily Activity Report, Rate and Market Statistic Report.

The Steps:

1. Map room revenue lines using the Rate and Market Statistic report; map "Stat" and "Amount" accordingly.
2. Map additional revenue from the Daily Activity report import (or use POS data for F&B).
3. Map cash and settlement transactions (importing as positive numbers) to the code "AMT".
4. Map receivables (Deposit, City, and Guest Ledger); map "End of Day" balance to "AMT" and "Beginning" balance to "-AMT".

The Result Validation: 

• Success: Revenue totals match the Daily Activity report.

Troubleshooting: 

• Note: Map duplicate codes consistently in the same section; mark all other duplicates as "NA".