Small Landlord and PG Rent Ledger with Deposits, Renewals, Electricity Split and TDS on Rent

Owners of one to twenty flats, rooms or PG beds get one workbook to match rent to receipts, watch renewals and escalations, split one electricity bill across sub-metered rooms, and record TDS a tenant deducted, ahead of filing their own return.

What's inside

• Landlord-PG-Rent-Ledger-v1.0.xlsx: 13 sheets (Start Here, Settings, Properties, Units, Tenancies, Rent Roll, Receipts, Deposits, Electricity Split, Expenses, TDS on Rent, Annual Summary, Dashboard) with a fictional sample owner (labelled Sample) - one Chennai flat and one Hyderabad PG with 12 sub-metered beds
• Landlord-PG-Rent-Ledger-Guide.pdf: a 16-page setup and reference guide with worked examples and every source cited

How to use it

1. On Settings, set your rent due day, grace days, late-fee rule (leave off unless your agreement allows it), default escalation % and electricity split method.
2. List your properties, units and tenancies; escalation, lock-in and renewal dates compute on their own.
3. Log every payment on Receipts as it happens - Rent Roll and Dashboard update automatically.
4. Enter each electricity bill and sub-meter reading on Electricity Split to see each unit's share.
5. Record deposits, deductions and refunds, and any TDS a tenant deducted, on their own sheets.

Requirements

• Microsoft Excel 2010 or later. Every formula uses only functions Google Sheets also supports.

Good to know

• This is a template for general information, not legal, tax or financial advice. Laws and rates change. Check the current rules, or consult a qualified professional (an advocate, chartered accountant or company secretary), before relying on it.
• Tenants deduct and deposit TDS themselves; this ledger only records it against your Annual Information Statement / Form 26AS.
• The house-property income block is an estimate; PG and serviced-accommodation income may instead be treated as business income depending on the facts.