From the Wyo Stays team. A ready-to-use spreadsheet template. Educational, not tax/accounting advice.
Clean books are the difference between a stressful April and a five-minute hand-off — and between guessing at your profit and actually knowing it. This tracker keeps it simple.
What the tracker captures
Income (monthly): - Gross booking revenue (split direct vs OTA) - Cleaning fees collected, other income
Expenses (categorized to match Schedule E): - Cleaning & turnover, supplies, restocking - Management & channel fees, software - Utilities, internet, subscriptions - Repairs & maintenance, lawn/snow - Insurance, property tax, HOA - Furnishings/capital (tracked separately for depreciation) - Professional fees, mileage, misc.
Automatic outputs: - Monthly and annual net profit (P&L) - Expense breakdown by category - Direct vs OTA revenue mix - A year-end summary ready for your CPA
How to use it
- Separate account/card for the rental — never commingle. This one habit makes bookkeeping trivial.
- Enter monthly (15 minutes) — don't let it pile up.
- Save receipts in a dated folder as you go.
- Review the P&L each quarter — it tells you if pricing and costs are healthy.
- Export the year-end summary to your CPA (see the Year-End Tax Packet).
Why it pays
Owners who track cleanly capture more deductions, spot problems early, and make better pricing decisions. Owners who don't overpay their CPA and leave money on the table.
→ Unlock the ready-to-use spreadsheet, or → get a free evaluation — managed owners get clean books and statements automatically.