Relief Applications

FIDH - Automated Timesheet Management System

FIDH tracks staff time across donor-funded human-rights programmes, but the process ran on disconnected Excel files and manual ADP payroll exports: error-prone, with heavy key-person dependency. We hardened and automated the existing Excel environment into a six-workbook system that imports ADP data, blocks outputs until eight validation checks pass and produces donor reports in one click.

Client
FIDH
When
May–Aug 2026
Team
2 people
Services
Info management & MEAL
Technologies
Excel, Power Query, VBA
Industry
Advocacy and Human Rights
SDGs
16. Peace, justice and strong institutions, 17. Partnerships for the goals
Client website
FIDH

FIDH manages a complex portfolio of international human-rights programmes funded by donors including the EU and AFD. Tracking staff time across projects is essential for compliance and reporting, yet the existing system relied on disconnected Excel files and manual ADP payroll exports: error-prone and with heavy key-person dependency.

Rather than replacing the environment, Relief Applications hardened and automated it with a six-layer Excel-native architecture: ADP imports, Power Query transformation, a business-rules layer encoding allocation logic, a processing engine, a validation gate and configurable donor output templates.

The delivered six-workbook system automates ADP import, blocks outputs until an eight-check validation passes, offers one-click reporting, segregates data by office with GDPR-compliant access, and ships with full French documentation and training.

The challenge

  • A fragmented, multi-file manual workflow
  • No systematic validation layer
  • Cross-office data privacy and varied donor formats

What we did

  • A modular six-workbook architecture
  • An automated Power Query import pipeline
  • An eight-check validation gate and configurable donor templates
Automated Timesheet Management System, FIDH: screen 1

More projects