This is part of a series of articles on Importing Time Sheets with Excel.
In this article, we are going to review the potential reasons that a totals mismatch could occur.
When a totals mismatch occurs, the Import Results screen will display a red "X" next to the Totals Comparison box and the two totals will not equal each other.
1. The primary reason this may occur, is that a formula in the spreadsheet has been accidentally deleted or modified. The best method to fix this problem is to download a fresh copy of the spreadsheet using the Download Template screen. Then copy and paste the data from one sheet to the other.
Important - Only copy and paste the data in the WHITE cells. The white cells are safe and can be copied. Do not copy any other data because this could cause additional problems.
2. Another reason a totals mismatch could occur is there are blank rows between employees data. There should not be any space/rows after an employees Totals row and the next Employee's Number.
If this does not resolve the problem, please reach out to support for further assistance.