Análisis Cuentas Por Pagar

  • Published on
    06-Feb-2016

  • View
    38

  • Download
    0

DESCRIPTION

archivo en excel

Transcript

Hoja2CdigoSuma de Saldo pesosBALANCECXPC9003525470.0ERROR:#N/A0P10058237(266,231)-266231-2662310.0P1017123859(60,000)-60000-600000.0P1018411823(3,132,313)-3132313-31323130.0P1038405254(370,000)-370000-3700000.0P1042426272(50)-50-500.0P1045685925(50,000)-50000-500000.0P1052382384(742,400)-742400-7424000.0P1053330262(43,080)-43080-430800.0P1075229895(104,500)-104500-1045000.0P1109291206(14,027)-14027-140270.0P1112618266(1,194,798)-1194798-11947980.0P1128276362(175,994)-175994-1759940.0P1132933(30,067,070)-30067070-300670700.0P1151937733(464,500)-464500-4645000.0P14954936(243,000)-243000-2430000.0P15487826235,4532354532354530.0P167515971,759,573175957317595730.0P16788165(4,294)-4294-42940.0P17068023(603,555)-603555-6035550.0P17150081(11,662,400)-11662400-116624000.0P18397788(36,400)-36400-364000.0P19097189(3,218,544)-3218544-32185440.0P19254921(3,999,085)-3999085-39990850.0P19474836(235,200)-235200-2352000.0P20647991(28,054)-28054-280540.0P22428492(220,742)-220742-2207420.0P22519744510,0005100005100000.0P22647342(190,000)-190000-1900000.0P23553423(2,750,280)-2750280-27502800.0P23965121(43,054)-43054-430540.0P24047575(526,897)-526897-5268970.0P24201985(37,539)-37539-375390.0P250034(102,274)-102274-1022740.0P28161669130,0001300001300000.0P28542158(266,070)-266070-2660700.0P28799690.0ERROR:#N/A0ERROR:#N/AP30303891(165,000)-165000-1650000.0P3065143(10,520)-10520-105200.0P30730243(260,000)-260000-2600000.0P3140740(10,817,640)-10817640-108176400.0P31842439(37,200)-37200-372000.0P31863672(225,000)-225000-2250000.0P31953555(104,500)-104500-1045000.0P31992623(144,000)-144000-1440000.0P32353633(228,130)-228130-2281300.0P32640692(232,500)-232500-2325000.0P32667805(2,507,873)-2507873-25078730.0P32679401(114,600)-114600-1146000.0P32692624(1,111,997)-1111997-11119970.0P3351171(44,262)-44262-442620.0P3365883(588,966)-588966-5889660.0P34983330(486,807)-486807-4868070.0P37862190(130,000)-130000-1300000.0P38565718(116,555)-116555-1165550.0P38569561(115,090)-115090-1150900.0P39574019(529,500)-529500-5295000.0P39574019.(88,500)-88500-885000.0P40045229(14,124)-14124-141240.0P40989591,605,100160510016051000.0P41654860(588,000)-588000-5880000.0P41673247(51,040)-51040-510400.0P41729053(6,815,111)-6815111-68151110.0P41757380(1,141,440)-1141440-11414400.0P41885504(8,340)-8340-83400.0P41889951(1)-0.5-0.50.0P42004915(1,125,173)-1125173-11251730.0P42115998(355,300)-355300-3553000.0P42118763(100,000)-100000-1000000.0P4228478(99,562)-99562-995620.0P4234081(5,267,464)-5267464-52674640.0P43278679(70,000)-70000-700000.0P43400645(235,009)-235009-2350090.0P4347008557,54157541575410.0P43627547(467,942)-467942-4679420.0P43872370(280,000)-280000-2800000.0P43903475(1,305,000)-1305000-13050000.0P444419(136,659,947)-123525201.65-136659946.9113,134,745P444420(77,515,704)-77515704-775157040.0P444421(923,016,977)-923016977.5-923016977.38(0)P4444300.0000.0P444436(229,867,653)-229867641.1-229867652.511P444437263262.89263.1700000054(0)P444439(766,352,787)-766352787.6-766352787.2(0)P444445(52,098,209)-52098208.96-52098208.960.0P4444500.00.0200P444451(116,103,691)-116103691.34-116103691.340.0P4444520.00.5201P4444570.00.200P444458(0)0-0.00000000140P4444590.0000.0P444460(118,666,016)-118666016-1186660160.0P444464(0)0-0.00000000750P4444660.0000.0P4444680.0000.0P444469000.0000000009(0)P444470(0)0-0.00000000360P444472(180,823,921)-180823921.77-180823921.15(1)P4444750.0000.0P444477(252,144,230)-253085898-252144230.34(941,668)P4444780.0-0.850(1)P4444800-21574171.810.0100000165(21,574,172)P444481(180,944,142)-180944142.4-180944142.26(0)P4444830.00.4400P4444840.0000.0P4444850.0-0.40(0)P4444880.00.2400P4444940.0000.0P45473789(235,000)-235000-2350000.0P46356176(181,000)-181000-1810000.0P5074481(27,825)-27825-278250.0P51629669(125,000)-125000-1250000.0P51672739(223,500)-223500-2235000.0P517814173,015,400301540030154000.0P51786382(7,191,994)-7191994-71919940.0P51800583(28,054)-28054-280540.0P51815395(238,100)-238100-2381000.0P51898733(14,027)-14027-140270.0P51901096(218,837)-218837-2188370.0P51904138(812,000)-812000-8120000.0P51915080(165,000)-165000-1650000.0P51933509(200,000)-200000-2000000.0P51944576(21,040)-21040-210400.0P51955611(200,000)-200000-2000000.0P51965155(223,500)-223500-2235000.0P51975750(171,600)-171600-1716000.0P51996496(31,539)-31539-315390.0P52097411(39,745)-39745-397450.0P52101249(28,054)-28054-280540.0P52167405(24,719)-24719-247190.0P52249500(44,000)-44000-440000.0P52364274(4,160,640)-4160640-41606400.0P52413943(223,500)-223500-2235000.0P52483815(20,406)-20406-204060.0P52489326(18,155,820)-18155820-181558200.0P52519940(58,941)-58941-589410.0P526442730.0000.0P52867072(200,000)-200000-2000000.0P52902398(29,556)-29556-295560.0P52978660(155,889)-155889-1558890.0P531137780.0000.0P53114252(84,586)-84586-845860.0P55176638(206,200)-206200-2062000.0P55220340(28,054)-28054-280540.0P55302498(200,000)-200000-2000000.0P57438378(200,000)-200000-2000000.0P5898839(3,560,000)-3560000-35600000.0P5937609(991,034)-991034-9910340.0P6013819(3,220,000)-3220000-32200000.0P6043276(111,565)-111565-1115650.0P65500920(28,054)-28054-280540.0P65701155(320,465)-320465-3204650.0P65789064(24,000)-24000-240000.0P65798131(28,054)-28054-280540.0P66809447100,0001000001000000.0P66907265(250,000)-250000-2500000.0P66930212(104,500)-104500-1045000.0P67014930(52,000)-52000-520000.0P71110634(386,219)-386219-3862190.0P71331764(220,000)-220000-2200000.0P71339223(260,000)-260000-2600000.0P71374524(57,738)-57738-577380.0P71783447(896,000)-896000-8960000.0P72133413(72,222)-72222-722220.0P72149821(156,107)-156107-1561070.0P72153355(143,800)-143800-1438000.0P72179684(130,200)-130200-1302000.0P72183106(1,111,204)-1111204-11112040.0P72183660(0)-0.14-0.140.0P72219079(139,845)-139845-1398450.0P72270629(250)-250-2500.0P72271953(1,482)-1482-14820.0P72432661(50)-50-500.0P7309079(694,313)-694313-6943130.0P73111819(169,772)-169772-1697720.0P73200984(11,246)-11246-112460.0P74324494(523,160)-523160-5231600.0P74325801(167,330)-167330-1673300.0P7456349(300,825)-300825-3008250.0P7472582(1,823,372)-1823372-18233720.0P769927399,90099900999000.0P791247277,564,115756411575641150.0P79128021(7,400)-7400-74000.0P79145563(14,596,931)-14596931-145969310.0P79156086(17,411,525)-17411525-174115250.0P79156086.(11,310,449)-11310449-113104490.0P79206040(495,370)-495370-4953700.0P79242145(12,842,844)-12842844-128428440.0P79280959(48,340)-48340-483400.0P79281544(2,640,000)-2640000-26400000.0P79372449(20,469)-20468.6-20468.60.0P79455732(334,263)-334263-3342630.0P79481693(13,042)-13042-130420.0P79515869(3,174,249)-3174249-31742490.0P79538829(5,672,700)-5672700-56727000.0P79614094(971,190)-971190-9711900.0P79716984(4,564)-4564-45640.0P79734672(240,000)-240000-2400000.0P79886278(21,040)-21040-210400.0P800005009606,0906060906060900.0P800011002(163,940,770)-163940770-1639407700.0P800018078(17,426,176)-17426176-174261760.0P800018078.(20,000)-20000-200000.0P800034633(1,618,056)-1618056-16180560.0P800045218(1,448,275)-1448275-14482750.0P80008629(1,870,857)-1870857-18708570.0P800090323(3,596,224)-3596224-35962240.0P800092723(8,262,680)-8262680-82626800.0P800106774(1,683,599)-1683599-16835990.0P800112214(8,584,950)-8584950-85849500.0P800124188(1,512,995)-1512995-15129950.0P800128359(4,626,450)-4626450-46264500.0P800130907(78,129)-78129-781290.0P800144355(131,615)-131615-1316150.0P800148290(11,084,198)-11084198-110841980.0P800148290.0.0000.0P800148756(1,931,751)-1931751-19317510.0P800151988(149,972,678)-149972678-1499726780.0P8001539930.0000.0P800159215(801,900)-801900-8019000.0P800163872(1,498,200)-1498200-14982000.0P800166024(760,320)-760320-7603200.0P800172301(1,628,793)-1628793-16287930.0P800172508(91,833,681)-91833681-918336810.0P800196550(15,795)-15795-157950.0P800203445(28,885,213)-28885213-288852130.0P800206442(7,022,370)-7022370-70223700.0P800207233(2,832,392)-2832392-28323920.0P800208990(352,225)-352225-3522250.0P800209831(332,640)-332640-3326400.0P8002171290.0000.0P800222082(240,800)-240800-2408000.0P800226013(1,108,800)-1108800-11088000.0P800237608(13,250,610)-13250610-132506100.0P800241469(257,780)-257780-2577800.0P800249518(11,231,320)-11231320-112313200.0P800250119(52,707)-52707-527070.0P800251984(4,704,000)-4704000-47040000.0P80025893(48,588)-48588-485880.0P80039452(2,723,028)-2723028-27230280.0P80158768(10,625)-10625-106250.0P802001223(295,609)-295609-2956090.0P802005636(99,868)-99868-998680.0P802014471(308,861)-308861-3088610.0P802015330(191,023)-191023-1910230.0P80206712(110,000)-110000-1100000.0P80266557(200,000)-200000-2000000.0P8032234(29,323)-29323-293230.0P80366456(161,061)-161061-1610610.0P80370546(11,000)-11000-110000.0P805000427(260,864)-260864-2608640.0P805006798(626,032)-626032-6260320.0P805008909(12,728,348)-12728348-127283480.0P805015151(1,186,712)-1186712-11867120.0P805020433(1,155)-1155-11550.0P805020438(202,056)-202056-2020560.0P805021782(1,110,000)-1110000-11100000.0P805028088105,6691056691056690.0P808001905(12,481,188)-12481188-124811880.0P80896500(6,600)-6600-66000.0P809006578(448,000)-448000-4480000.0P811001259(14,058,540)-14058540-140585400.0P811016478(966,474)-966474-9664740.0P811022408(55,605,261)-55605261-556052610.0P811023570(15,246,000)-15246000-152460000.0P81102862485,37985379853790.0P8110318300.0ERROR:#N/A0ERROR:#N/AP811042361(792,158)-792158-7921580.0P8110456071,916,865191686519168650.0P824003724(232,322)-232322-2323220.0P830000055(3,688,195)-3688195-36881950.0P830000556(119,510,698)-119510698-1195106980.0P830000817(4,154,271)-4154271-41542710.0P830000817.(1,222,252)-1222252-12222520.0P830001066(3,339,840)-3339840-33398400.0P830009816(29,878,875)-29878875-298788750.0P830018274(3,857,865)-3857865-38578650.0P830022636(301,162)-301162-3011620.0P830031045(28,009,371)-28009371-280093710.0P830036477(666,245)-666245-6662450.0P830037248(39,340)-39340-393400.0P830038007(114,800,044)-114800044-1148000440.0P830038007.(64,819)-64819-648190.0P830040575(7,378,451)-7378451-73784510.0P830043188(119,600,000)-119600000-1196000000.0P830043991(257,600)-257600-2576000.0P830048588(55,122,623)-55122623-551226230.0P830049459(19,488,000)-19488000-194880000.0P830050996(52,114,000)-52114000-521140000.0P830053800(728,465)-728465-7284650.0P830054838(4,496,534)-4496534-44965340.0P830060056(1,085,839)-1085839-10858390.0P830064013(4,930,440)-4930440-49304400.0P830070875(563,868)-563868-5638680.0P830086318(1,384,544)-1384544-13845440.0P830087275(4,135,493)-4135493-41354930.0P830090229(5,862,181)-5862181-58621810.0P8301032970.0000.0P830103297.(116,513)-116513-1165130.0P830103572(5,399,944)-5399944-53999440.0P830109367(13,068,105)-13068105-130681050.0P830109398(1,000,487)-1000487-10004870.0P830109486(54,195,496)-54195496-541954960.0P830113831(390,569)-390569-3905690.0P830117420(353,643)-353643-3536430.0P830117750(131,754,396)-131754396-1317543960.0P830135405(658,393)-658393-6583930.0P830136376(1,316,337)-1316337-13163370.0P830143316(18,795,600)-18795600-187956000.0P830505703(572,040)-572040-5720400.0P860000615(94,598,407)-94598407-945984070.0P860000761(9,442,438)-9442438-94424380.0P860001300(928,000)-928000-9280000.0P860001978(22,234,300)-22234300-222343000.0P8600021530.0000.0P860002153,OTROS(1,341,224)-1341224-13412240.0P860002153.ST(1,921,269)-1921269-19212690.0P8600030200.0000.0P860007336(3,239,921)-3239921-32399210.0P860010451(637,206)-637206-6372060.0P860013809(380,900,404)-380900404-3809004040.0P860025188(3,967,960)-3967960-39679600.0P860026182(16,521,187)-16521187-165211870.0P860027917(1,799,856)-1799856-17998560.0P860028238(4,764,330)-4764330-47643300.0P860031615(377,824)-377824-3778240.0P860032550(55,208,467)-55208467-552084670.0P860034812(12,613,956)-12613956-126139560.0P860039988(5,182,159)-5182159-51821590.0P860041813(3,456,449)-3456449-34564490.0P860042155(8,554,087)-8554087-85540870.0P860042593(2,787,311)-2787311-27873110.0P860048617(298,066)-298066-2980660.0P860051447(96,650,239)-96650239-966502390.0P860075787(27,747,200)-27747200-277472000.0P860079829(4,354,466)-4354466-43544660.0P860403163(34,410,000)-34410000-344100000.0P860404791(122,306)-122306-1223060.0P860450987(288,000)-288000-2880000.0P860507423(74,164,313)-74164313-741643130.0P8605110010.0000.0P860512330(273,400)-273400-2734000.0P860512699(439,060)-439060-4390600.0P860529748(16,636,262)-16636262-166362620.0P860530492(1,230,707)-1230707-12307070.0P860530492.(420,781)-420781-4207810.0P86681510.0000.0P8672328(204,600)-204600-2046000.0P8720909(68,600)-68600-686000.0P8733089(130,200)-130200-1302000.0P8740419(28,054)-28054-280540.0P8759668(56,285)-56285-562850.0P88157537(24,360)-24360-243600.0P890101994(1,826,700)-1826700-18267000.0P890102466(13,680,346)-13680346-136803460.0P890106278(11,229,854)-11229854-112298540.0P890106280(2,900,000)-2900000-29000000.0P890107487(16,158,345)-16158345-161583450.0P890110294(180,960)-180960-1809600.0P890110850(218,400)-218400-2184000.0P890111175(376,977)-376977-3769770.0P890117683(267,305)-267305-2673050.0P890200219(31,210,000)-31210000-312100000.0P8903002790.0000.0P890300346(17,427,971)-17427971-174279710.0P890301067(77,160)-77160-771600.0P890301884(9,401,707)-9401707-94017070.0P890302594(48,520,500)-48520500-485205000.0P890303208(2,822,576)-2822576-28225760.0P890311628(23,075,684)-23075684-230756840.0P890399003(505,736)-505736-5057360.0P890703203(4,244,900)-4244900-42449000.0P890806490(142,486)-142486-1424860.0P890900118(141,129,694)-141129694-1411296940.0P890900119(1,212,803)-1212803-12128030.0P890900608(40,629,319)-40629319-406293190.0P890900842(28,000)-28000-280000.0P890900943(7,156,270)-7156270-71562700.0P89090117287,34287342873420.0P890903295(9,209,737)-9209737-92097370.0P890903407(13,062,380)-13062380-130623800.0P890903790(413,792)-413792-4137920.0P8909039380.0000.0P890904996(3,888,255)-3888255-38882550.0P890906660(10,578,872)-10578872-105788720.0P890906878(855,360)-855360-8553600.0P89091398730,14430144301440.0P890917018(5,026,631)-5026631-50266310.0P890917465(2,916,555)-2916555-29165550.0P890919549(9,253,000)-9253000-92530000.0P890928257(64,927,071)-64927071-649270710.0P890929497(1,845,281)-1845281-18452810.0P891100024(513,112)-513112-5131120.0P891300241(33,097,260)-33097260-330972600.0P899999115(2,152,720)-2152720-21527200.0P900020635(14,521,196)-14521196-145211960.0P900021737(323,430)-323430-3234300.0P900027396(2,745,519)-2745519-27455190.0P900028583(11,202)-11202-112020.0P900033767(16,421,167)-16421167-164211670.0P9000340063,077,266307726630772660.0P900037539(126,841,463)-126841463-1268414630.0P900039775(8,238,016)-8238016-82380160.0P900059238(51,546,015)-51546015-515460150.0P900061224499,5004995004995000.0P900084379(11,762,760)-11762760-117627600.0P90009238565,05365053650530.0P900099646(467,250)-467250-4672500.0P900119170(5,058,765)-5058765-50587650.0P900146342(1,840,122)-1840122-18401220.0P900153392(644,266)-644266-6442660.0P900155107(5,902,367)-5902367-59023670.0P900156264(166,982)-166982-1669820.0P900157270(208,485)-208485-2084850.0P900160512(200,000)-200000-2000000.0P900165196(772,910)-772910-7729100.0P900165196,(193,103)-193103-1931030.0P900175475(472,500)-472500-4725000.0P900181710(2,000,000)-2000000-20000000.0P90...