{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Jan","Feb","Mar","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","Summe"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":246,"comments":12,"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":"Jan","index":0,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[[44,12,44,13],[0,12,0,14],[41,13,41,14],[36,12,36,13],[47,12,47,13],[0,0,0,3],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13]]}
["Einnahmen/Ausgaben",null,null,null,"Firma Muster",null,null,null,null,"Jan",2022,null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[1,"10.1.","Bar","Libro","Fachbücher",null,201,0.1,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":-18.27},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":-182.73},"Weiterbildung/ Fachliteratur",null,"Investitionen *)",{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":120},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":2},"12.1.","Bar","Saturn","Digitalkamera",null,120,0.2,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":-20},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":-100},"Geringw. Wirtschaftsgüter",null,"Abschreibungen (AfA *)",0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":3},"12.1.","Bar","Druckerei","Visitenkarten",null,140,0.2,-23.33,{"$f":"IF(F5<>\"\",F5-I5,(G5+I5)*-1)","v":-116.67},"Marketing-Werbung",null,"Wareneinkäufe",0,null,"","","","",""]
[4,"18.1.","Bank","Büroservice Müller","Schreibtisch",null,320,0.2,-53.33,-266.67,"Geringw. Wirtschaftsgüter",null,"Hilfs- u. Betriebsstoffe",0,null,"","","","",""]
[5,"2018-01-18","Bank","Öticket","Eintritt Wirtschaftsevent",null,112,0.13,-12.88,-99.12,"Marketing-Werbung",null,"Personalkosten",0,null,"","","","",""]
[6,"2018-01-19","Bank","Pagro","Druckerpatronen",null,34,0.2,-5.67,-28.33,"Büromaterial, Deko, Verp.",null,"Fremdleistungen (z.B. Prov.)",0,null,"","","","",""]
[7,"2018-01-20","Bank","Weber OG, Deutschland","Werbeartikel",620,null,0,0,620,"Handel",null,"Miete-Betriebskosten",0,null,620,false,false,false,false]
[8,"2018-01-22","Bar","MediaMarkt","EDV + Zubehör",null,720,0.2,-120,-600,"Investitionen *)",null,"Büromaterial, Deko, Verp.",-28.33,null,"","","","",""]
[9,"2018-01-22","Bar","MediaMarkt","EDV + Zubehör",null,-720,null,0,720,"Investitionen *)",null,"Marketing-Werbung",-215.79,null,"","","","",""]
[10,"2018-01-23","Bank","Öticket","Wirtschaftsevent",null,112,0.13,-12.88,-99.12,"Betriebl.-Versicherung",null,"Kommunikation & Porto",-25,null,"","","","",""]
[11,"2018-01-26","Bank","XY Institution","Seminar-Reihe",810,null,0.2,135,675,"Dienstleistungen",null,"Leasing",0,null,false,false,false,false,675]
[12,"24.1.","Bank","Müller","Konzept & Beratung",805,null,0.2,134.16999999999999,670.83,"Dienstleistungen",null,"Bankspesen/Zinsen",0,null,false,false,false,false,670.83]
[13,"26.1.","Bar","Vier","Telefon & Internet",null,30,0.2,-5,-25,"Kommunikation & Porto",null,"Beratungskosten",0,null,"","","","",""]
[14,"27.1.","Bar","Kammer","Grundumlage",null,160,null,0,-160,"Gebühren-Beiträge",null,"Gebühren-Beiträge",-160,null,"","","","",""]
[15,"2018-01-27","Bank","Uniqa","Betriebsausfallsv.",null,60,null,0,-60,"Betriebl.-Versicherung",null,"KFZ-Betriebskosten",-195,null,"","","","",""]
[16,"2014-01-28","Bank","Saturn","Bildschirm für PC",null,166,0.2,-27.67,-138.33000000000001,"Geringw. Wirtschaftsgüter",null,"Fahrt- und Reisekosten",-965.43,null,"","","","",""]
[17,"31.1.","Bar","Div. Tankstellen","Tanken Jänner",null,195,0,0,-195,"KFZ-Betriebskosten",null,"Betriebl.-Versicherung",-159.12,null,"","","","",""]
[18,"31.1.",null,"RK","Jänner",null,777.56,0,0,-777.56,"Fahrt- und Reisekosten",null,"Weiterbildung/ Fachliteratur",-182.73,null,"","","","",""]
[19,"31.1.",null,"RK","Jänner",null,195.2,0.1,-17.75,-177.45,"Fahrt- und Reisekosten",null,"Geringw. Wirtschaftsgüter",-505,null,"","","","",""]
[20,"2018-01-31",null,"RK","Jänner",null,12.5,0.2,-2.08,-10.42,"Fahrt- und Reisekosten",null,"Gewerbl. Sozialversicherung",0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Div. Steuern u. Abgaben",0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Sonstige Ausgaben",0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"A-leer1",0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"A-leer2",0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"A-leer3",{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Handel",null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":620},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Dienstleistungen",null,1345.83,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Diverse Gutschriften",null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"E-leer1",null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"E-leer2",null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"E-leer3",null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":1965.83},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":620},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":1345.83},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":-2316.4},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":-350.57},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":318.86},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":269.17},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":-49.69},"","","","",""]
[{"$f":"IF(B46<>\"\",A45+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"IF(F46<>\"\",IF(H46=0%,F46-I46),\"\")","v":""},"",{"$f":"IF(F46<>\"\",IF(H46=10%,F46-I46),\"\")","v":""},{"$f":"IF(F46<>\"\",IF(H46=13%,F46-I46),\"\")","v":""},{"$f":"IF(F46<>\"\",IF(H46=20%,F46-I46),\"\")","v":""}]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"IF(F47<>\"\",IF(H47=0%,F47-I47),\"\")","v":""},"",{"$f":"IF(F47<>\"\",IF(H47=10%,F47-I47),\"\")","v":""},{"$f":"IF(F47<>\"\",IF(H47=13%,F47-I47),\"\")","v":""},{"$f":"IF(F47<>\"\",IF(H47=20%,F47-I47),\"\")","v":""}]
[{"$f":"IF(B48<>\"\",A47+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,{"$f":"IF(F48<>\"\",IF(H48=0%,F48-I48),\"\")","v":""},"",{"$f":"IF(F48<>\"\",IF(H48=10%,F48-I48),\"\")","v":""},{"$f":"IF(F48<>\"\",IF(H48=13%,F48-I48),\"\")","v":""},{"$f":"IF(F48<>\"\",IF(H48=20%,F48-I48),\"\")","v":""}]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":2235},{"$f":"SUM(G3:G49)","v":2635.26},null,{"$f":"SUM(I3:I49)","v":-49.69},{"$f":"SUM(J3:J49)","v":-350.57}]

{"sheet":"Feb","index":1,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[0,0,0,3],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Feb",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Jan!A3:A49)+1","v":21},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Mar","index":2,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Mar",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Feb!A3:A49)+1","v":22},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Apr","index":3,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Apr",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Mar!A3:A49)+1","v":23},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Mai","index":4,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Mai",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Apr!A3:A49)+1","v":24},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Jun","index":5,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Jun",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Mai!A3:A49)+1","v":25},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Jul","index":6,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Jul",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Jun!A3:A49)+1","v":26},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Aug","index":7,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Aug",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Jul!A3:A49)+1","v":27},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Sep","index":8,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Sep",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Aug!A3:A49)+1","v":28},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Okt","index":9,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Okt",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Sep!A3:A49)+1","v":29},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Nov","index":10,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[0,4,0,8],[39,12,39,13],[42,12,42,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Nov",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Okt!A3:A49)+1","v":30},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},{"$f":"SUMIF($K$3:$K$49,M27,$J$3:$J$49)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",A48+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Dez","index":11,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[[47,12,47,13],[44,12,44,13],[0,12,0,14],[41,13,41,14],[0,4,0,8],[43,12,43,13],[35,12,35,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[42,12,42,13],[36,12,36,13]]}
["Einnahmen/Ausgaben",null,null,null,{"$f":"Jan!E1","v":"Firma Muster"},null,null,null,null,"Dez",{"$f":"Jan!K1","v":2022},null,"Zusammenfassung"]
["lfd. Nr.","Datum","Kto","Rechnung von/an","Text","E-Brutto","A-Brutto","MwSt.","MwSt. Betr.","Netto","Zuordung Ausg/ Einn.",null,"Ausgaben-/ Einnahmenart","Ausgaben",null,"0%","5%","10%","13%","20%"]
[{"$f":"MAX(Nov!A3:A49)+1","v":31},null,null,null,null,null,null,null,{"$f":"IF(F3<>\"\",IF(H3=20%,F3/6,IF(H3=13%,F3/8.6923076,IF(H3=5%,F3/21,IF(H3=10%,F3/11,IF(H3=0%,F3*0))))),IF(H3=20%,G3/6*-1,IF(H3=13%,G3/8.6923076*-1,IF(H3=5%,G3/21*-1,IF(H3=10%,G3/11*-1,IF(H3=0%,G3*0))))))","v":0},{"$f":"IF(F3<>\"\",F3-I3,(G3+I3)*-1)","v":0},null,null,{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"SUMIF($K$3:$K$49,M3,$J$3:$J$49)","v":0},null,{"$f":"IF(F3<>\"\",IF(H3=0%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=5%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=10%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=13%,F3-I3),\"\")","v":""},{"$f":"IF(F3<>\"\",IF(H3=20%,F3-I3),\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F4<>\"\",IF(H4=20%,F4/6,IF(H4=13%,F4/8.6923076,IF(H4=5%,F4/21,IF(H4=10%,F4/11,IF(H4=0%,F4*0))))),IF(H4=20%,G4/6*-1,IF(H4=13%,G4/8.6923076*-1,IF(H4=5%,G4/21*-1,IF(H4=10%,G4/11*-1,IF(H4=0%,G4*0))))))","v":0},{"$f":"IF(F4<>\"\",F4-I4,(G4+I4)*-1)","v":0},null,null,{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},0,null,{"$f":"IF(F4<>\"\",IF(H4=0%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=5%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=10%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=13%,F4-I4),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(H4=20%,F4-I4),\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""},null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M5","v":"Wareneinkäufe"},0,null,"","","","",""]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F6<>\"\",F6-I6,(G6+I6)*-1)","v":0},null,null,{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M7","v":"Personalkosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M9","v":"Miete-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M11","v":"Marketing-Werbung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M12","v":"Kommunikation & Porto"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M13","v":"Leasing"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M15","v":"Beratungskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M16","v":"Gebühren-Beiträge"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M24","v":"Sonstige Ausgaben"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M25","v":"A-leer1"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M26","v":"A-leer2"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M27","v":"A-leer3"},0,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"- - - - - - - - - - - - - - - - - - -",null,"Einnahmen","","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M29","v":"Handel"},null,{"$f":"SUMIF($K$3:$K$49,M29,$J$3:$J$49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M30","v":"Dienstleistungen"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M31","v":"Diverse Gutschriften"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M32","v":"E-leer1"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M33","v":"E-leer2"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"Jan!M34","v":"E-leer3"},null,0,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Einnahmen *)",null,{"$f":"SUM(O29:O34)","v":0},"","","","",""]
[{"$f":"IF(B36<>\"\",A35+1,\"\")","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(F36<>\"\",F36-I36,(G36+I36)*-1)","v":0},null,null,"*) gesplittet in Einnahmen mit 0%",null,{"$f":"IF(O35<>0,SUM(P3:P500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 5%",null,{"$f":"IF(O35<>0,SUM(Q3:Q500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 10%",null,{"$f":"IF(O35<>0,SUM(R3:R500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 13%",null,{"$f":"IF(O35<>0,SUM(S3:S500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"*) gesplittet in Einnahmen mit 20%",null,{"$f":"IF(O35<>0,SUM(T3:T500),\"\")","v":""},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Summe Ausgaben",{"$f":"SUM(N3:N27)","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(N42>0,\"Überschuss der Einnahmen\",\"Überschuss der Ausgaben\")","v":"Überschuss der Ausgaben"},{"$f":"O35+N41","v":0},null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Vorsteuer",null,{"$f":"SUMIF(I3:I49,\"<0\",I3:I49)*(-1)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Umsatzsteuer",null,{"$f":"SUMIF(I3:I49,\">0\",I3:I49)","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"Zahllast Finanzamt",null,{"$f":"(O43-O44)*-1","v":0},"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,null,null,null,"","","","",""]
["",null,null,null,null,null,null,null,0,0,null,null,"ab Zelle 47 kann man bei Bedarf und pro Klick",null,null,"","","","",""]
[{"$f":"IF(B49<>\"\",#REF!+1,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=20%,F49/6,IF(H49=13%,F49/8.6923076,IF(H49=5%,F49/21,IF(H49=10%,F49/11,IF(H49=0%,F49*0))))),IF(H49=20%,G49/6*-1,IF(H49=13%,G49/8.6923076*-1,IF(H49=5%,G49/21*-1,IF(H49=10%,G49/11*-1,IF(H49=0%,G49*0))))))","v":0},{"$f":"IF(F49<>\"\",F49-I49,(G49+I49)*-1)","v":0},null,null,null,null,null,{"$f":"IF(F49<>\"\",IF(H49=0%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=5%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=10%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=13%,F49-I49),\"\")","v":""},{"$f":"IF(F49<>\"\",IF(H49=20%,F49-I49),\"\")","v":""}]
["Summe Einnahmen/ Ausgaben:",null,null,null,null,{"$f":"SUM(F3:F49)","v":0},{"$f":"SUM(G3:G49)","v":0},null,{"$f":"SUM(I3:I49)","v":0},{"$f":"SUM(J3:J49)","v":0}]

{"sheet":"Summe","index":12,"n_rows":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":false,"merged":[[48,0,48,17],[69,0,69,7],[69,9,69,17],[33,0,33,17],[0,12,0,17]]}
["GESAMTERGEBNIS zu UMSATZ, ERTRAG und ZAHLLAST",null,null,null,null,null,{"$f":"Jan!K1","v":2022},null,null,null,null,null,{"$f":"Jan!E1","v":"Firma Muster"}]
["Ausgaben-/ Einnahmenart",{"$f":"Jan!J1","v":"Jan"},{"$f":"Feb!J1","v":"Feb"},{"$f":"Mar!J1","v":"Mar"},"1. QU",{"$f":"Apr!J1","v":"Apr"},{"$f":"Mai!J1","v":"Mai"},{"$f":"Jun!J1","v":"Jun"},"2. QU",{"$f":"Jul!J1","v":"Jul"},{"$f":"Aug!J1","v":"Aug"},{"$f":"Sep!J1","v":"Sep"},"3. QU",{"$f":"Okt!J1","v":"Okt"},{"$f":"Nov!J1","v":"Nov"},{"$f":"Dez!J1","v":"Dez"},"4. Qu","SUMME"]
[{"$f":"Jan!M3","v":"Investitionen *)"},{"$f":"Jan!N3","v":120},{"$f":"Feb!N3","v":0},{"$f":"Mar!N3","v":0},{"$f":"SUM(B3:D3)","v":120},{"$f":"Apr!N3","v":0},{"$f":"Mai!N3","v":0},{"$f":"Jun!N3","v":0},{"$f":"SUM(F3:H3)","v":0},{"$f":"Jul!N3","v":0},{"$f":"Aug!N3","v":0},{"$f":"Sep!N3","v":0},{"$f":"SUM(J3:L3)","v":0},{"$f":"Okt!N3","v":0},{"$f":"Nov!N3","v":0},{"$f":"Dez!N3","v":0},{"$f":"SUM(N3:P3)","v":0},{"$f":"E3+I3+M3+Q3","v":120}]
[{"$f":"Jan!M4","v":"Abschreibungen (AfA *)"},{"$f":"Jan!N4","v":0},{"$f":"Feb!N4","v":0},{"$f":"Mar!N4","v":0},{"$f":"SUM(B4:D4)","v":0},{"$f":"Apr!N4","v":0},{"$f":"Mai!N4","v":0},{"$f":"Jun!N4","v":0},{"$f":"SUM(F4:H4)","v":0},{"$f":"Jul!N4","v":0},{"$f":"Aug!N4","v":0},{"$f":"Sep!N4","v":0},{"$f":"SUM(J4:L4)","v":0},{"$f":"Okt!N4","v":0},{"$f":"Nov!N4","v":0},{"$f":"Dez!N4","v":0},{"$f":"SUM(N4:P4)","v":0},{"$f":"E4+I4+M4+Q4","v":0}]
[{"$f":"Jan!M5","v":"Wareneinkäufe"},{"$f":"Jan!N5","v":0},{"$f":"Feb!N5","v":0},{"$f":"Mar!N5","v":0},0,{"$f":"Apr!N5","v":0},{"$f":"Mai!N5","v":0},{"$f":"Jun!N5","v":0},0,{"$f":"Jul!N5","v":0},{"$f":"Aug!N5","v":0},{"$f":"Sep!N5","v":0},0,{"$f":"Okt!N5","v":0},{"$f":"Nov!N5","v":0},{"$f":"Dez!N5","v":0},0,0]
[{"$f":"Jan!M6","v":"Hilfs- u. Betriebsstoffe"},{"$f":"Jan!N6","v":0},{"$f":"Feb!N6","v":0},{"$f":"Mar!N6","v":0},0,{"$f":"Apr!N6","v":0},{"$f":"Mai!N6","v":0},{"$f":"Jun!N6","v":0},0,{"$f":"Jul!N6","v":0},{"$f":"Aug!N6","v":0},{"$f":"Sep!N6","v":0},0,{"$f":"Okt!N6","v":0},{"$f":"Nov!N6","v":0},{"$f":"Dez!N6","v":0},0,0]
[{"$f":"Jan!M7","v":"Personalkosten"},{"$f":"Jan!N7","v":0},{"$f":"Feb!N7","v":0},{"$f":"Mar!N7","v":0},0,{"$f":"Apr!N7","v":0},{"$f":"Mai!N7","v":0},{"$f":"Jun!N7","v":0},0,{"$f":"Jul!N7","v":0},{"$f":"Aug!N7","v":0},{"$f":"Sep!N7","v":0},0,{"$f":"Okt!N7","v":0},{"$f":"Nov!N7","v":0},{"$f":"Dez!N7","v":0},0,0]
[{"$f":"Jan!M8","v":"Fremdleistungen (z.B. Prov.)"},{"$f":"Jan!N8","v":0},{"$f":"Feb!N8","v":0},{"$f":"Mar!N8","v":0},0,{"$f":"Apr!N8","v":0},{"$f":"Mai!N8","v":0},{"$f":"Jun!N8","v":0},0,{"$f":"Jul!N8","v":0},{"$f":"Aug!N8","v":0},{"$f":"Sep!N8","v":0},0,{"$f":"Okt!N8","v":0},{"$f":"Nov!N8","v":0},{"$f":"Dez!N8","v":0},0,0]
[{"$f":"Jan!M9","v":"Miete-Betriebskosten"},{"$f":"Jan!N9","v":0},{"$f":"Feb!N9","v":0},{"$f":"Mar!N9","v":0},0,{"$f":"Apr!N9","v":0},{"$f":"Mai!N9","v":0},{"$f":"Jun!N9","v":0},0,{"$f":"Jul!N9","v":0},{"$f":"Aug!N9","v":0},{"$f":"Sep!N9","v":0},0,{"$f":"Okt!N9","v":0},{"$f":"Nov!N9","v":0},{"$f":"Dez!N9","v":0},0,0]
[{"$f":"Jan!M10","v":"Büromaterial, Deko, Verp."},{"$f":"Jan!N10","v":-28.33},{"$f":"Feb!N10","v":0},{"$f":"Mar!N10","v":0},-28.33,{"$f":"Apr!N10","v":0},{"$f":"Mai!N10","v":0},{"$f":"Jun!N10","v":0},0,{"$f":"Jul!N10","v":0},{"$f":"Aug!N10","v":0},{"$f":"Sep!N10","v":0},0,{"$f":"Okt!N10","v":0},{"$f":"Nov!N10","v":0},{"$f":"Dez!N10","v":0},0,-28.33]
[{"$f":"Jan!M11","v":"Marketing-Werbung"},{"$f":"Jan!N11","v":-215.79},{"$f":"Feb!N11","v":0},{"$f":"Mar!N11","v":0},-215.79,{"$f":"Apr!N11","v":0},{"$f":"Mai!N11","v":0},{"$f":"Jun!N11","v":0},0,{"$f":"Jul!N11","v":0},{"$f":"Aug!N11","v":0},{"$f":"Sep!N11","v":0},0,{"$f":"Okt!N11","v":0},{"$f":"Nov!N11","v":0},{"$f":"Dez!N11","v":0},0,-215.79]
[{"$f":"Jan!M12","v":"Kommunikation & Porto"},{"$f":"Jan!N12","v":-25},{"$f":"Feb!N12","v":0},{"$f":"Mar!N12","v":0},-25,{"$f":"Apr!N12","v":0},{"$f":"Mai!N12","v":0},{"$f":"Jun!N12","v":0},0,{"$f":"Jul!N12","v":0},{"$f":"Aug!N12","v":0},{"$f":"Sep!N12","v":0},0,{"$f":"Okt!N12","v":0},{"$f":"Nov!N12","v":0},{"$f":"Dez!N12","v":0},0,-25]
[{"$f":"Jan!M13","v":"Leasing"},{"$f":"Jan!N13","v":0},{"$f":"Feb!N13","v":0},{"$f":"Mar!N13","v":0},0,{"$f":"Apr!N13","v":0},{"$f":"Mai!N13","v":0},{"$f":"Jun!N13","v":0},0,{"$f":"Jul!N13","v":0},{"$f":"Aug!N13","v":0},{"$f":"Sep!N13","v":0},0,{"$f":"Okt!N13","v":0},{"$f":"Nov!N13","v":0},{"$f":"Dez!N13","v":0},0,0]
[{"$f":"Jan!M14","v":"Bankspesen/Zinsen"},{"$f":"Jan!N14","v":0},{"$f":"Feb!N14","v":0},{"$f":"Mar!N14","v":0},0,{"$f":"Apr!N14","v":0},{"$f":"Mai!N14","v":0},{"$f":"Jun!N14","v":0},0,{"$f":"Jul!N14","v":0},{"$f":"Aug!N14","v":0},{"$f":"Sep!N14","v":0},0,{"$f":"Okt!N14","v":0},{"$f":"Nov!N14","v":0},{"$f":"Dez!N14","v":0},0,0]
[{"$f":"Jan!M15","v":"Beratungskosten"},{"$f":"Jan!N15","v":0},{"$f":"Feb!N15","v":0},{"$f":"Mar!N15","v":0},0,{"$f":"Apr!N15","v":0},{"$f":"Mai!N15","v":0},{"$f":"Jun!N15","v":0},0,{"$f":"Jul!N15","v":0},{"$f":"Aug!N15","v":0},{"$f":"Sep!N15","v":0},0,{"$f":"Okt!N15","v":0},{"$f":"Nov!N15","v":0},{"$f":"Dez!N15","v":0},0,0]
[{"$f":"Jan!M16","v":"Gebühren-Beiträge"},{"$f":"Jan!N16","v":-160},{"$f":"Feb!N16","v":0},{"$f":"Mar!N16","v":0},-160,{"$f":"Apr!N16","v":0},{"$f":"Mai!N16","v":0},{"$f":"Jun!N16","v":0},0,{"$f":"Jul!N16","v":0},{"$f":"Aug!N16","v":0},{"$f":"Sep!N16","v":0},0,{"$f":"Okt!N16","v":0},{"$f":"Nov!N16","v":0},{"$f":"Dez!N16","v":0},0,-160]
[{"$f":"Jan!M17","v":"KFZ-Betriebskosten"},{"$f":"Jan!N17","v":-195},{"$f":"Feb!N17","v":0},{"$f":"Mar!N17","v":0},-195,{"$f":"Apr!N17","v":0},{"$f":"Mai!N17","v":0},{"$f":"Jun!N17","v":0},0,{"$f":"Jul!N17","v":0},{"$f":"Aug!N17","v":0},{"$f":"Sep!N17","v":0},0,{"$f":"Okt!N17","v":0},{"$f":"Nov!N17","v":0},{"$f":"Dez!N17","v":0},0,-195]
[{"$f":"Jan!M18","v":"Fahrt- und Reisekosten"},{"$f":"Jan!N18","v":-965.43},{"$f":"Feb!N18","v":0},{"$f":"Mar!N18","v":0},-965.43,{"$f":"Apr!N18","v":0},{"$f":"Mai!N18","v":0},{"$f":"Jun!N18","v":0},0,{"$f":"Jul!N18","v":0},{"$f":"Aug!N18","v":0},{"$f":"Sep!N18","v":0},0,{"$f":"Okt!N18","v":0},{"$f":"Nov!N18","v":0},{"$f":"Dez!N18","v":0},0,-965.43]
[{"$f":"Jan!M19","v":"Betriebl.-Versicherung"},{"$f":"Jan!N19","v":-159.12},{"$f":"Feb!N19","v":0},{"$f":"Mar!N19","v":0},-159.12,{"$f":"Apr!N19","v":0},{"$f":"Mai!N19","v":0},{"$f":"Jun!N19","v":0},0,{"$f":"Jul!N19","v":0},{"$f":"Aug!N19","v":0},{"$f":"Sep!N19","v":0},0,{"$f":"Okt!N19","v":0},{"$f":"Nov!N19","v":0},{"$f":"Dez!N19","v":0},0,-159.12]
[{"$f":"Jan!M20","v":"Weiterbildung/ Fachliteratur"},{"$f":"Jan!N20","v":-182.73},{"$f":"Feb!N20","v":0},{"$f":"Mar!N20","v":0},-182.73,{"$f":"Apr!N20","v":0},{"$f":"Mai!N20","v":0},{"$f":"Jun!N20","v":0},0,{"$f":"Jul!N20","v":0},{"$f":"Aug!N20","v":0},{"$f":"Sep!N20","v":0},0,{"$f":"Okt!N20","v":0},{"$f":"Nov!N20","v":0},{"$f":"Dez!N20","v":0},0,-182.73]
[{"$f":"Jan!M21","v":"Geringw. Wirtschaftsgüter"},{"$f":"Jan!N21","v":-505},{"$f":"Feb!N21","v":0},{"$f":"Mar!N21","v":0},-505,{"$f":"Apr!N21","v":0},{"$f":"Mai!N21","v":0},{"$f":"Jun!N21","v":0},0,{"$f":"Jul!N21","v":0},{"$f":"Aug!N21","v":0},{"$f":"Sep!N21","v":0},0,{"$f":"Okt!N21","v":0},{"$f":"Nov!N21","v":0},{"$f":"Dez!N21","v":0},0,-505]
[{"$f":"Jan!M22","v":"Gewerbl. Sozialversicherung"},{"$f":"Jan!N22","v":0},{"$f":"Feb!N22","v":0},{"$f":"Mar!N22","v":0},0,{"$f":"Apr!N22","v":0},{"$f":"Mai!N22","v":0},{"$f":"Jun!N22","v":0},0,{"$f":"Jul!N22","v":0},{"$f":"Aug!N22","v":0},{"$f":"Sep!N22","v":0},0,{"$f":"Okt!N22","v":0},{"$f":"Nov!N22","v":0},{"$f":"Dez!N22","v":0},0,0]
[{"$f":"Jan!M23","v":"Div. Steuern u. Abgaben"},{"$f":"Jan!N23","v":0},{"$f":"Feb!N23","v":0},{"$f":"Mar!N23","v":0},0,{"$f":"Apr!N23","v":0},{"$f":"Mai!N23","v":0},{"$f":"Jun!N23","v":0},0,{"$f":"Jul!N23","v":0},{"$f":"Aug!N23","v":0},{"$f":"Sep!N23","v":0},0,{"$f":"Okt!N23","v":0},{"$f":"Nov!N23","v":0},{"$f":"Dez!N23","v":0},0,0]
[{"$f":"Jan!M24","v":"Sonstige Ausgaben"},{"$f":"Jan!N24","v":0},{"$f":"Feb!N24","v":0},{"$f":"Mar!N24","v":0},0,{"$f":"Apr!N24","v":0},{"$f":"Mai!N24","v":0},{"$f":"Jun!N24","v":0},0,{"$f":"Jul!N24","v":0},{"$f":"Aug!N24","v":0},{"$f":"Sep!N24","v":0},0,{"$f":"Okt!N24","v":0},{"$f":"Nov!N24","v":0},{"$f":"Dez!N24","v":0},0,0]
[{"$f":"Jan!M25","v":"A-leer1"},{"$f":"Jan!N25","v":0},{"$f":"Feb!N25","v":0},{"$f":"Mar!N25","v":0},0,{"$f":"Apr!N25","v":0},{"$f":"Mai!N25","v":0},{"$f":"Jun!N25","v":0},0,{"$f":"Jul!N25","v":0},{"$f":"Aug!N25","v":0},{"$f":"Sep!N25","v":0},0,{"$f":"Okt!N25","v":0},{"$f":"Nov!N25","v":0},{"$f":"Dez!N25","v":0},0,0]
[{"$f":"Jan!M26","v":"A-leer2"},{"$f":"Jan!N26","v":0},{"$f":"Feb!N26","v":0},{"$f":"Mar!N26","v":0},0,{"$f":"Apr!N26","v":0},{"$f":"Mai!N26","v":0},{"$f":"Jun!N26","v":0},{"$f":"SUM(F26:H26)","v":0},{"$f":"Jul!N26","v":0},{"$f":"Aug!N26","v":0},{"$f":"Sep!N26","v":0},{"$f":"SUM(J26:L26)","v":0},{"$f":"Okt!N26","v":0},{"$f":"Nov!N26","v":0},{"$f":"Dez!N26","v":0},{"$f":"SUM(N26:P26)","v":0},{"$f":"E26+I26+M26+Q26","v":0}]
[{"$f":"Jan!M27","v":"A-leer3"},{"$f":"Jan!N27","v":0},{"$f":"Feb!N27","v":0},{"$f":"Mar!N27","v":0},0,{"$f":"Apr!N27","v":0},{"$f":"Mai!N27","v":0},{"$f":"Jun!N27","v":0},0,{"$f":"Jul!N27","v":0},{"$f":"Aug!N27","v":0},{"$f":"Sep!N27","v":0},0,{"$f":"Okt!N27","v":0},{"$f":"Nov!N27","v":0},{"$f":"Dez!N27","v":0},0,0]
[{"$f":"Jan!M29","v":"Handel"},{"$f":"Jan!O29","v":620},{"$f":"Feb!O29","v":0},{"$f":"Mar!O29","v":0},620,{"$f":"Apr!O29","v":0},{"$f":"Mai!O29","v":0},{"$f":"Jun!O29","v":0},0,{"$f":"Jul!O29","v":0},{"$f":"Aug!O29","v":0},{"$f":"Sep!O29","v":0},0,{"$f":"Okt!O29","v":0},{"$f":"Nov!O29","v":0},{"$f":"Dez!O29","v":0},0,{"$f":"E28+I28+M28+Q28","v":620}]
[{"$f":"Jan!M30","v":"Dienstleistungen"},{"$f":"Jan!O30","v":1345.83},{"$f":"Feb!O30","v":0},{"$f":"Mar!O30","v":0},1345.83,{"$f":"Apr!O30","v":0},{"$f":"Mai!O30","v":0},{"$f":"Jun!O30","v":0},0,{"$f":"Jul!O30","v":0},{"$f":"Aug!O30","v":0},{"$f":"Sep!O30","v":0},0,{"$f":"Okt!O30","v":0},{"$f":"Nov!O30","v":0},{"$f":"Dez!O30","v":0},0,{"$f":"E29+I29+M29+Q29","v":1345.83}]
[{"$f":"Jan!M31","v":"Diverse Gutschriften"},{"$f":"Jan!O31","v":0},{"$f":"Feb!O31","v":0},{"$f":"Mar!O31","v":0},{"$f":"SUM(B30:D30)","v":0},{"$f":"Apr!O31","v":0},{"$f":"Mai!O31","v":0},{"$f":"Jun!O31","v":0},{"$f":"SUM(F30:H30)","v":0},{"$f":"Jul!O31","v":0},{"$f":"Aug!O31","v":0},{"$f":"Sep!O31","v":0},{"$f":"SUM(J30:L30)","v":0},{"$f":"Okt!O31","v":0},{"$f":"Nov!O31","v":0},{"$f":"Dez!O31","v":0},{"$f":"SUM(N30:P30)","v":0},0]
[{"$f":"Jan!M32","v":"E-leer1"},{"$f":"Jan!O32","v":0},{"$f":"Feb!O32","v":0},{"$f":"Mar!O32","v":0},{"$f":"SUM(B31:D31)","v":0},{"$f":"Apr!O32","v":0},{"$f":"Mai!O32","v":0},{"$f":"Jun!O32","v":0},{"$f":"SUM(F31:H31)","v":0},{"$f":"Jul!O32","v":0},{"$f":"Aug!O32","v":0},{"$f":"Sep!O32","v":0},{"$f":"SUM(J31:L31)","v":0},{"$f":"Okt!O32","v":0},{"$f":"Nov!O32","v":0},{"$f":"Dez!O32","v":0},{"$f":"SUM(N31:P31)","v":0},0]
[{"$f":"Jan!M33","v":"E-leer2"},{"$f":"Jan!O33","v":0},{"$f":"Feb!O33","v":0},{"$f":"Mar!O33","v":0},{"$f":"SUM(B32:D32)","v":0},{"$f":"Apr!O33","v":0},{"$f":"Mai!O33","v":0},{"$f":"Jun!O33","v":0},{"$f":"SUM(F32:H32)","v":0},{"$f":"Jul!O33","v":0},{"$f":"Aug!O33","v":0},{"$f":"Sep!O33","v":0},{"$f":"SUM(J32:L32)","v":0},{"$f":"Okt!O33","v":0},{"$f":"Nov!O33","v":0},{"$f":"Dez!O33","v":0},{"$f":"SUM(N32:P32)","v":0},0]
[{"$f":"Jan!M34","v":"E-leer3"},{"$f":"Jan!O34","v":0},{"$f":"Feb!O34","v":0},{"$f":"Mar!O34","v":0},{"$f":"SUM(B33:D33)","v":0},{"$f":"Apr!O34","v":0},{"$f":"Mai!O34","v":0},{"$f":"Jun!O34","v":0},{"$f":"SUM(F33:H33)","v":0},{"$f":"Jul!O34","v":0},{"$f":"Aug!O34","v":0},{"$f":"Sep!O34","v":0},{"$f":"SUM(J33:L33)","v":0},{"$f":"Okt!O34","v":0},{"$f":"Nov!O34","v":0},{"$f":"Dez!O34","v":0},{"$f":"SUM(N33:P33)","v":0},{"$f":"E33+I33+M33+Q33","v":0}]
["Summen bzw. Angaben für Ust-VA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B34+C34+D34+F34+G34+H34+J34+K34+L34+N34+O34+P34","v":0}]
["Umsätze brutto",{"$f":"Jan!F50","v":2235},{"$f":"Feb!F50","v":0},{"$f":"Mar!F50","v":0},2235,{"$f":"Apr!F50","v":0},{"$f":"Mai!F50","v":0},{"$f":"Jun!F50","v":0},0,{"$f":"Jul!F50","v":0},{"$f":"Aug!F50","v":0},{"$f":"Sep!F50","v":0},0,{"$f":"Okt!F50","v":0},{"$f":"Nov!F50","v":0},{"$f":"Dez!F50","v":0},0,{"$f":"E35+I35+M35+Q35","v":2235}]
[{"$f":"Jan!M35","v":"Summe Einnahmen *)"},{"$f":"Jan!O35","v":1965.83},{"$f":"Feb!O35","v":0},{"$f":"Mar!O35","v":0},1965.83,{"$f":"Apr!O35","v":0},{"$f":"Mai!O35","v":0},{"$f":"Jun!O35","v":0},0,{"$f":"Jul!O35","v":0},{"$f":"Aug!O35","v":0},{"$f":"Sep!O35","v":0},0,{"$f":"Okt!O35","v":0},{"$f":"Nov!O35","v":0},{"$f":"Dez!O35","v":0},0,{"$f":"E36+I36+M36+Q36","v":1965.83}]
["*) Einnahmen mit 0%",{"$f":"Jan!O36","v":620},{"$f":"Feb!O36","v":""},{"$f":"Mar!O36","v":""},{"$f":"SUM(B37:D37)","v":620},{"$f":"Apr!O36","v":""},{"$f":"Mai!O36","v":""},{"$f":"Jun!O36","v":""},{"$f":"SUM(F37:H37)","v":0},{"$f":"Jul!O36","v":""},{"$f":"Aug!O36","v":""},{"$f":"Sep!O36","v":""},{"$f":"SUM(J37:L37)","v":0},{"$f":"Okt!O36","v":""},{"$f":"Nov!O36","v":""},{"$f":"Dez!O36","v":""},{"$f":"SUM(N37:P37)","v":0},{"$f":"E37+I37+M37+Q37","v":620}]
["*) Einnahmen mit 5%",{"$f":"Jan!O37","v":0},{"$f":"Feb!O37","v":""},{"$f":"Mar!O37","v":""},{"$f":"SUM(B38:D38)","v":0},{"$f":"Apr!O37","v":""},{"$f":"Mai!O37","v":""},{"$f":"Jun!O37","v":""},{"$f":"SUM(F38:H38)","v":0},{"$f":"Jul!O37","v":""},{"$f":"Aug!O37","v":""},{"$f":"Sep!O37","v":""},{"$f":"SUM(J38:L38)","v":0},{"$f":"Okt!O37","v":""},{"$f":"Nov!O37","v":""},{"$f":"Dez!O37","v":""},{"$f":"SUM(N38:P38)","v":0},{"$f":"E38+I38+M38+Q38","v":0}]
["*) Einnahmen mit 10%",{"$f":"Jan!O38","v":0},{"$f":"Feb!O38","v":""},{"$f":"Mar!O38","v":""},0,{"$f":"Apr!O38","v":""},{"$f":"Mai!O38","v":""},{"$f":"Jun!O38","v":""},0,{"$f":"Jul!O38","v":""},{"$f":"Aug!O38","v":""},{"$f":"Sep!O38","v":""},0,{"$f":"Okt!O38","v":""},{"$f":"Nov!O38","v":""},{"$f":"Dez!O38","v":""},0,0]
["*) Einnahmen mit 13%",{"$f":"Jan!O39","v":0},{"$f":"Feb!O39","v":""},{"$f":"Mar!O39","v":""},{"$f":"SUM(B40:D40)","v":0},{"$f":"Apr!O39","v":""},{"$f":"Mai!O39","v":""},{"$f":"Jun!O39","v":""},0,{"$f":"Jul!O39","v":""},{"$f":"Aug!O39","v":""},{"$f":"Sep!O39","v":""},0,{"$f":"Okt!O39","v":""},{"$f":"Nov!O39","v":""},{"$f":"Dez!O39","v":""},0,0]
["*) Einnahmen mit 20%",{"$f":"Jan!O40","v":1345.83},{"$f":"Feb!O40","v":""},{"$f":"Mar!O40","v":""},{"$f":"SUM(B41:D41)","v":1345.83},{"$f":"Apr!O40","v":""},{"$f":"Mai!O40","v":""},{"$f":"Jun!O40","v":""},0,{"$f":"Jul!O40","v":""},{"$f":"Aug!O40","v":""},{"$f":"Sep!O40","v":""},0,{"$f":"Okt!O40","v":""},{"$f":"Nov!O40","v":""},{"$f":"Dez!O40","v":""},0,1345.83]
[{"$f":"Jan!M41","v":"Summe Ausgaben"},{"$f":"Jan!N41","v":-2316.4},{"$f":"Feb!N41","v":0},{"$f":"Mar!N41","v":0},-2316.4,{"$f":"Apr!N41","v":0},{"$f":"Mai!N41","v":0},{"$f":"Jun!N41","v":0},0,{"$f":"Jul!N41","v":0},{"$f":"Aug!N41","v":0},{"$f":"Sep!N41","v":0},0,{"$f":"Okt!N41","v":0},{"$f":"Nov!N41","v":0},{"$f":"Dez!N41","v":0},0,-2316.4]
["Ergebnis",{"$f":"Jan!N42","v":-350.57},{"$f":"Feb!N42","v":0},{"$f":"Mar!N42","v":0},-350.57,{"$f":"Apr!N42","v":0},{"$f":"Mai!N42","v":0},{"$f":"Jun!N42","v":0},0,{"$f":"Jul!N42","v":0},{"$f":"Aug!N42","v":0},{"$f":"Sep!N42","v":0},0,{"$f":"Okt!N42","v":0},{"$f":"Nov!N42","v":0},{"$f":"Dez!N42","v":0},0,-350.57]
["Vorsteuer",{"$f":"Jan!O43","v":318.86},{"$f":"Feb!O43","v":0},{"$f":"Mar!O43","v":0},318.86,{"$f":"Apr!O43","v":0},{"$f":"Mai!O43","v":0},{"$f":"Jun!O43","v":0},0,{"$f":"Jul!O43","v":0},{"$f":"Aug!O43","v":0},{"$f":"Sep!O43","v":0},0,{"$f":"Okt!O43","v":0},{"$f":"Nov!O43","v":0},{"$f":"Dez!O43","v":0},0,318.86]
[{"$f":"Jan!M44","v":"Umsatzsteuer"},{"$f":"Jan!O44","v":269.17},{"$f":"Feb!O44","v":0},{"$f":"Mar!O44","v":0},269.17,{"$f":"Apr!O44","v":0},{"$f":"Mai!O44","v":0},{"$f":"Jun!O44","v":0},0,{"$f":"Jul!O44","v":0},{"$f":"Aug!O44","v":0},{"$f":"Sep!O44","v":0},0,{"$f":"Okt!O44","v":0},{"$f":"Nov!O44","v":0},{"$f":"Dez!O44","v":0},0,269.17]
["Zahllast FA",{"$f":"Jan!O45","v":-49.69},{"$f":"Feb!O45","v":0},{"$f":"Mar!O45","v":0},-49.69,{"$f":"Apr!O45","v":0},{"$f":"Mai!O45","v":0},{"$f":"Jun!O45","v":0},0,{"$f":"Jul!O45","v":0},{"$f":"Aug!O45","v":0},{"$f":"Sep!O45","v":0},0,{"$f":"Okt!O45","v":0},{"$f":"Nov!O45","v":0},{"$f":"Dez!O45","v":0},0,-49.69]
[]
[]
["Umsatz- & Ergebnisentwicklung"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["AUSGABEN",null,null,null,null,null,null,null,null,"EINNAHMEN"]