{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Anleitung","1. Quartal 1.1.-31.3.","2. Quartal 1.4.-30.6.","3. Quartal 1.7.-30.9.","4. Quartal 1.10.-31.12.","Jahreserklärungen"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Anleitung","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Anleitung:"]
["Als erstes das Datum und den Betrag eingeben."]
["Danach bei \"Aktion wählen\" mit der rechten Maustaste reinklicken und die gewünschte Operation auswählen."]
["Danach bei \"Art wählen\" mit der rechten Maustaste reinklicken und die gewünschte Kennzahl /  Verwendung auswählen."]
["Fertig."]
[]
["Erweitert:"]
["Die ganzen Werte sind gegliedert und somit ausgeblendet."]
["Soll alle Werte angezeigt werden einfach auf das PLUS oben klicken."]
["Danach wird alles eingeblendet."]
["Wieder ausblenden: Einfach auf das MINUS klicken."]
[]
["Feld \"OK\":"]
["Es wird \"OK\" angezeigt, wenn die Werte im Hintergrund nochmals auf Richtigkeit geprüft wurden."]
["Es wird \"NOK\" angezeigt, wenn die Werte im Hintergrund nochmals auf FALSCHHEIT geprüft wurden."]

{"sheet":"1. Quartal 1.1.-31.3.","index":1,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[89,4,89,19]]}
["OK","Datum","Betrag","Aktion wählen","Art wählen","Bezeichnung","Ein. netto 20%","Mwst 10%","Mwst 20%","Innerg. Ein.","Ein. Ohne","Ausg.netto 10%","Ausg.netto 20%","Vst 10%","Vst 20%","Innerg. Ausg.","Ausg.Ohne","Eust.","Ein. netto 19%","Mwst 19%"]
[{"$f":"IF(C2=SUM(E2:AA2),\"OK\",\"NOK\")","v":"OK"},"2021-01-01",100,"ZE BRUTTO 19",null,"Ausgabe 0815",null,null,null,null,null,null,null,null,null,null,null,null,null,84.033613445378151,15.966386554621849]
[{"$f":"IF(C3=SUM(E3:AA3),\"OK\",\"NOK\")","v":"OK"},"1923-02-02",200,"ZA BRUTTO 20",null,"Einnahme 33",null,null,null,null,null,null,null,166.66666666666669,null,33.333333333333336]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[{"$f":"IF(C67=SUM(E67:AA67),\"OK\",\"NOK\")","v":"OK"}]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[null,null,null,null,"",null,null,null,null,null,null,""]
[null,"Kennzahl 000 :",{"$f":"E91 + G91 +J91","v":0},null,"Summen:"]
[null,"Kennzahl 017:",{"$f":"J91","v":0},null,{"$f":"SUM(E2:E89)","v":0},null,0,0,0,0,0,0,0,166.66666666666669,0,33.333333333333336,0,0,{"$f":"SUM(S2:S88)","v":0},{"$f":"SUM(T2:T88)","v":84.033613445378151}]
[null,"Kennzahl 022:",{"$f":"G91","v":0}]
[null,"Kennzahl 029:",{"$f":"E91","v":0}]
[null,"Kennzahl 070:",{"$f":"P91","v":33.333333333333336}]
[null,"Kennzahl 072:",{"$f":"P91","v":33.333333333333336}]
[null,"Kennzahl 060:",{"$f":"N91 + O91","v":166.66666666666669}]
[null,"Kennzahl 061:",{"$f":"R91","v":0}]
[null,"Kennzahl 065:",{"$f":"P91 *0.2","v":6.6666666666666679}]
[]
[null,"Zahlung zirka:",{"$f":"H91 + I91 -N91 -O91 - R91","v":-166.66666666666669}]
[null,"Gewinn:",{"$f":"E91 +G91 +J91 +K91 -L91 -M91-P91-Q91","v":-33.333333333333336}]

{"sheet":"2. Quartal 1.4.-30.6.","index":2,"n_rows":104,"n_cols":21,"rows_kept":104,"cut":false,"hidden":false,"merged":[[92,6,92,20]]}
["OK","Datum","Betrag","Aktion wählen","Art wählen","Bezeichnung","Ein. netto 10%","Ein. netto 20%","Mwst 10%","Mwst 20%","Innerg. Ein.","Ein. Ohne","Ausg.netto 10%","Ausg.netto 20%","Vst 10%","Vst 20%","Innerg. Ausg.","Ausg.Ohne","Eust.","Ein. netto 19%","Mwst 19%"]
[{"$f":"IF(C2=SUM(E2:Z2),\"OK\",\"NOK\")","v":"OK"},null,null,null,null,""]
[{"$f":"IF(C3=SUM(G3:S3),\"OK\",\"NOK\")","v":"OK"},null,null,null,null,""]
["OK",null,null,null,null,""]
["OK",null,null,null,null,""]
["OK",null,null,null,null,""]
["OK",null,null,null,null,""]
["OK",null,null,null,null,""]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK",null,null,null,null,""]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[{"$f":"IF(C27=SUM(G27:S27),\"OK\",\"NOK\")","v":"OK"}]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[{"$f":"IF(C59=SUM(G59:S59),\"OK\",\"NOK\")","v":"OK"}]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[{"$f":"IF(C83=SUM(G83:S83),\"OK\",\"NOK\")","v":"OK"}]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[{"$f":"IF(C91=SUM(G91:S91),\"OK\",\"NOK\")","v":"OK"},null,null,null,null,""]
[null,null,null,null,null,"","",null,null,null,null,null,""]
[null,"Kennzahl 000 :",{"$f":"G94 + H94 +K94","v":0},null,null,"Alle Umsätze","Summen:"]
[null,"Kennzahl 017:",{"$f":"K94","v":0},null,null,"Innergemeinschaftliche Einnahmen",{"$f":"SUM(G2:G92)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T2:T92)","v":0},0]
[null,"Kennzahl 022:",{"$f":"H94","v":0},null,null,"Umsatz was mit 20% Besteuert wird"]
[null,"Kennzahl 029:",{"$f":"G94","v":0},null,null,"Umsatz was mit 10% Besteuert wird"]
[null,"Kennzahl 070:",{"$f":"Q94","v":0},null,null,"Gesamtbetrag aus den Innergemein. Ausgaben"]
[null,"Kennzahl 072:",{"$f":"Q94","v":0},null,null,"Innergemein. Ausgaben mit 20% besteuern"]
[null,"Kennzahl 060:",{"$f":"O94 + P94","v":0},null,null,"Alle Vorsteuern zusammen"]
[null,"Kennzahl 061:",{"$f":"S94","v":0},null,null,"Einfuhrumsatzsteuer"]
[null,"Kennzahl 065:",{"$f":"Q94 *0.2","v":0},null,null,"Vorsteuern aus dem Innergemein. Ausgaben"]
[]
[null,"Zahlung zirka:",{"$f":"I94 + J94 -O94 -P94 - S94","v":0}]
[null,"Gewinn:",{"$f":"G94 +H94 +K94 +L94 -M94 -N94-Q94-R94","v":0}]

{"sheet":"3. Quartal 1.7.-30.9.","index":3,"n_rows":86,"n_cols":21,"rows_kept":86,"cut":false,"hidden":false,"merged":[[74,6,74,20]]}
["OK","Datum","Betrag","Aktion wählen","Art wählen","Bezeichnung","Ein. netto 10%","Ein. netto 20%","Mwst 10%","Mwst 20%","Innerg. Ein.","Ein. Ohne","Ausg.netto 10%","Ausg.netto 20%","Vst 10%","Vst 20%","Innerg. Ausg.","Ausg.Ohne","Eust.","Ein. netto 19%","Mwst 19%"]
[{"$f":"IF(C2=SUM(G2:S2),\"OK\",\"NOK\")","v":"OK"},null,null,null,null,""]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[{"$f":"IF(C66=SUM(G66:S66),\"OK\",\"NOK\")","v":"OK"}]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[null,null,null,null,null,"","",null,null,null,null,null,""]
[null,"Kennzahl 000 :",{"$f":"G76 + H76 +K76","v":0},null,null,"Alle Umsätze","Summen:"]
[null,"Kennzahl 017:",{"$f":"K76","v":0},null,null,"Innergemeinschaftliche Einnahmen",{"$f":"SUM(G2:G74)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T2:T74)","v":0},{"$f":"SUM(U2:U74)","v":0}]
[null,"Kennzahl 022:",{"$f":"H76","v":0},null,null,"Umsatz was mit 20% Besteuert wird"]
[null,"Kennzahl 029:",{"$f":"G76","v":0},null,null,"Umsatz was mit 10% Besteuert wird"]
[null,"Kennzahl 070:",{"$f":"Q76","v":0},null,null,"Gesamtbetrag aus den Innergemein. Ausgaben"]
[null,"Kennzahl 072:",{"$f":"Q76","v":0},null,null,"Innergemein. Ausgaben mit 20% besteuern"]
[null,"Kennzahl 060:",{"$f":"O76 + P76","v":0},null,null,"Alle Vorsteuern zusammen"]
[null,"Kennzahl 061:",{"$f":"S76","v":0},null,null,"Einfuhrumsatzsteuer"]
[null,"Kennzahl 065:",{"$f":"Q76 *0.2","v":0},null,null,"Vorsteuern aus dem Innergemein. Ausgaben"]
[]
[null,"Zahlung zirka:",{"$f":"I76 + J76 -O76 -P76 - S76","v":0}]
[null,"Gewinn:",{"$f":"G76 +H76 +K76 +L76 -M76 -N76-Q76-R76","v":0}]

{"sheet":"4. Quartal 1.10.-31.12.","index":4,"n_rows":281,"n_cols":21,"rows_kept":281,"cut":false,"hidden":false,"merged":[[269,6,269,20]]}
["OK","Datum","Betrag","Aktion wählen","Art wählen","Bezeichnung","Ein. netto 10%","Ein. netto 20%","Mwst 10%","Mwst 20%","Innerg. Ein.","Ein. Ohne","Ausg.netto 10%","Ausg.netto 20%","Vst 10%","Vst 20%","Innerg. Ausg.","Ausg.Ohne","Eust.","Ein. netto 19%","Mwst 19%"]
[{"$f":"IF(C2=SUM(G2:S2),\"OK\",\"NOK\")","v":"OK"},null,null,"",null,""]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[{"$f":"IF(C77=SUM(G77:S77),\"OK\",\"NOK\")","v":"OK"}]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[{"$f":"IF(C141=SUM(G141:S141),\"OK\",\"NOK\")","v":"OK"}]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
[{"$f":"IF(C205=SUM(G205:S205),\"OK\",\"NOK\")","v":"OK"}]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK"]
["OK",null,null,"",null,""]
["OK",null,null,null,null,""]
["OK",null,null,null,null,""]
["OK",null,null,null,null,""]
[null,null,null,null,null,"","",null,null,null,null,null,""]
[null,"Kennzahl 000 :",{"$f":"G271 + H271 +K271","v":0},null,null,"Alle Umsätze","Summen:"]
[null,"Kennzahl 017:",{"$f":"K271","v":0},null,null,"Innergemeinschaftliche Einnahmen",{"$f":"SUM(G2:G269)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T2:T269)","v":0},{"$f":"SUM(U2:U269)","v":0}]
[null,"Kennzahl 022:",{"$f":"H271","v":0},null,null,"Umsatz was mit 20% Besteuert wird"]
[null,"Kennzahl 029:",{"$f":"G271","v":0},null,null,"Umsatz was mit 10% Besteuert wird"]
[null,"Kennzahl 070:",{"$f":"Q271","v":0},null,null,"Gesamtbetrag aus den Innergemein. Ausgaben"]
[null,"Kennzahl 072:",{"$f":"Q271","v":0},null,null,"Innergemein. Ausgaben mit 20% besteuern"]
[null,"Kennzahl 060:",{"$f":"O271 + P271","v":0},null,null,"Alle Vorsteuern zusammen"]
[null,"Kennzahl 061:",{"$f":"S271","v":0},null,null,"Einfuhrumsatzsteuer"]
[null,"Kennzahl 065:",{"$f":"Q271 * 0.2","v":0},null,null,"Vorsteuern aus dem Innergemein. Ausgaben"]
[]
[null,"Zahlung zirka:",{"$f":"I271 + J271 -O271 -P271 - S271","v":0}]
[null,"Gewinn:",{"$f":"G271 +H271 +K271 +L271 -M271 -N271-Q271-R271","v":0}]

{"sheet":"Jahreserklärungen","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"U1 Erklärung"]
[null,"Kennzahl 000 :",{"$f":"'1. Quartal 1.1.-31.3.'!C90 + '2. Quartal 1.4.-30.6.'!C93 + '3. Quartal 1.7.-30.9.'!C75 + '4. Quartal 1.10.-31.12.'!C270","v":0},"Alle Umsätze"]
[null,"Kennzahl 017:",{"$f":"'1. Quartal 1.1.-31.3.'!C91 + '2. Quartal 1.4.-30.6.'!C94 + '3. Quartal 1.7.-30.9.'!C76 + '4. Quartal 1.10.-31.12.'!C271","v":0},"Innergemeinschaftliche Einnahmen"]
[null,"Kennzahl 022:",{"$f":"'1. Quartal 1.1.-31.3.'!C92 + '2. Quartal 1.4.-30.6.'!C95 + '3. Quartal 1.7.-30.9.'!C77 + '4. Quartal 1.10.-31.12.'!C272","v":0},"Umsatz was mit 20% Besteuert wird"]
[null,"Kennzahl 029:",{"$f":"'1. Quartal 1.1.-31.3.'!C93 + '2. Quartal 1.4.-30.6.'!C96 + '3. Quartal 1.7.-30.9.'!C78 + '4. Quartal 1.10.-31.12.'!C273","v":0},"Umsatz was mit 10% Besteuert wird"]
[null,"Kennzahl 070:",{"$f":"'1. Quartal 1.1.-31.3.'!C94 + '2. Quartal 1.4.-30.6.'!C97 + '3. Quartal 1.7.-30.9.'!C79 + '4. Quartal 1.10.-31.12.'!C274","v":33.333333333333336},"Gesamtbetrag aus den Innergemein. Ausgaben"]
[null,"Kennzahl 072:",{"$f":"'1. Quartal 1.1.-31.3.'!C95 + '2. Quartal 1.4.-30.6.'!C98 + '3. Quartal 1.7.-30.9.'!C80 + '4. Quartal 1.10.-31.12.'!C275","v":33.333333333333336},"Innergemein. Ausgaben mit 20% besteuern"]
[null,"Kennzahl 060:",{"$f":"'1. Quartal 1.1.-31.3.'!C96 + '2. Quartal 1.4.-30.6.'!C99 + '3. Quartal 1.7.-30.9.'!C81 + '4. Quartal 1.10.-31.12.'!C276","v":166.66666666666669},"Alle Vorsteuern zusammen"]
[null,"Kennzahl 061:",{"$f":"'1. Quartal 1.1.-31.3.'!C97 + '2. Quartal 1.4.-30.6.'!C100 + '3. Quartal 1.7.-30.9.'!C82 + '4. Quartal 1.10.-31.12.'!C277","v":0},"Einfuhrumsatzsteuer"]
[null,"Kennzahl 065:",{"$f":"'1. Quartal 1.1.-31.3.'!C98 + '2. Quartal 1.4.-30.6.'!C101 + '3. Quartal 1.7.-30.9.'!C83 + '4. Quartal 1.10.-31.12.'!C278","v":6.6666666666666679},"Vorsteuern aus dem Innergemein. Ausgaben"]