| Required to formulate the Paysheet for the entire employee.. Dear viewers,
how to prepare the paysheet for the entire employees in the organization in excel sheet ? Calculation also reqd. for this?
CTC -10000
BASIC - 30% From CTC
HRA - 20% from Basic
Special allowance (SA) - 15% from HRA
Conveyance allowance (CA) - 10% From special allowane
PF - 12% for employee & employer(8.33% & 3.67%)
ESIC - 1.75% for employee & employer(4.75%)
Excel sheet should be in the format (WD-wORKING DAYS)
name Grosspay WD no.of days leave HRA SA CA PF ESIC NETPAY
XYZ 10000 30 12
ADF 8000 30 6
Kindly, structure the format of the excel sheet for the entire employee in the organisation.
Deduction of employee & employer PF & ESIC format also required.
Is there any salary limit for an employee to register the PF & ESIC?
Kindly, reply me it is an very urgent requirement.
Thankyou in advance. | 
