Excel Sample Sheet 33388 | Urbact Timesheets Fs2f

Partial file snippet.

Sheet 1: Introduction

	
	
		
 
	
	
	
		
 
	
	
	
		
	
		
	
		
	
		
	
		The URBACT III programme offers to interested project partners timesheet templates which can be used to record the time worked by the staff working on the implementation of the project. It is important to note that timesheets are not needed if the staff costs calculation can be based on fixed percentages.

This file contains three worksheets, each dedicated to one of the different calculation methods requiring timesheets:
- Calculation based on the contractual hours as indicated in the employment contract
- Calculation based on dividing the latest documented annual gross employment costs by 1,720 (according to Article 68(2) of Regulation (EU) No 1303/2013)
- Calculation based on contracts on an hourly basis

The timesheet shall:
- Be filled in separately for each employee involved in the project;
- Contain information on a monthly basis about the total hours worked by the employee AND
the hours worked specifically for the project;
- State briefly the activities performed within the project (a template can be provided on request
by the Joint Secretariat.);
- In the case of part-time employment for the project: the timesheet must indicate activities
performed outside the project (e.g. “work for another EU financed project”, “statutory tasks”
etc.);
- Be signed by the employee and his/her supervisor.

For detailed information, please see the Programme Manual Factsheet 2F

When using the timesheet models it is important to keep in mind that 
- project partners are free to use these timesheets, they serve as an example only and are not compulsory to use. In case project partner organisations use their own time registration system, they can be used as long as they comply with the programme rules.
- in case of mistakes in the formulas in the provided timesheets, the programme authorities cannot be held liable.

Finally, it is important to remind all partners that costs for project management (staff and external expertise combined) should not normally exceed 40% of the total project budget.



	
	
		
	
		
	
		
	
		
	
		
	
		



Sheet 2: contract. hours

	
	
	
	
	
	
		
 
		
		

		

		

		

	
	
		
 
		
		
	
		MONTHLY TIMESHEET FORMAT (EXAMPLE)
		
	
		This timesheet serves as an example only. The programme authorities cannot be held liable for the content or any mistakes in the formulas. Please fill in white fields, grey fields should be calculated automatically.
		
	
		
	
		Project name:
		

		
	
		Partner name
		

		
	
		Name of employee:
		

		
	
		Name of partner institution:
		

		
	
		

		

		

		

		

		

	
	
		Reporting period:
		DD/MM/YY - DD/MM/YY
		
	
		

		

		

		

		

		

	
	
		A rounding of 2 digits after the decimal point is automatically applied to the figures inserted in this document!
		
	
		Date
		Hours worked on the project
		other activities1
		Description of tasks (for project)
		
	
		(number of hours, only)
		
	
		

		0.00
		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		

		

	
	
		

		

		

		

		
	
		

		Hours worked on project
		

		Hourly rate:
		

		Total EUR:
	
	
		Total 
		0.00
		

		#DIV/0!
		

		#DIV/0!
	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		Signature of Employee
		

		Signature of Employer
		
	
		

		

		

		

		

		

	
	
		Date: 
		

		

		Date:
		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		Calculation of hourly rate
		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		(A) total monthly salary costs (incl. employer's contributions)
		€ 0
		

		

		

		

	
	
		(B) number of working hours per working day according to the employment contract (weekly working hours divided by the number of working days) 
		 -   
		

		

		

		

	
	
		(C) number of workable days in the month in question (any public/bank holidays* are to be substracted) 
		0
		

		

		

		

	
	
		(D) number of workable hours in the month in question (any public/bank holidays* are to be substracted) (B) * (C)
		0.00
		

		

		

		

	
	
		(E) number of annual holidays as per employment contract
		0
		

		

		

		

	
	
		(F) number of monthly holidays (days) as per the employment contract ((E) / 12)
		0.00
		

		

		

		

	
	
		(G) number of monthly holidays (hours) as per the employment contract (F) * (B)
		0.00
		

		

		

		

	
	
		(H) monthly working time, excluding holidays (D-G):
		0.00
		

		

		

		

	
	
		(I) Hourly rate for the month in question:
		#DIV/0!
		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		1If an employee works partly on the project at a flexible percentage (flexible number of hours per month) or on an hourly basis it is necessary to register 100% of the employees working time.

If an employee works on more than one project in URBACT, the project partner is invited to use one single timesheet reflecting all hours worked on the several projects (requires amendments of the model timesheet).
		



Sheet 3: 1720h

	
	
	
	
	
	
		
 
		
		

		

		

		

	
	
		

		
 
		
		
	
		MONTHLY TIMESHEET FORMAT (EXAMPLE)
		
	
		This timesheet serves as an example only. The programme authorities cannot be held liable for the content or any mistakes in the formulas. Please fill in white fields, grey fields should be calculated automatically.
		
	
		
	
		Project name:
		

		
	
		Partner name
		

		
	
		Name of employee:
		

		
	
		Name of partner institution:
		

		
	
		

		

		

		

		

		

	
	
		Reporting period:
		DD/MM/YY - DD/MM/YY
		
	
		

		

		

		

		

		

	
	
		A rounding of 2 digits after the decimal point is automatically applied to the figures inserted in this document!
		
	
		Date
		Hours worked on the project
		other activities1
		Description of tasks (for project)
		
	
		(number of hours, only)
		
	
		

		0.00
		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		

		

	
	
		

		

		

		

		
	
		

		Hours worked on project
		

		Hourly rate:
		

		Total EUR:
	
	
		Total 
		0.00
		

		EUR 0.00
		

		0.00
	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		Signature of Employee
		

		Signature of Employer
		
	
		

		

		

		

		

		

	
	
		Date: 
		

		

		Date:
		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		Calculation of hourly rate
		

		

		

		

		

	
	
		Employee's latest documented annual salary cost (incl. employer's contributions):
		0.00
		

		

		

		

	
	
		Annual hours worked:
		1,720.00
		

		

		

	
	
		Hourly rate:
		0.00
		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		1If an employee works partly on the project at a flexible percentage (flexible number of hours per month) or on an hourly basis it is necessary to register 100% of the employees working time.

If an employee works on more than one project in URBACT, the project partner is invited to use one single timesheet reflecting all hours worked on the several projects (requires amendments of the model timesheet).

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet introduction the urbact iii programme offers to interested project partners timesheet templates which can be used record time worked by staff working on implementation of it is important note that timesheets are not needed if costs calculation based fixed percentagesthis file contains three worksheets each dedicated one different methods requiring contractual hours as indicated in employment contract dividing latest documented annual gross according article regulation eu no contracts an hourly basisthe shall filled separately for employee involved contain information a monthly basis about total andthe specifically state briefly activities performed within template provided requestby joint secretariat case parttime must indicate activitiesperformed outside eg ldquo work another financed rdquo statutory tasks etc signed and hisher supervisorfor detailed please see manual factsheet fwhen using models keep mind free use these they serve example only compulsory partner organisations t...



MONTHLY TIMESHEET FORMAT (EXAMPLE)
This timesheet serves as an example only. The programme authorities cannot be held liable for the content or any mistakes in the formulas. Please fill in white fields, grey fields should be calculated automatically.

Project name:
Partner name
Name of employee:
Name of partner institution:

Reporting period:	DD/MM/YY - DD/MM/YY

*A rounding of 2 digits after the decimal point is automatically applied to the figures inserted in this document!*
Date	Hours worked on the project	other activities1	Description of tasks (for project)
Date	Hours worked on the project	(number of hours, only)	Description of tasks (for project)
	0.00























	Hours worked on project		Hourly rate:	Total EUR:
Total	0.00		#DIV/0!	#DIV/0!




Signature of Employee			Signature of Employer

Date:			Date:




*Calculation of hourly rate*

(A) total monthly salary costs (incl. employer's contributions)	€ 0
(B) number of working hours per working day according to the employment contract (weekly working hours divided by the number of working days)	-
*(C) number of workable days in the month in question (any public/bank holidays are to be substracted)**	0
*(D) number of workable hours in the month in question (any public/bank holidays are to be substracted) (B) * (C)**	0.00
(E) number of annual holidays as per employment contract	0
(F) number of monthly holidays (days) as per the employment contract ((E) / 12)	0.00
*(G) number of monthly holidays (hours) as per the employment contract (F) (B)**	0.00
(H) monthly working time, excluding holidays (D-G):	0.00
(I) Hourly rate for the month in question:	#DIV/0!




1If an employee works partly on the project at a flexible percentage (flexible number of hours per month) or on an hourly basis it is necessary to register 100% of the employees working time. If an employee works on more than one project in URBACT, the project partner is invited to use one single timesheet reflecting all hours worked on the several projects (requires amendments of the model timesheet).



MONTHLY TIMESHEET FORMAT (EXAMPLE)
This timesheet serves as an example only. The programme authorities cannot be held liable for the content or any mistakes in the formulas. Please fill in white fields, grey fields should be calculated automatically.

Project name:
Partner name
Name of employee:
Name of partner institution:

Reporting period:	DD/MM/YY - DD/MM/YY

*A rounding of 2 digits after the decimal point is automatically applied to the figures inserted in this document!*
Date	Hours worked on the project	other activities1	Description of tasks (for project)
Date	Hours worked on the project	(number of hours, only)	Description of tasks (for project)
	0.00























	Hours worked on project		Hourly rate:	Total EUR:
Total	0.00		EUR 0.00	0.00




Signature of Employee			Signature of Employer

Date:			Date:




*Calculation of hourly rate*
Employee's latest documented annual salary cost (incl. employer's contributions):	0.00
Annual hours worked:	1,720.00
Hourly rate:	0.00




1If an employee works partly on the project at a flexible percentage (flexible number of hours per month) or on an hourly basis it is necessary to register 100% of the employees working time. If an employee works on more than one project in URBACT, the project partner is invited to use one single timesheet reflecting all hours worked on the several projects (requires amendments of the model timesheet).

Related files

Share

Help







The URBACT III programme offers to interested project partners timesheet templates which can be used to record the time worked by the staff working on the implementation of the project. It is important to note that timesheets are not needed if the staff costs calculation can be based on fixed percentages. This file contains three worksheets, each dedicated to one of the different calculation methods requiring timesheets: - Calculation based on the contractual hours as indicated in the employment contract - Calculation based on dividing the latest documented annual gross employment costs by 1,720 (according to Article 68(2) of Regulation (EU) No 1303/2013) - Calculation based on contracts on an hourly basis The timesheet shall: - Be filled in separately for each employee involved in the project; - Contain information on a monthly basis about the total hours worked by the employee AND the hours worked specifically for the project; - State briefly the activities performed within the project (a template can be provided on request by the Joint Secretariat.); - In the case of part-time employment for the project: the timesheet must indicate activities performed outside the project (e.g. “work for another EU financed project”, “statutory tasks” etc.); - Be signed by the employee and his/her supervisor. For detailed information, please see the Programme Manual Factsheet 2F When using the timesheet models it is important to keep in mind that - project partners are free to use these timesheets, they serve as an example only and are not compulsory to use. In case project partner organisations use their own time registration system, they can be used as long as they comply with the programme rules. - in case of mistakes in the formulas in the provided timesheets, the programme authorities cannot be held liable. Finally, it is important to remind all partners that costs for project management (staff and external expertise combined) should not normally exceed 40% of the total project budget.

Related files

Share

Share to social media

Help

Login Area