plantilla ats 2013 para excel 2007 2010 2013 final prueba

Download Plantilla ATS 2013 Para Excel 2007 2010 2013 Final Prueba

If you can't read please download the document

Upload: pablo-vargas-morales

Post on 24-Nov-2015

20 views

Category:

Documents


11 download

TRANSCRIPT

Tipo Id InformanteIdentificacion InformanteRazn SocialAoMesNumero EstablecimientosTotal VentasCdigo OperativoR1391710712001CONGREGACION LA PROVIDENCIA BAHIA DE CARAQUEZ20131132.600,50IVA

Cdigo de compraCdigo de SustentoTipo Identificacin del ProveedorNmero de Identificacin del ProveedorCdigo del Tipo de ComprobanteTipo de ProveedorParte Relacionada?Fecha RegistroEstablecimientoPunto EmisinSecuencialFecha EmisinNmero de autorizacinBase Imponible no objeto de IVABase Imponible tarifa 0% de IVABase Imponible gravadaMonto ICEMonto IVARetencin de IVA 30% bienesRetencin de IVA 70% servicios100% Retencin de IVAPago Local o al ExteriorCompra001010113017953220010103/01/20130010011561703/01/201311119541430,00093011,1607,810,00307Compra002010113068119910010108/01/20130010011866608/01/201311120074540,00033,0403,96000,00312Compra003010113600015200010103/01/20130010023725703/01/201311119777990,005,78000000,00332Compra004010113600015200010103/01/20130010023725803/01/201311119777990,0028,78000000,00332Compra00501019925984680010103/01/2013086011691752303/01/201311118474930,0096,86000000,00332Compra00601019925984680010103/01/2013086011691617003/01/201311118474930,0030,6000000,00332Compra00701019925984680010103/01/2013086011691752403/01/201311118474930,0020,13000000,00332Compra008010113600689400010102/01/20130010014926202/01/201311109593880,0013,55000000,00332Compra009010113600689400010102/01/20130010014926102/01/201311109593880,0065,7000000,00332Compra01001020013091692070310/01/2013001001120510/01/201311111325740,0002000240024,00307Compra011010117104274750010114/01/201300100171614/01/201311107388690,00145000000,00307Compra012010113055204030010114/01/20130010011003014/01/201311119993380,000150018000,00304Compra013010113061778640010107/01/20130010012062907/01/201311110933440,0008,0400,96000,00312Compra014010117910720730010110/01/20130020015800410/01/201311117093130,0014000000,00332Compra015010113917415100010110/01/201300600123600610/01/201311112032420,0008,9301,07000,00332Compra016010113901435630010107/01/201300300125310607/01/201311113954190,0008,9301,07000,00332Compra017010113917369400010109/01/20130010017619909/01/201311119723750,0005,3600,64000,00312Compra018010113003365240010104/01/20130010011623304/01/201311120085040,0041,95000000,00312Compra019010113108711060010102/01/201300100147802/01/201311117813130,0002,0500,250,0800,00312Compra020010113917646260010110/01/20130010025962610/01/201311118964770,0006,4900,78000,00332Compra021010113077601480010107/01/20130010011296207/01/201311119473620,00026,7903,21000,00312Compra022010113108711060010104/01/201300100148504/01/201311117813130,0002,6800,320,100,00312Compra023010113003365240010111/01/20130010011626811/01/201311120085040,0014000000,00312Compra024010113086946500010114/01/2013001001235414/01/201311112683290,0006,700,8000,00312Compra025010117680426200010117/01/2013009002188217/01/201311109588450,00019,6402,36000,00332Compra02601020017016076300321/01/2013001001120621/01/201311111325740,00235000000,00307Compra027010113117380310010116/01/2013001001192416/01/201311118349970,0002903,481,0400,00312Compra028010113086946500010115/01/2013001001235515/01/201311112683290,0002,2300,27000,00312Compra029010113003365240010115/01/20130010011628715/01/201311120085040,007000000,00312Compra030010113068584710010116/01/2013001001552116/01/201311120978850,003,5000000,00312Compra03101019900175140010120/01/201307600313926320/01/201311111089990,0002,8200,34000,00332Compra032010113036704650010117/01/20130060019576617/01/201311121727950,0009,4301,13000,00332Compra033010113917369400010117/01/20130010017634017/01/201311119723750,0008,0400,96000,00312Compra034010117913116710010117/01/201300100118436517/01/201311116793390,00039,2904,71000,00332Compra03501015010547530010118/01/201300400125157118/01/201311114397350,00012,501,5000,00332Compra036010119000833930010115/01/20130020018620115/01/201311120146490,0008,9301,07000,00332Compra037010113009450350010118/01/201300300127256718/01/201311119918220,00011,6101,39000,00332Compra038010117921482430010118/01/201300100180182918/01/201311116816500,00014,1101,69000,00332Compra039010113099661980010121/01/2013001001352921/01/201311121697720,00025030,900,00312Compra040010113040869350010124/01/2013001001100324/01/201311120430050,000120014,4010,080,00307Compra041010113055204030010125/01/20130010011008825/01/201311119993380,00062,507,5000,00307Compra042010113031689650010124/01/2013001001169824/01/201311116585560,0045000000,00312Compra043010117681525600010110/01/20130010012118768310/01/201311107836860,0006,200,74000,00332Compra044010117681525600010117/01/20130010012197714617/01/201311107836860,000244,02029,28000,00332Compra045010117681525600010124/01/20130010012253218624/01/201311107836860,0062,87000000,00332Compra046010117681525600010117/01/20130010012179138217/01/201311107836860,00033,4304,01000,00332Compra047010113055204030010129/01/20130010011010329/01/201311119993380,0005,100,61000,00307Compra048010113055204030010129/01/20130010011010429/01/201311119993380,0060000000,00312Compra049010113068119910010128/01/20130010011878528/01/201311120074540,00035,7204,29000,00312Compra050010113917415100010125/01/201300600124136525/01/201311112032420,0008,9301,07000,00332Compra051010113012660430010122/01/201300100113420422/01/201311121427950,00013,9301,67000,00332Compra052010113917343790010123/01/20130010018177123/01/201311120163580,00012,8501,54000,00332Compra053010117910720730010125/01/20130020015838025/01/201311117093130,00016,8402,02000,00332Compra054010111001201440010121/01/20130010013340421/01/201311114342050,00022,102,65000,00312Compra055010113003365240010123/01/20130010011632621/01/201311120085040,0013,25000000,00312Compra056010113117380310010125/01/2013001001198525/01/201311118349970,0003,5700,430,1300,00312Compra057010113038645480010128/01/20130010013663428/01/201311120597960,0009,8201,18000,00312Compra058010113901193870010128/01/20130080011846628/01/201311108647850,000253,84030,46000,00312Compra059010113012660430010128/01/201300100113464728/01/201311121427950,00014,2901,71000,00332Compra060010113901435630010130/01/201300300125504830/01/201311113954190,00014,0601,69000,00332Compra061010113917646260010130/01/201300100117251730/01/201311121301220,0000,8400,1000,00332Compra062010113098938300010128/01/201300100127628/01/201311113942590,00150000000,00303Compra063010113025021560010111/01/20130010011111/01/201311111719400,0066,67000000,00303Compra064010113003389830010117/01/201300100132717/01/201311110301580,00336000000,00303

Slo se llena las compras que superanlos 1000 dlaresCdigo de compraForma de pago

Cdigo de compraCdigo de retencinBase imponiblePorcentaje de retencinValor retenidoFecha de pago de dividendoImpuesto a la renta AsociadoAo de utilidad dividendoCompra001307021,86Compra002312010,33Compra0033325,7800Compra00433228,7800Compra00533296,8600Compra00633230,600Compra00733220,1300Compra00833213,5500Compra00933265,700Compra010307024Compra01130714522,9Compra0123040812Compra013312010,08Compra0143321400Compra015332000Compra016332000Compra017312010,05Compra01831241,9510,42Compra019312010,02Compra020332000Compra021312010,27Compra022312010,03Compra0233121410,14Compra024312010,07Compra025332000Compra02630723524,7Compra027312010,29Compra028312010,02Compra029312710,07Compra0303123,510,04Compra031332000Compra032332000Compra033312010,08Compra034332000Compra035332000Compra036332000Compra037332000Compra038332000Compra039312010,25Compra040307022,4Compra041307021,25Compra0423124510,45Compra043332000Compra044332000Compra04533262,8700Compra046332000Compra047307020,1Compra0483126010,6Compra049312010,36Compra050332000Compra051332000Compra052332000Compra053332000Compra054312010,22Compra05531213,2510,13Compra056312010,04Compra057312010,1Compra058312012,54Compra059332000Compra060332000Compra061332000Compra0623031501015Compra06330366,67106,67Compra0643033361033,6

Tipo de Identificacin del ClienteNo. de Identificacin del ClienteCdigo tipo de comprobanteNo. de Comprobantes EmitidosBase Imponible No objeto de IVABase Imponible tarifa 0% IVABase Imponible tarifa IVA diferente de 0%Monto IVAValor de IVA que le han retenidoValor de Renta que le han retenido050001309083978181080000005000130583312918108000000413116795240011810750000050001304079815181010000000500017078974661810155000005000130726349918101400000050001307263481181075000005000130033582318101550000050001308692910181080000005000130947675018201600000050000908923477181075000004130696509400118201600000050001310129679181075000005000130406183918202350000050001306675891181075000005000130425879918101800000050001306127745181075000005000130522009518101200000050001305134221181025000005000130757618918108000000413024169360011810800000050001202327837181070000005000130033974218108000000500013082030071810800000050001310043300181024000000500013055961221810800000050001306953777181010000000500013076158621830180000005000130838163918101500000050001312051525181060000005000130242354418107500000500013032211451810750000050001307752160181075000005000130791644318107500000500013104289981810750000050001311656092181050000005000180123348518108000000500013095945521810150000005000130614055718107500000500018017049491810800000050001307695229181080000005000170201655918108000000500013006441901830210000005000130744241618106000000500013104455621810750000041304313578001182015500000500013114288311810600000041303263956001181013000000417103799320011810140000005000130361636918101200000050001304702937181075000005000130514053318108000000500013044685621810800000050001307426765181080000004130647160600118108000000500013050880211810800000050001306221092181060000004130375011900118107500000413077211730011810160000005000130992210018106000000500013055208331810800000050001304236456181014000000500013119919521810600000041391710712001181075000005000130486735918108000000500013061126061820115000004130433003600118101600000050000800226078181075000005000130758825918105500000500017502903871810750000050001306342468181075000005000130889054818101550000050001309147641181060000004130334688400118108000000500009081592391810750000050001308532843181075000005000171258457018106000000500013067923321810110000005000130681199118107500000413040608230011810750000050001307206043181080000005000130689666118108000000413080986470011810800000041301126544001181015000000500018025369101810800000050001308791290181060000005000130472969018107500000500013071190061810700000050001308675956181080000005000130268035818107500000500013060524891810800000050001307626091181019000000500013024304651810800000041307487247001181080000004131222955000118107500000500013045665971810800000050001305642553181080000005000130489457718105000000413104606110011810800000050001304332040181080000004130250215600118106000000500013085944391810600000040902031814001181080000005000130043481618201400000050001305529453181060000005000130622533318101600000050001307213247182015500000500013039609991810800000050001709560930181050000004130443470500118107500000413045946800011810800000050001302033368181080000005000130564178718108000000500013033600911810800000050001303070658181080000005000130209826218101600000050001705168134181080000005000171039038418201500000050001310354798181060000005000130288087518108000000500013035324181810800000050001304106360181060000005000130303007418101600000041306127836001181060000005000130998386218101900000050001303894636181080000005000130704303218106000000401000075410011810155000005000130700644318202350000050001306176445181080000005000130653626718108000000500013092121301810750000041305843300001181080000005000130556692718101950000040992648481001182014000000500009041342281810800000050001304062464181080000005000130511317518102000000500017127332921810800000050001307402568181016000000500017042626721810800000050001307767879181080000005000130559460618106000000500013086933061810800000041306390210001182016000000500017064321581810180000005000130552038718107500000500017070481511810800000050001308086428181075000005000130712001218201000000050001302299563181080000005000130455268818101300000050001302543556181080000004130646711700118301900000050001305593509181040000005000130383877318201550000050001308098647181080000005000130811058218301950000050001304045725182016000000500013072268011820155000004130482865800118201600000050001304331885181080000005000130791719318108000000500013042254001810800000050001304804881182016000000500013068741481810800000050001306608942181080000005000130445712818108000000413066763780011830180000005000131061054618201600000050001306577303181080000005000130163782118108000000417046849820011810800000050001306678127181050000005000131092033318201550000050001303437683182080000005000080180836118108000000500013085937611810800000050001303119588181080000005000130556987118108000000500013006407681810800000050001308678612183018000000500013080892321810800000050001306355072181080000005000130559535518108000000500013043318771810800000050001306888304181080000005000130154305218108000000500013021906221810800000050001300517891181080000005000130439885018401600000050001305596965181080000005000130709677418108000000500013060472731810140000005000130529402518108000000500013065103531810800000050001305595967181080000005000171552730318107500000500013056408131810800000050001301549448181080000005000091068362218201400000050001300430855181080000004130504811600118108000000500013038386411830192.500000500013070386691810800000050001304979816181080000004139177264500118201500000050001303553588181080000005000130696502918201550000050001304061912181060000005000131150287418107500000500013096514101810750000050001305642017181018000000500013098548321810600000041309164711001181013500000500013061276791810800000050001308593753181080000004130345430800118108000000500013003379441810800000050001306994961183019000000500013074948701810800000050001309438891181080000005000130123150018108000000500013098624701820155000005000131188398518105000000500004007263781810600000050001304249384181080000005000130749473018108000000500013090882411810800000050001302692387181080000005000130708971218108000000500013013235701820155000004130777842100118108000000500013052881181810800000050001305796060183019500000500013027950321810800000050000913348298181080000005000130859359718201100000050001307215002182012000000413046020610011810195000004130043321400118106000000500009140736061810195000005000130564296718108000000500013069189861820140000005000130798377318108000000500013076448391810800000050001305197806181080000005000170840598818108000000500013040358741810800000050001306861772181080000005000130786184718108000000500013084924991810800000050001707632855181080000005000130317947518201400000050001304361098182016000000500013033828141810800000041307526077001181080000005000130694981718108000000500013083187711810550000050001304798208182014000000500013044028841820100000005000130820587918108000000413113577330011820155000004130999965200118106500000500013104842231810500000050001306577741181080000005000130891384518201000000041301485394001181060000005000130286792218108000000500013071407391820125000005000130470779518108000000500013115123601810750000050000907845788181014000000500017078610741810800000050001307295020181075000005000130717923218106000000500013066299971810800000050001310339542181080000005000131173216618108000000500013086328901810600000050001306125988181050000005000131128626218108000000500013039837511810750000050001308591781181075000005000130159178118301900000041305844498001181075000005000090502867618107500000413098806700011820150000005000130694318218107500000413099996500011810650000050001308759792182010000000500013076778221820150000005000131172528518201200000050001309390860181075000005000130832354018107500000500013056400451810600000050000916354194181050000005000130859413218105000000413917794370011820150000005000130843909818201500000050001303777260181060000005000131130322418201500000050001311804031181075000005000131135765918107500000500013115540651810750000050001310074403181050000005000130815000018107500000500013100951281810750000050000801228495181075000004120021805300118105000000500013133493991810600000050001314469113181030000005000131184880618106000000500013086933971810500000050001305640599181080000005000130055154418104000000500013069830481810800000050001306129279181080000004130798292400118107500000500013019650811810800000050001309467487181060000005000130879219918107500000500013070252451810800000050001308421617181075000004130513270400118106000000500013095896281810150000005000130221957918108000000413098938300011810500000050001309667713181013000000500013075663471810800000050001301871578181080000004091162381700118101600000041306195320001181015000000500013049176261810800000050001301990543181075000007999999999999918705780000