Home / Guides / Airbnb income spreadsheet template
Airbnb income spreadsheet template
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.
An Airbnb income spreadsheet has one job: show gross rent, fees and deposits side by side, so your total for Schedule E line 3 is a number you can explain. Here is what to put in it, whether you build your own or use a template.
The columns that matter
| Column | What it holds |
|---|---|
| Payout date or month | Match the earnings report period. |
| Source | Airbnb, Vrbo, direct booking. |
| Gross rent | What guests paid for the stay, before fees. Schedule E line 3. |
| Platform fee | Host service fee withheld. An expense, not a reduction of rent. |
| Expected net | Gross minus fee. Formula. |
| Bank deposit | What actually arrived. |
| Difference | Deposit minus expected net. Should be zero or explainable. |
Example bridge (made-up numbers)
| Bank deposits | $37,539 |
| Plus platform fees | $1,161 |
| Gross rent (line 3) | $38,700 |
If your three numbers do not agree, look for refunds to guests, resolution adjustments, taxes the platform collected for you, or a payout that landed in a different month.
Where to get the numbers
- Airbnb: the earnings and transaction history reports in your host account.
- Vrbo: the payments and statements reports in your owner account.
- Direct bookings: your payment processor or bank record.
Build it or buy it?
Building it yourself is fine if you are comfortable with formulas. HostLedger is a ready-made version: income and expense sheets, a Schedule E Summary, and a Checks box. See the filled-in sample. For the tax side of each column, read 1099-K vs Schedule E.
Frequently asked questions
What should an Airbnb income spreadsheet include?
At least the payout date, source, gross rent, platform fee, bank deposit and the difference. Add the property name if you host more than one.
Should I record income by payout date or by stay date?
Use the method you and your CPA use for your return and stick with it. Many individual hosts use the cash method (income when received). Ask your CPA which applies.
Is there a free Airbnb income template?
There are free templates online. HostLedger is a paid template that adds the Schedule E line mapping, checks and a depreciation and personal use sheet in the Multi-Property plan.
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