Hi every one! Kindly suggest the formula to find the gross salary & other statutory deductions if the take-home amount is only confirmed. Regards
Cite.Co is a repository of information created by your industry peers and experienced seniors made possible with help from our prime sponsors like:

TALENTEDGE Who provide a platform for "interactive anywhere learning". Courses from top reputed institutes like IIM, XLRI, MICA. View Courses

FACTOHR - Provides Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS that can help streamline your organisation. Explore Features

Register Here and help by adding your inputs. Contributions From Other Members Follow Below...
Can you tell me what is the take home amount. And also the Statutory Compliance Components to be considered.
Sure. There is two cases for Rs.7k & 12k as take-home salary. And, deductions have to made basically for PF, ESI and PT.
Hi Uday,
Please refer to below salary structure for in hand 7k. The total gross has to be offered as 8000/- & CTC as 9040. In case of further clarification ,pls revert.
Total Monthly Gross 8000
Basic 5500
HRA 2500

PF ( Employee) 660
ESIC ( Employee) 140
PT (As applicable) 200
Additional Contribution-
PF ( Employer) 660
ESIC ( Employer) 380

Total CTC 9040
In hand Salary 7000
Hi, As requested please find the CTC Calculation for 7K and 12K Let me know if further assistance required.

Attached Files
Membership is required for download. Create An Account First
File Type: xls CTC Calculation.xls (31.0 KB, 368 views)

Nice Suggestion. But want to know excel formula sheet. So that all the related fragments came out thrg a single button when the known take-home amount will fit in it. Regards
Kindly find the below link
Major Salary Components « hrmexpress
Let me know if further assistance required.
If Take home salary is Rs.7000 in that case Salary would be like this:
Basic Rs. (50%) 3500
HRA Rs. (20%) 700
Travel 800
special all. 2000
Gross salary 7000
PF (12%) 420
ESI (1.75%) + 122
Cost to company would be calculated annually
Basic 42000
HRA 8400
Travel 9600
Special all 24000
PF (12%) 5040
ESI (4.75%) +3996
CTC 93,036
Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™