218x Filetype XLSX File size 0.05 MB Source: www.un-ihe.org
Sheet 1: International Travel
International travel costs specification: | ||||||||
For reporting period: | ||||||||
Activity | 1 | |||||||
Trip description | Period. | Name traveller | Description | Amount in | Exchange | Amount | Supporting receipt | |
local currency | rate | in € | reference nr. | |||||
XXX | date | Prof. Abcde | Air ticket round trip (submit also the broading passes) | € / $ /… | #DIV/0! | |||
Taxi cost airport to hotel | € / $ /… | #DIV/0! | ||||||
Taxi cost hotel to airport | € / $ /… | #DIV/0! | ||||||
Visa | € / $ /… | #DIV/0! | ||||||
XXX | date | Dr. Xyz | Air ticket round trip (submit also the broading passes) | € / $ /… | #DIV/0! | |||
Taxi cost airport to hotel | € / $ /… | #DIV/0! | ||||||
Taxi cost hotel to airport | € / $ /… | #DIV/0! | ||||||
Visa | € / $ /… | #DIV/0! | ||||||
Total | #DIV/0! | |||||||
Activity | 2 | |||||||
Trip description | Period. | Name traveller | Amount DSA | Supporting receipt | ||||
in € | reference nr. | |||||||
XXX | date | Prof. Abcde | Air ticket round trip (submit also the broading passes) | € / $ /… | #DIV/0! | |||
Taxi cost airport to hotel | € / $ /… | #DIV/0! | ||||||
Taxi cost hotel to airport | € / $ /… | #DIV/0! | ||||||
Visa | € / $ /… | #DIV/0! | ||||||
XXX | date | Dr. Xyz | Air ticket round trip (submit also the broading passes) | € / $ /… | #DIV/0! | |||
Train cost airport to hotel | € / $ /… | #DIV/0! | ||||||
Taxi cost hotel to airport | € / $ /… | #DIV/0! | ||||||
Visa | € / $ /… | #DIV/0! | ||||||
Total | #DIV/0! |
Local travel costs specification: | ||||||||
For reporting period: | ||||||||
Activity | 1 | |||||||
Trip description | Period. | Name traveller | Description | Amount in | Exchange | Amount | Supporting receipt | |
local currency | rate | in € | reference nr. | |||||
XXX | date | Prof. Abcde | xxx | € / $ /… | 0.00 | |||
XXX | date | Dr. Xyz | xxx | € / $ /… | 0.00 | |||
Total | 0.00 | |||||||
Activity | 2 | |||||||
Trip description | Period. | Name traveller | Description | Amount in | Exchange | Amount | Supporting receipt | |
local currency | rate | in € | reference nr. | |||||
XXX | date | Dr. Xyz | xxx | € / $ /… | 0.00 | |||
Total | 0.00 |
DSA calculation specification: | ||||||||||||
For reporting period: | 1st January 2017 to 30th June 2017 | |||||||||||
Activity | 1 | |||||||||||
Supporting receipt | ||||||||||||
Trip description | Period. | Name traveller | DSA nights | DSA | Amount DSA | Actual hotel costs | Exchange | Actual hotel costs | Total DSA | reference nr. | ||
Non-room part rate | Non-room part | in hotel bill currency | rate | in € | in € | |||||||
per overnighting in € | in € | |||||||||||
XXX | date | Prof. Abcde | X | #VALUE! | € / $ / … | #DIV/0! | #VALUE! | |||||
XXX | date | Dr. Xyz | X | #VALUE! | € / $ / … | #DIV/0! | #VALUE! | |||||
Total | 0.00 | #VALUE! | ||||||||||
Activity | 2 | |||||||||||
Supporting receipt | ||||||||||||
Trip description | Period. | Name traveller | DSA nights | DSA | Amount DSA | Actual hotel costs | Exchange | Actual hotel costs | Total DSA | reference nr. | ||
Non-room part rate | Non-room part | in hotel bill currency | rate | in € | in € | |||||||
per overnighting in € | in € | |||||||||||
XXX | date | Prof. Abcde | x | #VALUE! | € / $ / … | #DIV/0! | #VALUE! | |||||
XXX | date | Dr. Xyz | x | #VALUE! | € / $ / … | #DIV/0! | #VALUE! | |||||
Total | 0.00 | #VALUE! | ||||||||||
no reviews yet
Please Login to review.