{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["template","lump sum"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"template","index":0,"n_rows":98,"n_cols":14,"rows_kept":98,"merged":[[5,4,5,8],[7,4,7,8],[9,4,9,8],[11,4,11,8],[13,4,13,8],[55,4,55,6],[56,4,56,6],[57,4,57,6],[58,4,58,6],[59,4,59,6],[60,4,60,6],[61,4,61,6],[62,4,62,6],[63,4,63,6],[64,4,64,6],[65,4,65,6],[66,4,66,6]]}
[]
[null,null,"Travel-No:","0000",null,"Please, fill out only the boxes indicated in green!"]
[{"$nulls":13},"Excel-file status as of: 1/1/2025"]
[null,{"$f":"\"Travel-expenses-accounting - invoice number \"&D2","v":"Travel-expenses-accounting - invoice number 0000"}]
[]
[null,"Name",{"$nulls":8},"starting date"]
[]
[null,"Client/Project",{"$nulls":8},"end date"]
[{"$nulls":10},"corresponds invoice date"]
[null,"Destination",null,"country:","Germany"]
[]
[{"$nulls":3},"city:"]
[]
[null,"Purpose of trip"]
[]
[]
[null,"1. Travel costs / reimbursement based on kilometre-allowances",{"$nulls":11},"Euro"]
[]
[null,null,"to kilometre-allowances",null,"distance travelled (without decimals)",null,null,"km",null,"x  Euro",{"v":0.3,"d":"0.30"},null,"=",{"$f":"G19*K19","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[{"$nulls":4},"car's license plate"]
[{"$nulls":12},"subtotal",{"$f":"N19+N21","v":{"v":0,"d":"0.00"}}]
[]
[null,"2. Accomodation without receipts / reimbursement based on lump sum"]
[]
[null,null,"to lump sum",null,null,"number of nights",null,null,"x",{"$f":"VLOOKUP($E$10,'lump sum'!$B$1:$E$225,4,FALSE)","v":{"v":20,"d":"20.00"}},null,null,"=",{"$f":"G28*J28","v":{"v":0,"d":"0.00"}}]
[null,null,"(only for employees, not for sole proprietorship)"]
[]
[{"$nulls":12},"subtotal",{"$f":"N28","v":{"v":0,"d":"0.00"}}]
[]
[null,"3. Daily allowances",{"$nulls":6},"Euro"]
[]
[null,null,">8 hours absent",null,null,"number of days",null,"x",{"$f":"VLOOKUP($E$10,'lump sum'!$B$1:$E$225,3,FALSE)","v":{"v":14,"d":"14.00"}},{"$nulls":3},"=",{"$f":"E35*I35","v":{"v":0,"d":"0.00"}}]
[null,null,"24 hours absent",null,null,"number of days",null,"x",{"$f":"VLOOKUP($E$10,'lump sum'!$B$1:$E$225,2,FALSE)","v":{"v":28,"d":"28.00"}},{"$nulls":3},"=",{"$f":"E36*I36","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"\"(For several day trips with an overnight stay it is allowed to deduct daily allowances of \"&I35&\" Euros for \"","v":"(For several day trips with an overnight stay it is allowed to deduct daily allowances of 14 Euros for "}]
[null,null,"arrival and departure day irrespective of the knowledge of the number of hours being absent.)",{"$nulls":9},"subtotal",{"$f":"SUM(N35:N36)","v":{"v":0,"d":"0.00"}}]
[]
[null,"4. Meals paid by employer"]
[{"$nulls":8},"Euro"]
[null,null,"minus breakfast meals paid by employer"]
[{"$nulls":5},"number",null,"x",{"$f":"I36*0.2","v":{"v":5.6000000000000005,"d":"5.60"}},{"$nulls":3},"=",{"$f":"-E43*I43","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"minus lunch meals paid by employer"]
[{"$nulls":5},"number",null,"x",{"$f":"I36*0.4","v":{"v":11.200000000000001,"d":"11.20"}},{"$nulls":3},"=",{"$f":"-E46*I46","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"minus dinner meals paid by employer"]
[{"$nulls":5},"number",null,"x",{"$f":"I36*0.4","v":{"v":11.200000000000001,"d":"11.20"}},{"$nulls":3},"=",{"$f":"-E49*I49","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":12},"subtotal",{"$f":"MIN(N43+N46+N49,0)","v":{"v":0,"d":"0.00"}}]
[]
[null,"5. Other travel costs substantiated by receipts and paid by employee"]
[null,null,"(all receipts should be stapled on the travel-expenses-accounting)"]
[{"$nulls":9},"amount invoiced incl. VAT (gross)","VAT-%","MWSt"]
[null,null,"receipts",{"$nulls":7},{"v":0.19,"d":"19%"},{"$f":"J56*(1-1/(1+K56))","v":{"v":0,"d":"0.00"}},null,{"$f":"J56","v":{"v":0,"d":"0.00"}}]
[null,null,"(all figures in Euro)",{"$nulls":7},{"v":0.19,"d":"19%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"v":0.19,"d":"19%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"v":0.19,"d":"19%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"v":0.07,"d":"7%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"v":0.07,"d":"7%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"v":0.07,"d":"7%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"v":0.07,"d":"7%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"v":0,"d":"0%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"v":0,"d":"0%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"v":0,"d":"0%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":10},{"v":0,"d":"0%"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[]
[{"$nulls":12},"subtotal",{"$f":"SUM(N56:N67)","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":6},"included"]
[{"$nulls":5},"gross amount","VAT",null,null,"Total amount before deductions",null,null,"=",{"$f":"N24+N31+N38+N51+N69","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},{"v":0.19,"d":"19%"},{"$f":"G73/E73*(1+E73)","v":{"v":0,"d":"0.00"}},{"$f":"SUMIF($K$16:$K$69,$E73,$L$16:$L$69)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},{"v":0.07,"d":"7%"},{"$f":"G74/E74*(1+E74)","v":{"v":0,"d":"0.00"}},{"$f":"SUMIF($K$16:$K$69,$E74,$L$16:$L$69)","v":{"v":0,"d":"0.00"}},null,null,"Other deductions"]
[{"$nulls":4},{"v":0,"d":"0%"},{"$f":"F76-F74-F73","v":{"v":0,"d":"0.00"}},"-"]
[null,null,"Total",null,null,{"$f":"N72","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G73:G75)","v":{"v":0,"d":"0.00"}},{"$nulls":3},"Total amount",null,"=",{"$f":"N72+N74","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":12},"Lohnart"]
[{"$nulls":3},"Bei Auszahlung über Lohn:","Verpflegungsmehraufwendungen",{"$nulls":4},{"$f":"$N$38","v":{"v":0,"d":"0.00 EUR"}},null,"Lohnart:",9650]
[{"$nulls":4},"Kürzung Mahlzeiten",{"$nulls":4},{"$f":"$N$51","v":{"v":0,"d":"0.00 EUR"}},null,"Lohnart:",9670]
[{"$nulls":4},"Übernachtungspauschale (Auslösung)",{"$nulls":4},{"$f":"$N$31","v":{"v":0,"d":"0.00 EUR"}},null,"Lohnart:",9680]
[{"$nulls":4},"Sonstige Reisekosten (inkl. km-Pauschale)",{"$nulls":4},{"$f":"$N$24+$N$69","v":{"v":0,"d":"0.00 EUR"}},null,"Lohnart:","9030"]
[{"$nulls":4},"Gesamtsumme",{"$nulls":4},{"$f":"SUM(J80:J83)","v":{"v":0,"d":"0.00 EUR"}}]
[]
[{"$nulls":3},"Keine Auszahlung über Lohn:","Verpflegungsmehraufwendungen",{"$nulls":4},{"$f":"$N$38","v":{"v":0,"d":"0.00 EUR"}},null,"Lohnart:",9660,"(Statistiklohn)"]
{"$rows_empty":7}
[{"$nulls":4},0]
[null,null,"ja",null,1]
[null,null,"nein",null,2]
[{"$nulls":4},3]
[{"$nulls":4},4]

{"sheet":"lump sum","index":1,"n_rows":225,"n_cols":5,"rows_kept":225}
[null,"Germany",28,14,20]
[null,"Afganistan",30,20,95]
[null,"Albania",27,18,112]
[null,"Algeria",47,32,120]
[null,"Andorra",41,28,91]
[null,"Angola",40,27,368]
[null,"Argentina",35,24,113]
[null,"Armenia",29,20,107]
[null,"Australia (Canberra)",74,49,186]
[null,"Australia (Sydney)",57,38,173]
[null,"Australia (other)",57,38,173]
[null,"Austria",50,33,117]
[null,"Azerbaijan",44,29,88]
[null,"Bahrain",48,32,153]
[null,"Bangladesh",46,31,189]
[null,"Barbados",54,36,206]
[null,"Belarus",20,13,98]
[null,"Belgium",59,40,141]
[null,"Benin",40,27,168]
[null,"Bhutan",27,18,176]
[null,"Bolivia",46,31,108]
[null,"Bosnia + Herzegovina",23,16,75]
[null,"Botswana",46,31,176]
[null,"Brasilia (Brasilia)",51,34,88]
[null,"Brasilia (Rio de Janeiro)",69,46,140]
[null,"Brasilia (Sao Paulo)",46,31,151]
[null,"Brasilia (other)",46,31,88]
[null,"Brunei",45,30,110]
[null,"Bulgaria",22,15,115]
[null,"Burkina Faso",38,25,174]
[null,"Burundi",36,24,138]
[null,"Cambodia",42,28,108]
[null,"Cameroon",56,37,275]
[null,"Canada (Ottawa)",62,41,214]
[null,"Canada (Toronto)",54,36,392]
[null,"Canada (Vancouver)",63,42,304]
[null,"Canada (other)",54,36,214]
[null,"Cape Verde",38,25,90]
[null,"Central African Republic",53,36,210]
[null,"Chad",42,28,155]
[null,"Chile",44,29,154]
[null,"China (Chengdu)",41,28,131]
[null,"China (Hongkong)",71,48,169]
[null,"China (Kanton)",36,24,150]
[null,"China (Peking)",30,20,185]
[null,"China (Shanghai)",58,39,217]
[null,"China (other)",48,32,112]
[null,"Columbia",34,23,123]
[null,"Congo (Democratic Republic)",65,44,337]
[null,"Congo (Republic)",62,41,215]
[null,"Costa Rica",60,40,127]
[null,"Côte d’Ivoire",59,40,166]
[null,"Croatia",46,31,191]
[null,"Cuba",51,34,170]
[null,"Cyprus",42,28,125]
[null,"Czech Republic",32,21,77]
[null,"Denmark",75,50,183]
[null,"Djibouti",77,52,255]
[null,"Dominican Republic",50,33,167]
[null,"Ecuador",44,29,97]
[null,"Egypt",50,33,112]
[null,"El Salvador",65,44,161]
[null,"Equatorial Guinea",42,28,166]
[null,"Eritrea",46,31,78]
[null,"Estonia",29,20,85]
[null,"Ethiopia",44,29,159]
[null,"Fiji",32,21,183]
[null,"Finland",54,36,171]
[null,"France (Paris)",58,39,159]
[null,"France (other)",53,36,105]
[null,"Gabon",64,43,263]
[null,"Gambia",40,27,161]
[null,"Georgia",45,30,87]
[null,"Ghana",46,31,203]
[null,"Great Britain (London)",66,44,163]
[null,"Great Britain (other)",52,35,99]
[null,"Greece (Athens)",40,27,139]
[null,"Greece (other)",36,24,150]
[null,"Guatemala",46,31,124]
[null,"Guinea",59,40,140]
[null,"Guinea-Bissau",32,21,113]
[null,"Haiti",58,39,130]
[null,"Honduras",57,38,198]
[null,"Hungary",32,21,85]
[null,"Iceland",62,41,187]
[null,"India (Bangalore)",42,28,155]
[null,"India (Chennai)",22,15,80]
[null,"India (Kolkata)",32,21,167]
[null,"India (Mumbai)",53,36,218]
[null,"India (New Delhi)",46,31,211]
[null,"India (other)",22,15,80]
[null,"Indonesia",45,30,179]
[null,"Iran",33,22,196]
[null,"Ireland",58,39,129]
[null,"Israel",66,44,190]
[null,"Italy (Milan)",42,28,191]
[null,"Italy (Rome)",48,32,150]
[null,"Italy (other)",42,28,150]
[null,"Jamaica",39,26,171]
[null,"Japan (Tokyo)",50,33,285]
[null,"Japan (Osaka)",33,22,141]
[null,"Japan (other)",33,22,141]
[null,"Jemen",24,16,95]
[null,"Jordan",57,38,134]
[null,"Kazakhstan",33,22,108]
[null,"Kenya",51,34,219]
[null,"Korea (Democratic People's Republic)",28,19,92]
[null,"Korea (Republic)",48,32,108]
[null,"Kosovo",24,16,71]
[null,"Kuwait",56,37,241]
[null,"Kyrgyzstan",27,18,74]
[null,"Laos",35,24,71]
[null,"Latvia",35,24,76]
[null,"Lebanon",69,46,146]
[null,"Lesotho",28,19,104]
[null,"Liberia",65,44,173]
[null,"Libya",63,42,135]
[null,"Liechtenstein",56,37,190]
[null,"Lithuania",26,17,109]
[null,"Luxemburg",63,42,139]
[null,"Madagascar",33,22,116]
[null,"Malawi",41,28,109]
[null,"Malaysia",36,24,86]
[null,"Maledives",70,47,200]
[null,"Mali",38,25,120]
[null,"Malta",46,31,114]
[null,"Marshall Islands",63,42,102]
[null,"Mauretania",35,24,86]
[null,"Mauritius",44,29,172]
[null,"Mexico",48,32,177]
[null,"Moldavia",26,17,73]
[null,"Monaco",52,35,187]
[null,"Mongolia",23,16,92]
[null,"Montenegro",32,21,85]
[null,"Morocco",41,28,87]
[null,"Mosambique",51,34,208]
[null,"Myanmar",23,16,103]
[null,"Namibia",30,20,112]
[null,"Nepal",36,24,126]
[null,"Netherlands",47,32,122]
[null,"New Zealand",58,39,148]
[null,"Nicaragua",46,31,105]
[null,"Niger",42,28,131]
[null,"Nigeria",46,31,182]
[null,"North Macedonia",27,18,89]
[null,"Norway",75,50,139]
[null,"Oman",64,43,141]
[null,"Pakistan (Islamabad)",23,16,238]
[null,"Pakistan (other)",34,23,122]
[null,"Palau",51,34,193]
[null,"Panama",41,28,82]
[null,"Papua-New Guinea",59,40,159]
[null,"Paraguay",39,26,124]
[null,"Peru",34,23,143]
[null,"Philippines",41,28,140]
[null,"Poland (Breslau/Wroclaw)",34,23,124]
[null,"Poland (Warsaw)",40,27,143]
[null,"Poland (other)",34,23,124]
[null,"Portugal",32,21,111]
[null,"Qatar",56,37,149]
[null,"Romania (Bucharest)",32,21,92]
[null,"Romania (other)",27,18,89]
[null,"Russia (Moscow)",30,20,235]
[null,"Russia (St. Petersburg)",28,19,133]
[null,"Russia (other)",28,19,133]
[null,"Rwanda",44,29,117]
[null,"Samoa",39,26,105]
[null,"San Marino",34,23,79]
[null,"São Tomé (Príncipe)",36,24,147]
[null,"Saudi-Arabia (Djidda)",57,38,181]
[null,"Saudi-Arabia (Riad)",56,37,186]
[null,"Saudi-Arabia (other)",56,37,181]
[null,"Senegal",42,28,190]
[null,"Serbia",27,18,97]
[null,"Sierra Leone",57,38,145]
[null,"Singapore",71,48,277]
[null,"Slovak Republic",33,22,121]
[null,"Slovenia",38,25,126]
[null,"South Africa (Cape Town)",33,22,130]
[null,"South Africa (Johannisburg)",36,24,129]
[null,"South Africa (other)",29,20,109]
[null,"Southern Sudan",51,34,159]
[null,"Spain (Barcelona)",34,23,144]
[null,"Spain (Canary Islands)",36,24,103]
[null,"Spain (Madrid)",42,28,131]
[null,"Spain (Palma de Mallorca)",44,29,142]
[null,"Spain (other)",34,23,103]
[null,"Sri Lanka",36,24,112]
[null,"Sudan",33,22,195]
[null,"Sweden",50,33,168]
[null,"Switzerland (Geneva)",66,44,186]
[null,"Switzerland (other)",64,43,180]
[null,"Syria",38,25,140]
[null,"Tadzhikistan",27,18,85]
[null,"Taiwan",51,34,174]
[null,"Tanzania",44,29,97]
[null,"Thailand",36,24,114]
[null,"Togo",39,26,118]
[null,"Tonga",29,20,102]
[null,"Trinidad + Tobago",66,44,203]
[null,"Tunisia",40,27,144]
[null,"Turkey (Ankara)",32,21,110]
[null,"Turkey (Izmir)",44,29,120]
[null,"Turkey (other)",24,16,107]
[null,"Turkmenistan",28,19,135]
[null,"Uganda",41,28,143]
[null,"Ukraine",26,17,98]
[null,"United Arab Emirates",65,44,156]
[null,"Uruguay",40,27,113]
[null,"USA (Atlanta)",77,52,182]
[null,"USA (Boston)",63,42,333]
[null,"USA (Chicago)",65,44,233]
[null,"USA (Houston)",62,41,204]
[null,"USA (Los Angeles)",64,43,262]
[null,"USA (Miami)",65,44,256]
[null,"USA (New York City)",66,44,308]
[null,"USA (San Francisco)",59,40,327]
[null,"USA (Washington D.C.)",66,44,203]
[null,"USA (other)",59,40,182]
[null,"Uzbekistan",34,23,104]
[null,"Vatican",48,32,150]
[null,"Venezuela",45,30,127]
[null,"Vietnam",36,24,111]
[null,"Zambia",38,25,105]
[null,"Zimbabwe",63,42,198]