Automated Audit Pipeline
Fetch raw data straight from the Biometric & TimeChamp portals by date range — or upload files manually — then run the cross-reconciliation audit and open the styled workbook.
1 · Date Range & Sources
Both portals are downloaded and merged by the engine — same pipeline as a manual upload. Attendance up to yesterday is available.
1 · Raw Punch & Timesheet Sources
Drag & drop a file here…
Accepts .xls, .xlsx, and .csv. Pick one raw data file (Biometric, Timechamp, or Manual Tracking) — or several finished reports to consolidate.
2 · Engine Verification Parameters
- HR attendance cross-check Punches vs approved HR leave and holidays (live portal fetch).
- Shift boundary audit Late logins past grace and early logouts flagged per day.
- Worked-duration floors Days under 4h and under 8h worked flagged in the summary.
- Break policy Excessive break hours and more than 4 pauses per day flagged.
Built on this computer · large files can take a few minutes · the HR check needs internet.
Dashboard
Run health and the latest attendance snapshot — no Excel needed.
No reports yet
Generate your first report and this dashboard will show run health, attendance mix, and compliance flags for it.
Generate your first reportLatest Report
Attendance Mix
Loading latest report…
Policy Auditing
Compliance Flags
Loading flags…
Engine Execution Ledger
Recent Engine Job Runs
–
| Job ID | Input File / Source | Type | Status | Duration | Actions |
|---|
Reports History
Every run on this computer, newest first. Showing 20 runs per page — the newest 100 runs are kept; older ones are removed to save space.
No runs here yet
When you generate a report — or when the app finds reports from earlier sessions — they appear in this list for re-downloading.
Generate a report| Run date & time | Input File / Source | Type | Status | Duration | Actions |
|---|
Page 1 of 1
Loading report summary…
Schedules
Automatic portal fetch + report generation on a Daily, Weekly, or Monthly rhythm — the app must be running at the scheduled time.
No schedules yet
Create a schedule and this app will pull the raw attendance data from the portals and generate the report automatically — every day, week, or month.
| Schedule | Rhythm | Sources | Next run | Last run | Actions |
|---|
Schedules run while this app is open. If the app is closed at the scheduled time, the run fires once on the next start (catch-up).