Co-host operations guide
Reconcile co-host payouts before the owner statement goes out.
A practical month-end workflow for comparing expected and received platform payouts, resolving exceptions, and showing owners where each number came from.
Why owner statements become difficult
A booking can have accommodation revenue, a cleaning fee, taxes, discounts, platform deductions, and a co-host payout rule. Those figures may appear in different platform views, and the amount a platform says it sent may not match the amount available for the owner close.
Airbnb, for example, supports several co-host payout configurations, including a cleaning fee, a cleaning fee plus a percentage, a percentage with or without the cleaning fee, and a fixed amount. The chosen configuration changes what must be checked in the monthly close.
A reliable owner statement therefore needs two linked records:
- Booking economics: what the booking and payout rules imply should happen.
- Cash reconciliation: what the platform actually paid and whether the payment can be matched.
The five-step payout reconciliation workflow
1. Record one completed stay per row
Use a stable booking identifier and keep the property, check-in, check-out, accommodation revenue, cleaning fee, taxes, platform-fee assumption, management rate, and received payout on the same row. Avoid using guest names when the booking identifier is sufficient.
2. Calculate the expected platform payout
Expected payout = gross charge − expected platform deduction
The exact basis must match the reservation detail. Taxes, discounts, currency effects, and fee structures can vary, so a formula should make its basis visible rather than silently assuming that every booking is identical.
3. Compare expected and received cash
Calculate the variance for every booking:
Variance = payout received − expected payout
Use a small tolerance for rounding, then assign one operational status:
4. Calculate the manager fee on the agreed basis
Apply the management rate to the revenue basis defined in the owner agreement. Do not assume the platform's co-host transfer always equals the contractual management fee; cleaning-fee treatment and split-payout settings can create differences.
5. Build the owner statement from reconciled records
Show the reporting period, property, booking identifiers, gross booking amounts, received payouts, manager fees, owner amounts, and any held exceptions. If cash is missing, keep the row visible but do not present the missing amount as cash ready to remit.
Minimum fields for a useful owner statement
- Statement period
- Property identifier
- Booking identifier
- Check-out date
- Gross charge
- Payout received
- Management-fee basis and rate
- Manager fee
- Owner amount due
- Exception status and note
Common reconciliation mistakes
- Treating a payout notification as received cash. Match it to the actual payout record.
- Mixing expected revenue and received payout. Keep both columns and preserve the variance.
- Hiding exceptions from the owner statement. Show that a booking is held for review without presenting missing cash as payable.
- Applying one fee assumption to every reservation. Confirm the real basis when the platform or payout configuration changes.
- Collecting unnecessary personal data. Booking identifiers are usually enough for an operational reconciliation workbook.
Five-screen workbook preview
Use the workflow without rebuilding it every month.
The Co-host Payout & Owner Statement System brings booking inputs, payout exceptions, manager fees, owner statements, and a host-fee scenario into one local Excel workbook.
Sources and scope
This guide describes an operational reconciliation workflow, not tax, accounting, legal, or financial advice. Confirm the actual reservation detail and your owner agreement before calculating a payment.