{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Reisekostenabrechnung"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Reisekostenabrechnung","index":0,"n_rows":43,"n_cols":40,"rows_kept":43,"cut":false,"hidden":false,"merged":[[10,38,10,42],[30,38,30,42],[30,3,30,20],[30,21,30,22],[30,23,30,27],[30,28,30,32],[29,38,29,42],[14,28,14,32],[14,33,14,37],[14,38,14,42],[13,21,13,22],[13,23,13,27],[18,3,18,27],[18,28,18,32],[18,33,18,37],[18,38,18,42],[13,3,13,20],[14,3,14,20],[16,8,16,9],[16,10,16,13],[15,3,15,27],[30,33,30,37],[29,33,29,37],[29,3,29,20],[6,16,6,42],[31,38,31,42],[9,2,9,42],[17,8,17,9],[17,10,17,13],[17,14,17,16],[11,33,11,37],[12,3,12,20],[12,21,12,22],[17,19,17,20],[17,23,17,27],[13,28,13,32],[13,33,13,37],[12,28,12,32],[12,23,12,27],[12,33,12,37],[16,14,16,16],[16,23,16,27],[13,38,13,42],[14,21,14,22],[14,23,14,27],[17,17,17,18],[17,21,17,22],[12,38,12,42],[4,37,4,42],[3,23,3,29],[4,2,4,8],[11,38,11,42],[10,33,10,37],[1,9,2,42],[3,30,3,35],[3,37,3,42],[3,9,3,14],[4,22,4,29],[11,3,11,27],[3,16,3,21],[4,16,4,21],[7,2,7,42],[8,2,8,42],[4,30,4,35],[3,2,3,8],[4,9,4,14],[10,28,10,32],[11,28,11,32],[10,3,10,27],[5,2,5,15],[5,16,5,42],[6,2,6,15],[16,17,16,22],[17,3,17,7],[15,28,15,32],[15,33,15,37],[15,38,15,42],[16,28,16,32],[16,33,16,37],[16,38,16,42],[17,28,17,32],[17,33,17,37],[17,38,17,42],[21,3,21,19],[24,3,24,4],[19,38,19,42],[20,28,20,32],[20,33,20,37],[20,38,20,42],[19,21,19,22],[19,23,19,27],[19,28,19,32],[19,33,19,37],[21,33,21,37],[21,38,21,42],[21,21,21,22],[21,23,21,27],[20,3,20,27],[23,28,23,32],[22,28,22,32],[22,11,22,13],[22,23,22,27],[21,28,21,32],[22,21,22,22],[24,19,24,20],[24,38,24,42],[25,19,25,20],[25,21,25,22],[24,21,24,22],[25,23,25,27],[23,38,23,42],[22,38,22,42],[24,23,24,27],[24,28,24,32],[24,33,24,37],[23,33,23,37],[22,33,22,37],[23,3,23,27],[22,19,22,20],[22,3,22,8],[22,9,22,10],[22,17,22,18],[22,14,22,16],[24,5,24,13],[24,14,24,16],[24,17,24,18],[25,5,25,13],[25,14,25,16],[25,17,25,18],[25,3,25,4],[26,5,26,13],[26,14,26,16],[26,17,26,18],[26,38,26,42],[27,3,27,22],[32,38,32,42],[31,3,31,20],[31,21,31,22],[31,23,31,27],[31,28,31,32],[28,3,28,27],[26,3,26,4],[32,33,32,37],[29,21,29,22],[29,23,29,27],[29,28,29,32],[32,3,32,27],[32,28,32,32],[0,2,0,42],[35,28,35,32],[33,33,33,37],[33,38,33,42],[34,28,34,32],[34,33,34,37],[34,38,34,42],[35,17,35,21],[35,22,35,27],[33,21,33,22],[27,28,27,32],[27,33,27,37],[27,38,27,42],[25,28,25,32],[25,33,25,37],[25,38,25,42],[26,28,26,32],[35,9,35,16],[34,22,34,27],[26,19,26,20],[26,21,26,22],[26,23,26,27],[28,38,28,42],[26,33,26,37],[36,17,36,27],[33,23,33,27],[33,3,33,19],[33,28,33,32],[31,33,31,37],[40,39,40,42],[28,28,28,32],[28,33,28,37],[27,23,27,27],[36,9,36,16],[36,34,36,42],[0,0,41,1],[19,3,19,20],[42,33,42,38],[42,39,42,42],[39,3,39,42],[40,24,41,32],[42,3,42,32],[38,3,38,7],[38,8,38,42],[36,2,36,7],[40,5,40,23],[41,39,41,42],[38,2,42,2],[41,3,41,4],[41,11,41,12],[41,5,41,10],[41,13,41,23],[40,33,40,38],[41,33,41,38],[40,3,40,4],[35,34,35,42],[1,2,1,8],[2,2,2,8],[36,28,36,32]]}
[null,null,"Reisekostenabrechnung"]
[null,null,"Name und Adresse"]
[null,null,"des Abrechnenden:"]
[null,null,"Beginn der Reise:",null,null,null,null,null,null,"2014-02-01",null,null,null,null,null,null,"07:00:00",null,null,null,null,null,null,"Ende der Reise:",null,null,null,null,null,null,"2014-02-03",null,null,null,null,null,null,"09:00:00"]
[null,null,null,null,null,null,null,null,null,"Datum",null,null,null,null,null,null,"Uhrzeit",null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum",null,null,null,null,null,null,"Uhrzeit"]
[null,null,"Anlass der Dienst-/Geschäftsreise",null,null,null,null,null,null,null,null,null,null,null,null,null,"Anlass der Reise"]
[null,null,"Zieladresse der Dienst-/Geschäftsreise:"]
[]
[null,null,"Reisemittel:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brutto-",null,null,null,null,"Ust-",null,null,null,null,"Netto-"]
[null,null,null,"Fahrtkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ausgaben",null,null,null,null,"(Vorsteuer)",null,null,null,null,"aufwand"]
[null,null,null,"Bahnfahrten/Fahrausweise lt. Anlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,null,null,null,null,null,{"$f":"X13","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AC13-AH13","v":0}]
[null,null,null,"Flugkarten lt. Anlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,0,null,null,null,null,{"$f":"X14","v":0},null,null,null,null,0,null,null,null,null,{"$f":"AC14-AH14","v":0}]
[null,null,null,"Autokosten (Kraftstoff/Öl usw.) lt. Anlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,0,null,null,null,null,{"$f":"X15","v":0},null,null,null,null,0,null,null,null,null,{"$f":"AC15-AH15","v":0}]
[null,null,null,"Kilometersatz bei Privat-/Arbeitnehmer-Kfz"]
[null,null,null,"Zuschlag für",null,null,null,null,0,null,"Mitfahrer x",null,null,null,{"$f":"I18","v":0},null,null,"km x 0,02 EUR"]
[null,null,null,null,null,null,null,null,null,null,"km x",null,null,null,0.3,null,null,"EUR",null,"=",null,"EUR",null,{"$f":"(I17*O17*0.02)+(I18*O18)","v":0},null,null,null,null,{"$f":"X18","v":0},null,null,null,null,0,null,null,null,null,{"$f":"AC18-AH18","v":0}]
[null,null,null,"Aufwendungen für Unterbringung"]
[null,null,null,"nach beigefügten Belegen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR"]
[null,null,null,"       Kürzung Frühstück 20 % vom Höchstsatz Verpfl.mehraufwand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC21","v":0}]
[null,null,null,"       bei Auslandsübernachtung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"./.","EUR"]
[null,null,null,"oder Pauschbetr.",null,null,null,null,null,null,null,"Tage x",null,null,null,null,null,"EUR",null,"=",null,"EUR",null,{"$f":"X20-X22+(J23*O23)","v":0},null,null,null,null,{"$f":"X23","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AC23-AH23","v":0}]
[null,null,null,"Pauschbeträge für Verpflegungsmehraufwand"]
[null,null,null,1,null,"  Tage (mind. 24 Std.) zu",null,null,null,null,null,null,null,null,24,null,null,"EUR",null,"=",null,"EUR",null,{"$f":"D25*O25","v":24}]
[null,null,null,2,null,"  Tage (mind. 8 Std.) zu",null,null,null,null,null,null,null,null,12,null,null,"EUR",null,"=",null,"EUR",null,{"$f":"D26*O26","v":24}]
[null,null,null,1,null,"An-/Abreise (Tage) zu",null,null,null,null,null,null,null,null,12,null,null,"EUR",null,"=",null,"EUR",null,{"$f":"D27*O27","v":12}]
[null,null,null,"Summe EUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X25:AB27)","v":60},null,null,null,null,{"$f":"X28","v":60},null,null,null,null,0,null,null,null,null,{"$f":"AC28-AH28","v":60}]
[null,null,null,"Reisenebenkosten (Taxi, ÖNV, etc.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,null,null,null,null,null,{"$f":"X30","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AC30-AH30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,null,null,null,null,null,{"$f":"X31","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AC31-AH31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,null,null,null,null,null,{"$f":"X32","v":0},null,null,null,null,0,null,null,null,null,{"$f":"AC32-AH32","v":0}]
[null,null,null,"Verrechnung mit geldw. Vorteil aus Arbeitnehmerbewirtung"]
[null,null,null,"lt. Untenstehender Aufstellung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"./.","EUR",null,{"$f":"-AN43","v":-24},null,null,null,null,{"$f":"X34","v":-24},null,null,null,null,null,null,null,null,null,{"$f":"AC34-AH34","v":-24}]
[null,null,"Abrechnung erstellt:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe",null,null,null,null,null,{"$f":"SUM(AC13:AG34)","v":36},null,null,null,null,{"$f":"SUM(AH13:AL34)","v":0},null,null,null,null,{"$f":"SUM(AM13:AQ34)","v":36}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"./. Vorschüsse",null,null,null,null,null,0,null,null,null,null,null,"Buchungsvermerke:"]
[null,null," Datum",null,null,null,null,null,null,"Unterschrift",null,null,null,null,null,null,null,"Restzahlung/Überzahlung",null,null,null,null,null,null,null,null,null,null,{"$f":"AC35-AC36","v":36}]
[]
[null,null,null,"Nachrichtlich:",null,null,null,null,"Geldwerter Vorteil aus Arbeitnehmerbewirtung"]
[null,null,null,"Ich habe vom Arbeitgeber unentgeltlich erhalten:"]
[null,null,null,1,null,"x Frühstück je 4,80 EUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"insgesamt EUR",null,null,null,null,null,{"$f":"D41*4.8","v":4.8}]
[null,null,null,1,null,"x Mittagessen",null,null,null,null,null,1,null,"x Abendessen je 9,60 EUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"insgesamt EUR",null,null,null,null,null,{"$f":"(D42+L42)*9.6","v":19.2}]
[null,null,null,",",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe",null,null,null,null,null,{"$f":"SUM(AN41:AQ42)","v":24}]