{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Info","Formular","Erklärung","Tax Declaration","Länderschlüssel"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Info","index":0,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[[6,2,6,8],[7,2,7,8],[8,2,8,8],[9,2,9,8],[10,2,10,8],[1,2,1,8],[2,2,2,8],[3,2,3,8],[4,2,4,8],[5,2,5,8],[29,0,30,0],[42,0,43,0],[40,0,41,0],[46,2,46,8],[45,2,45,8],[37,2,37,8],[29,2,30,8],[16,2,16,8],[19,2,19,8],[40,2,41,8],[42,2,43,8],[12,2,12,8],[13,2,13,8],[14,2,14,8],[15,2,15,8],[20,2,20,8],[21,2,21,8],[17,2,17,8],[22,2,22,8]]}
[]
["Erstattung von Auslagen",null,"Reimbursement of expenses "]
["1.       Allgemeine Informationen",null,"1.       General Information"]
["Eine Erstattung von Auslagen ist nur möglich, wenn Folgendes beachtet wird:",null,"Reimbursement of expenses is only possible if the following is observed:"]
["·       Einreichen der Originalrechnung (auch für Reise-Tickets, z. B. DB, LH etc.)",null,"·       Submit the original invoice (also for travel tickets, e.g. DB, LH etc.)"]
["·       wichtig ist die Steuerangabe – TUM ist auch bei Auslagenerstattungen verpflichtet, Steuern in Deutschland korrekt abzuführen",null,"·       The tax information is important - TUM is also obliged to pay taxes correctly in Germany when reimbursing expenses"]
["·       Einreichen von Zahlungsnachweisen (Kopie der Kreditkartenabrechnung oder des Kontoauszugs)",null,"·       Submit proof of payment (copy of credit card statement or bank statement)"]
["·       ggf. Begründung, warum kein Kauf auf Rechnung möglich war",null,"·       If applicable, justification as to why purchase on account was not possible"]
["·       Rechnung muss auf TUM ausgestellt sein, nicht auf eine Privatperson",null,"·       Invoice must be issued to TUM, not to a private individual"]
["·       Erstattung kann erst nach Lieferung der Waren oder erbrachten Leistung erfolgen (hierfür zeichnet die Unterschrift bei „sachlich richtig“)",null,"·       Reimbursement can only be made after the goods have been delivered or the service has been rendered (signature under ‘factually correct’)"]
["·       Beachtung der Beschaffungsrichtlinien der TUM – siehe ",null,"·       Compliance with the TUM procurement guidelines – see "]
["https://portal.mytum.de/kompass/index/kompass/rechtsicherheitswesen_intranet/ausschreibung",null,"https://portal.mytum.de/kompass/index/kompass/rechtsicherheitswesen_intranet/ausschreibung"]
["·       Bei Barauslagen muss der Originalkassenzettel beigefügt werden.",null,"·       In the case of cash expenses, the original receipt must be enclosed."]
[]
["2.       Ausländische Rechnungen",null,"2.       Foreign Invoices"]
["Aus der Rechnung muss ersichtlich sein, aus welchem Land die Ware oder Dienstleistung kommt und ob bereits Steuern bezahlt wurden. Grundsätzlich müssen bei allen Bestellungen/Käufen im Ausland die Umsatzsteuernummer der TUM DE 811193231 angegeben werden. Es werden dann von den ausländischen Lieferanten Rechnungen ohne Umsatzsteuer ausgestellt. Dadurch wird eine unnötige Abfuhr der Steuer im Ausland vermieden.",null,"The invoice must indicate the country from which the goods or services originate and whether taxes have already been paid. In principle, the VAT number of TUM DE 811193231 must be stated for all orders/purchases abroad. Foreign suppliers will then issue invoices without VAT. This avoids unnecessary payment of tax abroad."]
["Bei Auslagen in Fremdwährung wird eine Kopie der Kreditkartenabrechnung oder des Kontoauszugs benötigt, \num den korrekten Eurobetrag erstatten zu können. Andernfalls wird eine tagesgenaue Umrechnung in EUR vorgenommen – siehe ",null,"For expenses in foreign currency, a copy of the credit card statement or bank statement is required in order to be able to reimburse the correct euro amount. Otherwise, the amount will be converted into EUR on a daily basis – see "]
["https://www.oanda.com/currency-converter/de/?from=EUR&to=USD&amount=1",null,"https://www.oanda.com/currency-converter/de/?from=EUR&to=USD&amount=1"]
[]
["Unterlagen bitte s/w und doppelseitig kopieren, insgesamt Papier sparen – Danke.",null,"Please copy documents in b/w and double-sided to save paper – thank you."]
["Belege aus Thermopapier müssen kopiert werden, weil die Schrift verblasst (danach aufkleben).",null,"Thermal paper receipts must be copied because the writing fades (then stick them on)."]
[]
["Externe Person (kein TUM-Arbeitnehmer) ",null,"Externe Person (Englische Version)"]
[]
["Eine Pflicht zum Ausfüllen des Formulars \"Erklärung zum Steuergeheimnis\" besteht für:",null,"The form \"Declaration on tax confidentiality\" must be filled out by:"]
[" -> natürliche Personen",null," -> natural persons"]
[" -> ohne hauptberufliche unternehmerische Tätigkeit",null," -> without full-time business activity"]
[" -> ohne Dienstverhältnis mit der TUM ",null," -> without an employment relationship with TUM"]
[" -> zusammenhängendem Aufenthalt > 6 Monate in Deutschland",null," - >continuous stay > 6 months in Germany"]
["Das Formular muss nur einmalig ausgefüllt und eingereicht werden.\nBei Änderungen bitte neu einreichen (klick unten).",null,"The form only needs to be filled out and submitted once. If there are any changes, please resubmit (click below)."]
[]
[]
["Pflicht zum Ausfüllen der \"Tax Declaration\" liegt vor für:",null,"The obligation to complete the \"Tax declaration\" applies to:"]
[" -> natürliche Personen",null," -> natural persons"]
[" -> ohne Dienstverhältnis mit der TUM",null," -> without an employment relationship with TUM"]
["\n -> mit Wohnsitz im Ausland",null," -> with residence abroad"]
[]
["Informationen zur Währung",null,"Currency Info"]
[]
["Der Betrag muss in EUR angegeben werden!",null,"The amount must be stated in EUR!"]
["Bitte reichen Sie Kontoauszüge und/oder Kreditkartenabrechnungen mit ein, die die abgebuchten Beträge belegen. ",null,"Please submit bank statements and/or credit card statements showing the amounts debited. "]
[]
["Sofern keine Auszüge vorliegen, müssen die EUR-Beträge über OANDA ermittelt werden (bitte Ausdruck beilegen). Der Tag der Zahlung dient als Grundlage für die Erstattung. ",null,"If no statements are available, the EUR amounts must be determined via OANDA (please enclose a printout). The day of payment serves as the basis for the refund."]
[]
[]
["OANDA Kurse: / OANDA Courses:",null,"OANDA Kurse: / OANDA Courses:"]
["https://www.oanda.com/currency-converter/de/?from=EUR&to=USD&amount=1",null,"https://www.oanda.com/currency-converter/de/?from=EUR&to=USD&amount=1"]

{"sheet":"Formular","index":1,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[13,10,14,14],[37,3,37,4],[39,3,39,4],[41,3,41,4],[37,5,37,6],[39,5,39,6],[41,5,41,6],[29,4,29,7],[6,1,6,7],[33,3,33,4],[33,5,33,6],[35,3,35,4],[35,5,35,6],[16,1,16,3],[18,1,18,3],[18,4,18,7],[8,4,8,6],[9,4,9,6],[10,4,10,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[2,10,3,17],[30,1,30,2],[30,4,30,7],[21,3,21,7],[23,3,23,7],[24,3,24,7],[25,3,25,7],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[26,3,26,5],[22,3,22,6],[29,1,29,2]]}
[]
[null,"Antrag auf KOSTENERSTATTUNG privat verauslagter Beträge für die",null,null,null,null,null,null,null,null,"Bitte Makros aktivieren / Please enable macros"]
[null,"Application for REIMBURSEMENT of private expenses for the",null,null,null,null,null,null,null,null,"Wenn Sie keine Makros aktivieren können, können Sie das Formular trotzdem verwenden. Alle Informationen zum Ausfüllen des Formulars finden Sie im Blatt „Info“."]
[]
[null,"TUM School of Social Sciences and Technology"]
[null,null,null,null,null,null,null,null,null,null,"Version 1.0.4"]
[null,"Originalbelege sind beigefügt.\nOriginal receipts are enclosed."]
[]
[null,"Nr.\nNo.","Belegdatum \nDocument Date","Firma\nCompany","Bezeichnung der Auslage\nDescription of Expenses",null,null,"Betrag €\nAmount €"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"😊 Makros by K. Malá, 2024, finance@sot.tum.de"]
[]
[]
[null,null,null,null,"Gesamtbetrag / Total Amount",null,null,{"$f":"SUM(H10:H16)","v":0}]
[]
[null,"Anmerkung, Begründung, Projektname o.ä.\nNote, reason/, project name or similar"]
[]
[]
[null,"Name, Vorname:\nName, First Name:"]
[null,"Privatanschrift:\nPrivate Address:",null,null,null,null,null,"Germany"]
[null,"Kreditinstitut:\nFinancial Institution:"]
[null,"IBAN:"]
[null,"BIC / SWIFT-Code:"]
[null,"Kontoinhaber*in:\nAccount Holder:"]
[]
[]
[null,{"$f":"TODAY()","v":"2024-11-14"}]
[null,"  Datum / Date",null,null,"Unterschrift / Signature"]
[]
[null,null,null,"Kostenstelle",null,"Auftrag/Fonds"]
[]
[null,null,null,"Sachkonto",null,"Kapitel/Titel"]
[]
[null,null,null,"Inventar-Nr.",null,"Beleg-Nr."]
[]
[null,null,null,"rechnerisch richtig","Datum","Betrag €"]
[]
[null,null,null,"sachlich richtig","Datum","Anordnungsbefugte/r"]

{"sheet":"Erklärung","index":2,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[7,10,8,12],[10,0,10,7],[11,0,11,7],[14,0,14,1],[26,0,26,7],[14,5,14,6],[15,0,15,2],[0,0,0,1],[3,0,3,7],[4,0,4,7],[6,0,6,7],[9,0,9,7],[30,5,30,6],[15,5,15,6],[18,0,18,7],[19,0,19,7],[21,0,21,7],[24,0,24,7],[25,0,25,7],[30,0,30,2],[29,0,29,1],[29,5,29,6]]}
["For English please scroll"]
[]
[]
["Erklärung des Zahlungsempfängers/der Zahlungsempfängerin"]
["Erklärung zum Steuergeheimnis"]
[]
["Ich, Vorname Name, geboren am Datum, wohnhaft in Anschrift, STEUER-ID-Nummer:",null,null,null,null,null,null,null,null,"Ich, Vorname Name, geboren am Datum, wohnhaft in Anschrift, STEUER-ID-Nummer:"]
[null,null,null,null,null,null,null,null,null,null,"😊 Makros by K. Malá, 2024, finance@sot.tum.de"]
["erkläre,"]
["·       dass ich die Finanz- und Bewilligungsbehörden von der Verpflichtung zur Wahrung des Steuergeheimnisses gegenüber Bewilligungs- und Strafverfolgungsbehörden befreie, soweit meine Daten zu verifizieren/kontrollieren sind, die für die dortigen Verfahren von Bedeutung sind oder waren (§ 30 Abs. 4 Nr. 3 AO);"]
["·       dass ich der Weitergabe von Daten durch die Bewilligungsstellen an die Finanzbehörden zustimme, soweit diese Daten für die Besteuerung relevant sind (§ 93 AO);"]
["·       dass ich der Verarbeitung meiner angegebenen personenbezogenen Daten für die finanzbehördlichen Kontrollzwecke durch die Technische Universität München zustimme (Art. 7 DSGVO)."]
[]
[]
[]
["Ort, Datum",null,null,null,null,"Unterschrift"]
[]
[]
["Declaration on tax confidentiality"]
["Declaration by the payee"]
[]
["I, first name last name, born on date, resident at address, German tax identification number",null,null,null,null,null,null,null,null,"I, first name last name, born on date, resident at address, German tax identification number"]
[]
["declare"]
["·       that I release the financial and granting authorities from the obligation to maintain tax secrecy towards the granting and prosecuting authorities, insofar as my data is to be verified/controlled, which is or was of importance for the proceedings there (§ 30 section 4 no. 3 German Tax Code);"]
["·       that I consent to the transfer of data by the granting authorities to the tax authorities insofar as this data is relevant for taxation (§ 93 German Tax Code);"]
["·       that I consent to the processing of my personal data for the control purposes of the tax authorities by the Technical University of Munich (art. 7 GDPR)."]
[]
[]
[]
["Place, Date",null,null,null,null,"Signature"]

{"sheet":"Tax Declaration","index":3,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[7,11,8,13],[0,0,0,9],[6,0,6,8],[20,2,20,6],[16,6,16,9],[16,0,16,1],[16,2,16,4],[2,0,3,9],[7,0,7,9],[8,0,8,9],[19,3,19,8],[14,0,14,8],[5,0,5,9],[10,3,10,9],[11,3,11,9],[10,0,10,2],[20,7,20,8],[12,3,12,9],[39,3,39,9],[39,0,39,2],[41,0,41,4],[18,0,18,2],[18,3,18,6],[26,1,26,9],[22,0,22,3],[24,0,24,5],[41,5,41,9],[31,2,31,7],[37,4,37,5],[48,0,48,2],[21,3,21,8],[47,4,47,9],[48,4,48,9],[33,0,33,8],[34,0,34,1],[37,0,37,2],[47,1,47,2],[45,0,45,3],[45,6,45,7],[43,0,43,3],[43,6,43,7]]}
["Tax Declaration"]
[]
["regarding status as taxable person (“Unternehmer” within the meaning of § 2 of the German sales tax law [UStG]) and establishment of the supplier pursuant to § 13b UStG"]
[]
[]
["This tax declaration is applicable to all services provided by a foreign supplier, in particular services provided by visiting scholars, services in the form of guest lectures, translation services and artistic performance, and must be submitted to:"]
[]
["Finanzbuchhaltung/Zahlstelle of ZA 3 or ZA 8,",null,null,null,null,null,null,null,null,null,null,"😊 Makros by K. Malá, 2024, finance@sot.tum.de"]
["together with the original invoice and a payment request form"]
[]
["I/we (name/address of provider)",null,null,{"$f":"IF(Formular!$D$22=0,\"\",Formular!$D$22)","v":""}]
[null,null,null,{"$f":"IF(Formular!$D$23=0,\"\",Formular!$D$23)","v":""}]
[null,null,null,{"$f":"Formular!$H$23","v":"Germany"}]
[]
["herewith declare to Technische Universität München (TUM)"]
[]
["that for the period from",null,null,null,null,"to"]
[]
["remuneration in the amount of",null,null,{"$f":"Formular!H17","v":0},null,null,null,", comprising"]
[]
["a fee of",null,"and / or travel costs and expenses of",null,null,null,null,null,null,","]
[]
["has been agreed upon"]
[]
["for the following services provided by me/us:"]
[null,"visiting scholarship (research stay / no employment with TUM)"]
[null,"guest lecture (teaching as self-employed teacher/lecturer within the context of scholary teaching"]
[null,"public lecture (single lecture at an TUM Event)"]
[null,"scientific consultation"]
[null,"translation services"]
[null,"artistic performance"]
[null,"other",null,null,null,null,null,null,"(please specify)"]
[]
["I/we provide/will provide these services within the meaning of § 2 UStG (German sales tax law)"]
["in the capacity of a",null,null,"taxable person (“Unternehmer”)"]
[null,null,null,"non-taxable person (activity not intended for repetition)"]
[]
["If taxable: I am/we are registered",null,null,null,"in Germany",null,null,null,"abroad"]
[]
["with (name of tax office)"]
[]
["under the tax declaration number (“Steuernummer”)"]
[]
["The services were/will be provided",null,null,null,null,null,"in Germany",null,"abroad."]
[]
["The services are protected by copyright",null,null,null,null,null,"yes",null,"no."]
[]
[{"$f":"IF(Formular!B30=0,\" \",Formular!B30)","v":"2024-11-14"}]
["(date/location)",null,null,null,"(signature)"]

{"sheet":"Länderschlüssel","index":4,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
["Länderschlüssel","DE","ENG",null,null,"Version 1.0.2","uprava Seitenlayout, nefungovalo pro Apple Geräte"]
["AF","Afghanistan","Afghanistan",null,null,"Version 1.0.3","uprava listu Info, rozdeleni na jednu stranku Nemecka verze a druha Anglicka"]
["AL","Albanien","Albania",null,null,null," - uprava Seitenlayout, rozdeleni nasirku na 2. Seite a na vysku 1. Seite"]
["DZ","Algerien","Algeria"]
["AD","Andorra","Andorra"]
["AM","Armenien","Armenia"]
["AU","Australien","Australia"]
["AT","Österreich","Austria"]
["AZ","Aserbaidschan","Azerbaijan"]
["BH","Bahrain","Bahrain"]
["BY","Belarus","Belarus"]
["BE","Belgien","Belgium"]
["BO","Bolivien","Bolivia"]
["BA","Bosnien und Herzegowina","Bosnia and Herzegovina"]
["BR","Brasilien","Brazil"]
["BG","Bulgarien","Bulgaria"]
["CA","Kanada","Canada"]
["CL","Chile","Chile"]
["CN","China","China"]
["CO","Kolumbien","Columbia"]
["CR","Costa Rica","Costa Rica"]
["HR","Kroatien","Croatia"]
["CU","Kuba","Cuba"]
["CY","Zypern","Cyprus"]
["CZ","Tschechische Republik","Czech Republic"]
["KP","Korea, demokratische Volksrepublik","Democratic People's Republic of Korea"]
["DK","Dänemark","Denmark"]
["EC","Ecuador","Ecuador"]
["EG","Ägypten","Egypt"]
["SV","El Salvador","El Salvador"]
["EN","England","England"]
["GB","England/Großbritannien","England/Great Britain"]
["EE","Estland","Estonia"]
["FI","Finnland","Finland"]
["FR","Frankreich","France"]
["GE","Georgien","Georgia"]
["DE","Deutschland","Germany"]
["GI","Gibraltar","Gibraltar"]
["GR","Griechenland","Greece"]
["GT","Guatemala","Guatemala"]
["HN","Honduras","Honduras"]
["HK","Hong Kong","Hong Kong"]
["HU","Ungarn","Hungary"]
["IS","Island","Iceland"]
["IN","Indien","India"]
["ID","Indonesien","Indonesian"]
["IE","Irland","Ireland"]
["IL","Israel","Israel"]
["IT","Italien","Italy"]
["JP","Japan","Japan"]
["KZ","Kasachstan","Kazakstan"]
["KG","Kurdistan","Kurdistan"]
["KW","Kuwait","Kuwait"]
["LV","Lettland","Latvia"]
["LI","Liechtenstein","Liechtenstein"]
["LT","Litauen","Lithuania"]
["LU","Luxemburg","Luxembourg"]
["LX","Luxemburg","Luxembourg"]
["MK","Makedonien","Macedonia"]
["MY","Malaysia","Malaysia"]
["MT","Malta","Malta"]
["MX","Mexiko","Mexico"]
["MD","Moldavien","Moldavia"]
["MC","Monaco","Monaco"]
["MA","Marokko","Morocco"]
["NL","Niederlande","Netherlands"]
["NZ","Neuseeland","New Zealand"]
["NI","Nicaragua","Nicaragua"]
["NO","Norwegen","Norway"]
["PK","Pakistan","Pakistan"]
["PA","Panama","Panama"]
["PG","Papua-Neuguinea","Papuan New Guinea"]
["PY","Paraguay","Paraguay"]
["PE","Peru","Peru"]
["PH","Philippinen","Philippine"]
["PL","Polen","Poland"]
["PT","Portugal","Portugal"]
["PR","Puerto Rico","Puerto Rica"]
["QA","Quatar","Qatar"]
["KR","Korea, Republik","Republic of Korea"]
["RO","Rumänien","Romania"]
["RU","Russland","Russia"]
["SM","San Marino","San Marino"]
["SA","Saudi Arabien","Saudi Arabia"]
["SG","Singapur","Singapore"]
["SK","Slowakei (slowakische Republik)","Slovak Republic"]
["SI","Slowenien","Slovenia"]
["ZA","Südafrika","South Africa"]
["ES","Spanien","Spain"]
["SE","Schweden","Sweden"]
["CH","Schweiz","Switzerland"]
["TJ","Tadschikistan","Tadschikistan"]
["TH","Thailand","Thailand"]
["TN","Tunesien","Tunisia"]
["TR","Türkei","Turkey"]
["TM","Turkmenistan","Turkmenistan"]
["US","U.S.A.","U.S.A."]
["UA","Ukraine","Ukraine"]
["AE","Vereinigte Arabische Emirate","United Arab Emirates"]
["UY","Uruguay","Uruguay"]
["UZ","Usbekistan","Uzbekistan"]
["VE","Venezuela","Venezuela"]
["YU","Jugoslawien","Yugoslavia"]