4.9 KiB
HTVR Invoicing explainer
Summary
The net position of HTVR between February 2024 and 31st January 2025 is, according to invoicing data, ~303K GBP. The client is stating that the net amount should be ~327K GBP, which is NOT the case.
However, the client can challenge us for a double charged amount of 3,030 USD because of 303 duplicated bookings.
Cleaning the duplicated bookings and re-doing the computation, the net position of HTVR between would be ~306K USD, coming from:
- ~ -124K USD Booking Fees, and
- ~430K USD Net Waivers Amount due to Host
Re-doing the client hypothesis, the net position would result into ~319K USD, but this is wrong because it cannot be assumed that the compute comes uniquely from Approved Bookings at 30 USD per booking fee since:
- Bookings with status different to Approved are also charged. This accounts for ~ -18K USD
- Waivers can be charged to Bookings with Status different than Approved. This accounts for ~ 5K USD
Detail
Cleaning Bookings data
| Count | |
|---|---|
| Total Bookings | 12,730 |
| Duplicated Bookings | 303 |
| Unique Bookings | 12,427 |
| Unique Approved Bookings | 10,626 |
We have a discrepancy on 303 bookings that are duplicated. We will remove them to have a clean computation. This are available in the Unique Bookings tab.
Hypothesis
Amount due to Host is 30 USD X Unique Approved Bookings = 318,780 USD
Actual computation (excl. duplicated bookings)
We invoice based on:
- Booking Fees
- This applies to ALL bookings, indistinctly of the status (Approved, Cancelled, Not Approved).
- Therefore: 12,427 Unique Bookings X 10 USD booking fee = 124,270 USD.
- Net Waivers Amount due to Host
- This takes into account Waivers that have been charged in period minus waivers that have been refunded in period.
- Waivers Charged up to 31st Jan 2025 = 11,704
- Source: Stripe Export - Paid, filtering by happened_after_january = FALSE
- Waivers Refunded up to 31st Jan 2025 = 941
- Source: Stripe Export - Refunded, filtering by happened_after_january = FALSE
- Net Waivers Count = 11,704 - 941 = 10,763
- Net Waivers Amount due to Host = 10,763 X 40 USD = 430,520 USD
Which results into:
- Net Payouts (excl. duplicated bookings) = Net Waivers Amount due to Host - Booking Fees = 430,520 USD - 124,270 USD = 306,250 USD
Note here that this figure differs from the net amount of that has actually been invoiced, as the actual amount invoiced takes into account 3,030 USD from the 303 duplicated bookings.
Explaining differences
The hypothesis results into a position of 318,780 USD in favour of the Host.
The actual computation, excluding the duplicated bookings, results into a position of 306,250 USD in favour of the Host.
The Host could mistakenly assume that we owe them 318,780 USD - 306,250 USD = 12,530 USD
Difference 1: Bookings with status different to Approved are also charged
The amount of unique bookings that don’t have the status approved can be retrieved from:
- Unique Bookings - Unique Approved Bookings = 1,801
Therefore, the Booking Fees from these status will be:
- 10 USD X 1,801 = 18,010 USD
This explains MORE than the actual difference of 12,530 USD, so technically we could mistakenly assume that we have paid more to the Host than what’s needed. Let’s jump into difference 2.
Difference 2: Waivers are not always being charged in the same period, and are not only linked to Approved Bookings
The count of net waivers up to 31st January 2024 is 10,763 Waivers.
This is more than the actual amount of Approved Unique Booking, that is 10,626.
Thus by simple look at the figures, we can see that we actually received more Waivers than Approved Unique Bookings in the same period. This is because Bookings with other status aside from Approved can actually be charged and not necessarily refunded.
- Waivers attributed to Bookings with a Charge and without a Refund with Status different than Approved = 134
- Source: Unique Bookings - filtering by Is Waiver Charged = True, Is Waiver Refunded = True, Status ≠ Approved
Applying a 40 USD amount due to host, this results into:
- Waiver Amount due to Host on Bookings with Status different than Approved = 134 X 40 USD = 5,360 USD
Consolidation
- Bookings with status different to Approved are also charged = 18,010 USD
- Waiver Amount due to Host on Bookings with Status different than Approved = 5,360 USD
- Difference = 12,650 USD
Comparing this figure with the differences in computations from the Hypothesis and the actual computation, which is 12,530 USD, results into:
- 12,650 - 12,530 USD = 120 USD
Technically, we cannot assume all Approved Bookings will have a waiver charge and that being happening on the same period. Also, while generally is true that an Approved Booking will contain a Waiver charged, there’s a few cases of approved bookings without a waiver charged, and even some cases in which the waiver is charged and refunded. Therefore, this can explain the differences.