Format
The format of LoS pricing breakdown is as follows and should be delivered in CSV format:
Accommodation column represents the base price value without fees and taxes.
Fee column represents the value of total fees for a checkin, nr guests and lengh of stay combination. Tax column represents the value of total taxes for a checkin, nr guests and lengh of stay combination.
Total column represents the total price value, which is the sum of base price value with fees and taxes applied.
The Discount column indicates the amount already deducted from the Total. It does not affect pricing but highlights the discount applied to demonstrate the value provided to guests.
The matrix must contain these 5 columns by the following order Accommodation, Fee, Tax, Total, Discount.
| CheckIn | Guests | Los1Accommodation | Los1Fee | Los1Tax | Los1Total | Los1Discount | Los2Accommodation | Los2Fee | Los2Tax | Los2Total | Los2Discount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-12-20 | 4 | 200 | 10 | 0 | 210 | 100 | 300 | 50 | 10 | 360 | 250 |
| 2023-03-01 | 4 | 600 | 0 | 600 | 1200 | 1000 | 800 | 0 | 600 | 1400 | 1100 |
| CheckIn | Guests | LosXAccommodation | LosXFee | LosXTax | LosXTotal | LosXDiscount |
|---|---|---|---|---|---|---|
| 2022-12-20 | 4 | 200 | 10 | 0 | 210 | 100 |
| 2023-03-01 | 4 | 600 | 0 | 600 | 1200 | 1000 |
Rules & Examples
1. A price of 0 indicates no availability.
For example, if there was a booking from 1/12/2022 to 3/12/2022 for a home priced at £200/night, the table would look like this for the first week of December 2022 (assuming no other pricing or availability rules):
| CheckIn | Guests | Los1Accommodation | Los1Fee | Los1Tax | Los1Total | Los1Discount | Los2Accommodation | Los2Fee | Los2Tax | Los2Total | Los2Discount | Los3Accommodation | Los3Fee | Los3Tax | Los3Total | Los3Discount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-12-01 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2022-12-02 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2022-12-03 | 4 | 200 | 400 | 600 | 1400 | 1000 | 200 | 400 | 600 | 1200 | 1000 | 200 | 400 | 600 | 1200 | 1000 |
| 2022-12-04 | 4 | 200 | 400 | 600 | 1400 | 1000 | 200 | 400 | 600 | 1200 | 1000 | 200 | 400 | 600 | 1200 | 1000 |
| 2022-12-05 | 4 | 200 | 400 | 600 | 1400 | 1000 | 200 | 400 | 600 | 1200 | 1000 | 200 | 400 | 600 | 1200 | 1000 |
| 2022-12-06 | 4 | 200 | 400 | 600 | 1400 | 1000 | 200 | 400 | 600 | 1200 | 1000 | 200 | 400 | 600 | 1200 | 1000 |
| 2022-12-07 | 4 | 200 | 400 | 600 | 1400 | 1000 | 200 | 400 | 600 | 1200 | 1000 | 200 | 400 | 600 | 1200 | 1000 |
2. Discount Rules
Length of Stay Discount: If you have a discount on stays of a certain length, then this must be included in the matrix. For example, if a stay of 7 nights gets a 10% discount then the matrix would like so - 10% of Los7 Total:
| CheckIn | Guests | ... | Los7Accommodation | Los7Fee | Los7Tax | Los7Total | Los7Discount |
|---|---|---|---|---|---|---|---|
| 2022-12-20 | 4 | ... | 0 | 0 | 0 | 0 | 0 |
| 2022-12-21 | 4 | ... | 0 | 0 | 0 | 0 | 0 |
| 2022-12-22 | 4 | ... | 600 | 400 | 200 | 1200 | 120 |
| 2022-12-23 | 4 | ... | 800 | 400 | 200 | 1400 | 140 |
2.1 A discount price of 0 indicates no discount
To not display any discount value in the platform, the value of LosXDiscount should be 0 or left empty.
| CheckIn | Guests | ... | Los7Accommodation | Los7Fee | Los7Tax | Los7Total | Los7Discount |
|---|---|---|---|---|---|---|---|
| 2022-12-20 | 4 | ... | 0 | 0 | 0 | 0 | 0 |
| 2022-12-21 | 4 | ... | 0 | 0 | 0 | 0 | 0 |
| 2022-12-22 | 4 | ... | 600 | 400 | 200 | 120 | NULL |
| 2022-12-23 | 4 | ... | 800 | 400 | 200 | 140 | NULL |
3. The matrix should contain all pricing possibilities. We will not add any discounts or pricing rules to the price stated in the matrix except for tax.
Example 2.1: Additional Guests
Additional Guests: If pricing is higher with 5 guests, a second set of data would be expected with the prices for 5 guests. For example, using the table in the format section, if the price of an additional guest above 4 guests is £50 / night, the matrix should be changed to look like so:
| CheckIn | Guests | LosXAccommodation | LosXFee | LosXTax | LosXTotal | LosXDiscount |
|---|---|---|---|---|---|---|
| 2022-12-20 | 4 | 200 | 100 | 50 | 350 | 0 |
| 2022-12-20 | 5 | 250 | 100 | 50 | 400 | 0 |
| 2023-03-01 | 4 | 600 | 0 | 0 | 600 | 0 |
| 2023-03-01 | 5 | 650 | 0 | 0 | 650 | 0 |
4. The matrix should contain all availability possibilities. We will not apply any additional availability rules to the matrix.
The matrix must list every possible booking scenario, showing available and unavailable options.
Apply all availability rules, such as minimum/maximum nights or check-in restrictions, when building the matrix.
If a stay is not available, display a price of 0 for that combination.
Example 4.1: Minimum Night Stay
Minimum Night Stay: If you have a minimum night stay, then this must be included in the matrix. For example, if we use the table listed in the format section, and then apply a minimum night stay of 3 nights and no pricing rules, the matrix should look like so:
| CheckIn | Guests | ... | Los3Accommodation | Los3Fee | Los3Tax | Los3Total | Los3Discount | ...Los7Accommodation | Los7Fee | Los7Tax | Los7Total | Los7Discount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-12-20 | 4 | ... | 600 | 10 | 0 | 610 | 0 | 700 | 50 | 10 | 760 | 120 |
| 2022-12-21 | 4 | ... | 600 | 10 | 0 | 610 | 0 | 700 | 50 | 10 | 760 | 120 |
Example 4.2: Maximum Night Stay
Maximum Night Stay: If you have a maximum night stay, then this must be included in the matrix. For example, if we use the table listed in the format section, and then apply a maximum night stay of 3 nights and no pricing rules, the matrix should look like so:
| CheckIn | Guests | ...Los1Total... | ...Los2Total | ...Los3Total... | ...Los4Total... | ...Los7Total... |
|---|---|---|---|---|---|---|
| today | 4 | 100 | 200 | 400 | 0 |
Example 4.3: Blocked Check-in
Blocked Check in: If you have a blocked check-in date, then this must be included in the matrix. For example, if we use the table listed in the format section, and then apply a blocked check-in on saturdays, you don’t add that date on the matrix, so it should look like:
| CheckIn | Guests | ...Los1Total... | ...Los2Total | ...Los3Total... | ...Los4Total... | ...Los7Total... |
|---|---|---|---|---|---|---|
| 2025-11-07 | 4 | 100 | 200 | 400 | 500 | 600 |
| 2025-11-09 | 4 | 200 | 400 | 1400 | 1500 | 2000 |
5. We can accept pricing up to 2 years in advance.
6. Do not send header rows. If you have less than 730 nights data, then send less columns.
7. We can accept any currency for LoS pricing.
8. Please include cleaning fees in the pricing matrix. Cleaning fees sent using the POST Cleaning Fee endpoint will be ignored.
Process Time
Due to the time taken to process a price matrix, this will not be a synchronous process. Your matrix will be accepted and processed asynchronously. We will not give a guaranteed time in which it will be processed and made available.
