Rajasthan Teachers Web Portal & Salary Rules Updates!
LATEST NEWS
ЁЯФе RPSC RAS рднрд░реНрддреА 2026 рдХрд╛ 607 рдкрджреЛрдВ рдкрд░ рдиреЛрдЯрд┐рдлрд┐рдХреЗрд╢рди рдЬрд╛рд░реА   •  
general

7th Pay Arrear Excel Sheet Free Download

June 08, 2026 22 Views

 

ЁЯУЛ SEO Optimized Resource Page

7th Pay Commission Salary Arrears Calculator

Quick guide on understanding salary fixation matrices, retroactive DA calculations, and how to verify computations using offline Excel automation spreadsheets.

What is a Salary Arrear in Central & State Services?

A salary arrear is the amount paid to an employee as retroactive payment for service rendered during a previous period when pay levels were subject to upward revision. In government service, this most commonly occurs during the implementation of Central Pay Commissions (CPC) or after the declaration of backdated Dearness Allowance (DA) hikes.

When the government implements a new pay structure retroactively, the difference between the revised salary and the historically drawn salary is computed for each month. This accumulated outstanding sum forms the arrear payout, which must be itemized meticulously to satisfy tax reporting structures.

ЁЯТб

Important Note: In Indian civil services, salary arrears are historically governed under Section 89 of the Income Tax Act, allowing employees to claim relief from sudden high-tax brackets.

Step-by-Step Calculation of 7th CPC Arrears

To compute your revised salary arrears under the 7th Pay Commission regulations, the absolute change in Basic Pay and Dearness Allowance must be simulated month-by-month. Follow this formula logic:

  • тЬУ Pay Matrix Fixation: Map your existing basic scale to the corresponding fitment factor (2.57 multiplier) in the designated level (Level 1 to 18).
  • тЬУ Revised DA Accrual: Calculate historical revised Dearness Allowance percentages against the newly fixed monthly basic salary.
  • тЬУ Differential Summation: Subtract the total drawn basic and DA from the computed revised values to extract the monthly arrear dues.
Share Article: WhatsApp