Track meals deductibly. Don’t lose another receipt. Per-diem meal deduction tracker for Airbnb and STR hosts. 50% deductible business meals + per-diem option. Editable Excel. You drove out to your cabin in Pigeon Forge for the quarterly inspection. Lunch was $24 at the diner with the cleaner. Dinner was $42 at the BBQ place where you discussed pricing strategy with your co-host. Both deductible at 50%. Receipt for the diner is in your jacket pocket. Receipt for the BBQ is in your truck. Both will be a damp ball of paper by April. Or you can log them as you go. This template is the log. WHAT’S INCLUDED 📋 Meal Log (1,000-row capacity) · Date, location, business purpose, attendees · Total amount + tip + tax · Auto-50% deduction calculation per row · Photo-of-receipt link column (Drive / Dropbox / iCloud URLs) 📋 Per-Diem Method (alternative) · GSA per-diem rates by location · CONUS standard rate dropdown · Stack against actual-method totals to see which wins per trip 📋 Travel-Day Detection · Multi-day trip handler · Day-of-departure / day-of-return 75% rule · “On the road” days at 100% per-diem 📋 Monthly + YTD Roll-up · Total deductible $ by month · Per-trip subtotal · Schedule E Line 7 / Schedule C Line 24 ready 📋 Audit-Defense Block · Pub 463 substantiation: who, where, why, how much · Receipt link presence checker · Personal-meal flag for spouse-only meals (not deductible)
Related
- Home Office Deduction Allocator
- The Mileage Log
- Depreciation Tracker (Full MACRS)
- Cost Segregation DIY Workbook
- The 1099-NEC Tracker
Get the workbook
Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.