Extract Airbnb and VRBO Earnings for Schedule E or C

A US short-term rental host reports Airbnb and VRBO income on Schedule E when the activity is a passive rental, and on Schedule C (subject to self-employment tax) when the activity is a trade or business. The decisive test for most hosts is the seven-day rule in Treasury Regulation §1.469-1T(e)(3)(ii): an activity involving the use of tangible property is not a rental activity for a taxable year if the average period of customer use is seven days or less — the rule that pushes most short-term rental activity off Schedule E and into Schedule C. Substantial services (cleaning during stays, meals, concierge, daily linens) force Schedule C regardless of average stay length, and Schedule C carries self-employment tax.

To extract Airbnb and VRBO earnings for Schedule E or C, reconcile the platform 1099-K against the Airbnb Annual Earnings Summary or the VRBO Payout Summary before populating any return line. The 1099-K's gross-payments figure and the earnings-summary's net-of-fees figure are built differently by design, and plugging either one straight into Schedule E Line 3 or Schedule C Line 1 without walking the bridge produces a return that does not tie to the information return on file with the IRS.

The workflow below assumes four documents are in hand: the Airbnb Annual Earnings Summary for each listing, the VRBO Payout Summary for each listing, a Form 1099-K from each platform that issued one, and the folder of host-side receipts for costs the platforms do not track — cleaning paid outside the platform, supplies, utilities, repairs, management fees, mortgage interest, property tax, insurance, and depreciation.

Substantial services, material participation, and the STR loophole branch

The seven-day rule answers whether the activity is a rental for passive-activity purposes. It does not, on its own, answer whether the activity files on Schedule E or Schedule C. Two further tests complete the classification.

The substantial-services test. Schedule C applies when the host provides substantial services to guests during the stay: daily cleaning while the unit is occupied, prepared meals, in-stay linen changes, transportation, concierge bookings, guided activities. Routine pre-arrival cleaning, linens laid out before check-in, utilities included in the nightly rate, and a supplied welcome book are not substantial services on their own. IRS Publication 527 Chapter 3 (Rental of Personal Property) and Chapter 5 (Personal Use of Dwelling Unit) frame how the service-level test reads against a typical STR, and the instructions for Schedule E (Form 1040) and Schedule C (Form 1040) govern the form-mechanics layer that sits under this decision.

The material-participation tests. Treasury Regulation §1.469-5T sets out seven tests; three of them carry most STR fact patterns. A host who spends 500 or more hours on the activity in the year meets the 500-hour test. A host whose participation is substantially all of the participation by anyone (including paid cleaners and contractors) in the activity meets the substantially-all test. A host who spends more than 100 hours on the activity and more than any other single individual meets the more-than-100-hours test — usually the binding test for a single-property host who uses a cleaning service. The tests apply year by year. Time logs, reservation calendars, cleaning-service invoices, and communication records are what carry the material-participation position under examination; an undocumented assertion of 500 hours will not.

The STR loophole as a decision branch. Where the average guest stay is seven days or less (or 30 days or less with substantial services) and the host also materially participates, losses from the activity are non-passive and can offset W-2 or other active income. That combination — the seven-day activity characterization plus material participation — is what social-media tax content calls the STR loophole. It is a real Code position, but the downstream consequences matter: Schedule C filers owe self-employment tax on the net, depreciation recapture applies on sale of the property, and the recordkeeping burden is higher than a passive Schedule E. Route decisions on whether to take the loophole position through a CPA familiar with §469 rather than a generic tax-prep workflow.

The practical framework for the typical host. A seven-day or shorter average stay with no substantial services and no material-participation claim defaults to Schedule E with passive-activity loss treatment. Substantial services or an active trade-or-business posture moves the filing to Schedule C. The choice between Schedule E with material participation (for non-passive loss treatment) and Schedule C (for active-business treatment) is a facts-and-circumstances judgment on what the host actually does day to day, not a preference setting.

One constraint worth stating plainly: the same property in the same year does not split between Schedule E and Schedule C. Classification is made at the activity level for the year. A mid-year change — adding substantial services, flipping from long-term to short-term rental, bringing a property-management company in or out — has to be documented coherently across the year, not retrofitted at tax time.

What the platforms issue: 1099-K thresholds and what's reportable regardless

The federal 1099-K threshold for short-term rental platforms is currently $20,000 in gross payments and more than 200 transactions for the calendar year. The One Big Beautiful Bill Act, enacted in 2025, restored that long-standing threshold for 2025 and 2026, replacing the $2,500 (2025) and $600 (2026) figures that the American Rescue Plan Act had set and that a substantial amount of competing tax-prep content still quotes. Verify the figure against the current IRS Form 1099-K instructions before filing, but expect the $20,000 / 200-transaction number to be what Airbnb and VRBO use when deciding who receives a 1099-K for federal purposes.

The threshold governs issuance, not reportability. All short-term rental income is reportable on the federal return regardless of whether Airbnb or VRBO issues a 1099-K. The 1099-K is an information return; the figures that populate Schedule E Line 3 or Schedule C Line 1 come from the Annual Earnings Summary or Payout Summary combined with the host's own ledger, not from the 1099-K itself. A host with three weeks of bookings and $4,000 in gross revenue has $4,000 in reportable income whether or not a 1099-K arrives in the mail.

What each platform issues:

• Airbnb. A 1099-K to hosts who meet the federal threshold, plus any applicable state threshold in the state of residence. Every host, above or below the threshold, can access an Annual Earnings Summary from the tax documents section of the host dashboard. Airbnb does not issue a 1099-MISC for host earnings under normal circumstances.
• VRBO. A 1099-K on the same basis. Every host can download the Payout Summary from the Financial Reporting area of the host dashboard regardless of threshold.

The state-threshold layer. Several states set their own 1099-K thresholds below the federal figure. Massachusetts, Vermont, Virginia, Maryland, Illinois, New Jersey, and the District of Columbia are among the jurisdictions that have adopted lower thresholds, and the exact figures shift. A host whose activity sits below the federal threshold can still receive a 1099-K triggered by the state threshold. Each platform's tax documents page surfaces the state rules that applied to the host's account for the year, and the state figures are worth reading rather than assuming. If multiple 1099-Ks (federal plus state) arrive for the same income, they report the same payments, not separate amounts — do not double-count. For the mechanics of pulling 1099-K and related information returns into a structured workbook alongside the platform summaries, see our guide on how to extract 1099-K and 1099-NEC data into a spreadsheet.

Occupancy, transient, and resort taxes are a separate compliance workstream. Local transient occupancy, hotel, and resort taxes are a state and city obligation that Airbnb and VRBO collect and remit in some jurisdictions and not in others. Where the platform collects and remits, the amount shows up on the earnings summary as an information line and is neither income nor a federal deduction to the host. Where the host self-collects and remits, the collection is a liability rather than revenue, and the remittance is a local-tax line on its own books — not a federal income-tax deduction, and not a return-line entry on Schedule E or Schedule C. Keep occupancy-tax bookkeeping on a separate track from the federal return.

1099-NEC issuance flows the other way. A host who pays cleaners, handymen, co-hosts, or other service providers $600 or more in the calendar year, and who pays them as unincorporated contractors, has a 1099-NEC filing obligation on the host side. These filings sit separately from the income reconciliation but tie back to the Schedule E or Schedule C expense lines the payments are claimed on, so keep the vendor W-9s and the 1099-NEC copies with the return-prep file rather than in a year-end scramble.

Extract the Airbnb Annual Earnings Summary column by column

The Airbnb Annual Earnings Summary is a per-listing document accessible from the host dashboard under Transaction History or Earnings, with a tax-documents view that consolidates across listings. It summarizes gross earnings, adjustments, and amounts paid out for the calendar year, calculated from completed reservations — cancelled-and-refunded reservations appear as refunds against gross rather than as deleted rows. Hosts with multiple listings receive one summary per listing; a single-listing host works from a single file.

The practical question is what each column represents, whether it already nets fees or refunds, and which Schedule E or Schedule C line it feeds.

The Airbnb columns and what they mean

• Gross earnings. The pre-fee, pre-refund total the guest paid Airbnb for the listing for the year. This is the revenue figure, not a payout figure.
• Host service fees. The 3% (or equivalent) host service fee Airbnb retained from each payout. Surfaced as its own line so the host can see what the platform kept.
• Adjustments. Resolution-center debits and credits posted during the year — damage claims paid by guests, host-initiated goodwill refunds, and similar one-off movements.
• Refunds. Guest refunds, both host-initiated and platform-initiated, netted against gross revenue.
• Pass-through fees. Cleaning fees, pet fees, and extra-guest fees the host configured on the listing and that Airbnb collected from the guest and passed through to the host. These are part of gross earnings.
• Occupancy taxes collected and remitted by Airbnb. Surfaced on a separate information line. Neither income nor expense to the host where Airbnb handled the remittance.
• Tax withheld. Federal or state tax Airbnb withheld on the host's behalf in specific situations (typically where the host did not provide a valid tax ID). Shown separately from gross.

Which Airbnb column maps to which return line

Airbnb column	Schedule E line	Schedule C line
Gross earnings (including pass-through fees)	Line 3 — Rents received	Line 1 — Gross receipts or sales
Host service fees	Line 10 — Commissions, or Line 19 — Other (labelled "platform service fees")	Line 10 — Commissions and fees
Refunds	Net against Line 3 revenue	Line 2 — Returns and allowances
Pass-through cleaning fees paid out to a cleaner	Line 7 — Cleaning and maintenance	Line 11 — Contract labor, or Line 22 — Supplies
Occupancy taxes collected and remitted by Airbnb	Not reported — neither income nor expense	Not reported — neither income nor expense
Resolution-center adjustments (damage recoveries, reimbursements)	Fact-dependent — see Section 7	Fact-dependent — see Section 7

The one line that catches hosts: Airbnb passes cleaning fees through to the host as revenue, then the host pays the cleaner separately as an expense. Both sides belong on the return. Treating the cleaning fee as a wash — because the money came in and went out — understates both revenue and expense and creates a mismatch against the 1099-K.

Reconcile the Annual Earnings Summary to 1099-K Box 1a

The Airbnb 1099-K reports gross payments in Box 1a: the guest's total payment before the host service fee is netted and before any refunds are processed. The Annual Earnings Summary's gross earnings line is built on a different basis — it reflects the revenue recognized on the host's side, which nets some items the 1099-K does not.

Walk the bridge as arithmetic rather than assumption. Starting from 1099-K Box 1a gross, add back any items the 1099-K excluded (rare, but year-end-straddling bookings can appear here), subtract the host service fees Airbnb retained, and subtract refunds paid to guests. The result should equal the Annual Earnings Summary's net payout figure for the year. Airbnb's tax documents section includes a reconciliation table that shows this arithmetic year by year; start with that table and rebuild the bridge in the host's own ledger with the amounts that will populate the return. Mismatches almost always trace to bookings where the reservation and the payout fell on opposite sides of December 31, refunds processed after the 1099-K cutoff, or resolution-center activity that posted late.

Co-host payouts are the one Airbnb column that behaves differently depending on the co-host's payout setup. If a co-host receives funds directly from Airbnb, that share does not pass through the primary host's 1099-K or gross earnings once Airbnb splits the payout; if the primary host receives the full payout and pays the co-host separately, the full amount is the primary host's income and the co-host payment is an expense. The detail belongs in the edge-cases section.

Once the Airbnb numbers tie, the extraction step is mechanical: each column becomes a field in a spreadsheet row, each row becomes a return-line amount, and the 1099-K bridge becomes a working-paper tab behind the return. For hosts with multiple listings, a folder of year-end PDFs, and a 1099-K per platform, pulling the figures out by hand is where the mistakes happen. AI data extraction for Airbnb and VRBO earnings summaries turns the Annual Earnings Summary PDF, the companion CSV, and the 1099-K into structured rows — you describe what you need (gross, service fees, refunds, occupancy-tax information line, per-listing splits) in a natural-language prompt and download an XLSX or CSV that drops into the return-prep ledger. The same extraction handles the VRBO Payout Summary and the folder of host-side receipts in one batch.

Extract the VRBO Payout Summary and reconcile to 1099-K Box 1a

VRBO's Payout Summary is structured differently from Airbnb's. Where Airbnb presents a per-listing revenue statement with explicit columns for every adjustment, VRBO presents a listing-keyed view built around bookings and the payouts that followed them. Service-fee handling sits inside the booking-level figures rather than as a consolidated column, refunds and cancellations appear as adjustments against specific bookings, and damage deposits are tracked as a separate activity stream. The document is downloaded from the Financial Reporting or Reservations area of the host dashboard.

Two things to confirm before reading the columns. First, which VRBO payment model the host is on: the older subscription model charges an annual fee and does not deduct a per-booking service fee, so the payout summary shows the booking total flowing through more or less unchanged. The pay-per-booking model deducts a VRBO service fee from each booking, and that deduction is visible on the summary. The column meanings shift between the two models. Second, whether VRBO processed the payment for each booking: hosts who collected some bookings directly (card-on-file through a property-management system, or offline) will see those bookings flagged separately because they do not flow through VRBO's 1099-K.

The VRBO columns and what they mean

• Gross booking amount. The full amount the guest paid for the reservation, before any deductions. Equivalent to Airbnb's gross earnings on a per-booking basis.
• VRBO service fee. On the pay-per-booking model, the platform fee deducted from the host's share. Not present on the subscription model.
• Guest service fee. Charged to the guest on top of the booking amount. Flows between guest and VRBO directly and does not touch the host's income or expense.
• Refunds and cancellations. Adjustments against specific bookings, tied to the original reservation. Reduce gross the same way Airbnb refunds do.
• Payment-processing fees. Appear as a separate deduction on some VRBO payment models. Treat consistently as a fee expense.
• Damage-deposit activity. Held separately. Deposits charged and retained (for damage) are income to the host when retained; deposits refunded are neither income nor expense.
• Net payout. The amount VRBO transferred to the host's bank account per booking, after service fees and refunds.

Which VRBO column maps to which return line

VRBO column	Schedule E line	Schedule C line
Gross booking amount	Line 3 — Rents received	Line 1 — Gross receipts or sales
VRBO service fee (host share, pay-per-booking)	Line 10 — Commissions, or Line 19 — Other	Line 10 — Commissions and fees
Guest service fee	Not reported — flows guest-to-VRBO	Not reported — flows guest-to-VRBO
Refunds and cancellations	Net against Line 3 revenue	Line 2 — Returns and allowances
Payment-processing fees	Line 19 — Other	Line 17 — Legal and professional, or Line 27a — Other
Damage deposit retained for damage	Line 3 — Rents received	Line 6 — Other income
Damage deposit refunded	Not reported	Not reported

Reconcile the Payout Summary to 1099-K Box 1a

VRBO's 1099-K reports the gross payment amounts that flowed through VRBO's payment processor — typically the full gross booking amount per reservation, before service fees and refunds, for bookings where VRBO processed payment. The Payout Summary shows the net payouts that actually reached the host's bank account.

The bridge in arithmetic form: gross bookings (VRBO-processed), plus any refunded amounts still counted as gross processed payments, minus VRBO service fees, minus refunds and cancellations, minus payment-processing fees, equals net payout. Build the bridge per listing and then sum. Mismatches usually come from three places: bookings that straddled year-end so the reservation landed in one year and the payout in the next, refunds processed after the 1099-K cutoff, and damage-deposit retentions that were treated as payments for 1099-K purposes but categorized separately in the Payout Summary.

Bookings the host processed outside VRBO (card-on-file, offline, or through a property-management system) do not appear on the VRBO 1099-K at all but still generate reportable income. Those bookings need their own reconciliation track and join the return-line math as revenue just like the VRBO-processed bookings, sourced from the host's own payment-processor statements rather than a platform summary. For hosts whose portfolios include property-manager-sourced bookings alongside VRBO and direct channels, the commission, folio, and payout reconciliation is its own workflow — the approach for reconciling OTA commission statements against folios and payouts transfers to the manager-plus-VRBO mix with minor adjustment.

Host-side expenses the platforms don't track

The platform statements cover revenue, platform fees, occupancy tax, and refunds — the amounts Airbnb and VRBO touch. Everything the host spends to run the property sits outside that perimeter and has to come from the host's own records: bank and credit-card statements, vendor invoices, the Form 1098 mortgage-interest statement, the property-tax bill, insurance declarations, and the depreciation schedule carried forward from prior years. Each category maps to a specific line on Schedule E or the Schedule C equivalent.

Host-side categories and return-line mapping

• Cleaning paid outside the platform. The cleaner the host pays directly, as distinct from Airbnb's passed-through cleaning fee. Schedule E Line 7 (Cleaning and maintenance) or Schedule C Line 11 (Contract labor). Cleaners paid $600 or more in the year who are not incorporated trigger a 1099-NEC filing on the host side.
• Supplies. Consumables for the rental: toiletries, paper goods, linens replaced during the year, small kitchen and bath items under the de minimis safe harbor threshold. Schedule E Line 15 (Supplies) or Schedule C Line 22 (Supplies).
• Utilities. Electricity, gas, water, sewer, trash, internet, and cable for the rental property. Schedule E Line 17 (Utilities) or Schedule C Line 25 (Utilities).
• Repairs and maintenance. Plumbing service, HVAC service, minor fixes, paint touch-ups, appliance repair. Schedule E Line 14 (Repairs) or Schedule C Line 21 (Repairs and maintenance). Capital improvements — a new roof, full kitchen remodel, HVAC replacement — are not repairs; they go on the depreciation schedule.
• Property management fees. Payments to a local property manager or co-host service. Schedule E Line 11 (Management fees) or Schedule C Line 10 (Commissions and fees).
• Mortgage interest. From the property's Form 1098. Schedule E Line 12 (Mortgage interest paid to banks). A Schedule C filer with a Schedule C property uses Line 16b (Other interest).
• Property tax. From the county or municipal bill. Schedule E Line 16 (Taxes) or Schedule C Line 23 (Taxes and licenses). Self-collected transient or occupancy tax the host remitted to a state or city sits on the same line.
• Insurance. Landlord policy, short-term rental rider, or commercial policy premium. Schedule E Line 9 (Insurance) or Schedule C Line 15 (Insurance).
• Depreciation. The building, furniture, fixtures, and capital improvements carried on the depreciation schedule. Schedule E Line 18 (Depreciation) or Schedule C Line 13 (Depreciation). The depreciation schedule itself is a separate working paper — IRS Publication 527 covers residential rental depreciation mechanics including the 27.5-year life for the building and the treatment of furniture and appliances, and going deeper on depreciation sits outside this article.
• Travel to the property for host work. Supervising repairs, dealing with inspections, handling a turnover the host performs personally. Schedule E Line 6 (Auto and travel) or Schedule C Line 24a (Travel). Mileage logs — date, odometer reading, purpose — are the documentation, not a year-end estimate.
• Miscellaneous. Subscriptions to property-management software, lockbox and smart-lock subscriptions, listing photography, professional staging, bookkeeping and accounting fees, legal fees for lease review. Schedule E Line 19 (Other) or Schedule C Line 27a (Other expenses), itemized with a brief label rather than grouped as "miscellaneous".

Recordkeeping for the expense side

Every expense entry needs backing documentation: the receipt, the invoice, the bank-statement line item, the canceled check. A spreadsheet row without a receipt behind it is a position the host cannot defend under examination. Tools that capture host-side receipts for Schedule C expense tracking turn the folder of paper and photographed receipts into a structured ledger that ties to the bank feed, and the documentation baseline — including IRS receipt retention and the $75 documentation rule — is worth settling before filing season rather than during an audit letter. Retain source documents for at least three years from the filing date, longer where a substantial understatement or unreported income question could extend the statute.

Two practitioner pitfalls worth flagging

Double-counting the passed-through cleaning fee. Airbnb's cleaning-fee passthrough is revenue (the guest paid the host through Airbnb) and the host's separate payment to the cleaner is an expense. One number goes on the revenue line, a different number goes on the cleaning-expense line, and they do not offset. The error pattern is to either book both sides of the same dollar (inflating revenue and expense equally) or to book neither (understating both). The correct treatment books each side once, from its own source document.

Claiming full expenses when personal use crossed a Publication 527 threshold. If the host also used the property personally during the year, and the personal use exceeded either 14 days or 10 percent of the rental days, Publication 527's personal-use rules limit the deductible share of the expenses. The calculation is a Publication 527 Chapter 5 exercise, not a Schedule E line-level adjustment, and skipping it invites a correction. Hosts who rented for fewer than 15 days total in the year fall under the 14-day rental safe harbor and exclude the rental income entirely, with no corresponding expense deduction — the opposite pattern, but the same personal-use line of questioning.

Edge cases: co-host payouts, resolution-center adjustments, and mixed-use days

A clean platform-to-return reconciliation usually hits a handful of situations that fall outside the column-to-line mapping. Each has a defensible treatment and a specific documentation trail.

Co-host payouts. Airbnb lets a co-host receive a share of the payout directly from the platform. When that is set up, the co-host's share is income to the co-host and does not pass through the primary host's 1099-K or Annual Earnings Summary once Airbnb splits the funds — Airbnb issues separate tax documents to each recipient. Where the primary host receives the full payout and pays the co-host separately, the full amount is the primary host's gross income, and the payment to the co-host is a deduction — Schedule E Line 11 Management fees or Schedule C Line 10 Commissions and fees. The $600 1099-NEC threshold applies to the co-host payment in the same way it applies to any service-provider payment, so a host paying a co-host $600 or more outside the platform needs a W-9 from the co-host and files a 1099-NEC. Airbnb's Annual Earnings Summary labels co-host payouts explicitly in the years and listings where they applied — verify the label before assuming how a specific payout flowed.

Resolution-center adjustments. Three buckets, each with its own treatment:

• Damage claims paid by a guest through the resolution center are generally a recovery against the repair expense. If the damage occurred and the recovery arrived in the same year, book the recovery against the repair line. If damage and recovery straddle years, treat the arrangement consistently by policy — either as income in the recovery year or as a prior-period expense adjustment, not both.
• Cancellation reimbursements Airbnb paid to the host under a platform-initiated cancellation (host-protection coverage, goodwill, or similar) are income to the host.
• Refunds the host issued to guests are refund-of-revenue — a reduction of gross, not an expense line.

Mixing the three buckets is the most common error and produces a return that does not tie to the Annual Earnings Summary. The resolution-center activity in the summary's Adjustments column, read line by line against the underlying case notes in the host dashboard, tells the correct story.

Mixed-use days and the 14-day rule. Publication 527 Chapter 5 governs the treatment when the host also used the property personally. Two distinct tests:

• The 14-day / 10-percent personal-use test. When personal use exceeds 14 days or 10 percent of the days the property was rented at fair rental value (whichever is greater), the property is treated as a dwelling unit used as a residence, and deductible expenses are limited to rental income — no net loss.
• The 14-day rental safe harbor. When the property is rented for fewer than 15 days in the year and the dwelling also qualifies as a residence under the personal-use test, rental income is excluded from gross income entirely and no rental expenses are deductible.

The two tests run in parallel, not sequence. Run both against the host's actual day count for the year and apply whichever result governs. Publication 527 carries the allocation arithmetic — day-by-day, not a simplified percentage — and the workbook step is keeping an accurate day count in the first place, which means reservation dates plus personal-use dates on the same calendar.

Multi-platform and managed portfolios. A host with some units on Airbnb, some on VRBO, some on a direct-booking channel, and one or two units handled by a local property manager has three to five statement sources that have to consolidate before any return line is populated. Each statement source has its own column structure, its own fee conventions, and its own reconciliation against a 1099-K or to a bank deposit. The owner statements from AppFolio, Buildium, or Yardi — common in the mixed long-term / short-term portfolio — report rent collected, management fees retained, maintenance charges, and owner draws on their own schedule; you consolidate property-manager owner statements across a portfolio into the same return-prep ledger that holds the Airbnb and VRBO figures, then tie the whole thing to the bank feed before allocating to return lines.

Mid-year classification change. Converting a Schedule E property to Schedule C by adding substantial services mid-year, or converting a long-term rental to a short-term rental (or the reverse), has to be documented coherently across the year. The activity classification is made at the activity level for the year, not month by month — so the host's working papers need a services log, a booking-duration log, and a written note on when and why the policy changed. A use-change between long-term and short-term also has depreciation-schedule implications: where the actual use of the property genuinely changed, the basis and useful-life treatment may need to be reset, and the updated schedule stays with the return file.

1099-NEC obligation for service providers. Cleaners, handymen, contractors, and co-hosts paid $600 or more in the calendar year who are not incorporated trigger a 1099-NEC filing on the host's side. Collect the W-9 when the vendor is engaged, not in January — chasing down a W-9 from a cleaner who moved on is a standard source of pre-deadline friction. Keep the 1099-NEC copies tied to the Schedule E or Schedule C expense lines they correspond to, so the expense deduction and the information-return filing line up in the working papers.