{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["RECAP","SUMUP","SUMUP2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"RECAP","index":0,"n_rows":1190,"n_cols":219,"rows_kept":1190,"cut":false,"hidden":false,"merged":[[1,48,1,52],[14,100,21,111],[1,0,1,7],[1,10,1,19],[1,24,1,28],[1,32,1,36],[1,40,1,44],[1,136,1,144],[1,56,1,60],[1,64,1,68],[1,73,1,83],[1,93,1,95],[1,96,1,98],[1,99,1,102],[1,103,1,106],[1,108,1,111],[1,112,1,115],[1,124,1,125],[1,128,1,133],[1,188,1,190],[1,147,1,154],[1,157,1,159],[1,160,1,162],[1,163,1,165],[1,166,1,168],[1,170,1,172],[1,173,1,175],[1,176,1,178],[1,179,1,181],[1,182,1,184],[1,185,1,187],[2,93,3,95],[2,96,3,98],[2,99,3,102],[2,103,3,107],[2,108,3,111],[1,191,1,193],[1,194,1,197],[1,198,1,200],[1,201,1,205],[1,209,1,213],[2,182,2,184],[2,112,3,116],[2,136,2,142],[2,147,3,154],[2,157,2,159],[2,160,2,162],[2,163,2,165],[2,166,2,168],[2,170,2,172],[2,173,2,175],[2,176,2,178],[2,179,2,181],[3,157,3,159],[3,160,3,162],[3,163,3,165],[3,166,3,168],[3,170,3,172],[2,185,2,187],[2,188,2,190],[2,191,2,193],[2,194,2,197],[2,198,2,200],[3,191,3,193],[3,194,3,197],[3,198,3,200],[4,114,5,114],[4,115,5,115],[4,116,5,116],[5,160,5,162],[5,166,5,168],[5,173,5,175],[5,179,5,181],[3,173,3,175],[3,176,3,178],[3,179,3,181],[3,182,3,184],[3,185,3,187],[3,188,3,190],[5,185,5,187],[5,191,5,193],[6,73,7,73],[6,136,6,144],[5,0,6,7],[5,74,5,95],[5,100,5,102],[5,109,5,111],[5,117,6,127],[5,150,5,154]]}
[{"$f":"COLUMN(A1)","v":1},{"$f":"COLUMN(B1)","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,{"$f":"COLUMN(BN1)","v":66},67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,{"$f":"COLUMN(DZ1)","v":130},131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,{"$f":"COLUMN(GL1)","v":194},195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219]
["CO Rapport imprimé  (inscrit par la vendeuse et éventuellement corrigé)",null,null,null,null,null,null,null,null,null,"CO Chiffres après contrôle physique                        ( Chiffres CO imprimé + différence)",null,null,null,null,null,null,null,null,null,null,null,"Tot diff de caisse",null,"PAIEMENTS ELECTRONIQUES                                 BANKSYS MAESTRO",null,null,null,null,null,null,null,"PAIEMENTS ELECTRONIQUES                                           VISA",null,null,null,null,null,null,null,"PAIEMENTS ELECTRONIQUES                                           EUROCARD",null,null,null,null,null,null,null,"PAIEMENTS ELECTRONIQUES                                           VPAY",null,null,null,null,null,null,null,"PAIEMENTS ELECTRONIQUES                                         DINERS",null,null,null,null,null,null,null,"TOTAL                                                                                   CARTES DE CREDIT",null,null,null,null,null,null,null,null,"TOTAL                                                                             PAIEMENTS ELECTRONIQUES  AXEPTA et WORDLINE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"12+37.34+10.36","v":59.7},null,null,null,null,null,null,"RELEVE CPTE BQ BELFIUS","Paiements électroniques    Ingenico",null,null,"Paiements électroniques    Ingenico",null,null,"Paiements électroniques             EQUINOXE   Sumup",null,null,null,"EQUINOXE ID: MRLM4Y7K BELFIUS  equinoxe.sa@outlook.com",null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},"Paiements électroniques             EQUINOXE Sumup",null,null,null,"EQUINOXE ID: MRLM4Y7K BELFIUS  equinoxe.sa@outlook.com",null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,"CASH",null,null,null,null,null,"TOTAL","TOTAL","PAIEMENTS EFFECTUES PAR VIREMENT",null,null,null,null,null,null,null,null,null,{"$f":"SUM(FK2+FR2+FX2+GJ2)","v":{"$error":"#REF!"}},"VENTES REALISEES  PAR SUMUP",null,null,null,null,null,null,null,null,"FRAIS","WST ID: M9UF4LMY CRELAN jean-pierre@szava.com",null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!-#REF!+FE2","v":{"$error":"#REF!"}},null,null,{"$f":"1256.81-567.01","v":689.8},"NAM ID: MCV2ZSNS     ING  jean-pierre.szava@telenet.be",null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},null,null,"NAM2 ID: MYNDFNNE   SUMUP   carine.vanleeuw@telenet.be",null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!-#REF!+GD2","v":{"$error":"#REF!"}},null,null,"SUMUP BELFIUS ID: MXGKXF9K  SUMUP   svs.concept@outlook.be",null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},null,null,"                                      PAIEMENTS EFFECTUES  PAR DIVERS",null,null,null,null,null,null,null,"                                      DEPENSES SANS JUSTIFICATIFS"]
[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,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,{"$f":"SUM(#REF!+#REF!+#REF!+#REF!+#REF!+#REF!)","v":{"$error":"#REF!"}},null,null,null,"COL",null,null,null,null,null,"COL","calcul jps",null,null,null,null,null,null,null,null,"SVS",null,null,"EQUINOXE",null,null," (Dans Co, vente encaissée en \"chèque\" et dans Comptage \"Cheque S\")",null,null,null,"23252325Aa?",null,null,null,null," (Dans Co, vente encaissée en \"chèque\" et dans Comptage \"Cheque S\")",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,"(dans CO, choisir type de paiement: traite)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!)*0.9831","v":{"$error":"#REF!"}},"Dans CO, choisir \"Autre type de paiement\"",null,null,null,null,null,null,null,null,null,"5291 3340 4757 3811",null,null,"valid 06/24  cvc 973",null,null,null,null,null,"valid 04/27  cvc 743",null,null,null,"5291 3340 5136 0048",null,null,"valid 08/24  cvc 240",null,null,null,null,null,"valid 07/27  cvc 711",null,null,"5291 3340 6652 6732",null,null,"valid 07/25  cvc 927",null,null,null,null,null,"valid 04/27  cvc 316",null,null,"5291 3340 1738 0791",null,null,null,"valid 11/24  cvc 704"]
[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,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,{"$f":"SUM(#REF!+#REF!+#REF!+#REF!)","v":{"$error":"#REF!"}},null,null,null,{"$f":"COLUMN(BZ3)","v":78},null,null,null,null,null,{"$f":"COLUMN(CF3)","v":84},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"à disposition sur cartes",null,null,null,null,null,null,null,null,null,{"$f":"822.86","v":822.86},"IE55SUMU99036510021870    23252325Aa?",null,null,"SUMUIE22XXX",null,null,null,null,null,"SUMUIE22XXX",null,null,{"$f":"FX2-1704.77","v":{"$error":"#REF!"}},"IE78SUMU99036510082760   23252325Aa?",null,null,"SUMUIE22XXX",null,null,null,null,null,"SUMUIE22XXX",null,null,"IE86SUMU99036510292621  23252325Aa?",null,null,"SUMUIE22XXX",null,null,null,null,null,"SUMUIE22XXX",null,null,"IE46SUMU99036510257354",null,null,null,"SUMUIE22XXX"]
["Date","WST","NIV","NAM","STO","NAM 2","HOR",null,null,null,"WST","Diff.","NIV","Diff.","NAM","Diff.","STO","Diff.","NAM 2","Diff.","HOR","Diff.",null,null,"Date","WST","NIV","NAM","STO","WAV","NAM 2","HOR","Date","WST","NIV","NAM","STO","WAV","NAM 2","HOR","Date","WST","NIV","NAM","STO","WAV","NAM 2","HOR","Date","WST","NIV","NAM","STO","WAV","NAM 2","HOR","Date","WST","NIV","NAM","STO","WAV","NAM 2","HOR","Date","WST","NIV","NAM","STO","WAV","NAM 2","HOR","Date",null,"COR","COR","COR","NIV","NIV","NIV","NAM","NAM","NAM","STO","STO","STO","NAM 2","NAM 2","NAM 2","HOR","HOR","HOR",null,"TOTAL","TOTAL","TOTAL","TOTAL","TOTAL","TOTAL","Date","STO",null,"Frais","A VERSER","DIFF","CC SVS","CC SVS","CC SVS","Date","NIV","Equinoxe","Frais","A VERSER","DIFF","CC Equinoxe","CC Equinoxe","CC Equinoxe",null,null,null,null,null,null,null,null,null,null,null,"WST","NIV","NAM","STO","NAM 2","HOR","TOTAL","TOTAL",null,"WST","NIV","NAM","STO","WAV","NAM 2","HOR","TOTAL","TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"reprise",141594.1,138141.60999999996,null,null,null,"reprise",2415.9300000000003,1861.49,null,null,null,null,"reprise",88788.149999999951,88607.280000000013,null,null,{"$f":"1539.44-1557.55","v":-18.1099999999999},"reprise",130416.80000000002,130236.8499999999,null,null,null,null,null,null,null,null,null,"reprise",8605.0399999999972,8575.7999999999993,null,"WST"]
["CO Rapport imprimé  ",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,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," PAIEMENTS ELECTRONIQUES  AXEPTA et WORDLINE",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,"PAIEM. ELECTR. SUMUP",null,null,null,null,null,null,null,null,"PAIEM. ELECTR. SUMUP",null,null,null,null,null,null,null,"TOTAL PAIEMENTS ELECTRONIQUES (bruts sans les frais)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SVS","Equinoxe",null,null,null,null,null,null,null,null,"SVS","EQUINOXE",{"$f":"EQ2+EQ3","v":{"$error":"#REF!"}},null,null,"Dispo:",{"$f":"SUM(FK6+FR6+FX6+GJ6)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Dispo:",{"$f":"SUM(FE2)+SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,{"$f":"1222.82-666.4","v":556.41999999999996},null,{"$f":"SUM(FK2)+SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,"Dispo:",{"$f":"SUM(FR2)+SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,"Dispo:",{"$f":"SUM(FX2)+SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,"Dispo:",{"$f":"SUM(GD2)+SUM(#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"1949.94-1919.92","v":30.019999999999982},null,"Dispo:",{"$f":"SUM(GJ2)+SUM(#REF!)","v":{"$error":"#REF!"}}]
[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,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,"Date","COR","COR","COR","NIV","NIV","NIV","NAM","NAM","NAM","STO ","STO","STO","NAM 2","NAM 2","NAM 2","HOR","HOR","HOR","RELEVE CPTE BQ BELFIUS SVS","TOTAL","TOTAL","TOTAL","TOTAL","TOTAL","TOTAL","Date","STO","STO","STO","A VERSER","DIFF","CC SVS","CC SVS","CC SVS","Date","NIV","NIV","NIV","A VERSER","DIFF","CC Equinoxe","CC Equinoxe","CC Equinoxe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,"PAIEMENTS EFFECTUES PAR VIREMENT",null,null,null,null,null,null,null,null,null,"Date","WST","NIV","NAM","STO","WAV","NAM 2","HOR","TOTAL","TOTAL","2,75%","A VERSER","VERSÉ","DIFF","CC WST","CC WST","CC WST","A VERSER","VERSÉ","DIFF","CC WST","CC WST","CC WST","Date","A VERSER","VERSÉ","DIFF","CC NAM","CC NAM","CC NAM","A VERSER","VERSÉ","DIFF","CC STO","CC STO","CC STO","A VERSER","VERSÉ","DIFF","CC NAM 2","CC NAM 2","CC NAM 2","A VERSER","VERSÉ","DIFF","CC HOR","CC HOR","CC HOR","VENTES","A VERSER","VERSÉ","DIFF","CC SUMUP","CC SUMUP","CC SUMUP","Date","WST","NIV","NAM","STO","WAV","NAM 2","HOR","Date","WST","NIV","NAM","STO","WAV","NAM 2","HOR","TOTAL","TOTAL"]
["Date","COR","NIV","NAM","STO","NAM 2","HOR","TOTAL SVS","TOTAL EQUINOXE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tot Diff.SVS","Tot Diff EQUINOXE",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,null,null,null,null,null,null,null,null,"01258480","versé","frais",null,"versé","frais","01258462","versé","frais","01308996","versé","frais","01309029","versé","frais","01309029","versé","frais",null,"VENTES","versé","frais","VENTES","versé","frais",null,"VENTES","versé","frais","SVS","SVS","APPORT","DEPENSES","QUID",null,"VENTES","versé","frais","SVS","SVS","APPORT","DEPENSES","QUID","Date","COR","NIV","NAM","STO","NAM 2","HOR","SUMUP SVS","SUMUP EQUINOXE","TOTAL SVS","TOTAL EQUINOXE","COR","NIV","NAM","STO","NAM 2","HOR","TOTAL SVS","TOTAL EQUINOXE","Date","COR","NIV","NAM","STO","WAV","NAM 2","HOR","TOTAL  SVS","TOTAL  EQUINOXE",null,null,null,null,null,null,null,null,"SVS","EQUINOXE","1,69%","WST","WST","WST","APPORT","DEPENSES","QUID","NIV","NIV","NIV","APPORT","DEPENSES","QUID",null,"NAM","NAM","NAM","APPORT","DEPENSES","QUID","STO","STO","STO","APPORT","DEPENSES","QUID","NAM 2","NAM 2","NAM 2","APPORT","DEPENSES","QUID","HOR","HOR","HOR","APPORT","DEPENSES","QUID","SUMUP","SUMUP","SUMUP","SUMUP","APPORT","DEPENSES","QUID",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SVS","EQUINOXE"]
["2024-07-07","",1130,"","","","",0,1130,"2024-07-07","","0",1129.5,-0.5,"","0",0,"0","","0","","0",0,-0.5,"2024-07-07","",455.97,"","","","","","2024-07-07","",49,"","","","","","2024-07-07","",36.03,"","","","","","2024-07-07","","","","","","","","2024-07-07","","","","","","","","2024-07-07","",85.03,"","","","","","2024-07-07","2024-07-07","",null,"",541,null,"","",null,"","",null,"","",null,"","",null,"",null,0,0,0,541,0,0,"2024-07-07","",null,"","","",null,null,null,"2024-07-07","",null,"","","",null,null,null,"2024-07-07","",541,"","","","",null,"","",541,"",0,"",0,"","","","","2024-07-07","","","","","","","","","","2024-07-07","",589,"","","","","","",589,9.9541000000000004,"",null,"","",null,null,579.04589999999996,579.05999999999995,1.4099999999984902E-2,579.05999999999995,-1500,"TFT SB","2024-07-07","",null,"","",null,null,"",null,"","",92.23,"AVEVE","",null,"","",null,null,"",null,"","",null,null,"","",null,"","",null,null,"2024-07-07","","","","","","","","2024-07-07","","","","","","","",0,0]
["2024-07-08","",1804,"",805,"","",0,2609,"2024-07-08","","0",1804,"0","","0",805,"0","","0","","0",0,0,"2024-07-08","",561,"",69,"","","","2024-07-08","",49,"",35,"","","","2024-07-08","",139,"","","","","","2024-07-08","","","","","","","","2024-07-08","","","","","","","","2024-07-08","",188,"",35,"","","","2024-07-08","2024-07-08","",null,"",749,null,"","",null,"",104,103.13,0.87000000000000455,"",null,"","",null,"",null,0,0,0,853,103.13,0.87000000000000455,"2024-07-08","",null,"","","",null,null,null,"2024-07-08","",null,"","","",null,null,null,"2024-07-08","",749,"",104,"","",null,"","",853,"",450,"",0,"","","",450,"2024-07-08","","","","","","","","","","2024-07-08","",513,"",653,"","","","",1166,19.705400000000001,"",null,"","",null,null,504.33029999999997,504.34,9.7000000000093678E-3,504.34,10500,"TFT ING JPS","2024-07-08","",null,"","",null,null,641.96429999999998,641.96,-4.2999999999437932E-3,641.96,1500,"TFT SC","",null,"","",null,null,"",null,"","",null,null,"","",null,"","",null,null,"2024-07-08","","","","","","","","2024-07-08","","","","","","","",0,0]
["2024-07-09","",1078,"",714,"","",0,1792,"2024-07-09","","0",1078,"0","","0",714,"0","","0","","0",0,0,"2024-07-09","",630,"",203,"","","","2024-07-09","",73,"","","","","","2024-07-09","","","","","","","","2024-07-09","","","","","","","","2024-07-09","","","","","","","","2024-07-09","",73,"","","","","","2024-07-09","2024-07-09","",null,"",703,null,"","",null,"",203,202.53,0.46999999999999886,"",null,"","",null,"",null,0,0,0,906,202.53,0.46999999999999886,"2024-07-09",25,{"$f":"VLOOKUP(A11,SUMUP2!A4:X7,23,FALSE)","v":24.58},{"$f":"VLOOKUP(A11,SUMUP2!A4:Y7,24,FALSE)","v":0.42},24.3125,0.26749999999999829,null,null,null,"2024-07-09","",null,"","","",null,null,null,"2024-07-09","",703,"",203,"","",null,25,"",931,"",0,"",200,"","","",200,"2024-07-09","","","","","","","","","","2024-07-09","",375,"",286,"","","","",661,11.1709,"",null,"","",null,null,368.66249999999997,368.67,7.5000000000500222E-3,368.67,null,null,"2024-07-09","",null,"","",null,null,281.16660000000002,281.17,3.3999999999991815E-3,281.17,1034,"joys farfalla","",null,"","",null,null,"",null,"","",null,null,25,"",null,"","",null,null,"2024-07-09","","","","","","","","2024-07-09","","","","","","","",0,0]
["2024-07-10","",1548,"",660,"","",0,2208,"2024-07-10","","0",1548,"0","","0",660,"0","","0","","0",0,0,"2024-07-10","",757,"",39,"","","","2024-07-10","","","",215,"","","","2024-07-10","",23,"",36,"","","","2024-07-10","","","","","","","","2024-07-10","","","","","","","","2024-07-10","",23,"",251,"","","","2024-07-10","2024-07-10","",null,"",780,null,"","",null,"",290,286.95999999999998,3.0400000000000205,"",null,"","",null,"",null,0,0,0,1070,286.95999999999998,3.0400000000000205,"2024-07-10","",null,"","","",null,null,null,"2024-07-10",35,{"$f":"VLOOKUP(A12,SUMUP2!A4:X7,23,FALSE)","v":34.409999999999997},{"$f":"VLOOKUP(A12,SUMUP2!A4:X7,24,FALSE)","v":0.59},34.037500000000001,0.37249999999999517,null,null,null,"2024-07-10","",780,"",290,"","",null,35,"",1105,"",250,"",60,"","","",310,"2024-07-10","","","","","","","","","","2024-07-10","",477,"",293,"","","","",770,13.013,"",null,"","",null,null,468.93869999999998,468.93,-8.6999999999761712E-3,468.93,null,null,"2024-07-10","",null,"","",null,null,288.04829999999998,288.05,1.7000000000280124E-3,288.05,170,"VETO","",null,"","",null,null,"",null,"","",null,null,"","",null,"","",null,null,"2024-07-10","","","","","","","","2024-07-10","","","","","","","",0,0]
["2024-07-11","",1960,"",787,"","",0,2747,"2024-07-11","","0",1960,"0","","0",787,"0","","0","","0",0,0,"2024-07-11","",761,"",358,"","","","2024-07-11","",72,"",29,"","","","2024-07-11","",73,"",65,"","","","2024-07-11","","","","","","","","2024-07-11","","","","","","","","2024-07-11","",145,"",94,"","","","2024-07-11","2024-07-11","",null,"",906,null,"","",null,"",452,449.47,2.5299999999999727,"",null,"","",null,"",null,0,0,0,1358,449.47,2.5299999999999727,"2024-07-11","",null,"","","",null,null,null,"2024-07-11","",null,"","","",null,null,null,"2024-07-11","",906,"",452,"","",null,"","",1358,"",140,"",100,"","","",240,"2024-07-11","","","","","","","","","","2024-07-11","",785,"",176,"","","","",961,16.2409,"",null,"","",null,null,771.73349999999994,771.73,-3.499999999917236E-3,771.73,null,null,"2024-07-11","",null,"","",null,null,173.0256,173.01,-1.5600000000006276E-2,173.01,957.4,"XUNA FEILAI","",null,"","",null,null,"",null,"","",null,null,"","",null,"","",null,null,"2024-07-11","","","","","","","","2024-07-11","","","","","","","",0,0]
[]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ce qui fonctionne avec la feuille SUMUP2 ne fonctionne pas avec la feuille SUMUP. Pour que cela fonctionne, il me faut supprimer dans la feuille SUMUP2 la colonne A et convertir la colonne de date ou remettre une date manuellement à la date de la nouvelle colonne A. Est-il possible de faire fonctionner la formule avec la feuille SUMUP qui est le fichier original téléchargé de la banque et d'éviter ainsi toutes ces manipulations à devoir faire dans SUMUP2 ?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]

{"sheet":"SUMUP","index":1,"n_rows":8,"n_cols":25,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COLUMN(A1)","v":1},{"$f":"COLUMN(B1)","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
["Email","Date","Identifiant de la transaction","Type du mouvement","Status","Type de carte","4 derniers chiffres","Traiter en tant que","Méthode de paiement","Mode de saisie","Code d'authentification","Description","Montant total","Prix net","Montant des taxes","Montant du pourboire","Frais","Virement","Date du virement","ID du versement","Référence","DATE VENTE","MONTANT BRUT","MONTANT Payé NET","FRAIS"]
[]
["equinoxe.sa@outlook.com","2024-07-10 11:50:05","TCGGHFC72R","Vente","Accepté","MASTERCARD","**** **** **** 4473","DEBIT","POS","CHIP","658662","1 x Montant personnalisé",35,28.93,6.07,0,0.59,34.409999999999997,null,null,null,{"$f":"IF(LEFT(E4,4)=\"Payé\",LEFT(B4,10),\"\")","v":""},{"$f":"IF(LEFT(E4,4)=\"Payé\",M4,\"\")","v":""},{"$f":"IF(LEFT(E4,4)=\"Payé\",R4,\"\")","v":""},{"$f":"IF(LEFT(E4,4)=\"Payé\",Q4,\"\")","v":""}]
[null,"2024-07-10 11:50:30","TCGGHFC72R","Virement","Payé",null,null,null,null,null,null,null,35,null,null,null,0.59,34.409999999999997,"2024-07-11","605527",null,{"$f":"IF(LEFT(E5,4)=\"Payé\",LEFT(B5,10),\"\")","v":"2024-07-10"},{"$f":"IF(LEFT(E5,4)=\"Payé\",M5,\"\")","v":35},{"$f":"IF(LEFT(E5,4)=\"Payé\",R5,\"\")","v":34.409999999999997},{"$f":"IF(LEFT(E5,4)=\"Payé\",Q5,\"\")","v":0.59}]
["equinoxe.sa@outlook.com","2024-07-09 15:14:35","TC9ZP2DE76","Vente","Accepté","VISA","**** **** **** 3606","DEBIT","POS","CHIP","654559","1 x Montant personnalisé",25,20.66,4.34,0,0.42,24.58,null,null,null,{"$f":"IF(LEFT(E6,4)=\"Payé\",LEFT(B6,10),\"\")","v":""},{"$f":"IF(LEFT(E6,4)=\"Payé\",M6,\"\")","v":""},{"$f":"IF(LEFT(E6,4)=\"Payé\",R6,\"\")","v":""},{"$f":"IF(LEFT(E6,4)=\"Payé\",Q6,\"\")","v":""}]
[null,"2024-07-09 15:15:10","TC9ZP2DE76","Virement","Payé",null,null,null,null,null,null,null,25,null,null,null,0.42,24.58,"2024-07-10","604003",null,"2024-07-09",25,24.58,0.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]

{"sheet":"SUMUP2","index":2,"n_rows":8,"n_cols":24,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COLUMN(A1)","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["Date","Identifiant de la transaction","Type du mouvement","Status","Type de carte","4 derniers chiffres","Traiter en tant que","Méthode de paiement","Mode de saisie","Code d'authentification","Description","Montant total","Prix net","Montant des taxes","Montant du pourboire","Frais","Virement","Date du virement","ID du versement","Référence","DATE VENTE","MONTANT BRUT","MONTANT Payé NET","FRAIS"]
[]
["2024-07-10 11:50:05","TCGGHFC72R","Vente","Accepté","MASTERCARD","**** **** **** 4473","DEBIT","POS","CHIP","658662","1 x Montant personnalisé",35,28.93,6.07,0,0.59,34.409999999999997,null,null,null,{"$f":"IF(LEFT(D4,4)=\"Payé\",LEFT(A4,10),\"\")","v":""},{"$f":"IF(LEFT(D4,4)=\"Payé\",L4,\"\")","v":""},{"$f":"IF(LEFT(D4,4)=\"Payé\",Q4,\"\")","v":""},{"$f":"IF(LEFT(D4,4)=\"Payé\",P4,\"\")","v":""}]
["2024-07-10","TCGGHFC72R","Virement","Payé",null,null,null,null,null,null,null,35,null,null,null,0.59,34.409999999999997,"2024-07-11","605527",null,{"$f":"IF(LEFT(D5,4)=\"Payé\",LEFT(A5,10),\"\")","v":"45483"},{"$f":"IF(LEFT(D5,4)=\"Payé\",L5,\"\")","v":35},{"$f":"IF(LEFT(D5,4)=\"Payé\",Q5,\"\")","v":34.409999999999997},{"$f":"IF(LEFT(D5,4)=\"Payé\",P5,\"\")","v":0.59}]
["2024-07-09 15:14:35","TC9ZP2DE76","Vente","Accepté","VISA","**** **** **** 3606","DEBIT","POS","CHIP","654559","1 x Montant personnalisé",25,20.66,4.34,0,0.42,24.58,null,null,null,{"$f":"IF(LEFT(D6,4)=\"Payé\",LEFT(A6,10),\"\")","v":""},{"$f":"IF(LEFT(D6,4)=\"Payé\",L6,\"\")","v":""},{"$f":"IF(LEFT(D6,4)=\"Payé\",Q6,\"\")","v":""},{"$f":"IF(LEFT(D6,4)=\"Payé\",P6,\"\")","v":""}]
["2024-07-09","TC9ZP2DE76","Virement","Payé",null,null,null,null,null,null,null,25,null,null,null,0.42,24.58,"2024-07-10","604003",null,"45482",25,{"$f":"IF(LEFT(D7,4)=\"Payé\",Q7,\"\")","v":24.58},0.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]