Reports

Conversion and reconciliation reports for Vio.com affiliates.

booking

Source of truth for the current state of affiliate bookings. Includes, among others, information about status, value, actual and forecasted commission of the booking.

Schema

Column	Description	Example
id	Unique identifier of the booking.	123wde12hhdiu
hotel_id	Unique identifier of the hotel.	3468198
hotel_name	Name of the hotel.	Hostal Plaza Mayor
hotel_country	ISO 3166-1 alpha-2 code of the hotel country.	ES
provider	Human readable name of the intermediary provider of the booking.	Vio.com
check_in	Booking check in date in YYYY-MM-DD format.	2025-02-01
check_out	Booking check out date in YYYY-MM-DD format.	2025-02-02
status1	Status of the booking. One of "confirmed" (booking created), "finished" (stay completed) or "cancelled" (booking cancelled).	confirmed
currency	ISO 4217 code of the currency used to pay the affiliate.	EUR
device	The device from which the booking was made. One of "mobile", "desktop" or "tablet".	mobile
label	Custom string or object set by the affiliate for tracking purposes.	my_tracking_id
value2	Booking value (GBV) in the affiliate currency.	20.00
commission2,3	Commission for the affiliate in the affiliate currency.	10.00
forecasted_commission2,4	Forecasted commission for the affiliate, using the cancellation probability calculated by Vio.com, in the affiliate currency.	8.00
created5,6	Timestamp when the booking entry was created.	2025-01-01 20:00:00
modified5,7	Timestamp of the last update to either the booking status or commission.	2025-01-03 22:00:00
cancelled5,8	Timestamp when the booking cancellation was reported	NULL
legacy_booking_id9	Legacy unique identifier of the booking.	456kij121234
legacy_date9	Legacy timestamp when the booking was created	2025-01-01 16:00:00
cashback_value10	Estimated cashback value that the end-user (booker) will receive in the currency specified by the cashback_currency	452
cashback_currency10	ISO 4217 code of the currency of the estimated cashback. Note that it can also be points or some other imaginary "currency"	points

Notes

1. Bookings in "confirmed" status are considered "finished" 60 days after their check out date.
2. All monetary metrics are reported in the affiliate currency. Currency conversion is done at the booking creation time (created column).
3. The commission will be paid for the booking if the booking is eventually "finished". The value of commission is 0 for "cancelled" bookings.
4. The forecasted_commission adjusts the commission value using Vio.com's internal cancellation probability for the booking. The value of forecasted_commission is not updated when the final status of the booking ("cancelled" or "finished") becomes known. forecasted_commission is only available to specific Partners. Please speak with a Vio Partnerships representative if you want forecasted_commission reported.
5. All timestamps are in UTC timezone and refer to the times when the bookings are processed by the affiliate reporting system, which happens several times a day.
6. The created timestamp is not necessarily the same as the timestamp when the traveler made the booking.
7. The modified timestamp considers only changes in commission and status.
8. The cancelled timestamp is only available when the status is "cancelled".
9. The legacy_booking_id and legacy_date are provided only for bookings already reported through the legacy system to simplify the reconciliation process.
10. Cashback columns are only available to Cashback WhiteLabel Partners.

Booking updates

Booking data is updated up until 60 days after the check out date of the booking. After that, the booking status is considered either "cancelled" or "finished" and none of its properties are updated anymore.

Calculation of commission

The commission for a booking is calculated using the gross commission, this is, the revenue that Vio.com receives from the booking, and the revenue share of the affiliate:

commission = gross commission * revenue share

• The gross commission is calculated by the provider of the booking (Vio.com or others) based on the value (GBV) and other factors. In some ocassions, the gross commission can change throoughout the lifetime of a booking, which will also impact the value of the commission for the affiliate.
• The revenue share depends on the specific agreement of each affiliate. For affiliates with a tiered revenue share agreement, the revenue share is calculated on the 15th day of every month for the bookings with check out date on the previous month. For bookings with check out date in a month that is not yet closed, the latest available tier is used.

Access

This report can be accessed via live reporting.

booking_daily

Daily report with bookings created on the previous day. Includes the same information as the booking report for the day when the booking was created.

Schema

Column	Description	Example
report_date	Date when the report is generated.	2025-01-01
change_type	Type of change that affected the booking. Currently only "created".	created
id	Unique identifier of the booking.	123wde12hhdiu
hotel_id	Unique identifier of the hotel.	3468198
hotel_name	Name of the hotel.	Hostal Plaza Mayor
hotel_country	ISO 3166-1 alpha-2 code of the hotel country.	ES
provider	Human readable name of the intermediary provider of the booking.	Vio.com
check_in	Booking check in date in YYYY-MM-DD format.	2025-02-01
check_out	Booking check out date in YYYY-MM-DD format.	2025-02-02
status1	Status of the booking. One of "confirmed" (booking created), "finished" (stay completed) or "cancelled" (booking cancelled).	confirmed
currency	ISO 4217 code of the currency used to pay the affiliate.	EUR
device	The device from which the booking was made. One of "mobile", "desktop" or "tablet".	mobile
label	Custom string or object set by the affiliate for tracking purposes.	my_tracking_id
value2	Booking value (GBV) in the affiliate currency.	20.00
commission2,3	Commission for the affiliate in the affiliate currency.	10.00
forecasted_commission2,4	Forecasted commission for the affiliate, using the cancellation probability calculated by Vio.com, in the affiliate currency.	8.00
created5,6	Timestamp when the booking entry was created.	2025-01-01 20:00:00
modified5,7	Timestamp of the last update to either the booking status or commission.	2025-01-03 22:00:00
cancelled5,8	Timestamp when the booking cancellation was reported	NULL
cashback_value9	Estimated cashback value that the end-user (booker) will receive in the currency specified by the cashback_currency	452
cashback_currency9	ISO 4217 code of the currency of the estimated cashback. Note that it can also be points or some other imaginary "currency"	points

Notes

1. Bookings in "confirmed" status are considered "finished" 60 days after their check out date.
2. All monetary metrics are reported in the affiliate currency. Currency conversion is done at the booking creation time (created column).
3. The commission will be paid for the booking if the booking is eventually "finished". The value of commission is 0 for "cancelled" bookings.
4. The forecasted_commission adjusts the commission value using Vio.com's internal cancellation probability for the booking. The value of forecasted_commission is not updated when the final status of the booking ("cancelled" or "finished") becomes known. forecasted_commission is only available to specific Partners. Please speak with a Vio Partnerships representative if you want forecasted_commission reported.
5. All timestamps are in UTC timezone and refer to the times when the bookings are processed by the affiliate reporting system, which happens several times a day.
6. The created timestamp is not necessarily the same as the timestamp when the traveler made the booking.
7. The modified timestamp considers only changes in commission and status.
8. The cancelled timestamp is only available when the status is "cancelled".
9. Cashback columns are only available to Cashback White Label Partners.

Access

This report can be accessed via scheduled reporting.

invoice_item

Invoice items with the outstanding balance to be paid by or to the affiliate.

Schema

Column	Description	Example
id1	Unique identifier of the invoice item.	123wde12hhdiu
invoice_id	Unique identifier of the invoice.	kjklsd782
type	Type of invoice item. Currently only "booking".	booking
description	Description of the invoice item.
currency	ISO 4217 code of the currency used to pay the affiliate.	EUR
amount2	Amount to be paid by or to the affiliate in the affiliate currency.	3.00
status	Status of the invoice. One of "issued" or "cancelled".	issued
created3	Timestamp when the invoice was created.	2025-03-15
cancelled3,4	Timestamp when the invoice was cancelled manually by the finance department.	NULL
cashback_value9	Estimated cashback value that the end-user (booker) will receive in the currency specified by the cashback_currency	452
cashback_currency9	ISO 4217 code of the currency of the estimated cashback. Note that it can also be points or some other imaginary "currency"	points

Notes

1. For items of type "booking", the id is the booking id.
2. All monetary metrics are reported in the affiliate currency. Currency conversion is done at the booking creation time (created column).
3. All timestamps are in UTC timezone and refer to the times when the bookings are processed by the affiliate reporting system, which happens several times a day.
4. The cancelled timestamp is only available when the status is "cancelled".
5. Cashback columns are only available to Cashback White Label Partners.

Invoice creation process

The invoice creation happens monthly on the day 15th. In that moment, all bookings with check out date before the first of the current month are processed to calculate the outstanding amount. For that, the amount from the previous invoice items and the latest available commission are used:

amount_outstanding = commission - SUM(amount_issued)

Each month, we issue an invoice based on the affiliate bookings as follows:

• Full commission is paid for bookings for which the status is "finished".
• No commission is paid for bookings for which the status is "cancelled."
• Bookings in "confirmed" status are considered "finished" 60 days after their checkout date if they haven't been cancelled.
• For each booking, you may see up to two invoices:

  - An initial payment 1 month after checkout.
  - An additional invoice to adjust the balance if there are changes in the Vio.com’s earned commission.
  Since the updates of a booking stop 60 days after the check out date, you can receive only up to two invoices for a booking irrespective of changes in Vio.com's earned commission after that period.

Access

This report can be accessed via scheduled reporting and live reporting.

invoice

Monthly invoice with the total outstanding balance to be paid by or to the affiliate.

Schema

Column	Description	Example
id	Unique identifier of the invoice.	affiliate_id_1_2025-06-01
created1	Timestamp when the invoice was created.	2025-06-15 05:05:43.234+0000
status	Status of the invoice. One of "issued" or "cancelled".	issued
cancelled1	Timestamp when the invoice was cancelled manually by the finance department.	null
total_amount	Amount to be paid by or to the affiliate in the affiliate currency	5616.24
currency	ISO 4217 code of the currency used to pay the affiliate.	EUR

Notes

1. All timestamps are in UTC timezone and refer to the times when the bookings are processed by the affiliate reporting system, which happens several times a day.

Invoice creation process

Invoices are created monthly on the day 15th only if there are invoice items (bookings) with a non-zero amount.

Access

This report can be accessed via scheduled reporting and live reporting.