Airbnb Host Income and Expense Tracker

A bookkeeping spreadsheet for short-term rental hosts. Log each stay and each expense, and the workbook shows occupancy, average nightly rate, payouts, expenses and net income by month, for one property or up to five.

What's included

• A Bookings log for 600 stays. Nights and net payout fill in, and platform fees are kept separate
• Occupancy taxes that Airbnb or Vrbo collect for you are kept out of your income
• An Expenses log for 600 costs with IRS Schedule E categories in a dropdown, a receipt check and a Shared option for costs that cover every property
• A Monthly tab with occupancy, average nightly rate, net income, a running total and a chart, for one property or all of them
• A Schedule E tab with year totals by line and property, plus fair rental days and personal use days
• A Settings tab for your tax year, properties, booking platforms and categories

Files

• Airbnb Host Income and Expense Tracker.xlsx, filled in with a fictional sample year for three rentals
• Airbnb Host Income and Expense Tracker (blank).xlsx, ready for your own numbers

You get them in one zip file, Airbnb Host Income and Expense Tracker.zip.

Good to know

Works in Excel 2016 or later and Microsoft 365 on Windows or Mac, and in Google Sheets. There are no macros or add-ins. To use it in Google Sheets, upload the .xlsx to Google Drive, open it with Google Sheets, then choose File > Save as Google Sheets. Setup steps are on the Instructions tab inside the file.

The Monthly and Schedule E tabs are protected without a password, so you can unlock them if you want to change something.

This is a digital download, so nothing is shipped. You can download the zip from your purchase receipt right after you buy. Sample names and figures are fictional.

License (single person or single business): for use by one person, or one business and its own staff. You may edit the files and make copies for your own use. You may not resell, share, give away or redistribute them, or use one purchase for more than one person or business.

Questions? Email Bengopoyan1@gmail.com. More templates: etsy.com/shop/KeelAndCharter, payhip.com/KeelandCharter and keelandcharter.gumroad.com

Disclaimer: This template is an organizational tool, not tax, legal or accounting advice. Tax rules change, so confirm figures with a qualified tax professional before filing.

Designed and reviewed by Keel & Charter. AI tools helped build the spreadsheets, draft the text and lay out the preview images. Preview images show the actual files with sample data.