Home / Guides / Airbnb expense tracker spreadsheet for US hosts
Airbnb expense tracker spreadsheet for US hosts
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.
If your Airbnb costs live in bank notes, email receipts and a half-finished sheet, tax season turns into a weekend of digging. An expense tracker spreadsheet fixes that by giving every cost one home, one category and one date, as it happens.
What a good Airbnb expense tracker records
- Date and amount of each cost.
- Who you paid, so you can find the receipt later.
- A category that matches how rental costs are reported on Schedule E (Form 1040), Part I.
- The property, if you host more than one place.
- A receipt note: a file name or link in your one folder per year.
Categories hosts usually track
These are the common categories for short-term rental hosts. Always confirm against the official Schedule E instructions.
| Category | Typical examples |
|---|---|
| Advertising | Paid listing promotions, photos for the listing |
| Auto and travel | Trips to the property for rental purposes (keep a log) |
| Cleaning and maintenance | Turnover cleaners, lawn care, pool service |
| Commissions | Platform host fees are often placed here |
| Insurance | Landlord or short-term rental policies |
| Legal and other professional fees | Accountant, rental permits advice |
| Management fees | Co-host or property manager fees |
| Repairs | Fixing a faucet, patching a wall |
| Supplies | Soap, towels, coffee, small items |
| Taxes | Property taxes |
| Utilities | Power, water, internet |
| Other | Software, linen service, other ordinary costs |
For how each category connects to Schedule E, see the Airbnb and Schedule E guide or the deductions checklist.
Repair or improvement? Log it, then ask
Fixing something back to how it was is usually a repair. Adding value or extending the life of the property, like a new roof, is generally an improvement that is depreciated over time. Where the line falls is a judgment call, so record big items with a clear note and bring them to your CPA.
See the HostLedger tracker
HostLedger is an Excel template that you can import into Google Sheets. You enter expenses once, it sorts them into Schedule E categories, and it checks that your payouts reconcile. The sample sheet shows how the pages look with example numbers. Hosting on Vrbo too? Read the Vrbo rental income spreadsheet page.
Frequently asked questions
What should an Airbnb expense tracker spreadsheet include?
At minimum: the date, who you paid, the amount, a category and a place to note the receipt. Add the property name if you host more than one place.
Does the HostLedger tracker work in Google Sheets and Excel?
It is an Excel (.xlsx) file. In Google Sheets, use File, Import, Upload. It uses ordinary formulas and dropdowns.
Can I deduct everything I log?
Not necessarily. Whether a cost is deductible, and in which year, depends on your situation, for example personal use days or repair versus improvement. Check with a CPA.
Do I need to track the Airbnb host fee as an expense?
Airbnb pays you net of its host service fee, so your deposit is lower than gross rent. Tax reporting generally starts from the gross amount, with the fee shown as an expense. HostLedger keeps the fee as its own column so the numbers bridge.
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