Revision contable
35
Click here to load reader
-
Upload
celso-amor -
Category
Business
-
view
2.132 -
download
1
description
importar Diario en excel a Contaplus y/o Keme. Revisión del Diario contable
Transcript of Revision contable
![Page 1: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/1.jpg)
![Page 2: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/2.jpg)
![Page 3: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/3.jpg)
www.a2click.es
![Page 4: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/4.jpg)
![Page 5: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/5.jpg)
![Page 6: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/6.jpg)
![Page 7: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/7.jpg)
![Page 8: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/8.jpg)
![Page 9: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/9.jpg)
![Page 10: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/10.jpg)
![Page 11: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/11.jpg)
![Page 12: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/12.jpg)
![Page 13: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/13.jpg)
![Page 14: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/14.jpg)
![Page 15: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/15.jpg)
Con la función sumatorio detectamos el descuadre del Diario
![Page 16: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/16.jpg)
Añadimos tres columnas, y mediante una función lógica calculamos:debe del asiento, acumulando las cantidades del debe para cada asientohaber del asiento, acumulando las cantidades del haber para cada asientodescuadre asiento, restando debe asto – haber asto, en la última línea correspondiente al asiento
![Page 17: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/17.jpg)
![Page 18: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/18.jpg)
![Page 19: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/19.jpg)
![Page 20: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/20.jpg)
![Page 21: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/21.jpg)
![Page 22: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/22.jpg)
![Page 23: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/23.jpg)
![Page 24: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/24.jpg)
![Page 25: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/25.jpg)
![Page 26: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/26.jpg)
![Page 27: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/27.jpg)
![Page 28: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/28.jpg)
![Page 29: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/29.jpg)
![Page 30: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/30.jpg)
![Page 31: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/31.jpg)
![Page 32: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/32.jpg)
![Page 33: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/33.jpg)
Abriendo la base de datos de Keme, podemos ver otros campos de la tabla de Diario, por si es necesaria su incorporación.
![Page 34: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/34.jpg)
Diario importado a Keme:
![Page 35: Revision contable](https://reader037.fdocuments.mx/reader037/viewer/2022100300/559c369e1a28ab982e8b460c/html5/thumbnails/35.jpg)