Workforce Time Tracking & Payroll Management for Windows
Import attendance logs · Calculate hours · Resolve anomalies · Export to payroll
by Tabajah Stack
After downloading, right-click TrueHour.exe → Properties → Digital Signatures → verify the publisher before running.
TrueHour is a standalone Windows desktop application that takes raw attendance log files (.dat / .txt) from ZKTeco biometric terminals, parses login/logout events, and calculates the exact hours worked by each employee. It gives managers a clean interface to import data, fix anomalies, configure pay rates, and export payroll-ready reports — all without an internet connection.
Single .exe file. No installation. No runtime dependencies.
| Category | What you get |
|---|---|
| Smart Import | Drag-and-drop .dat files from ZKTeco terminals. Automatic merge and deduplication — importing the same file twice is safe. |
| Employee Management | Auto-detects new worker IDs on import. Set names, hourly or daily pay rates. |
| Timesheet View | Full shift grid with filters by employee, date range, and status. Color-coded anomaly and edit indicators. |
| Anomaly Detection | Flags missing logouts/logins, short/long shifts, unusual durations, and invalid time ranges. Severity-coded (critical, warning, info). |
| Resolution Options | Manual edit, type-specific quick fix, auto-fix using worker history, or batch resolve all. |
| Dashboard | Summary stat cards, per-employee reliability scores and behavior drift, salary estimates. |
| Payroll Export | Excel (with live formulas and summary sheet) or CSV. Headers localized to the selected language. RTL-aware. |
| Full Audit Trail | Every edit tracked with old/new values. Preview diffs, restore any snapshot, or checkout and branch. |
| Password Protection | Optional AES-256 database encryption (SQLCipher) with PBKDF2-HMAC-SHA256 key derivation (600K iterations). |
| Demo Mode | Try all features with pre-loaded sample data (16 employees, ~500 shifts). No activation required. |
| Offline Activation | Machine-bound Ed25519 activation codes — no server, no internet needed. |
| USB Update | Update from a USB drive with Authenticode signature verification — fully air-gapped. |
| Online Update | Optional GitHub Releases polling with streaming download + signature verification. |
| Trilingual | Full English, Hebrew (RTL), and Arabic (RTL) support. |
Import .dat → Detect → Review → Set Pay → Export
(drag & drop) Anomalies Timesheet Rates CSV/Excel
- Import — Drag a
.datfile onto the drop zone. New employees are auto-detected and named. - Fix Anomalies — Review each flagged shift. Choose manual edit, quick fix, or auto-resolve.
- Review Timesheet — Filter, sort, and edit shifts. Every change is tracked in the audit trail.
- Set Rates — Configure hourly or daily rates per employee. The dashboard shows salary estimates.
- Export — Select employees and a date range. Excel exports include live formulas and a summary sheet.
- Download
TrueHour.exefrom the latest release. - (Recommended) Right-click → Properties → Digital Signatures → verify the publisher signature.
- Double-click
TrueHour.exe— no Python runtime or installer required. - On first launch, follow the setup wizard or click Try Demo to explore with sample data.
| Requirement | Details |
|---|---|
| OS | Windows 10 or newer (x64) |
| Disk | ~60 MB for the executable; database grows with usage |
| Permissions | User-level write access to %LOCALAPPDATA% |
| Network | Not required (optional for online update checks) |
| Display | 1280×720 minimum recommended |
TrueHour reads ZKTeco attendance logs (.dat or .txt), tab or space-separated:
101 2026-01-21 08:00:03 1 0 0 0
101 2026-01-21 16:30:04 1 1 0 0
| Column | Content |
|---|---|
| 1 | Worker ID (integer) |
| 2–3 | Timestamp (YYYY-MM-DD HH:MM:SS) |
| 4 | Verification type (1 = fingerprint, 2 = card) |
| 5 | In/Out flag (0 = in, 1 = out) |
| 6–7 | Reserved (always 0) |
Do I need to install anything?
No. TrueHour is a single portable.exe — no installer, no Python runtime, no dependencies.
Can I try it before activating?
Yes. Click Try Demo on the activation screen to explore all features with pre-loaded sample data. Demo data is automatically cleaned up on exit.How do I get an activation code?
Launch TrueHour and copy your Request Code from the activation screen. Send it to the vendor — you will receive a machine-specific Activation Code in return.Does it require an internet connection?
No. TrueHour works fully offline. Internet is only used for optional online update checks.How do I update on an air-gapped machine?
Copy the newTrueHour.exe to a USB drive. In TrueHour, go to Settings → Check for Update and select the file. The Authenticode signature is verified before replacement.
What biometric terminals are supported?
Any ZKTeco terminal that exports attendance logs in the standard.dat / .txt format (tab or space-separated with Worker ID, timestamp, verification type, and in/out flag).
I forgot my database password — can I recover?
Yes. On the login screen, use the Forgot Password option to restore from any encrypted backup using that backup's password.If you encounter a bug or have a feature request, please open an issue.
For security vulnerabilities, see SECURITY.md.
Built for reliable workforce management by Tabajah Stack.