{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Reisekosten (mit Formeln)","Reisekosten (blanko)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Reisekosten (mit Formeln)","index":0,"n_rows":78,"n_cols":19,"rows_kept":78,"cut":false,"hidden":false,"merged":[[51,1,51,5],[51,6,51,7],[75,18,77,18],[55,1,55,6],[59,1,60,1],[59,3,60,6],[60,15,61,18],[62,1,63,1],[62,3,63,6],[66,1,66,6],[66,9,66,18],[77,8,77,9],[30,1,31,6],[33,1,34,6],[48,7,48,8],[49,1,50,8],[50,9,50,10],[16,14,16,16],[16,17,16,19],[1,1,1,5],[1,7,1,11],[4,1,4,5],[4,7,4,13],[10,1,10,3],[10,8,10,9],[10,12,10,14],[7,1,7,5],[11,8,11,9],[12,1,13,3],[16,1,17,3],[16,11,16,13]]}
[null,null,null,"Quelle: Haufe-Lexware - Vorlage: Reisekostenabrechnung 2011",null,null,null,"Stand:",2020]
[]
[null,"Abteilung, Sportbereich",null,null,null,null,null,"Monat, Jahr"]
[]
[]
[null,"Name, Vorname",null,null,null,null,null,"Anschrift"]
[]
[]
[null,"Anlass/Zielort der Auswärtstätigkeit"]
[]
[null,null,null,null,"um",null,"Uhr",null,null,null,"um",null,null,null,null,"Uhr"]
[null,"Beginn der Reise",null,null,null,null,null,null,"Ende der Reise"]
[null,"Reisemittel:"]
[]
[]
[]
[null,"Fahrtkosten",null,null,null,null,null,null,null,null,null,"Bruttoausgaben",null,null,"Ust-(Vorsteuer)",null,null,"Nettoaufwand"]
[]
[null,"Bahnfahrten/Fahrausweise lt. Anlage",null,null,null,null,null,null,"EUR",0,null,null,{"$f":"J19","v":0},null,null,null,null,null,{"$f":"M19-P19","v":0}]
[]
[null,"Flugkarten lt. Anlage",null,null,null,null,null,null,"EUR",0,null,null,{"$f":"J21","v":0},null,null,null,null,null,{"$f":"M21-P21","v":0}]
[]
[null,"Autokosten (Kraftstoff/Öl usw.) lt. Anlage",null,null,null,null,null,null,"EUR",0,null,null,{"$f":"J23","v":0},null,null,null,null,null,{"$f":"M23-P23","v":0}]
[]
[null,"Kilometersatz für Privat-/Arbeitnehmer-KfZ"]
[null,0,null,"km","x",0,"EUR",null,"EUR",{"$f":"B26*F26","v":0},null,null,{"$f":"J26","v":0},null,null,null,null,null,{"$f":"M26-P26","v":0}]
[]
[null,"Aufwendungen für Unterbringung"]
[null,"nach beigefügten Belegen",null,null,null,null,null,null,"EUR"]
[]
[null,"Kürzung Frühstück um 5,60 EUR/Tag\nbzw. 20% bei Auslandsübernachtung",null,null,null,null,null,null," ./. EUR",0]
[]
[]
[null,"Kürzung Mittag-/Abendessen um11,20 EUR/Tag\nbzw. 40% bei Auslandsübernachtung",null,null,null,null,null,null," ./. EUR",0]
[]
[]
[null,"oder Pauschbeträge ",null,null,null,"Tage    x",null,"EUR","EUR",{"$f":"J29-J31-J34","v":0},null,null,{"$f":"J37","v":0},null,null,null,null,null,{"$f":"M37-P37","v":0}]
[]
[null,"Pauschbeträge für Verpflegungsmehraufwand (im In- und Ausland)"]
[]
[null,null,null,"eintägig (mehr als 8 Stunden)",null,null,14,"EUR","EUR",{"$f":"B41*G41","v":0}]
[]
[null,null,null,"mehrtägig (Anreisetag ohne Zeitvorgabe)",null,null,14,"EUR","EUR",{"$f":"B43*G43","v":0}]
[]
[null,null,null,"mehrtägig (Abreisetag ohne Zeitvorgabe)",null,null,14,"EUR","EUR",{"$f":"B45*G45","v":0}]
[]
[null,null,null,"Zwischentage (24 Stunden Abwesenheit)",null,null,28,"EUR","EUR",{"$f":"B47*G47","v":0}]
[]
[null,null,null,null,null,null,null,"Summe EUR",null,{"$f":"J41+J43+J47+J45","v":0},null,null,{"$f":"J49","v":0},null,null,null,null,null,{"$f":"M49-P49","v":0}]
[null,"Reisenebenkosten lt. Formular \"Reisekostenabrechnung\""]
[null,null,null,null,null,null,null,null,null,"(Belege wie Parkge-bühren, … beilegen)"]
[null,null,null,null,null,null,null,null,"EUR",0,null,null,{"$f":"J52","v":0},null,null,null,null,null,{"$f":"M52-P52","v":0}]
[]
[null,"Verrechnung mit geldwertem Vorteil aus Arbeitnehmerbewirtung"]
[]
[null,"lt. untenstehender Aufstellung",null,null,null,null,null,null," ./. EUR",{"$f":"S76","v":0},null,null,{"$f":"J56","v":0},null,null,null,null,null,{"$f":"M56-P56","v":0}]
[]
[null,"Abrechnung erstellt",null,null,null,null,null,null,null,"Summe",null,null,{"$f":"SUM(M19:M56)","v":0},null,null,{"$f":"SUM(P19:P56)","v":0},null,null,{"$f":"SUM(S19:S56)","v":0}]
[]
[null,null,null,null,null,null,null,null,null," ./. Vorschüsse",null,null,null,null,null,"Buchungsvermerke:"]
[]
[null,"Datum",null,"Unterschrift Reisender",null,null,null,null,null,"Restzahlung/Überzahlung",null,null,{"$f":"M58-M60","v":0}]
[]
[]
[null,"Datum",null,"Unterschrift Vorgesetzter",null,null,null,null,null,"Ich bitte um Überweisung auf folgendes Konto: "]
[]
["Bank:"]
[null,"Bank:",null,null,null,null,null,null,null,"IBAN:"]
[]
[]
[]
[null,"Nachrichtlich:",null,null,"Geldwerter Vorteil aus Arbeitnehmerbewirtung:"]
[]
[null,"Ich habe vom Arbeitgeber unentgeltlich erhalten:"]
[]
[null,null,null,"Frühstück","á",1.57,null,null,null,null,null,null,"insgesamt","EUR",null,{"$f":"B76*F76","v":0},null,null,{"$f":"P76+P78","v":0}]
[]
[null,null,null,"x Mittagessen",null,null,"x Abendessen je",null,2.83,null,null,null,"insgesamt","EUR",null,{"$f":"(B78+F78)*I78","v":0}]

{"sheet":"Reisekosten (blanko)","index":1,"n_rows":78,"n_cols":18,"rows_kept":78,"cut":false,"hidden":false,"merged":[[66,1,66,6],[66,9,66,18],[75,18,77,18],[77,8,77,9],[55,1,55,6],[59,1,60,1],[59,3,60,6],[60,15,61,18],[62,1,63,1],[62,3,63,6],[51,1,51,5],[51,6,51,7],[11,8,11,9],[12,1,13,3],[16,1,17,3],[30,1,31,6],[33,1,34,6],[48,7,48,8],[49,1,50,8],[50,9,50,10],[16,11,16,13],[16,14,16,16],[16,17,16,19],[1,1,1,5],[1,7,1,11],[4,1,4,5],[4,7,4,13],[7,1,7,5],[10,1,10,3],[10,8,10,9],[10,12,10,14]]}
[null,null,null,"Quelle: Haufe-Lexware - Vorlage: Reisekostenabrechnung 2011",null,null,null,"Stand:",2020]
[]
[null,"Abteilung, Sportbereich",null,null,null,null,null,"Monat, Jahr"]
[]
[]
[null,"Name, Vorname",null,null,null,null,null,"Anschrift"]
[]
[]
[null,"Anlass/Zielort der Auswärtstätigkeit"]
[]
[null,null,null,null,"um",null,"Uhr",null,null,null,"um",null,null,null,null,"Uhr"]
[null,"Beginn der Reise",null,null,null,null,null,null,"Ende der Reise"]
[null,"Reisemittel:"]
[]
[]
[]
[null,"Fahrtkosten",null,null,null,null,null,null,null,null,null,"Bruttoausgaben",null,null,"Ust-(Vorsteuer)",null,null,"Nettoaufwand"]
[]
[null,"Bahnfahrten/Fahrausweise lt. Anlage",null,null,null,null,null,null,"EUR"]
[]
[null,"Flugkarten lt. Anlage",null,null,null,null,null,null,"EUR"]
[]
[null,"Autokosten (Kraftstoff/Öl usw.) lt. Anlage",null,null,null,null,null,null,"EUR"]
[]
[null,"Kilometersatz für Privat-/Arbeitnehmer-KfZ"]
[null,null,null,"km","x",null,"EUR",null,"EUR"]
[]
[null,"Aufwendungen für Unterbringung"]
[null,"nach beigefügten Belegen",null,null,null,null,null,null,"EUR"]
[]
[null,"Kürzung Frühstück um 5,60 EUR/Tag\nbzw. 20% bei Auslandsübernachtung",null,null,null,null,null,null," ./. EUR"]
[]
[]
[null,"Kürzung Mittag-/Abendessen um 11,20 EUR/Tag\nbzw. 40% bei Auslandsübernachtung",null,null,null,null,null,null," ./. EUR"]
[]
[]
[null,"oder Pauschbeträge ",null,null,null,"Tage    x",null,"EUR","EUR"]
[]
[null,"Pauschbeträge für Verpflegungsmehraufwand (im In- und Ausland)"]
[]
[null,null,null,"eintägig (mehr als 8 Stunden)",null,null,14,"EUR","EUR"]
[]
[null,null,null,"mehrtägig (Anreisetag ohne Zeitvorgabe)",null,null,14,"EUR","EUR"]
[]
[null,null,null,"mehrtägig (Abreisetag ohne Zeitvorgabe)",null,null,14,"EUR","EUR"]
[]
[null,null,null,"Zwischentage (24 Stunden Abwesenheit)",null,null,28,"EUR","EUR"]
[]
[null,null,null,null,null,null,null,"Summe EUR"]
[null,"Reisenebenkosten lt. Formular \"Reisekostenabrechnung\""]
[null,null,null,null,null,null,null,null,null,"(Belege wie Parkge-bühren, … beilegen)"]
[null,null,null,null,null,null,null,null,"EUR"]
[]
[null,"Verrechnung mit geldwertem Vorteil aus Arbeitnehmerbewirtung"]
[]
[null,"lt. untenstehender Aufstellung",null,null,null,null,null,null," ./. EUR"]
[]
[null,"Abrechnung erstellt",null,null,null,null,null,null,null,"Summe"]
[]
[null,null,null,null,null,null,null,null,null," ./. Vorschüsse",null,null,null,null,null,"Buchungsvermerke:"]
[]
[null,"Datum",null,"Unterschrift Reisender",null,null,null,null,null,"Restzahlung/Überzahlung"]
[]
[]
[null,"Datum",null,"Unterschrift Vorgesetzter",null,null,null,null,null,"Ich bitte um Überweisung auf folgendes Konto: "]
[]
["Bank:"]
[null,"Bank:",null,null,null,null,null,null,null,"IBAN:"]
[]
[]
[]
[null,"Nachrichtlich:",null,null,"Geldwerter Vorteil aus Arbeitnehmerbewirtung:"]
[]
[null,"Ich habe vom Arbeitgeber unentgeltlich erhalten:"]
[]
[null,null,null,"Frühstück","á",1.57,null,null,null,null,null,null,"insgesamt","EUR"]
[]
[null,null,null,"x Mittagessen",null,null,"x Abendessen je",null,2.83,null,null,null,"insgesamt","EUR"]