Landlord Tenant Toolkit

Rent ledger with automatic late fees, move-out inspection to security deposit itemization, tenant screening, turnover cost and a maintenance log.

Run the day-to-day of your rentals from one workbook: rent and late fees, move-out inspections, security deposits, tenant screening, turnover cost and repairs.

Rent Ledger with automatic late fees. Set your grace period, flat fee, % of rent, daily fee and a cap once. Every charge then shows days late, late fee, balance and status (Paid / Due / Late / Upcoming).

Move-in / move-out inspection → security deposit itemization. Walk each room, enter repair costs and mark normal wear (never charged). The Deposit tab pulls the damage total, adds unpaid rent, cleaning and other deductions, interest if your state requires it, and shows the refund (or what the tenant still owes) plus your return deadline and the days left.

Tenant screening scorecard. The same written criteria for every applicant: income-to-rent multiple, credit score, time at job, prior evictions, reference and ID check. Includes fair-housing guidance.

Turnover vs renewal. Vacancy days, make-ready, marketing, leasing fee and your time compared with a renewal over 12 months, plus the renewal increase that breaks even. Often the answer is "keep the tenant".

Maintenance log with response targets by priority and an OVERDUE flag. Dashboard: rent due vs collected this month, outstanding balance, late fees, open/overdue repairs, deposit status.

Includes a blank workbook, a filled-in SAMPLE (4 units) and a PDF guide that walks through every number.

Works in Excel 2010+, Google Sheets and LibreOffice. No macros.

Tested: every calculated cell was recalculated in LibreOffice and matched an independent Python model on the sample and three randomized workbooks.

You enter your own state's late-fee limits, deposit deadline and rules; the workbook doesn't know your jurisdiction. Not legal, tax or financial advice.

Built with AI assistance and tested by running it end to end (details in the guide).

Refunds: 30-day refund if it doesn't work as described (refund policy).

Learn the method (free)

• Rent Late Fee Calculator Spreadsheet: Grace Period, Flat + Daily Fees and a Cap (Excel & Google Sheets)

  Build a rent ledger that works out days late, the late fee (flat, percent of rent, daily, with a maximum) and the balance for every charge, and flags LATE automatically. Exact formulas, tested by recalculating a sample workbook, plus how to set the grace period to match state rules like Colorado, New York and Texas.

Related free tools

• Bank CSV Categorizer for Schedule E and Schedule C

  Turn a bank or card CSV into categorized rows for landlord (Schedule E) or freelancer (Schedule C) spreadsheets. Runs in your browser; nothing is uploaded.

• Free Rental Property Calculator: Cash Flow, Cap Rate, Cash-on-Cash, DSCR

  Instant rental deal math in your browser: monthly cash flow, NOI, cap rate, cash-on-cash return, DSCR, GRM, 1% rule and break-even occupancy.

Checkout, delivery, receipts and sales tax are handled by Gumroad. Questions after purchase: reply to your Gumroad receipt email. Not tax, legal or financial advice.