{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Personalfragebogen","Assistent","Listen","Listen (englisch)","Logo","Verwaltung"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":2,"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":"Personalfragebogen","index":0,"n_rows":352,"n_cols":44,"rows_kept":352,"cut":false,"hidden":false,"merged":[[351,3,351,35],[351,39,351,47],[336,19,336,27],[338,19,340,27],[336,3,336,7],[338,3,340,7],[336,11,336,15],[338,11,340,15],[335,31,335,39],[336,31,336,39],[338,31,340,39],[335,43,335,47],[336,43,336,47],[338,43,340,47],[326,43,326,47],[327,43,327,47],[329,43,331,47],[335,3,335,7],[335,11,335,15],[335,19,335,27],[326,19,326,27],[327,19,327,27],[329,19,331,27],[326,31,326,39],[327,31,327,39],[329,31,331,39],[326,3,326,7],[327,3,327,7],[329,3,331,7],[326,11,326,15],[327,11,327,15],[329,11,331,15],[307,27,309,47],[313,3,313,23],[304,3,304,11],[305,3,305,11],[307,3,309,11],[304,15,304,23],[305,15,305,23],[307,15,309,23],[289,3,291,23],[287,27,287,35],[289,27,291,35],[314,3,314,23],[316,3,318,23],[313,27,313,47],[314,27,314,47],[316,27,318,47],[304,27,304,47],[305,27,305,47],[274,27,274,35],[298,3,300,23],[295,27,295,47],[296,27,296,47],[298,27,300,47],[287,39,287,47],[289,39,291,47],[295,3,295,23],[296,3,296,23],[287,3,287,23],[277,11,279,15],[274,39,274,47],[275,39,275,47],[277,39,279,47],[286,3,286,23],[286,27,286,35],[286,39,286,47],[274,19,274,23],[275,19,275,23],[277,19,279,23],[265,27,265,35],[266,27,266,35],[268,27,270,35],[275,27,275,35],[277,27,279,35],[274,3,274,7],[275,3,275,7],[277,3,279,7],[274,11,274,15],[275,11,275,15],[265,39,265,47],[266,39,266,47],[268,39,270,47],[252,3,252,47],[256,3,256,23],[256,27,256,47],[265,3,265,7],[266,3,266,7],[268,3,270,7],[265,11,265,15],[266,11,266,15],[268,11,270,15],[265,19,265,23],[243,3,243,23],[244,3,244,23],[246,3,248,23],[266,19,266,23],[268,19,270,23],[243,27,243,47],[244,27,244,47],[246,27,248,47],[231,3,231,23],[232,3,232,23],[234,3,236,23],[231,27,231,47],[232,27,232,47],[234,27,236,47],[222,3,222,23],[223,3,223,23],[225,3,227,23],[222,27,222,47],[223,27,223,47],[225,27,227,47],[213,27,213,35],[214,27,214,35],[216,27,218,35],[213,39,213,47],[214,39,214,47],[216,39,218,47],[214,3,214,11],[216,3,218,11],[213,15,213,23],[214,15,214,23],[216,15,218,23],[201,3,201,23],[202,3,202,23],[204,3,206,23],[213,3,213,11],[192,3,192,23],[193,3,193,23],[195,3,197,23],[192,27,192,47],[193,27,193,47],[195,27,197,47],[177,44,179,47],[183,3,183,23],[184,3,184,23],[186,3,188,23],[183,27,183,47],[184,27,184,47],[186,27,188,47],[177,20,179,23],[177,27,179,27],[177,28,179,31],[177,35,179,35],[177,36,179,39],[177,43,179,43],[165,27,165,47],[166,27,166,47],[168,27,170,47],[174,3,174,47],[175,3,175,47],[177,3,179,3],[177,4,179,7],[177,11,179,11],[177,12,179,15],[177,19,179,19],[165,3,165,11],[166,3,166,11],[168,3,170,11],[165,15,165,23],[166,15,166,23],[168,15,170,23],[156,3,156,23],[157,3,157,23],[159,3,161,23],[156,27,156,47],[157,27,157,47],[159,27,161,47],[150,3,152,23],[147,27,147,47],[148,27,148,47],[150,27,152,47],[138,27,138,47],[139,27,139,47],[141,27,143,47],[147,3,147,23],[139,3,139,11],[141,3,143,11],[126,3,126,23],[127,3,127,23],[129,3,131,23],[138,3,138,11],[138,15,138,23],[148,3,148,23],[139,15,139,23],[141,15,143,23],[120,3,122,23],[117,27,117,47],[118,27,118,47],[120,27,122,47],[108,27,108,47],[109,27,109,47],[111,27,113,47],[117,3,117,23],[108,3,108,11],[109,3,109,11],[91,3,91,11],[93,3,95,11],[90,15,90,23],[91,15,91,23],[93,15,95,23],[118,3,118,23],[111,3,113,11],[108,15,108,23],[109,15,109,23],[111,15,113,23],[100,3,100,23],[102,3,104,23],[99,27,99,47],[100,27,100,47],[102,27,104,47],[90,27,90,47],[91,27,91,47],[93,27,95,47],[99,3,99,23],[90,3,90,11],[81,3,81,23],[82,3,82,23],[84,3,86,23],[81,27,81,47],[82,27,82,47],[84,27,86,47],[75,3,77,23],[72,27,72,47],[73,27,73,47],[75,27,77,47],[64,31,64,47],[66,31,68,47],[72,3,72,23],[73,3,73,23],[64,3,64,19],[66,3,68,19],[54,27,54,47],[55,27,55,47],[57,27,59,47],[63,21,63,23],[64,21,64,23],[66,21,68,23],[63,27,63,29],[64,27,64,29],[66,27,68,29],[46,27,46,47],[48,27,50,47],[54,3,54,23],[45,3,45,23],[63,3,63,19],[63,31,63,47],[46,3,46,23],[48,3,50,23],[55,3,55,23],[57,3,59,23],[34,3,34,35],[36,3,38,35],[33,39,33,47],[34,39,34,47],[36,39,38,47],[45,27,45,47],[26,3,28,23],[33,3,33,35],[15,3,15,23],[16,3,16,23],[18,3,20,23],[22,3,24,23]]}
[]
[]
[null,null,null,"Personalfragebogen"]
[]
[null,null,null,"für geringfügig (Minijob) oder kurzfristig Beschäftigte"]
[]
[null,null,null,"Die mit diesem Balken gekennzeichneten Felder sind"]
[null,null,null,"vom Arbeitgeber auszufüllen"]
[]
[null,null,null,"Die rot umrahmten Felder sind für das Erzeugen einer Exportdatei zwingend erforderlich"]
[]
[]
[]
[]
[]
[null,null,null,"Firma"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Name des Mitarbeiters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personalnummer"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Persönliche Angaben"]
[]
[]
[null,null,null,"Familienname",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vorname"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Geburtsname",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geburtsdatum (TT.MM.JJJJ)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Straße",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hausnr.",null,null,null,null,null,"PLZ",null,null,null,"Ort"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Anschriftenzusatz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versicherungsnummer gem. Sozialvers.-Ausweis"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Geburtsort (nur bei fehlender Versicherungs-Nr.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geburtsland (nur bei fehlender Versicherungs-Nr.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Geschlecht",null,null,null,null,null,null,null,null,null,null,null,"Familienstand",null,null,null,null,null,null,null,null,null,null,null,"Staatsangehörigkeit"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Schwerbehindert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arbeitnehmernummer Sozialkasse - Bau"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Kontonummer",null,null,null,null,null,null,null,null,null,null,null,"Bankleitzahl",null,null,null,null,null,null,null,null,null,null,null,"Bankbezeichnung"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"IBAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIC"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Barzahlung"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Beschäftigung"]
[]
[]
[null,null,null,"Eintrittsdatum (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,"Ersteintrittsdatum (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,"Betriebsstätte"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Berufsbezeichnung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgeübte Tätigkeit (Kennziffer gem. BA oder Bezeichnung)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Höchster Schulabschluss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Höchste Berufsausbildung"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Wöchentliche Arbeitszeit",null,null,null,null,null,null,null,null,null,null,null,"Urlaubsanspruch (Kalenderjahr)",null,null,null,null,null,null,null,null,null,null,null,"Vertragsform"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Ggf. Verteilung der wöchentlichen Arbeitszeit (Std.)"]
[]
[]
[null,null,null,"Mo",null,null,null,null,null,null,null,"Di",null,null,null,null,null,null,null,"Mi",null,null,null,null,null,null,null,"Do",null,null,null,null,null,null,null,"Fr",null,null,null,null,null,null,null,"Sa"]
[]
[]
[]
[]
[]
[null,null,null,"Kostenstelle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abteilungsnummer"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Im Baugewerbe beschäftigt seit (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personengruppe"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Status bei Beginn der Beschäftigung"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Steuer"]
[]
[]
[null,null,null,"Finanzamtsnummer",null,null,null,null,null,null,null,null,null,null,null,"Identifikationsnummer",null,null,null,null,null,null,null,null,null,null,null,"Steuerklasse",null,null,null,null,null,null,null,null,null,null,null,"Faktor"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Kinderfreibetrag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Konfession"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Pauschalierung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abwälzung an Arbeitnehmer"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Sozialversicherung"]
[]
[]
[null,null,null,"Krankenversicherung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name Krankenkasse/Private Versicherung"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Nur bei geringfügig Beschäftigten:"]
[]
[]
[]
[null,null,null,"Arbeitnehmer-Option zur Befreiung von der Aufstockung in der RV\r\n(gem. § 6 Abs. 1 b SGB VI)"]
[]
[]
[]
[]
[]
[null,null,null,"Entlohnung"]
[]
[]
[null,null,null,"Bezeichnung",null,null,null,null,null,null,null,"Betrag",null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)",null,null,null,null,null,null,null,"Stundenlohn",null,null,null,null,null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Bezeichnung",null,null,null,null,null,null,null,"Betrag",null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)",null,null,null,null,null,null,null,"Stundenlohn",null,null,null,null,null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"VWL - nur notwendig, wenn Vertrag vorliegt"]
[]
[]
[null,null,null,"Empfänger VWL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Betrag",null,null,null,null,null,null,null,null,null,null,null,"AG-Anteil (Höhe monatlich)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"seit wann (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vertragsnummer"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Kontonummer",null,null,null,null,null,null,null,null,null,null,null,"Bankleitzahl",null,null,null,null,null,null,null,null,null,null,null,"Bankbezeichnung"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"IBAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIC"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Angaben zu weiteren Beschäftigungen"]
[null,null,null,"(bei kurzfristig Beschäftigten auch Vorbeschäftigungen aus dem Vorjahr)"]
[]
[]
[null,null,null,"von (TT.MM.JJJJ)",null,null,null,null,null,null,null,"bis (TT.MM.JJJJ)",null,null,null,null,null,null,null,"Arbeitgeber",null,null,null,null,null,null,null,null,null,null,null,"Art der Tätigkeit",null,null,null,null,null,null,null,null,null,null,null,"Wöchentl. Arbeitszeit"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"von (TT.MM.JJJJ)",null,null,null,null,null,null,null,"bis (TT.MM.JJJJ)",null,null,null,null,null,null,null,"Arbeitgeber",null,null,null,null,null,null,null,null,null,null,null,"Art der Tätigkeit",null,null,null,null,null,null,null,null,null,null,null,"Wöchentl. Arbeitszeit"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Bescheinigungen elektronisch annehmen (Bea)"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Ich widerspreche der elektronischen Übermittlung von Arbeits- und Nebeneinkommensbescheinigungen an die Bundesagentur für Arbeit."]

{"sheet":"Assistent","index":1,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
["Firma","Company name",null,null,"D19;D23;D27"]
["Name des Mitarbeiters, Personalnummer","Employee name, Personnel number",null,null,"D37;AN37"]
["Familienname","Surname",null,null,"D49"]
["Vorname","Given name",null,null,"AB49"]
["Geburtsname","Maiden name",null,null,"D58"]
["Geburtsdatum (TT.MM.JJJJ)","Date of birth (DD.MM.YYYY)",null,null,"AB58"]
["Straße, Hausnr.","Street, House No.",null,null,"D67;V67"]
["PLZ, Ort","Postcode, City",null,null,"AB67;AF67"]
["Anschriftenzusatz","Additional information",null,null,"D76"]
["Versicherungsnummer gem. Sozialvers.-Ausweis","Insurance number (as per social insurance card)",null,null,"AB76"]
["Geburtsort (nur bei fehlender Versicherungs-Nr.)","Place of birth (only if without insurance number)",null,null,"D85"]
["Geburtsland (nur bei fehlender Versicherungs-Nr.)","Country of birth (only if without insurance number)",null,null,"AB85"]
["Geschlecht, Familienstand","Gender, Marital status","False","True","D94;P94","15,75;503,25",null,null,"cbx_Geschlecht;cbx_Familienstand"]
["Staatsangehörigkeit","Nationality",null,null,"AB94"]
["Schwerbehindert","Severely disabled","True","True","D103","15,75;544,5",null,null,"cbx_Schwerbehindert"]
["Arbeitnehmernummer Sozialkasse - Bau","Employee number, pension fund - construction",null,null,"AB103"]
["Kontonummer Bankleitzahl","Bank account number Sort code",null,null,"D112;P112"]
["Bankbezeichnung","Name of bank institute",null,null,"AB112"]
["IBAN","IBAN",null,null,"D121"]
["BIC","BIC",null,null,"AB121"]
["Barzahlung","Cash payment","False","True","D130","15,75;668,25",null,null,"cbx_Barzahlung"]
["Eintrittsdatum Ersteintrittsdatum","Date employment contract begins First day",null,null,"D142;P142"]
["Betriebsstätte","Place of employment","True",null,"AB142"]
["Berufsbezeichnung","Description of profession",null,null,"D151"]
["Ausgeübte Tätigkeit (Kennziffer gem. BA oder Bezeichnung)","Job performed","True",null,"AB151"]
[]
[]
[]
[]
["Höchster Schulabschluss","Highest level of education","False","True","D160","15,75;817,5",null,null,"cbx_Schulabschluss"]
["Höchste Berufsausbildung","Highest level of professional training","False","True","AB160","348,75;817,5",null,null,"cbx_Berufsausbildung"]
[]
[]
["Wöchentliche Arbeitszeit Urlaubsanspruch","Weekly working hours Holiday entitlement",null,null,"D169;P169"]
["Vertragsform","Type of contract","True","True","AB169","348,75;858,75",null,null,"cbx_Vertragsform"]
["Wöchentliche Arbeitszeit","Weekly working hours",null,null,"E178;M178;U178;AC178;AK178;AS178"]
["Kostenstelle","Cost centre","True",null,"D187"]
["Abteilungsnummer","Department number","True",null,"AB187"]
["Im Baugewerbe beschäftigt seit (TT.MM.JJJJ)","Employed in construction industry since (DD.MM.YYYY)",null,null,"D196"]
["Personengruppe","Person group","True","True","AB196","348,75;982,5",null,null,"cbx_Personengruppe"]
["Status bei Beginn der Beschäftigung","Status at beginning of employment","False","True","D205","15,75;1023,75",null,null,"cbx_Status_Beschaeftigung"]
[]
[]
[]
[]
[]
[]
["Finanzamtsnummer Identifikationsnummer","Tax office No. Identification No.",null,null,"D217;P217"]
["Steuerklasse, Faktor","Tax class, Factor",null,null,"AB217;AN217"]
["Kinderfreibetrag","Number of exemptions for children",null,null,"D226"]
["Konfession","(Religious) Denomination","False","True","AB226","348,75;1131,75",null,null,"cbx_Konfession"]
["Pauschalierung","Blanket allowance","True","True","D235","15,75;1173",null,null,"cbx_Pauschalierung"]
["Abwälzung an Arbeitnehmer","Burden shifted to employee","True","True","AB235","348,75;1173",null,null,"cbx_Abwaelzung_an_Arbeitnehmer"]
["Gesetzl. Krankenkasse (bei PKV: letzte ges. Krankenkasse)","Statutory health insurance (HI) (in case of private HI: last statutory HI)"]
[]
[]
[]
[]
[]
["Krankenversicherung","Health insurance","False","True","D247","15,75;1239,75",null,null,"cbx_Krankenversicherung"]
["Name Krankenkasse/Private Versicherung","Name of state/private insurer",null,null,"AB247"]
["RV-Option","Pension insurance option","False","True","AB257:AV257","15,75;1293,75"]
["Entlohnung","Remuneration",null,null,"D269;L269;T269;AB269;AN269"]
["Entlohnung 2","Remuneration 2",null,null,"D278;L278;T278;AB278;AN278"]
[]
[]
[]
[]
[]
[]
["Empfänger VWL","Recipient",null,null,"D290"]
["Betrag, AG-Anteil","Amount Employer share",null,null,"AB290;AN290"]
["seit wann (TT.MM.JJJJ)","since (DD.MM.YYYY)",null,null,"D299"]
["Vertragsnummer","Contract number",null,null,"AB299"]
["Kontonummer Bankleitzahl","Bank account number Sort code",null,null,"D308;P308"]
["Bankbezeichnung","Name of bank institute",null,null,"AB308"]
["IBAN","IBAN",null,null,"D317"]
["BIC","BIC",null,null,"AB317"]
[]
[]
[]
[]
[]
["Angaben zu weiteren Beschäftigungen","Information on additional employment",null,null,"D330;L330;T330;AF330;AR330",1674,null,null,"cbx_weitere_Beschaeftigungen"]
["Angaben zu weiteren Beschäftigungen 2","Information on additional employment 2",null,null,"D339;L339;T339;AF339;AR339",1715.25,null,null,"cbx_weitere_Beschaeftigungen_2"]
[]
[]
[]
["Bea","Bea",null,null,"AN352:AV352",1770.75,null,null,"cbx_Bea"]

{"sheet":"Listen","index":2,"n_rows":24,"n_cols":29,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Arbeitsvertrag","Arbeitsvertrag","Ausbildungsvertrag"]
["Bescheinigung über LSt.-Abzug","Bescheinigung über LSt.-Abzug/Anzahl der Beschäftigungstage bei Vorarbeitgebern","Bescheinigung über LSt.-Abzug","männlich","ledig","ja","ja","Hauptbeschäftigung","ja","ja","ja","1 - Ohne Schulabschluss","1 - Ohne beruflichen Ausbildungsabschluss","1 - Unbefristet in Vollzeit","101 - Sozialversicherungspflichtig Beschäftigte","Arbeitnehmer/in","Befristet","Konfessionslos",0.02,"ja","ja","0 - Kein Beitrag","0 - Kein Beitrag","0 - Kein Beitrag zur BA","0 - Kein Beitrag zur gesetzlichen PV","Verzicht auf die RV-Option","Gesetzlich","geringfügig entlohnt","ja"]
["SV-Ausweis","SV-Ausweis","SV-Ausweis","weiblich","verheiratet","nein","nein","Nebenbeschäftigung","nein","nein","nein","2 - Haupt-/Volksschulabschluss","2 - Abschluss einer anerkannten Berufsausbildung","2 - Unbefristet in Teilzeit","102 - Auszubildende ohne besondere Merkmale","Arbeitnehmer/in in Elternzeit","Unbefristet","rk - Römisch-Katholische Kirchensteuer",0.2,"nein","nein","1 - Allgemeiner Beitrag","1 - Beitrag zur Rentenversicherung","1 - Voller Beitrag zur BA","1 - Voller Beitrag zur gesetzlichen PV","Ausübung der RV-Option (Verzicht auf RV-Freiheit)","Privat","nicht geringfügig entlohnt","nein"]
["Mitgliedsbescheinigung Krankenkasse","Antrag zur Befreiung von der RV-Pflicht","Mitgliedsbescheinigung Krankenkasse",null,"geschieden",null,null,null,null,null,null,"3 - Mittlere Reife oder gleichwertiger Abschluss","3 - Meister-/Techniker- oder gleichwertiger Fachschulabschluss","3 - Befristet in Vollzeit","103 - Beschäftigte in Altersteilzeit","Arbeitslose/r","Zweckbefristet","ev - Evangelische Kirchensteuer",null,null,null,"2 - Erhöhter Beitrag","3 - 1/2 Beitrag zur Rentenversicherung","2 - Halber Beitrag zur BA","2 - Halber Beitrag zur gesetzlichen PV",null,null,"kurzfristig beschäftigt"]
["Bescheinigung der privaten Krankenversicherung","Bescheinigung der privaten Krankenversicherung","VWL-Vertrag",null,"verwitwet",null,null,null,null,null,null,"4 - Abitur/Fachabitur","4 - Bachelor","4 - Befristet in Teilzeit","104 - Hausgewerbetreibende","Beamtin/Beamter",null,"lt - Evangelisch lutherisch",null,null,null,"3 - Ermäßigter Beitrag","5 - Geringfügig entlohnt"]
["VWL-Vertrag","VWL-Vertrag","Nachweis Elterneigenschaft",null,"dauernd getrennt",null,null,null,null,null,null,"9 - Abschluss unbekannt","5 - Diplom/Magister/Master/Staatsexamen",null,"105 - Praktikanten","Hausfrau/Hausmann",null,"rf - Evangelisch reformiert",null,null,null,"4 - Beitrag zur landwirtschaftlichen KV"]
["Nachweis Elterneigenschaft","Schul-/Studienbescheinigung","Vertrag Betriebliche Altersversorgung",null,null,null,null,null,null,null,null,null,"6 - Promotion",null,"106 - Werkstudenten","Schüler/in",null,"ak - Altkatholische Kirchensteuer",null,null,null,"6 - Geringfügig entlohnte Beschäftigte"]
["Vertrag Betriebliche Altersversorgung","Schwerbehindertenausweis","Schwerbehindertenausweis",null,null,null,null,null,null,null,null,null,"9 - Abschluss unbekannt",null,"107 - Behinderte Menschen in anerkannten Werkstätten oder gleichartigen Einrichtungen","Schulentlassene/r",null,"is - Israelitische / Jüdische Kultussteuer",null,null,null,"9 - Freiwillige KV, Firmenzahler"]
["Schwerbehindertenausweis","Unterlagen Sozialkasse Bau/Maler","Unterlagen Sozialkasse Bau/Maler",null,null,null,null,null,null,null,null,null,null,null,"108 - Bezieher von Vorruhestandsgeld","Selbstständige/r",null,"fb - Freireligiöse Landesgemeinde Baden"]
["Unterlagen Sozialkasse Bau/Maler",null,null,null,null,null,null,null,null,null,null,null,null,null,"109 - Geringfügig entlohnte Beschäftigte","Student/in",null,"ib - Israelitische Religionsgemeinschaft Baden"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"110 - Kurzfristig Beschäftigte","Sozialhilfeempfänger/in",null,"fo - Freireligiöse Gemeinde Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"111 - Personen in berufsfördernden Maßnahmen zur Rehabilitation","Studienbewerber/in",null,"fp - Freireligiöse Landesgemeinde Pfalz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"112 - Mitarbeitende Familienangehörige in der Landwirtschaft","Wehr-/Zivildienstleistender",null,"fm - Freireligiöse Gemeinde Mainz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"113 - Nebenerwerbslandwirte",null,null,"jü - Jüdisch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"114 - Nebenerwerbslandwirte - saisonal beschäftigt",null,null,"iw - Israelitische Religionsgemeinschaft Württembergs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116 - Ausgleichsgeldempfänger nach dem FELEG",null,null,"if - Israelitische Kultussteuer Frankfurt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"118 - Unständig Beschäftigte",null,null,"il - Israelitische Kultussteuer Land"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"119 - Versicherungsfreie Altersvollrentner und Versorgungsbezieher wegen Alters",null,null,"fr - Französisch reformiert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"190 - Beschäftigte, die nur in der gesetzlichen Unfallversicherung versichert sind",null,null,"fa - Freie Religionsgemeinschaft Alzey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"900 - Nicht meldepflichtig Beschäftigte",null,null,"fg - Freireligiöse Landesgemeinde Pfalz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs - Freireligiöse Gemeinde Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ih - Jüdische Kultussteuer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jd - Jüdische Kultussteuer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jh - Jüdische Kultussteuer"]

{"sheet":"Listen (englisch)","index":3,"n_rows":24,"n_cols":29,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Employment contract","Employment contract","Apprenticeship contract"]
["Income tax card/written confirmation of income tax","Income tax card/number of days employed at previous employers","Income tax card/written confirmation of income tax","male","unwed","yes","yes","Regular employment","yes","yes","yes","1 - No school leaving certificate","1 - No vocational training","1 - Permanent full-time contract","101 - Employees subject to social insurance contributions","Employee","Fixed-term","Non-denominational",0.02,"yes","yes","0 - No contribution","0 - No contribution","0 - No contribution to occupational pension","0 - No contribution to statutory nursing care insurance","Refuse pension insurance option","State","Mini job","yes"]
["Social insurance ID","Social insurance ID","Social insurance ID","female","married","no","no","Additional employment","no","no","no","2 - Haupt-/Volksschulabschluss (completion of secondary education)","2 - Officially recognised vocational training","2 - Permanent part-time contract","102 - Apprentices with no special attributes","Employee on parental leave","Permanent","rk - Roman-catholic church tax",0.2,"no","no","1 - General contribution","1 - Pension insurance contribution","1 - Full contribution to occupational pension","1 - Full contribution to statutory nursing care insurance","Excercise pension insurance option (waive pension insurance exemption)","Private","Non-mini job employment","no"]
["State insurance membership certificate","Application for exemption of pension insurance","State insurance membership certificate",null,"divorced",null,null,null,null,null,null,"3 - School leaving certificate or equivalent","3 - Master craftsman/technican/similar degree","3 - Fixed-term full-time contract","103 - Employees in partial retirement","Unemployed","Fixed-term ending on completion of assignment","ev - Protestant church tax",null,null,null,"2 - Increased contribution","3 - 1/2 pension insurance contribution","2 - 1/2 contribution to occupational pension","2 - 1/2 contribution to statutory nursing care insurance",null,null,"Short-term employment"]
["Certificate of private health insurance","Certificate of private health insurance","Capital-forming benefits (VWL) contract",null,"widowed",null,null,null,null,null,null,"4 - Abitur/Fachabitur (equivalent of A levels in UK)","4 - Bachelor's degree","4 - Fixed-term part-time contract","104 - Self-employed persons","Civil servant",null,"lt - Protestant Lutheran",null,null,null,"3 - Reduced contribution","5 - Low income"]
["Capital-forming benefits (VWL) contract","Capital-forming benefits (VWL) contract","Proof of parenthood",null,"permanently separated",null,null,null,null,null,null,"9 - Unknown","5 - Diploma/graduate degree/master's degree/state examination certificate",null,"105 - Interns","Housewife/house husband",null,"rf - Protestant reformed",null,null,null,"4 - Contribution to farmers health insurance"]
["Proof of parenthood","School/university certificate","Company retirement provision contract",null,null,null,null,null,null,null,null,null,"6 - PhD",null,"106 - Student trainees","School pupil",null,"ak - Old Catholic church tax",null,null,null,"6 - Low income employees"]
["Company retirement provision contract","Severely disabled ID","Severely disabled ID",null,null,null,null,null,null,null,null,null,"9 - Unknown",null,"107 - Handicapped people in accredited sheltered workshops or similar facilities","Unqualified",null,"is - Israelite / Jewish “Kultussteuer” (community tax)",null,null,null,"9 - Voluntary health insurance, paid by company"]
["Severely disabled ID","Pension fund documents construction/painting","Pension fund documents construction/painting",null,null,null,null,null,null,null,null,null,null,null,"108 - Early retirement pensioners","Self-employed",null,"fb - Non-denominational state parish Baden"]
["Pension fund documents construction/painting",null,null,null,null,null,null,null,null,null,null,null,null,null,"109 - Low income employees","Student",null,"ib - Israelite religious parish Baden"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"110 - Short-term employees","Social welfare recipient",null,"fo - Non-denominational parish Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"111 - Persons participating in job-supporting measures for rehabilitation","University applicant",null,"fp - Non-denominational state parish Palatinate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"112 - Family members working in farming","Military/social service",null,"fm - Non-denominational parish Mainz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"113 - Part-time farmers ",null,null,"jü - Jewish"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"114 - Part-time farmers – working seasonally",null,null,"iw - Israelite religious parish Württemberg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116 - Persons receiving compensation money according to FELEG (Law encouraging the cessation of farm work)",null,null,"if - Israelite “Kultussteuer” (community tax) Frankfurt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"118 - Short-term contract workers",null,null,"il - Israelite “Kultussteuer” (community tax) State"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"119 - Full pensioners exempted from insurance and persons qualifying for pension related benefits due to age",null,null,"fr - French reformed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"190 - Employees only insured with statutory accident insurance",null,null,"fa - Non-denominational parish Alzey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"900 - Employees not subject to registration",null,null,"fg - Non-denominational state parish Palatinate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs - Non-denominational parish Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ih - Jewish “Kultussteuer” (community tax)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jd - Jewish “Kultussteuer” (community tax)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jh - Jewish “Kultussteuer” (community tax)"]

{"sheet":"Logo","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Verwaltung","index":5,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Gewählter Fragebogen","GfB/Minijob"]
["Sprache PFB","Deutsch"]
["Eigenes Logo"]
[]
["Initialisierung durchgeführt","X"]
["Fragebogen erzeugt","X"]
[]
["Beraternummer"]
["Mandantennummer"]
[]
["Allgemein"]
["Persönliche Angaben",42]
["Beschäftigung",135]
[]
["Steuer",210]
["Sozialversicherung",240]
["Entlohnung",262]
[]
["VWL",283]
[]
["weitere Beschäftigungen",322]
["Bea",344]
["Angaben zu den Arbeitspapieren",null,1842.75]
["Arbeitnehmererklärung"]