{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Données","Bulletin de Paie"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Données","index":0,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":true,"merged":[[10,5,10,6],[63,7,63,8],[17,7,17,8],[10,15,10,16],[53,5,53,6],[56,5,56,6],[51,5,51,6],[52,5,52,6],[62,7,62,8],[57,5,57,6],[55,5,55,6],[54,5,54,6],[10,25,10,26],[10,11,10,12],[10,13,10,14],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,24],[7,14,8,15],[28,5,28,6],[29,5,30,6],[64,7,64,8],[37,1,37,2],[48,0,48,1],[60,7,60,8],[7,0,8,2],[58,0,58,1],[54,0,54,1],[57,0,57,1],[46,0,46,1],[45,0,45,1],[31,2,33,3],[49,0,49,1],[55,0,55,1],[0,6,0,7],[7,11,8,13],[35,0,36,0],[10,3,10,4],[61,7,61,8],[29,4,30,4],[9,0,9,4],[29,2,30,3],[29,1,30,1],[7,3,8,4],[58,7,58,8],[59,7,59,8],[29,0,30,0],[38,1,38,2],[35,1,36,2],[36,7,37,8]]}
["Année",2025,null,{"$error":"#VALUE!"}]
[]
["OUI","CDI"]
["NON","CDD à terme imprécis"]
[]
[]
[null,null,null,null,null,null,null,"V 1-0-4","Modifications contenu notes Indemnités repas"]
["COTISATIONS SOCIALES",null,null,{"$f":"\"Au 1er Janvier \" & Année","v":"Au 1er Janvier 2025"},null,null,null,"V 1-0-4","Ajout 3 notes sur zones PAS"]
[null,null,null,null,null,null,null,"V 1-0-4","Zone taux PAS mise en rose (zone saisissable)"]
["Base 100 % du salaire brut",null,null,null,null,null,null,"V 1-0-4","Feuille données : mise à jour indemnités"]
[null,null,null,"Janvier",null,null,null,"V 1-0-3","Affichage automatique des 29/30/31 du mois selon le mois saisi"]
[null,null,null,"Salariales","Patronales",null,null,"V 1-0-3","Souligement des dimanches dans le tableau d'heures"]
["Sécurité sociale (maladie, maternité, invalidité, décès, ",null,null,null,null,null,null,"V 1-0-2","Mise à jour Formule PAS/NET par Liliane"]
["vieillesse, allocations familales, accidents du travail)",null,null,{"$f":"IF('Bulletin de Paie'!R3=\"NON\",(7.3%),(8.6%))","v":7.2999999999999995E-2},0.29609999999999997,null,null,"V 1-0-2","Cadrage / Formatage zone commentaire"]
["FNAL  Fond national d'aide au logement",null,null,null,1E-3,null,null,"V 1-0-1","Déblocage de la zone taux PAS qui ne pouvait être saisie"]
["Contribution Solidarité Autonomie",null,null,null,3.0000000000000001E-3,null,null,"V 1-0","Mise en place PAS"]
["Formation professionnelle",null,null,null,8.5000000000000006E-3]
["Retraite complémentaire",null,null,4.0099999999999997E-2,6.0100000000000001E-2]
["Ircem prévoyance +  DS + IDV Retraite +  Fived",null,null,1.04E-2,2.4500000000000001E-2]
["Réduction sur cotisation HC/HM",null,null,0.11310000000000001,6.0000000000000001E-3]
["Assurance chômage",null,null,null,4.0500000000000001E-2]
["Contribution au dialogue social",null,null,null,1.6000000000000001E-4]
["Contribution Santé au Travail (CST)",null,null,null,2.7E-2]
["Base 98,25 % du salaire brut",null,0.98250000000000004]
["CSG + CRDS non déductible sur le salaire de base",null,null,2.9000000000000001E-2]
["CSG déductible sur le salaire de base",null,null,6.8000000000000005E-2]
[]
[]
["Indemnités","Base"]
["Indemnités d'entretien","Base",{"$f":"\"MG\nAu 1er janvier \" & Année","v":"MG\nAu 1er janvier 2025"}]
[]
["Indemnité entretien Journées 6,16 heures ou moins",2.65,4.22]
["Indemnité entretien Journées de 9 heures ou plus",{"$f":"ROUND(C32*0.9,2)","v":3.8},null,null,{"$f":"B33/9","v":0.42222222222222222}]
["Indemnité entretien à partir de la 10ème heure",{"$f":"B33/9","v":0.42222222222222222}]
[]
["TAUX DE CHARGES ",{"$f":"\"Au 1er Janvier \" & Année","v":"Au 1er Janvier 2025"}]
[]
["TAUX DE CHARGES ",{"$f":"(D14+D18+D19+D21)+(((D25+D26)*98.25)/100)","v":0.21880250000000001}]
["COEFFICIENT MULTIPLICATEUR brut --> net",{"$f":"1-B38","v":0.78119749999999999}]
[]
[{"$f":"\"Copyright \" & Année & \" - Reproduction interdite - Tous droits réservés à UNSA-PROASSMAT\"","v":"Copyright 2025 - Reproduction interdite - Tous droits réservés à UNSA-PROASSMAT"}]
[]
[]
["CONGES PAYES pour FP de JANVIER à MAI"]
[]
[{"$f":"\"01/06/\" & Année-1&\" au\"","v":"01/06/2024 au"}]
[{"$f":"\"31/05/\" & Année & \" (N)\"","v":"31/05/2025 (N)"}]
[]
[{"$f":"\"01/06/\" & Année-2 & \" au\"","v":"01/06/2023 au"}]
[{"$f":"\"31/05/\" & Année-1 & \" (N-1)\"","v":"31/05/2024 (N-1)"}]
[]
[]
["CONGES PAYES pour FP de JUIN à DECEMBRE"]
[]
[{"$f":"\"01/06/\" & Année & \" au\"","v":"01/06/2025 au"}]
[{"$f":"\"31/05/\" & Année+1 & \" (N)\"","v":"31/05/2026 (N)"}]
[]
[{"$f":"\"01/06/\" & Année-1 & \" au\"","v":"01/06/2024 au"}]
[{"$f":"\"31/05/\" & Année & \" (N-1)\"","v":"31/05/2025 (N-1)"}]

{"sheet":"Bulletin de Paie","index":1,"n_rows":88,"n_cols":26,"rows_kept":88,"cut":false,"hidden":false,"merged":[[1,16,1,17],[2,16,3,16],[2,17,3,17],[70,13,70,14],[72,0,72,14],[62,0,63,4],[62,5,63,6],[59,0,59,5],[53,7,53,13],[1,0,1,6],[1,7,1,14],[2,0,2,1],[2,2,2,6],[2,7,2,8],[2,9,2,14],[6,2,6,6],[11,13,11,14],[5,0,5,1],[5,2,5,6],[5,7,5,8],[7,9,7,14],[10,0,10,14],[11,0,11,2],[52,0,52,3],[76,10,77,10],[76,12,77,13],[76,14,77,14],[73,10,74,10],[70,1,70,2],[55,7,56,14],[78,0,78,14],[76,11,77,11],[73,0,73,1],[73,2,73,3],[73,6,74,6],[73,7,74,8],[73,11,74,11],[73,14,74,14],[76,0,76,1],[77,2,77,3],[73,12,74,13],[73,9,74,9],[76,2,76,3],[76,6,77,6],[76,7,77,8],[76,9,77,9],[60,0,61,1],[61,7,68,14],[79,0,79,14],[77,0,77,1],[74,0,74,1],[74,2,74,3],[41,0,41,4],[46,0,46,4],[46,5,46,7],[51,0,51,3],[51,7,52,14],[49,7,49,12],[46,8,46,9],[57,14,58,14],[58,0,58,3],[53,0,53,3],[47,7,47,10],[48,7,48,11],[54,7,54,13],[49,0,50,4],[49,5,50,6],[50,7,50,11],[54,0,54,1],[70,3,70,4],[70,7,70,8],[70,10,70,11],[59,7,60,14],[36,0,36,4],[47,0,47,6],[28,0,28,4],[13,0,13,6],[23,0,23,6],[9,7,9,8],[22,0,22,1],[3,0,3,1],[5,9,5,14],[25,7,25,8],[11,4,11,6],[11,8,11,11],[24,0,24,6],[21,0,21,6],[48,0,48,6],[22,2,22,6],[12,13,12,14],[27,0,27,5],[27,6,27,7],[27,8,27,9],[12,8,12,11],[57,7,58,13],[0,9,0,12],[0,2,0,8],[4,0,4,1],[4,9,4,14],[4,2,4,6],[4,7,4,8],[0,13,0,14],[6,9,6,14],[12,4,12,6],[7,7,7,8],[6,7,6,8],[3,7,3,8],[9,9,9,11],[8,10,8,11],[6,0,6,1],[8,12,8,14],[3,2,3,6],[7,0,7,1],[9,0,9,6],[7,2,7,6],[3,9,3,14],[0,0,0,1],[8,7,8,8],[8,0,8,6]]}
[{"$f":"Données!D1","v":{"$error":"#VALUE!"}},null,"Bulletin de paie du mois de",null,null,null,null,null,null,"2025-01-01",null,null,null,{"$f":"Année","v":2025}]
["EMPLOYEUR",null,null,null,null,null,null,"SALARIE",null,null,null,null,null,null,null,null,"A REMPLIR OBLIGATOIREMENT"]
["Nom prénom",null,null,null,null,null,null,"Nom prénom",null,null,null,null,null,null,null,null,"Le salarié bénéficie-t-il du régime Haut Rhin, Bas Rhin, Moselle ?","NON",null,null,null,null,null,null,null,"NON"]
["Adresse",null,null,null,null,null,null,"Adresse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NON"]
["complément",null,null,null,null,null,null,"complément"]
["CP Ville",null,null,null,null,null,null,"CP Ville"]
["N°employeur",null,null,null,null,null,null,"N° sécurité sociale"]
["Nom, prénom de l'enfant",null,null,null,null,null,null,"N° salarié pajemploi"]
["Convention Collective des assistants maternels du particulier employeur  -  code NAF 8891.A",null,null,null,null,null,null,"Date d'embauche",null,null,"type contrat",null,"CDI"]
["Service des URSSAF - Centre national  Pajemploi - 43013 Le PUY en VELAY cedex",null,null,null,null,null,null,"Qualification :",null,"Assistant(e) maternel(le) Agréé(e)"]
[]
["Nombre semaines programmées :",null,null,null,"Heures normales par semaine",null,null,null,"Mensualisation (max 45h/semaine)",null,null,null,null,{"$f":"ROUND(IF(H12<45,(D12*H12)/12,(45*D12)/12),2)","v":0}]
[null,null,null,null,"Heures supplémentaires par semaine",null,null,null,"Heures supplémentaires mensualisées",null,null,null,null,{"$f":"ROUND(D12*H13/12,2)","v":0},null,null,null,null,null,"L+M+N","(L+M+N)<8"]
["REMUNERATION",null,null,null,null,null,null,"Base","Taux","Montant","Jour","Heures","H. compl","H. sup","H. contrac"]
["Salaire brut de base",null,null,null,null,null,null,{"$f":"N12","v":0},null,{"$f":"H15*I15","v":0},1,null,null,null,null,null,null,null,null,{"$f":"SUM(L15:N15)","v":0},{"$f":"IF(T15<8,T15,0)","v":0},{"$f":"IF(T15>=8,1,0)","v":0}]
["Heures supplémentaires au delà de 45h, mensualisées ",null,null,null,null,null,null,{"$f":"N13","v":0},{"$f":"I15","v":0},{"$f":"H16*I16","v":0},2,null,null,null,null,null,null,null,null,0,{"$f":"IF(T16<8,T16,0)","v":0},{"$f":"IF(T16>=8,1,0)","v":0}]
["Majoration des heures supplémentaires mensualisées :",null,null,null,null,0.25,null,null,{"$f":"I15*F17","v":0},{"$f":"H17*I17","v":0},3,null,null,null,null,null,null,null,null,0,0,0]
["Heures complémentaires",null,null,null,"majoration :",null,null,null,{"$f":"$I$15*(1+F18)","v":0},{"$f":"H18*I18","v":0},4,null,null,null,null,null,null,null,null,0,0,0]
["Heures supplémentaires",null,null,null,"majoration :",null,null,null,{"$f":"$I$15*(1+F19)","v":0},{"$f":"H19*I19","v":0},5,null,null,null,null,null,null,null,null,0,0,0]
["Absence de l'enfant",null,null,null,null,null,null,null,null,{"$f":"-H20*I20","v":0},6,null,null,null,null,null,null,null,null,0,0,0]
["Absence du salarié",null,null,null,null,null,null,null,null,{"$f":"-H21*I21","v":0},7,null,null,null,null,null,null,null,null,0,0,0]
["Indemnité de congés payés pendant le contrat",null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,0,0,0]
["Régularisation",null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,0,0,0]
["Indemnité compensatrice de congés payés  - ICCP - Uniquement à la rupture du contrat",null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,0,0,0]
["Prime de précarité si CDD",null,null,null,null,null,null,null,0.1,{"$f":"H25*I25","v":0},11,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,"Salaire brut",null,{"$f":"(SUM(J15:J25))","v":0},12,null,null,null,null,null,null,null,null,0,0,0]
["COTISATIONS SOCIALES",null,null,null,null,null,"SALARIALES",null,"PATRONALES",null,13,null,null,null,null,null,null,null,null,0,0,0]
["COTISATIONS SOCIALES",null,null,null,null,null,"SALARIALES",null,"PATRONALES",null,14,null,null,null,null,null,null,null,null,0,0,0]
["Base 100 % du salaire brut",null,null,null,null,"Base","Taux","Montant","Taux","Montant",15,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A13","v":"Sécurité sociale (maladie, maternité, invalidité, décès, "},null,null,null,null,{"$f":"J26","v":0},null,null,null,{"$f":"I30*F30","v":0},16,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A14","v":"vieillesse, allocations familales, accidents du travail)"},null,null,null,null,{"$f":"$J$26","v":0},{"$f":"Données!D14","v":7.2999999999999995E-2},{"$f":"F31*G31","v":0},{"$f":"Données!E14","v":0.29609999999999997},0,17,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A15","v":"FNAL  Fond national d'aide au logement"},null,null,null,null,0,null,null,{"$f":"Données!E15","v":1E-3},0,18,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A16","v":"Contribution Solidarité Autonomie"},null,null,null,null,0,null,null,{"$f":"Données!E16","v":3.0000000000000001E-3},0,19,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A17","v":"Formation professionnelle"},null,null,null,null,0,null,null,{"$f":"Données!E17","v":8.5000000000000006E-3},0,20,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A18","v":"Retraite complémentaire"},null,null,null,null,0,{"$f":"Données!D18","v":4.0099999999999997E-2},{"$f":"F35*G35","v":0},{"$f":"Données!E18","v":6.0100000000000001E-2},0,21,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A19","v":"Ircem prévoyance +  DS + IDV Retraite +  Fived"},null,null,null,null,0,{"$f":"Données!D19","v":1.04E-2},{"$f":"F36*G36","v":0},{"$f":"Données!E19","v":2.4500000000000001E-2},0,22,null,null,null,null,null,null,null,null,0,0,0]
["Réduction cotisation sur HC/HM",null,null,null,null,{"$f":"SUM(J16:J19)","v":0},0.11310000000000001,{"$f":"-F37*G37","v":0},null,0,23,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A21","v":"Assurance chômage"},null,null,null,null,0,{"$f":"Données!D21","v":0},{"$f":"F38*G38","v":0},{"$f":"Données!E21","v":4.0500000000000001E-2},0,24,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A22","v":"Contribution au dialogue social"},null,null,null,null,0,null,null,{"$f":"Données!E22","v":1.6000000000000001E-4},{"$f":"I39*F39","v":0},25,null,null,null,null,null,null,null,null,{"$f":"SUM(L39:N39)","v":0},{"$f":"IF(T39<8,T39,0)","v":0},{"$f":"IF(T39>=8,1,0)","v":0}]
[{"$f":"Données!A20","v":"Réduction sur cotisation HC/HM"},null,null,null,null,0,null,null,{"$f":"Données!E20","v":6.0000000000000001E-3},0,26,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A23","v":"Contribution Santé au Travail (CST)"},null,null,null,null,0,null,null,{"$f":"Données!E23","v":2.7E-2},{"$f":"MIN(F41*I41, 5)","v":0},27,null,null,null,null,null,null,null,null,{"$f":"SUM(L41:N41)","v":0},{"$f":"IF(T41<8,T41,0)","v":0},{"$f":"IF(T41>=8,1,0)","v":0}]
[{"$f":"Données!A24","v":"Base 98,25 % du salaire brut"},null,null,null,null,null,null,null,null,null,28,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A25","v":"CSG + CRDS non déductible sur le salaire de base"},null,null,null,null,{"$f":"J26*Données!C24","v":0},{"$f":"Données!D25","v":2.9000000000000001E-2},{"$f":"F43*G43","v":0},null,null,29,null,null,null,null,null,null,null,null,0,0,0]
[{"$f":"Données!A26","v":"CSG déductible sur le salaire de base"},null,null,null,null,{"$f":"F43","v":0},6.8000000000000005E-2,{"$f":"F44*G44","v":0},null,null,30,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,31,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Total cotisations sociales",null,null,null,null,{"$f":"ROUND(SUM(H30:H46),2)","v":0},null,null,{"$f":"ROUND(SUM(J30:J46),2)","v":0},null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,"Total ",null,null,null,{"$f":"SUM(L15:L47)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(U15:U47)","v":0},{"$f":"SUM(V15:V47)","v":0}]
[null,null,null,null,null,null,null,"Heures complémentaires du mois",null,null,null,null,{"$f":"SUM(M15:M47)","v":0}]
["Salaire net social",null,null,null,null,{"$f":"ROUND(J26-F47,2)","v":0},null,"Heures supplémentaires du mois",null,null,null,null,null,{"$f":"SUM(N15:N47)","v":0}]
[null,null,null,null,null,null,null,"Heures contractuelles rémunérées du  mois",null,null,null,null,null,null,{"$f":"SUM(O15:O47)+L48","v":0}]
["Indemnités  ",null,null,null,"Base","Nbre","Montant","JOURS & HEURES D'ACCUEIL (IRPP)"]
["IE - Indemnité entretien négociée au contrat (par jour)",null,null,null,null,null,{"$f":"F53*E53","v":0}]
["Indemnité entretien des hrs cplt et sup non mensualisées",null,null,null,null,null,{"$f":"F54*E54","v":0},"Nombre de jours de 8 heures ou plus d'activité",null,null,null,null,null,null,{"$f":"V48","v":0}]
["IN - Indemnité de repas",null,null,null,null,null,{"$f":"F55*E55","v":0},"Cumuls des heures des journées inférieures à 8 heures d'activité",null,null,null,null,null,null,{"$f":"U48","v":0}]
["IN - Indemnité de repas fourni par les parents",null,null,null,null,null,{"$f":"F56*E56","v":0},"POUR LA DECLARATION   PAJEMPLOI"]
["IK - Indemnité kilométrique",null,null,null,null,null,{"$f":"F57*E57","v":0}]
["Indemnité de rupture",null,null,null,null,null,null,"Nombre de jours d'activité à déclarer à pajemploi ",null,null,null,null,null,null,0]
["Autres"]
["Total des indemnités à régler :",null,null,null,null,null,{"$f":"ROUND(SUM(G53:G59),2)-G56","v":0},"Commentaires du mois"]
["Imposition à la source",null,"Base :",{"$f":"D71","v":0},"Montant :",null,{"$f":"+D61*D62","v":0}]
[null,null,"Taux :"]
["MONTANT NET A PAYER",null,null,null,null,{"$f":"F50+G60-G61","v":0}]
[]
[]
["Date paiement",null,null,"Signature de l'employeur"]
["Banque"]
["N°chèque ou virement"]
[]
[]
["MENSUEL","Net imposable ",null,{"$f":"J26-F37-F47+H43+SUM(G53:G57)","v":0},null,"IE + IN + IK",{"$f":"SUM(G53:G57)","v":0},"CUMUL ANNUEL ",null,"Net imposable",{"$f":"D71","v":0},null,"IE +IN + IK",{"$f":"G71","v":0}]
[]
["CONGES PAYES"]
[{"$f":"Données!A55","v":"01/06/2025 au"},null,"Nb de mois travaillés",null,null,"Jours enfants",null,"Total jrs ouvrables acquis",null,{"$f":"IF(ROUNDUP(E75/4*2.5+E74*2.5,0)+G74>30,(30),(ROUNDUP(E75/4*2.5+E74*2.5,0)+G74))","v":0},"Nb de jrs pris",null,"SOLDE",null,{"$f":"J74-L74","v":0}]
[{"$f":"Données!A56","v":"31/05/2026 (N)"},null,"Nb de semaines travaillées",null,null,"- 15 ans"]
[]
[{"$f":"Données!A58","v":"01/06/2024 au"},null,"Nb de mois travaillés",null,null,"Jours enfants",null,"Total jrs ouvrables acquis",null,{"$f":"IF(ROUNDUP(E78/4*2.5+E77*2.5,0)+G77>30,(30),(ROUNDUP(E78/4*2.5+E77*2.5,0)+G77))","v":0},"Nb de jrs pris",null,"SOLDE",null,{"$f":"J77-L77","v":0}]
[{"$f":"Données!A59","v":"31/05/2025 (N-1)"},null,"Nb de semaines travaillées",null,null,"- 15 ans"]
["Dans votre intérêt et pour vous aider à faire valoir vos droits, conservez votre bulletin de salaire sans limitation de durée"]
[{"$f":"Données!A41","v":"Copyright 2025 - Reproduction interdite - Tous droits réservés à UNSA-PROASSMAT"}]
[]
[{"$f":"INFO(\"version\")","v":"16.0"},"V6.20_31/01/2025","2025-01-01"]
[]
[]
[]
[]
[]
["Aucun droit n'ayant été cédé, ce fichier est la propriété de Céline SCHAAR"]