Airbnb Income & Expense Tracker in Google Sheets: The Complete Host Guide (2026)

You listed your property, guests are booking, and money is coming in — but do you actually know if you're profitable? Most Airbnb hosts are guessing. This guide shows you how to build a free income and expense tracker in Google Sheets that tells you your true profit, occupancy rate, average daily rate, and tax-ready numbers every single month.

Why Your Airbnb Dashboard Isn't Enough

Airbnb's built-in dashboard shows you payouts and upcoming reservations. That's it. It does not show you:

• Your actual profit after cleaning fees, supplies, maintenance, and mortgage interest
• Whether your occupancy rate is improving month-over-month
• How much of your revenue comes from service fees you can't deduct
• Your true Average Daily Rate (ADR) vs. what Airbnb shows
• What you owe in taxes after deductions
• How your property compares month-over-month or year-over-year

VRBO, Hipcamp, and direct bookings add even more complexity — every platform reports differently. A Google Sheets tracker consolidates everything into one source of truth.

The 5-Tab Tracker Structure

Here's the sheet structure that covers everything an Airbnb host needs, from booking-level detail to IRS-ready tax numbers:

Tab 1: Booking & Income Log

Each reservation gets one row. The booking log is your revenue source of truth. Capture more than just the payout — you need gross fare and fees separately for accurate tax reporting.

Columns to Include

Calculating Monthly Gross Revenue

Once your booking log is set up, pull monthly totals with a SUMIFS formula:

Tab 2: Expense Log (All Deductible Categories)

This is where most hosts leave money on the table. Airbnb hosting has more deductible expenses than most hosts realize. Every dollar you miss is money you overpay in taxes.

Complete STR Expense Categories

The expense log columns should be: Date | Vendor | Category | Amount | Notes | Month. Keep receipts in a linked Google Drive folder — one folder per month.

Tab 3: Performance Metrics

This tab transforms raw booking data into the numbers that actually tell you if your business is healthy. Here are the three metrics every serious STR host should track:

Occupancy Rate

Occupancy rate = Nights booked ÷ Nights available. For a full month of 30 days:

Average Daily Rate (ADR)

ADR = Total gross revenue ÷ Nights booked. This is what you actually earn per night after platform calculations.

RevPAR (Revenue Per Available Room)

RevPAR = ADR × Occupancy Rate. This is the hotel industry's gold standard metric and works perfectly for STR analysis. A $150 ADR at 50% occupancy (RevPAR = $75) is less profitable than a $100 ADR at 80% (RevPAR = $80).

Tab 4: Monthly P&L Dashboard

The dashboard is where you read the business. Build it as a monthly summary table with a row per month and these columns:

Add a simple column chart (Insert → Chart) on Gross Revenue vs. Net Operating Income by month. The gap between those two lines is your cost structure — and it's often shocking the first time you see it.

Tab 5: Schedule E Tax Prep

If your Airbnb rental is a passive activity (you average fewer than 7 days per stay AND less than 750 hours of active participation), you report it on Schedule E, Part I. Here's how your spreadsheet maps to Schedule E lines:

6 Essential Copy-Paste Formulas

1. Annual Gross Revenue

2. Total Expenses by Category (Year)

3. Year-to-Date Occupancy

4. Net Profit Margin

5. Cost Per Booked Night

6. Top Expense Category

Tracking Multiple Properties

If you have more than one STR property, the cleanest approach is to add a Property column to both the Booking Log and Expense Log, then use a third criteria in every SUMIFS formula.

For example, monthly revenue for Property A only:

Your Tax Prep tab should also separate by property — Schedule E allows up to three properties on one form, but each property's income and expenses are listed separately.

6 Costly Mistakes Airbnb Hosts Make With Their Books

1. Tracking Payouts Instead of Gross Revenue

The IRS expects you to report what the guest paid, not what you received. Airbnb's 1099-K reflects gross transactions. If your spreadsheet shows only payouts, your records won't match your 1099 and you could face penalties.

2. Forgetting the Cleaning Fee Is Income

If you keep the cleaning fee (even if you pay a cleaner), the fee is income. The cleaning cost is a separate expense. Both sides must appear in your tracker.

3. Missing Depreciation

Depreciation is the biggest legal deduction available to rental property owners — and most hosts either skip it or get it wrong. A $300,000 property (land excluded) generates ~$9,000/year in depreciation deductions on a 27.5-year schedule. Don't leave this on the table. Use Form 4562 and enter the result in your Tax Prep tab.

4. Not Prorating for Personal Use

The IRS is explicit: if you use the property personally, you must prorate shared expenses. Failing to do this is an audit risk. Track your personal-use days in the Booking Log tab (add a "personal use" booking type).

5. Treating Platform Fees as Revenue Reductions

Airbnb fees are deductible advertising expenses — they reduce your taxable income, but they're not a revenue reduction. This distinction matters for some state tax calculations and for accuracy in your books.

6. Catching Up at Tax Time Instead of Monthly

Reconciling a year's worth of Airbnb transactions in April is painful, error-prone, and expensive if you're paying a CPA by the hour. Spend 20 minutes at the end of each month updating your tracker. Your future self will thank you — and your CPA will too.

Next Steps: Build It or Buy It

You can build this tracker from scratch using the structure above, or save hours by starting with a done-for-you template. Either way, the critical thing is to start tracking before you have a tax problem — not after.

The five tabs, the formulas, and the monthly routine outlined here will give you full visibility into your STR business: what you're earning, where it's going, and exactly what to hand your accountant at tax time.

If you run other income streams alongside your rental — freelance work, a side business, consulting — check out our freelance income & expense tracker guide and the rental property expense tracking guide for the long-term rental version of this workflow.

And if you want a single-dashboard view of all your income streams, taxes, and monthly P&L, the net worth tracker pairs well with property tracking to give you the full financial picture.