STR Airbnb Mileage Log Spreadsheet – IRS Compliant Tax Tracker (Excel/Google Sheets)

Close your year before April does. IRS-compliant mileage log for Airbnb and STR hosts. Auto-calculates deduction at 2026 IRS rate ($0.70/mi). Editable Excel.

The IRS requires four things per business-mile entry: date, destination, business purpose, and miles. Most STR hosts have none of it at tax time. Active hosts miss $2,000–$8,000 per year in mileage deductions — not because they didn't drive, but because they didn't document.

This log captures all four fields plus odometer readings, property allocation, and auto-calculated dollar deduction at the current IRS standard mileage rate. Hand the monthly summary and YTD dashboard to your CPA. Done.

═══════════════════════════════════════════
WHAT'S INCLUDED
═══════════════════════════════════════════

Excel workbook (5 tabs):

- Mileage Log — one row per trip. Date, property, destination, business purpose, start/end odometer OR typed miles, notes. 2,000-row capacity.
- Monthly Summary — miles + dollar deduction per month, auto-calculated from the log
- YTD Dashboard — totals + breakdown by business purpose (7 categories: property inspection, turnover, supplies run, guest transport, repairs, meeting cleaner, other)
- Welcome tab — IRS compliance note + how-to guide
- Settings tab — editable IRS rate (update every January 1), property list, purpose list (source for all dropdowns)

Compliance check column (col K): green ✓ when a row meets IRS Pub 463 requirements, red ⚠ when something required is missing.

Formula auto-detects odometer method (start + end odo) OR stated-miles method (typed). Use whichever you prefer.

═══════════════════════════════════════════
WHY THIS PAYS FOR ITSELF IN ONE TRIP
═══════════════════════════════════════════

25 miles round-trip × $0.70/mi = $17.50 deduction.

This template pays for itself on one trip. Active STR hosts who document consistently recover $2,000–$8,000 per year. At a 25% tax bracket, every 100 documented miles is $17.50 back in your pocket.

The IRS does not accept "I think I drove a lot." They want a log. This is the log.

═══════════════════════════════════════════
WHO IT'S FOR
═══════════════════════════════════════════

- STR hosts who drive to their properties for inspections, turnovers, supply runs, repairs, or guest transport
- Multi-property hosts who want per-property mileage allocation
- Hosts filing Schedule C or Schedule E who want an audit-defensible record
- Anyone who told their CPA "I didn't keep a mileage log" and doesn't want to say that again

═══════════════════════════════════════════
HOW IT WORKS
═══════════════════════════════════════════

1. Purchase → instant download
2. Open Settings tab — confirm IRS rate (2026: $0.70/mi), enter your property names
3. Open Mileage Log — fill one row per trip (5 seconds)
4. Column K flags any incomplete rows in red
5. At tax time: print Monthly Summary + YTD Dashboard to PDF, send to CPA

═══════════════════════════════════════════
FILE COMPATIBILITY
═══════════════════════════════════════════

Microsoft Excel 2016+ (Windows and Mac)
Microsoft Excel 365
Google Sheets (imports cleanly)

═══════════════════════════════════════════
REFUNDS + SUPPORT
═══════════════════════════════════════════

14-day refund, no questions asked. If the file doesn't work on your setup or doesn't solve the problem you bought it for, email hello [!at] thestrledger.com — real humans, fast replies.

Not tax advice. Consult your CPA for your specific situation.

═══════════════════════════════════════════
ABOUT THE STR LEDGER
═══════════════════════════════════════════

The STR Ledger builds business-grade Excel systems for hosts who treat their STR portfolio like a real business. Full tax + operations template library at thestrledger.com.

Tax Season Bundle: mileage log + home office deduction + 1099-NEC tracker + Schedule E prep workbook, $147. Details at thestrledger.com/tax-bundle.

This is a digital product. No physical item will be shipped.