When a DA revision is announced, the number that matters isn't the new percentage — it's the difference it makes to each component of take-home pay, multiplied across every month the revision covers. That multiplication is where this template does its work.
The Wage Base
BASIC PAY and GRADE PAY form the foundation. Every percentage-based allowance in the Indian government pay structure calculates against this sum. Enter them once per salary month; the calculated fields handle the rest.
HRA Amt is computed automatically at 30% of the basic-plus-grade total — the standard rate applicable under many pay commission recommendations. This doesn't need to be entered; it reflects from the base fields.
Old vs. New DA
The template holds two DA percentage fields — DA percent Old and Da Percent New. Both yield corresponding DA amounts via calculation. The Difference Da field is the output that matters: the per-month increase in DA entitlement that results from the hike.
This difference, summed across the arrears period, is the total arrears amount. That sum isn't in the template — it lives in an aggregation across multiple monthly records — but the per-month figure is the input every arrears calculation requires.
Special Pay Components
OT Bonus Hrs, Nda Hrs, and Nsb Bonus hrs capture the variable hour-based components. Each generates two calculated amounts — old and new — because OT rate, NDA rate, and NSB rate all change when DA changes. An employee working consistent night duty allowance hours has DA-sensitive earnings beyond the base salary.
Tpt Amt with out da handles transport allowance before DA loading. Tpt Old and Tpt New show the transport amount under both DA regimes — a figure relevant when transport allowance is DA-linked.
fpa (Fixed Personal Allowance) is entered directly and flows into OT calculations. Its value doesn't change with DA, but it affects the OT rate denominator.
Practical Use
One record per salary month captures the calculation state at that point in time. When arrears cover a 12-month revision period, 12 records produce 12 Difference Da values. The sum of those values is the arrears claim — documented, calculable, and verifiable.