Current for 2026 Tax Year · Form 1099-K Box 1a & 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
If you record only the $1,338.60 bank deposit in QuickBooks or Excel, your ledger will underreport gross income by $41.40 compared to Form 1099-K Box 1a, which calls for source-record review 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 | |
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 the 3% 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.
Airbnb host service fees (3%), Vrbo traveler and host commissions (8%), and co-host earnings.
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.