Change in employee hourly rate causes retro-active change in pay.
Hey all, we have been having a problem with our timesheets when changing an employee's pay rate. We are electrical contractors, and we use our timesheets to do cost analysis on a job when the job is complete. However, if we change an employee's pay rate during the time when the job is still active, t-sheets will retroactively change the pay rate of the employee. For example, if an employee was being paid $20/hour for the first 6 months of a job, and we raise them to $25/hour for the last 6 months of the job, when we do our cost analysis at the end of the job it will show that the employee was being paid $25/hour for the entirety of the job. This makes cost analysis very difficult; I was wondering if anyone else has encountered this issue and had a solution.