H2020 timesheet template
Some background on timesheets for H2020 projects plus a free template for you.
WE have an UPDATEd document!
Last year we developed a timesheet template where you could track your team working hours there. After collect feedbacks from our latest version, we built a new timesheet for 2021, you can download it here. Today, we're offering our updated version, with new formulas and new structures that will help you to manage your project.
If you are working on a H2020 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, best on a daily basis. Supervisors should 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.
The European Commission also provides a template for a timesheet. But we found it actually not very helpful.
We, from collaborate.eu, developed a nice and clean timesheet template for 2020 that will help you to record your time. Please note that this is a full time recording template to record not only the time on one specific project. We also added some formulas to a summary sheet to calculate the total costs for you so that you can monitor if the costs are inline with your planning and claim costs in the end.