{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Accueil","Suivi Récouvrement","Régistre Récouvrement","Quittance","Paramétrages"],"not_rendered":{"charts":0,"images":22,"macros":1,"external_links":0,"defined_names":6,"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":"Accueil","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Suivi Récouvrement","index":1,"n_rows":24,"n_cols":31,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,17,1,28],[1,2,1,5],[1,6,1,9],[1,10,1,13]]}
[]
["Code ",null,"Propriétaire(s)",null,null,null,"Locataire(s)",null,null,null,"Bien(s)",null,null,null,"Montant","Status","Acompte","Année 2020",null,null,null,null,null,null,null,null,null,null,null,"Nbre de ","Impayé"]
["Suivi Récouv.","Contrat","Civilité","Prénom","Nom","Code Pro:","Civilité","Prénom","Nom","Code Loc:","Localisation","Type","Domicile","Code Loc","Loyer"," Contrat","Versé","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","mois de Retard","TOTAL"]
["REC0044","BA0044","M","Dofing","COULIBALY","PRO0001","M","Mamadou","COULIBALY","LOC0042","BAMAKO","Appartement","Kalaban-Coura","BI0046",42500,"Résilier"]
["REC0048","BA0048","M","Dofing","COULIBALY","PRO0001","M","Mamadou","KONE","LOC0046","BAMAKO","Boutique","Kalaban-Coura","BI0050",10000,"Encours",null,"2020-02-05","2020-03-05","2020-04-05","2020-05-05"]
["REC0073","BA0073","M","Dofing","COULIBALY","PRO0001","M","Mamadou","KONE","LOC0046","BAMAKO","Appartement","Kalaban-Coura","BI0053",35000,"Encours",null,"-","-","-","2020-04-15"]
["REC0070","BA0070","M","Dofing","COULIBALY","PRO0001","M","Mamadou","N'DIAYE","LOC0069","BAMAKO","Appartement","Kalaban-Coura","BI0064",50000,"Encours",null,"2020-03-05","2020-03-05","2020-03-05","2020-03-05"]
["REC0032","BA0032","M","Dofing","COULIBALY","PRO0001","M","Mamady","FOFANA","LOC0031","BAMAKO","Appartement","Kalaban-Coura","BI0034",45000,"Encours",null,"2020-02-05","2020-04-05","2020-04-05"]
["REC0007","BA0007","M","Dofing","COULIBALY","PRO0001","M","Mamoudou","CAMARA","LOC0007","KATI","Appartement","Coco-Plaine","BI0008",47500,"Encours",null,"2020-02-23","2020-03-04","2020-03-30","2020-05-05"]
["REC0056","BA0056","M","Dofing","COULIBALY","PRO0001","M","Modibo","AMARA","LOC0052","BAMAKO","Appartement","Kalaban-Coura","BI0058",50000,"Encours",null,"2020-02-13","2020-03-07","2020-05-06","2020-05-06"]
["REC0003","BA0003","M","Dofing","COULIBALY","PRO0001","M","Modibo","DIALLO","LOC0002","KATI","Appartement","Coco-Plateau","BI0002",45000,"Encours",null,"2020-02-05","2020-03-04","2020-04-01","2020-05-02"]
["REC0001","BA0001","M","Dofing","COULIBALY","PRO0001","M","Modibo","DIARRA","LOC0001","KATI","Maison","Coco-Plateau","BI0001",40000,"Encours",null,"2020-01-28","2020-02-23","2020-04-02","2020-05-04"]
["REC0025","BA0025","M","Dofing","COULIBALY","PRO0001","M","Modibo","TRAORE","LOC0025","BAMAKO","Appartement","Kalaban-Coura","BI0027",35000,"Encours",null,"2020-02-05","2020-03-05","2020-04-04","2020-05-05"]
["REC0043","BA0043","M","Dofing","COULIBALY","PRO0001","M","Mohamed","DABO","LOC0041","BAMAKO","Maison","Kalaban-Coura","BI0045",150000,"Encours",null,"2020-02-22","2020-04-04"]
["REC0072","BA0072","M","Dofing","COULIBALY","PRO0001","M","Mohamed","DOUMBIA","LOC0071","BAMAKO","Appartement","Kalaban-Coura","BI0049",50000,"Encours",null,"-","-","-","2020-04-07"]
["REC0016","BA0016","M","Dofing","COULIBALY","PRO0001","M","Moussa","BERTHE","LOC0016","KATI","Appartement","Kati-Coro","BI0017",30000,"Résilier",null,"2020-02-05",{"$f":"IF($A16=\"\",\"\",IF($P16=\"Résilier\",\"-\",IF(TODAY()<VLOOKUP(S$3,Paramétrages!#REF!,3,FALSE),\"Non dûs\",IF(TODAY()=VLOOKUP(S$3,Paramétrages!#REF!,3,FALSE),\"Encours\",IF(TODAY()>VLOOKUP(S$3,Paramétrages!#REF!,3,FALSE),\"Rétard\")))))","v":"-"},{"$f":"IF($A16=\"\",\"\",IF($P16=\"Résilier\",\"-\",IF(TODAY()<VLOOKUP(T$3,Paramétrages!#REF!,3,FALSE),\"Non dûs\",IF(TODAY()=VLOOKUP(T$3,Paramétrages!#REF!,3,FALSE),\"Encours\",IF(TODAY()>VLOOKUP(T$3,Paramétrages!#REF!,3,FALSE),\"Rétard\")))))","v":"-"},{"$f":"IF($A16=\"\",\"\",IF($P16=\"Résilier\",\"-\",IF(TODAY()<VLOOKUP(U$3,Paramétrages!#REF!,3,FALSE),\"Non dûs\",IF(TODAY()=VLOOKUP(U$3,Paramétrages!#REF!,3,FALSE),\"Encours\",IF(TODAY()>VLOOKUP(U$3,Paramétrages!#REF!,3,FALSE),\"Rétard\")))))","v":"-"}]
["REC0068","BA0068","M","Dofing","COULIBALY","PRO0001","M","Moussa","CAMARA","LOC0067","BAMAKO","Appartement","Kalaban-Coura","BI0056",35000,"Encours",null,"-","2020-02-08","2020-04-05","2020-05-05"]
["REC0041","BA0041","M","Dofing","COULIBALY","PRO0001","M","Moussa","KOUREICHI","LOC0061","BAMAKO","Appartement","Kalaban-Coura","BI0043",35000,"Encours",null,"2020-02-05","2020-03-05","2020-04-05","2020-05-05"]
["REC0064","BA0064","M","Dofing","COULIBALY","PRO0001","M","Moussa","OUATTARA","LOC0063","BAMAKO","Appartement","Kalaban-Coura","BI0046",50000,"Encours",null,"2019-12-28","2020-03-07","2020-04-05","2020-05-05"]
["REC0034","BA0034","M","Dofing","COULIBALY","PRO0001","M","Ousmane Sy","BALLO","LOC0033","BAMAKO","Appartement","Kalaban-Coura","BI0036",35000,"Encours",null,"2020-02-05","2020-03-05","2020-04-05","2020-05-05"]
["REC0002","BA0002","M","Dofing","COULIBALY","PRO0001","M","Salif","DOUMBIA","LOC0003","KATI","Appartement","Coco-Plateau","BI0003",45000,"Encours",null,"2020-01-27","2020-03-02","2020-03-29","2020-04-29"]
["REC0033","BA0033","M","Dofing","COULIBALY","PRO0001","M","Sékou","DIALLO","LOC0032","BAMAKO","Appartement","Kalaban-Coura","BI0035",20000,"Encours",null,"2020-02-05","2020-03-05","2020-04-05","2020-05-05"]
["REC0035","BA0035","M","Dofing","COULIBALY","PRO0001","M","Sékou","KOUREICHY","LOC0034","BAMAKO","Appartement","Kalaban-Coura","BI0037",35000,"Encours",null,"2020-02-05","2020-03-05","2020-04-05","2020-05-05"]
["REC0029","BA0029","M","Dofing","COULIBALY","PRO0001","M","Sékou","NOMOKO","LOC0028","BAMAKO","Appartement","Kalaban-Coura","BI0031",50000,"Encours",null,"2020-02-05","2020-03-05","2020-04-05","2020-05-05"]

{"sheet":"Régistre Récouvrement","index":2,"n_rows":2,"n_cols":23,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Code Régist. Récouvr.","Code Suivi. Récouvr.","Code Baux. Locat.","Civilité","Prénom Propriétaire","Nom Propriétaire","Code Pro","Civilité","Prénom Locataire","Nom Locataire","Code Loc","Localisation","Type Bien","Domicile Bien","Code Bien","Mensualité","Mois","Année","Montant Encaissé","Montant Décaissé","Acompte Restant","Mode de Payement","Observation"]

{"sheet":"Quittance","index":3,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":true,"merged":[[2,2,2,4],[17,2,17,4],[35,3,35,6],[48,8,48,9],[22,9,22,10],[22,2,22,8],[11,2,11,4],[16,2,16,4],[19,8,19,10],[34,2,34,8],[16,6,16,8],[17,6,17,8],[19,6,19,7],[20,6,20,7],[53,2,54,10],[28,2,32,10],[42,2,45,10]]}
[]
[]
[null,null,"Bailleur"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"APPEL DE LOYER N°               "]
[null,null,"Date d'émission","Date d'échéance","Réf. Contrat"]
[]
[null,null,"Références à rappeler avec toute correspondance"]
[]
[null,null,"Lot (Réf.                   )",null,null,null,"Période",null,null,"Début","Fin"]
[]
[]
[null,null,null,null,null,null,"Code",null,"Locataire (s)"]
[]
[]
[null,null,"Référence",null,null,null,null,null,null,"Montant"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(K24:K26)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"DETAIL DES PAIEMENTS"]
[null,null,"Date","Mode de paiement / référence",null,null,null,"Remb.","Montant"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(I37:I40)-SUM(H37:H40)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Le propriétaire"]
[]
[]
[]
[]
[null,null,"La présente quittance ne libère l'occupant que pour la période indiquée et annule tout reçu à valoir. Elle n'est pas libératoire des loyers antérieurs impayés et est délivrée sous réserve de toutes instances judiciaires en cours."]

{"sheet":"Paramétrages","index":4,"n_rows":12,"n_cols":25,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,7,1,26],[5,7,5,9],[5,11,5,13],[5,15,5,17],[5,19,5,21],[5,23,5,25],[4,7,4,9],[4,11,4,13],[4,15,4,17],[4,19,4,21],[4,23,4,25],[6,7,6,9],[6,11,6,13],[6,15,6,17],[6,19,6,21],[6,23,6,25],[7,7,7,9],[7,11,7,13],[7,15,7,17],[7,19,7,21],[7,23,7,25],[8,7,8,9],[8,11,8,13],[8,15,8,17],[8,19,8,21],[8,23,8,25],[9,7,9,9],[9,11,9,13],[9,15,9,17],[9,19,9,21],[9,23,9,25],[10,7,10,9],[10,11,10,13],[10,15,10,17],[10,19,10,21],[10,23,10,25],[11,7,11,9],[11,11,11,13],[11,15,11,17],[11,19,11,21],[11,23,11,25],[12,7,12,9],[12,11,12,13],[12,15,12,17],[12,19,12,21],[12,23,12,25],[13,7,13,9],[13,11,13,13],[13,15,13,17],[13,19,13,21],[13,23,13,25],[14,11,14,13],[14,15,14,17],[14,19,14,21],[14,23,14,25],[15,11,15,13],[15,15,15,17],[15,19,15,21],[15,23,15,25],[16,11,16,13],[16,15,16,17],[16,19,16,21],[16,23,16,25],[17,11,17,13],[17,15,17,17],[17,19,17,21],[17,23,17,25],[18,11,18,13],[18,15,18,17],[18,19,18,21],[18,23,18,25],[19,11,19,13],[19,15,19,17],[19,19,19,21],[19,23,19,25],[20,11,20,13],[20,15,20,17],[20,19,20,21],[20,23,20,25],[21,11,21,13],[21,15,21,17],[21,19,21,21],[21,23,21,25],[22,11,22,13],[22,15,22,17],[22,19,22,21],[22,23,22,25],[23,11,23,13],[23,15,23,17],[23,19,23,21],[23,23,23,25]]}
[]
[null,null,null,null,null,null,null,"Paramétrages"]
[]
[null,null,null,null,null,null,null,null,"H",null,null,null,"L",null,null,null,"P",null,null,null,"T",null,null,null,"X"]
[null,null,"Compteurs",null,null,"Codage",null,"Modes de Paiement",null,null,null,"Charges",null,null,null,"Civilités",null,null,null,"Types de biens",null,null,null,"Classe"]
[null,"Locataires",73,null,"Locataires","LOC",null,null,null,null,null,null,null,null,null,null,null,null,null,"F2",null,null,null,"Boutique"]
[null,"Biens",66,null,"Biens","BI",null,"Argent Liquide",null,null,null,"Taxes Ordures Ménagères",null,null,null,"M",null,null,null,"F3",null,null,null,"Maison"]
[null,"Baux",76,null,"Baux","BA",null,"Virement Bancaire",null,null,null,"Gestion Compte",null,null,null,"Mme",null,null,null,"F4",null,null,null,"Appartement"]
[null,"Registre",0,null,"Registre","Enr",null,"Transfert Orange Money",null,null,null,null,null,null,null,"Mlle",null,null,null,"F5",null,null,null,"Garage"]
[null,"Quittances",0,null,"Quittances","CA",null,"Transfert Mobi Cash",null,null,null,null,null,null,null,"M. et Mme",null,null,null,"F6",null,null,null,"Box"]
[null,"Bailleurs",1,null,"Bailleurs","PRO"]
[null,"Suivi Récouv.",76,null,"Suivi Récouv.","REC"]