Actually you need a ready calculation sheet for calculating arrear. I can give you that and the remaining part I shall try to create as soon as possible. Actually I am presently working hard to create Salary bill for 400 employees fully automated which may take a long time. Please provide me some time.