{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":[" Inland 2020"," Ausland 2020"],"not_rendered":{"charts":0,"images":0,"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":" Inland 2020","index":0,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[[22,5,22,6],[23,5,32,6],[4,9,4,11],[4,7,4,8],[2,7,2,8],[2,9,2,10],[4,1,4,6],[6,0,6,3],[6,4,6,6],[8,4,8,6],[8,0,8,3],[8,7,8,11],[6,7,6,11]]}
[null,null,null,null,"Reisekostenabrechnung",null,null,"  wird von Buchhaltung ausgefüllt"]
[null,null,null,null,"Inland",null,null,"  Beleg Nr.: ",null," Datum:",null," Monat:"]
[]
[" Pers-Nr.","  Vor- und Zuname des Reisenden, Wohnort",null,null,null,null,null," Kostenstelle",null," Konto"]
[]
[" Bankverbindung ",null,null,null," Konto-Nr.",null,null," BLZ"]
[]
[" Reiseweg ",null,null,null," Besuchte Stellen ",null,null," Begründung"]
[]
["Abfahrt ",null,"Rückkehr ",null," Benutztes Verkehrsmittel "]
[" Datum ","Uhrzeit","Datum","Uhrzeit"," Flugzeug",null,null," eig. Pkw Kennzeichen:  "]
[null,null,null,null," Eisenbahn ",null,null," Mitfahrt von / bei "]
[null,null,null,null," Firmenwagen",null,null," Mietwagen"]
["A","Fahrtkosten",null,null,"EUR",null,"MWST","Betrag",null,null,"St.Sch.","Konto"]
[]
["Flugzeug",null,null,null,null,null,0.19,{"$f":"+E16","v":0}]
["Auto",null,null,null,null,null,0.19,{"$f":"+E17","v":0}]
["Parken",null,null,null,null,null,0.19,0]
["Mietwagen (wenn selber bezahlt)",null,null,null,null,null,0.19,{"$f":"+E19","v":0}]
[]
[" Kilometergeld",null,null,"km",null,"x EUR 0,30",null,{"$f":"+E21*0.3","v":0}]
[]
["B","Verpflegungskosten Pauschale ",null,null,null,"Bemerkungen / Hinweise"]
[null,null,null,"Tage","gesetzl. Sätze "]
[]
[" ab 8 Stunden",null,null,null,"14,00 EUR",null,null,{"$f":"D26*(E26+F26)","v":{"$error":"#VALUE!"}}]
[]
[" ab 24 Stunden ",null,null,null,"28,00 EUR",null,null,{"$f":"D28*(E28+F28)","v":{"$error":"#VALUE!"}}]
[]
[" ./. pausch. Einbehalt für",null,null,null,"5,60 EUR",null,null,{"$f":"D30*E30*-1","v":{"$error":"#VALUE!"}}]
[" Frühstück bei Berechnung"]
[" Übernachtung incl. Frühstück"]
[]
["C","Übernachtungskosten "]
[null,"Pauschale Innland",null,null,20,null,null,{"$f":"D35*E35","v":0},null,{"$f":"+H35","v":0}]
[]
["  Einzelnachweis ",null,null,null,null," lt. Rechnung",null,{"$f":"E37","v":0}]
["  ./. Frühstück lt. Hotelrechnung",null,null,null,null,null,null,{"$f":"E38*-1","v":0},null,{"$f":"H37+H38","v":0}]
[]
["D","Sachbezugswert"]
[" Mittag-u. Abendessen",null,null,null,"3,40 EUR",null,null,{"$f":"D41*E41*-1","v":{"$error":"#VALUE!"}},null,{"$f":"D41*E41","v":{"$error":"#VALUE!"}}]
[" Frühstück",null,null,null,"1,80 EUR",null,null,{"$f":"D42*E42*-1","v":{"$error":"#VALUE!"}},null,{"$f":"D42*E42","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G41+G42","v":0}]
["E","Einzelbelege Bewirtung (mit Fremden)"]
[" Beträge mit ausgewiesener MWSt",null,null,null,"EUR"]
[" Bewirtung mit 19% MWSt",null,null,null,null,null,0.19,{"$f":"E46","v":0}]
[" Bewirtung mit 7% MWSt",null,null,null,null,null,7.0000000000000007E-2,{"$f":"E47","v":0}]
[" Telefon inkl. MWST",null,null,null,null,null,0.19,{"$f":"E48","v":0}]
[" Sonstige",null,null,null,null,null,0.19,{"$f":"E49","v":0}]
[null,null,null,null,null,null,null,{"$f":"E50","v":0}]
[" Beträge ohne ausgewiesene MWSt"]
[" Telefon ohne MWST,  Porto",null,null,null,null,null,null,{"$f":"E52","v":0}]
[null,null,null,null,null,null,null,{"$f":"E53","v":0}]
[null,null,null,null,null,null,null,{"$f":"E54","v":0}]
[null,null,null,null,null,null,null,{"$f":"E55","v":0}]
[]
[" Vorschuß",null,null,"abzüglich",null,null,null,{"$f":"E57*-1","v":0}]
[]
[" Auszuzahlender Betrag:",null,null,null,null,null,null,{"$f":"SUM(H16:H57)","v":{"$error":"#VALUE!"}}]
[]
[" Für die Richtigkeit:",null,null,null,"Genehmigung:",null,null,"Auszahlung:"]
[]
[" Datum, Reisender:",null,null,null,"Datum, Vorgesetzter:",null,null,"Datum, Buchhaltung:"]

{"sheet":" Ausland 2020","index":1,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":false,"merged":[[38,5,38,6],[39,5,39,6],[4,9,4,11],[40,5,40,6],[2,7,2,8],[2,9,2,10],[8,7,8,11],[4,1,4,6],[4,7,4,8],[6,7,6,10],[8,4,8,6],[8,0,8,3],[6,0,6,3],[6,4,6,6]]}
[null,null,null,null,"Reisekostenabrechnung",null,null,"  wird von Buchhaltung ausgefüllt"]
[null,null,null,null,"Ausland",null,null,"  Beleg Nr.: ",null," Datum:",null," Monat:"]
[]
[" Pers-Nr.","  Vor- und Zuname des Reisenden, Wohnort",null,null,null,null,null," Kostenstelle",null," Konto"]
[]
[" Bankverbindung ",null,null,null," Konto-Nr.",null,null," BLZ",null,null,null,"Kurs FW"]
[]
[" Reiseweg ",null,null,null," Besuchte Stellen ",null,null," Begründung"]
[]
["Abfahrt ",null,"Rückkehr ",null," Benutztes Verkehrsmittel "]
[" Datum ","Uhrzeit","Datum","Uhrzeit"," Flugzeug",null,null," eig. Pkw Kennzeichen:  "]
[null,null,null,null," Eisenbahn ",null,null," Mitfahrt von / bei "]
[null,null,null,null," Firmenwagen",null,null," Mietwagen"]
["A","Fahrtkosten",null,null,"EUR",null,"MWST","Betrag",null,null,"St.Sch.","Konto"]
[]
[" Eisenbahn, Flugzeug, Parkgeb.",null,null,"Inland",null,null,0.19]
[" Fahrtkosten, Benzin",null,null,"Ausland"]
[null,null,null,"Ausland"]
[" Taxi, Straßenbahn, Bus",null,null,"Inland",null,null,0.19]
[null,null,null,"Ausland"]
[null,null,null,"Ausland"]
[]
[" Kilometergeld",null,null,"km",null,"x EUR 0,30",null,{"$f":"+E23*0.3","v":0}]
[]
["B","Verpflegungskosten Pauschale"]
[null,null,null,"Tage","gesetzl. Sätze "]
[]
[" ab  8 Stunden",null,null,null,null,null,null,{"$f":"D28*(E28+F28)","v":0}]
[]
[]
[" ab 24 Stunden ",null,null,null,null,null,null,{"$f":"D31*(E31+F31)","v":0}]
[]
[" ./. pausch. Einbehalt für Frühstück",null,null,null,null,null,null,{"$f":"D33*E33*-1","v":0}]
[" bei Berechnung Übernachtung"]
[" incl. Frühstück 20% d. vollen Tagessatzes"]
[]
["C","Übernachtungskosten",null,"Tage","gesetzl. Sätze "]
[null,"Pauschale",null,null,null,null,null,{"$f":"D38*E38","v":0},null,{"$f":"+H38","v":0}]
[null,null,null,null,"EUR-Betrag","FW-Betrag"]
["  Einzelnachweis lt. Rechnung",null,null,null,null,null,null,{"$f":"+E40","v":0}]
["  ./. Frühstück lt. Hotelrechnung",null,null,null,null,null,null,{"$f":"-E41","v":0},null,{"$f":"SUM(H40:H41)","v":0}]
[]
["D","Sachbezugswert"]
[" Mittag-u. Abendessen",null,null,null,"3,40 EUR",null,{"$f":"J44/116*16","v":{"$error":"#VALUE!"}},null,null,{"$f":"D44*E44","v":{"$error":"#VALUE!"}}]
[" Frühstück",null,null,null,"1,80 EUR",null,{"$f":"J45/116*16","v":{"$error":"#VALUE!"}},null,null,{"$f":"D45*E45","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G44+G45","v":{"$error":"#VALUE!"}}]
["E","Einzelbelege Bewirtung (mit Fremden)"]
[" Fremdwährungsbeträge",null,null,null,"Fremdwähr."]
[" Bewirtung",null,null,null,null,null,null,{"$f":"E49*L7","v":0}]
[" Telefon, Porto",null,null,null,null,null,null,{"$f":"E50*L7","v":0}]
[" Sonstige:",null,null,null,null,null,null,{"$f":"E51*L7","v":0}]
[null,null,null,null,null,null,null,{"$f":"E52*L7","v":0}]
[" EUR - Belege",null,null,null,"EUR"]
[" Bewirtung: ",null,null,null,null,null,null,{"$f":"E54","v":0}]
[" Sonstige:",null,null,null,null,null,null,{"$f":"E55","v":0}]
[null,null,null,null,null,null,null,{"$f":"E56","v":0}]
[null,null,null,null,null,null,null,{"$f":"E57","v":0}]
[]
[" Vorschuß",null,null,"abzüglich",null,null,null,{"$f":"E59*-1","v":0}]
[]
[" Auszuzahlender Betrag:",null,null,null,null,null,null,{"$f":"SUM(H16:H57)-H59","v":0}]
[]
[" Für die Richtigkeit:",null,null,null,"Genehmigung:",null,null,"Auszahlung:"]
[]
[" Datum, Reisender:",null,null,null,"Datum, Vorgesetzter:",null,null,"Datum, Buchhaltung:"]