U1A4 AlonsoA AnaLuisa
U1A4 AlonsoA AnaLuisa
ESCA Tepepan
s
Fase 1. Ejercicio práctico integrador: ingresos
Importante: Para el llenado de los archivos de Excel, toma en cuenta la información del documento Evaluación de ingresos
Notas importantes:
Revisar modificaciones actuales a la NIF B-3 y si es necesario modifica su presentación.
Esta cédula es la hoja de trabajo, para la revisión del área de resultados, observa los índices que aparecen en la columna A de cada una de las cuentas de resultados
Éstos te van a servir para integrar tus cédulas sumarias.
И И И И И И И И
V
И SUMAS Y/O RESTAS VERIFICADAS
NU'UKUL S.A. DE C.V. 10
AUDITORÍA AL 31 DE DICIEMBRE DE 20YY ELABORÓ
CÉDULA SUMARIA DE INGRESOS REVISÓ
И И И И И И И И
V
И SUMAS Y/O RESTAS VERIFICADAS
Esta es una cédula sumaria, completa los datos y cuida que las cifras finales crucen con los saldos de la PG
selecciona tus objetivos y procedimientos y colócalos a continuación:
OBJETIVOS: Comprobar la autenticidad de los ingresos y cuentas por cobrar, así como de los descuentos y devoluciones.
PROCEDIMIENTOS:
REVISIÓN ANALITICA:
Análisis de razones financieras tales como utilidad neta a ingresos, rotación de cuentas por cobrar, etc., para identificar
variaciones y tendencias, así como para juzgar la razonabilidad de éstas con base en el conocimiento general del
negocio y de su entorno.
Cerciorarse que exista remisión o nota de salida pre-numerada, la cual deberá contener los datos relativos al pedido y a
la remisión correspondiente y podrá ser utilizada para recabar la firma de recibido por parte del cliente de los productos
embarcados.
Verificación de la utilización y control de facturas de venta y notas de crédito pre-numeradas.
PRUEBAS SUSTANTIVAS: Inspección de la documentación que ampara las cuentas por cobrar con objeto de verificar su propiedad, o bien revisión de cobros posteriores.
x
PAGOS POSTERIORES
CONCLUSIONES
NU'UKUL S.A. DE C.V. 10
AUDITORÍA AL 31 DE DICIEMBRE DE 20YY ELABORÓ
CÉDULA ANALÍTICA DE INGRESOS REVISÓ M.E.G.
И И И И И
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
Factura cancelada d
d
d
d
d
NU'UKUL S.A. DE C.V. 10
AUDITORÍA AL 31 DE DICIEMBRE DE 20YY ELABORÓ
PRUEBA DE INGRESOS DEL MES DE JULIO 20YY REVISÓ
NO. DE
FECHA CLIENTE IMPORTE IVA TOTAL OBSERVACIONES
FACTURA
1105 2-Jul-20 ALUMETALES SA 160,380.00 25,661.00 186,041.00
1106 3-Jul-20 ALUMETALES SA 459,045.00 73,447.00 532,492.00
1107 4-Jul DISTRIBUIDORA MEXICANA 511,750.00 81,880.00 593,630.00
1108 5-Jul F.ERREXALOSTOC SA DE CV 499,700.00 79,952.00 579,652.00
1109 6-Jul cancelada - - -
1110 9-Jul GRUPO INTERNACIONAL DEL NORTE 335,860.00 53,738.00 389,598.00
1111 11-Jul CASA MARY SA DE CV 235,750.00 37,720.00 273,470.00
1112 8-Jul BRACE MEX S.A. 165,552.00 26,488.00 192,040.00
1113 13-Jul COMPAÑÍA ABASTECEDORA DEL NORTE 211,730.00 33,877.00 245,607.00
1114 14-Jul ABARROTERA DE JALISCO SA DE CV 226,444.00 36,231.00 262,675.00
1115 15-Jul ABARROTERA DE JALISCO SA DE CV 103,525.00 16,564.00 120,089.00
1116 16-Jul cancelada - - -
1117 21-Jul SUPER TOOLS SA DE CV 100,930.00 16,149.00 117,079.00
1118 22-Jul RECON sa de cv 146,680.00 23,469.00 170,149.00
1119 23-Jul DRAGOCO SA DE CV 130,770.00 20,923.00 151,693.00
1120 24-Jul DISTRIBUIDOR ELECTRICO SA 441,370.00 70,619.00 511,989.00
1121 25-Jul MERCANTIL DE SONORA SA DE CV 315,000.00 50,400.00 365,400.00
1122 25-Jul GRUPO INTERNACIONAL DEL NORTE 245,450.00 39,272.00 284,722.00
1123 28-Jul DISTRIBUIDORA MEXICANA 117,960.00 18,874.00 136,834.00
1124 28-Jul cancelada - - - Factura no cancelada en libros
1125 29-Jul ABARROTERA DE JALISCO SA DE CV 199,419.00 31,907.00 231,326.00
1126 30-Jul ALUMETALES SA 133,419.00 21,347.00 154,766.00
1127 31-Jul DAGOCO SA DE CV 111,125.00 17,780.00 128,905.00
1128 31-Jul REFACCIONES ELECTRIGAS CONDOX SA 237,335.00 37,974.00 275,309.00
5,089,194.00 814,272.00 5,903,466.00
И И И
saldo cedula de ingresos 5,283,994.00
Diferencia - 194,800.00
1124 28-Jul DISTRIBUIDORA MEXICANA 194,800.00 31,168.00 225,968.00 Factura no cancelada en libros
d
d
d
d
d
d
d
d
d
d
Actividad 4. Ejercicio ingresos
109,237,052.11 109,237,052.11
DE C.V.
CIÓN
SALDO A 20YY
CARGO ABONO
DEBE HABER
41,500.00
5,500.00
6,000.00
18,000.00
12,000.00
105,689,562.00 104,766,202.00 964,160.00
105,689,562.00 104,766,202.00 964,160.00
1,645,931.64 1,645,931.64
1,645,931.64 1,645,931.64
68,731,924.10 63,645,440.00 6,084,438.10
10,581,876.10 9,722,215.00 978,163.10
7,812,236.00 7,474,898.00 402,718.00
11,079,043.00 10,259,230.00 945,463.00
15,591,080.00 15,050,161.00 710,956.00
2,678,400.00 2,477,005.00 299,232.00
4,435,111.00 3,820,743.00 658,363.00
4,480,888.00 4,357,702.00 161,988.00
681,305.00 579,547.00 185,888.00
4,794,718.00 4,674,841.00 197,144.00
1,207,668.00 1,001,574.00 230,756.00
1,068,292.00 802,241.00 291,086.00
1,034,134.00 836,447.00 228,501.00
1,206,661.00 928,341.00 306,762.00
791,168.00 542,551.00 272,754.00
118,744.00 70,950.00 56,830.00
852,184.00 771,467.00 96,915.00
318,416.00 275,527.00 60,919.00
4,771,982.00 2,899,967.00 2,205,820.00
456,897.00 78,043.00 405,310.00
663,882.00 447,956.00 248,520.00
456,897.00 375,484.00 101,310.00
436,985.00 342,740.00 130,135.00
1,051,323.00 616,003.00 501,420.00
478,216.00 218,216.00 300,000.00
756,241.00 719,431.00 87,500.00
471,541.00 102,094.00 431,625.00
1,958,489.00 1,082,253.00 1,074,646.00
25,000.00 0.00 25,000.00
20,500.00 0.00 20,500.00
0.00 0.00 45,000.00
0.00 0.00 23,000.00
62,500.00 0.00 62,500.00
225,397.00 0.00 225,397.00
55,230.00 0.00 55,230.00
1,569,862.00 1,082,253.00 618,019.00
500,000.00 334,830.00 334,830.00
0.00 146,310.00 146,310.00
250,000.00 30,000.00 30,000.00
250,000.00 158,520.00 158,520.00
9,553,173.00 7,125,967.00 3,864,535.00
9,553,173.00 7,125,967.00 3,864,535.00
7,459,623.00 7,494,103.00 1,419,995.00
7,459,623.00 7,494,103.00 1,419,995.00
7,494,103.00 9,972,279.00 609,599.00
7,494,103.00 9,972,279.00 609,599.00
2,569,897.00 2,484,447.00 728,970.00
2,569,897.00 2,484,447.00 728,970.00
501,378.00 615,427.00 127,750.00
501,378.00 615,427.00 127,750.00
856,493.00 806,096.00 546,629.88
856,493.00 806,096.00 546,629.88
0.00 0.00 0.00
0.00 0.00 0.00
11,661.11 2,544.63
11,661.11 2,544.63
0.00 0.00 6,526,107.00
0.00 0.00 6,526,107.00
0.00 0.00 2,778,250.00
0.00 0.00 2,778,250.00
69,447.00 1,750,000.00 5,616,985.00
69,447.00 1,750,000.00 5,616,985.00
139,345.00 0.00 1,040,555.00
139,345.00 0.00 1,040,555.00
1,630,700.00 0.00 2,192,050.00
1,630,700.00 0.00 2,192,050.00
0.00 0.00 2,356,800.00
0.00 0.00 2,356,800.00
486,440.62 4,177,842.38
486,440.62 4,177,842.38
0.00 155,250.00
0.00 155,250.00
581,130.00 0.00 581,130.00
581,130.00 0.00 581,130.00
0.00 224,045.00
0.00 224,045.00
0.00 70,766.00
0.00 70,766.00
0.00 0.00
0.00 0.00
0.00 478,300.00
0.00 478,300.00
1,500,000.00 4,000,000.00 4,000,000.00
1,500,000.00 4,000,000.00 4,000,000.00
21,200,183.00 6,959,102.00 6,290,101.00
29,339.00 58,963.00 56,173.00
2,036,194.00 116,897.00 107,600.00
2,166,793.00 569,269.00 537,801.00
176,701.00 175,256.00 25,104.00
1,042,991.00 284,169.00 367,142.00
3,006,101.00 589,237.00 590,123.00
22,708.00 35,269.00 17,830.00
3,161,715.00 235,646.00 733,720.00
3,064,747.00 392,495.00 687,372.00
82,923.00 12,456.00 25,520.00
3,626,914.00 2,979,365.00 3,141,716.00
2,783,057.00 1,510,080.00 0.00
1,055,759.40 1,444,435.40 813,685.00
125,356.00 132,417.00 59,426.00
113,599.00 206,698.08 115,668.08
198,387.40 250,000.00 65,259.85
72,884.00 56,987.00 30,000.00
143,742.00 159,639.00 59,295.00
95,494.00 106,897.00 60,000.00
151,142.57 75,426.00 56,491.44
37,122.00 35,897.00 15,000.00
79,576.43 67,915.32 2,544.63
38,456.00 352,559.00 350,000.00
19,307,877.51 22,134,797.89 4,964,012.38
5,166,094.00 5,277,792.00 610,457.00
47,127.00 45,000.00 1,570.00
204,484.00 198,567.00 10,070.00
33,069.00 30,000.00 6,500.00
22,778.00 22,400.00 2,517.00
5,216,943.21 7,617,264.59 3,168,384.38
1,115,897.00 1,118,195.00 95,108.00
2,303,536.00 2,353,221.00 239,344.00
4,420,318.00 4,789,562.00 759,000.00
777,631.30 682,796.30 71,062.00
4,206,434.00 3,592,116.00 276,357.00
4,206,434.00 3,592,116.00 276,357.00
347,185.00 2,298,846.84 2,298,846.84
347,185.00 2,298,846.84 2,298,846.84
242,453.00 127,970.00 316,807.00
242,453.00 127,970.00 316,807.00
447,300.00 0.00 300,000.00
447,300.00 0.00 300,000.00
0.00 138,900.00 984,711.50
0.00 138,900.00 984,711.50
1,225,000.00 421,520.00 2,000,813.35
1,225,000.00 421,520.00 2,000,813.35
0.00 43,045.00 609,256.56
0.00 43,045.00 609,256.56
0.00 614,140.00 1,344,140.00
0.00 614,140.00 1,344,140.00
0.00 209,460.00 266,460.00
0.00 209,460.00 266,460.00
204,305.06 0.00 615,426.94
204,305.06 0.00 615,426.94
0.00 22,404.00 112,004.00
0.00 22,404.00 112,004.00
0.00 15,906.00 15,906.00
0.00 15,906.00 15,906.00
0.00 0.00 24,768.00
0.00 0.00 24,768.00
23,287.50 31,050.00
23,287.50 31,050.00
35,988.00 165,820.00 474,497.00
35,988.00 165,820.00 474,497.00
0.00 4,000,000.00 14,000,000.00
4,000,000.00 14,000,000.00
0.00 13,317,296.00
0.00 13,317,296.00
112,324.00 204,758.40
112,324.00 204,758.40
4,828,969.87 6,018,663.03
4,828,969.87 6,018,663.03
0.00 -88,284.00
0.00 -88,284.00
0.00 27,310,094.72 0.00
27,310,094.72 0.00
0.00 254,389.00
0.00 254,389.00
50,502,237.64 72,254,105.61 72,254,105.61
50,502,237.64 72,254,105.61 72,254,105.61
962,615.00 762,615.00 962,615.00
962,615.00 762,615.00 962,615.00
673,796.00 473,796.00 673,796.00
673,796.00 473,796.00 673,796.00
0.00 882,826.00 0.00
882,826.00 0.00
9,610,414.00 8,965,638.00 9,610,414.00
9,610,414.00 8,965,638.00 9,610,414.00
14,241,101.32 7,501,488.12 14,241,101.32
4,582,260.28 3,916,141.00 4,582,260.28
390,226.00 210,914.00 390,226.00
31,973.00 12,180.00 31,973.00
51,932.00 18,760.00 51,932.00
120,000.00 85,690.00 120,000.00
1,567,671.90 652,516.00 1,567,671.90
464,381.66 450,731.00 464,381.66
100,549.00 86,852.00 100,549.00
125,020.00 112,519.13 125,020.00
58,078.00 35,478.00 58,078.00
422,953.00 219,260.00 422,953.00
270,321.33 210,725.00 270,321.33
302,825.69 272,524.00 302,825.69
32,569.00 29,372.00 32,569.00
9,589.00 10,121.00 9,589.00
7,592.00 61,137.00 7,592.00
25,890.00 29,148.00 25,890.00
32,569.00 41,026.00 32,569.00
56,378.00 46,120.00 56,378.00
4,601,419.70 125,345.00 4,601,419.70
107,412.00 62,569.00 107,412.00
62,989.73 35,896.00 62,989.73
184,642.42 189,569.00 184,642.42
210,338.61 188,359.00 210,338.61
421,520.00 398,535.99 421,520.00
7,775,402.16 3,856,180.00 7,775,402.16
7,775,402.16 3,856,180.00 7,775,402.16
17,156,858.78 13,857,614.82 17,156,858.78
10,619,751.39 9,508,106.00 10,619,751.39
840,416.00 701,174.00 840,416.00
65,412.00 40,134.00 65,412.00
2,086,866.08 862,508.00 2,086,866.08
642,672.00 586,428.00 642,672.00
129,337.00 101,142.00 129,337.00
13,880.00 17,739.91 13,880.00
2,800.00 41,184.00 2,800.00
55,208.86 48,130.00 55,208.86
76,543.00 61,641.00 76,543.00
123,456.00 113,362.00 123,456.00
45,890.00 31,920.00 45,890.00
450,000.00 90,000.00 450,000.00
80,000.00 60,000.00 80,000.00
258,765.00 159,617.00 258,765.00
1,000.00 8,000.00 1,000.00
197,028.50 60,654.50 197,028.50
76,278.00 50,125.00 76,278.00
0.00 15,816.00 0.00
850.00 20,016.00 850.00
102,245.00 4,120.00 102,245.00
0.00 4,810.00 0.00
22,404.00 11,202.25 22,404.00
31,000.00 52,849.00 31,000.00
255,126.42 246,489.00 255,126.42
229,368.03 245,689.00 229,368.03
34,436.00 71,916.56 34,436.00
630,000.00 617,044.00 630,000.00
62,838.00 20,208.60 62,838.00
23,287.50 5,589.00 23,287.50
9,484,292.66 7,895,866.83 9,484,292.66
5,169,225.83 4,345,372.00 5,169,225.83
210,620.00 100,175.00 210,620.00
28,136.00 20,420.00 28,136.00
1,659,397.33 1,390,519.04 1,659,397.33
328,873.34 220,130.00 328,873.34
53,790.00 31,020.00 53,790.00
146,622.00 60,194.40 146,622.00
15,906.00 0.00 15,906.00
128,900.00 81,147.00 128,900.00
150,000.00 38,111.00 150,000.00
65,435.00 70,169.00 65,435.00
186,000.00 143,320.00 186,000.00
115,689.00 747,300.00 115,689.00
112,345.00 81,369.00 112,345.00
127,970.00 37,120.00 127,970.00
170,878.00 85,960.00 170,878.00
300,000.00 0.00 300,000.00
181,148.00 101,126.00 181,148.00
33,164.00 27,135.00 33,164.00
130,993.16 84,596.00 130,993.16
29,240.00 0.00 29,240.00
10,364.00 41,140.00 10,364.00
8,609.00 13,698.39 8,609.00
120,987.00 175,845.00 120,987.00
640,660.00 1,491,368.00 640,660.00
559,596.00 1,477,273.00 559,596.00
1,424.00 3,526.00 1,424.00
67,978.89 4,771.62 67,978.89
11,661.11 5,797.38 11,661.11
147,541.00 0.00 147,541.00
147,541.00 147,541.00
78,130.00 8,069,266.50 8,069,266.50
31,170.00 3,456,796.68 3,456,796.68
46,960.00 4,612,469.82 4,612,469.82
25,689.00 34,071.00 34,071.00
25,689.00 34,071.00 34,071.00
0.00 17,700.00 17,700.00
0.00 17,700.00 17,700.00
4,339,416.00 890,675.00 4,339,416.00
4,339,416.00 890,675.00 4,339,416.00
65,890.00 0.00 0.00
65,890.00 0.00
2,298,846.84 347,185.00 2,298,846.84
2,298,846.84 347,185.00 2,298,846.84
Funcionarios clave:
Compras Estela Cruz Miranda
Contador de Costos C.P. Héctor Guerra Ruíz
Contador de Finanzas C.P. José Guadalupe Ramírez
Contralora C.P. Silvia Elena Montoya De Lira
Director de Comercialización Lic. Admón. Guadalupe Arias
Director de Finanzas Lic. en Fin. Jorge Luis García Gutiérrez
Director de Producción Ing. Salomón Huerta
Directora de Administración C.P. Aida Sandoval Requena
Gerente de Crédito y Cobranzas Lic. en Admón. José Luis Campos Cortés
Control interno
NU’UKUL S.A de C.V. tiene manual de políticas, métodos y procedimientos para
efectuar sus operaciones.
Políticas contables significativas
Libros de registro de la contabilidad: libros de diario y libros de mayor que codifica por
medio de un sistema
Actividades computarizado Aspel
de producción:
Consejo de Administración
Dir. de Administración
Aída Sandoval
Administrador de Efectivo
Planeación Financiera
Impuestos
al Humano
Diseño
Montoya
Compras
za
Contabilidad
Financiera
Contabilidad
de Costos
MARCAS ESTÁNDAR