Educational scenario · Form 1099-K Box 1a & 2025 Schedule E Line 3
Airbnb & Vrbo Payout & Gross-to-Net Estimator.
Deconstruct bundled OTA payouts into gross rental revenue, cleaning fees, and platform commissions. Explore an illustrative journal entry and gross-to-net comparison for accountant review.
1. Reservation parameters
2. Modeled settlement & gross-to-net comparison
Gross receipts minus bank deposit: $41.40. Host fees reduce cash; host-collected tax increases cash and is modeled as a payable, separately from rental revenue. Review source records with your CPA.
Illustrative Double-Entry Journal Entry — CPA Review Required
Debits = Credits Balanced| Account Name | Illustrative Account Mapping | Debit | Credit |
|---|---|---|---|
| 1010 Operating Checking | Balance Sheet (Cash) | $1,338.60 | — |
| 6020 OTA Platform Host Fees | Illustrative platform-fee account | $41.40 | — |
| 4010 Gross Rental Revenue | Illustrative rental-revenue account | — | $1,200.00 |
| 4020 Cleaning Fee Reimbursements | Illustrative cleaning-fee account | — | $180.00 |
| Total Entry Balance | $1,380.00 | $1,380.00 | |
Illustrative source-record exercise
Worked payout example
A $1,338.60 bank deposit can represent $1,380.00 of guest charges before a $41.40 host fee. Keep the reservation, fee statement, payout identifier, and bank settlement together so each amount can be explained.
| Source component | Amount | Record to retain |
|---|---|---|
| Nightly rent | $1,200.00 | Reservation statement |
| Guest cleaning charge | $180.00 | Reservation statement; cleaner invoice separately |
| Gross guest charges | $1,380.00 | Sum of rent and cleaning |
| Host fee retained | −$41.40 | Fee statement: chosen 3% of $1,380.00 |
| Modeled bank deposit | $1,338.60 | Payout statement matched to bank settlement |
Assumptions: one reservation, no refunds, reserves, adjustments, or settlement timing difference. An additional $145.00 lodging-tax amount is assumed collected and remitted by the platform outside the host payout. Verify the actual fee base, collection coverage, and tax records. This is a chosen fee scenario, not a universal Airbnb rate; the example does not determine Form 1099-K Box 1a or taxable income.
Download the payout reconciliation example and worksheet (CSV). The file includes the example and blank columns for your own amounts and source-record review; it does not upload your records.
For refunds and year-end settlement differences, read the Airbnb 1099-K reconciliation guide and annual workpaper. Try a different fee or collection assumption in the payout calculator.
Why Gross-to-Net Differences Need Source-Record Review
When third-party settlement organizations (Airbnb, Vrbo, Stripe) file Form 1099-K under IRC § 6050W, they report unadjusted gross reservation volume in Box 1a.
Many hosts make the mistake of setting up bank feed automation in QuickBooks or Excel that categorizes each deposit directly as "Rental Income." This creates two compounding accounting failures:
- Gross-to-Net Difference: Form 1099-K amounts and bank deposits can differ. Reconcile source records and review reporting placement and any notice with your CPA; this calculator does not predict a CP2000 notice.
- Distorted Expense Ratios: Netting an entered host commission and cleaning fees against rent understates your true operating expenses and masks high turnover costs.
Illustrative Accounting Categories to Review
Includes base room charges, extra guest fees, pet fees, and cleaning fees collected from guests.
Actual amounts disbursed to cleaning personnel, laundry services, and turnover technicians.
Chosen host commission assumptions and co-host earnings; guest service fees are outside this host-payout illustration.
Work through a gross-to-net payout and see how it fits a monthly close.
Review supported payout records
Review supported payout components in one workflow.
Roxby imports supported official Airbnb and Vrbo statement files and separates available payout components for reconciliation review.