How to Map the Income Journal for Properties Using Maestro PMS

The Hook: Use this workflow to map Maestro PMS import data, including rates, settlements, and ledger balances, to ensure accurate financial reporting.

Prerequisites: 

• Access to the Daily > Import PMS screen. 
• Reports or information from the Maestro system that display all revenues.

The Steps:

1. Navigate to the Import PMS screen to view the Maestro import lines.
2. Map room revenue lines (e.g., "Rate Type - Stat" and "Rate Type - Amt") to balance room revenue,.
3. Map additional revenue accounts; if using POS data for F&B, do not map the Maestro data.
4. Map cash and credit card settlements (which import as positive numbers) by mapping Debit lines to -AMT and Credit lines to AMT.
5. Map receivables (Deposit Ledger, AR Ledger, and Guest Ledger).
6. Map the current balance (e.g., "Net 1" or "AD-CURR") to AMT and the previous balance (e.g., "Net 2" or "AD-BAL") to -AMT,.

The Result Validation: 

• Success: Revenue totals match your PMS reports.

Troubleshooting: 

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