How to Create a Rent Receipt for HRA in Excel (India)

If you live in a rented house and receive House Rent Allowance (HRA) from your employer, rent receipts are the single most important document at tax time. They are what unlock the HRA exemption under Section 10(13A) of the Income Tax Act — and without them the entire HRA in your salary becomes taxable. Here is how to make a rent receipt in Excel that your employer and the income-tax department will accept.

When are rent receipts required?

Employers ask for rent receipts whenever your monthly HRA is more than ₹3,000. During Income Tax Return filing, the tax officer can also demand them. Two rules to keep in mind:

• Landlord PAN is mandatory when your annual rent crosses ₹1,00,000 (roughly ₹8,333 per month). Without PAN — or a signed declaration from the landlord — the HRA claim can be rejected.
• A revenue stamp of ₹1 must be affixed on cash rent receipts exceeding ₹5,000. For cheque, NEFT, UPI, or bank transfer, no stamp is required — the bank record itself is your extra proof.

What every rent receipt must contain

To be valid for HRA, every rent receipt needs these fields. Missing any of them can cause the employer or the tax officer to reject the claim:

• Receipt number and date
• Full name of the tenant
• Rent amount (in figures and in words)
• Period covered by the receipt (from date to date)
• Full address of the rented property
• Mode of payment — cash, cheque, NEFT, UPI, or bank transfer
• Landlord's name, address, and PAN (when annual rent > ₹1,00,000)
• Landlord's signature — over the revenue stamp for cash > ₹5,000

Step-by-step: make a rent receipt in Excel

1. Open a blank spreadsheet. Set page layout to A4 or letter so the receipt prints cleanly.
2. Add a title bar — RENT RECEIPT in bold at the top. Below it, add a one-line note: "For claiming HRA under Section 10(13A) of the Income Tax Act."
3. Create the receipt meta row — Receipt Number and Date, in two cells side by side.
4. Write the main text — a sentence like: "Received a sum of ₹[amount] from Mr./Ms. [tenant name] towards the monthly rent for the period from [date] to [date] for the property situated at [address]."
5. Add an amount block — three rows: Rent Amount (in figures), Amount in words, and Mode of Payment.
6. Add a landlord details block — Name, Address, PAN, Contact Number. Highlight PAN visually because it is the field most often missed.
7. Add a signature block with a small placeholder for the revenue stamp on the left, and a signature line + "Signature of Landlord" label on the right.
8. Print the receipt monthly, get it signed, and file a copy with your own records.

Rent receipt vs rent agreement

A rent agreement is a one-time contract that establishes the arrangement — parties, term, monthly rent, deposit, notice period. A rent receipt is issued every month as proof that a specific month's rent was actually paid. Both are commonly asked for at HRA-claim time — the agreement establishes the arrangement, the receipts prove ongoing payment.

How the HRA exemption is calculated

The HRA exemption you can actually claim is the least of these three amounts:

1. Actual HRA received from employer
2. Rent paid minus 10% of your Basic Salary + DA
3. 50% of Basic + DA if you live in a metro city — Delhi, Mumbai, Kolkata, Chennai; or 40% of Basic + DA for non-metro cities, which includes Bengaluru, Hyderabad, Pune, Ahmedabad, and all other cities

Sum up all 12 months of rent for the number to plug into that formula. A 12-month HRA log makes this trivial.

Common mistakes to avoid

• Skipping the landlord PAN when annual rent exceeds ₹1,00,000 — the most common HRA-rejection reason.
• Missing revenue stamps on cash receipts above ₹5,000 — required under the Indian Stamp Act.
• Preparing all 12 receipts in one sitting at year-end — obvious to the tax department; issue them monthly.
• Paying rent to a spouse and claiming HRA — courts and tax authorities disallow this.
• Paying rent in cash without any bank proof — technically allowed but risky; NEFT / UPI is much safer.
• Missing revenue stamp signature — the landlord must sign across the revenue stamp, not just beside it.

Save time — download our free rent receipt template

Instead of building the format from scratch, download our free Rent Receipt Template for HRA (India). It gives you two sheets: a printable single-month receipt with every HRA-required field, and a 12-month HRA log for the full April–March financial year that auto-sums your annual rent for the exemption calculation.

For related tools: the Salary Slip Template helps you verify HRA in your monthly pay, and the Cash Book Template is useful for landlords tracking rental income from multiple properties.

Summary

Rent receipts are what turn HRA in your salary from a taxable amount into an exemption. Every receipt needs the tenant name, rent amount, period, property address, mode of payment, and landlord's name, PAN, and signature. Add a revenue stamp for cash above ₹5,000 and always include the landlord's PAN if annual rent exceeds ₹1,00,000. Issue one receipt per month — never bulk at year-end — and keep them alongside your rent agreement for a clean HRA claim.

FAQ

Is landlord PAN mandatory for HRA claim?

Landlord PAN is mandatory when your annual rent exceeds ₹1,00,000 (approximately ₹8,333 per month). If the landlord refuses to share PAN, a written declaration from the landlord is required — but most employers will not accept the HRA claim without an actual PAN. Include the PAN on every rent receipt for the entire year to be safe.

Is a revenue stamp required on every rent receipt?

No. A revenue stamp of ₹1 is only required when the rent is paid in cash and the receipt amount exceeds ₹5,000. For payments made via cheque, NEFT, UPI, or bank transfer, no revenue stamp is needed — the bank record provides additional proof of payment.

Can I claim HRA if I pay rent to my parents?

Yes, you can pay rent to parents or a relative and claim HRA, provided (1) the property is genuinely owned by them, (2) an actual rent agreement exists, (3) payment is made via bank transfer, and (4) the recipient declares the rental income in their own Income Tax Return. Paying rent to a spouse is generally not accepted by courts and tax authorities.

How is the HRA exemption calculated?

The exemption you can claim is the least of these three: (1) actual HRA received from employer, (2) rent paid minus 10% of basic salary plus DA, (3) 50% of basic + DA if you live in a metro city (Delhi, Mumbai, Kolkata, Chennai) or 40% for non-metro cities. Adding up all 12 months of rent gives you the "rent paid" figure for the second calculation.

Do I need monthly receipts or is one annual receipt enough?

Best practice is one signed receipt per month — that is what employers and the income-tax department expect. A single lump-sum receipt for the whole year raises red flags during scrutiny. Issue monthly receipts and attach them along with a consolidated 12-month summary when submitting your HRA declaration.