Case study · Food sector
Attendance review, from 5 days to 1 hour.
For a company with more than 40 employees, Cromo turned Excel timesheets and manual reconciliations into an automated, verifiable monthly process.
- Company
- 40+
- employees in the food sector
- Before
- 5 days
- of work each monthly cycle
- With Cromo
- 1 hour
- including checks
The starting point
The work did not end when the file was read.
Each month, the administration team started with Excel timesheets. To produce usable results, they had to interpret attendance codes, compare expected schedules and the calendar, apply internal rules, and review exceptions.
The information needed for that work lived across files, procedures, and people's knowledge. Manual checks were required, and it was harder to reconstruct how final hours and time-bank balances had been determined.
Process input
A monthly attendance file, together with operating rules and employee, schedule, and time-bank data.
The solution
A process designed around the company's rules.
Cromo brings five parts of the work together. Chat helps configure the process, inspect results, and request corrections; calculation steps remain defined and controllable.
-
Company Brain
Holds the procedures the administration team uses to check attendance, interpret codes, and handle exceptions. The rules become a shared reference for the process.
-
Structured data
The company ontology connects employee records, contract categories, expected schedules, working calendars, holidays, attendance codes, and time-bank balances.
-
Workflow
Designed and configured through chat, it receives the monthly attendance file, interprets the data, and applies the rules to produce daily, weekly, and monthly results.
-
Dashboard
Built through chat, it lets the team inspect results by month and employee, down to daily detail.
-
Corrections and handoff
The administration team can request specific corrections to final hours in chat. Cromo updates related results, keeps a history, and generates an Excel file for administrative review.
In detail
The checks the workflow needs to perform.
The process earns its value from the specific rules applied to each timesheet, beyond extracting data from a file.
Hours worked
- Hours and rounding calculations
- Overtime excluded from the totals
- Night hours highlighted
Codes and calendar
- Vacation, sick leave, and other leave
- Holidays and working calendar
- Comparison with expected schedules
Balances and corrections
- Keeps different hour totals separate
- Applies company-defined thresholds and rules
- Updates results after each correction
The outcome
Results to inspect, corrections to trace.
The automated workflow replaces Excel calculations and manual reconciliations. The team can inspect results, drill into the details, adjust final hours, and trace corrections before the administrative review.
Before
5 days
Excel calculations, reconciliations, and checks repeated in each monthly cycle.
With Cromo
1 hour
Including checks: company knowledge, data, workflow, and dashboard work in one process, through to the final Excel file.
What process would you start with?
Tell us about the work that currently moves between files, people, and systems. We can identify a first process to build in Cromo together.