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

The Hook: Use this workflow to map revenues, operations summaries, and posting journals to balance your hotel's data in IQware.

Prerequisites: 

• Required Reports: Operations Summary Report and Posting Journal.

The Steps:

1. Navigate to the Import PMS screen.
2. Map room revenue lines using the Operations Summary Report; map the "Stat" line to Stat and the "Amount" line to Amount.
3. Map additional revenue lines, most likely found on the Posting Journal.
4. Map F&B revenue using POS interface data if available; if chosen, do not map the IQware data.
5. Map cash and settlement transactions (which import as negative numbers/credits) using the code -AMT.
6. Map receivables (Deposit, AR, and Guest Ledger) found on the Operations Summary Report and Posting Journal.
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 Posting Journal.

Troubleshooting: 

• Note: Map duplicate codes consistently in the same section; mark all other duplicates not used to balance the hotel as "NA". 
• Note: Some payment PMS codes will differ per site, requiring verification against specific property data.