{"text_format":"3","workbook":"xlsx","n_sheets":19,"sheets":["Fourchette","BalanceN","BalanceN-1","BalanceConso","1","15","16.45","20.21","26","3","40","41","42.43","44","46.47.49","5","48","67.77","entetes"],"not_rendered":{"macros":1,"defined_names":47},"read":"whole","date_system":"1900"}

{"sheet":"Fourchette","index":0,"n_rows":179,"n_cols":9,"rows_kept":179}
["Mode d'emploi :",null,"Saisir les infos ci-dessous (Nom Société et Dates)"]
[null,null,"Appuyer sur les boutons des étapes 1 à 3"]
[]
["Société :","Société Exemple"]
["Situation au :","31/07/2013",{"$nulls":3},"NOTES IMPORTANTES :"]
["Situation N-1 :","31/07/2012",{"$nulls":3},"- Si une classe de comptes est vide (les stocks par ex), une erreur va apparaître : cliquez sur OK"]
["Clôture au :","31/12/2013",{"$nulls":3},"- Virgule dans les libellés = problèmes possibles"]
[{"$nulls":5},"- Fichiers importés : séparateur \",\" ou TAB mais pas \";\". Pas de ligne entête (à supprimer via notepad)"]
[]
["ETAPE 1 ->","LONGUEUR DES COMPTES DE LA BALANCE",{"$nulls":4},6]
[{"$nulls":3},"Fichiers .txt ou .csv (essais à faire) contenant une balance format Coala ou X3 c’est-à-dire :"]
[{"$nulls":3},"N° Comptes, Libellé, Mvts Db, Mvts Cr, et AN"]
[{"$nulls":3},"ou format plus standard : N° Comptes, Libellé, Débit, Crédit"]
[{"$nulls":3},"Si les comptes ne sont pas sur 10 caractères, alors saisissez la longueur des comptes ci-dessous."]
[{"$nulls":3},"Si votre balance est sous forme N° compte, Libellé, Solde (signé + ou -), alors copier/coller les, dans les feuilles BalanceN et N-1"]
[]
["ETAPE 2 ->"]
[]
["Solde N =",{"$f":"SUM(BalanceN!C:C)","v":{"v":7.048583938740194e-12,"d":"0.00"}},"Solde N-1 =",{"$f":"SUM('BalanceN-1'!E:E)","v":{"v":0,"d":"0.00"}},null,"Solde BalanceConso=",null,{"$f":"SUM(BalanceConso!C:D)","v":{"v":-5.6843418860808015E-12,"d":"-0.00"}}]
["Résultat N =",{"$f":"-SUM(IF(LEFT(BalanceN!$A$2:$A$2000,1)=\"7\",BalanceN!$C$2:$C$2000))-SUM(IF(LEFT(BalanceN!$A$2:$A$2000,1)=\"6\",BalanceN!$C$2:$C$2000))","v":{"v":44484.66,"d":"44,484.66"}},"Résultat N-1 =",{"$f":"-SUM(IF(LEFT('BalanceN-1'!$A$2:$A$2000,1)=\"7\",'BalanceN-1'!$C$2:$C$2000))-SUM(IF(LEFT('BalanceN-1'!$A$2:$A$2000,1)=\"6\",'BalanceN-1'!$C$2:$C$2000))","v":{"v":25424.310000000012,"d":"25,424.31"}}]
[]
[]
[]
[]
["ETAPE 3 ->"]
[]
[]
["Une fois créé et utilisé le DA, il faut le réinitialiser pour l'utiliser de nouveau ->"]
["Ne supprime que les feuilles maitresses. Les balances sont supprimées à l'import."]
{"$rows_empty":22}
["B01","CAPITAUX PROPRES",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",1000000000,"à","1499999999",null,{"$f":"\">=\"&LEFT(D53,$G$10)","v":">=100000"},{"$f":"\"<=\"&LEFT(F53,$G$10)","v":"<=149999"}]
[null,null,"B",4560000000,"à","4579999999",null,">=456000","<=457999"]
[null,null,"C",4410000000,"à","4419999999",null,">=441000","<=441999"]
[null,null,"D",7400000000,"à","7499999999",null,">=740000","<=749999"]
[null,null,"E",7770000000,"à","7779999999",null,">=777000","<=777999"]
[null,null,"F",7872000000,"à","7874999999",null,">=787200","<=787499"]
[null,null,"G",6872000000,"à","6874999999",null,">=687200","<=687499"]
["B02","PROVISIONS POUR RISQUES",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",1500000000,"à","1599999999",null,{"$f":"\">=\"&LEFT(D61,$G$10)","v":">=150000"},{"$f":"\"<=\"&LEFT(F61,$G$10)","v":"<=159999"}]
[null,null,"B",6815000000,"à","6815999999",null,">=681500","<=681599"]
[null,null,"C",6865000000,"à","6865999999",null,">=686500","<=686599"]
[null,null,"D",6875000000,"à","6875999999",null,">=687500","<=687599"]
[null,null,"E",7815000000,"à","7815999999",null,">=781500","<=781599"]
[null,null,"F",7865000000,"à","7865999999",null,">=786500","<=786599"]
[null,null,"G",7875000000,"à","7875999999",null,">=787500","<=787599"]
["B03","IMMOBILISATIONS CORPORE",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",2000000000,"à","2399999999",null,{"$f":"\">=\"&LEFT(D69,$G$10)","v":">=200000"},{"$f":"\"<=\"&LEFT(F69,$G$10)","v":"<=239999"}]
[null,null,"B",2800000000,"à","2899999999",null,">=280000","<=289999"]
[null,null,"C",2900000000,"à","2959999999",null,">=290000","<=295999"]
[null,null,"D",6800000000,"à","6811999999",null,">=680000","<=681199"]
[null,null,"E",6816000000,"à","6816999999",null,">=681600","<=681699"]
[null,null,"F",6870000000,"à","6899999999",null,">=687000","<=689999"]
[null,null,"G",7800000000,"à","7811999999",null,">=780000","<=781199"]
[null,null,"H",7816000000,"à","7816999999",null,">=781600","<=781699"]
[null,null,"I",6750000000,"à","6755999999",null,">=675000","<=675599"]
[null,null,"J",6757000000,"à","6779999999",null,">=675700","<=677999"]
[null,null,"K",7750000000,"à","7755999999",null,">=775000","<=775599"]
[null,null,"L",7758000000,"à","7759999999",null,">=775800","<=775999"]
[null,null,"M",7200000000,"à","7299999999",null,">=720000","<=729999"]
["B04","IMMOBILISATIONS FINANC",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",1700000000,"à","1899999999",null,{"$f":"\">=\"&LEFT(D83,$G$10)","v":">=170000"},{"$f":"\"<=\"&LEFT(F83,$G$10)","v":"<=189999"}]
[null,null,"B",2500000000,"à","2599999999",null,">=250000","<=259999"]
[null,null,"C",2600000000,"à","2799999999",null,">=260000","<=279999"]
[null,null,"D",2960000000,"à","2970009999",null,">=296000","<=297000"]
[null,null,"E",4580000000,"à","4589999999",null,">=458000","<=458999"]
[null,null,"F",6860000000,"à","6869999999",null,">=686000","<=686999"]
[null,null,"G",7860000000,"à","7869999999",null,">=786000","<=786999"]
[null,null,"H",7600000000,"à","7629999999",null,">=760000","<=762999"]
[null,null,"I",6550000000,"à","6559999999",null,">=655000","<=655999"]
[null,null,"J",7550000000,"à","7559999999",null,">=755000","<=755999"]
[null,null,"K",6756000000,"à","6756999999",null,">=675600","<=675699"]
[null,null,"L",7756000000,"à","7756999999",null,">=775600","<=775699"]
[null,null,"M",6640000000,"à","6649999999",null,">=664000","<=664999"]
["B05","OPERATIONS FINANCIERES",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",1600000000,"à","1699999999",null,{"$f":"\">=\"&LEFT(D97,$G$10)","v":">=160000"},{"$f":"\"<=\"&LEFT(F97,$G$10)","v":"<=169999"}]
[null,null,"G",4500000000,"à","4599999999",null,">=450000","<=459999"]
[null,null,"B",5000000000,"à","5099999999",null,">=500000","<=509999"]
[null,null,"C",5100000000,"à","5199999999",null,">=510000","<=519999"]
[null,null,"D",5300000000,"à","5399999999",null,">=530000","<=539999"]
[null,null,"E",5800000000,"à","5899999999",null,">=580000","<=589999"]
[null,null,"F",5900000000,"à","5999999999",null,">=590000","<=599999"]
[null,null,"H",4816000000,"à","4816999999",null,">=481600","<=481699"]
[null,null,"I",6670000000,"à","6679999999",null,">=667000","<=667999"]
[null,null,"J",7640000000,"à","7649999999",null,">=764000","<=764999"]
[null,null,"K",7660000000,"à","7679999999",null,">=766000","<=767999"]
[null,null,"L",6270000000,"à","6279999999",null,">=627000","<=627999"]
[null,null,"M",6600000000,"à","6611699999",null,">=660000","<=661169"]
[null,null,"N",6861000000,"à","6861999999",null,">=686100","<=686199"]
[null,null,"O",6612000000,"à","6616999999",null,">=661200","<=661699"]
["B06","STOCKS ET TRAVAUX EN CO",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",3000000000,"à","3999999999",null,{"$f":"\">=\"&LEFT(D113,$G$10)","v":">=300000"},{"$f":"\"<=\"&LEFT(F113,$G$10)","v":"<=399999"}]
[null,null,"B",6030000000,"à","6039999999",null,{"$f":"\">=\"&LEFT(D114,$G$10)","v":">=603000"},{"$f":"\"<=\"&LEFT(F114,$G$10)","v":"<=603999"}]
[null,null,"C",7100000000,"à","7139999999",null,{"$f":"\">=\"&LEFT(D115,$G$10)","v":">=710000"},{"$f":"\"<=\"&LEFT(F115,$G$10)","v":"<=713999"}]
[null,null,"D",6817000000,"à","6817399999",null,{"$f":"\">=\"&LEFT(D116,$G$10)","v":">=681700"},{"$f":"\"<=\"&LEFT(F116,$G$10)","v":"<=681739"}]
[null,null,"E",7817000000,"à","7817399999",null,{"$f":"\">=\"&LEFT(D117,$G$10)","v":">=781700"},{"$f":"\"<=\"&LEFT(F117,$G$10)","v":"<=781739"}]
[{"$nulls":7},""]
["B07","PRODUITS ET CREANCES D'",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",4100000000,"à","4199999999",null,{"$f":"\">=\"&LEFT(D120,$G$10)","v":">=410000"},{"$f":"\"<=\"&LEFT(F120,$G$10)","v":"<=419999"}]
[null,null,"B",7000000000,"à","7099999999",null,">=700000","<=709999"]
[null,"Fourchette(s)","A",4160000000,"à","4169999999",null,">=416000","<=416999"]
[null,null,"B",4910000000,"à","4919999999",null,">=491000","<=491999"]
[null,null,"C",6540000000,"à","6549999999",null,">=654000","<=654999"]
[null,null,"D",6817400000,"à","6859999999",null,">=681740","<=685999"]
[null,null,"E",7817400000,"à","7859999999",null,">=781740","<=785999"]
["B08","DETTES ET CHARGES D'EXP",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",4000000000,"à","4099999999",null,{"$f":"\">=\"&LEFT(D128,$G$10)","v":">=400000"},{"$f":"\"<=\"&LEFT(F128,$G$10)","v":"<=409999"}]
[null,null,"B",6000000000,"à","6029999999",null,{"$f":"\">=\"&LEFT(D129,$G$10)","v":">=600000"},{"$f":"\"<=\"&LEFT(F129,$G$10)","v":"<=602999"}]
[null,null,"C",6040000000,"à","6099999999",null,{"$f":"\">=\"&LEFT(D130,$G$10)","v":">=604000"},{"$f":"\"<=\"&LEFT(F130,$G$10)","v":"<=609999"}]
[null,null,"E",6200000000,"à","6299999999",null,{"$f":"\">=\"&LEFT(D131,$G$10)","v":">=620000"},{"$f":"\"<=\"&LEFT(F131,$G$10)","v":"<=629999"}]
[null,null,"F",6100000000,"à","6199999999",null,{"$f":"\">=\"&LEFT(D132,$G$10)","v":">=610000"},{"$f":"\"<=\"&LEFT(F132,$G$10)","v":"<=619999"}]
["B09","ETAT FISCALITE",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",1550000000,"à","1559999999",null,{"$f":"\">=\"&LEFT(D134,$G$10)","v":">=155000"},{"$f":"\"<=\"&LEFT(F134,$G$10)","v":"<=155999"}]
[null,null,"B",4400000000,"à","4499999999",null,">=440000","<=449999"]
[null,null,"C",6300000000,"à","6399999999",null,">=630000","<=639999"]
[null,null,"D",6712000000,"à","6712999999",null,">=671200","<=671299"]
[null,null,"E",6950000000,"à","6959999999",null,">=695000","<=695999"]
[null,null,"F",6970000000,"à","6979999999",null,">=697000","<=697999"]
[null,null,"G",6990000000,"à","6999999999",null,">=699000","<=699999"]
["B10","PERSONNEL",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",4200000000,"à","4299999999",null,{"$f":"\">=\"&LEFT(D142,$G$10)","v":">=420000"},{"$f":"\"<=\"&LEFT(F142,$G$10)","v":"<=429999"}]
[null,null,"B",4300000000,"à","4399999999",null,">=430000","<=439999"]
[null,null,"C",1582000000,"à","1582999999",null,">=158200","<=158299"]
[null,null,"D",4482000000,"à","4482999999",null,">=448200","<=448299"]
[null,null,"E",6400000000,"à","6499999999",null,">=640000","<=649999"]
[null,null,"F",2743000000,"à","2743009999",null,">=274300","<=274300"]
[null,null,"G",6900000000,"à","6910009999",null,">=690000","<=691000"]
[null,null,"H",1660000000,"à","1660009999",null,">=166000","<=166000"]
["B11","OPERATIONS EXCEPTIONNEL",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",6700000000,"à","6799999999",null,{"$f":"\">=\"&LEFT(D151,$G$10)","v":">=670000"},{"$f":"\"<=\"&LEFT(F151,$G$10)","v":"<=679999"}]
[null,null,"B",7700000000,"à","7799999999",null,{"$f":"\">=\"&LEFT(D152,$G$10)","v":">=770000"},{"$f":"\"<=\"&LEFT(F152,$G$10)","v":"<=779999"}]
[null,null,"C",6870000000,"à","6879999999",null,{"$f":"\">=\"&LEFT(D153,$G$10)","v":">=687000"},{"$f":"\"<=\"&LEFT(F153,$G$10)","v":"<=687999"}]
[null,null,"D",7870000000,"à","7879999999",null,{"$f":"\">=\"&LEFT(D154,$G$10)","v":">=787000"},{"$f":"\"<=\"&LEFT(F154,$G$10)","v":"<=787999"}]
[]
["B12","AUTRES COMPTES",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",4600000000,"à","4699999999",null,{"$f":"\">=\"&LEFT(D157,$G$10)","v":">=460000"},{"$f":"\"<=\"&LEFT(F157,$G$10)","v":"<=469999"}]
[null,null,"B",4700000000,"à","4799999999",null,">=470000","<=479999"]
[null,null,"C",4900000000,"à","4999999999",null,">=490000","<=499999"]
[null,null,"D",5200000000,"à","5299999999",null,">=520000","<=529999"]
[null,null,"E",5400000000,"à","5799999999",null,">=540000","<=579999"]
[null,null,"F",6500000000,"à","6599999999",null,">=650000","<=659999"]
[null,null,"G",6680000000,"à","6689999999",null,">=668000","<=668999"]
[null,null,"H",6813000000,"à","6813999999",null,">=681300","<=681399"]
[null,null,"I",6814000000,"à","6814999999",null,">=681400","<=681499"]
[null,null,"J",6860000000,"à","6869999999",null,">=686000","<=686999"]
[null,null,"K",7230000000,"à","7299999999",null,">=723000","<=729999"]
[null,null,"L",7500000000,"à","7599999999",null,">=750000","<=759999"]
[null,null,"M",7630000000,"à","7639999999",null,">=763000","<=763999"]
[null,null,"N",7650000000,"à","7659999999",null,">=765000","<=765999"]
[null,null,"O",7680000000,"à","7689999999",null,">=768000","<=768999"]
[null,null,"P",7860000000,"à","9999999999",null,">=786000","<=999999"]
[null,null,"Q",7900000000,"à","7999999999",null,">=790000","<=799999"]
[null,null,"R",8000000000,"à","8099999999",null,">=800000","<=809999"]
[null,null,"S",9000000000,"à","9999999999",null,">=900000","<=999999"]
[null,null,"T",null,"à","0999999999",null,">=","<=099999"]
[]
["B13","Comptes régul 486 487",{"$nulls":5},"Compte","Compte"]
[null,"Fourchette(s)","A",4800000000,"à","4899999999",null,{"$f":"\">=\"&LEFT(D179,$G$10)","v":">=480000"},{"$f":"\"<=\"&LEFT(F179,$G$10)","v":"<=489999"}]

{"sheet":"BalanceN","index":1,"n_rows":121,"n_cols":3,"rows_kept":121}
["Compte","Libellé","Solde"]
[101200,"Cap.sous.appele non verse          ",0]
[101300,"Cap.souscr. appele verse           ",-5000]
[106100,"Réserve légale                     ",-500]
[110000,"Report à nouveau crédit.           ",-3876.84]
[120000,"Result. exercice benefice          ",0]
[129000,"Resultat exercice perte            ",0]
[205000,"Concess. brevets licence           ",1230]
[218100,"Aai divers                         ",3815]
[218300,"Materiel bureau et info.           ",1206.52]
[280500,"Amort.concessions brevets          ",-847.33]
[281810,"Amort.aai divers                   ",-514.42]
[281830,"Amort.mat.bureau et info.          ",-690.33]
[401000,"Cent.fourniss.credit               ",-426.25]
[401100,"Cent.fourniss.debit                ",0]
[408100,"Fourn.fact.non.parvenues           ",-4177.63]
[411100,"Clients                            ",6762.89]
[411110,"Clients exo                        ",0]
[419100,"Clients crediteurs                 ",0]
[419110,"Clients crediteurs exo             ",0]
[438600,"Prov.charges soc.tns               ",-6905]
[438601,"Ne sert plus                       ",-4744]
[444000,"Impots sur les benefices           ",-4265]
[445510,"Tva a decaisser                    ",0]
[445620,"Tva/immobilis.deductible           ",0]
[445660,"Tva ded.s/achats de b.&s.          ",69.85]
[445670,"Crédit de tva                      ",0]
[445710,"Tva collectee 196%                ",-817.41]
[445810,"Acomptes regime simplifie          ",0]
[445830,"Remboursement tva demandé          ",2539]
[445860,"Tva/fact.non parvenues             ",684.63]
[455100,"Compte courant xxx",0]
[456250,"Apport.cap.appel.non vers          ",0]
[457000,"Assoc.dividendes a payer           ",0]
[467000,"Notes de frais xxx",-2100.01]
[471000,"Compte d attente                   ",0]
[503000,"Val.mobil.de placement             ",36598.32]
[512100,"Bnp paribas                        ",20660.25]
[531000,"Caisse                             ",5782.42]
[604000,"Achats d'etudes et de ps           ",8670]
[606300,"Fournit. petit equipement          ",708.78]
[606400,"Fournit.de bureau                  ",841.33]
[606800,"Fournitures informatiques          ",488.23]
[607100,"Achats de marchandises             ",11989.15]
[613200,"Loyer",0]
[615200,"Entr.&reparat.des locaux           ",62.69]
[615600,"Maintenance                        ",0]
[616100,"Ass.multirisque prof.              ",0]
[618100,"Presse                             ",1018.37]
[622600,"Honoraires avocat                  ",1100]
[622610,"Honor.expert comptable             ",3300]
[622700,"Frais d'actes & content.           ",94.6]
[623400,"Cadeau clientèle                   ",0]
[623800,"Frais de representations           ",34.23]
[624100,"Transport sur achats               ",174]
[625100,"Voyages et deplacements            ",4434.87]
[625110,"Indemnites km ",518.07]
[625700,"Missions et receptions             ",1121.57]
[626110,"Telephone portable                 ",331.62]
[626120,"Internet                           ",371.79]
[626200,"Frais postaux                      ",41.66]
[627000,"Frais bancaires                    ",442.74]
[633300,"Formation continue (tns)           ",48]
[635100,"Autres impots et taxes             ",3.98]
[635110,"Taxe professionnelle               ",0]
[637800,"Csg deductible (tns)               ",890]
[637810,"Csg/crds non deduct.(tns)          ",506]
[641100,"Remuneration xxx",15000]
[646000,"Cotisations RSI                    ",729]
[646100,"Ne sert plus                       ",972]
[646200,"Ne sert plus                       ",2253]
[646300,"CARDIF retr.loi madelin            ",0]
[658000,"Charges div.gest.courante          ",35.96]
[666000,"Pertes de change                   ",0]
[668000,"Ecarts de conversion               ",0]
[671200,"Pénalités amende fiscale          ",0]
[681110,"Dot.amort.immo.incorpore.          ",615]
[681120,"Dot.amort.immo.corporell.          ",783.63]
[695100,"Impots s/benefices                 ",12484]
[706100,"Prestat.de serv.196%              ",-24075]
[706110,"Prestat.de serv.exo                ",-61423.64]
[707100,"Ventes march.19.6%                 ",-13849.04]
[708100,"Débours 19.6%                      ",0]
[708110,"Débours exo                        ",-1021.92]
[708200,"Commissions & court.19.6%          ",-10479.35]
[708210,"Commissions & court.exo            ",-3095.49]
[758000,"Prod.divers de gest.cour.          ",-5.76]
[766000,"Gains de change                    ",0]
[767000,"Prod.nets/ces.val.mob.pla          ",-598.73]
[768000,"Ecarts de conversion               ",0]
[769000,"Autres impots et taxes             ",-500]
[770000,"xxx",-6065.79]
[771000,"xxx",0]
[772000,"xxx",0]
[773000,"xxx",1775]
[774000,"xxx",12.01]
[775000,"xxx",641.53]
[776000,"xxx",0]
[777000,"xxx",292.69]
[778000,"xxx",0]
[779000,"xxx",0]
[780000,"xxx",0]
[781000,"xxx",0]
[782000,"xxx",0]
[783000,"xxx",1056.84]
[784000,"xxx",1788.03]
[785000,"xxx",0]
[786000,"xxx",0]
[787000,"xxx",54.25]
[788000,"xxx",0]
[789000,"xxx",0]
[790000,"xxx",0]
[791000,"xxx",0]
[792000,"xxx",0]
[793000,"xxx",0]
[794000,"xxx",0]
[795000,"xxx",0]
[796000,"xxx",0]
[797000,"xxx",945.44]
[798000,"xxx",0]
[799000,"xxx",0]

{"sheet":"BalanceN-1","index":2,"n_rows":121,"n_cols":3,"rows_kept":121}
["Compte","Libellé","Solde"]
[101200,"Cap.sous.appele non verse          ",0]
[101300,"Cap.souscr. appele verse           ",-5000]
[106100,"Réserve légale                     ",-500]
[110000,"Report à nouveau crédit.           ",-14653.5]
[120000,"Result. exercice benefice          ",0]
[129000,"Resultat exercice perte            ",0]
[205000,"Concess. brevets licence           ",1230]
[218100,"Aai divers                         ",3815]
[218300,"Materiel bureau et info.           ",2534.33]
[280500,"Amort.concessions brevets          ",-1230]
[281810,"Amort.aai divers                   ",-895.92]
[281830,"Amort.mat.bureau et info.          ",-1105.98]
[401000,"Cent.fourniss.credit               ",0]
[401100,"Cent.fourniss.debit                ",0]
[408100,"Fourn.fact.non.parvenues           ",-6651.84]
[411100,"Clients                            ",770.02]
[411110,"Clients exo                        ",0]
[419100,"Clients crediteurs                 ",0]
[419110,"Clients crediteurs exo             ",0]
[438600,"Prov.charges soc.tns               ",-12941]
[438601,"Ne sert plus                       ",0]
[444000,"Impots sur les benefices           ",12483]
[445510,"Tva a decaisser                    ",-4185]
[445620,"Tva/immobilis.deductible           ",0]
[445660,"Tva ded.s/achats de b.&s.          ",0]
[445670,"Crédit de tva                      ",0]
[445710,"Tva collectee 19 6%                ",-126.19]
[445810,"Acomptes regime simplifie          ",0]
[445830,"Remboursement tva demandé          ",0]
[445860,"Tva/fact.non parvenues             ",791.84]
[455100,"Compte courant xxx",-676.83]
[456250,"Apport.cap.appel.non vers          ",0]
[457000,"Assoc.dividendes a payer           ",0]
[467000,"Notes de frais xxx",-895.53]
[471000,"Compte d attente                   ",226]
[503000,"Val.mobil.de placement             ",47482.61]
[512100,"Bnp paribas                        ",3068.23]
[531000,"Caisse                             ",1885.07]
[604000,"Achats d'etudes et de ps           ",3277.7]
[606300,"Fournit. petit equipement          ",1240.47]
[606400,"Fournit.de bureau                  ",362.98]
[606800,"Fournitures informatiques          ",229.98]
[607100,"Achats de marchandises             ",2715.04]
[613200,"Loyer",1820]
[615200,"Entr.&reparat.des locaux           ",0]
[615600,"Maintenance                        ",49.58]
[616100,"Ass.multirisque prof.              ",4181.07]
[618100,"Presse                             ",1111.37]
[622600,"Honoraires avocat                  ",1100]
[622610,"Honor.expert comptable             ",3350]
[622700,"Frais d'actes & content.           ",137]
[623400,"Cadeau clientèle                   ",5.34]
[623800,"Frais de representations           ",0]
[624100,"Transport sur achats               ",120]
[625100,"Voyages et deplacements            ",3474.83]
[625110,"Indemnites km ",481.77]
[625700,"Missions et receptions             ",1404.39]
[626110,"Telephone portable                 ",672.66]
[626120,"Internet                           ",591.07]
[626200,"Frais postaux                      ",17.89]
[627000,"Frais bancaires                    ",476.25]
[633300,"Formation continue (tns)           ",49]
[635100,"Autres impots et taxes             ",0]
[635110,"Taxe professionnelle               ",266]
[637800,"Csg deductible (tns)               ",1767]
[637810,"Csg/crds non deduct.(tns)          ",1005]
[641100,"Remuneration xxx",30000]
[646000,"Cotisations RSI                    ",6886]
[646100,"Ne sert plus                       ",0]
[646200,"Ne sert plus                       ",0]
[646300,"CARDIF retr.loi madelin            ",765]
[658000,"Charges div.gest.courante          ",0.5]
[666000,"Pertes de change                   ",0]
[668000,"Ecarts de conversion               ",0]
[671200,"Pénalités  amende fiscale          ",27]
[681110,"Dot.amort.immo.incorpore.          ",382.67]
[681120,"Dot.amort.immo.corporell.          ",797.15]
[695100,"Impots s/benefices                 ",0]
[706100,"Prestat.de serv.19 6%              ",-40323.08]
[706110,"Prestat.de serv.exo                ",-28600]
[707100,"Ventes march.19.6%                 ",-3086.8]
[708100,"Débours 19.6%                      ",-140]
[708110,"Débours exo                        ",-2801.32]
[708200,"Commissions & court.19.6%          ",-18226.27]
[708210,"Commissions & court.exo            ",0]
[758000,"Prod.divers de gest.cour.          ",-0.31]
[766000,"Gains de change                    ",0]
[767000,"Prod.nets/ces.val.mob.pla          ",-781.26]
[768000,"Ecarts de conversion               ",0]
[769000,"Autres impots et taxes             ",-1000]
[770000,"xxx",0]
[771000,"xxx",0]
[772000,"xxx",0]
[773000,"xxx",0]
[774000,"xxx",0]
[775000,"xxx",0]
[776000,"xxx",0]
[777000,"xxx",0]
[778000,"xxx",770.02]
[779000,"xxx",0]
[780000,"xxx",0]
[781000,"xxx",0]
[782000,"xxx",0]
[783000,"xxx",0]
[784000,"xxx",0]
[785000,"xxx",0]
[786000,"xxx",0]
[787000,"xxx",0]
[788000,"xxx",0]
[789000,"xxx",0]
[790000,"xxx",0]
[791000,"xxx",0]
[792000,"xxx",0]
[793000,"xxx",0]
[794000,"xxx",0]
[795000,"xxx",0]
[796000,"xxx",0]
[797000,"xxx",0]
[798000,"xxx",0]
[799000,"xxx",0]

{"sheet":"BalanceConso","index":3,"n_rows":121,"n_cols":4,"rows_kept":121}
["Compte","Libellé",{"$f":"\"SoldeN\"","v":"SoldeN"},{"$f":"\"SoldeN-1\"","v":"SoldeN-1"}]
[101200,"Cap.sous.appele non verse          "]
[101300,"Cap.souscr. appele verse           ",-5000,-5000]
[106100,"Réserve légale                     ",-500,-500]
[110000,"Report à nouveau crédit.           ",-3876.84,-14653.5]
[120000,"Result. exercice benefice          "]
[129000,"Resultat exercice perte            "]
[205000,"Concess. brevets licence           ",1230,1230]
[218100,"Aai divers                         ",3815,3815]
[218300,"Materiel bureau et info.           ",1206.52,2534.33]
[280500,"Amort.concessions brevets          ",-847.33,-1230]
[281810,"Amort.aai divers                   ",-514.42,-895.92]
[281830,"Amort.mat.bureau et info.          ",-690.33,-1105.98]
[401000,"Cent.fourniss.credit               ",-426.25]
[401100,"Cent.fourniss.debit                "]
[408100,"Fourn.fact.non.parvenues           ",-4177.63,-6651.84]
[411100,"Clients                            ",6762.89,770.02]
[411110,"Clients exo                        "]
[419100,"Clients crediteurs                 "]
[419110,"Clients crediteurs exo             "]
[438600,"Prov.charges soc.tns               ",-6905,-12941]
[438601,"Ne sert plus                       ",-4744]
[444000,"Impots sur les benefices           ",-4265,12483]
[445510,"Tva a decaisser                    ",null,-4185]
[445620,"Tva/immobilis.deductible           "]
[445660,"Tva ded.s/achats de b.&s.          ",69.85]
[445670,"Crédit de tva                      "]
[445710,"Tva collectee 196%                ",-817.41,-126.19]
[445810,"Acomptes regime simplifie          "]
[445830,"Remboursement tva demandé          ",2539]
[445860,"Tva/fact.non parvenues             ",684.63,791.84]
[455100,"Compte courant xxx",null,-676.83]
[456250,"Apport.cap.appel.non vers          "]
[457000,"Assoc.dividendes a payer           "]
[467000,"Notes de frais xxx",-2100.01,-895.53]
[471000,"Compte d attente                   ",null,226]
[503000,"Val.mobil.de placement             ",36598.32,47482.61]
[512100,"Bnp paribas                        ",20660.25,3068.23]
[531000,"Caisse                             ",5782.42,1885.07]
[604000,"Achats d'etudes et de ps           ",8670,3277.7]
[606300,"Fournit. petit equipement          ",708.78,1240.47]
[606400,"Fournit.de bureau                  ",841.33,362.98]
[606800,"Fournitures informatiques          ",488.23,229.98]
[607100,"Achats de marchandises             ",11989.15,2715.04]
[613200,"Loyer",null,1820]
[615200,"Entr.&reparat.des locaux           ",62.69]
[615600,"Maintenance                        ",null,49.58]
[616100,"Ass.multirisque prof.              ",null,4181.07]
[618100,"Presse                             ",1018.37,1111.37]
[622600,"Honoraires avocat                  ",1100,1100]
[622610,"Honor.expert comptable             ",3300,3350]
[622700,"Frais d'actes & content.           ",94.6,137]
[623400,"Cadeau clientèle                   ",null,5.34]
[623800,"Frais de representations           ",34.23]
[624100,"Transport sur achats               ",174,120]
[625100,"Voyages et deplacements            ",4434.87,3474.83]
[625110,"Indemnites km ",518.07,481.77]
[625700,"Missions et receptions             ",1121.57,1404.39]
[626110,"Telephone portable                 ",331.62,672.66]
[626120,"Internet                           ",371.79,591.07]
[626200,"Frais postaux                      ",41.66,17.89]
[627000,"Frais bancaires                    ",442.74,476.25]
[633300,"Formation continue (tns)           ",48,49]
[635100,"Autres impots et taxes             ",3.98]
[635110,"Taxe professionnelle               ",null,266]
[637800,"Csg deductible (tns)               ",890,1767]
[637810,"Csg/crds non deduct.(tns)          ",506,1005]
[641100,"Remuneration xxx",15000,30000]
[646000,"Cotisations RSI                    ",729,6886]
[646100,"Ne sert plus                       ",972]
[646200,"Ne sert plus                       ",2253]
[646300,"CARDIF retr.loi madelin            ",null,765]
[658000,"Charges div.gest.courante          ",35.96,0.5]
[666000,"Pertes de change                   "]
[668000,"Ecarts de conversion               "]
[671200,"Pénalités amende fiscale          ",null,27]
[681110,"Dot.amort.immo.incorpore.          ",615,382.67]
[681120,"Dot.amort.immo.corporell.          ",783.63,797.15]
[695100,"Impots s/benefices                 ",12484]
[706100,"Prestat.de serv.196%              ",-24075,-40323.08]
[706110,"Prestat.de serv.exo                ",-61423.64,-28600]
[707100,"Ventes march.19.6%                 ",-13849.04,-3086.8]
[708100,"Débours 19.6%                      ",null,-140]
[708110,"Débours exo                        ",-1021.92,-2801.32]
[708200,"Commissions & court.19.6%          ",-10479.35,-18226.27]
[708210,"Commissions & court.exo            ",-3095.49]
[758000,"Prod.divers de gest.cour.          ",-5.76,-0.31]
[766000,"Gains de change                    "]
[767000,"Prod.nets/ces.val.mob.pla          ",-598.73,-781.26]
[768000,"Ecarts de conversion               "]
[769000,"Autres impots et taxes             ",-500,-1000]
[770000,"xxx",-6065.79]
[771000,"xxx"]
[772000,"xxx"]
[773000,"xxx",1775]
[774000,"xxx",12.01]
[775000,"xxx",641.53]
[776000,"xxx"]
[777000,"xxx",292.69]
[778000,"xxx",null,770.02]
[779000,"xxx"]
[780000,"xxx"]
[781000,"xxx"]
[782000,"xxx"]
[783000,"xxx",1056.84]
[784000,"xxx",1788.03]
[785000,"xxx"]
[786000,"xxx"]
[787000,"xxx",54.25]
[788000,"xxx"]
[789000,"xxx"]
[790000,"xxx"]
[791000,"xxx"]
[792000,"xxx"]
[793000,"xxx"]
[794000,"xxx"]
[795000,"xxx"]
[796000,"xxx"]
[797000,"xxx",945.44]
[798000,"xxx"]
[799000,"xxx"]

{"sheet":"1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"15","index":5,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"16.45","index":6,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"20.21","index":7,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"26","index":8,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"3","index":9,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"40","index":10,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"41","index":11,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"42.43","index":12,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"44","index":13,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"46.47.49","index":14,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"5","index":15,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"48","index":16,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"67.77","index":17,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"entetes","index":18,"n_rows":20,"n_cols":5,"rows_kept":20,"merged":[[1,0,1,5],[25,0,25,6]]}
[]
[]
[{"$f":"+Fourchette!$B$4","v":"Société Exemple"}]
[{"$nulls":3},"Clôture :",{"$f":"+Fourchette!$B$7","v":"31/12/2013"}]
["Situation au :",{"$f":"+Fourchette!$B$5","v":"31/07/2013"}]
[]
[1,"CAPITAUX PROPRES"]
[15,"PROVISIONS POUR RISQUES ET CHARGES"]
[16.45,"EMPRUNTS ET COMPTES COURANTS"]
[20.21,"IMMOBILISATIONS INCORPORELLES ET CORPORELLES"]
[26,"IMMOBILISATIONS FINANCIERES"]
[3,"STOCKS ET EN-COURS"]
[40,"FOURNISSEURS"]
[41,"CLIENTS"]
[42.43,"PERSONNEL"]
[44,"IMPOTS - ETATS"]
["46.47.49","DEBITEURS ET CREDITEURS DIVERS"]
[5,"FINANCIER"]
[48,"COMPTES DE REGULARISATION"]
[67.77,"RESULTAT EXCEPTIONNEL"]