Home / Guides / Vrbo rental income tax spreadsheet: match payouts to gross rent
Vrbo rental income tax spreadsheet: match payouts to gross rent
Updated October 28, 2026. Line numbers follow the 2025 Schedule E (Form 1040).
General information, not tax advice. Rules change and every situation is different. Please check with a CPA and with the official IRS pages linked here before you file.
Your Vrbo deposits rarely equal the income you report. Fees come out first, guests get refunds, and the year-end tax form can show yet another number. A rental income spreadsheet puts all of it in one place so the totals agree before you file.
Why your Vrbo payout does not match your tax paperwork
- Platforms pay you net. Your deposit is after the host service fee. Tax reporting generally starts from the gross amount, with the fee shown as an expense.
- Adjustments and refunds to guests can change what you were paid.
- Taxes collected for you. In some places occupancy taxes are collected and remitted. Those are not the same as your rent.
- Form 1099-K may show a total that includes fees, so it can be higher than your bank deposits.
The fix is a simple bridge: bank deposits, plus fees, plus any refunds, equals gross rent. The HostLedger sample sheet shows exactly that with example numbers.
One income sheet for Vrbo, Airbnb and direct bookings
Income in HostLedger has a source on every row (Airbnb, Vrbo, direct booking), so you can add Vrbo, Airbnb and direct bookings together and see one gross rent total. If you also track costs, read the Airbnb expense tracker spreadsheet page, which covers the expense side.
Which form does a Vrbo host use?
Most hosts who just rent out a place, and do not provide hotel-like services, report rental income and expenses on Schedule E (Form 1040), Part I. If you provide substantial services to guests, such as daily housekeeping or meals, the activity may be reported on Schedule C instead. The IRS explains this in Publication 527, Residential Rental Property. A CPA can tell you which one fits you. More detail is in the Schedule E guide.
Personal use days
If you also stay at the property yourself, or let family stay for free or cheap, your personal use days can limit which expenses you can deduct. The IRS describes the rules, including the 14-day or 10% test, in Publication 527. Keep a simple calendar of rented days, personal days and days it was available.
See also Vrbo and Airbnb 1099-K vs Schedule E.
Official sources
- IRS: Instructions for Schedule E
- IRS: Publication 527, Residential Rental Property
- IRS: Topic 414, Rental income and expenses
Frequently asked questions
How do I track Vrbo rental income for taxes?
Record each booking or payout, then bridge it to gross rent: bank deposits, plus platform fees, plus any refunds, equals gross rent.
Can I put Vrbo, Airbnb and direct bookings in one sheet?
Yes. Every income row in HostLedger has a source, so all platforms add into one gross rent total.
Which tax form do Vrbo hosts use?
Most hosts who simply rent out a place report on Schedule E (Form 1040), Part I. If you provide substantial services to guests, Schedule C can apply. A CPA can tell you which one fits.
Want this done for you in a spreadsheet? HostLedger totals your Airbnb and Vrbo income and expenses into Schedule E lines. From $19, one time.
See plans See a filled-in sample