We need a reporting variable that returns accommodation revenue earned by stay date within the reporting period (sum of nightly rates for those dates) instead of ADR-prorated totals. Without this, cross-month extensions retroactively change closed accounting periods and owner statements.

Because revenue is currently prorated using blended ADR, any cross-month reservation that is later modified retroactively changes revenue in already-closed accounting periods; we need a reporting field that recognizes accommodation revenue by stay date (sum of nightly charges in the period) so closed months remain financially stable.

example

A guest books:

Dec 20 – Jan 5

16 nights total

Each night priced at $100

Total reservation value = $1,600

For December reporting:

December nights = 12

Correct December revenue = 12 × $100 = $1,200

Later, the guest extends the reservation:

Extends Jan 5 → Jan 10

New extension nights priced at $200/night

New reservation total = $2,600

New ADR becomes $123.81

Using ADR prorating (current behavior):

December revenue becomes 12 × $123.81 = $1,485.72

December revenue changes retroactively, even though those nights were already stayed and reported.

Desired behavior

December revenue should remain $1,200, because the nightly prices for the December stay dates did not change.

To support accurate month-end accounting and owner statements, we need a reporting variable that returns:

“Accommodation revenue earned in the reporting period based on the nightly prices for the stay dates within that period (sum of nightly rates in period)”

instead of:
“Reservation total × fraction earned.”