← Our work

KARVANIS / Our work

Time management: from entry to reporting

A business application connecting the steps of time tracking: information entered once feeds calculations and useful reports.

41users
One central processEntry → calculations → exports

Client project

The workflow in four steps

  1. Clock records

    Import clock-in and clock-out records.

  2. Rules

    Match working hours with schedules and absences.

  3. Review

    Examine discrepancies and record reasons for corrections.

  4. Reports

    View balances and prepare exports for HR.

Understand the implementation

Turning clock records into explainable results

This time management project starts with a simple event: a person clocks in or out. Its output needs to be useful to the employee, their manager and HR. The complexity lies in the rules and exceptions between the original record and the final result.

Read exports and apply working rules

The calculation engine imports time-clock exports, including CSV, Excel and attlog.dat files. It connects records with people, schedules, absences and working parameters.

Calculations must account for different working arrangements and situations. A total alone is not enough: anomalies need to be visible, and users need to understand which days contribute to their balances.

How the solution works

An explanation is different from a correction

A missed clock event can be reported, reviewed and corrected. Justifying an anomaly has a different effect from changing a clock record: a justification explains the situation, while a correction changes the calculation input.

The original time-clock exports remain intact. Corrections form a separate layer with an author and a reason, after which results are recalculated. This keeps the origin of a result traceable rather than silently overwriting its history.

Show each user the relevant information

Employees view their own days and balances. Managers follow their assigned scope and handle reports. HR has the imports, settings and exports needed for overall administration.

Dashboards and Excel files provide different views of the same calculation. A local HR console supports the planned processing outside the server. The public demonstration is simplified and uses fictional data only.

Technical choices and their purpose

Calculation independent of presentation

Python handles imports and calculation rules. HTML dashboards and Excel outputs use those results. Business logic therefore goes beyond formatting a spreadsheet.

Access follows roles and scope

The internal web application uses Microsoft 365 for identification and applies permissions on the server. Individual access, team management and HR work have separate scopes.

The operational need

Tracking a team’s working hours involves more than adding numbers. People need to retrieve entered information, apply calculation rules and prepare data for administrative follow-up. The BX1 project brought these uses together in one application.

What the application brings together

Time entry is the starting point. Hour and time balance calculations use that information, which then feeds administrative reports and exports. This creates a continuous workflow between entering information and using the results.

The principle: stop rebuilding the result

Information loses value when someone must copy it or repeat the same calculation at every step. The chosen approach keeps information moving within the application and lets the calculation rules produce the corresponding results.

A concrete, observable result

The application is used by 41 people. It brings time entry, time balances and administrative exports together in one tool, keeping information available throughout the workflow.

From a real need to a usable tool

The business process connects the whole project. Screens, calculations and outputs belong together: entered information should remain understandable all the way to the report. For a new project, we start with your workflows and examples to agree on a defined scope.

Application developed for BX1. Client reference available on request.

Try the principle with fictional data

The public simulation lets you edit a fictional team’s hours and watch totals update. It illustrates the principle without providing access to BX1’s internal application or data. The 30 people in the demo are fictional and do not represent the actual workforce.

Try the time management demo ↗

Discuss your project

Discuss your project ↗