Why are there discrepancies in payouts and revenue reports in Hosthub, and how can I reconcile them?
Why are there discrepancies in payouts and revenue reports in Hosthub, and how can I reconcile them?
Discrepancies in payouts and revenue figures are common due to various factors including filtering logic, tax and fee deductions, cancellations, and payout configuration settings in Hosthub. Below is a detailed guide to understanding the reasons behind these differences and how to address them effectively.
Overview of Common Causes
1. Differences in Date Logic
Hosthub reports and payouts may use different criteria for calculating totals:
- Reports include reservations impacting the selected period, even if they start or end before/after the date range. For example, a reservation starting before May 1 but with a checkout after May 1 will still be included in the May reports.
- Payouts are calculated only for bookings with payments made during the selected period.
2. Filtering Discrepancies
- Ensure that all filters (e.g., date ranges and criteria) applied in your report match the data you want to compare. For example, differences between Dashboard and Excel exports can result from unintentional filtering or date logic.
- Align the same date criteria for both the Dashboard and the exported report.
3. Cancellations and Their Impact
- Non-refundable cancelled reservations may still contribute values (e.g., cancellation fees) in reports. Accurately reconciling totals requires accounting for these components.
- For cancelled offline bookings, remember that they might still reflect a non-zero "final payment" value that gets summed into the payout.
4. Tax and Commission Adjustments
- Payouts reflect the net amount you receive after taxes, fees, and channel adjustments.
- Hosthub’s "Revenues" include the full booking amount plus applicable taxes and fees, whereas "Final Payment" reflects what you receive after deductions.
- Differences in tax amounts declared for tax purposes and payouts occur because tax declarations include platform commissions and lodging/accommodation taxes that are not part of your payouts.
5. Configuration Settings
- The "Owners Payout" field will display 0 if no custom payout formula has been set. Ensure that custom payout formulas are configured correctly in the rental’s settings to generate accurate owner payout values in reports.
How to Reconcile the Discrepancies
To reconcile the differences, perform the following steps:
- Align Filters Across Reports: - Use uniform date filters when comparing the Hosthub Dashboard, reports, and exported files. - Double-check for hidden or unintended filters that might exclude certain bookings.
- Examine Cancellations: - Account for non-refundable cancellations and fees that are included in the totals when comparing revenue and payout figures. - Verify offline bookings to ensure no non-zero payment values are contributing to the total despite cancellation.
- Review Tax and Fee Deductions: - Compare the "Total Payout" field in Hosthub (which reflects net payout after deductions) with channel payout data (e.g., Airbnb). - Use breakdowns provided by Hosthub or platforms to understand the components of taxes, fees, and commissions.
- Configure Custom Formulas: - If Owners Payout shows as 0, create and apply a custom payout formula in the rental’s settings, then refresh your report.
- Understand Date Logic: - Note that Hosthub calculates revenues based on the check-in dates for reservations within the selected period, while payouts are determined by payments received. Adjust your comparisons based on this logic.
By following these steps, you can better understand and reconcile differences in payouts and revenue reports within Hosthub.
Updated on: 02/07/2026
Thank you!