Estados Financieros

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 14

Indicador

Cuenta
Actividades de operación
a - Utilidad antes de impuestos a la utilidad
b - Depreciación y Amortización
c - Costo neto del periodo por obligaciones laborales
d - SUBTOTAL
e - Partidas relacionadas con actividades de inversión y financiamiento
f - Aumento / (Disminución) en cuentas por cobrar y otras cuentas por cobrar
g - Aumento/(Disminución) en impuestos por recuperar
h - Aumento / (Disminución) en inventarios
i - Aumento / (Disminución) en proveedores
j - Aumento / (Disminución) en cuentas por pagar y pasivos acumulados
l - Aumento / (Disminución) en otros activos
k - Impuestos pagados
m - Flujos netos de efectivo de actividades de operación
Actividades de inversión
n - Inmuebles Adaptación de Inmuebles Mobiliario y Equipo
Inversión en activos intangibles
ñ - Flujos netos de efectivo de actividades de inversión
Actividades de Financiamiento
Préstamos bancarios obtenidos
Préstamos obtenidos (pagados)
r - Dividendos Pagados
o - Intereses pagados
Intereses a cargo
s - Flujos netos de efectivo de actividades de financiamiento
t - Aumento / (Disminución) neto de efectivo y demás equivalentes de efectivo
u - Efectivo y equivalentes de efectivo al principio del periodo
v - Efectivo y equivalentes de efectivo al final del período
Flujo de Efectivo
Presupuesto Calculo Diferencia


18,496,729,040 18,496,729,040.18 0
19373256 19,373,256.00 0
0 0
19,373,256 19,373,256.00 0
18,516,102,296 18,516,102,296.18 0
(2,081,033.00) -2,081,033 0
- 0 0
138,580,400,536 138,580,400,536 0
0 0 0 * Revisar en PPTO_UAT con datos
121,681,694.43 121,681,694 0
(349,079,574.98) -349,079,575 0
(1,539,875,371.42) -1,539,875,372.00 -1
155,327,148,547 155,327,148,546.18 -1

-54389042 54,389,042
-14123952 14,123,952
-68512994 68,512,994
– #VALUE!
– #VALUE!
– #VALUE!
– #VALUE!
-3820760.4 3,820,760
3820760.4 -3,820,760
0 0
149,135,336,782 -149,135,336,782
1,563,120,127 -1,563,120,127
150,698,456,910 -150,698,456,910
150,698,456,910 -150,698,456,910
TO_UAT con datos
Version TEST_EEFF TEST_EEFF TEST_EEFF
Indicador Valor Valor Valor
Tiempo Jan (2024) Feb (2024) Mar (2024)
Cuenta
2SPF44 Ventas Netas 2,032,935,735.16 1,908,077,994.69 2,042,687,448.14
2SPF45 Costo de Ventas 23,132,004.69 35,867,088.32 38,280,526.48
2SPF33 Utilidad Bruta 2,009,803,730.47 1,872,210,906.37 2,004,406,921.66
2SPF46 Gastos de Operación 447,969,952.57 427,074,223.78 476,067,962.30
2SPF38 Depreciación y Amortización 1,614,438.00 1,614,438.00 1,614,438.00
2SPF50 Otros Ingresos - Neto -69,842.43 30,000.00 -77,076.82
2SPF30 Total Gastos 449,654,233.00 428,658,661.78 477,759,477.12
2SPF52 Intereses a cargo - Neto 347,256.29 343,797.99 340,187.28
2SPF51 Costo Integral de Fi 347,256.29 343,797.99 340,187.28
2SPF27 Utilidad Operativa 1,559,802,241.18 1,443,208,446.60 1,526,307,257.26
2SPF26 Utilidad antes de Im 1,559,802,241.18 1,443,208,446.60 1,526,307,257.26
7500001000 Prov ISR Corriente 513,798,858.25 475,392,862.31 502,765,610.54
7500002000 Prov ISR Diferido -140,382,201.71 -129,888,760.19 -137,367,653.15
2SPF57 Impuestos a la Utili 373,416,656.54 345,504,102.12 365,397,957.39
2SPF43 Utilidad Neta 1,186,385,584.64 1,097,704,344.48 1,160,909,299.87
TEST_EEFF TEST_EEFF TEST_EEFF TEST_EEFF TEST_EEFF
Valor Valor Valor Valor Valor
Apr (2024) May (2024) Jun (2024) Jul (2024) Aug (2024)

1,947,105,159.62 2,066,671,674.89 2,000,561,854.77 2,010,168,746.01 1,991,817,345.13


33,279,448.95 33,776,655.66 32,577,023.58 33,262,354.17 33,462,579.90
1,913,825,710.68 2,032,895,019.23 1,967,984,831.19 1,976,906,391.85 1,958,354,765.23
428,989,705.56 474,111,917.03 430,529,380.96 439,322,002.32 466,564,825.33
1,614,438.00 1,614,438.00 1,614,438.00 1,614,438.00 1,614,438.00
30,000.00 30,000.00 30,000.00 -77,076.82 30,000.00
430,574,143.56 475,696,355.03 432,113,818.96 441,013,517.14 468,149,263.33
336,599.98 332,937.08 329,614.97 326,495.83 323,976.21
336,599.98 332,937.08 329,614.97 326,495.83 323,976.21
1,482,914,967.13 1,556,865,727.12 1,535,541,397.26 1,535,566,378.88 1,489,881,525.69
1,482,914,967.13 1,556,865,727.12 1,535,541,397.26 1,535,566,378.88 1,489,881,525.69
488,472,190.17 512,831,570.51 505,807,336.26 505,815,565.20 490,766,974.56
-133,462,347.04 -140,117,915.44 -138,198,725.75 -138,200,974.10 -134,089,337.31
355,009,843.13 372,713,655.07 367,608,610.50 367,614,591.10 356,677,637.25
1,127,905,124.00 1,184,152,072.05 1,167,932,786.76 1,167,951,787.77 1,133,203,888.44
TEST_EEFF TEST_EEFF TEST_EEFF TEST_EEFF TEST_EEFF
Valor Valor Valor Valor Valor
Sep (2024) Oct (2024) Nov (2024) Dec (2024) Totals

1,960,042,217.75 2,033,367,029.12 2,107,204,069.22 2,263,167,799.55 24,363,807,074.05


31,909,826.24 37,139,780.40 37,910,547.65 41,113,808.08 411,711,644.10
1,928,132,391.51 1,996,227,248.72 2,069,293,521.58 2,222,053,991.47 23,952,095,429.95
437,020,016.68 442,339,024.95 487,716,756.09 474,512,609.74 5,432,218,377.31
1,614,438.00 1,614,438.00 1,614,438.00 1,614,438.00 19,373,256.00
30,000.00 30,000.00 30,000.00 30,000.00 46,003.94
438,604,454.68 443,923,462.95 489,301,194.09 476,097,047.74 5,451,545,629.37
320,873.39 318,420.97 250,243.20 250,357.20 3,820,760.40
320,873.39 318,420.97 250,243.20 250,357.20 3,820,760.40
1,489,207,063.44 1,551,985,364.80 1,579,742,084.29 1,745,706,586.53 18,496,729,040.18
1,489,207,063.44 1,551,985,364.80 1,579,742,084.29 1,745,706,586.53 18,496,729,040.18
490,544,806.70 511,223,979.17 520,367,042.56 575,035,749.60 6,092,822,545.84
-134,028,635.71 -139,678,682.83 -142,176,787.59 -157,113,592.79 -1,664,705,613.62
356,516,170.99 371,545,296.33 378,190,254.98 417,922,156.81 4,428,116,932.22
1,132,690,892.45 1,180,440,068.47 1,201,551,829.31 1,327,784,429.71 14,068,612,107.96
Version Actual Actual Actual Actual
Tiempo Oct (2 Oct (2023) Oct (2023) Oct (2023)
Auditoria Saldo IAjuste Manual Modelos Totals
Cuenta
2SPF15 Efectivo y Equivalen -25,000 1,563,145,127 1,563,120,127
2SPF16 Clientes 11,566,869 11,566,869
1113001000 CxC Intercompañías 833,623 833,623
2SPF18 Partes Relacionadas 833,623 833,623
2SPF29 Impuestos por recupe -140,280,435 -140,280,435
2SPF28 Inventarios 499,515 35,902,811,126 35,903,310,641
2SPF17 Otras Cuentas por Co 37,443,389 37,443,389
2SPF8 Activo Circulante 474,515 37,375,519,699 37,375,994,214
1120000100 Terrenos 286,976 286,976
1120000200 Edificio 2,211,544 2,211,544
2SPF19 Inmuebles 2,498,520 2,498,520
2SPF31 Adap. a Inmuebles, M 60,299,121 60,299,121
1122000100 Activos intangibles 11,440,919 11,440,919
1122000200 Activos inta en Proc 79,460,324 79,460,324
1123000100 Amort. Activos intan -7,841,824 -7,841,824
2SPF32 Activos Intangibles 83,059,419 83,059,419
1120000800 D-5 Derechos de Uso -1,931,479,498 -1,931,479,498
1120000900 D-5Derecho de Uso In -236,357,223 -236,357,223
1121000800 D-5Amort.Derecho Uso -567,630,102 -567,630,102
1121000900 D-5Amort.Derecho Int -85,009,148 -85,009,148
2SPF59 Arrendamientos -2,820,475,970 -2,820,475,970
1130000100 Seguros y Fianzas 19,201,263 19,201,263
1130000101 GMM -5,640,570 -5,640,570
1130000200 Pagos Anticipados 18,272,656 18,272,656
1130000300 Depósitos en garantí 1,546,001 1,546,001
1130000400 Rentas Pag por antic 8,170,386 8,170,386
1130000500 Publicidad pagada an 69,833,088 69,833,088
1130000600 Ints arrendamiento f 1,421,983 1,421,983
1130000910 Cta. val. Pag Ant -65,499 -65,499
1133000100 PTU Diferida -59,983,219 -59,983,219
2SPF20 Otros Activos 52,756,088 52,756,088
1132000100 ISR Diferido -183,610,529 -183,610,529
2SPF22 Impuesto Sobre la Re -183,610,529 -183,610,529
2SPF9 Activo No Circulante -2,805,473,351 -2,805,473,351
2SPF7 Activo Total 474,515 34,570,046,348 34,570,520,863
2SPF41 Prestamos Bancarios 0 0
2SPF34 Proveedores 553,309,712 553,309,712
2SPF35 Partes Relacionadas 76,806,221 76,806,221
2SPF36 Cuentas por pagar y 30,603,231,968 30,603,231,968
2SPF40 PTU por pagar 134,420,104 134,420,104
2SPF11 Pasivo a Corto Plazo 31,367,768,004 31,367,768,004
2SPF23 Arrendamiento Financ -48,987,119 -48,987,119
2SPF58 Pasivos por Arrendam 95,251,243 95,251,243
2SPF42 Beneficios a los Emp 85,734,270 85,734,270
2SPF12 Pasivo a Largo Plazo 131,998,394 131,998,394
2SPF13 Pasivo 31,499,766,398 31,499,766,398
3000000000 Capital Social Fijo 1,430,000 1,430,000
3000001000 Capital Social Varia 19,264,664 19,264,664
3000002000 Act. Capital Social 21,283,037 21,283,037
2SPF24 Capital Social 41,977,701 41,977,701
3100000000 Reserva Legal 4,138,934 4,138,934
3200000000 Resultado Ejerc Ant 3,270,589,112 3,270,589,112
3200001000 Act. Resulta Ej. Ant 1,898,313 1,898,313
3300000000 Resultado por Fusión 2,449,814 2,449,814
3500000000 Resultado del Ejerci -83,440,405 -83,440,405
2SPF25 Utilidades Acumulada 3,195,635,768 3,195,635,768
2SPF14 Capital Contable 3,237,613,469 3,237,613,469
2SPF27 Utilidad Operativa -19,137,793 -19,137,793
2SPF26 Utilidad antes de Im -19,137,793 -19,137,793
7500001000 Prov ISR Corriente 0 0
7500002000 Prov ISR Diferido 0 0
2SPF57 Impuestos a la Utili 0 0
2SPF43 Utilidad Neta -19,137,793 -19,137,793
2SPF6 Pasivo y Capital 34,718,242,074 34,718,242,074
2SPF Estructura de balanc 474,515 -148,195,726 -147,721,211
TEST_EEFF TEST_EEFF TEST_EEFF TEST_EEFF TEST_EEFF
Jan (2024) Jan (2024) Jan (2024) Jan (2024) Dec (2024)
Saldo Inicial Ajuste Manual Modelos Totals Saldo Inicial

1,563,120,127 1,563,120,127 1,562,208,907


11,566,869 125,863 11,692,732 13,647,902
833,623 833,623 833,623
833,623 833,623 833,623
-140,280,435 -140,280,435 -140,280,435
-138,609,414,958 138,609,414,958 108,772,578 108,772,578 -138,609,414,958
37,443,389 37,443,389 37,443,389
-137,136,731,386 138,609,540,821 108,772,578 1,581,582,014 -137,135,561,573
286,976 286,976 286,976
2,211,544 2,211,544 2,211,544
2,498,520 2,498,520 2,498,520
60,299,121 125,362 10,362,112 70,786,595 95,595,199
11,440,919 11,440,919 11,440,919
79,460,324 79,460,324 79,460,324
-7,841,824 -462,678 -8,304,502 -12,931,282
83,059,419 -462,678 82,596,741 77,969,961
-1,931,479,498 -1,931,479,498 -1,931,479,498
-236,357,223 -236,357,223 -236,357,223
-567,630,102 -567,630,102 -567,630,102
-85,009,148 -85,009,148 -85,009,148
-2,820,475,970 -2,820,475,970 -2,820,475,970
19,201,263 19,201,263 19,201,263
-5,640,570 -5,640,570 -5,640,570
18,272,656 18,272,656 18,272,656
1,546,001 573,754 2,119,755 7,857,295
8,170,386 8,170,386 8,170,386
69,833,088 69,833,088 69,833,088
1,421,983 1,421,983 1,421,983
-65,499 -65,499 -65,499
-59,983,219 -59,983,219 282,211,308
52,756,088 573,754 53,329,842 401,261,909
-183,610,529 -183,610,529 1,356,264,843
-183,610,529 -183,610,529 1,356,264,843
-2,805,473,351 125,362 10,473,188 -2,794,874,801 -886,885,539
-139,942,204,737 138,609,666,183 119,245,766 -1,213,292,787 -138,022,447,111
0 0 0
553,309,712 553,309,712 553,309,712
76,806,221 76,806,221 76,806,221
30,603,231,968 -144,278,402 30,458,953,565 29,063,356,596
134,420,104 150,832,877 285,252,981 1,788,930,642
31,367,768,004 6,554,474 31,374,322,479 31,482,403,171
-48,987,119 -48,987,119 -48,987,119
95,251,243 95,251,243 95,251,243
85,734,270 85,734,270 85,734,270
131,998,394 131,998,394 131,998,394
31,499,766,398 6,554,474 31,506,320,873 31,614,401,565
1,430,000 1,430,000 1,430,000
19,264,664 19,264,664 19,264,664
21,283,037 21,283,037 21,283,037
41,977,701 41,977,701 41,977,701
4,138,934 4,138,934 4,138,934
3,270,589,112 3,270,589,112 3,270,589,112
1,898,313 1,898,313 1,898,313
2,449,814 2,449,814 2,449,814
-83,440,405 -83,440,405 -83,440,405
3,195,635,768 3,195,635,768 3,195,635,768
3,237,613,469 3,237,613,469 3,237,613,469
-19,137,793 1,559,802,241 1,540,664,448 17,083,994,839
-19,137,793 1,559,802,241 1,540,664,448 17,083,994,839
0 513,798,858 513,798,858 5,635,943,859
0 -140,382,202 -140,382,202 -1,539,875,371
0 373,416,657 373,416,657 4,096,068,488
-19,137,793 1,186,385,585 1,167,247,791 12,987,926,351
34,718,242,074 1,192,940,059 35,911,182,133 47,839,941,385
-174,660,446,810 138,609,666,183 -1,073,694,293 -37,124,474,920 -185,862,388,496
TEST_EEFF TEST_EEFF TEST_EEFF
Dec (2024) Dec (2024) Dec (2024)
Ajuste Manual Modelos Totals Variacion

1,562,208,907 -911,220
13,647,902 2,081,033
833,623 0
833,623 0
-140,280,435 0
137,787,000 -138,471,627,958 -138,580,400,536
37,443,389 0
137,787,000 -136,997,774,572 138,956,814
286,976 0
2,211,544 0
2,498,520 0
-557,888 95,037,311 34,738,190
11,440,919 0
79,460,324 0
-462,678 -13,393,960 -5,552,136
-462,678 77,507,283 -5,552,136
-1,931,479,498 0
-236,357,223 0
-567,630,102 0
-85,009,148 0
-2,820,475,970 0
19,201,263 0
-5,640,570 0
18,272,656 0
573,754 8,431,049 6,885,048
8,170,386 0
69,833,088 0
1,421,983 0
-65,499 0
282,211,308 342,194,527
573,754 401,835,663 349,079,575
1,356,264,843 1,539,875,372
1,356,264,843 1,539,875,372
-446,812 -887,332,351 1,918,141,000
137,340,188 -137,885,106,923 2,057,097,814
0 0
553,309,712 0
76,806,221 0
-161,763,299 28,901,593,297 -1,701,638,671
168,809,827 1,957,740,469 1,823,320,365
7,046,528 31,489,449,699 121,681,695
-48,987,119 0
95,251,243 0
85,734,270 0
131,998,394 0
7,046,528 31,621,448,093 121,681,695
1,430,000 0
19,264,664 0
21,283,037 0
41,977,701 0
4,138,934 0
3,270,589,112 0
1,898,313 0
2,449,814 0
-83,440,405 0
3,195,635,768 0
3,237,613,469 0
1,745,706,587 18,829,701,426 18,848,839,219
1,745,706,587 18,829,701,426 18,848,839,219
575,035,750 6,210,979,609 6,210,979,609
-157,113,593 -1,696,988,964 -1,696,988,964
417,922,157 4,513,990,645 4,513,990,645
1,327,784,430 14,315,710,781 14,334,848,574
1,334,830,958 49,174,772,342 14,456,530,268
-1,197,490,769 -187,059,879,265 -12,399,432,455
Technical Information
Model name /t.E.Cgc0cd0hg8ga94qmnr0sk64j39/Cgc0cd0hg8ga94qmnr0sk64j39_qs
Tenant URI https://b2bfsanpablo-q.us20.hcs.cloud.sap/sap/fpa/ui/
Story URI https://b2bfsanpablo-q.us20.hcs.cloud.sap/sap/fpa/ui/app.html#/story&/s/B
Created by EGONZALEZ
Created on Thu Jun 06 2024 16:57:15 GMT-0300 (hora estándar de Argentina)

Page Filters
Dimension Value
Sociedad 0020 (Pharma)

Widget Filters
Dimension Value
Cuenta (Missing) (Estructura de balanc)
Moneda MXN (Peso Mexicano)
CEBE SPF1SPF1 (San Pablo Farmacias), # (SPF1/Sin asignar), CEBE_NA (No Aplica)
CECO SPF1SPF1 (Jerarquía Std San Pa), CECO_NA (Centro de Costos No Aplica), # (S
Division DIV_NA (División No Aplica), # (Unassigned), DV_TOTAL (Total División)
Auditoria AUDIT_EEFF (Modelos), AUDIT_AJM (Ajuste Manual), AUDIT_SI (Saldo Inicial)
Canal CANAL_NA (No Aplica), # (Sin asignar), TOTAL_CANALES (Total de Canales)
Indicador Valor
Version Actual, TEST_EEFF
Concepto P_EEFF (Total EEFF), # (Unassigned), PC_NA (Concepto No Aplica)
Tiempo Oct (2023), 2024
mnr0sk64j39_qs

/app.html#/story&/s/BA3468859A8556507E8779A2DAB06BC9

e Argentina)

CEBE_NA (No Aplica)


Costos No Aplica), # (SPF1/Sin asignar)
L (Total División)
AUDIT_SI (Saldo Inicial)
S (Total de Canales)

No Aplica)

También podría gustarte