Sheet 1 — Self-Occupied Property
| Step | What it computes |
|---|---|
| Step 1 | Gross Annual Value (NIL for SOP) |
| Step 2 | Net Annual Value after Municipal Taxes |
| Step 3 | Deductions u/s 24(a) & 24(b) — interest capped at ₹2,00,000 |
| Step 4 | Income / Loss from House Property |
| Step 5 | Loss set-off (₹2L cap) & carry-forward u/s 71B |
| Step 6 | Additional deduction u/s 80EEA (first-time buyer) |
Sheet 2 — Let-Out Property
Covers all extra provisions specific to let-out properties — unrealised rent, vacancy allowance (Sec 23), recovery of past unrealised rent (Sec 25A), and unlimited interest deduction u/s 24(b).
Sheet 3 — Multi-Property Summary
A consolidated aggregator for up to 4 properties with automatic totalling and a set-off/carry-forward summary block for ITR filing.
Key features: Blue cells = input fields · Auto-detection of SOP vs Let-Out for GAV & deduction rules · All statutory limits built into formulas · Indian Rupee (₹) formatting throughout
