HRA Exemption & Calculation: A Payroll Guide
A practical guide for Indian employers on how HRA exemption is calculated, the documentation employees need, and how HRA is treated under the old vs new tax regime.
If you run payroll for an Indian company, you already know that House Rent Allowance is one of the most common — and most frequently botched — parts of a salary structure. Getting the HRA exemption calculation right matters for three reasons: it affects how much tax your employees actually pay, it determines how much documentation your HR team has to chase every year, and it directly influences whether your payroll process survives a tax audit without red flags. This guide walks through how HRA works, how the exemption is calculated, what changes under the old and new tax regimes, the paperwork employers must collect, and how payroll software can take most of the manual work off your team's plate.
We've written this specifically for HR managers, founders running lean payroll operations, and payroll executives who need a practical reference — not a tax textbook. Wherever exact percentages, thresholds, or rupee limits come up, we've flagged that you should confirm the current figures against the latest Income Tax Department rules and notifications before applying them, since these numbers are revised periodically and this article is meant to explain the mechanics, not to serve as a tax filing reference.
What Is House Rent Allowance (HRA)?
House Rent Allowance is a component of an employee's salary that employers pay to help cover the cost of rented accommodation. It's one of the oldest and most widely used allowances in Indian compensation structures, and it exists for a simple reason: employees who live in rented housing incur a real, recurring cost, and HRA is a way of building that cost into the salary package in a tax-efficient manner.
From a payroll perspective, HRA is not a reimbursement. It's a fixed allowance, usually expressed as a percentage of basic salary, that is paid out every month regardless of what the employee actually spends on rent. What makes HRA special is that a portion of it can be claimed as tax-exempt income under the Income Tax Act, provided the employee actually pays rent and submits the right proof. The rest of the HRA — whatever isn't exempt — is taxed like any other part of the salary.
This is why HRA exemption calculation is such an important topic for payroll teams. Two employees earning the exact same CTC, with the exact same HRA component, can end up with very different take-home pay depending on where they live, how much rent they actually pay, and whether they submit valid proof on time.
Why HRA Exists in Salary Structures
Most Indian salary structures break the fixed component into parts such as basic pay, HRA, special allowance, and sometimes other allowances like conveyance or leave travel allowance. HRA is typically structured as a percentage of basic salary — commonly somewhere in the range of 40-50%, though this varies by company policy and city classification, and there's no single mandated figure.
Employers include HRA in the CTC structure because:
- It allows employees renting a home to reduce their taxable income legally, which increases their effective take-home pay without costing the employer anything extra.
- It's a well-understood, standard component that employees expect to see in an Indian salary slip.
- It creates a natural incentive for accurate, on-time submission of rent proof, which supports cleaner payroll records.
Who Is Eligible for HRA Exemption?
Not every salaried employee automatically gets to claim HRA exemption. A few basic conditions need to be true.
- The employee must receive HRA as part of their salary structure. If HRA isn't a listed component in the salary breakup, there's nothing to exempt — this is a common scenario for consultants, contractors, or employees whose CTC is structured without a dedicated HRA line.
- The employee must actually be paying rent. HRA exemption is meant to offset a real housing cost. An employee who lives in a property they own, or lives rent-free with parents without paying anything, generally cannot claim the exemption for that period.
- The rented accommodation cannot be owned by the employee. If the employee owns the house they live in, they aren't eligible to claim HRA exemption for that residence, even if HRA is part of their salary.
- The employee must be under the old tax regime for the exemption to apply in the way described below. Under the new tax regime, most exemptions including HRA are not available in the same form — more on this shortly.
There's a widely discussed but often misunderstood scenario: employees who pay rent to a parent. This is generally permissible as a legitimate arrangement, provided the arrangement is genuine, rent is actually transferred (ideally through a traceable bank transfer rather than cash), the parent declares this rental income in their own tax return, and proper documentation exists. HR teams should treat these cases with a bit more diligence and clearly worded internal policy, since they attract more scrutiny than a standard landlord-tenant relationship. This is a good area to get specific advice from a tax professional or chartered accountant if it comes up frequently in your workforce, since the rules and required evidence can be nuanced.
Employees who don't receive HRA at all — for instance, because their company's salary structure doesn't include it — may still get some relief through Section 80GG, which we cover later in this guide.
The HRA Exemption Calculation Formula: The Three-Way Least-Of Rule
This is the heart of HRA exemption calculation, and it's where most confusion happens. The tax-exempt portion of HRA is not simply "whatever HRA the employee receives." Instead, it is the least of three amounts:
- The actual HRA received from the employer during the relevant period.
- Rent paid by the employee, minus 10% of salary (where "salary" for this purpose generally means basic pay plus dearness allowance, if applicable).
- A percentage of salary that depends on whether the employee lives in a metro city or a non-metro city — historically a higher percentage for metro cities and a lower percentage for non-metro cities.
Whichever of these three figures is the smallest becomes the amount of HRA that is exempt from tax. The remainder of the HRA received is added to taxable salary.
This "least of the three" approach is intentional. It prevents an employee from claiming full tax exemption on their entire HRA regardless of actual rent paid, while still giving genuine relief to people who are paying meaningful rent relative to their salary.
A crucial caveat: the exact percentages used for the metro/non-metro calculation, the definition of "salary" for this formula, and the specific thresholds involved are set by income tax rules and can be updated by the government. Before you hard-code any percentage into a payroll formula or communicate a specific number to employees, verify it against the current Income Tax Department guidance or consult your company's tax advisor. Treat any percentage mentioned anywhere as illustrative unless you've independently confirmed it against the current rules.
Breaking Down Each Component
1. Actual HRA received
This is the simplest of the three components. It's the total HRA paid to the employee by the employer over the period being calculated — typically a financial year, or a shorter period if the employee's salary, rent, or city changed partway through the year.
2. Rent paid minus 10% of salary
This component reflects the idea that a baseline portion of income naturally goes toward housing regardless of whether someone rents or owns, so only rent paid above that baseline should count toward exemption. If an employee's rent is quite low relative to their salary, this figure could be small or even zero, in which case zero becomes the least-of-three outcome and no HRA is exempt.
3. Percentage of salary based on city of residence
Metro cities generally get a higher applicable percentage than non-metro cities, on the reasoning that rents tend to be higher in larger metros. Which cities are classified as "metro" for this purpose is defined by tax rules, not by common usage — so a city that feels like a major metro in everyday conversation may or may not fall into the metro category for this specific calculation. Payroll teams should confirm the current official list of qualifying cities rather than assuming based on population or common perception.
Worked Example: Understanding the Calculation
Let's walk through an illustrative example. All figures below are hypothetical, used purely to demonstrate how the three-way comparison works — they are not official rates and should not be used as reference figures for actual payroll runs.
Assume an employee, let's call her Priya, has the following illustrative annual figures:
- Basic salary + DA: ₹6,00,000 per year
- HRA received: ₹2,70,000 per year
- Actual rent paid: ₹3,00,000 per year
- City of residence: a metro city (illustrative percentage assumption for this example only)
Now we calculate the three components:
| Component | Calculation (illustrative) | Amount |
|---|---|---|
| 1. Actual HRA received | Given | ₹2,70,000 |
| 2. Rent paid minus 10% of salary | ₹3,00,000 − (10% of ₹6,00,000 = ₹60,000) | ₹2,40,000 |
| 3. Percentage of salary for metro city (illustrative rate used here) | Illustrative rate applied to ₹6,00,000 | ₹3,00,000 |
| Exempt HRA (least of the three) | ₹2,40,000 |
In this illustrative case, ₹2,40,000 would be exempt from tax, and the remaining ₹30,000 of the HRA received (₹2,70,000 − ₹2,40,000) would be added to Priya's taxable income for the year.
Now consider a second illustrative example — Arjun, who lives in a non-metro city with a lower rent:
| Component | Calculation (illustrative) | Amount |
|---|---|---|
| 1. Actual HRA received | Given | ₹1,50,000 |
| 2. Rent paid minus 10% of salary | ₹1,20,000 − (10% of ₹5,00,000 = ₹50,000) | ₹70,000 |
| 3. Percentage of salary for non-metro city (illustrative rate used here) | Illustrative rate applied to ₹5,00,000 | ₹1,00,000 |
| Exempt HRA (least of the three) | ₹70,000 |
In Arjun's case, the low rent relative to salary is the limiting factor, so only ₹70,000 is exempt, and ₹80,000 of his HRA becomes taxable.
These two examples illustrate a key point for payroll teams: HRA exemption calculation is highly individual. It depends on the interaction of salary, rent, and city — you cannot apply a flat percentage rule to every employee and expect an accurate result. This is exactly the kind of calculation that benefits from automation rather than manual spreadsheets, especially once your headcount grows past a handful of people.
What Happens When Rent or Salary Changes Mid-Year
In practice, employees change accommodation, renegotiate rent, or get salary revisions partway through the financial year. When that happens, the exemption should technically be computed separately for each period during which the rent, salary, or city of residence remained constant, and then the exempt amounts summed up. A payroll system that only does a single annual calculation at the end of the year, using average or year-end figures, can produce a materially different (and less accurate) result than one that breaks the year into sub-periods. This is one of the more common gaps in manually maintained payroll spreadsheets.
HRA Under Old vs New Tax Regime
One of the biggest sources of employee confusion — and a frequent source of payroll queries — is how HRA is treated differently under India's old and new tax regimes. This is a critical piece of the HRA exemption calculation conversation, because the exemption described above only has meaningful value under one of the two regimes.
Under the old tax regime, the HRA exemption calculated using the three-way least-of rule reduces the employee's taxable income, which can meaningfully lower their tax liability, especially for employees paying substantial rent in expensive cities. The old regime also allows a range of other deductions and exemptions (such as those for investments, insurance premiums, and home loan interest) that many employees combine with HRA to reduce their overall tax outgo.
Under the new tax regime, most traditional exemptions and deductions — including the HRA exemption — are generally not available in the same way, in exchange for lower slab rates. This means an employee who opts for the new regime typically cannot reduce their taxable income using the HRA exemption calculation described in this guide, even if HRA is still paid out to them as part of salary.
This creates an important operational reality for payroll teams: you may need to run parallel calculations or maintain regime-specific logic, because employees can generally choose their preferred regime, and different employees within the same company may make different choices. Since rules on default regime selection and the ability to switch between regimes can change from year to year, payroll teams should confirm current guidance each financial year rather than relying on last year's process.
Here's a simplified comparison to help frame the conversation with employees:
| Aspect | Old Tax Regime | New Tax Regime |
|---|---|---|
| HRA exemption available | Yes, calculated using the three-way least-of rule | Generally not available |
| Other common exemptions/deductions | Generally available (subject to conditions and limits) | Largely restricted or unavailable |
| Tax slab rates | Generally higher slab rates | Generally lower slab rates |
| Rent receipts/proof required | Yes, to claim HRA exemption | Not required for HRA, since exemption isn't claimed |
| Best suited for | Employees with significant rent, investments, or eligible deductions | Employees with few deductions, or where lower slab rates outweigh lost exemptions |
| Payroll action needed | Collect rent proof, run HRA exemption calculation, adjust TDS accordingly | Skip HRA exemption calculation for TDS purposes; simpler processing |
Two practical implications for HR and payroll teams:
- Employee communication matters. Many employees don't realize that choosing the new regime means their rent receipts won't reduce their taxable salary through payroll. It's worth including a simple explainer during the investment declaration window so employees aren't surprised at year-end.
- Don't assume — ask. Since the choice of regime can vary by employee and by year, payroll systems need a clean way to capture each employee's regime preference for the year and apply the correct HRA treatment consistently through every payroll cycle, not just at the final settlement.
It's worth repeating: regime rules, default options, and the ability to switch between regimes during the year are governed by current income tax law and can change. Always verify the applicable rules for the relevant financial year rather than relying on memory or last year's policy document.
Documentation Employers and Employees Need for HRA Exemption
Accurate HRA exemption calculation is only half the job — the other half is having the paperwork to support it. If your company gets a tax notice or an employee's return is scrutinized, the documentation trail is what protects both the employee and, indirectly, your payroll process's credibility.
Rent Receipts
Rent receipts are the most basic and most commonly requested piece of evidence. A proper rent receipt for HRA purposes should typically include:
- Name of the tenant (the employee) and the landlord
- Address of the rented property
- Rent amount and the period it covers (usually monthly)
- Landlord's signature
- Revenue stamp affixed, where the rent paid in cash for a single receipt exceeds the applicable threshold (this threshold is set by stamp duty rules and should be verified rather than assumed)
Payroll teams typically ask for monthly or quarterly receipts covering the full period for which HRA exemption is being claimed. A common mistake is accepting a single receipt for the whole year without any supporting monthly breakup — this is weak evidence and can be challenged.
PAN of the Landlord
When annual rent paid crosses a specified threshold, the employee is generally required to furnish the landlord's PAN (Permanent Account Number) to claim HRA exemption. If the landlord does not have a PAN, a declaration from the landlord to that effect is typically required instead. This threshold is a specific rupee figure set by tax rules — payroll teams should confirm the current threshold before enforcing this requirement, since relying on an outdated number could mean either over-collecting unnecessary documentation or under-collecting required documentation.
Rental Agreement
While not always mandatory purely for HRA exemption claims, a signed rental agreement is strong supporting evidence and is increasingly requested by employers as standard practice, especially for higher rent amounts. It also protects the employee in case of scrutiny, since it corroborates the rent receipts and landlord PAN with a formal, dated document.
A Simple Documentation Checklist for Payroll Teams
- Rent receipts (monthly or quarterly, signed, with revenue stamp where applicable)
- Landlord PAN (or a "no PAN" declaration) where annual rent crosses the applicable threshold
- Rental agreement (recommended, especially above a certain rent level set by internal policy)
- Proof of rent payment via bank transfer, UPI, or cheque (strongly recommended, even if not strictly mandatory, since it reduces audit risk)
- A declaration form where the employee confirms the accommodation isn't self-owned
Encouraging non-cash rent payments is good practice generally — it creates a natural audit trail without extra paperwork and reduces disputes later.
HRA Payroll Processing: Where It Fits in the Annual Cycle
For most Indian companies, HRA exemption calculation isn't a one-time event — it's tied to the broader investment declaration and proof submission cycle that repeats every financial year. Understanding where HRA fits into that cycle helps payroll teams plan collection deadlines and avoid the year-end scramble.
Typically, the cycle looks like this:
- Start of financial year — employees submit provisional investment declarations, including expected HRA claims based on anticipated rent for the year.
- Mid-year — payroll applies provisional TDS calculations based on these declarations, reducing monthly tax deducted at source for employees who declared HRA and other exemptions.
- Later in the year, proof submission window — employees are asked to submit actual rent receipts, landlord PAN, and other documentation to substantiate what they declared earlier.
- Final calculation and reconciliation — payroll recalculates actual eligible exemptions based on submitted proof, adjusts TDS for the remaining months to true up any shortfall or excess, and reflects the final numbers in Form 16 at year-end.
If an employee fails to submit proof, or submits proof that doesn't match their earlier declaration, payroll is required to treat the earlier provisional exemption as invalid and deduct the corresponding tax, usually in the remaining payroll cycles of the year. This is one of the more sensitive parts of HRA payroll processing, since it can lead to a sudden, larger-than-usual TDS deduction in an employee's salary if they miss the deadline — a scenario that generates a lot of employee queries if not communicated well in advance.
Common Payroll Mistakes with HRA
Even experienced payroll teams make recurring errors around HRA. Here are the ones we see most often.
- Treating HRA as automatically fully exempt. Some smaller companies simply don't tax any part of HRA, assuming the whole allowance is tax-free. This is incorrect and can create liability for both the employer (as tax deductor) and the employee.
- Using a flat percentage for every employee regardless of city. Applying a single metro or non-metro percentage to the entire workforce without checking each employee's actual city of residence produces inaccurate exemption figures.
- Ignoring mid-year changes. Salary revisions, city relocations, or rent changes partway through the year require recalculating HRA exemption for each distinct period rather than applying year-end figures to the whole year.
- Accepting weak or incomplete rent receipts. Receipts without a landlord signature, without an address, or without a clear period covered are easy to challenge and put both employee and employer at risk.
- Forgetting the PAN threshold requirement. Not collecting landlord PAN when rent crosses the applicable threshold is a common compliance gap, especially in smaller HR teams managing this manually.
- Not distinguishing between old and new regime employees. Applying HRA exemption logic uniformly without checking which regime each employee has opted into for the year leads to incorrect taxable income and TDS calculations.
- Missing the proof submission deadline consequences. Failing to warn employees clearly about what happens if they don't submit rent proof on time, leading to unpleasant surprises in take-home pay later in the year.
- Manual, spreadsheet-based tracking at scale. Once a company crosses even 30-40 employees, manually tracking rent receipts, landlord PANs, city classifications, and mid-year changes in spreadsheets becomes error-prone and time-consuming.
- Not archiving proof properly. Rent receipts and PAN declarations should be retained in an organized, retrievable format in case of future scrutiny — loose paper receipts or scattered email attachments are a real risk.
How HRMS/Payroll Software Can Automate HRA Processing
This is where modern payroll software earns its keep. HRA exemption calculation, done manually across a growing workforce, is repetitive, rule-heavy, and easy to get wrong — exactly the kind of task software should own.
Here's what good HRMS/payroll automation typically handles:
- Structured proof collection. Instead of employees emailing PDFs of rent receipts to HR, an employee self-service portal can prompt for structured inputs — rent amount, landlord name, landlord PAN, property address, and receipt uploads — during the designated declaration window.
- Automatic three-way calculation. Once rent, salary, and city are captured, the system runs the least-of-three HRA exemption calculation automatically for each employee, removing manual formula errors.
- Period-wise recalculation. Good systems automatically break the year into sub-periods whenever salary, rent, or city changes, rather than applying a single flat annual calculation.
- Regime-aware processing. The system applies the correct treatment depending on whether each individual employee has opted for the old or new tax regime for that financial year, so payroll doesn't need to track this manually per employee.
- Deadline reminders and escalations. Automated nudges to employees who haven't submitted proof by the deadline, and automatic reversal of provisional exemptions with recalculated TDS if proof isn't received in time.
- PAN threshold checks. Built-in validation that flags when landlord PAN is required based on the rent amount, prompting the employee for it before the submission is considered complete.
- Audit-ready documentation storage. Centralized, searchable storage of rent receipts, agreements, and declarations tied to each employee's payroll record, instead of scattered files across email inboxes and shared drives.
- Form 16 accuracy. Because the exemption is calculated consistently and correctly through the year, the year-end Form 16 reflects accurate figures without last-minute manual reconciliation.
For a growing Indian SMB, this isn't just a convenience — it materially reduces the compliance risk that comes from ad hoc HRA handling, and it frees up HR bandwidth that would otherwise go into chasing receipts and manually checking formulas every declaration cycle.
Self-Employed and No-HRA-in-CTC Scenarios: Understanding Section 80GG
Not every working person has HRA as part of their compensation. This includes:
- Self-employed individuals and freelancers, who don't have a traditional salary structure at all.
- Salaried employees whose CTC structure simply doesn't include an HRA component.
- Employees who receive HRA but it isn't sufficient relative to actual rent (though in this case the standard HRA exemption calculation still applies to whatever HRA they do receive).
For people who pay rent but don't receive any HRA, Section 80GG of the Income Tax Act generally provides a way to claim a deduction for rent paid, subject to conditions and limits set by the tax rules. Broadly, and only as a general orientation:
- The individual (or their spouse or minor child) generally should not own residential accommodation at the place of employment or residence.
- The individual generally should not be receiving HRA from an employer for the period the deduction is claimed.
- The deduction amount is generally computed based on a formula involving rent paid, a percentage of total income, and a fixed cap — the specific formula, percentage, and cap are set by current tax rules and should be verified directly rather than assumed.
- A specific declaration form is generally required to be filed to claim this deduction.
Section 80GG is relevant to payroll teams mainly in an advisory sense — if you have employees whose CTC structure doesn't include HRA, or contractors/consultants who ask about this, it's worth pointing them toward 80GG as a possible option and recommending they confirm the current rules and limits with a tax advisor, since this deduction operates outside the standard payroll HRA exemption calculation and isn't something payroll systems typically process directly.
Step-by-Step: Setting Up HRA Processing During the Investment Declaration Cycle
For HR and payroll teams looking to tighten up their HRA process this year, here's a practical, step-by-step approach.
Step 1: Confirm current statutory parameters before the cycle begins. Before declarations open, verify the current applicable percentages, city classifications, PAN thresholds, and any other rule changes against official Income Tax Department guidance or your tax advisor. Don't carry forward last year's numbers by default.
Step 2: Communicate the old vs new regime choice clearly. Send employees a simple explainer (not just a compliance notice) covering what HRA exemption means under each regime, and confirm each employee's regime choice for the year in your HRMS before running provisional calculations.
Step 3: Open the investment declaration window with structured HRA fields. Rather than free-text submissions, use structured fields for expected annual rent, landlord details, and property city, so the system can immediately compute provisional exemption using the three-way rule.
Step 4: Apply provisional TDS adjustments. Based on declared figures, adjust monthly TDS deductions for the remaining months of the year, spreading the tax benefit evenly rather than applying it all at once.
Step 5: Set a clear proof submission deadline, well before year-end. Give employees adequate notice, and communicate explicitly what happens if proof isn't submitted — including the fact that TDS will be recalculated and any shortfall recovered from remaining salary payments.
Step 6: Validate submitted proof against declared figures. Check that rent receipts match the declared rent amount, confirm landlord PAN is captured where the threshold applies, and flag mismatches for employee follow-up before finalizing.
Step 7: Recalculate exemption using actual submitted data. Run the final HRA exemption calculation using verified figures rather than provisional declarations, accounting for any mid-year changes in salary, rent, or city.
Step 8: True up TDS for the remaining payroll cycles. Adjust the last few months of payroll to reconcile any difference between provisional and final tax liability, so employees aren't hit with a large deduction or an unexpected refund only at year-end.
Step 9: Reflect final figures accurately in Form 16. Ensure the exemption amounts reported at year-end match what was actually verified and processed through payroll, keeping the audit trail clean.
Step 10: Archive documentation systematically. Store rent receipts, landlord declarations, and rental agreements against each employee's payroll record in a retrievable format, in case of future scrutiny by tax authorities.
Running this cycle manually across even a modestly sized team consumes significant HR time every single year. Automating steps 3 through 9 through payroll software is where most companies see the biggest reduction in both effort and error rate.
Frequently Asked Questions
1. Is HRA fully tax-exempt? No. Only a portion of HRA is exempt from tax, determined by the three-way least-of rule — actual HRA received, rent paid minus 10% of salary, and a percentage of salary based on city of residence. The remaining HRA is added to taxable income. The exact percentages should be verified against current income tax rules.
2. Can I claim HRA exemption if I live with my parents and pay them rent? This is generally possible if the arrangement is genuine — meaning rent is actually paid (ideally via a traceable bank transfer), proper rent receipts exist, and the parent declares the rental income in their own tax return. This scenario tends to attract closer scrutiny, so it's worth confirming the specific requirements with a tax advisor.
3. What happens if I don't submit rent receipts on time? If proof isn't submitted by the payroll team's deadline, the provisional HRA exemption applied earlier in the year is typically reversed, and the corresponding tax is deducted from the employee's remaining salary payments for that financial year. This is why clear communication about deadlines matters.
4. Can I claim HRA exemption under the new tax regime? Generally, no. The new tax regime does not allow the HRA exemption in the way the old regime does, in exchange for lower slab rates. Employees should factor this into their choice of regime, especially if they pay significant rent.
5. Is a rental agreement mandatory to claim HRA exemption? A rental agreement is not always strictly mandatory purely for HRA exemption purposes, but it's strongly recommended as supporting evidence alongside rent receipts, especially for higher rent amounts, since it strengthens the documentation trail.
6. Do I need my landlord's PAN to claim HRA exemption? Generally, yes, once annual rent paid crosses a specified threshold set by tax rules. If the landlord doesn't have a PAN, a declaration to that effect is typically required instead. Confirm the current threshold, since it is subject to change.
7. What if my company's salary structure doesn't include HRA? If HRA isn't part of your salary structure but you pay rent, you may be able to claim a deduction under Section 80GG, subject to conditions and limits set by tax rules. This operates separately from the standard payroll HRA exemption process and generally requires a specific declaration.
8. How often should HRA exemption be recalculated during the year? Ideally, whenever there's a change in salary, rent amount, or city of residence, since the exemption should technically be computed period-wise rather than using a single average for the whole year. This is one of the areas where automated payroll systems offer a clear accuracy advantage over manual spreadsheets.
Conclusion
HRA exemption calculation sits at the intersection of compliance, employee trust, and payroll accuracy — get it wrong and you risk both incorrect tax deductions and a wave of employee queries every declaration season, but get it right and it becomes a smooth, largely invisible part of your payroll cycle. If your team is still tracking rent receipts, landlord PANs, and regime choices in spreadsheets, it's worth exploring how a purpose-built HRMS can take this off your plate — CozyHR handles structured HRA proof collection, automatic exemption calculations, regime-aware TDS adjustments, and audit-ready documentation storage, so your payroll team can spend less time chasing receipts and more time on the work that actually needs a human.
