{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Personalfragebogen","Assistent","Listen","Listen (englisch)","Logo","Verwaltung"],"not_rendered":{"charts":0,"images":13,"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":360,"n_cols":44,"rows_kept":360,"cut":false,"hidden":false,"merged":[[38,3,38,35],[40,3,42,35],[37,39,37,47],[38,39,38,47],[40,39,42,47],[49,3,49,23],[67,21,67,23],[68,21,68,23],[19,3,19,23],[20,3,20,23],[22,3,24,23],[26,3,28,23],[30,3,32,23],[37,3,37,35],[50,3,50,23],[52,3,54,23],[49,27,49,47],[50,27,50,47],[52,27,54,47],[67,27,67,29],[68,27,68,29],[70,27,72,29],[59,3,59,23],[61,3,63,23],[58,27,58,47],[59,27,59,47],[61,27,63,47],[67,3,67,19],[67,31,67,47],[58,3,58,23],[85,3,85,23],[86,3,86,23],[88,3,90,23],[85,27,85,47],[86,27,86,47],[88,27,90,47],[68,31,68,47],[70,31,72,47],[76,3,76,23],[77,3,77,23],[79,3,81,23],[76,27,76,47],[77,27,77,47],[79,27,81,47],[68,3,68,19],[70,3,72,19],[70,21,72,23],[103,3,103,23],[104,3,104,23],[106,3,108,23],[103,27,103,47],[104,27,104,47],[106,27,108,47],[94,3,94,23],[95,3,95,23],[97,3,99,23],[94,27,94,47],[95,27,95,47],[97,27,99,47],[112,3,112,23],[113,3,113,23],[115,3,117,23],[124,3,124,11],[125,3,125,11],[127,3,129,11],[124,15,124,23],[125,15,125,23],[127,15,129,23],[142,3,142,23],[143,3,143,23],[145,3,147,23],[142,27,142,47],[143,27,143,47],[145,27,147,47],[124,27,124,47],[125,27,125,47],[127,27,129,47],[133,3,133,23],[134,3,134,23],[136,3,138,23],[133,27,133,47],[134,27,134,47],[136,27,138,47],[151,27,151,47],[152,27,152,47],[154,27,156,47],[160,3,160,47],[161,3,161,47],[163,3,165,3],[163,4,165,11],[163,15,165,15],[163,16,165,23],[163,27,165,27],[151,3,151,11],[152,3,152,11],[154,3,156,11],[151,15,151,23],[152,15,152,23],[154,15,156,23],[163,28,165,35],[163,39,165,39],[163,40,165,47],[167,3,169,3],[167,4,169,11],[167,15,169,15],[167,16,169,23],[167,27,169,27],[167,28,169,35],[182,27,182,47],[183,27,183,47],[185,27,187,47],[173,3,173,23],[174,3,174,23],[176,3,178,23],[173,27,173,47],[174,27,174,47],[176,27,178,47],[191,3,191,23],[192,3,192,23],[194,3,196,23],[203,3,203,23],[204,3,204,23],[206,3,208,23],[182,3,182,23],[183,3,183,23],[185,3,187,23],[203,27,203,47],[204,27,204,47],[206,27,208,47],[212,3,212,23],[213,3,213,23],[215,3,217,23],[212,27,212,47],[213,27,213,47],[215,27,217,47],[242,3,242,23],[243,3,243,23],[245,3,247,23],[242,27,242,47],[243,27,243,47],[245,27,247,47],[224,39,224,47],[225,39,225,47],[227,39,229,47],[233,3,233,23],[234,3,234,23],[236,3,238,23],[233,27,233,47],[234,27,234,47],[236,27,238,47],[224,3,224,23],[225,3,225,23],[227,3,229,23],[224,27,224,35],[225,27,225,35],[227,27,229,35],[263,3,263,23],[264,3,264,23],[266,3,268,23],[263,27,263,47],[264,27,264,47],[266,27,268,47],[254,3,254,23],[255,3,255,23],[257,3,259,23],[254,27,254,47],[255,27,255,47],[257,27,259,47],[286,19,286,23],[288,19,290,23],[285,27,285,35],[286,27,286,35],[288,27,290,35],[285,39,285,47],[286,39,286,47],[288,39,290,47],[272,3,272,47],[276,3,276,23],[276,27,276,47],[285,3,285,7],[286,3,286,7],[288,3,290,7],[285,11,285,15],[286,11,286,15],[288,11,290,15],[285,19,285,23],[294,39,294,47],[295,39,295,47],[297,39,299,47],[306,3,306,23],[307,3,307,23],[309,3,311,23],[306,27,306,35],[307,27,307,35],[309,27,311,35],[306,39,306,47],[294,19,294,23],[295,19,295,23],[297,19,299,23],[294,27,294,35],[295,27,295,35],[297,27,299,35],[294,3,294,7],[295,3,295,7],[297,3,299,7],[294,11,294,15],[295,11,295,15],[297,11,299,15],[324,3,324,23],[325,3,325,23],[327,3,329,23],[324,27,324,47],[325,27,325,47],[327,27,329,47],[307,39,307,47],[309,39,311,47],[315,3,315,23],[316,3,316,23],[318,3,320,23],[315,27,315,47],[316,27,316,47],[318,27,320,47],[337,43,337,47],[338,43,338,47],[340,43,342,47],[346,3,346,7],[347,3,347,7],[349,3,351,7],[346,11,346,15],[347,11,347,15],[349,11,351,15],[346,19,346,27],[337,19,337,27],[338,19,338,27],[340,19,342,27],[337,31,337,39],[338,31,338,39],[340,31,342,39],[337,3,337,7],[338,3,338,7],[340,3,342,7],[337,11,337,15],[338,11,338,15],[340,11,342,15],[355,3,355,47],[359,3,359,38],[359,39,359,47],[347,19,347,27],[349,19,351,27],[346,31,346,39],[347,31,347,39],[349,31,351,39],[346,43,346,47],[347,43,347,47],[349,43,351,47]]}
[]
[]
[null,null,null,"Personalfragebogen"]
[]
[null,null,null,"für geringfügig (Minijob) oder kurzfristig Beschäftigte"]
[]
[null,null,null,"Dieser Personalfragebogen dient zur Vorerfassung von Personaldaten für das DATEV-"]
[null,null,null,"Lohnabrechnungsprogramm. Zur Wahrung der Aufbewahrungsfrist wird der ausgefüllte"]
[null,null,null,"Personalfragebogen von dem Arbeitgeber / der lohnabrechnenden Stelle gespeichert."]
[]
[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,""]
[]
[]
[]
[null,null,null,""]
[]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[]
[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,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,null,""]
[]
[]
[]
[]
[]
[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,"",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,"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,"",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,"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,"",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,"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,"",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,"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,"",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,"Geschlecht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staatsangehörigkeit"]
[]
[]
[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,"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,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,"IBAN"]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[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,"Beschäftigungsbetrieb"]
[]
[]
[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,"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,"",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,"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,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Ggf. Verteilung der wöchentlichen Arbeitszeit (Std.)"]
[]
[]
[null,null,null,"Mo","",null,null,null,null,null,null,null,null,null,null,"Di","",null,null,null,null,null,null,null,null,null,null,"Mi","",null,null,null,null,null,null,null,null,null,null,"Do",""]
[]
[]
[]
[null,null,null,"Fr","",null,null,null,null,null,null,null,null,null,null,"Sa","",null,null,null,null,null,null,null,null,null,null,"So",""]
[]
[]
[]
[]
[]
[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,"",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,"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,""]
[]
[]
[]
[]
[]
[null,null,null,"Status bei Beginn der Beschäftigung"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Befristung"]
[]
[]
[null,null,null,"Art der Befristung",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,"Befristung Arbeitsvertrag zum (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,"Abschluss Arbeitsvertrag am (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,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Steuer"]
[]
[]
[null,null,null,"Identifikationsnummer",null,null,null,null,null,null,null,null,null,null,null,null,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,"",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,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,""]
[]
[]
[]
[]
[]
[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,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,"UV-Gefahrtarif",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEÜV-Status"]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[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,"",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,"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,"",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,"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,"",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,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,"",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,"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,"",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,"Angaben zu weiteren Beschäftigungen"]
[null,null,null,"(bei kurzfristig Beschäftigten auch Vorbeschäftigungen aus dem Vorjahr und beendete Vorbeschäftigungen des aktuellen Jahres)"]
[]
[]
[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,"Ergibt die Zusammenrechnung der monatlichen Arbeitsentgelte mehr als EUR 450?"]
[]
[]
[]
[null,null,null,"(Hinweis für den Arbeitgeber: Sozialversicherungsrechtliche Beurteilung prüfen)"]

{"sheet":"Assistent","index":1,"n_rows":96,"n_cols":9,"rows_kept":96,"cut":false,"hidden":true,"merged":[]}
["Firma","Company name",null,null,"D23;D27;D31",null,";;"]
["Name des Mitarbeiters, Personalnummer","Employee name, Personnel number",null,null,"D41;AN41",null,";"]
["Familienname","Surname",null,null,"D53",null,""]
["Vorname","Given name",null,null,"AB53",null,""]
["Geburtsname","Maiden name",null,null,"D62",null,""]
["Geburtsdatum (TT.MM.JJJJ)","Date of birth (DD.MM.YYYY)",null,null,"AB62",null,""]
["Straße, Hausnr.","Street, House No.",null,null,"D71;V71",null,";"]
["PLZ, Ort","Postcode, City",null,null,"AB71;AF71",null,";"]
["Anschriftenzusatz","Additional information",null,null,"D80",null,""]
["Versicherungsnummer gem. Sozialvers.-Ausweis","Insurance number (as per social insurance card)",null,null,"AB80",null,""]
["Geburtsort (nur bei fehlender Versicherungs-Nr.)","Place of birth (only if without insurance number)",null,null,"D89",null,""]
["Geburtsland (nur bei fehlender Versicherungs-Nr.)","Country of birth (only if without insurance number)",null,null,"AB89",null,""]
["Geschlecht","Gender","False","True","D98","15,75;503,25",null,null,"cbx_Geschlecht"]
["Staatsangehörigkeit","Nationality",null,null,"AB98",null,""]
["Schwerbehindert","Severely disabled","True","True","D107","15,75;544,5",null,null,"cbx_Schwerbehindert"]
["Arbeitnehmernummer Sozialkasse - Bau","Employee number, pension fund - construction",null,null,"AB107",null,""]
["Kontonummer Bankleitzahl","Bank account number Sort code"]
["Bankbezeichnung","Name of bank institute"]
["IBAN","IBAN",null,null,"D116",null,""]
["BIC","BIC"]
[]
["Eintrittsdatum Ersteintrittsdatum","Date employment contract begins First day",null,null,"D128;P128",null,";"]
["Beschäftigungsbetrieb","Place of employment","True",null,"AB128",null,""]
["Berufsbezeichnung","Description of profession",null,null,"D137",null,""]
["Ausgeübte Tätigkeit (Kennziffer gem. BA oder Bezeichnung)","Job performed","True",null,"AB137",null,""]
[]
[]
[]
[]
["Höchster Schulabschluss","Highest level of education","False","True","D146","15,75;735",null,null,"cbx_Schulabschluss"]
["Höchste Berufsausbildung","Highest level of professional training","False","True","AB146","348,75;735",null,null,"cbx_Berufsausbildung"]
[]
[]
["Wöchentliche Arbeitszeit Urlaubsanspruch","Weekly working hours Holiday entitlement",null,null,"D155;P155",null,";"]
["Vertragsform","Type of contract","True","True","AB155","348,75;776,25",null,null,"cbx_Vertragsform"]
["Wöchentliche Arbeitszeit","Weekly working hours",null,null,"E164;Q164;AC164;AO164;E168;Q168;AC168",null,";;;;;;"]
["Kostenstelle","Cost centre","True",null,"D177",null,""]
["Abteilungsnummer","Department number","True",null,"AB177",null,""]
["Im Baugewerbe beschäftigt seit (TT.MM.JJJJ)","Employed in construction industry since (DD.MM.YYYY)",null,null,"D186",null,""]
["Personengruppe","Person group","True","True","AB186","348,75;924",null,null,"cbx_Personengruppe"]
["Status bei Beginn der Beschäftigung","Status at beginning of employment","False","True","D195","15,75;965,25",null,null,"cbx_Status_Beschaeftigung"]
["Art der Befristung","Type of fixed-term contract","True","True","D207","15,75;1032",null,null,"cbx_Art_der_Befristung"]
[" "," ","True","True","AB207","348,75;1032",";"]
["Befristung Arbeitsvertrag zum (TT.MM.JJJJ)","Employment contract fixed until (DD.MM.YYYY)","True",null,"D216",null,""]
["Abschluss Arbeitsvertrag am (TT.MM.JJJJ)","Employment contract concluded on (DD.MM.YYYY)","True",null,"AB216",null,""]
[]
[]
["Identifikationsnummer","Identification No.",null,null,"D228",null,""]
["Steuerklasse, Faktor","Tax class, Factor",null,null,"AB228;AN228",null,";"]
["Kinderfreibetrag","Number of exemptions for children",null,null,"D237",null,""]
["Konfession","(Religious) Denomination","False","True","AB237","348,75;1181,25",null,null,"cbx_Konfession"]
["Pauschalierung","Blanket allowance","True","True","D246","15,75;1222,5",null,null,"cbx_Pauschalierung"]
["Abwälzung an Arbeitnehmer","Burden shifted to employee","True","True","AB246","348,75;1222,5",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)"]
[]
[]
[]
[]
["UV-Gefahrtarif","Accident insurance risk tariff","True",null,"D267",null,""]
["Krankenversicherung","Health insurance","False","True","D258","15,75;1289,25",null,null,"cbx_Krankenversicherung"]
["Name Krankenkasse/Private Versicherung","Name of state/private insurer",null,null,"AB258",null,""]
["RV-Option","Pension insurance option","False","True","AB277:AV277","15,75;1384,5",""]
["Entlohnung","Remuneration",null,null,"D289;L289;T289;AB289;AN289",null,";;;;"]
["Entlohnung 2","Remuneration 2",null,null,"D298;L298;T298;AB298;AN298",null,";;;;"]
[]
[]
[]
[]
[]
[]
["Empfänger VWL","Recipient",null,null,"D310",null,""]
["Betrag, AG-Anteil","Amount Employer share",null,null,"AB310;AN310",null,";"]
["seit wann (TT.MM.JJJJ)","since (DD.MM.YYYY)",null,null,"D319",null,""]
["Vertragsnummer","Contract number",null,null,"AB319",null,""]
["Kontonummer Bankleitzahl","Bank account number Sort code"]
["Bankbezeichnung","Name of bank institute"]
["IBAN","IBAN",null,null,"D328",null,""]
["BIC","BIC",null,null,"AB328",null,""]
[]
[]
[]
[]
[]
["Angaben zu weiteren Beschäftigungen","Information on additional employment",null,null,"D341;L341;T341;AF341;AR341",1723.5,null,null,"cbx_weitere_Beschaeftigungen"]
["Angaben zu weiteren Beschäftigungen 2","Information on additional employment 2",null,null,"D350;L350;T350;AF350;AR350",1764.75,null,null,"cbx_weitere_Beschaeftigungen_2"]
[]
[]
[]
["Bea","Bea"]
["EUR450-Option","EUR450-Option","False","True","AN360:AV360",1808]
[]
[]
[]
[]
[]
["DEÜV-Status","DEÜV-status","True","True","AB267","348,75;1330,5",null,null,"cbx_DEUEV"]

{"sheet":"Listen","index":2,"n_rows":24,"n_cols":31,"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","ja","0 - keine Angabe"]
["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","nein","1 - Ehegatte/Lebenspartner/Abkömmling"]
["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,"3 - Ermäßigter Beitrag","3 - 1/2 Beitrag zur Rentenversicherung","2 - Halber Beitrag zur BA","2 - Halber Beitrag zur gesetzlichen PV",null,null,"kurzfristig beschäftigt",null,null,"2 - geschäftsführender Gesellschafter (GmbH)"]
["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,"4 - Beitrag zur landwirtschaftlichen KV","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,"5 - Arbeitgeberbeitrag 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 - Pauschalbetrag für geringfügig 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":31,"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 - Private health insurance","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","yes","0 - no specification"]
["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","no","1 - spouse/cohabitant/descendant"]
["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,"3 - Reduced 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",null,null,"2 - managing partner (GmbH)"]
["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,"4 - Contribution to agricultural sickness fund","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,"5 - Employer contribution to agricultural sickness fund"]
["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 - Flat-rate contribution for low-wage 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 - 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":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Gewählter Fragebogen","GfB/Minijob"]
["Sprache PFB","Deutsch"]
["Eigenes Logo","X"]
[]
["Initialisierung durchgeführt","X"]
["Fragebogen erzeugt","X"]
["Fragebogen geändert"]
["Beraternummer"]
["Mandantennummer"]
[]
["Allgemein"]
["Persönliche Angaben",46]
["Beschäftigung",121]
["Befristung",200]
["Steuer",221]
["Sozialversicherung",251]
["Entlohnung",282]
[]
["VWL",303]
[]
["weitere Beschäftigungen",333]
[]
["Bea"]
["Angaben zu den Arbeitspapieren"]
["Arbeitnehmererklärung"]