H2020 and Horizon Europe
timesheet template

Some background on timesheets for H2020 or Horizon Europe projects plus a free template for you.

WE have an UPDATEd document! 

Last year we developed a timesheet template to track your team's working hours. After collecting feedback from our latest version, we built a new timesheet for 2022. Today, we're offering our updated version, with new formulae and new structures that will help you to manage your project.

If you are working on a Horizon 2020 or Horizon Europe project, it is a requirement to use timesheets for your team. There are multiple ways to do this (e.g. on paper or electronically). However, you should invest some thinking into a proper process. Request your staff to track their time regularly, ideally on a daily basis and request supervisors to check and countersign the timesheets also on a regular basis (e.g. on a monthly basis).

The Annotated Model Grant Agreement defines in §18 (page 179) six minimal requirements for timesheets:

Time records should include, as a minimum: 

  • the title and number of the action, as specified in the GA 

  • the beneficiary’s full name, as specified in the GA 

  • the full name, date and signature of the person working for the action 

  • the number of hours worked for the action in the period covered by the time record 

  • the supervisor’s full name and signature 

  • a reference to the action tasks or work packages of Annex 1, to which the person has contributed by the reported working hours.

https://ec.europa.eu/research/participants/data/ref/h2020/grants_manual/amga/h2020-amga_en.pdf

The European Commission also provides a template for a timesheet. However, we didn't find it particularly helpful.

Timesheet H2020.png

We, from collaborate.eu, developed a nice and clean timesheet template for 2022 that will help you to record your time. Please note that this is a full time recording template to record not only the time for one specific project but for multiple projects. We also added some formulas to a summary sheet to calculate the total costs for you to cross-check if the costs are inline with your planning and claim expenses annually.

 

Timesheet Template.png