Per Diem Meal Deduction Tracker – STR Business Log Excel Template

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)

═══════════════════════════════════════════
WHY STR HOSTS NEED THIS
═══════════════════════════════════════════

Most hosts skip business meals entirely or take a guess in March. The IRS
disallows undocumented meal deductions on audit — Pub 463 wants who, where,
why, how much, with receipts for anything over $75.

Realistic case: 30 business meals a year × $35 average × 50% = $525 deduction.
At a 24% bracket, $126 in tax saved. Workbook is $17. Year-one ROI: 7×.

The bigger value is the audit-defense paper trail. If the IRS asks, you have
a structured log with attendees, business purpose, and receipt links.

═══════════════════════════════════════════
WHO THIS IS FOR
═══════════════════════════════════════════

· Airbnb / VRBO hosts who travel between properties
· Multi-property operators meeting cleaners, contractors, and co-hosts
· Hosts who entertain owners, agents, or prospective deal partners
· Anyone whose CPA flagged "no meal substantiation" last year

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

1. Open in Excel or Google Sheets. Pre-loaded with sample meals.
2. After every business meal, log a row (30 seconds): date, location, purpose, amount, attendees.
3. Take a phone photo of the receipt; paste the cloud link into column G.
4. Optionally compare per-diem vs actual on multi-day trips.
5. At year-end, print the YTD Summary tab. Plug into Schedule E Line 7 or Schedule C Line 24.

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

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

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

14-day refund, no questions asked. Email hello [!at] thestrledger.com — real humans,
fast replies.

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

Business-grade Excel systems for serious short-term rental hosts.
Full template library at thestrledger.com.

═══════════════════════════════════════════

⚠ Digital product. Not tax advice. Consult your CPA. IRS Pub 463 (Travel/Gift/Car Expenses)
is the canonical reference for business meals.