Novak Design
Back to projects
Live & ActiveFree 7-day demo

Attendance & Cost Management

A complete system for the construction company Polákstav — from an automated Google Sheet to a full web application for attendance, costs, per-site profit, quotes and payroll. Workers log hours from their phones, the owner sees every euro in real time. The system later grew into our product Evidenka.

19+
employees tracked
4+
construction sites
100+
formulas automated
0 hrs
manual payroll work
Web AppMobileGoogle SheetsAutomation

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.

Phase 2 — Done & Deployed

Web application dochadzka.polakstav.sk

The Google Sheet took the company far, but it had limits — fixed ranges in formulas, rate changes that rewrote the past, and nobody could tell who forgot to log their hours. So we replaced it with a full web application: one system that holds the whole company together — from an hour logged on site, through costs and profit, to a quote for the customer.

Attendance

The whole crew, the whole month on one screen — work, holiday, public holiday, sick leave. Fix an entry in two seconds and it flows straight into costs.

Worker portal

Workers tap their hours on the phone right from the site. One tap — day logged. Editable until 7:00 the next morning, then the day locks.

Costs

Labour is calculated automatically from attendance and rates, plus materials and overheads — per site and per month.

Profit per site

Revenue minus real costs = profit and margin of every site. Any time, not at year end.

Finance & charts

Where the money goes, costs by month, hours worked — clearly in charts.

Quotes

A quote from your own price list in minutes, exported as a finished PDF for the customer.

Payroll & advances

Who gets how much in hand, including advances — accurate to the cent, straight from the phone on site.

Holidays

Request from the phone, approve with one click, instantly reflected in attendance and costs.

Change history

Every change is traceable — who, what, when.

Rates over time

A new hourly rate applies from the chosen month; the past stays as it was.

Open the app — dochadzka.polakstav.sk

Offer for companies

Free 7-day demo

We built the system for Polákstav, but it is universal — it fits any company with people in the field that wants attendance, costs, job profit, quotes and payroll in one place. Construction, trades, installations, services.

  • Full access to every module for 7 days, no strings attached
  • Try it on your own people and jobs — not on sample data
  • Logins for the admin and for workers on their phones
  • After the trial we tailor the system exactly to your company
I want the demo

Reach out via the form or e-mail — we set up your demo within 24 hours.

App walkthrough (46 s, demo data)

Client

Polákstav s.r.o. · Construction · 2026

Polákstav s.r.o. · Construction · 2026

Built with

Google SheetsApps ScriptQUERY FormulaFILTER FormulaARRAYFORMULAConditional FormattingData Validation

Interested in a similar solution?

Let's talk