Modular Business Management & Payroll Software Solutions for SMEs

Timesheets imported by CSV file were imported twice, how do I fix this?

If you find that Timesheets imported via a CSV file have been duplicated, this can be corrected by editing a copy of the original CSV import file, changing the sign of the Qty figure (eg, if originally 38hrs, change to -38hrs) on all lines, then import again.

You can discover if the timesheets have been imported more than once by starting a pay and checking the presented hours on a pay screen.  If, for example you were expecting 38 Hrs of Normal and 2 Hrs overtime, and you are seeing 114 Hrs of Normal and 6 Hrs overtime, you can presume that the timesheet file was imported three times, so the correcting hours need to be imported twice.