Timesheet Template Horizon Europe

Standard Operating Procedure: Horizon Europe Personnel Time Allocation & Timesheet Architecture

Document ID: SOP-TR-HE-042
Effective Date: October 24, 2023
Version: 3.2.0
Review Cadence: Annual / Post-Audit Cycle
Author: Julian Vance, Chief Architect, Template Registry

---

1. Executive Summary & Purpose

This Standard Operating Procedure (SOP) defines the institutional mandates, architectural design requirements, and operational workflows for managing, logging, and auditing timesheet templates compliant with Horizon Europe (HE) Framework Programme regulations.

Under the European Commission (EC) Annotated Grant Agreement (AGA), personnel costs charged to Horizon Europe actions must be backed by reliable, verifiable time-recording systems. This document establishes the exact execution steps required to maintain audit readiness, eliminate retroactive allocations, and ensure 100% alignment with Article 20 (Record-Keeping) and Article 6 (Eligible Personnel Costs) of the Horizon Europe Model Grant Agreement.

---

2. Scope & Prerequisites

Scope

This procedure applies to all internal personnel, sub-contractors, and third-party contributors charging personnel hours (productive hours) to any Horizon Europe research and innovation action managed or registered via Template Registry frameworks.

Prerequisites & Required Tools

• Time-Tracking Infrastructure: Template Registry HE-Compliant Timesheet Portal (v4.0+) or certified enterprise ERP (SAP, Workday, NetSuite) integrated with daily cryptographic timestamping.
• Access Credentials: Multi-Factor Authentication (MFA) enabled corporate Single Sign-On (SSO).
• Reference Documentation: Horizon Europe Annotated Grant Agreement (AGA), specific project Grant Agreement (GA) data (Work Package structures, Person-Month allocations).
• Personnel Requirements: Mandatory completion of the Template Registry "Horizon Europe Compliance & Audit Defense" training module.

---

3. Roles & Responsibilities

---

4. Step-by-Step Procedure

Phase 1: Initialization & Work Breakdown Structure (WBS) Mapping

• 1.1 Verify that the individual's employment contract and productive hour calculation model (Annual 1,720 hours, Full-Time Equivalent, or Exclusive Assignment) are registered in the HR database.
• 1.2 Import the specific Horizon Europe Grant Agreement Work Packages (WPs) and Task IDs into the user's personal timesheet profile prior to the first day of the reporting period.
• 1.3 Confirm that non-project activities (e.g., general administration, teaching, sick leave, annual leave) are assigned distinct, non-billable categorical codes (e.g., OV-ADMIN, LEAVE-SICK).

Phase 2: Daily/Weekly Time Logging Execution

• 2.1 Access the Template Registry HE Timesheet interface via secure enterprise portal.
• 2.2 Record hours spent on specific project tasks on a daily or weekly basis. Retroactive block-filling at the end of a month/year is strictly prohibited.
• 2.3 Ensure that total hours recorded per day do not exceed statutory maximum working hours defined by national labor law and institutional policy (typically 8–10 hours/day).
• 2.4 Cross-reference logged hours against daily calendar entries, laboratory logbooks, or commit logs (Git/Jira) to maintain an auditable paper trail.

Phase 3: Monthly Validation & Submission

• 3.1 Perform a monthly reconciliation on the final business day of the calendar month, ensuring the sum of productive hours and absence hours equals total available working time.
• 3.2 Submit the completed timesheet template through the workflow engine for supervisory review.
• 3.3 Ensure the Work Package Leader electronically signs and dates the timesheet no later than the 5th working day of the subsequent month.

Phase 4: Archival & Audit Trail Maintenance

• 4.1 System automatically generates a PDF/A export bearing cryptographic hashes (SHA-256) of the submitted timesheet and associated approval logs.
• 4.2 Archive the immutable record in the institutional document repository for a minimum of five (5) years after the final payment of the grant (or three (3) years for low-value grants, per specific GA stipulations).

---

5. Quality Assurance & Pro-Tips

Best Practices

• Real-Time Tracking: Encourage logging hours at the end of each working day. Memory-based estimations completed weeks later are routinely rejected during EC financial audits.
• The 100% Threshold Rule: If an employee is exclusively dedicated to a single Horizon Europe project (100% of productive time), a signed declaration of exclusive assignment can replace monthly timesheets only if supported by institutional processes. However, keeping standard timesheets remains the gold standard to mitigate audit risk.
• Fractional Precision: Log time in decimals (e.g., 1.5 hours) rather than minutes to maintain clean reporting matrices.

Common Pitfalls (Audit Findings)

• Pitfall: Charging estimated, budgeted, or proportional hours rather than actual hours worked.
• Correction: Timesheets must reflect actual time spent on tasks, even if it deviates from the original Annex 1 estimates. Deviations require project management justification, not timesheet fabrication.
• Pitfall: Over-declaration of hours (logging hours on weekends/holidays without formal institutional authorization or overtime frameworks).

Metric Thresholds

• Submission Compliance Rate: $\ge 98%$ of timesheets submitted by the 5th working day post-month-end.
• Audit Traceability Index: 100% match between timesheet entries and secondary verification artifacts (commit logs, lab access logs).

---

6. Frequently Asked Questions (FAQ)

Q1: What happens if an employee forgets to log hours for a specific week and the reporting period has closed?
A: The system locks historical periods on the 5th of the following month. If an omission occurs, the employee must file an "Exception & Retroactive Adjustment Ticket" countersigned by the HR Director and Project Coordinator. This entry is explicitly flagged in the audit logs as a manual override and requires justification documentation.

Q2: Are digital signatures accepted by EC auditors for Horizon Europe timesheets?
A: Yes. The European Commission accepts electronic signatures (advanced or qualified electronic signatures compliant with eIDAS regulation) provided the underlying system logs metadata including IP address, timestamp, user authentication state, and immutable document hashes. Manual "wet-ink" signatures scanned to PDF are also acceptable but carry higher administrative overhead.

Q3: How do we handle personnel working across multiple Horizon Europe projects simultaneously?
A: The timesheet template must enforce a clear compartmentalization by Task and Grant Agreement number. The total sum of hours charged across all projects plus internal/administrative tasks cannot exceed the employee's total contracted working hours for that period. System validations must block submission if total hours exceed 100% of standard capacity.