Help Centre

How are prices calculated in each pro-rata setting?

Updated on

Pro-rata after first week (example calculation)

This setting comes into action if you have a guest book a stay for dates that cross-over two price bands within your Price Planner:

Use the following calculation (example booking is 7 nights):

4 nights fall within the first price band of £1000 (1000 / 7 = 142.86 (the daily rate) x 4 nights = £571.42)

3 nights fall within the second price band of £2000 (2000 / 7 = 285.71 (the daily rate) x 3 nights = £857.14)

TOTAL FOR 7 NIGHTS 857.14 + 571.42 = £1428.57

Entire calculation: ((1000/7)*4)+((2000/7)*3)

For stays of more than 7 nights (example booking is 10 nights):

Use the above calculation to work out the 7 night price and then use that solution in the following calculation to work out the remaining 3 nights:

7 night price previously calculated/7 x 3 nights  e.g. (£1428.57/7 = £204.08 (the daily rate) x 3 nights = £612.24)

TOTAL FOR 10 NIGHT STAY 1428.57 + 612.24 = £2040.81

Entire calculation: ((1000/7)*4)+((2000/7)*3)+((1428.57/7)*3)

Calculate short breaks across price bands (example calculation)

If selected, this option will apply to short break bookings which span over two different price bands.

Example calculation of 4 nights:

2 nights fall within the first price band so we take the 4 night price of £400 and divide it by 4 (the length of stay) = £100 (the daily rate)  x  2 nights e.g. (400/4)*2 = £200

2 nights fall within the second price band with a 4 night price of £500 so again using the above calculation we have (500/4)*2 = £250

TOTAL FOR 4 NIGHTS £200 + 250 = £450.00

Entire calculation: ((400/4)*2)+((500/4)*2)

Please note:
If either a Friday or a Saturday is part of the booking, you need to use the weekend prices.

Previous Article How to create a CSV file from the printable prices table
Next Article How can I bulk increase my prices in the priceplanner?