Full Question: We have employees in different provinces, and depending on the province, we have certain expenses associated with those employees. A simple example is payroll taxes, that are different in BC and QC. Is there a way to "code" employees as BC, QC, ON etc... and then make a calculation of payroll taxes by province? Is there another easy way you could recommend we do it?
Answer: There are several elements to this:
First - for each province where there is a different payroll tax rate, you'll need to create a different payroll tax formula (Employees > HR Formulas).
Second - you will apply the appropriate formula to each employee that works in that province. If you have a lot of employees, you can make it easier to find the right employees by adding a suffix (e.g. BC, QC, etc) to the employee code or job title - the employee menu on the formula page is searchable.
Third - If you have an employee that works in both BC and QC then the best way to do this is to add that employee twice. For example, if the employee code is 1001, create an employee 1001-BC and another employee 1001-QC, using the same employee name. Then you can set payroll for each of these employees and partially allocate their salary. So employee 1001-BC would get say 30% of the salary and 1001-QC would get 70%. Then use the appropriate HR formula for each part of the split employee