Company-wide time tracking

Result

One tool for the whole company, and no more totals broken by a typo.

Duration

5 days

Problem

The whole company logged its hours by hand in a shared spreadsheet. One typo in a project name and the totals stopped adding up; any report by person or project had to be assembled manually every time.

What we built

An internal tool with a live timer and manual entry, a fixed list of departments, reports by project, person and day, a CSV export in the original spreadsheet's format, and sign-in through the company Google account.

Operating status

We operate it

The spreadsheet worked while a handful of people were logging hours. At a hundred and twelve it became a source nobody trusted — two people spelling the same project differently was enough to make a department's total wrong.

The new tool rests on two rules. Time is measured in one click, so it is not filled in afterwards from memory. And a project is not typed but picked from a list an admin maintains — which removed a whole category of errors rather than individual typos.

We deliberately kept the export in the spreadsheet's original format, so the accounting processes built on top of the old timesheet needed no changes at all.

Tech: Next.js · React · Tailwind · Supabase · Vercel