Salary Break Up in Excel Sheet
I have attached standard format for break ups in salary.
NAME OF THE COMPANY | |||
INCREMENT/ PROMOTION DETAILS AS ON _______ | |||
Emp. Name : | Mr. | Emp. Code : | |
Designation : | Sr. Executive | Department : | |
Promoted / Redesignated as : | NA | Transfer (if applicable) | |
From | To | ||
NA | NA | ||
SALARY – OUT OF ESI (Rs./Month) | |||
Monthly Earnings | Deductions | ||
Basic & DA | 7846 | PF | 780 |
HRA | 3139 | PT | 150 |
TA | 800 | ||
CEA | 200 | ||
Uniform Allowance | 500 | ||
Sub Total | 12485 | (C) | 930 |
Other Allowance | 5044 | ||
Gross Earnings(A) | 17529 | Take Home(A-C) | 16599 |
Other Benefits | TCC (A+B) | TCC (P.A.) | |
PF | 780 | ||
Bonus | 654 | ||
19,616 | 235,392 | ||
Medical | 654 | ||
(B) | 2087 | ||
Gratuity as per Act: | 4608 | ||
Gross Emoluments : | TCC | TCC + GRAT. | |
235392 | 240000 | ||