{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["RK Inland","RK Ausland"],"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":"RK Inland","index":0,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[16,7,16,8],[23,5,23,6],[24,5,33,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],[15,7,15,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[21,7,21,8],[26,7,26,8],[28,7,28,8],[30,7,30,8],[35,7,35,8],[37,7,37,8],[38,7,38,8],[41,7,41,8],[42,7,42,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[57,7,57,8],[59,7,59,8],[52,7,52,8],[53,7,53,8],[54,7,54,8],[55,7,55,8]]}
[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}]
["öffentliche Verkehrsmittel",null,null,null,null,null,0.19,{"$f":"E17","v":0}]
["Auto",null,null,null,null,null,0.19,{"$f":"+E18","v":0}]
["Parken",null,null,null,null,null,0.19,{"$f":"+E19","v":0}]
["Mietwagen (wenn selber bezahlt)",null,null,null,null,null,0.19,{"$f":"+E20","v":0}]
[]
[" Kilometergeld",null,null,"km",null,"x EUR 0,30",null,{"$f":"+E22*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,12,null,null,{"$f":"D27*(E27+F27)","v":0}]
[]
[" ab 24 Stunden ",null,null,null,24,null,null,{"$f":"D29*(E29+F29)","v":0}]
[]
[" ./. pausch. Einbehalt für",null,null,null,4.8,null,null,{"$f":"D31*E31*-1","v":0}]
[" Frühstück bei Berechnung"]
[" Übernachtung incl. Frühstück"]
[]
["C","Übernachtungskosten "]
[null,"Pauschale Innland",null,null,20,null,null,{"$f":"D36*E36","v":0},null,{"$f":"+H36","v":0}]
[]
["  Einzelnachweis ",null,null,null,null," lt. Rechnung",null,{"$f":"E38","v":0}]
["  ./. Frühstück lt. Hotelrechnung",null,null,null,null,null,null,{"$f":"E39*-1","v":0},null,{"$f":"H38+H39","v":0}]
[]
["D","Sachbezugswert"]
[" Mittag-u. Abendessen",null,null,null,3.1,null,null,{"$f":"D42*E42*-1","v":0},null,{"$f":"D42*E42","v":0}]
[" Frühstück",null,null,null,1.67,null,null,{"$f":"D43*E43*-1","v":0},null,{"$f":"D43*E43","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"G42+G43","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":"E47","v":0}]
[" Bewirtung mit 7% MWSt",null,null,null,null,null,7.0000000000000007E-2,{"$f":"E48","v":0}]
[" Telefon inkl. MWST",null,null,null,null,null,0.19,{"$f":"E49","v":0}]
[" Sonstige",null,null,null,null,null,0.19,{"$f":"E50","v":0}]
[null,null,null,null,null,null,null,{"$f":"E51","v":0}]
[" Beträge ohne ausgewiesene MWSt"]
[" Telefon ohne MWST,  Porto",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}]
[null,null,null,null,null,null,null,{"$f":"E56","v":0}]
[]
[" Vorschuß",null,null,"abzüglich",null,null,null,{"$f":"E58*-1","v":0}]
[]
[" Auszuzahlender Betrag:",null,null,null,null,null,null,{"$f":"SUM(H16:H58)","v":0}]
[]
[" Für die Richtigkeit:",null,null,null,"Genehmigung:",null,null,"Auszahlung:"]
[]
[" Datum, Reisender:",null,null,null,"Datum, Vorgesetzter:",null,null,"Datum, Buchhaltung:"]

{"sheet":"RK Ausland","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],[16,7,16,8],[17,7,17,8],[15,7,15,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[22,7,22,8],[27,7,27,8],[30,7,30,8],[32,7,32,8],[37,7,37,8],[39,7,39,8],[40,7,40,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[51,7,51,8],[60,7,60,8],[53,7,53,8],[54,7,54,8],[55,7,55,8],[56,7,56,8],[58,7,58,8]]}
[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,{"$f":"+E16","v":0}]
[" Fahrtkosten, Benzin",null,null,"Ausland",null,null,null,0]
[null,null,null,"Ausland",null,null,null,0]
[" Taxi, Straßenbahn, Bus",null,null,"Inland",null,null,0.19,0]
[null,null,null,"Ausland",null,null,null,0]
[null,null,null,"Ausland",null,null,null,0]
[]
[" 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.1,null,{"$f":"J44/116*16","v":0},null,null,{"$f":"D44*E44","v":0}]
[" Frühstück",null,null,null,1.67,null,{"$f":"J45/116*16","v":0},null,null,{"$f":"D45*E45","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"G44+G45","v":0}]
["E","Einzelbelege Bewirtung (mit Fremden)"]
[" Fremdwährungsbeträge",null,null,null,"Fremdwähr."]
[" Bewirtung",null,null,null,45,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,5,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:"]