The host problem
A cancellation reopens inventory. Most hosts see the reopened nights and immediately cut price to refill. Sometimes it works. Sometimes they refill nights at a rate far below what the canceled booking paid — and call it a recovery.
The worksheet separates those two outcomes. Refilling nights is not the same as recovering revenue. This tool forces the distinction.
Critical measurement rule: Cancellation metrics belong in a separate tracking block from live KPI metrics. Do not merge canceled revenue into live accommodation revenue. Do not count canceled nights as booked nights. Your live ANR, RevPAR, RCI, and Net RevPAR measure the surviving live period only. The worksheet tracks what happened in the cancellation ledger — a different accounting.
What the tool helps you decide
After each cancellation, the worksheet answers:
- How many nights did I lose, and how many did I refill?
- What ANR did I earn on refilled nights versus the original booking?
- Did I recover nights, revenue, or neither?
- Did the cancellation create an orphan gap that still needs action?
- Was this an event-window cancellation that required a different response?
Inputs required
Log one row per cancellation. Each row captures:
- Cancellation date: when the reservation was canceled
- Original check-in date: when the guest was supposed to arrive
- Original check-out date
- Nights canceled: total nights in the canceled reservation
- Original ANR: accommodation revenue from the canceled booking ÷ nights in that booking
- Lead time at cancellation: days between cancellation date and original check-in date
- Refilled nights: count of canceled nights that you rebooked before the check-in date
- Replacement accommodation revenue: total accommodation revenue from refill bookings covering those nights
- Replacement ANR: Replacement Accommodation Revenue ÷ Refilled Nights
- Orphan flag: yes/no — did the cancellation create a one- or two-night gap that could not attach to adjacent demand?
- Event window flag: yes/no — did the cancellation fall inside a major local or regional event window?
- Action taken: Hold, Cut, Raise, Reshape, or Wait
Outputs produced
The worksheet calculates:
- Night Recovery Rate = Refilled Nights ÷ Nights Canceled
- Revenue Recovery Rate = Replacement Accommodation Revenue ÷ (Original ANR × Nights Canceled)
- ANR Delta = Replacement ANR minus Original ANR (negative means you refilled at a lower rate)
- Orphan status (flag for follow-up if unresolved)
- Event-window note (flag indicating a different post-mortem standard applies)
Example
A host loses a 4-night booking. Original ANR was $150. She refills 3 of the 4 nights at an average of $110 per night.
- Night Recovery Rate = 3 ÷ 4 = 75%
- Original Revenue Expected = $150 × 4 = $600
- Replacement Revenue = $110 × 3 = $330
- Revenue Recovery Rate = $330 ÷ $600 = 55%
- ANR Delta = $110 minus $150 = negative $40
She recovered three-quarters of the nights but only 55 percent of the revenue. The remaining night is unrefilled and may be an orphan depending on the surrounding calendar.
That is a partial recovery, not a successful one — even though the calendar looks nearly filled.
What most hosts get wrong
The most common mistake is declaring victory when refilled nights match or exceed canceled nights without checking replacement ANR. Night recovery is not revenue recovery. A 100 percent night recovery at 60 percent of original ANR still represents meaningful economic loss.
The second mistake is treating event-window cancellations the same as off-peak cancellations. If a cancellation falls inside an event window, do not automatically cut to refill. Check whether event demand still exists at the shorter lead time. If it does, protect rate and solve shape first.
How to use it this week
- Pull your last cancellation: dates, original ANR, and what you rebooked afterward.
- Enter the numbers into the worksheet.
- Calculate Night Recovery Rate and Revenue Recovery Rate.
- Flag any orphan night still open.
- Note what pricing action you took and whether it matched the evidence.
Connected articles
- Cancellation Recovery: When to Hold, Cut, or Reshape
- How Airbnb Cancellations Change Your Pricing Decision
- How to Price After a Last-Minute Airbnb Cancellation
- Airbnb Orphan Night Strategy
- Airbnb Cancellation Recovery Playbook
Educational note
This page is educational. It is not tax, legal, investment, or guaranteed-income advice.