@Ute42 @Susan17
Both formulas ar correct ...
(nightly rate) x (# of nights) x 0.97 x 0.25
works with strict cancellation policy and a cancellation less then 7 days befor check-in or accordingly with moderat or flexible with cancellation on the day of check-in (or probably earlier by moderate) ... when you normally get paid in full.
(nightly rate) x (# of nights) x 0.97 x 0.50 x 0.25
works, when the cancellation is more upfront and the amount received would be only 50 % (normally).
the 0.97 is what you get normally -> 97 % of the booking (3 % for airbnb)
0.50 -> 50 %
0.25 -> 25 %
0.50 * 0.25 = 0.125 -> 12.5 % .. what we get now (if)
12.5 % = 1/8 of 100 %
... or you could take the amount of the mail with the booking conformation, take away your cleaning fees and then take 1/8 of that.
... but I stall on the 5 letter word : D