Rental Property templates
Track your tenants, rent, and property income with clarity
Templates included
Key features
- Per-unit, per-tenant payment tracking
- Annual rent schedule vs collected
- Outstanding balance and days overdue
- Payment method recording
- Portfolio-level collection summary
Real use case
A landlord with 18 units across 3 properties uses this to produce a monthly rent statement. The outstanding balances view identified 4 tenants whose arrears had quietly grown to over ₦600,000 combined.
This template is being prepared and will be available shortly.
How to use these templates
- 1
Download the file
Click the download button. The .xlsx file saves instantly — no account needed.
- 2
Open in Excel
Open with Microsoft Excel 2016+ or Google Sheets. All formulas are pre-built and compatible.
- 3
Customise and use
Replace sample data with your business figures. Adjust headings and start immediately.
How Nigerian Landlords Can Manage Multiple Properties Without Losing Track of Rent
Rental property investment is one of the most popular wealth-building strategies in Nigeria, but it is also one of the most poorly managed from a financial perspective. Most Nigerian landlords with more than two or three properties are managing their rental income informally — through memory, bank alerts, and occasional conversations with tenants — rather than through a systematic record.
Property expense tracking is where most Nigerian property owners fail to see the real picture of their returns. Roof repairs, repainting between tenancies, and agency fees are all legitimate costs of ownership. Without capturing these costs systematically, the net return from your property portfolio is essentially unknowable.
Ready to move beyond spreadsheets?
DigitGlance Invoice automates invoicing, payment tracking, VAT reporting, and supplier management.
Need a custom rental property Excel solution?
We build custom VBA automation, management dashboards, and tailored Excel systems.