How to Map the Income Journal for Properties Using WynGuest PMS

The Hook: Use this workflow to map revenues, cash settlements, and receivables using WynGuest reports to balance your hotel’s financial data efficiently.

Prerequisites: 

• Required Reports: Detail Transaction Totals List, Revenue Recap by Rate Plan, Statistics Report, and Hotel Ledger Comparison.

The Steps:

1. Navigate to the Import PMS screen.
2. Map room revenue lines using the Revenue Recap by Rate Plan report for segmentation and the Statistics Report for total room revenue.
3. Ensure both the "Stat" line and "Amount" line are mapped for each segment.
4. Map additional revenue using the Detail Transaction Totals List import.
5. Map F&B revenue using POS interface data if available; if chosen, do not map the WynGuest data.
6. Map cash and settlement transactions (which import as debits/negative numbers) using the code -AMT.
7. Map receivables (Deposit Ledger, City Ledger, and Guest Ledger) found on the Hotel Ledger Comparison report.
8. Map the End of Day balance to AMT and the Previous Day (or beginning) balance to -AMT.

The Result Validation: 

• Success: Revenue totals match the Detail Transaction Totals List report.

Troubleshooting: 

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