With the automated Excel templates developed by BAK-AG Projektmanagement and KoWi, you can calculate eligible Horizon Europe costs in a user-friendly manner and generate lists summarizing employee working hours.
The Excel templates can be easily customised to suit your institution’s individual needs.
Timesheet templates
The public holidays of each federal state are included in the timesheet templates. Time tracking can be done based on hours per day (daily) or hours per month (monthly).
- Timesheet template (daily): https://www.kowi.de/Portaldata/2/Resources/kowi/BAK_Timesheet_HorizonEurope_V.2_Daily.xlsx
- Timesheet template (monthly): https://www.kowi.de/Portaldata/2/Resources/kowi/BAK_Timesheet_HorizonEurope_V.2_Monthly.xlsx
Personnel cost tools
The personnel cost tools allow you to easily display billable daily rates for periodic or annual periods. With version 2.2, you can also switch between German and English.
- BAK-personnel cost tool HEU V.2.2_periodic: https://www.kowi.de/Portaldata/2/Resources/kowi/BAK_personnel_cost_tool_HEU_V.2.2_periodic.xlsx
- BAK-personnel cost tool HEU V.2.2_annual: https://www.kowi.de/Portaldata/2/Resources/kowi/BAK_personnel_cost_tool_HEU_V.2.2_annual.xlsx
- BAK-personnel cost tool_examples_V.2.2_periodic: https://www.kowi.de/Portaldata/2/Resources/kowi/BAK_personnel_cost_tool_examples_V.2.2_periodic.xlsx
- BAK-personnel cost tool_examples_V.2.2_annual: https://www.kowi.de/Portaldata/2/Resources/kowi/BAK_personnel_cost_tool_examples_V.2.2_annual.xlsx
Further information and documents can be found on the homepage of the European Liaison Office of the German Research Organisations (KoWi): https://www.kowi.de/en/kowi/proposal-project/project-implementation-1/reporting/personalkosten-tool/cost-and-reporting-tools.aspx