I am working in the company which having 300 manpower in different state and facing problem with compliances and minimum wages . How can i mange the same in excel payroll?
From India, Pune
2From India, Pune
HI Manish
I understand Managing payroll for different states is quite difficult as the statutory part needs to be taken care esp PT/LWF, however we can always create a one time standard (master) Excel sheet with respect to payroll.
You need to give the accurate details like
States in which your Employee are present.
What % of CTC you are allocating to Basic/DA.
What is the minimum salary you are paying to your employees. etc!!!!!!!
Please have these details ready with you.
For any details/help You can revert to this or you can also send me a mail to
i can try to help you.
From India, Bangalore
I understand Managing payroll for different states is quite difficult as the statutory part needs to be taken care esp PT/LWF, however we can always create a one time standard (master) Excel sheet with respect to payroll.
You need to give the accurate details like
States in which your Employee are present.
What % of CTC you are allocating to Basic/DA.
What is the minimum salary you are paying to your employees. etc!!!!!!!
Please have these details ready with you.
For any details/help You can revert to this or you can also send me a mail to
From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Payroll.xls
Payroll.doc
Folklore Payroll.pdf