Small sites using FingerTec TCMS
Turn the punch list into a lateness and missing-punch report in Excel.
FingerTec Attendance Excel Export: Headers and Pitfalls
A FingerTec TCMS attendance log is a plain punch list. The header shape our tests cover is User ID, Name, Date, Time, with the date and the time in separate columns and no in or out column. WatheeqaHR reads User ID as the employee ID and combines Date and Time into the punch. With no direction column, the first punch of each day is check-in and the last is check-out.
FingerTec: header shape, what WatheeqaHR reads and pitfalls
The header shape our tests cover
The automated tests resolve this header row: User ID, Name, Date, Time, with User ID as the employee ID. Export the TCMS attendance log as Excel or CSV.
What WatheeqaHR reads from it
User ID is the employee ID and Name the employee name. Date and Time are two columns that the analyzer combines into one timestamp per punch. There is no State or Type column in this shape, so no direction is read.
Pitfall: no in and out column
Without a direction column, the analyzer takes the first punch of each day as check-in and the last as check-out. Any extra punch in the middle of the day does not change that, but an extra punch before or after the real ones does.
Pitfall: a single punch in a day
A day with one punch has no check-out. It appears as a missing punch for HR to review, not as a confirmed absence, so check those days against the real attendance before using the totals for payroll.
Before you upload
Keep Date and Time as two columns, as exported. Upload one month at a time, under 5 MB, and check in the preview that both columns are present.
Features
| Feature | Description |
|---|---|
| User ID | Employee ID. |
| Name | Employee name. |
| Date | Punch date, read together with Time. |
| Time | Punch time, combined with Date. |
Who uses this
Payroll reviewers
Know which days to check by hand when a single punch is missing its pair.
Frequently asked questions
How do I convert a FingerTec TCMS report to Excel?
Export the attendance log from TCMS as Excel or CSV and upload it to the free analyzer. WatheeqaHR reads the exported file and does not connect to the device.
Does FingerTec data show check-in and check-out?
This header shape has no in or out column, so the first punch of each day counts as check-in and the last as check-out.
What happens to a day with one punch?
It is shown as a missing punch for review, not as a confirmed absence.
Do I need to merge Date and Time myself?
No. Keep them as two columns and the analyzer combines them.
Is this a FingerTec compatibility guarantee?
No. This page describes the header shape our tests use. Test your real file.
Related pages
Start with your real attendance file
Upload an Excel or CSV export and review the result free — no signup required.
Analyze attendance free Create free account