Salary Calculation Template In Excel

I have Attached Sample Salary Calculation Template.

 

Salary Calculation Template
GROSS – Cost to Company Rs. Chq Amt Every Month Rs. Gets Will get in Rs.
Basic + DA 8000.00 Basic + DA     8,000.00 Take Home Amt                   12,040.00
PF 12.00%           960.00 PF, 12%       (960.00) Other accts                      4,780.00
HRA        4,000.00 HRA     4,000.00 Prof tax                         200.00
ESIC 4.75%                    – ESIC, 1.75%                  – Total                   17,020.00
LTA 5.00%           400.00 Conveyance         800.00 Annual CTC                 204,240.00
Medical 5.00%           400.00 Prof Tax       (200.00)
Conveyance           800.00 Helper allowance                  – Name
Outfit           100.00 Family welfare         200.00 Division
Helper allowance                    – Education allowance         200.00 Grade
Family welfare           200.00   12,040.00 Qualification:
Gratuity 4.50%           360.00 DOJ
Bonus 20.00%        1,600.00 Effective
Education           200.00 Added to other accounts Position
S.A. 10.00%                    – PF, 24%     1,920.00 Location
Food coupons                    – ESIC, 6.5%                  –
    17,020.00 LTA, 5%         400.00
  204,240.00 Bonus, 20%     1,600.00
Outfit         100.00
PF deposited in PF department Medical, 5%         400.00
ESIC deposited with ESIC dept Gratuity 4.5%         360.00
Prof tax paid to PT department Food Coupons                  – 549
LTA payable in August     4,780.00 99
Medical if appl.payable in August
Outfit if appl. payable in January
Bonus paid at the time of Diwali
Gratuity will be paid after 5 yrs services
Note: Your Compensation is personal to you and confidential between you and the Company.
         You are requested not to share details of the same with others, within or outside the Company.
            Eventhough LTA, Medical, & Bonus are the part of salary package, These will be  payable only if employee completes one year of service
Authorised Signatory

 

Click Here To Download Salary Calculation Template

Search Sample Formats: