Employee Timesheet Automation
Python tool automating FFG-compliant time-tracking and documentation — groups entries by project, slices by period, and prepares signature-ready outputs.
Overview
Developed a Python automation tool to handle the recurring and error-prone process of preparing FFG (Austrian Research Promotion Agency) compliant time-tracking documentation.
Problem
FFG-funded projects require detailed time logs grouped by work package and time period, formatted consistently, and prepared for manager signatures. Doing this manually from raw timesheet exports was slow and introduced formatting inconsistencies.
What it does
- Parses raw time-log exports (CSV/Excel)
- Groups entries by project and work package
- Slices logs by arbitrary date ranges (month, quarter, funding period)
- Formats outputs according to FFG documentation requirements
- Generates printable / signature-ready reports
Outcome
Reduced the time spent on monthly documentation from roughly 2–3 hours to under 10 minutes. Eliminated formatting errors that had previously required corrections before submission.
Notes
This is an internal administrative tool. Source code is not publicly available. The project demonstrates practical Python scripting for workflow automation in a compliance context.