Attendance & Cost Management
A fully automated Google Sheets system for a Slovak construction company — tracking 19 employees across 4 active construction sites. Replaced manual Excel sheets, automated monthly payroll, and gave managers a real-time cost overview.
The Problem
A growing Slovak construction company was managing employee attendance, wages, and site costs across multiple active construction sites using manual Excel sheets. Errors were frequent, monthly payroll took days, and managers had no real-time overview of costs per site.
Our Solution
A fully automated Google Sheets system replacing all manual tracking — 3 contract types, automatic wage calculation, daily attendance statuses, site cost splitting, and per-employee monthly reports. Built to run without any technical knowledge from the client.
What we built
Employee Management
3 contract types (employment, trade licence, agreement), automatic hourly rate calculation and vacation entitlement tracking.
Daily Attendance Tracking
Work / Sick Leave / Vacation / Holiday / Inactive statuses with dual-site support and automatic cost split.
Smart Site Management
Active/inactive site filtering via dynamic FILTER formulas — no manual list maintenance required.
Automatic Cost Calculation
Real-time hours × rate per employee, separate logic per contract type, auto-attributed to the correct site.
Monthly Reports
Total hours and costs per site per month, per-employee breakdown, sick leave and vacation costs tracked.
Employee Dashboard
Actual vs. planned hours, cumulative balance from first working day, remaining vacation, per-site cost breakdown.
Web Application
- Role-based access (Admin / Manager / Employee)
- Mobile-optimised interface
- PDF / Excel export on demand
- Automated monthly email reports
- GPS check-in at construction sites
Client
Polákstav s.r.o. · Construction · 2026
Built with
Interested in a similar solution?
Let's talk