The verdict in three sentences
When a 420-employee plant tracks 2,300 qualifications in shared spreadsheets, the audit always finds gaps: here, 12% were out of date, or 276 cases of someone working without a valid authorisation. A certification tracking app that links each role to required skills, alerts at 90 and 30 days and produces clean exports for the Berufsgenossenschaft fixes the problem at the source. The project takes 3 to 5 months and Kolonell prices it at 2,500,000 to 15,000,000+ FCFA (EUR 3,810 to 22,870+) depending on complexity, with anything else set in the quote.
Why spreadsheets break at 2,300 qualifications
Each qualification follows its own rule under German occupational safety law. The Arbeitsschutzgesetz and DGUV Vorschrift 1 require safety instruction (Unterweisung) at least once a year, documented and signed. Forklift drivers need training and a written authorisation from the employer under DGUV Grundsatz 308-001, first aiders must refresh every 2 years, and electrical work is reserved for qualified electricians or instructed persons under DGUV Vorschrift 3. Add new hires, leavers, role changes and agency workers, and the file is never current.
The consequences are twofold. After an accident, the employer must prove the worker was trained and authorised, or face recourse from the Berufsgenossenschaft. Day to day, refreshers are booked in a rush at external providers instead of being grouped into cheaper in-house sessions.
| Qualification | Basis | Usual validity | What the app checks |
|---|---|---|---|
| Annual safety instruction | ArbSchG section 12, DGUV Vorschrift 1 | 12 months | Signed record per employee and topic |
| Forklift authorisation | DGUV Grundsatz 308-001 | Written authorisation, annual instruction | Training proof, medical fitness, employer signature |
| Electrically instructed person | DGUV Vorschrift 3 | Refresher typically every 1 to 3 years | Level required per role |
| First aider | DGUV Vorschrift 1 | 2 years | 5% to 10% of staff per shift, by area |
| Work at height and harness | DGUV Regel 112-198 | Annual instruction | Roles concerned, PPE inspection |
| Fire safety assistant | ASR A2.2 | Refresher every 3 to 5 years | At least 5% of staff trained |
Features that change the HSE team's day
The core of the app is the role and skill matrix: each workstation lists the qualifications it requires, and each employee assigned to it inherits those requirements automatically. Gaps appear without searching. Alerts go to the training team at 90 days to schedule a session, then to the supervisor and employee at 30 days. Certificates are attached to each record, and an export by employee, area or qualification type is ready in one click for the Berufsgenossenschaft, the insurer or an ISO 45001 audit.
| Criterion | Shared spreadsheet | HR suite training module (2026 order of magnitude) | Kolonell custom app |
|---|---|---|---|
| Cost | Free on paper | EUR 4,000 to 15,000 a year | 2,500,000 to 15,000,000+ FCFA (EUR 3,810 to 22,870+), rest in the quote |
| Role and skill matrix | Manual | Often limited to courses | Native, with rules per area |
| 90 and 30-day alerts | None | Yes, generic | Yes, targeted to employee, supervisor, HSE |
| Agency workers and contractors | Separate file | Rarely covered | Dedicated profiles with limited access |
| Audit export | Manual formatting | Standard report | Custom export, full audit trail |
| Time to go live | Immediate | 1 to 3 months | 3 to 5 months |
| Maintenance | Internal time | Included | 35,000 to 120,000 FCFA a month (EUR 53 to 183) |
An existing HR suite may be enough if the plant has few hazardous roles. Custom work pays off when rules are site-specific: several production areas, three-shift operations, many agency workers and a need to connect with payroll or access control.
Works council and project phasing
In Germany, any system that can monitor employee behaviour or performance requires co-determination by the works council under section 87 of the Works Constitution Act. Involve the Betriebsrat at scoping and plan 1 to 2 months for a works agreement. Phasing then limits risk: the first release imports the spreadsheet history, builds the matrix and switches on alerts, which already delivers about 70% of the value.
| Release | Duration | Content |
|---|---|---|
| Scoping, matrix, works council briefing | 3 weeks | Role inventory, validity rules |
| Import and alerts | 5 weeks | 2,300 records migrated, 90 and 30-day alerts |
| Session planning | 4 weeks | Grouped refreshers, invitations |
| Mobile and agency workers | 3 to 4 weeks | Check at the workstation, external profiles |
| HR integration and testing | 3 to 4 weeks | Headcount sync, user training |
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Lukas, HSE manager at the Berlin plant, spends 6 hours a week updating spreadsheets and 80 hours a year preparing audits, 356 hours in total. At EUR 50 an hour fully loaded, that is EUR 17,800. With the app, this falls to 1.5 hours a week and 16 hours of audit prep, 85 hours or EUR 4,250, a saving of EUR 13,550. Grouping refreshers into in-house sessions saves roughly another EUR 9,000 in external training. With a medium-complexity build at the top of the range, EUR 10,670, plus Standard maintenance of EUR 1,368 a year, first-year net gain is around EUR 10,500 and the investment pays back in about 6 months.
FAQ
Can existing spreadsheet history be imported?
Yes, after cleaning duplicates and date formats. For 2,300 rows, allow 2 to 3 days of migration, with a report of incomplete records to fix.
Can agency workers be tracked?
Yes, through an external profile linked to the agency. Their forklift and safety qualifications are checked before their first shift, which often covers 15% to 25% of the workforce in peak periods.
Does the app replace the employer's written authorisation?
No, the authorisation is still issued and signed by the employer. The app generates a pre-filled document, collects the e-signature and archives the signed version.
What about GDPR and the works council?
Qualification data is personal data and the tool needs a works agreement in most German plants. Plan 1 to 2 months and limit access by role, for example supervisors only see their own team.
What happens during an inspection?
An export by area or employee is ready in under a minute, with each certificate date and the alert history. It shows the company anticipated deadlines rather than reacting to them.
Let's scope your project. We define with you the roles, the qualifications tracked and the HR system links for an app delivered in 3 to 5 months. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
