{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Bestandsschutz","ab 1. Oktober 2022","ab Oktober Sachsen","Mehrfachbeschäftigung","Unterschreitung 450_520€","Bestandsschutz ab 1.1.2023","ab 1.1.2023","Veröffentlichung"],"not_rendered":{"charts":0,"images":10,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Bestandsschutz","index":0,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"für Arbeitnehmer im Übergangsbereich von 450,01 bis 520,00 €, deren Beschäftigungsverhältnis bereits bestanden hat",null,null,null,"Beitrag","Satz","halber Satz",null,null,"PV-Beitragszuschlag Kinderlose",null,null,3.5000000000000001E-3]
[null,"AE","Arbeitsentgelt",null,510,"KV",0.14599999999999999,{"$f":"G2/2","v":7.2999999999999995E-2}]
[null,"G","Geringfügigkeitsgrenze",null,520,"ZB",1.4999999999999999E-2,7.4999999999999997E-3]
[{"$nulls":4},1300,"RV",0.186,9.2999999999999999E-2]
[null,"F",0.75090000000000001,"(30% ./. GSV-Beitragssatz)","bis 30.09.2022","AV",2.4E-2,1.2E-2]
[null,"F",0.70089999999999997,"(28% ./. GSV-Beitragssatz)","ab 01.10.2022","PV",3.0499999999999999E-2,1.525E-2]
[]
[{"$nulls":5},"PV-Zuschlag",3.5000000000000001E-3,1.75E-3]
["A","Gesamtbeitrag je Versicherungszweig",null,"aus der beitragspflichtigen Einnahme, die sich nach der Formel (rechts) ermittelt: ",null,null,null,"Gesamtbeitrag",null,null,"Beitragspflichtige Einnahme "]
[{"$nulls":4},"BE (Gesamt)","max. 1.600€!!",{"$nulls":4},"Kurzformel"]
[{"$nulls":5},{"$f":"ROUND(E2*K11+N11,2)","v":405.82},{"$nulls":4},1.1318764699999999,"x","AE",-171.439412]
[null,"Ermittlung des Gesamtbeitrages"]
[null,"Beitragspflichtige Einnahme","x","halber Beitragssatz","ergibt halber Beitrag","kaufmännisch runden","x2",null,null,null,"zur Ermittlung der Beitragspflichtigen Einnahme"]
[null,{"$f":"F11","v":405.82},"KV",{"$f":"H2","v":7.2999999999999995E-2},{"$f":"B14*D14","v":29.624859999999998},{"$f":"ROUND(E14,2)","v":29.62},{"$f":"F14*2","v":59.24}]
[null,null,"ZB",{"$f":"H3","v":7.4999999999999997E-3},{"$f":"B14*D15","v":3.04365},{"$f":"ROUND(E15,2)","v":3.04},{"$f":"F15*2","v":6.08},{"$f":"SUM(G14:G15)","v":65.320000000000007}]
[]
[null,null,"RV",{"$f":"H4","v":9.2999999999999999E-2},{"$f":"B14*D17","v":37.741259999999997},{"$f":"ROUND(E17,2)","v":37.74},{"$f":"F17*2","v":75.48},{"$f":"F17*2","v":75.48}]
[null,null,"AV",{"$f":"H5","v":1.2E-2},{"$f":"B14*D18","v":4.8698399999999999},{"$f":"ROUND(E18,2)","v":4.87},{"$f":"F18*2","v":9.74},{"$f":"G18","v":9.74}]
[null,null,"PV",{"$f":"H6","v":1.525E-2},{"$f":"B14*D19","v":6.1887549999999996},{"$f":"ROUND(E19,2)","v":6.19},{"$f":"F19*2","v":12.38},{"$f":"F19*2","v":12.38}]
[null,null,"PV-Zuschlag",{"$f":"G8","v":3.5000000000000001E-3},null,null,null,{"$f":"G8*B14","v":1.4203699999999999}]
[{"$nulls":7},{"$f":"SUM(H15:H20)","v":164.34037000000001}]
[{"$nulls":8},"(Gesamtbeitrag ./. Arbeitgeber-Anteil)"]
["B","Beitragsanteil Arbeitgeber","aus dem tatsächlichen Arbeitsentgelt",null,null,{"$f":"E2","v":510},null,"Arbeitgeber-Anteil","Arbeitnehmer-","(A - B = C)"]
[{"$nulls":8},"Anteile","C"]
[null,"tatsächliches Arbeitsentgelt",null,"halber Beitragssatz","ergibt halber Beitrag",null,null,null,"siehe Entgeltabrechnung"]
[null,{"$f":"F23","v":510},"KV",{"$f":"D14","v":7.2999999999999995E-2},{"$f":"B26*D26","v":37.229999999999997},{"$f":"ROUND(E26,2)","v":37.229999999999997},null,null,{"$f":"G14-F26","v":22.010000000000005}]
[null,null,"ZB",{"$f":"D15","v":7.4999999999999997E-3},{"$f":"B26*D27","v":3.8249999999999997},{"$f":"ROUND(E27,2)","v":3.83},null,{"$f":"SUM(F26:F27)","v":41.059999999999995},{"$f":"G15-F27","v":2.25},{"$f":"SUM(I26:I27)","v":24.260000000000005}]
[]
[null,null,"RV",{"$f":"H4","v":9.2999999999999999E-2},{"$f":"B26*D29","v":47.43},{"$f":"ROUND(E29,2)","v":47.43},null,{"$f":"F29","v":47.43},null,{"$f":"H17-H29","v":28.050000000000004}]
[null,null,"AV",{"$f":"H5","v":1.2E-2},{"$f":"B26*D30","v":6.12},{"$f":"ROUND(E30,2)","v":6.12},null,{"$f":"F30","v":6.12},null,{"$f":"H18-H30","v":3.62}]
[null,null,"PV",{"$f":"H6","v":1.525E-2},{"$f":"B26*D31","v":7.7774999999999999},{"$f":"ROUND(E31,2)","v":7.78},null,{"$f":"F31","v":7.78},{"$f":"H19-H31","v":4.6000000000000005}]
[{"$nulls":8},{"$f":"B14*G8","v":1.4203699999999999},{"$f":"SUM(I31:I32)","v":6.0203700000000007}]

{"sheet":"ab 1. Oktober 2022","index":1,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"ab Oktober 2022",null,null,null,"Beitrag","Satz","halber Satz",null,null,"für:"]
[null,"AE","Arbeitsentgelt",null,1100,"KV",0.14599999999999999,{"$f":"G2/2","v":7.2999999999999995E-2},null,"1)","neue Midi-Jobs ab Oktober 2022"]
[null,"G","Geringfügigkeitsgrenze",null,520,"ZB",1.4999999999999999E-2,7.4999999999999997E-3,null,"2)","und bei Erhöhung des Durchschnittsentgeltes über 520,00 € (dauerhaft)"]
[{"$nulls":4},1600,"RV",0.186,9.2999999999999999E-2]
[null,"F",0.75090000000000001,"(30% ./. GSV-Beitragssatz)","bis 30.09.2022","AV",2.4E-2,1.2E-2]
[null,"F",0.70089999999999997,"(28% ./. GSV-Beitragssatz)","ab 01.10.2022","PV",3.0499999999999999E-2,1.525E-2]
[null,null,null,"für Kinderlose AN",null,"PV-Zuschlag",3.5000000000000001E-3]
[]
["A","Gesamtbeitrag je Versicherungszweig",null,"aus der beitragspflichtigen Einnahme, die sich nach der Formel (rechts) ermittelt: ",null,null,null,"Gesamtbeitrag"]
[null,"Ermittlung der Beitragspflichtigen Einnahme für den Gesamtbeitrag",null,null,"BE (Gesamt)"]
[{"$nulls":5},{"$f":"ROUND(E2*K13+N13,2)","v":1027.99}]
[null,"Ermittlung des Gesamtbeitrages",{"$nulls":8},"Kurzformel"]
[null,"Beitragspflichtige Einnahme","x","halber Beitragssatz","ergibt halber Beitrag","kaufmännisch runden","x2",null,null,null,1.1440111111,"x","AE",-230.4177777777]
[null,{"$f":"F11","v":1027.99},"KV",{"$f":"H2","v":7.2999999999999995E-2},{"$f":"B14*D14","v":75.043269999999993},{"$f":"ROUND(E14,2)","v":75.040000000000006},{"$f":"F14*2","v":150.08000000000001}]
[null,null,"ZB",{"$f":"H3","v":7.4999999999999997E-3},{"$f":"B14*D15","v":7.7099250000000001},{"$f":"ROUND(E15,2)","v":7.71},{"$f":"F15*2","v":15.42},{"$f":"SUM(G14:G15)","v":165.5},null,null,"zur Ermittlung der Beitragspflichtigen Einnahme "]
[]
[null,null,"RV",{"$f":"H4","v":9.2999999999999999E-2},{"$f":"B14*D17","v":95.603070000000002},{"$f":"ROUND(E17,2)","v":95.6},{"$f":"F17*2","v":191.2},{"$f":"F17*2","v":191.2}]
[null,null,"AV",{"$f":"H5","v":1.2E-2},{"$f":"B14*D18","v":12.33588},{"$f":"ROUND(E18,2)","v":12.34},{"$f":"F18*2","v":24.68},{"$f":"G18","v":24.68}]
[null,null,"PV",{"$f":"H6","v":1.525E-2},{"$f":"B14*D19","v":15.676847499999999},{"$f":"ROUND(E19,2)","v":15.68},{"$f":"F19*2","v":31.36},{"$f":"F19*2","v":31.36}]
[null,null,"PV-Zuschlag",{"$f":"G7","v":3.5000000000000001E-3},null,null,null,{"$f":"D20*B14","v":3.5979650000000003},{"$f":"SUM(H19:H20)","v":34.957965000000002}]
["B","Beitragsanteil Arbeitnehmer",{"$nulls":5},"Arbeitnehmer-Anteil","Arbeitgeber-Anteil"]
[null,"Ermittlung der Beitragspflichtigen Einnahme für den Arbeitnehmeranteil",null,null,"BE (AN-Anteil)",{"$f":"ROUND(E2*K25+N25,4)","v":859.25930000000005}]
[null,"Ermittlung des Arbeitnehmeranteils",{"$nulls":6},"(GSV-Beitrag ./. Arbeitnehmer-Anteil)"]
[null,"Beitragspflichtige Einnahme    X",null,"halber Beitragssatz","ergibt halber Beitrag","kaufmännisch runden",{"$nulls":4},"Kurzformel"]
[null,{"$f":"F22","v":859.25930000000005},"KV",{"$f":"D14","v":7.2999999999999995E-2},{"$f":"B25*D25","v":62.7259289},{"$f":"ROUND(E25,2)","v":62.73},null,null,{"$f":"G14-F25","v":87.350000000000023},null,1.4814814813999999,"x","AE",-770.37037037029995]
[null,null,"ZB",{"$f":"D15","v":7.4999999999999997E-3},{"$f":"B25*D26","v":6.4444447499999997},{"$f":"ROUND(E26,2)","v":6.44},null,{"$f":"SUM(F25:F26)","v":69.17},{"$f":"G15-F26","v":8.98},{"$f":"SUM(I25:I26)","v":96.330000000000027}]
[{"$nulls":10},"zur Ermittlung der Beitragspflichtigen Einnahme "]
[null,null,"RV",{"$f":"H4","v":9.2999999999999999E-2},{"$f":"F22*D28","v":79.911114900000001},{"$f":"ROUND(E28,2)","v":79.91},null,{"$f":"F28","v":79.91},null,{"$f":"G17-H28","v":111.28999999999999}]
[null,null,"AV",{"$f":"H5","v":1.2E-2},{"$f":"F22*D29","v":10.3111116},{"$f":"ROUND(E29,2)","v":10.31},null,{"$f":"F29","v":10.31},null,{"$f":"H18-H29","v":14.37}]
[]
[null,"Arbeitnehmer-Anteil","PV",{"$f":"H6","v":1.525E-2},{"$f":"F22*D31","v":13.103704325000001},{"$f":"ROUND(E31,2)","v":13.1},null,{"$f":"F31","v":13.1},null,{"$f":"H19-H31","v":18.259999999999998}]
[null,"vom AN allein zu tragen","PV-Zuschlag",{"$f":"G7","v":3.5000000000000001E-3},null,null,null,{"$f":"D32*F11","v":3.5979650000000003},{"$f":"SUM(H31:H32)","v":16.697965}]

{"sheet":"ab Oktober Sachsen","index":2,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"ab Oktober 2022",null,null,null,"Beitrag","Satz","halber Satz","*) Besonderheit PV-Beitragszuschlag Sachsen: Arbeitnehmer mit einem Beschäftigungsort in Sachsen tragen die Beiträge zur Pflegeversicherung in Höhe von 1% allein (§ 58 Absatz 3 Satz 1 SGB XI). "]
[null,"AE","Arbeitsentgelt",null,1100,"KV",0.14599999999999999,{"$f":"G2/2","v":7.2999999999999995E-2},"PV-Beitragssatz",null,null,{"$f":"G6","v":3.0499999999999999E-2}]
[null,"G","Geringfügigkeitsgrenze",null,520,"ZB",1.4999999999999999E-2,7.4999999999999997E-3,"vom AN allein zu tragen",null,null,0.01]
[{"$nulls":4},1600,"RV",0.186,9.2999999999999999E-2,null,null,null,{"$f":"L2-L3","v":2.0499999999999997E-2}]
[null,"F",0.75090000000000001,"(30% ./. GSV-Beitragssatz)","bis 30.09.2022","AV",2.4E-2,1.2E-2,null,null,null,"./. 2"]
[null,"F",0.70089999999999997,"(28% ./. GSV-Beitragssatz)","ab 01.10.2022","PV Sachsen *)",3.0499999999999999E-2,{"$f":"G6/2","v":1.525E-2},"(AN-Anteil Sachsen)",null,null,{"$f":"L4/2","v":1.0249999999999999E-2}]
[null,null,null,"für Kinderlose AN",null,"PV-Zuschlag",3.5000000000000001E-3,null,"zuzüglich dem Anteil, den der AN alleine trägt",null,null,0.01]
[{"$nulls":11},{"$f":"L6+L7","v":2.0249999999999997E-2},"Prozentsatz für PV-Beitrag AN-Anteil"]
["A","Gesamtbeitrag je Versicherungszweig",null,"aus der beitragspflichtigen Einnahme, die sich nach der Formel (rechts) ermittelt: ",null,null,null,"Gesamtbeitrag","abzüglich","ergibt"]
[null,"Ermittlung der Beitragspflichtigen Einnahme für den Gesamtbeitrag",null,null,"BE (Gesamt)",null,null,null,"Arbeitnehmer-Anteil","Arbeitgeber-Anteil"]
[{"$nulls":5},{"$f":"ROUND(E2*L12+O12,2)","v":1027.99},{"$nulls":5},"Kurzformel"]
[null,"Ermittlung des Gesamtbeitrages",{"$nulls":9},1.1440111111,"x","AE",-230.4177777777]
[null,"Beitragspflichtige Einnahme","x","halber Beitragssatz","ergibt halber Beitrag","kaufmännisch runden","x2"]
[null,{"$f":"F11","v":1027.99},"KV",{"$f":"H2","v":7.2999999999999995E-2},{"$f":"B14*D14","v":75.043269999999993},{"$f":"ROUND(E14,2)","v":75.040000000000006},{"$f":"F14*2","v":150.08000000000001},{"$nulls":4},"zur Ermittlung der Beitragspflichtigen Einnahme "]
[null,null,"ZB",{"$f":"H3","v":7.4999999999999997E-3},{"$f":"B14*D15","v":7.7099250000000001},{"$f":"ROUND(E15,2)","v":7.71},{"$f":"F15*2","v":15.42},{"$f":"SUM(G14:G15)","v":165.5}]
[]
[null,null,"RV",{"$f":"H4","v":9.2999999999999999E-2},{"$f":"B14*D17","v":95.603070000000002},{"$f":"ROUND(E17,2)","v":95.6},{"$f":"F17*2","v":191.2},{"$f":"F17*2","v":191.2}]
[null,null,"AV",{"$f":"H5","v":1.2E-2},{"$f":"B14*D18","v":12.33588},{"$f":"ROUND(E18,2)","v":12.34},{"$f":"F18*2","v":24.68},{"$f":"G18","v":24.68}]
[null,null,"PV",{"$f":"H6","v":1.525E-2},{"$f":"B14*D19","v":15.676847499999999},{"$f":"ROUND(E19,2)","v":15.68},{"$f":"F19*2","v":31.36},{"$f":"F19*2","v":31.36}]
[]
[]
["B","Beitragsanteil Arbeitnehmer",{"$nulls":5},"Arbeitnehmer-Anteil"]
[null,"Ermittlung der Beitragspflichtigen Einnahme für den Arbeitnehmeranteil",null,null,"BE (AN-Anteil)",{"$f":"ROUND(E2*L24+O24,4)","v":859.25930000000005},{"$nulls":5},"Kurzformel"]
[null,"Ermittlung des Arbeitnehmeranteils",{"$nulls":9},1.4814814813999999,"x","AE",-770.37037037029995]
[null,"Beitragspflichtige Einnahme    X",null,"halber Beitragssatz","ergibt halber Beitrag","kaufmännisch runden"]
[null,{"$f":"F23","v":859.25930000000005},"KV",{"$f":"D14","v":7.2999999999999995E-2},{"$f":"B26*D26","v":62.7259289},{"$f":"ROUND(E26,2)","v":62.73},{"$nulls":5},"zur Ermittlung der Beitragspflichtigen Einnahme "]
[null,null,"ZB",{"$f":"D15","v":7.4999999999999997E-3},{"$f":"B26*D27","v":6.4444447499999997},{"$f":"ROUND(E27,2)","v":6.44},null,{"$f":"SUM(F26:F27)","v":69.17},{"$f":"H27","v":69.17},{"$f":"H15-H27","v":96.33}]
[]
[null,null,"RV",{"$f":"H4","v":9.2999999999999999E-2},{"$f":"F23*D29","v":79.911114900000001},{"$f":"ROUND(E29,2)","v":79.91},null,{"$f":"F29","v":79.91},{"$f":"H29","v":79.91},{"$f":"H17-H29","v":111.28999999999999}]
[null,null,"AV",{"$f":"H5","v":1.2E-2},{"$f":"F23*D30","v":10.3111116},{"$f":"ROUND(E30,2)","v":10.31},null,{"$f":"F30","v":10.31},{"$f":"H30","v":10.31},{"$f":"H19-H32","v":13.96}]
[{"$nulls":4},{"$f":"F23*D31","v":0},{"$f":"ROUND(E31,2)","v":0},null,{"$f":"F31","v":0}]
[null,"*) siehe Besonderheit","PV Sachsen",{"$f":"L8","v":2.0249999999999997E-2},{"$f":"F23*D32","v":17.400000824999999},{"$f":"ROUND(E32,2)","v":17.399999999999999},null,{"$f":"F32","v":17.399999999999999}]
[null,"vom AN allein zu tragen","PV-Zuschlag",{"$f":"G7","v":3.5000000000000001E-3},null,null,null,{"$f":"D33*F11","v":3.5979650000000003},{"$f":"SUM(H32:H33)","v":20.997965000000001},{"$f":"H19-H32","v":13.96}]

{"sheet":"Mehrfachbeschäftigung","index":3,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"ab Oktober 2022",null,null,null,"Beitrag","Satz","halber Satz",null,null,"keine Zusammenrechnung der Mehrfachbeschäftigung in der Arbeitslosenversicherung"]
[null,"AE","Arbeitsentgelt",null,1100,"KV",0.14599999999999999,{"$f":"G2/2","v":7.2999999999999995E-2}]
[null,null,"Fremdentgelt",null,360]
[null,null,"Gesamtentgelt",null,{"$f":"SUM(E2:E3)","v":1460}]
[null,"G","Geringfügigkeitsgrenze",null,520,"ZB",1.4999999999999999E-2,7.4999999999999997E-3]
[{"$nulls":4},1600,"RV",0.186,9.2999999999999999E-2]
[null,"F",0.75090000000000001,"(30% ./. GSV-Beitragssatz)","bis 30.09.2022","AV",2.4E-2,1.2E-2]
[null,"F",0.70089999999999997,"(28% ./. GSV-Beitragssatz)","ab 01.10.2022","PV",3.0499999999999999E-2,{"$f":"G8/2","v":1.525E-2}]
[{"$nulls":5},"PV-Zuschlag",3.5000000000000001E-3,null,"für Kinderlose AN"]
[]
["A","Gesamtbeitrag je Versicherungszweig",null,"aus der beitragspflichtigen Einnahme, die sich nach der Formel (rechts) ermittelt: ",null,null,null,"Gesamtbeitrag","abzüglich","ergibt"]
[null,"Ermittlung der Beitragspflichtigen Einnahme für den Gesamtbeitrag",null,null,"BE (Gesamt)",{"$f":"((C8*E5+((E6/(E6-E5))-(E5/(E6-E5))*C8)*(E4-E5))*E2)/E4","v":1084.809786910198},null,null,"Arbeitnehmer-Anteil","Arbeitgeber-Anteil"]
[]
[null,"Ermittlung des Gesamtbeitrages"]
[null,"Beitragspflichtige Einnahme","x","halber Beitragssatz","ergibt halber Beitrag","kaufmännisch runden","x2"]
[null,{"$f":"F12","v":1084.809786910198},"KV",{"$f":"H2","v":7.2999999999999995E-2},{"$f":"B16*D16","v":79.191114444444452},{"$f":"ROUND(E16,2)","v":79.19},{"$f":"F16*2","v":158.38},{"$nulls":4},"zur Ermittlung der Beitragspflichtigen Einnahme "]
[null,null,"ZB",{"$f":"H5","v":7.4999999999999997E-3},{"$f":"B16*D17","v":8.1360734018264846},{"$f":"ROUND(E17,2)","v":8.14},{"$f":"F17*2","v":16.28},{"$f":"SUM(G16:G17)","v":174.66}]
[]
[null,null,"RV",{"$f":"H6","v":9.2999999999999999E-2},{"$f":"B16*D19","v":100.88731018264842},{"$f":"ROUND(E19,2)","v":100.89},{"$f":"F19*2","v":201.78},{"$f":"F19*2","v":201.78}]
[null,{"$f":"E2*K22+N22","v":1027.9944444323},"AV",{"$f":"H7","v":1.2E-2},{"$f":"B20*D20","v":12.335933333187601},{"$f":"ROUND(E20,2)","v":12.34},{"$f":"F20*2","v":24.68},{"$f":"G20","v":24.68},null,null,"HIER: normale Formel zur Ermittlung der beitragspflichtigen Einnahme, soweit KEINE Zusammenrechnung erfolgt!"]
[null,null,"PV",{"$f":"H8","v":1.525E-2},{"$f":"B16*D21","v":16.543349250380519},{"$f":"ROUND(E21,2)","v":16.54},{"$f":"F21*2","v":33.08},{"$f":"F21*2","v":33.08},null,null,"Kurzformel"]
[{"$nulls":10},1.1440111111,"x","AE",-230.4177777777]
[]
["B","Beitragsanteil Arbeitnehmer",{"$nulls":5},"Arbeitnehmer-Anteil"]
[null,"Ermittlung der Beitragspflichtigen Einnahme für den Arbeitnehmeranteil",null,null,"BE (AN-Anteil)",{"$f":"((E6/(E6-E5)*(E4-E5))*E2)/E4","v":1049.2135971588027}]
[null,"Ermittlung des Arbeitnehmeranteils"]
[null,"Beitragspflichtige Einnahme    X",null,"halber Beitragssatz","ergibt halber Beitrag","kaufmännisch runden"]
[null,{"$f":"F25","v":1049.2135971588027},"KV",{"$f":"D16","v":7.2999999999999995E-2},{"$f":"B28*D28","v":76.592592592592595},{"$f":"ROUND(E28,2)","v":76.59}]
[null,null,"ZB",{"$f":"D17","v":7.4999999999999997E-3},{"$f":"B28*D29","v":7.8691019786910203},{"$f":"ROUND(E29,2)","v":7.87},null,{"$f":"SUM(F28:F29)","v":84.460000000000008},{"$f":"H29","v":84.460000000000008},{"$f":"H17-H29","v":90.199999999999989},null,"zur Ermittlung der Beitragspflichtigen Einnahme "]
[]
[null,null,"RV",{"$f":"H6","v":9.2999999999999999E-2},{"$f":"F25*D31","v":97.576864535768649},{"$f":"ROUND(E31,2)","v":97.58},null,{"$f":"F31","v":97.58},{"$f":"H31","v":97.58},{"$f":"H19-H31","v":104.2}]
[null,{"$f":"E2*K34+N34","v":859.25925916970004},"AV",{"$f":"H7","v":1.2E-2},{"$f":"D32*B32","v":10.3111111100364},{"$f":"ROUND(E32,2)","v":10.31},null,{"$f":"F32","v":10.31},{"$f":"H32","v":10.31},{"$f":"H21-H34","v":17.079999999999998},"HIER: normale Formel zur Ermittlung der beitragspflichtigen Einnahme, soweit KEINE Zusammenrechnung erfolgt!"]
[{"$nulls":4},{"$f":"F25*D33","v":0},{"$f":"ROUND(E33,2)","v":0},null,{"$f":"F33","v":0},null,null,"Kurzformel"]
[null,null,"PV Sachsen",{"$f":"H8","v":1.525E-2},{"$f":"F25*D34","v":16.00050735667174},{"$f":"ROUND(E34,2)","v":16},null,{"$f":"F34","v":16},null,null,1.4814814813999999,"x","AE",-770.37037037029995]
[null,"vom AN allein zu tragen","PV-Zuschlag",{"$f":"G9","v":3.5000000000000001E-3},null,null,null,{"$f":"D35*F13","v":0},{"$f":"SUM(H34:H35)","v":16},{"$f":"H21-H34","v":17.079999999999998}]

{"sheet":"Unterschreitung 450_520€","index":4,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,0,14,2],[2,3,14,5],[0,0,0,5],[16,0,16,5],[25,1,25,2],[25,4,25,5]]}
["Unterschreitung der unteren Entgeltgrenze"]
[]
["Bestandsschutz",null,null,"ab 1. Oktober 2022"]
{"$rows_empty":13}
["                                                                              Berechnung der beitragspflichtigen Einnahme:"]
[]
[null,400,"Arbeitsentgelt",null,510,"Arbeitsentgelt"]
["mal",0.75090000000000001,"Faktor (FÜ)","mal",0.70089999999999997,"Faktor (F)"]
["ergibt ",{"$f":"B19*B20","v":300.36},"als beitragspflichtige Einnahme",null,{"$f":"E19*E20","v":357.459},"als beitragspflichtige Einnahme"]
[]
[]
[]
[]
[null,"ab 1. Januar 2023",null,null,"ab 1. Januar 2023"]
[]
[null,400,"Arbeitsentgelt",null,400,"Arbeitsentgelt"]
["mal",{"$f":"'Bestandsschutz ab 1.1.2023'!C8","v":0.74170000000000003},"Faktor (FÜ) ab 1. Januar 2023","mal",{"$f":"'ab 1.1.2023'!C7","v":0.69220000000000004},"Faktor (F) ab 1. Januar 2023"]
["ergibt ",{"$f":"B28*B29","v":296.68},"als beitragspflichtige Einnahme",null,{"$f":"E28*E29","v":276.88},"als beitragspflichtige Einnahme"]

{"sheet":"Bestandsschutz ab 1.1.2023","index":5,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"für Arbeitnehmer im Übergangsbereich von 450,01 bis 520,00 €, deren Beschäftigungsverhältnis bereits bestanden hat",null,null,null,"Beitrag","Satz","halber Satz","ab Januar 2023 - vorbehaltlich dass der Faktor FÜ in Höhe von 0,7417 vom Bundesministerium für Arbeit und Soziales in dieser Höhe festgesetzt wird - bisherige Information seitens der ITSG"]
[null,"AE","Arbeitsentgelt",null,510,"KV",0.14599999999999999,{"$f":"G2/2","v":7.2999999999999995E-2}]
[{"$nulls":4},450]
[null,"G","Geringfügigkeitsgrenze",null,520,"ZB",1.4999999999999999E-2,7.4999999999999997E-3]
[{"$nulls":4},1300,"RV",0.186,9.2999999999999999E-2]
[null,"F",0.75090000000000001,"(30% ./. GSV-Beitragssatz)","bis 30.09.2022","AV",2.5999999999999999E-2,1.2999999999999999E-2]
[null,"F",0.70089999999999997,"(28% ./. GSV-Beitragssatz)","ab 01.10.2022","PV",3.0499999999999999E-2,1.525E-2]
[null,"FÜ",0.74170000000000003,null,"ab 01.01.2023",{"$nulls":4},"Beitragspflichtige Einnahme durch Anwendung der Formel:"]
[{"$nulls":5},"PV-Zuschlag",3.5000000000000001E-3,1.75E-3]
["A","Gesamtbeitrag je Versicherungszweig",null,"aus der beitragspflichtigen Einnahme, die sich nach der Formel (rechts) ermittelt: ",null,null,null,"Gesamtbeitrag"]
[{"$nulls":4},"BE (Gesamt)"]
[{"$nulls":5},{"$f":"C8*E3+(E5/(E5-E3)-E3/(E5-E3)*C8)*(E2-E3)","v":401.96982352941177}]
[null,"Ermittlung des Gesamtbeitrages"]
[null,"Beitragspflichtige Einnahme","x","halber Beitragssatz","ergibt halber Beitrag","kaufmännisch runden","x2",null,null,"nur für Beschäftigungsverhältnisse, die bereits vor dem 30.09.2022 bestanden haben"]
[null,{"$f":"F12","v":401.96982352941177},"KV",{"$f":"H2","v":7.2999999999999995E-2},{"$f":"B15*D15","v":29.343797117647057},{"$f":"ROUND(E15,2)","v":29.34},{"$f":"F15*2","v":58.68},null,null,"nur für Beschäftigungsverhältnisse, deren regelmäßiges Arbeitsentgelt max. 520,- € beträgt"]
[null,null,"ZB",{"$f":"H4","v":7.4999999999999997E-3},{"$f":"B15*D16","v":3.0147736764705884},{"$f":"ROUND(E16,2)","v":3.01},{"$f":"F16*2","v":6.02},{"$f":"SUM(G15:G16)","v":64.7},null,"bis max. 31.12.2023!"]
[]
[null,null,"RV",{"$f":"H5","v":9.2999999999999999E-2},{"$f":"B15*D18","v":37.383193588235294},{"$f":"ROUND(E18,2)","v":37.380000000000003},{"$f":"F18*2","v":74.760000000000005},{"$f":"F18*2","v":74.760000000000005}]
[null,null,"AV",{"$f":"H6","v":1.2999999999999999E-2},{"$f":"B15*D19","v":5.2256077058823527},{"$f":"ROUND(E19,2)","v":5.23},{"$f":"F19*2","v":10.46},{"$f":"G19","v":10.46}]
[null,null,"PV",{"$f":"H7","v":1.525E-2},{"$f":"B15*D20","v":6.1300398088235291},{"$f":"ROUND(E20,2)","v":6.13},{"$f":"F20*2","v":12.26},{"$f":"F20*2","v":12.26}]
[null,null,"PV-Zuschlag",{"$f":"G9","v":3.5000000000000001E-3},null,null,null,{"$f":"G9*B15","v":1.4068943823529412}]
[{"$nulls":7},{"$f":"SUM(H16:H21)","v":163.58689438235294}]
[{"$nulls":8},"(Gesamtbeitrag ./. Arbeitgeber-Anteil)"]
["B","Beitragsanteil Arbeitgeber","aus dem tatsächlichen Arbeitsentgelt",null,null,{"$f":"E2","v":510},null,"Arbeitgeber-Anteil","Arbeitnehmer-","(A - B = C)"]
[{"$nulls":8},"Anteile","C"]
[null,"tatsächliches Arbeitsentgelt",null,"halber Beitragssatz","ergibt halber Beitrag",null,null,null,"siehe Entgeltabrechnung"]
[null,{"$f":"F24","v":510},"KV",{"$f":"D15","v":7.2999999999999995E-2},{"$f":"B27*D27","v":37.229999999999997},{"$f":"ROUND(E27,2)","v":37.229999999999997},null,null,{"$f":"G15-F27","v":21.450000000000003}]
[null,null,"ZB",{"$f":"D16","v":7.4999999999999997E-3},{"$f":"B27*D28","v":3.8249999999999997},{"$f":"ROUND(E28,2)","v":3.83},null,{"$f":"SUM(F27:F28)","v":41.059999999999995},{"$f":"G16-F28","v":2.1899999999999995},{"$f":"SUM(I27:I28)","v":23.64}]
[]
[null,null,"RV",{"$f":"H5","v":9.2999999999999999E-2},{"$f":"B27*D30","v":47.43},{"$f":"ROUND(E30,2)","v":47.43},null,{"$f":"F30","v":47.43},null,{"$f":"H18-H30","v":27.330000000000005}]
[null,null,"AV",{"$f":"H6","v":1.2999999999999999E-2},{"$f":"B27*D31","v":6.63},{"$f":"ROUND(E31,2)","v":6.63},null,{"$f":"F31","v":6.63},null,{"$f":"H19-H31","v":3.830000000000001}]
[null,null,"PV",{"$f":"H7","v":1.525E-2},{"$f":"B27*D32","v":7.7774999999999999},{"$f":"ROUND(E32,2)","v":7.78},null,{"$f":"F32","v":7.78},{"$f":"H20-H32","v":4.4799999999999995}]
[{"$nulls":8},{"$f":"B15*G9","v":1.4068943823529412},{"$f":"SUM(I32:I33)","v":5.8868943823529403}]

{"sheet":"ab 1.1.2023","index":6,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"ab Oktober 2022",null,null,null,"Beitrag","Satz","halber Satz",null,null,"für:"]
[null,"AE","Arbeitsentgelt",null,1400,"KV",0.14599999999999999,{"$f":"G2/2","v":7.2999999999999995E-2},null,"1)","neue Midi-Jobs ab Oktober 2022"]
[null,"G","Geringfügigkeitsgrenze",null,520,"ZB",1.4999999999999999E-2,7.4999999999999997E-3,null,"2)","und bei Erhöhung des Durchschnittsentgeltes über 520,00 € (dauerhaft)"]
[{"$nulls":4},1600,"RV",0.186,9.2999999999999999E-2]
[null,"F",0.75090000000000001,"(30% ./. GSV-Beitragssatz)","bis 30.09.2022","AV",2.5999999999999999E-2,1.2999999999999999E-2]
[null,"F",0.70089999999999997,"(28% ./. GSV-Beitragssatz)","ab 01.10.2022","PV",3.0499999999999999E-2,1.525E-2]
[null,"F",0.69220000000000004,"(28% ./. GSV-Beitragssatz)","ab 01.01.2023","PV-Zuschlag",3.5000000000000001E-3,"für Kinderlose AN"]
[]
[]
["A","Gesamtbeitrag je Versicherungszweig",null,"aus der beitragspflichtigen Einnahme, die sich nach der Formel (rechts) ermittelt: ",null,null,null,"Gesamtbeitrag"]
[null,"Ermittlung der Beitragspflichtigen Einnahme für den Gesamtbeitrag",null,null,"BE (Gesamt)"]
[{"$nulls":5},{"$f":"ROUND(E2*K14+N14,2)","v":1335.11}]
[null,"Ermittlung des Gesamtbeitrages",{"$nulls":8},"Kurzformel"]
[null,"Beitragspflichtige Einnahme","x","halber Beitragssatz","ergibt halber Beitrag","kaufmännisch runden","x2",null,null,null,1.108145946,"x","AE",-216.2918919]
[null,{"$f":"F12","v":1335.11},"KV",{"$f":"H2","v":7.2999999999999995E-2},{"$f":"B15*D15","v":97.463029999999989},{"$f":"ROUND(E15,2)","v":97.46},{"$f":"F15*2","v":194.92}]
[null,null,"ZB",{"$f":"H3","v":7.4999999999999997E-3},{"$f":"B15*D16","v":10.013324999999998},{"$f":"ROUND(E16,2)","v":10.01},{"$f":"F16*2","v":20.02},{"$f":"SUM(G15:G16)","v":214.94},null,null,"zur Ermittlung der Beitragspflichtigen Einnahme "]
[]
[null,null,"RV",{"$f":"H4","v":9.2999999999999999E-2},{"$f":"B15*D18","v":124.16522999999999},{"$f":"ROUND(E18,2)","v":124.17},{"$f":"F18*2","v":248.34},{"$f":"F18*2","v":248.34}]
[null,null,"AV",{"$f":"H5","v":1.2999999999999999E-2},{"$f":"B15*D19","v":17.35643},{"$f":"ROUND(E19,2)","v":17.36},{"$f":"F19*2","v":34.72},{"$f":"G19","v":34.72}]
[null,null,"PV",{"$f":"H6","v":1.525E-2},{"$f":"B15*D20","v":20.360427499999997},{"$f":"ROUND(E20,2)","v":20.36},{"$f":"F20*2","v":40.72},{"$f":"F20*2","v":40.72}]
[null,null,"PV-Zuschlag",{"$f":"G7","v":3.5000000000000001E-3},null,null,null,{"$f":"D21*B15","v":4.672885},{"$f":"SUM(H20:H21)","v":45.392885}]
["B","Beitragsanteil Arbeitnehmer",{"$nulls":5},"Arbeitnehmer-Anteil","Arbeitgeber-Anteil"]
[null,"Ermittlung der Beitragspflichtigen Einnahme für den Arbeitnehmeranteil",null,null,"BE (AN-Anteil)",{"$f":"ROUND(E2*K26+N26,4)","v":1189.1892}]
[null,"Ermittlung des Arbeitnehmeranteils",{"$nulls":6},"(GSV-Beitrag ./. Arbeitnehmer-Anteil)"]
[null,"Beitragspflichtige Einnahme    X",null,"halber Beitragssatz","ergibt halber Beitrag","kaufmännisch runden",{"$nulls":4},"Kurzformel"]
[null,{"$f":"F23","v":1189.1892},"KV",{"$f":"D15","v":7.2999999999999995E-2},{"$f":"B26*D26","v":86.810811599999994},{"$f":"ROUND(E26,2)","v":86.81},null,null,{"$f":"G15-F26","v":108.10999999999999},null,1.3513513509999999,"x","AE",-702.70270200000004]
[null,null,"ZB",{"$f":"D16","v":7.4999999999999997E-3},{"$f":"B26*D27","v":8.9189190000000007},{"$f":"ROUND(E27,2)","v":8.92},null,{"$f":"SUM(F26:F27)","v":95.73},{"$f":"G16-F27","v":11.1},{"$f":"SUM(I26:I27)","v":119.20999999999998}]
[{"$nulls":10},"zur Ermittlung der Beitragspflichtigen Einnahme "]
[null,null,"RV",{"$f":"H4","v":9.2999999999999999E-2},{"$f":"F23*D29","v":110.59459560000001},{"$f":"ROUND(E29,2)","v":110.59},null,{"$f":"F29","v":110.59},null,{"$f":"G18-H29","v":137.75}]
[null,null,"AV",{"$f":"H5","v":1.2999999999999999E-2},{"$f":"F23*D30","v":15.459459599999999},{"$f":"ROUND(E30,2)","v":15.46},null,{"$f":"F30","v":15.46},null,{"$f":"H19-H30","v":19.259999999999998}]
[]
[null,"Arbeitnehmer-Anteil","PV",{"$f":"H6","v":1.525E-2},{"$f":"F23*D32","v":18.135135300000002},{"$f":"ROUND(E32,2)","v":18.14},null,{"$f":"F32","v":18.14},null,{"$f":"H20-H32","v":22.58}]
[null,"vom AN allein zu tragen","PV-Zuschlag",{"$f":"G7","v":3.5000000000000001E-3},null,null,null,{"$f":"D33*F12","v":4.672885},{"$f":"SUM(H32:H33)","v":22.812885000000001}]

{"sheet":"Veröffentlichung","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}