What is included
- Property and lease records support portfolios of up to 10 properties and 40 units.
- Rent entries record dated payments and month assignments; deposits are tracked separately from rent income.
- Expenses, maintenance requests and a Schedule E-style summary accompany the landlord dashboard.
- Includes Google Sheets and sample/blank Excel; the Sheets quick-entry tools are edition-specific, and Excel photos require Microsoft 365.
Based on the Etsy listing reviewed October 28, 2026. Check the current listing for any later changes.
What to prepare
For the workflow this product is designed around, gather:
- Property and tenant references
- Rent periods, charges and any opening balances
- Individual payment dates, amounts and references
A practical way to use your records
Keep each received payment identifiable, including installments received for the same rent period. Review the ledger against your payment records and explain adjustments separately. Use consistent property and tenant references so a balance can be traced to its entries.
A worked example
Fictional example: a landlord preserves two partial rent payments while checking a tenant's remaining balance.
- Tenant and rent month
- Fictional Unit B02, one recorded month
- Monthly rent in lease record
- $1,200
- Payments received
- $700 followed by $400, each with its own date and reference
- Set the monthly rent in the lease record, then log both receipts separately in Rent Log against the same tenant and rent month.
- Check the receipt dates and amounts against payment evidence before reviewing paid and still-owed figures for that month.
Result: The two payments total $1,100, leaving $100 of the stated $1,200 rent unpaid. Recording the second receipt should not replace the first. This example excludes earlier balances, deposits and other charges so the month comparison remains clear.
Fictional figures explain the workflow; they do not represent customer results or guarantee particular template fields. See the included features above and the current Etsy listing.
A closer look at Rental Property and Tenant Rent Ledger Spreadsheet for Google Sheets and Excel
Additional previews from this product's Etsy listing. Open any image for a larger view.
Learn the method
Questions about this product
Is this a spreadsheet for a tenant rent ledger?
Yes. Rental property records, rent tracking and a tenant rent ledger are included.
Can I check a simple rent balance before choosing a template?
The separate free rent balance calculator on this site checks opening balance plus charges minus payments. It does not replace this paid ledger.
Which spreadsheet formats are listed?
This product is described for Google Sheets and Excel. Confirm the included files, software requirements and delivery instructions on its current Etsy listing.
