Attendance Format For Outsourced Employees - XLS Download

Dear All..
My company is providing recruitment and payroll services to one of its client.
Staff is working for the client but are on our payrolls.Plus these employees are located in different locations in India.
Every month we receive the attendance from our client in a an unorganized way.
Please help me to develop a format which i can send to my client and get the updates in a proper manner.Also please update me the best way to cross check /audit this attendance sheet.
waiting for the valuable inputs from seniors
regards,
Vanita

Please find the attached format , if t can help you out for the same.

please give password for unprotection n further modification...