Revenue & cost attribution settings
TL;DR
- Set one attribution type per Client/Owner account. It applies to all properties linked to that client.
- Statements are monthly and per property. Attribution only determines which bookings are included in each month’s statement (and how much).
- Three attribution types:
- Prorated (by nights): splits total booking revenue (and booking‑linked costs) across statements, based on number of nights in each month.
- Check‑in: includes all bookings that start (check-in date) in the month of the statement.
- Check‑out (default): includes all bookings that end (check-out date) in the month of the statement.
- Finalised statements are locked. In the case of prorated attribution, if prices for a booking change after a previous month statement has been finalized, the adjusted revenue and cost will be attributed to the current month. If you would like to re-distribute it for a more accurate view, unfinalise the earlier month.
Please review this page when switching between attribution type settings, to understand their impact on reporting and take any necessary actions to prevent mis-/under-reporting booking revenue and costs.
Good to know: For booking‑linked costs/fees (e.g., cleaning fee billed with the booking), the selected attribution type governs inclusion alongside the booking’s revenue. Standalone and/or recurring expenses not tied to a booking are included in the statement for the month they are dated.
Where to set Attribution rules
Path: Clients → Clients → [Select Client] → Profile tab → Attribution Type
Change here once; it applies to all properties under this client going forward.
How attribution works
Example Scenario Used Throughout
We’ll use three bookings that span October → November to illustrate the three attribution types.
Bookings:
- Booking 1: 7 nights, $3,500 total, Check‑in: Oct 30, Check‑out: Nov 6 → Average $500/night
- Booking 2: 2 nights, $700 total, Check‑in: Oct 30, Check‑out: Nov 1 → Average $350/night
- Booking 3: 2 nights, $1,200 total, Check‑in: Nov 2, Check‑out: Nov 4 → Average $600/night
Nights by Calendar Day
| Booking/dates | 30 Oct | 31 Oct | 1 Nov | 2 Nov | 3 Nov | 4 Nov | 5 Nov | 6 Nov |
|---|---|---|---|---|---|---|---|---|
| Booking 1 ($3,500) | $400 | $400 | $700 | $700 | $450 | $450 | $400 | out |
| Booking 2 ($700) | $350 | $350 | out | |||||
| Booking 3 ($1,200) | $600 | $600 | out |
Attribution Types
1. Prorated
Distributes each booking’s revenue across the months by nights that fall in the statement period.
Example Calculation
- Booking 1: 7 nights - 2 nights in October, 5 nights in November
- October:
2/7 * 3500 = $1000 - November:
5/7 * 3500 = $2500
- October:
Monthly Totals
| Booking/months | October | November |
|---|---|---|
| Booking 1 ($3,500) | $1,000 | $2,500 |
| Booking 2 ($700) | $700 | |
| Booking 3 ($1,200) | $1,200 | |
| Total ($5,400) | $1,700 | $3,700 |
2. Check-in
Includes only bookings whose check-in date is within the statement month.
| Booking/months | October | November |
|---|---|---|
| Booking 1 ($3,500) | $3,500 | |
| Booking 2 ($700) | $700 | |
| Booking 3 ($1,200) | $1,200 | |
| Total ($5,400) | $4,200 | $1,200 |
3. Check-out (Default)
Includes only bookings whose check-out date is within the statement month.
Monthly Totals
| Booking/months | October | November |
|---|---|---|
| Booking 1 ($3,500) | $3,500 | |
| Booking 2 ($700) | $700 | |
| Booking 3 ($1,200) | $1,200 | |
| Total ($5,400) | $0 | $5,400 |
Note: In this scenario, Booking 2 will be fully allocated to November, since check-out is in November, even though none of the nights fall in November.
Costs & Fees
- Booking-linked costs/fees follow the same attribution logic as the booking’s revenue.
- Stand-alone costs appear in the month matching their posted or cost date.
Negative adjustments can occur in open months if earlier ones are finalised and later price/cost updates shift attribution.
Booking price/fee changes
- When no months are finalised, updates propagate naturally.
- If one month is finalised:
- Example: Booking 1 originally $3,500; October is finalised at $1,000. If price changes to $4,000 → November gets the additional $500 allocated, for a total of $3,000.
- If October is later unfinalised, system recalculates:
$4,000 ÷ 7 = ~$571/night → October: $1,142, November: $2,857
Good to know: Future months may show negative revenue if initial month was finalised at a higher value and total price drops.
Finalise vs Unfinalise
- Finalise locks the statement and its totals.
- Unfinalise reopens it for recalculation.
This is essential when changing attribution type or after price edits.
Switching Attribution Types
When changing attribution logic with previous month's statement in a finalised status, revenue and costs could be mis-allocated or even under-reported. In the example below, the switch happens in November, with the October statement already finalised.
A. Check-in → Check-out
Optional: Unfinalise October statement to re-allocate costs accurately.
| Month | October | November | Total |
|---|---|---|---|
| Revenue Expected | $0 | $5,400 | $5,400 |
| Revenue Shown (if Oct finalised) | $4,200 | $1,400 | $5,400 |
| Revenue Shown (if Oct unfinalised) | $0 | $5,400 | $5,400 |
B. Check-in → Prorated
Optional: Unfinalise October statement to re-allocate costs accurately.
| Month | October | November | Total |
|---|---|---|---|
| Revenue Expected | $1,700 | $3,700 | $5,400 |
| Revenue Shown (if Oct finalised) | $4,200 | $1,400 | $5,400 |
| Revenue Shown (if Oct unfinalised) | $1,700 | $3,700 | $5,400 |
C. Check-out → Check-in
Required: Unfinalise October statement to re-allocate costs accurately and prevent under-reporting.
| Month | October | November | Total |
|---|---|---|---|
| Revenue Expected | $4,200 | $1,200 | $5,400 |
| Revenue Shown (if Oct finalised) | $0 | $1,200 | $1,200 |
| Revenue Shown (if Oct unfinalised) | $4,200 | $1,200 | $5,400 |
D. Check-out → Prorated
Required: Unfinalise October statement to re-allocate costs accurately and prevent under-reporting.
| Month | October | November | Total |
|---|---|---|---|
| Revenue Expected | $1,700 | $3,700 | $5,400 |
| Revenue Shown (if Oct finalised) | $0 | $3,700 | $3,700 |
| Revenue Shown (if Oct unfinalised) | $1,700 | $3,700 | $5,400 |
E. Prorated → Check-out
Optional: Unfinalise October statement to re-allocate costs accurately.
| Month | October | November | Total |
|---|---|---|---|
| Revenue Expected | $0 | $5,400 | $5,400 |
| Revenue Shown (if Oct finalised) | $1,700 | $3,700 | $5,400 |
| Revenue Shown (if Oct unfinalised) | $0 | $5,400 | $5,400 |
F. Prorated → Check-in
Required: Unfinalise October statement to re-allocate costs accurately and prevent under-reporting.
| Month | October | November | Total |
|---|---|---|---|
| Revenue Expected | $4,200 | $1,200 | $5,400 |
| Revenue Shown (if Oct finalised) | $1,700 | $1,200 | $2,900 |
| Revenue Shown (if Oct unfinalised) | $4,200 | $1,200 | $5,400 |
Updated 9 days ago