Help Centre

How are prices calculated in each pro-rata setting?

Updated on

Expand or collapse content 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)

Expand or collapse content 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?