How to Map the Income Journal for Properties Using the Fosse (Non-Extended Stay) PMS

The Hook: Use this workflow to map Fosse PMS data using the Daily Closing Report to capture all adjustments and ensure accurate balancing for transient and extended stay properties.

Prerequisites: 

• Required Reports: Daily Segmentation Report, Daily Closing Report, and Daily Closing Report Summary.

The Steps:

1. Navigate to the Import PMS screen.
2. Map room revenue lines using the Daily Segmentation Report for segmentation and the Daily Closing Report Summary for total room revenue.
3. Map additional revenue from the Daily Closing Report Summary import; use POS data for F&B if available.
4. Map cash settlements (which import as credits/positive numbers) using the code AMT.
5. Map receivables (Deposit, AR, and Guest Ledger) found on the Daily Closing Summary report.
6. Map the debit transaction to -AMT and the credit transaction to AMT (or use Balance/Prev Balance codes as available).

The Result Validation: 

• Success: Revenue totals match the Daily Closing Report Summary.

Troubleshooting: 

• Note: To address out-of-balance issues caused by adjustments not captured in the Daily Segmentation Report, use the Daily Closing Report (equivalent to a trial balance) for financial mapping. 
• Note: Use the Manual Adjustment Report to identify adjustments made by the front desk that are missing from segmentation reports. 
• Note: Be aware of posting code differences between transient hotels (e.g., Courtyard, SpringHill Suites) and extended stay hotels (e.g., Residence Inn), as these affect reconciliation.