An actual spreadsheet that opens instantly - not a PDF with a link inside. Download the .xlsx, open it, and start logging rent. A one-page Start Here tab walks you through everything in plain English.

Built for small landlords with 1 to 20 properties or units.

What's inside

• Start Here - one page: what each tab does and how to clear the sample data.

• Properties - list up to 20 properties or units.

• Tenants / Leases - rent amount, due day, lease dates, and an Active Yes/No dropdown.

• Rent Log - due date, paid date and amount paid. Balance, days late and status are calculated for you: Paid on time, Paid late, Partial, Overdue, Due, Part payment and Extra payment, plus warnings (Enter due date, Add paid date, Check amount) when something needs fixing. Partial payments keep counting as late until fully paid. Paid in parts? Log one row per payment and the month's status updates automatically; each payment counts in the year it was received. You add one Rent Log row per tenant per month - rows are not created automatically.

• Expenses - log costs per property with a category dropdown (Repairs, Insurance, Property Tax, Mortgage Interest and more; rename them on the Lists tab).

• Reminders - automatically lists rent due in the next 7 days and anything overdue, based on today's date (15 per list, with a "Showing 15 of N" note if there are more).

• Annual Summary - pick a year to see rent received, expenses by category and net per property, plus totals, with built-in check rows that flag typos, duplicate IDs, amounts typed as text, a month with rent entered twice, or deleted formulas. Handy to have ready for your records at year end.

Details

• Files: .xlsx and .ods. Tested in Google Sheets (File > Import) and LibreOffice Calc. Made for Excel 2010 or newer; Excel itself has not been tested yet. No macros, no add-ins.

• Capacity: 20 properties, 50 tenants, 2,000 rent rows, 2,000 expense rows.

• Comes pre-filled with clearly marked SAMPLE DATA so you can see how it works; delete it in a minute. Sample dates follow today's date; preview images were captured on 2026-10-16.

• Currency-neutral (works for $, £, etc.).

• Instant digital download. No physical item is shipped.

Please note: this is a record-keeping tool only. It is not tax, legal or accounting advice.