Hello,

The organization I work at uses a csv template for timesheets that has multiple fields (name and different types of hours worked) including; Name of employee,Regular Hours,Team Lead Regular,Team Lead Night Sleep,Night Awake Hours,Night Sleep Hours,Sick Hours,Sick Night Sleep,Vacation Hours,Vacation Night Sleep etc. 

I tried using the import timesheets feature in Sage50 so that it can automatically map the name of the employee and the total hours worked for each work type but the feature asks me stuff like income, pieces, amount and only has 1 'hours' yet our organization has like 15 different kinds of hours and are all paid at their respective wage rates. Is there a way to change the format of timesheets in sage50 in a way that it is ideal for our organization?

Thank you for your help