Hi,
As per the ESI Act, it is calculated on the gross amount. To arrive at the gross amount, various pay elements are considered such as Basic, HRA, Conveyance, and Special pay (balancing figure after allocating the amount in other pay elements), etc. Since PF, ESI, and Gratuity are calculated after gross salary, and ESI is calculated on gross, I am encountering a circular reference while preparing the salary fitment in the spreadsheet.
Can anybody guide me on how to arrive at gross earnings as Special pay is the balancing figure?
I would appreciate an early response.
Thanks,
Nikita
As per the ESI Act, it is calculated on the gross amount. To arrive at the gross amount, various pay elements are considered such as Basic, HRA, Conveyance, and Special pay (balancing figure after allocating the amount in other pay elements), etc. Since PF, ESI, and Gratuity are calculated after gross salary, and ESI is calculated on gross, I am encountering a circular reference while preparing the salary fitment in the spreadsheet.
Can anybody guide me on how to arrive at gross earnings as Special pay is the balancing figure?
I would appreciate an early response.
Thanks,
Nikita