1. How to Use the Rent Ledger Template
A rent ledger is your source of truth for all rent payments. Our template is pre-formatted with formula columns that calculate outstanding balances automatically.
Step-by-Step Setup:
- Enter Property Details: Input property name, unit/room number, and tenant names.
- Set the Monthly Rent: Input the agreed monthly rent amount for each tenant.
- Record Payments: When a tenant pays, enter the payment date and the amount paid.
- Automatic Calculations: The sheet automatically calculates the balance. If a tenant pays less than the due amount, it will flag it as an outstanding balance.
2. Generating Rent Receipts Automatically
Providing rent receipts is essential for tenant record-keeping and tax claims (like HRA in India). Instead of writing receipts manually, our toolkit includes a dynamic generator.
Simply enter the tenant's name, room number, payment period, and amount. The template compiles this into a clean, print-ready, professional receipt template that you can save as a PDF and share via WhatsApp or Email.
3. Vetting the Landlord-Tenant Agreement
A strong agreement prevents legal disputes. Included in this bundle is a standard template detailing terms for:
- Security deposit terms and refund rules.
- Monthly rent due date and grace periods.
- Maintenance responsibilities (who pays for major vs. minor repairs).
- Notice periods for vacating the property.
4. Keeping a Maintenance & Expense Log
True profitability is calculated as **Gross Rent Revenue minus Maintenance Expenses**. Use the Maintenance Log tab in the spreadsheet to record plumber fees, electrical repairs, painting, and cleaning costs. This helps you calculate your true Net Rental Yield at the end of the financial year.
Tired of Manual Spreadsheets?
While Excel is great for starting out, updating it manually every day becomes a headache as you scale. Tenants forget to pay, sending manual screenshots gets confusing, and copying numbers can lead to manual errors.
With Nivasa, you can: