Feed Only One Cell & Get Your Salary Sheet With PF & E.S.I.C.

Share:

Feed Only One Cell & Get Your Salary Sheet With PF & E.S.I.C.


How To Get Your Salary All Deduction & Allowances Details With Only Feed One Single Cell In Excel. Guys Here We Share You an Excel Sheet Where You Easily Learn How To Calculate Your Salary With Excel With All Deduction & Allowance In One Single Step.

First You Have To Open Your Salary Slip & Find your Basic Salary & Feed The Excel Basic Salary Amount In cell & Automatically You Can Get Your Pf Amount From Your Hand & Also Get Amount Deducted From Employer.

This Is the easy way to Find your Salary Details

First Step You Have To Create One Plane Excel Sheet As Like Below Image


When You Complete This Step After You Have To Create One Sheet As Like Below Image.
Also I'll Show You How You Put The Formulas In Cells.

You only Have To Put a Data Of Red Color Marks In Below Image


 Show When You Put That Data In Your Excel It Means Format Like Name, Basic Salary, Pf  & ESIC As Etc Like Like Second Image.

After That You Have To feed Formulas In All Cells Like That

Basic Salary = Your Basic Salary

H.R.A. = Your House Rent Allowance From Company

Convenience Allowance = Feed amount Actual You Get From Company For Convenience Allowance

Other Allowance = Feed amount Actual You Get From Company For Other Allowance

Gross Salary = Your Basic Salary + Your All Allowances

 Deduction From Your Salary

Deduction from your Hand = Provident Fund + E.S.I.C. + Professional Tax

Provident Fund :

As Per Indian Government That All The Employee Have To pay 12% Of Amount Of basic Salary For Provident Fund So Formula Of Pf = Basic Salary(Cell)x12%

E.S.I.C. :

As Per Indian Government That All The Employee Have To pay 1.75% From Her/His Owen Gross Salary For E.S.I.C. So Formula Of Pf = Basic Salary(Cell)x12%

Professional Tax:

As per Indian Government That All the Employee have To pay Some Amount as Professional Tax When The Do Job In Any Big Or Small Companies.

Salary Take Home Or On Hand Salary Or Net Salary

Net Salary = Gross Salary - Total Deduction From Employee

Total Deduction From Employee :

Deducted Amount as P.F., E.S.I.C & Professional Tax

 Deduction From Employer Hand

Also Provident Fund & Employee Insurance (E.S.I.C.) From Employer Hand As Are Below Mentioned Percentage 

Provident Fund : 13.36% On Your Basic Salary Formula ( Basic Salary x 13.36% )
E.S.I.C : 4.75% On Your Gross Salary Formula ( Gross Salary x 4.75% )

Total Deduction From Employer Hands

Total Deduction = Provident Fund From Employer Hand + E.S.I.C. From Employer Hand

C.T.C. = Cost to Company

C.T.C. = Cost to Company = Gross Salary + Total Deduction From Employer Hands

So Here You Put Only Your Basic Salary & Know your Cost To Company, Gross Salary & Net Salary Also & You Can Also Study This Excel From Below Download Button You Can Easily Download This Excel Sheet Easily.



No comments