Need excel based deduction calculation u/s 80ccd(2)

Save Share

This query is : Resolved

Quick Summary

This guide provides an Excel-based method for calculating deductions under Section 80CCD(2) of the Income Tax Act, specifically for employer contributions to the National Pension System (NPS). It outlines the steps involved, including determining the employer's contribution and ensuring it falls within the 10% of salary limit. A sample Excel template with formulae is provided to help you easily compute your eligible deduction for the financial year 2022-23.

Keyur

Keyur (Querist)
Follow

15 June 2022 Hello all

I required urgently excel based deduction working u/s 80ccd(2).

Can anybody share it for fy-2022-23??

thanks,

Keyur

Keyur (Querist)
Follow

01 July 2022 Anybody have excel based working??

Aashok Kumar Sharma online

Aashok Kumar Sharma

(Expert)
Follow

03 August 2024 To calculate the deduction under Section 80CCD(2) of the Income Tax Act using Excel, you need to follow these steps. This section allows for deductions for contributions made by the employer to the National Pension System (NPS) account of the employee.

Here’s a step-by-step guide and a template for calculating the deduction:

### Steps for Calculation

1. **Determine the Contribution Amount**:
- Check the total contribution made by the employer to the NPS account.
- Ensure this contribution is within the permissible limit under Section 80CCD(2).

2. **Check the Eligibility**:
- The contribution eligible for deduction under Section 80CCD(2) is the amount made by the employer up to 10% of the salary (basic + dearness allowance) of the employee.

3. **Apply the Deduction**:
- The deduction under Section 80CCD(2) is available over and above the Rs. 1.5 lakh limit under Section 80C.

### Excel Template for Deduction Calculation

Below is a sample Excel template you can use for calculating the deduction under Section 80CCD(2). You can copy this template into an Excel sheet and fill in the relevant details:

| **Description** | **Amount (₹)** |
|------------------------------|----------------|
| **1. Salary (Basic + DA)** | |
| **2. Employer Contribution to NPS** | |
| **3. Maximum Deductible Amount (10% of Salary)** | |
| **4. Deductible Amount Under Section 80CCD(2)** | |

#### Excel Formulae

1. **Maximum Deductible Amount**:
\[ = \text{Salary} \times 10\% \]

2. **Deductible Amount Under Section 80CCD(2)**:
\[ = \text{MIN(Employer Contribution to NPS, Maximum Deductible Amount)} \]

Here’s how you can set up the Excel sheet:

**Cell A1**: Description
**Cell B1**: Amount (₹)

**Cell A2**: Salary (Basic + DA)
**Cell B2**: (Enter Salary amount here)

**Cell A3**: Employer Contribution to NPS
**Cell B3**: (Enter Employer's contribution amount here)

**Cell A4**: Maximum Deductible Amount (10% of Salary)
**Cell B4**: `=B2*10%`

**Cell A5**: Deductible Amount Under Section 80CCD(2)
**Cell B5**: `=MIN(B3, B4)`

### Example

Let’s assume:
- Salary (Basic + DA) = ₹6,00,000
- Employer Contribution to NPS = ₹70,000

**Cell B2**: ₹6,00,000
**Cell B3**: ₹70,000
**Cell B4**: `=B2*10%` which equals ₹60,000
**Cell B5**: `=MIN(B3, B4)` which equals ₹60,000

In this example, the deductible amount under Section 80CCD(2) is ₹60,000.

Feel free to adjust the template according to your specific needs. If you need further customization or have additional requirements, let me know!

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!