{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1-Calculs préparatoires","2-Journal rubriques AED","3-Bilan AED"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"1-Calculs préparatoires","index":0,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[11,1,11,3],[5,1,5,3],[2,1,3,3],[1,1,1,3]]}
[]
[null,"Notice : remplir les cases colorées. "]
[null,"Nota : il se peut que certaines cases ne figurent pas dans le journal et/ou soient à zéro. Dans ce cas ne rien inscire dans la case."]
[]
[]
[null,"AED"]
[]
[null,"ANNEE BUDGETAIRE ",null,"® Saisir l'année (ex : 2023)"]
[null,"MOIS ANNEE",null,"® Saisir le mois et l'année (ex: 01/2023)"]
[null,"RNE ETABLISSEMENT",null,"® Saisir le RNE de l'établissement"]
[]
[null,"Calculs préparatoires"]
[null,"PSC INDEMNITE PSC",null,"Indemnité PSC"]
[null,"A01 BRUT SOUMIS",null,"Brut"]
[null,"ACS TOT COT SAL",null,"Cotisations salariales"]
[null,"Total A",{"$f":"C13+C14-C15","v":0}]
[null,"PTM REMB. TRANSPORT",null,"Remboursement titres de transports"]
[null,"TMD MOBILITE DURABLE",null,"Forfait mobilités durables"]
[null,"SA1 SAISIE",null,"Saisie sur rémunération"]
[null,"SA2 SAISIE",null,"Saisie sur rémunération"]
[null,"SA3 SAISIE",null,"Saisie sur rémunération"]
[null,"SA4 SAISIE",null,"Saisie sur rémunération"]
[null,"SA5 SAISIE",null,"Saisie sur rémunération"]
[null,"SPA PENSION ALIMENT",null,"Saisie sur rémunération"]
[null,"VB5 REPRISE DACOMPTE",null,"Acompte sur salaire"]
[null,null,{"$f":"C16+C17+C18+C19+C20+C21+C22+C23+C24+C25","v":0}]
[]
[]
[null,"975 NET A PAYER",null,"Net à payer selon journal"]
[null,null,{"$f":"C17+C18","v":0},"Remboursement titres de transports"]
[null,null,{"$f":"C29-C30","v":0},"Net à mandater au 6447"]
[]
[null,"Différence",{"$f":"C26-C29","v":0},"Différence correspond au PAS"]

{"sheet":"2-Journal rubriques AED","index":1,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[48,2,48,3],[12,1,12,2],[1,1,1,4],[2,1,3,4],[5,1,5,4],[11,1,11,4],[45,3,45,4]]}
[]
[null,"Notice : remplir les cases colorées. Valeurs positives uniquement."]
[null,"Nota : il se peut que certaines cases ne figurent pas dans le journal et/ou soient à zéro. Dans ce cas ne rien inscire dans la case."]
[]
[]
[null,"AED"]
[]
[null,"ANNEE BUDGETAIRE ",{"$f":"'1-Calculs préparatoires'!C8","v":0}]
[null,"MOIS ANNEE",{"$f":"'1-Calculs préparatoires'!C9","v":"00:00:00"}]
[null,"RNE ETABLISSEMENT",{"$f":"'1-Calculs préparatoires'!C10","v":0}]
[]
[null,"JOURNAL DES RUBRIQUES"]
[null,"RUBRIQUE DE PAIE",null,"PARTS SALARIALES","PARTS PATRONALES"]
[null,"UM1 & UE1","MALADIE & MALADIE AL/MO"]
[null,"UM6","VIEILLESSE"]
[null,"UP1","VIEILLESSE TR.A"]
[null,"UIA ","IRCANTEC TR A"]
[null,"UIF ","IRCANTEC TR B"]
[null,"UN6","CSG NON DEDUCTIBLE"]
[null,"UN1","CSG DEDUCTIBLE"]
[null,"UD1","RDS"]
[null,"UF5","UF5 ALLOC.FAM.REDUIT"]
[null,"UFA","UFA ALLOC.FAM.COMPL."]
[null,"UAT","UAT ACCIDENT TRAVAIL"]
[null,"US1","US1 SOL. AUTONOMIE"]
[null,"UKE","UKE CHOMAGE"]
[null,"FM1","FM1 FNAL TR.A"]
[null,"UT0","UT0 TAXE TRANSPORT"]
[null,"CFS","CFS FORFAIT SOCIAL"]
[null,"HRF","HRF REDUC HS EXO AED"]
[null,"UTA","UTA TAXE SALAIRE TR0"]
[null,"UTB","UTB TAXE SALAIRE TR1"]
[null,"UTC","UTC TAXE SALAIRE TR2"]
[null,"PTM","REMB. TRANSPORT",{"$f":"'1-Calculs préparatoires'!C17","v":0}]
[null,"TMD ","MOBILITE DURABLE",{"$f":"'1-Calculs préparatoires'!C18","v":0}]
[null,"SA1","SAISIE",{"$f":"-'1-Calculs préparatoires'!C19","v":0}]
[null,"SA2","SAISIE",{"$f":"-'1-Calculs préparatoires'!C20","v":0}]
[null,"SA3","SAISIE",{"$f":"-'1-Calculs préparatoires'!C21","v":0}]
[null,"SA4","SAISIE",{"$f":"-'1-Calculs préparatoires'!C22","v":0}]
[null,"SA5","SAISIE",{"$f":"-'1-Calculs préparatoires'!C23","v":0}]
[null,"SPA","PENSION ALIMENT",{"$f":"-'1-Calculs préparatoires'!C24","v":0}]
[null,"VB5","REPRISE DACOMPTE",{"$f":"-'1-Calculs préparatoires'!C25","v":0}]
[null,975,"NET A PAYER",{"$f":"'1-Calculs préparatoires'!C31","v":0}]
[null,null,"PAS",{"$f":"'1-Calculs préparatoires'!C33","v":0}]
[null,null,"SOUS-TOTAL",{"$f":"SUM(D14:D44)","v":0},{"$f":"SUM(E14:E44)","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D45:E45)","v":0}]
[]
[]
[null,null,"Vérification des cotisations"]
[null,null,"ACP TOT COT PAT",{"$f":"SUM(E14:E33)","v":0}]
[null,null,"ACS TOT COT SAL",{"$f":"SUM(D14:D33)","v":0}]
[null,null,"APA Montant PAS",{"$f":"'1-Calculs préparatoires'!C33","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D50:D52)","v":0}]

{"sheet":"3-Bilan AED","index":2,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[24,2,24,3],[4,1,4,4],[5,1,5,4],[8,1,10,1],[8,4,10,4],[11,1,20,1],[12,4,16,4],[18,4,19,4]]}
[null,"ANNEE BUDGETAIRE ",{"$f":"'2-Journal rubriques AED'!C8","v":0}]
[null,"MOIS ANNEE",{"$f":"'2-Journal rubriques AED'!C9","v":"00:00:00"}]
[null,"RNE ETABLISSEMENT",{"$f":"'2-Journal rubriques AED'!C10","v":0}]
[]
[null,{"$f":"'[1]2 -journal AED'!$B$11","v":"AED"}]
[null,"BILAN COMPTABLE"]
[]
[null,"Charges\nde personnels","Libellé","Montants","Sommes"]
[null,"Net à payer","MONTANT NET     6447",{"$f":"'2-Journal rubriques AED'!D43","v":0},{"$f":"D9+D10+D11","v":0}]
[null,null,"REMB. TRANSPORT     6251",{"$f":"'2-Journal rubriques AED'!D34+'2-Journal rubriques AED'!D35","v":0}]
[null,null,"ACOMPTE     6447",{"$f":"'2-Journal rubriques AED'!D42","v":0}]
[null,"Charges sociales","SAISIE SUR SALAIRE     6447",{"$f":"SUM('2-Journal rubriques AED'!D36:D41)","v":0},{"$f":"D12","v":0}]
[null,null,"URSSAF SALARIAL     6447",{"$f":"'2-Journal rubriques AED'!D14+'2-Journal rubriques AED'!D15+'2-Journal rubriques AED'!D16+'2-Journal rubriques AED'!D19+'2-Journal rubriques AED'!D20+'2-Journal rubriques AED'!D21-'2-Journal rubriques AED'!D30","v":0},{"$f":"D13+D14+D15+D16+D17","v":0}]
[null,null,"URSSAF PATRONAL    6451",{"$f":"'2-Journal rubriques AED'!E14+'2-Journal rubriques AED'!E15+'2-Journal rubriques AED'!E16+'2-Journal rubriques AED'!E22+'2-Journal rubriques AED'!E23+'2-Journal rubriques AED'!E24+'2-Journal rubriques AED'!E25+'2-Journal rubriques AED'!E29","v":0}]
[null,null,"TAXE TRANSPORT     6331",{"$f":"'2-Journal rubriques AED'!E28","v":0}]
[null,null,"FNAL    6332",{"$f":"'2-Journal rubriques AED'!E27","v":0}]
[null,null,"ASS CHOMAGE     6454",{"$f":"'2-Journal rubriques AED'!E26","v":0}]
[null,null,"TAXE SALAIRE     631",{"$f":"'2-Journal rubriques AED'!E31+'2-Journal rubriques AED'!E32+'2-Journal rubriques AED'!E33","v":0},{"$f":"D18","v":0}]
[null,null,"IRCANTEC PATRONAL    6453",{"$f":"'2-Journal rubriques AED'!E17+'2-Journal rubriques AED'!E18","v":0},{"$f":"D19+D20","v":0}]
[null,null,"IRCANTEC SALARIAL     6447",{"$f":"'2-Journal rubriques AED'!D17+'2-Journal rubriques AED'!D18","v":0}]
[null,null,"IMPOT SUR LES REVENUS    6338",{"$f":"'2-Journal rubriques AED'!D44","v":0},{"$f":"D21","v":0}]
[null,null,"TOTAL A MANDATER",{"$f":"SUM(D9:D21)","v":0},{"$f":"SUM(E9:E21)","v":0}]
[]
[]
[null,null,"Vérifications avec"]
[null,null,"Cotisations salariales",{"$f":"D13+D20","v":0}]
[null,null,"Cotisations patronales",{"$f":"D14+D15+D16+D17+D18+D19","v":0}]
[null,null,"Montant net + rmb. transp. + acompte + saisie arrêt",{"$f":"SUM(D9:D12)","v":0}]
[null,null,"Impôt sur les revenus",{"$f":"D21","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D26:D29)","v":0}]