How to mange payroll in excel for 300 employee for diffrent state

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?

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 [Login to view] i can try to help you.