First, you need to know the reporting dates for that month.
1. Go to Owners > Booking Report
2. Select the Batch History green tab near the top.
3. Make note of the last reporting period - eg. July 1 to August 2 in the screenshot below
Then go to Trust Account > Ledger Inquiry
Click on the second of the 4 green buttons near the top (holding accounts).
Select your Management Fees holding account and click on the Open Selected Holding Account button:
Scroll down to the bottom and click on the green 'Print Ledger Statement' button:
Select 'Excel file format (xls)' as the report type, enter the time period you located from the Batch Report History - ie. July 1 to August 2 and then click on the 'Create Report' button:
Open the excel file and you'll be able to sort by property. Please note, only the file number shows. You can check the file numbers either in OTA Plus from the Property page, or in Felix on the Properties page as they match the property IDs.
If required, you can then repeat the process for Cleaning Fees, Extras and any other holding accounts.