{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hoja2","CONCILIACIONES","LDF EAID"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":15,"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":"Hoja2","index":0,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["MESES","DIAS","AÑO"]
["Enero",1,2018]
["Febrero",31,2019]
["Marzo",null,2020]
["Abril",null,2021]
["Mayo",null,2022]
["Junio",null,2023]
["Julio",null,2024]
["Agosto",null,2025]
["Septiembre",null,2026]
["Octubre",null,2027]
["Noviembre",null,2028]
["Diciembre",null,2029]
[null,null,2030]
[null,null,2031]
[null,null,2032]
[null,null,2033]
[null,null,2034]
[null,null,2035]
[null,null,2036]
[null,null,2037]
[null,null,2038]
[null,null,2039]
[null,null,2040]
[null,null,2041]
[null,null,2042]
[null,null,2043]
[null,null,2044]
[null,null,2045]
[null,null,2046]
[null,null,2047]
[null,null,2048]
[null,null,2049]
[null,null,2050]

{"sheet":"CONCILIACIONES","index":1,"n_rows":72,"n_cols":12,"rows_kept":72,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[6,1,6,2],[25,1,25,2]]}
[null,null,null,null,"ANEXO 5"]
[null,"H. AYUNTAMIENTO DEL MUNICIPIO DE VERACRUZ, VERACRUZ"]
[null,"CONCILIACIONES CONTABLES - PRESUPUESTALES"]
[null,"CORRESPONDIENTE DEL 01 DE FEBRERO AL 29 DE FEBRERO 2020"]
[]
[null,"Conciliación entre los Ingresos Presupuestarios y Contables"]
[null,"Concepto",null,null,"$"]
[null,"1. Ingresos Presupuestarios",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[null,"2. Más ingresos contables no presupuestarios",null,null,{"$f":"SUM(D11:D15)","v":{"$error":"#REF!"}}]
["4.3.2",null,"Incremento por variación de inventarios",0]
["4.3.3",null,"Disminución del exceso de estimaciones por pérdida o deterioro u obsolescencia",0]
["4.3.4",null,"Disminución del exceso de provisiones",0]
["4.3.9",null,"Otros ingresos y beneficios varios",0]
[null,null,"Otros ingresos contables no presupuestarios",{"$f":"-#REF!","v":{"$error":"#REF!"}}]
[]
[null,"3. Menos ingresos presupuestarios no contables",null,null,{"$f":"SUM(D18:D21)","v":{"$error":"#REF!"}}]
[null,null,"Productos de capital",0]
[null,null,"Aprovechamientos capital",{"$f":"+K34+K35","v":99737778.039999962}]
[null,null,"Ingresos derivados de financiamientos",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,"Otros Ingresos presupuestarios no contables",{"$f":"+K36","v":130000000}]
[null,null,null,null,null,null,"COMPROBACIÓN","DIFERENCIA"]
[null,"4. Ingresos Contables (4 = 1 + 2 - 3)",null,null,{"$f":"+E8+E10-E17","v":{"$error":"#REF!"}},null,421499159.88000005,{"$f":"+E23-G23","v":{"$error":"#REF!"}}]
[]
[null,"Conciliación entre los Egresos Presupuestarios y Contables"]
[null,"Concepto",null,null,"$"]
[null,"1. Total de egresos (presupuestarios)",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[null,"2. Menos egresos presupuestarios no contables",null,null,{"$f":"SUM(D30:D59)","v":{"$error":"#REF!"}}]
["1.2.4.1",null,"Mobiliario y equipo de administración",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["1.2.4.2",null,"Mobiliario y equipo educacional y recreativo",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["1.2.4.3",null,"Equipo e instrumental médico y de laboratorio",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["1.2.4.4",null,"Vehículos y equipo de transporte",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Activos Intangibles",null,"INTEGRACION DEL DEVENGO PRESUPUESTAL EN ENERO 2020"]
["1.2.4.5",null,"Equipo de defensa y seguridad",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Remanentes Fiscales",null,99737778.039999962,"APROVECHAMIENTOS"]
["1.2.4.6",null,"Maquinaria, otros equipos y herramientas",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Fideicomiso centro Histórico",null,0,"APROVECHAMIENTOS"]
["1.2.4.7",null,"Colecciones, Obras de Arte y Objetos Valiosos",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Remanente de Participaciones",null,130000000,"PARTICIPACIONES"]
["1.2.4.8",null,"Activos biológicos",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"RECURSO ZOFEMAT (REMANENTE)",null,0,"PARTICIPACIONES (CONVENIOS)"]
[null,null,"Activos Intangibles",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"FONDO ZOFEMAT (REMANENTE)",null,0,"PARTICIPACIONES (CONVENIOS)"]
[null,null,"Bienes inmuebles",0,null,null,null,null,"FONDO DE HIDROCARBUROS MARITIMOS(REMANENTE)",null,0,"PARTICIPACIONES (CONVENIOS)"]
["1.2.3.1",null,"Terrenos",null,null,null,null,null,null,null,{"$f":"SUM(K34:K39)","v":229737778.03999996}]
["1.2.3.2",null,"Viviendas"]
["1.2.3.3",null,"Edificios no Habitacionales"]
["1.2.3.4",null,"Infraestructura"]
["1.2.3.9",null,"Otros Bienes Inmuebles"]
[]
["1.2.5",null,"Activos intangibles",0]
[null,null,"Obra pública en bienes propios",0]
["1.2.3.5",null,"Construcciones en Proceso en Bienes de Dominio Público",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["1.2.3.6",null,"Construcciones en Proceso en Bienes Propios",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["1.2.1.4",null,"Acciones y participaciones de capital",0]
[null,null,"Compra de títulos y valores",0]
[null,null,"Inversiones en fideicomisos, mandatos y otros análogos",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,"Provisiones para contingencias y otras erogaciones especiales",0]
["5.5.2.2",null,"Provisiones de Pasivos a Largo Plazo"]
[null,null,"Amortización de la deuda publica",0]
["2.1.3",null,"Porción a Corto Plazo de la Deuda Pública a Largo Plazo",{"$f":"+'[2]ANALISIS EGR'!$H$75","v":12798086.310000001}]
["2.2.3",null,"Deuda Pública a Largo Plazo"]
[null,null,"Adeudos de ejercicios fiscales anteriores (ADEFAS)",{"$f":"+'[2]ANALISIS EGR'!$H$81","v":0}]
[null,null,"Otros Egresos Presupuestales No Contables",0]
[]
[]
[null,"3. Más gastos contables no presupuestales",null,null,{"$f":"SUM(D63:D69)","v":{"$error":"#REF!"}}]
["5.5.1",null,"Estimaciones, depreciaciones, deterioros, obsolescencia y amortizaciones",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["5.5.2",null,"Provisiones",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["5.5.3",null,"Disminución de Inventarios",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["5.5.4",null,"Aumento por insuficiencia de estimaciones por pérdida o deterioro u obsolescencia",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["5.5.5",null,"Aumento por insuficiencia de provisiones",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["5.5.9",null,"Otros Gastos",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,"Otros Gastos Contables No Presupuestales",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,"COMPROBACIÓN","DIFERENCIA"]
[null,"4. Total de Gasto Contable (4 = 1 - 2 + 3)",null,null,{"$f":"+E27-E29+E62","v":{"$error":"#REF!"}},null,253069190.67000002,{"$f":"+E72-G72","v":{"$error":"#REF!"}}]

{"sheet":"LDF EAID","index":2,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":false,"merged":[[72,4,72,5],[63,4,63,5],[5,6,5,11],[7,3,7,5],[5,3,6,5],[70,4,70,5],[71,4,71,5]]}
[null,null,null,null,null,null,null,"FORMATO 5 ESTADO ANALÍTICO DE INGRESOS DETALLADO-LDF",null,null,null,null,"INDICE"]
[null,null,null,null,null,null,null,"H. Ayuntamiento del Municipio de Veracruz, Ver."]
[null,null,null,null,null,null,null,"Estado Analítico de Ingresos Detallado - LDF"]
[null,null,null,null,null,null,null,"Del 1 de enero al 30 de septiembre de 2023"]
[null,null,null,null,null,null,null,"(PESOS)"]
[null,null,null,"Concepto",null,null,"INGRESO"]
[null,null,null,null,null,null,"Estimado","Ampliaciones / (Reducciones)","Modificado","Devengado","Recaudado","Diferencia"]
[null,null,null,"  Ingresos de Libre Disposición",null,null,"","","","","",""]
[null,null,null,null,"A. Impuestos",null,372481613.22000003,36655908,409137521.22000003,371278006.70999998,371278006.70999998,-1203606.5100000501]
[null,null,null,null,"B. Cuotas y Aportaciones de Seguridad Social",null,0,0,0,0,0,0]
[null,null,null,null,"C. Contribuciones de Mejoras",null,0,0,0,0,0,0]
[null,null,null,null,"D. Derechos",null,130186176.87,15500000.000000002,145686176.87,132019733.12,132019733.12,1833556.25]
[null,null,null,null,"E. Productos",null,24441000.190000001,19294170.48,43735170.670000002,42425090.370000005,42425090.370000005,17984090.180000003]
[null,null,null,null,"F. Aprovechamientos",null,59128651.519999996,237954172.97,297082824.49000001,281833331.18000001,281833331.18000001,222704679.66000003]
[null,null,null,null,"G. Ingresos por Ventas de Bienes y Servicios",null,0,0,0,0,0,0]
[null,null,null,null,"H. Participaciones",null,1158439713.2999997,297988917.76000011,1456428631.0599997,1367312981.48,1367312981.48,208873268.18000016]
[null,null,null,null,null,"H1. Fondo General de Participaciones",700679041.67999995,7100000,707779041.67999995,657039535.13999999,657039535.13999999,-43639506.539999962]
[null,null,null,null,null,"H2. Fondo de Fomento Municipal",171889579.41999999,15000000,186889579.41999999,182759510.03,182759510.03,10869930.610000014]
[null,null,null,null,null,"H3. Fondo de Fiscalización y Recaudación",36085360.780000001,3000000,39085360.780000001,38454794.850000001,38454794.850000001,2369434.0700000003]
[null,null,null,null,null,"H4. Fondo de Compensación",0,0,0,0,0,0]
[null,null,null,null,null,"H5. Fondo de Extracción de Hidrocarburos",4179002.44,0,4179002.44,3877588.58,3877588.58,-301413.85999999987]
[null,null,null,null,null,"H6. Impuesto Especial Sobre Producción y Servicios",12561871.8999999,1.0058283805847168E-7,12561871.9,11727085.130000001,11727085.130000001,-834786.76999989897]
[null,null,null,null,null,"H7. 0.136% de la Recaudación Federal Participable",150568212,70000000,220568212,200881379,200881379,50313167]
[null,null,null,null,null,"H8. 3.17% Sobre Extracción de Petróleo",0,0,0,0,0,0]
[null,null,null,null,null,"H9. Gasolinas y Diesel",10786971.970000001,0,10786971.970000001,10501520.6,10501520.6,-285451.37000000104]
[null,null,null,null,null,"H10. Fondo del Impuesto Sobre la Renta",71689673.109999999,0,71689673.109999999,59182650.390000001,59182650.390000001,-12507022.719999999]
[null,null,null,null,null,"H11. Fondo de Estabilización de los Ingresos de las Entidades Federativas",0,0,0,0,0,0]
[null,null,null,null,null,"H.A SubTotal Participaciones",1158439713.2999997,95100000.000000104,1253539713.2999997,1164424063.72,1164424063.72,5984350.4200001545]
[null,null,null,null,null,"H.B Devolucion de Participaciones Retenidas",0,202888917.75999999,202888917.75999999,202888917.75999999,202888917.75999999,202888917.75999999]
[null,null,null,null,"I. Incentivos Derivados de la Colaboración Fiscal",null,8836709.6999999806,3400000.0000000214,12236709.700000001,8279742.1600000001,8279742.1600000001,-556967.53999997955]
[null,null,null,null,null,"I1. Tenencia o Uso de Vehiculos",0,0,0,0,0,0]
[null,null,null,null,null,"I2. Fondo de Compensación ISAN",2044346.3199999901,1.0011717677116394E-8,2044346.32,1460504.96,1460504.96,-583841.35999999009]
[null,null,null,null,null,"I3. Impuesto Sobre Automóviles Nuevos",6792363.3799999896,3400000.0000000112,10192363.380000001,6819237.2000000002,6819237.2000000002,26873.820000010543]
[null,null,null,null,null,"I4. Fondo de Compensación de Repecos-Intermedios",0,0,0,0,0,0]
[null,null,null,null,null,"I5. Otros Incentivos Económicos",0,0,0,0,0,0]
[null,null,null,null,"J. Transferencias",null,0,0,0,0,0,0]
[null,null,null,null,"K. Convenios",null,0,0,0,0,0,0]
[null,null,null,null,null,"K1. Otros Convenios y Subsidios",0,0,0,0,0,0]
[null,null,null,null,null,"K1. Subsidio alumbrado público",0,0,0,0,0,0]
[null,null,null,null,null,"K1. Subsidio Municipal",0,0,0,0,0,0]
[null,null,null,null,"L. Otros Ingresos de Libre Disposición",null,22120.5999999999,1455829.52,1477950.12,1307692.18,1307692.18,1285571.58]
[null,null,null,null,null,"L1. Participaciones en Ingresos Locales",0,0,0,0,0,0]
[null,null,null,null,null,"L2. Otros Ingresos de Libre Disposición",22120.5999999999,1455829.52,1477950.12,1307692.18,1307692.18,1285571.58]
[null,null,null,"  I.Total de Ingresos de Libre Disposición",null,null,1753535985.3999996,612248998.73000014,2365784984.1299996,2204456577.1999998,2204456577.1999998,450920591.80000019]
[null,null,null,"  Ingresos Excedentes de Ingresos de Libre Disposición",null,null,null,null,null,null,null,450920591.80000019]
[null,null,null,"  Transferencias Federales Etiquetadas"]
[null,null,null,null,"A. Aportaciones",null,723755924,4866643,728622567,574534695.85000002,574534695.85000002,-149221228.14999998]
[null,null,null,null,null,"A1. Fondo de Aportaciones para la Nomina Educativa y Gasto Operativo",0,0,0,0,0,0]
[null,null,null,null,null,"A2. Fondo de Aportaciones para los Servicios de Salud",0,0,0,0,0,0]
[null,null,null,null,null,"A3. Fondo de Aportaciones para la Infraestructura Social",187092938.31999999,116713.68000000715,187209652,168738685,168738685,-18354253.319999993]
[null,null,null,null,null,"A4. Fondo de Aportaciones para el Fortalecimiento de los Municipios y de las Demarcaciones Territoriales del Distrito Federal",536662985.68000001,4749929.3199999928,541412915,405796010.85000002,405796010.85000002,-130866974.82999998]
[null,null,null,null,null,"A5. Fondo de Aportaciones Múltiples",0,0,0,0,0,0]
[null,null,null,null,null,"A6. Fondo de Aportaciones para la Educación Tecnológica y de Adultos",0,0,0,0,0,0]
[null,null,null,null,null,"A7. Fondo de Aportaciones para la Seguridad Pública de los Estados y del Distrito Federal",0,0,0,0,0,0]
[null,null,null,null,null,"A8. Fondo de Aportaciones para el Fortalecimiento de las Entidades Federativas",0,0,0,0,0,0]
[null,null,null,null,"B. Convenios",null,171122,2060221.77,2231343.77,1955363.37,1955363.37,1784241.37]
[null,null,null,null,null,"B1. Convenios de Protección Social en Salud",0,0,0,0,0,0]
[null,null,null,null,null,"B2. Convenios de Descentralización",0,0,0,0,0,0]
[null,null,null,null,null,"B3. Convenios de Reasignación",0,0,0,0,0,0]
[null,null,null,null,null,"B4. Otros Convenios y Subsidios",171122,2060221.77,2231343.77,1955363.37,1955363.37,1784241.37,0]
[null,null,null,null,"C. Fondos Distintos de Aportaciones",null,31785867,2988802.09,34774669.090000004,27188294.48,27188294.48,-4597572.5199999996]
[null,null,null,null,null,"C1. Fondo para Entidades Federativas y Municipios Productores de Hidrocarburos",31785867,2988802.09,34774669.090000004,27188294.48,27188294.48,-4597572.5199999996]
[null,null,null,null,null,"C2. Fondo Minero",0,0,0,0,0,0]
[null,null,null,null,"D. Transferencias, Subsidios y Subvenciones, y Pensiones y Jubilaciones",null,0,0,0,0,0,0]
[null,null,null,null,"E. Otras Transferencias Federales Etiquetadas",null,0,0,0,0,0,0]
[null,null,null,"  II. Total de Transferencias Federales Etiquetadas",null,null,755712913,9915666.8599999994,765628579.86000001,603678353.70000005,603678353.70000005,-152034559.29999998]
[null,null,null,"  III. Ingresos Derivados de Financiamientos",null,null,0,0,0,0,0,0]
[null,null,null,null,"A. Ingresos Derivados de Financiamientos",null,0,0,0,0,0,0]
[null,null,null," IV. Total de Ingresos",null,null,2509248898.3999996,622164665.59000015,3131413563.9899998,2808134930.8999996,2808134930.8999996,298886032.50000024]
[null,null,null,null,"Datos Informativos",null,"","","",null,"",""]
[null,null,null,null,"1. Ingresos Derivados de Financiamientos con Fuente de Pago de Ingresos de Libre Disposición",null,0,0,0,0,0,0]
[null,null,null,null,"2. Ingresos Derivados de Financiamientos con Fuente de Pago de Transferencias Federales Etiquetadas",null,0,0,0,0,0,0]
[null,null,null,null,"3. Ingresos Derivados de Financiamientos (3 = 1 + 2)",null,0,0,0,0,0,0]
[null,null,null,"Bajo protesta de decir verdad declaramos que la información es razonablemente correcta y responsabilidad del emisor"]