How to generate payment transaction reports

Where can I find it? More >>> Payment transactions.

In this article, you will learn how to easily locate and analyse monetary transactions recorded in your TuriTop booking system.

This report provides a detailed account of each payment line linked to bookings within your Bookings tab. In other words, it records all financial transactions that have been entered manually or via payment gateways directly into the panel. 

• OTA bookings: Bookings from external resellers such as Viator, GetYourGuide, or others are not included in this report. This is because the payment line is managed on the reseller's platform and is not automatically entered into TuriTop.

• Cancelled bookings: The report includes payments for deleted or cancelled bookings as long as there is a registered payment line. The system considers the payment to have been made.

• Refund management: In order for the amount of a cancellation to be deducted from the total in the report, it is essential to register a negative payment line (refund) within the list of payments for the booking.

If you prefer to account for all amounts, including those without a registered payment line, go to the More tab >>> Reports. Unlike the transaction report, in this section the amounts of deleted or cancelled bookings are automatically deducted from each gateway's count. You can consult this article for more information.

How to generate a report

Step 1: Locate the section

Access your TuriTop control panel and go to the More tab >>> Payment transactions:

Step 2: Select a time range

Once inside, select a time period from "Custom period":

Step 3: Choose a filter

After selecting a time range, choose a filter to apply to the search from "Filter by":

You will have various parameters at your disposal to filter the information, such as:

• All transactions: You can generate a report of all movements for the selected period, obtaining key details such as: the date, the payment gateway used, a description with the booking reference, the external Tracking ID (to locate the transaction in your payment gateway), the currency and the total amount.

• Services: You can generate a report of all transactions for the selected period, for one or more specific services, obtaining key details such as: the date, the payment gateway used, a description with the booking reference, the external tracking ID (to locate the transaction in your payment gateway), the currency and the total amount.

• Single payments: You can generate a report of all transactions for the selected period, filtering only for simple payments. In this report, you will obtain key details such as: the date, the payment gateway used, a description with the booking reference, the external tracking ID (to locate the transaction in your payment gateway), the currency and the total amount.
• Credit transactions: You can generate a report of all transactions for the selected period, filtering only for credit transactions. In this report, you will obtain key details such as: the date, the payment gateway used, a description with the booking reference, the external tracking ID (to locate the transaction in your payment gateway), the currency and the total amount.
• Payment gateways: You can generate a report of all transactions for the selected period, by one or more specific gateways, obtaining key details such as: the date, the payment gateway used, a description with the booking reference, the external tracking ID (to locate the transaction in your payment gateway), the currency and the total amount.

Once you have set the period and filters, click on "Search". A report like the one shown below will be generated, which you can download in .csv or .xls format by clicking on the 'CSV' or 'Excel' buttons, respectively.

You can sort the results in ascending or descending order by clicking on the column headers (Date, Amount, etc.). When you click on the green title of each category, the list will automatically be organised according to your preferences.