About this product

Stop guessing whether your short-term rentals actually make money.

STR Ledger Pro is a complete bookkeeping system built for self-managing Airbnb/VRBO hosts. Log every payout and expense once in the transaction ledger, and the workbook does the rest: per-property profit & loss, a tax-season Schedule E category summary, occupancy and ADR metrics, and a deal analyzer for your next purchase.

WHAT'S INSIDE (5 files):

• STR-Ledger-Pro.xlsx — 9-sheet workbook, 100% native formulas, zero macros:
• START HERE — 10-minute setup walkthrough
• PROPERTIES — profiles for up to 10 rentals (names feed every dropdown)
• LEDGER — 400 transaction rows with Date, Property, Category, Income/Expense, Amount, Platform, Receipt tracking and Notes; dropdowns on every field
• MAPPING — 16 ledger categories mapped to IRS Schedule E lines (Line 3 rents through Line 21 other expenses)
• PER-PROPERTY P&L — auto-built from your ledger: gross revenue, all 13 expense lines, net income, net margin %, nights booked, occupancy %, ADR (average daily rate) — per property plus portfolio totals
• SCHEDULE E MAP — year-to-date totals rolled into the 14 Schedule E lines with net rental income, ready to hand to your CPA
• UNDERWRITE — deal analyzer with 14 outputs: cash invested, mortgage P&I (PMT), monthly/annual cash flow, cash-on-cash return, cap rate, DSCR, and a 1% rule check
• STAYS — 200-row reservation log feeding occupancy and ADR
• CLEANER CHECKLIST — 27-task turnover sheet inside the workbook
• Guest-Guide.pdf — 1-page FILLABLE guest sheet: property name, Wi-Fi network and password, check-in/out times, parking, trash day, emergency contact, thermostat notes, house rules, and a dashed QR placeholder box. Type your details, paste your own QR code image (generated free from any QR tool), print and laminate. The box is a placeholder — it links nowhere until you add your own QR.
• Cleaner-Turnover-Checklist.pdf — printable 27-task checklist for every turnover.
• Quick-Start-Guide.pdf — setup walkthrough.
• README-license.txt — license and disclaimers.

SAMPLE DATA: Three sample properties, 38 sample transactions and 15 sample stays are pre-loaded and clearly labeled SAMPLE so every formula shows live numbers. Replace them with your own data.

WORKS WITH: Excel, Google Sheets, and LibreOffice. No macros, no add-ins, no internet connection required.

HONEST DISCLOSURES:

• This kit is a bookkeeping and organizational aid — NOT tax, legal, or investment advice. The Schedule E mapping mirrors the IRS Schedule E line layout; verify every categorization with a qualified tax professional before filing. Depreciation is intentionally excluded — your CPA computes it.
• Platform service fees are mapped to Schedule E Line 11 (Management fees); confirm this treatment with your tax professional.
• The guest-guide QR box is an empty placeholder. No QR image is included and nothing links anywhere until you add your own.
• Underwriting outputs are planning estimates from your own inputs, not investment advice or return guarantees.
• One workbook per tax year is the recommended workflow.

What's included

• STR-Ledger-Pro.xlsx — 9-sheet workbook, 100% native formulas, zero macros:
• START HERE — 10-minute setup walkthrough
• PROPERTIES — profiles for up to 10 rentals (names feed every dropdown)
• LEDGER — 400 transaction rows with Date, Property, Category, Income/Expense, Amount, Platform, Receipt tracking and Notes; dropdowns on every field
• MAPPING — 16 ledger categories mapped to IRS Schedule E lines (Line 3 rents through Line 21 other expenses)
• PER-PROPERTY P&L — auto-built from your ledger: gross revenue, all 13 expense lines, net income, net margin %, nights booked, occupancy %, ADR (average daily rate) — per property plus portfolio totals
• SCHEDULE E MAP — year-to-date totals rolled into the 14 Schedule E lines with net rental income, ready to hand to your CPA
• UNDERWRITE — deal analyzer with 14 outputs: cash invested, mortgage P&I (PMT), monthly/annual cash flow, cash-on-cash return, cap rate, DSCR, and a 1% rule check
• STAYS — 200-row reservation log feeding occupancy and ADR
• CLEANER CHECKLIST — 27-task turnover sheet inside the workbook
• Guest-Guide.pdf — 1-page FILLABLE guest sheet: property name, Wi-Fi network and password, check-in/out times, parking, trash day, emergency contact, thermostat notes, house rules, and a dashed QR placeholder box. Type your details, paste your own QR code image, print and laminate.
• Cleaner-Turnover-Checklist.pdf — printable 27-task checklist for every turnover.
• Quick-Start-Guide.pdf — setup walkthrough.
• README-license.txt — license and disclaimers. Sample data: three sample properties, 38 sample transactions and 15 sample stays are pre-loaded and clearly labeled SAMPLE so every formula shows live numbers. Replace them with your own data.

Key features

• One ledger feeds everything → per-property P&L, Schedule E totals, occupancy and ADR all compute from the same 400-row transaction log
• Schedule E mapping built in → 16 ledger categories mapped to IRS lines; year-to-date totals roll into the 14 Schedule E lines with net rental income, ready for your CPA
• Real performance metrics per property → net margin %, nights booked, occupancy % and ADR per property plus portfolio totals
• Deal underwriting with 14 outputs → cash-on-cash, cap rate, DSCR and a 1% rule check for the next purchase, from your own inputs
• Fillable guest guide + turnover checklist → the guest-facing and cleaner-facing pieces are in the same kit
• 100% native formulas, zero macros → works in Excel, Google Sheets, and LibreOffice with no internet required