The Payment Received report is designed to search all your payment records depending on the filters you choose. These payments are made on bookings, invoices, a customer, company, channel or agent.
To open the Payments Received report, select it from the Finance submenu. See example below of what the report will look like:
Rows Per Page: Set how many rows you want to appear on each page
Columns: Select and deselect the columns to appear on the page.
To show the payments as credits and debits you will need to select the tab “Payments Received (Debit/Credit)” to run the report:
You have the ability to create multiple filters, set a default and save them by clicking on the “Save filter” button.
Dates - This is where you have the ability to select your ‘to” and “from” date or click on the setting symbol to use the advance date search options
Date Type - If the Date Type is set to “Payment” it applies to all payments where the payment received date is within the date range selected. If the Date Type was set to “Arrival” then this will list all payments made on bookings or invoices where the arrival date is within the date range selected. Arrival date is more appropriate if you wish to ignore payments that have been made in advance of arrival.
Held - Ability to choose if you only want to search hold bookings or not
Payment Methods - Select the different payment methods used
Properties - This filter only shows if you iBex account is multi property. Will give you the option to run the report on a single or multiple properties
Booking Groups - If you use reporting groups in iBex this field will show your list of booking groups which are found/set on a booking
Unit Groups - If you use reporting groups in iBex this field will show your list of unit groups which are found/set on the unit
Booking Reference - When searching a booking reference number it will ignore the date picker and it will take into consideration the options "Held", “Payments Methods" "Booking Groups" and "Unit Groups"
Payment ID - When searching the payment ID number it will ignore all filters
Invoice Number - When searching a invoice number it will ignore the date picker and it will take into consideration the filters "Held", “Payments Methods" "Booking Groups" and "Unit Groups"
Payment Reference - This will take into consideration all filter options
Comments - This will take into consideration all filter options
The report has an export button which if clicked will create an export file via the following formats:
Excel Spreadsheet (xlsx)
Excel Spreadsheet (xls)
Comma Delimited (csv) (please note that the csv does not contain calculated totals)
Searched filters and fields will show in the export
Exporting the report will show ALL columns in the spreadsheet/file
Exports are limited to 5000 records