I want, when I know the gross salary, then automatically calculate ESI, PF, and CTC. Or when I know the take-home salary, then automatically calculate ESI, PF, and CTC. Please, can anyone help me with this problem? Please format an Excel sheet.
From India
Acknowledge(0)
Amend(0)
CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Other Discussions That May Be Relevant
Esi-pf calculation made simple with excel sheet - xls download Hi all i have attached an excel sheet that integrates all esi pf based statutory preparations on a monthly and annual basis. the interesting part of the excel sheet is... 7 Replies3 Files7 Participants
Re: preprations of esi of employees - xls download Dear seniors how do i prepare the esi of employees in an excel sheet? could you please send the excel sheet in which esi is prepared? thank you ... 5 Replies1 Files4 Participants
What will be the deduction amount of pf? - xls download If the basic salary is inr 15000 what will be the deduction amount of pf on: 1 employee contribution 2 employer contribution pension 8.33 3 employer contribution pf balance on... 14 Replies2 Files3 Participants