Excel Sample Sheet 33585

Partial file snippet.

Sheet 1: Introduction

	
	
		

	
	
		Interreg Europe - timesheet templates
	
	
		

	
	
		The Interreg Europe 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 (method 1 or 2 in the programme manual). 
Note: fourth call projects partners can only use the staff costs calculation based on fixed percentages or based the hourly rate (and for which they can use this template). 
 
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 (method 3.a in the programme manual)
- Calculation based on dividing the latest documented annual gross employment costs by 1,720 (method 3.b in the programme manual)
- Calculation based on contracts on an hourly basis (method 4 in the programme manual)
For detailed information, please see the programme manual section 7.2.1.

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.
- 100% of the working time of staff members have to be recorded (unless methods 1 and 2 in the programme manual are used). 
- in case of mistakes in the formulas in the provided timesheets, the programme authorities cannot be held liable.
	



Sheet 2: contract. hours (3a)

	
	
	
	
	
	
		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.
		
	
		
	
		PGI:
		

		
	
		ACRONYM:
		

		
	
		Name of employee:
		

		
	
		Name of partner institution:
		

		
	
		Partner number:
		

		
	
		

		

		

		

		

		

	
	
		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)
		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		

		

	
	
		

		

		

		

		
	
		

		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)
		

		

		

		

		

	
	
		(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) 
		

		

		

		

		

	
	
		(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
		

		

		

		

		

	
	
		(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 Interreg Europe, 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 (3b)

	
	
	
	
	
	
		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.
		
	
		
	
		PGI:
		

		
	
		ACRONYM:
		

		
	
		Name of employee:
		

		
	
		Name of partner institution:
		

		
	
		Partner number:
		

		
	
		

		

		

		

		

		

	
	
		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)
		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		
	
		

		

		

		

		

		

	
	
		

		

		

		

		
	
		

		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):
		

		

		

		

		

	
	
		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 Interreg Europe, 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 interreg europe timesheet templates the programme offers to interested project partners 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 percentages method or in manual fourth call projects only use hourly rate and for they this template file contains three worksheets each dedicated one different methods requiring contractual hours as indicated employment contract a dividing latest documented annual gross b contracts an basis detailed information please see section when using models keep mind free these serve example compulsory case partner organisations their own registration system long comply with rules members have recorded unless mistakes formulas provided authorities cannot held liable monthly format serves content any fill white fields grey should calculated automatically pgi acronym name employee institution number reporting period ddmmyy rounding di...

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.

PGI:
ACRONYM:
Name of employee:
Name of partner institution:
Partner number:

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)
	Hours worked on the project	(number of hours, only)	Description of tasks (for project)
























	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)
(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)**
*(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
(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 Interreg Europe, 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.

PGI:
ACRONYM:
Name of employee:
Name of partner institution:
Partner number:

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)
	Hours worked on the project	(number of hours, only)	Description of tasks (for project)
























	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):
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 Interreg Europe, 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

Related files

Share

Share to social media

Help

Login Area