Employee Attendance

Employee Attendance — Practical guide for claimed shop owners

Track who came to work, hours they did, overtime, and daily pay — all in one place. Clear, simple, payroll-ready.


Purpose

A single place for shop owners and managers to record and review staff attendance, compute daily hours and pay automatically, spot lateness/absences fast, and export clean CSVs for payroll or HR.


What this feature shows (at a glance)

  • Employee summary — name, role, employee code, photo and an optional quick rating.

  • Top tiles — total days in period, present/absent/leave/half-day counts, on-time %, total hours (regular & overtime), and total earnings.

  • Charts — daily hours (bar), attendance breakdown (pie), and daily pay (line).

  • Daily table — one row per date with status, check-in / check-out, regular & overtime hours, total pay and punctuality indicator.

  • Filters — pick employee(s), start & end dates, and status; sort by date, hours or salary.

  • Per-employee drilldown — open an employee to see day-level details and compute pay for each day.

  • CSV import / export — import bulk attendance, download template, and export current view for payroll.


Business benefits — why you’ll use it

  • Faster payroll: hours & daily pay computed automatically; export-ready CSVs.

  • Fair reviews: objective records for coaching, raises or corrective action.

  • Spot problems early: repeated lateness or rising absenteeism is visible in charts.

  • Smarter scheduling: use daily-hours trends to staff peak times.

  • Lower risk: reliability and punctuality scores reduce understaffing surprises.


Key features (what you can do)

  • Record daily attendance: present / absent / leave / half_day.

  • Add check-in and check-out times (required for present/half-day) so hours and pay compute.

  • See totals and charts for any date range.

  • Edit, delete, or create attendance entries manually.

  • Import bulk attendance via CSV (template provided).

  • Download template (CSV) for easy offline entry.

  • Export the current report/table as CSV for payroll or archives.

  • Tenant-aware: each shop sees only its employees/records.

  • Audit logs on create/update/delete.


How it works — non-technical

  • You record attendance or upload a CSV.

  • If check-in and check-out are present, the system calculates regular and overtime hours and daily salary using your shop’s employee salary rules.

  • Charts and totals are generated from stored daily records.

  • Export gives you the exact rows used to compute payroll for the selected period.


How to use — step-by-step (for managers / owners)

  1. Open Store Operations → Attendance Management.

  2. (Optional) Choose an Employee to filter, or leave blank for all employees.

  3. Select Start Date and End Date for the period you want to review. Click Apply.

  4. Check the top tiles for total hours, total pay and on-time % — these highlight urgent issues.

  5. Inspect the Daily table to find exact days with low hours, absent entries or unusual overtime.

  6. To add or fix: click Add (New Attendance) or Edit on the row you want to change.

    • For present / half_day: make sure you enter check-in and check-out times (format HH:MM).

  7. To bulk add: click Import, upload a CSV using the template. The import reports row-level errors.

  8. When ready for payroll: click Export CSV (includes the selected date range).


CSV template & rules

Header (required):

employee_code,date,status,check_in,check_out,notes

Example rows:

EMP001,2025-08-01,present,09:00,17:00,On time
EMP001,2025-08-02,absent, , ,Sick leave
EMP002,2025-08-01,half_day,09:00,13:00,Left early

Import rules

  • employee_code: must match the employee code in the system.

  • date: YYYY-MM-DD. No future dates.

  • status: one of present, absent, leave, half_day.

  • For present and half_day, check_in and check_out are required and must be HH:MM. check_out must be after check_in.

  • The importer validates rows and reports errors with line numbers — fix the CSV and re-upload.


How to interpret the numbers

  • Low total hours: Could mean slow store days or missed timecards — check day notes.

  • High overtime for one person: Risk of burnout — consider shift reallocation or hiring.

  • Low on-time %: Talk to the employee about start time or transportation issues.

  • Many absences on the same weekday: Could indicate a schedule conflict or consistent issue — investigate.


  • Morning (same day): check for absentees and late arrivals; reassign shifts where necessary.

  • Within 48 hours: follow up with staff showing repeated lateness or unexplained absences.

  • Weekly: review overtime and rebalance shifts to reduce excessive hours.

  • Monthly: export attendance CSV, reconcile with payroll and reward top performers.


Reports & exports

  • End-of-pay-period export: pick the pay-period date range and export CSV for payroll processing.

  • Monthly performance summary: export for owner/manager review.

  • File naming suggestion: attendance_{place_id}_2025-08-01_to_2025-08-15.csv


Access & privacy (important)

  • Only owners, managers, and authorized payroll/HR staff should access attendance.

  • Treat attendance records and personal data as confidential.

  • Avoid sharing CSVs over unsecured channels. Keep an audit trail for all exports.


Troubleshooting & FAQs

Q: My chart shows missing days. A: Confirm the date range and whether that day was a scheduled off, holiday, or missing timecard.

Q: Hours or pay look incorrect. A: Check check-in/checkout times and the employee’s salary settings. Small entry errors cause wrong totals.

Q: The import failed. A: Open the import error messages — they list row numbers and problems (invalid date, wrong employee_code, missing times). Fix and re-upload.

Q: Why did an employee get a low score? A: Scores are based on attendance, punctuality, hours consistency and overtime. Inspect daily rows to see the reason.


Quick manager checklist

  • Morning: check absentees & late staff.

  • Weekly: watch overtime and falling efficiency.

  • Monthly: export & reconcile with payroll.

  • Always: limit CSV shares to authorized staff.

Last updated