DA Calculation Sheet
Complete guide to Dearness Allowance calculation with detailed tables, formulas, AICPI data, and an Excel calculation sheet for central government employees.
What is a DA Calculation Sheet?
A DA (Dearness Allowance) calculation sheet is a structured document — typically an Excel spreadsheet — used to calculate Dearness Allowance for government employees and pensioners. It tracks the AICPI index values, computes the 12-month average, derives the DA percentage, and calculates individual DA amounts based on basic pay. This guide provides a complete reference with tables, formulas, and step-by-step instructions.
DA calculation sheets are essential for payroll departments, HR professionals, and individual employees who want to verify their salary components. With the 7th Pay Commission framework, understanding the calculation helps you anticipate future DA revisions and plan your finances accordingly.
DA Calculation Formula Under 7th Pay Commission
The DA formula under the 7th Pay Commission (Base Year 2016=100) is:
Where 261.42 is the base index value corresponding to the 12-month average AICPI for the base period 2016. The DA amount for an individual employee is then: DA Amount = (Basic Pay × DA%) / 100.
Sample AICPI Data Table for DA Calculation
Here is a sample of how AICPI data is tracked month by month for DA calculation. For the July 2026 revision, the data from January to December 2025 would be used:
| Month | AICPI Index (Base 2016=100) | Month | AICPI Index |
|---|---|---|---|
| January 2025 | 398.2 | July 2025 | 402.8 |
| February 2025 | 399.5 | August 2025 | 403.5 |
| March 2025 | 400.1 | September 2025 | 404.2 |
| April 2025 | 400.8 | October 2025 | 404.8 |
| May 2025 | 401.3 | November 2025 | 405.0 |
| June 2025 | 402.0 | December 2025 | 405.5 |
12-Month Average (Jan-Dec 2025): (398.2 + 399.5 + 400.1 + 400.8 + 401.3 + 402.0 + 402.8 + 403.5 + 404.2 + 404.8 + 405.0 + 405.5) / 12 = 402.31
DA% for July 2026: ((402.31 - 261.42) / 261.42) × 100 = 53.9% ≈ 54% (rounded)
DA Calculation for Individual Employees
Once the DA% is determined, individual DA amounts are calculated using this table structure:
| Basic Pay (₹) | DA% | DA Amount (₹) | Total (Basic + DA) |
|---|---|---|---|
| 18,000 | 54% | 9,720 | 27,720 |
| 35,400 | 54% | 19,116 | 54,516 |
| 45,600 | 54% | 24,624 | 70,224 |
| 56,100 | 54% | 30,294 | 86,394 |
| 78,800 | 54% | 42,552 | 121,352 |
| 1,00,000 | 54% | 54,000 | 1,54,000 |
Historical DA Rate Table (7th Pay Commission)
Here is the DA revision history since the implementation of the 7th Pay Commission:
| Effective Date | DA Percentage | AICPI 12-Month Avg |
|---|---|---|
| January 2026 | 55% (est.) | 405.2 |
| July 2025 | 53% | 400.2 |
| January 2025 | 50% | 392.1 |
| July 2024 | 50% | 392.1 |
| January 2024 | 46% | 382.3 |
| July 2023 | 42% | 371.2 |
| January 2023 | 38% | 361.1 |
| July 2022 | 34% | 350.0 |
| January 2022 | 31% | 342.8 |
| July 2021 | 28% | 335.2 |
| January 2021 | 28% | 335.2 |
| July 2020 | 28% | 335.2 |
| January 2020 | 21% | 316.8 |
| July 2019 | 17% | 306.0 |
| January 2019 | 12% | 292.8 |
| July 2018 | 9% | 285.0 |
| January 2018 | 7% | 279.6 |
| July 2017 | 5% | 274.5 |
| January 2017 | 4% | 271.8 |
| July 2016 | 2% | 266.5 |
How to Create a DA Calculation Sheet in Excel
Follow these steps to build your own DA calculation sheet:
Step 1: AICPI Data Tracking Sheet
Create a sheet named "AICPI Data" with columns: A: Month, B: Year, C: AICPI Index. Enter the last 24 months of data. In cell D2, calculate the 12-month average: =AVERAGE(OFFSET(C2,0,0,12,1)). This formula always takes the last 12 entries. In cell E2, apply the DA formula: =ROUND(((D2-261.42)/261.42)*100,1). This gives you the current DA percentage.
Step 2: Employee DA Calculation Sheet
Create a second sheet named "DA Calculation" with columns: Employee Name, Basic Pay, Current DA%, DA Amount (=B×C/100), Total Salary (=B+D). For multiple employees, copy the formula down. Use absolute reference ($C$1) if the DA% is in a single cell. Add conditional formatting to highlight employees with high DA amounts.
Step 3: DA Arrear Calculation Sheet
Create a third sheet for arrears: Employee Name, Basic Pay, Old DA%, New DA%, Difference %, Arrear Period (Months), Monthly Arrear, Total Arrear. Formula for Total Arrear: =B×(E/100)×F. This automatically computes arrears for any revision period.
DA Calculation for Pensioners (Dearness Relief)
DR (Dearness Relief) for pensioners uses the same percentage as DA for employees. The calculation sheet for pensioners replaces "Basic Pay" with "Basic Pension". The formula remains: DR = Basic Pension × DR% / 100. For family pensioners, the family pension amount is used. DR is also revised twice a year on the same schedule as DA.
Common Mistakes in DA Calculation Sheets
Avoid these common errors: 1) Using the wrong base year — ensure Base 2016=100 for 7th CPC. 2) Forgetting to round DA% to one decimal. 3) Not updating AICPI data monthly. 4) Using gross salary instead of basic pay for DA calculation. 5) Incorrect arrear period — arrears start from the effective date, not the announcement date. 6) Not accounting for DA merger when DA% exceeds 50%.
With a well-maintained DA calculation sheet, you can accurately compute current DA, estimate future revisions, calculate arrears, and ensure your salary components are correct. Use our online DA calculators alongside your Excel sheet for verification.