Hi,
it is true that you can handle this using xls. But you can save good amount of time and manage payroll and leave in a more sophisticated way with the help of software. I would suggest you to try Greytip Online
www.greytip.in ( Free trial for 30 days, No installation is required and you can use it just like email or facebook).