{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CODES","31-12-YYYY"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"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":"CODES","index":0,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,0,5,1]]}
["VIRTUACOMPTA /VIRTUACCOUNTING"]
["CODE - LEGENDES"]
[]
[]
[]
["CODE"]
[]
["MB","MOBILIER DE BUREAU"]
["MI","MATERIEL INFORMATIQUE"]
["REV","REVENUS"]
["ESS","ESSENCE","Pour TA ou voiture achetée/louée sous corporation"]
["ACH-SS","ACHATS (COUT DE MARCHANDISES VENDUES - SOUS TRAITANTS)"]
["ACH - M&O","ACHATS (COUT DE MARCHANDISES VENDUES - MATERIELS)"]
["CELL","CELLULAIRE"]
["INT","INTERNET"]
["REP","REPAS ET FRAIS DE REPRESENTATION"]
["ENT","ENTRETIEN AUTO","Pour TA ou voiture achetée/louée sous corporation"]
["BUR","BUREAU (LOYER, ENTRETIEN MENAGER)"]
["LOC","LOCATION CHAUFFE-EAU"]
["ELE","ELECTRICITE"]
["KM","KILOMETRAGE","POUR CORPO: 0.55$/KM<5000KM + 0.49$/KM >5000K"]
["PRO","HONORAIRE PROFESSIONNEL"]
["DEP","DEPLACEMENT"]
["FOB","FOURNITURES DE BUREAU"]
["ASSP","ASSURANCE PROFESSIONNELLE"]
["PER","PERMIS, COTISATION, MEMBERSHIP"]
["IFB","INTERET ET FRAIS BANCAIRES"]
["IPM","INTERET, PENALITE ET AMANDE"]
["TA","TAXES D'AFFFAIRES"]
["FOR","FORMATION, CONGRES"]
["PUB","PUBLICITE ET PROMOTION"]
["DA","DEVELOPPEMENT D'AFFAIRES"]
["ASSA","ASSURANCE AUTO"]
["ASSAAD","ASSURANCE ADMINISTRATEURS"]
["IMM","IMMATRICULATION","Pour TA ou voiture achetée/louée sous corporation"]
[]
["AUTO","TA OU VOITURE ACHETéE/LOUéE SOUS CORPORATION:"]
[null,"INFORMATIONS A FOUNIR: CONTRAT D'ACHAT OU LOCATION, MONTANT D'ACHAT/LOCATION MENSUELLE, DATE D'ACHAT OU LOCATION, KM, MARQUE, MODELE/SERIE, % D'UTILISATION POUR AFFAIRES"]

{"sheet":"31-12-YYYY","index":1,"n_rows":147,"n_cols":30,"rows_kept":147,"cut":false,"hidden":false,"merged":[[4,7,4,8],[4,9,4,10]]}
["NOM DU TA"]
["ANNUELLE"]
["DATE","31 DECEMBRE YYYY"]
[]
[null,null,null,null,null,null,null,"REVENUS",null,"DÉPENSES",null,null,"REV","ASSP","PER","FOR","REP","PUB","ACH","BUR","PRO","CELL","ENT","ESS","DEP","ASS","LOC","ELE"]
[null,"DATE","DESCRIPTION","CODE","MONTANT\n100%¹","%\nAFFAIRE","MONTANT","TPS²","TVQ²","TPS²","TVQ²",null,"\n\nREVENUS","\nASSURANCE\nPROF.","\nPERMIS COTISATION\nABONNEMENT","\nFORMATION","REPAS","PUBLICITÉ","ACHATS","BUREAU","HON. PROF.","CELLULAIRE","ENTRETIEN AUTO\n80%","ESSENCE 80%","DÉPLACEMENT 100%","ASSURANCE\n100%","LOCATION\nCHAUFFEAU","ÉLECTRICITÉ 20%","total","Preuve"]
[]
[null,null,null,null,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(H8:AB8)","v":0},{"$f":"G8-AC8","v":0}]
[null,null,null,"ESS",null,0.8,{"$f":"E9*F9","v":0},null,null,null,null,null,{"$f":"IF($D9=M$5,$G9,\"\")","v":""},{"$f":"IF($D9=N$5,$G9,\"\")","v":""},{"$f":"IF($D9=O$5,$G9,\"\")","v":""},"","","","","","","","",0,"","","","",0,0]
[null,null,null,"ACH",null,1,0,null,null,null,null,null,{"$f":"IF($D10=M$5,$G10,\"\")","v":""},"","","","","",0,"","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"CELL",null,1,0,null,null,null,null,null,"","","","","","","","","",0,"","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ACH",null,1,0,null,null,null,null,null,"","","","","","",0,"","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ENT",null,0.8,0,null,null,null,null,null,"","","","","","","","","","",0,"","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ACH",null,1,0,null,null,null,null,null,"","","","","","",0,"","","","","","","","","",0,0]
[null,null,null,"BUR",null,1,0,null,null,null,null,null,"","","","","","","",0,"","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,{"$f":"IF($D26=M$5,$G26,\"\")","v":""},"","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"LOC",null,0.2,0,null,null,null,null,null,"","","","","","","","","","","","","","",0,"",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ELE",null,0.2,0,null,null,null,null,null,"","","","","","","","","","","","","","","",0,0,0]
[null,null,null,"ENT",null,0.8,0,null,null,null,null,null,"","","","","","","","","","",0,"","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"BUR",null,0.2,0,null,null,null,null,null,"","","","","","","",0,"","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","",{"$f":"IF($D41=AB$5,$G41,\"\")","v":""},0,0]
[null,null,null,"ELE",null,0.2,0,null,null,null,null,null,{"$f":"IF($D42=M$5,$G42,\"\")","v":""},"","","","","","","","","","","","","","",0,0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"Bur",null,0.2,0,null,null,null,null,null,"","","","","","","",0,"","","","","","","","",0,0]
[null,null,null,"REV",null,1,{"$f":"E45*F45","v":0},null,null,null,null,null,0,"","","","","","","","","","","","","","","",{"$f":"SUM(H45:AB45)","v":0},{"$f":"G45-AC45","v":0}]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ACH",null,1,0,null,null,null,null,null,"","","","","","",0,"","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"ACH",null,1,0,null,null,null,null,null,"","","","","","",0,"","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ACH",null,1,0,null,null,null,null,null,"","","","","","",0,"","","","","","","","","",0,0]
[null,null,null,"ACH",null,1,0,null,null,null,null,null,"","","","","","",0,"","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"BUR",null,0.2,0,null,null,null,null,null,"","","","","","","",0,"","","","","","","","",0,0]
[null,null,null,"CELL",null,1,0,null,null,null,null,null,"","","","","","","","","",0,"","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","",{"$f":"IF($D60=Q$5,$G60,\"\")","v":""},"","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"PRO",null,1,0,null,null,null,null,null,"","","","","","","","",0,"","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"BUR",null,1,0,null,null,null,null,null,"","","","","","","",0,"","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"ACH",null,1,0,null,null,null,null,null,"","","","","","",0,"","","","","","","","","",0,0]
[null,null,null,"ENT",null,0.8,0,null,null,null,null,null,"","","","","","","","","","",0,"","","","","",0,0]
[null,null,null,"PRO",null,1,0,null,null,null,null,null,"","","","","","","","",0,"","","","","","","",{"$f":"SUM(H71:AB71)","v":0},{"$f":"G71-AC71","v":0}]
[null,null,null,"ENT",null,0.8,0,null,null,null,null,null,"","","","","","","","","","",0,"","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ENT",null,0.8,0,null,null,null,null,null,"","","","","","","","","","",0,"","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","",{"$f":"IF($D78=T$5,$G78,\"\")","v":""},"","","",0,"","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"ELE",null,0.2,0,null,null,null,null,null,"","","","","","","","","","","","","","","",0,0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"DEP",null,1,0,null,null,null,null,null,"","","","","","","","","","","","",0,"","","",0,0]
[null,null,null,"ELE",null,0.2,{"$f":"E88*F88","v":0},null,null,null,null,null,"","","","","","","","","","","","","","","",0,0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ELE",null,0.2,0,null,null,null,null,null,"","","","","","","","","","","","","","","",0,0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"CELL",null,1,0,null,null,null,null,null,"","","","","","","","","",0,{"$f":"IF($D96=W$5,$G96,\"\")","v":""},"","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,{"$f":"IF($D106=M$5,$G106,\"\")","v":""},"","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"LOC",null,0.2,0,null,null,null,null,null,"","","","","","","","","","","","","","",0,"",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",{"$f":"SUM(H113:AB113)","v":0},{"$f":"G113-AC113","v":0}]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","",{"$f":"IF($D114=Z$5,$G114,\"\")","v":""},"","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"DEP",null,1,0,null,null,null,null,null,"","","","","","","","","","","","",0,"","","",0,0]
[null,null,null,"ELE",null,0.2,0,null,null,null,null,null,"","","","","","","","","","","","","","","",0,0,0]
[null,null,null,"ESS",null,0.8,0,null,null,null,null,null,"","","","","","","","","","","",0,"","","","",0,0]
[null,null,null,"DEP",null,1,0,null,null,null,null,null,"","","","","","","","","","","","",0,"","","",0,0]
[null,null,null,"DEP",null,1,0,null,null,null,null,null,"","","","","","","","","","","","",0,"","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REV",null,1,0,null,null,null,null,null,0,"","","","","","","","","","","","","","","",0,0]
[null,null,null,"REP",null,1,0,null,null,null,null,null,"","","","",0,"","","","","","","","","","","",0,0]
[null,null,null,"BUR",null,1,0,null,null,null,null,null,"","","","","","","",0,"","","","","","","","",0,0]
[null,null,null,null,null,null,{"$f":"E128*F128","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H128:AB128)","v":0},{"$f":"G128-AC128","v":0}]
[null,null,null,null,null,null,{"$f":"E129*F129","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E9:E129)","v":0},null,{"$f":"SUM(G9:G129)","v":0},{"$f":"SUM(H9:H129)","v":0},{"$f":"SUM(I9:I129)","v":0},{"$f":"SUM(J9:J129)","v":0},{"$f":"SUM(K9:K129)","v":0},null,{"$f":"SUM(M9:M129)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,"Dépenses à 100% pour T2125",null,null,{"$f":"N130","v":0},{"$f":"O130","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"# TPS: ",null,null,null,null,"RAPPORT TPS/TVQ"]
[null,"# TVQ: "]
[null,null,null,null,"Chiffre d'affaire",{"$f":"M130","v":0}]
[]
[null,null,null,null,"TPS à payer",{"$f":"H130","v":0},{"$f":"I130","v":0},"TVQ à payer"]
[null,null,null,null,"CTI",{"$f":"J130","v":0},{"$f":"K130","v":0},"RTI"]
[null,null,null,null,null,{"$f":"F138-F139","v":0},{"$f":"G138-G139","v":0}]
[]
[null,null,null,null,"Total à payer",null,{"$f":"F140+G140","v":0}]
[]
[]
[]
["NOTES","1) Si revenus total <30K, pas besoin de s'enregistrer aux taxes de ventes. Donc 100% montants des depenses inclut les taxes"]
[null,"1-2) Si enregistré aux taxes de vente, 100% montant = montant sans les taxes et inscrire les taxes dans les colonnes de taxes appropriées."]