{"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":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":"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":12,"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,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 31 de marzo de 2024"]
[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,444097443.87,47457317.310000002,491554761.18000001,225205493,225205493,-218891950.87]
[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,177054066.06,21000000,198054066.06,66731403,66731403,-110322663.06]
[null,null,null,null,"E. Productos",null,53374690.280000001,16504145.039999999,69878835.319999993,16340140.370000001,16340140.370000001,-37034549.909999996]
[null,null,null,null,"F. Aprovechamientos",null,58537744.230000004,273381282.27999997,331919026.50999999,285862974.24000001,285862974.24000001,227325230.00999999]
[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,1313842887,313050244.64999998,1626893131.6500001,602790549.43999994,602790549.43999994,-711052337.55999982]
[null,null,null,null,null,"H1. Fondo General de Participaciones",699603129.28999996,0,699603129.28999996,191675829.40000001,191675829.40000001,-507927299.88999999]
[null,null,null,null,null,"H2. Fondo de Fomento Municipal",200000000,0,200000000,59930365.359999999,59930365.359999999,-140069634.63999999]
[null,null,null,null,null,"H3. Fondo de Fiscalización y Recaudación",30000000,0,30000000,7489273.5899999999,7489273.5899999999,-22510726.41]
[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",5000000,0,5000000,724003.6,724003.6,-4275996.4000000004]
[null,null,null,null,null,"H6. Impuesto Especial Sobre Producción y Servicios",15000000,0,15000000,3502781.61,3502781.61,-11497218.390000001]
[null,null,null,null,null,"H7. 0.136% de la Recaudación Federal Participable",250000000,100000000,350000000,76969144,76969144,-173030856]
[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",12004082.32,0,12004082.32,2846283.15,2846283.15,-9157799.1699999999]
[null,null,null,null,null,"H10. Fondo del Impuesto Sobre la Renta",102235675.39,0,102235675.39,46602624.079999998,46602624.079999998,-55633051.310000002]
[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",1313842887,100000000,1413842887,389740304.78999996,389740304.78999996,-924102582.2099998]
[null,null,null,null,null,"H.B Devolucion de Participaciones Retenidas",0,213050244.65000001,213050244.65000001,213050244.65000001,213050244.65000001,213050244.65000001]
[null,null,null,null,"I. Incentivos Derivados de la Colaboración Fiscal",null,12000000,0,12000000,2734671.72,2734671.72,-9265328.2799999993]
[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",2000000,0,2000000,382085.31,382085.31,-1617914.69]
[null,null,null,null,null,"I3. Impuesto Sobre Automóviles Nuevos",10000000,0,10000000,2352586.41,2352586.41,-7647413.5899999999]
[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,1531232.1099999999,0,1531232.1099999999,241045.45,241045.45,-1290186.6599999999]
[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",1531232.1099999999,0,1531232.1099999999,241045.45,241045.45,-1290186.6599999999]
[null,null,null,"  I.Total de Ingresos de Libre Disposición",null,null,2060438063.55,671392989.27999997,2731831052.8299999,1199906277.2199998,1199906277.2199998,-860531786.32999992]
[null,null,null,"  Ingresos Excedentes de Ingresos de Libre Disposición",null,null,null,null,null,null,null,0]
[null,null,null,"  Transferencias Federales Etiquetadas"]
[null,null,null,null,"A. Aportaciones",null,741210898,1412691.0000000298,742623589,195469374,195469374,-545741524]
[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",189493796.22,6775776.7800000012,196269573,58880871,58880871,-130612925.22]
[null,null,null,null,null,"A4. Fondo de Aportaciones para el Fortalecimiento de los Municipios y de las Demarcaciones Territoriales del Distrito Federal",551717101.77999997,-5363085.7799999714,546354016,136588503,136588503,-415128598.77999997]
[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,387521,965501.16,1353022.1600000001,1053667.9100000001,1053667.9100000001,666146.91000000015]
[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",387521,965501.16,1353022.1600000001,1053667.9100000001,1053667.9100000001,666146.91000000015]
[null,null,null,null,"C. Fondos Distintos de Aportaciones",null,33535647,40442,33576089,7048265.3700000001,7048265.3700000001,-26487381.629999999]
[null,null,null,null,null,"C1. Fondo para Entidades Federativas y Municipios Productores de Hidrocarburos",33535647,40442,33576089,7048265.3700000001,7048265.3700000001,-26487381.629999999]
[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,775134066,2418634.16000003,777552700.15999997,203571307.28,203571307.28,-571562758.72000003]
[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,2835572129.5500002,673811623.44000006,3509383752.9899998,1403477584.4999998,1403477584.4999998,-1432094545.05]
[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"]