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.



Operation


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:




Filters


You have the ability to create multiple filters, set a default and save them by clicking on the “Save filter” button.




Report Options


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



Search Fields


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



Exporting Report


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)




NOTE

  • 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