
One row per lease
The unit, the start and end dates, the monthly rent and the deposit. A lease ending within 60 days is marked when you open the file.
Rent owed, worked out from the leases
Type what arrived each month, and the Rent tab shows what is still owed, with partial payments, vacant months and late fees.
Repairs and expenses in one log
Each cost gets a date, a property, a category, the vendor and what was done, with Open or Done for repairs still to finish.
A year-end summary per property
Rent, late fees and fourteen expense categories, named and ordered like the lines on Schedule E. A record of what you typed, not tax advice.
What's in the download
- Six tabs, Start Here, Properties, Tenants & Leases, Rent, Expenses & Repairs and Year-End Summary
- Room for 6 properties, 12 units, 40 leases and 300 expense rows
- A copy filled with an example, and a blank one for yours
- A quick-start guide with the Google Sheets copies
- Four color themes in one file
Who it's for
Landlords with a few units who want tenants, leases, rent and repairs kept together in one file they can open on any day of the month.
Questions
How is it different from Rental Property Bookkeeping?
This one keeps tenants, leases, deposits and repairs, with a year-end summary. Rental Property Bookkeeping goes deeper on the money, with a Dashboard, a month-by-month Property P&L, five years side by side and a financial year that starts in any month.
Will it tell me when a lease is ending?
Inside the file, yes. A lease ending within 60 days is marked, and the count sits above the table, so you see it when you open the file.
Are security deposits counted as rent?
No. Each lease keeps its deposit, the day it was received and what was returned, and Properties shows what you are holding.
Goes well with
SpreadsheetRental Property BookkeepingRent due, rent received and every cost, property by property.
SpreadsheetShort Term Rental SpreadsheetEvery stay, its payout and its profit, for up to five properties.
SpreadsheetReal Estate Investment CalculatorRentals, flips and BRRRRs, worked out from the numbers you type.







