{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["USt.Verpr","__Goal_Metadata"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":1,"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":"USt.Verpr","index":0,"n_rows":92,"n_cols":7,"rows_kept":92,"cut":false,"hidden":false,"merged":[[101,0,101,3],[102,0,102,3],[94,0,94,3],[95,0,95,3],[96,0,96,3],[97,0,97,3],[98,0,98,3],[100,0,100,3],[91,0,91,3],[99,0,99,3],[74,0,74,1],[16,0,16,1],[57,0,57,2],[58,0,58,2],[72,0,72,1],[67,0,67,2],[61,0,61,2],[23,0,23,1],[73,0,73,1],[70,0,70,3],[69,0,69,3],[30,0,30,1],[29,0,29,1],[54,0,54,3],[64,0,64,2],[66,0,66,2],[2,5,4,5],[2,3,4,3],[6,0,6,1],[17,0,17,1],[8,0,8,1],[19,0,19,1],[7,0,7,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[15,0,15,1],[26,0,26,1],[22,0,22,1],[24,0,24,1],[2,0,4,1],[21,0,21,1],[18,0,18,1],[25,0,25,1]]}
[]
[]
[null,null,null,"Umsatzsteuer-Abrechnung",null,{"$f":"G3","v":2016},2016]
[]
[]
[]
["Berechnung der Umsatzsteuer",null,null,"Bemessungsgrundlage",null,"Steuer"]
[" "]
[" ",null,null,{"$f":"IF(G3>2001,\"Euro\",\"DM\")","v":"Euro"},null,{"$f":"D9","v":"Euro"}]
[]
["Innergemeinschaftl. Lieferung § 4 Nr. 1 b"]
["Exporte in Drittländer § 4 Nr. 1 a"]
["sonstige steuerfr. Umsätze § 4 Nr."]
["nicht steuerbare Umsätze"]
["Erlöse aus Leistungen nach § 13 b "]
[{"$f":"\"Umsatzerlöse \"&IF(Jahr<2007,\"16%\",\"19%\")","v":"Umsatzerlöse 19%"},null,null,{"$f":"IF(F16=\"\",\"\",ROUND(F16/RIGHT(A16,3),2))","v":""}]
[{"$f":"\"unentgeltliche Wertabgaben \"&IF(Jahr<2007,\"16%\",\"19%\")","v":"unentgeltliche Wertabgaben 19%"},null,null,{"$f":"IF(F17=\"\",\"\",ROUND(F17/RIGHT(A17,3),2))","v":""}]
[{"$f":"\"Umsatzerlöse \"&IF(Jahr<2007,\"15%\",\"16%\")","v":"Umsatzerlöse 16%"},null,null,""]
[{"$f":"\"unentgeltliche Wertabgaben \"&IF(Jahr<2007,\"15%\",\"16%\")","v":"unentgeltliche Wertabgaben 16%"},null,null,""]
["Umsatzerlöse   7%",null,null,""]
["unentgeltliche Wertabgaben 7%",null,null,""]
[{"$f":"\"Innergemeinschaftlicher Erwerb \"&IF(Jahr<2007,\"16%\",\"19%\")","v":"Innergemeinschaftlicher Erwerb 19%"},null,null,""]
[{"$f":"\"Innergemeinschaftlicher Erwerb \"&IF(Jahr<2007,\"15%\",\"16%\")","v":"Innergemeinschaftlicher Erwerb 16%"},null,null,""]
["Innergemeinschaftlicher Erwerb   7%",null,null,""]
[{"$f":"\"Umsätze nach § 13 b UStG (EU) \"&IF(Jahr<2007,\"16%\",\"19%\")","v":"Umsätze nach § 13 b UStG (EU) 19%"},null,null,""]
[{"$f":"\"Umsätze nach § 13 b UStG (Drittland) \"&IF(Jahr<2007,\"16%\",\"19%\")","v":"Umsätze nach § 13 b UStG (Drittland) 19%"},null,null,""]
[{"$f":"\"Umsätze nach § 13 b UStG (Inland) \"&IF(Jahr<2007,\"16%\",\"19%\")","v":"Umsätze nach § 13 b UStG (Inland) 19%"},null,null,""]
[null,null,null,{"$f":"IF(SUM(D11:D27)=0,\"\",SUM(D11:D27))","v":""},null,{"$f":"SUM(F11:F27)","v":0}]
[]
["Verprobung Gesamtumsatz",null,null,{"$f":"IF(D28=0,\"\",D28)","v":""}]
[" "]
[]
["Konto"]
[null,"Umsatzerlöse lt. G. u. V."]
[4860,"Grundstückserträge",null," "]
[4645,"Kfz-Nutzung",null," "]
[4646,"Telefon-Nutzung",null," "]
[4845,"Anlagenverkäufe",null," "]
[4925,"Ertr. abgeschriebene Forderungen",null," "]
[4831,"sonstige betriebliche Erträge",null," "]
[]
[6935,"Forderungsverluste 16%",null," "]
[6936,"Forderungsverluste 19%"]
[]
[3270,{"$f":"\"Anzahlungen Vortrag 01.01.\"&F3","v":"Anzahlungen Vortrag 01.01.2016"},null," "]
[3270,{"$f":"\"Anzahlungen Stand   31.12.\"&F3","v":"Anzahlungen Stand   31.12.2016"},null," "]
[null,null,null," "]
[5425,"Innergemeinschaftlicher Erwerb",null," "]
[null,null,null," "]
[5920,"Umsätze nach § 13 b UStG"]
[]
[null,"Rundungsdifferenz",null,{"$f":"IF(ABS(SUM(D30:D51))<2,-SUM(D30:D51),\"\")","v":0}]
[null,{"$f":"IF(OR(ROUND(SUM(D30:D52),2)=0,D53=\"\"),\"\",\"Abstimmungsdiff. suchen !!\")","v":""},null,{"$f":"IF(D30=\"\",\"\",SUM(D30:D52))","v":""}]
[]
[{"$f":"\"Berechnung \"&IF(F67<0,\"Erstattungsanspruch\",\"Nachzahlung\")","v":"Berechnung Nachzahlung"},null,null,null,null,{"$f":"D9","v":"Euro"}]
[]
[]
["Umsatzsteuer",null,null,null,null,{"$f":"F28","v":0}]
[" "]
["Vorsteuer § 15 (1), 1 UStG",null,null,null,null,0]
["Vorsteuer innergemeinschaftl. Erwerb",null,null,null,null,0]
["Einfuhrumsatzsteuer",null,null,null,null,0]
["Vorsteuer nach § 13 b UStG",null,null,null,null,0]
["nachträgl. abziehb. Vorsteuer nach § 15 a UStG f. bewegl.Wirtschaftsgüter",null,null,null,null,0]
[{"$f":"IF(F65<0,\"Überschuss\",\"Schuld\")","v":"Schuld"},null,null,null,null,{"$f":"F58-SUM(F59:INDIRECT(\"F\"&ROW()-1))","v":0}]
["Vorauszahlungs-Soll (Übereinstimmung mit Konten 3820/3830)",null,null,null,null,0]
[{"$f":"IF(F67<0,\"Erstattungsanspruch\",\"Nachzahlung\")","v":"Nachzahlung"},null,null,null,null,{"$f":"F65-F66","v":0}]
[]
[]
[{"$f":"\"Nachweis \"&IF(F67<0,\"Erstattungsanspruch\",\"Nachzahlung\")","v":"Nachweis Nachzahlung"}]
[]
[]
["nicht abgegebene USt.-VA lt. Abr.Nr."]
["nicht abgegebene USt.-VA lt. Abr.Nr."]
[]
["Konto",null," ","AB-Nr."]
[" "," "," "," "]
[" "," "," "," "]
[" "," "," "," "]
[" "," "," "," "]
[null,null," "]
[null,null," ",null,null," "]
[null,null," ",null,null," "]
[null,null," ",null,null," "]
[null,null," "]
[null,null," "]
[null,null,null,null,null,{"$f":"IF(COUNT(F73:INDIRECT(\"F\"&ROW()-1))=0,\"\",SUM(F73:INDIRECT(\"F\"&ROW()-1)))","v":""}]
[{"$f":"\"lt. Berechnung \"&IF(F67<0,\"Erstattungsanspruch\",\"Nachzahlung\")","v":"lt. Berechnung Nachzahlung"},null,null,null,null,{"$f":"-F67","v":0}]
[{"$f":"IF(D9=\"DM\",\"Differenz (Beträge unter DM 100,00 nicht suchen)\",\"Differenz (Beträge unter 50,00 Euro nicht suchen)\")","v":"Differenz (Beträge unter 50,00 Euro nicht suchen)"},null,null,null,null,{"$f":"IF(AND(F87=\"\",F88=\"\"),\"\",SUM(F87:F88))","v":0}]
[]
[]
["Wichtige Einzelpositionen"]

{"sheet":"__Goal_Metadata","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["_KAW999934","J"]
["_KAW999929","b312ac36-b004-481d-be9e-8c7af6e8c59e"]