How to Track Airbnb Income and Expenses in a Spreadsheet

Airbnb dashboards show gross payouts — not cleaning turnover, supply restocks, or the water bill spike from weekly guests. A free Airbnb income and expense tracker spreadsheet calculates net profit per property with categories you can hand to a tax preparer.

Monthly row per property

1. Gross booking income — payouts + any direct bookings
2. Cleaning — per turnover or monthly contract
3. Supplies — toiletries, coffee, linens replacement
4. Platform fees — host-only slice if not netted in payouts
5. Utilities and insurance — allocated to the STR
6. Net profit — income minus all lines

Multi-property hosts filter by property — one weak unit hidden in portfolio gross becomes visible.

Log when money moves, not at tax time

Enter cleaning charges when the invoice hits, not in March. Category discipline beats a shoebox of receipts.

STR vs. long-term rental

Hosts with both should use this tracker for short-term stays and the long-term rental tracker for annual leases — different expense patterns and tax questions.

When STR PMS accounting wins

Integrated booking calendars, automated expense import, and multi-owner statements justify tools at portfolio scale. One–three listing hosts often know their real margin first in a sheet.

These templates are operational finance logs, not tax advice. STR tax rules vary by jurisdiction and use — consult a qualified tax professional.