{"id":1556,"date":"2024-12-11T10:50:02","date_gmt":"2024-12-11T15:50:02","guid":{"rendered":"http:\/\/www.perucontable.com\/excelcontable\/?p=1556"},"modified":"2024-12-20T11:27:18","modified_gmt":"2024-12-20T16:27:18","slug":"aplicativo-macro-cierre-contable-automatico-gratis","status":"publish","type":"post","link":"https:\/\/www.perucontable.com\/excelcontable\/aplicativo-macro-cierre-contable-automatico-gratis\/","title":{"rendered":"APLICATIVO MACRO: CIERRE CONTABLE AUTOM\u00c1TICO (GRATIS)"},"content":{"rendered":"El cierre contable es un proceso fundamental en la contabilidad, especialmente al finalizar un ejercicio. Generalmente, los sistemas contables realizan autom\u00e1ticamente este cierre. En este caso, PERUCONTABLE presenta una herramienta desarrollada en Excel que facilita la generaci\u00f3n de los asientos de cierre contable para empresas que siguen el Plan Contable General Empresarial (PCGE).\n\n<a href=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen1.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-1557 size-large\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen1-1024x576.png\" width=\"1024\" height=\"576\" \/><\/a>\n\nEste aplicativo se basa en una hoja de trabajo, la cual puede obtenerse a partir del libro diario.\n\n<a href=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen2.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-1558 size-large\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen2-1024x577.png\" width=\"1024\" height=\"577\" \/><\/a>\n\nPara obtener nuestra de hoja de trabajo podemos partir del libro diario o en todo caso se ingresar\u00eda solo la informaci\u00f3n de la hoja de trabajado relacionado a las 4 primeras columnas que corresponden a las cuentas contables y a las sumas del mayor esto podr\u00eda ser copiando y pegando de nuestra hoja de trabajo que tengamos ya elaborada.\n\n<a href=\"https:\/\/walink.co\/897709\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-18578 aligncenter\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/08\/premiuuuuuuu-1.jpg\" alt=\"\" width=\"420\" height=\"420\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/08\/premiuuuuuuu-1.jpg 526w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/08\/premiuuuuuuu-1-300x300.jpg 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/08\/premiuuuuuuu-1-150x150.jpg 150w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/08\/premiuuuuuuu-1-420x420.jpg 420w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/a>\n<div class=\"wp-block-buttons\">\n<div class=\"wp-block-button is-style-shadow\"><a class=\"wp-block-button__link has-background wp-element-button\" href=\"https:\/\/walink.co\/897709\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>No dejes pasar esta oportunidad de formar parte de una comunidad completa de contadores exigentes. \u00a1Cont\u00e1ctanos ahora! (CLICK AQU\u00cd)<\/strong><\/a><\/div>\n<!-- \/wp:button -->\n\n<\/div>\n<!-- \/wp:buttons --> <!-- wp:separator {\"className\":\"is-style-dots\"} -->\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\" \/>\n\n<!-- \/wp:separator -->\n\n<strong>Este proceso lo realizaremos en dos partes:<\/strong>\n\nEn el caso de disponer \u00fanicamente del libro diario, la herramienta permite generar la hoja de trabajo correspondiente:\n\n<a href=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen3.png\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-1559 aligncenter\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen3-1024x589.png\" width=\"702\" height=\"404\" \/><\/a>\n\nPara generar la hoja de trabajo utilizamos la opci\u00f3n \u201cGENERAR HOJA DE TRABAJO\u201d de la pesta\u00f1a personalizada:<a href=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen4.png\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-1560 \" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen4-1024x278.png\" width=\"527\" height=\"143\" \/><\/a>\n\nUna vez obtenida la hoja de trabajo, se procede al proceso de cierre. Es importante considerar que se pueden ingresar los importes relativos a las diferencias temporales y permanentes en la hoja \u00abAPOYO \u2013 ASIENTO\u00bb para determinar la base tributaria.\n\n<a href=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen5.png\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-1561 \" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen5-1024x580.png\" width=\"747\" height=\"423\" \/><\/a>\n\nPor lo dem\u00e1s solo resta generar el proceso de cierre utilizando la opci\u00f3n \u201cCIERRE CONTABLE\u201d:\n\n<a href=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen6.png\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-1562 aligncenter\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen6-300x153.png\" alt=\"\" width=\"318\" height=\"162\" \/><\/a>\n\n<!-- wp:image {\"align\":\"center\",\"id\":18578,\"width\":420,\"height\":420,\"sizeSlug\":\"full\",\"linkDestination\":\"custom\"} -->\n\n<!-- \/wp:buttons --> <!-- wp:separator {\"className\":\"is-style-dots\"} -->\n\n<strong>Este proceso lo realizaremos en dos partes:<\/strong>\n\n<a href=\"https:\/\/walink.co\/13aba6\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter\" src=\"https:\/\/www.perucontable.com\/contabilidad\/wp-content\/uploads\/2024\/12\/Post-19-1024x1024.png\" width=\"467\" height=\"467\" \/><\/a>\n\n<!-- wp:image {\"align\":\"center\",\"id\":25035,\"width\":512,\"height\":512,\"sizeSlug\":\"large\",\"linkDestination\":\"custom\"} -->\n\n<!-- \/wp:image --> <!-- wp:buttons {\"layout\":{\"type\":\"flex\",\"justifyContent\":\"center\"}} -->\n<div class=\"wp-block-buttons\"><!-- wp:button {\"style\":{\"color\":{\"background\":\"#1f516e\"}}} -->\n<div class=\"wp-block-button\" style=\"text-align: center;\"><a class=\"wp-block-button__link has-background wp-element-button\" href=\"https:\/\/walink.co\/13aba6\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Inscr\u00edbete a nuestro Especializaci\u00f3n en CIERRE CONTABLE 2024 (<\/strong>CLICK AQU\u00cd<strong>)<\/strong><\/a><\/div>\n<!-- \/wp:button -->\n\n<\/div>\n<!-- \/wp:buttons --> <!-- wp:heading {\"level\":4,\"style\":{\"color\":{\"text\":\"#021d2b\"},\"typography\":{\"fontSize\":\"20px\"}},\"tdMarginTop\":15} -->\n<h4 class=\"has-text-color\"><strong>Soluci\u00f3n:<\/strong><\/h4>\n<!-- \/wp:heading -->\n<ol>\n \t<li>Cierre de cuentas de resultados<\/li>\n<\/ol>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen7.png\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-1563 size-large\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen7-1024x576.png\" width=\"1024\" height=\"576\" \/><\/a>2.- Cierre de cuentas de balance<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen8.png\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-1564 size-large\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen8-1024x524.png\" width=\"1024\" height=\"524\" \/><\/a><\/p>\nParalelo a esto obtenemos los asientos de cierre en el libro diario:\n\n<a href=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen9.png\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-1565 aligncenter\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2017\/01\/Imagen9-1024x577.png\" width=\"669\" height=\"377\" \/><\/a>\n\nEste aplicativo est\u00e1 dise\u00f1ado para realizar el cierre contable en empresas que siguen el PCGE, considerando todas las cuentas principales y divisionarias vigentes en dicho plan.\n\n<!-- wp:buttons -->\n<div class=\"wp-block-buttons\"><!-- wp:button {\"align\":\"center\",\"style\":{\"border\":{\"radius\":\"0px\"},\"color\":{\"background\":\"#0483cd\"}},\"className\":\"is-style-shadow\"} -->\n<div class=\"wp-block-button aligncenter is-style-shadow\"><a class=\"wp-block-button__link has-background wp-element-button\" href=\"https:\/\/mega.nz\/#!XkdBlJSR!rEyZKl1_8vvbCPYgKnOECzvR_rjF6TnZZE3baAOVEIU\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Descarga aqu\u00ed el aplicativo: APLICATIVO &#8211; CIERRE CONTABLE (GRATIS)<\/strong><\/a><\/div>\n<\/div>\n<strong><!-- wp:paragraph {\"style\":{\"typography\":{\"fontSize\":\"19px\"}}} --><\/strong>\n\n<strong>Te recomendamos:<\/strong>\n\n<strong><!-- \/wp:paragraph --> <!-- wp:list --><\/strong>\n<ul>\n \t<li style=\"list-style-type: none;\">\n<ul><!-- wp:list-item --><\/ul>\n<\/li>\n<\/ul>\n<ul>\n \t<li style=\"list-style-type: none;\">\n<ul>\n \t<li><strong><a href=\"https:\/\/walink.co\/8dec49\" target=\"_blank\" rel=\"noreferrer noopener\">Especializaci\u00f3n en Asistente Contable<\/a><\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<ul>\n \t<li style=\"list-style-type: none;\">\n<ul>\n \t<li><strong><a href=\"https:\/\/walink.co\/98b1c9\" target=\"_blank\" rel=\"noreferrer noopener\">Diplomado Virtual en An\u00e1lisis y Elaboraci\u00f3n de Estados Financieros<\/a><\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<ul>\n \t<li style=\"list-style-type: none;\">\n<ul>\n \t<li><strong><a href=\"https:\/\/walink.co\/ddc928\" target=\"_blank\" rel=\"noreferrer noopener\">Especializaci\u00f3n en Empresas Constructoras e Inmobiliarias<\/a><\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<!-- \/wp:list-item -->\n\n<strong><!-- \/wp:list --> <!-- wp:paragraph --><\/strong>\n\n<strong>Para un mejor entendimiento, te recomendamos descargar esta plantilla:<\/strong>\n\n<strong><!-- \/wp:paragraph --> <!-- wp:image {\"align\":\"center\",\"id\":18599,\"sizeSlug\":\"full\",\"linkDestination\":\"custom\"} --><\/strong>\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/www.perucontable.com\/descargar\/a\/plantilla-excel-estado-flujo-efectivo-automatico\/\"><img decoding=\"async\" loading=\"lazy\" width=\"545\" height=\"284\" class=\"wp-image-18599\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/08\/image-67.png\" alt=\"\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/08\/image-67.png 545w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/08\/image-67-300x156.png 300w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/a><\/figure>\n<strong><!-- \/wp:image --> <!-- wp:buttons --><\/strong>\n<div class=\"wp-block-buttons\"><!-- wp:button {\"align\":\"center\",\"style\":{\"border\":{\"radius\":\"0px\"},\"color\":{\"background\":\"#0483cd\"}},\"className\":\"is-style-shadow\"} -->\n<div class=\"wp-block-button aligncenter is-style-shadow\"><a class=\"wp-block-button__link has-background wp-element-button\" href=\"https:\/\/www.perucontable.com\/descargar\/a\/plantilla-excel-estado-flujo-efectivo-automatico\/\" target=\"_blank\" rel=\"noreferrer noopener\">DESCARGA LA PLANTILLA EXCEL (CLICK AQU\u00cd)<\/a><\/div>\n<!-- \/wp:button -->\n\n<\/div>\n<strong><!-- \/wp:buttons --> <!-- wp:separator {\"className\":\"is-style-dots\"} --><\/strong>\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\" \/>\n\n<strong><!-- \/wp:separator --> <!-- wp:paragraph --><\/strong>\n\n<strong>\u00bfQu\u00e9 le pareci\u00f3 el art\u00edculo? D\u00e9jenos sus comentarios.<\/strong>\n\n<strong><!-- \/wp:paragraph --><\/strong>\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><\/figure>\n<!-- wp:buttons -->\n<div class=\"wp-block-buttons\"><\/div>\n<!-- \/wp:buttons -->","protected":false},"excerpt":{"rendered":"<p>El cierre contable es un proceso fundamental en la contabilidad, especialmente al finalizar un ejercicio. Generalmente, los sistemas contables realizan autom\u00e1ticamente este cierre. En este caso, PERUCONTABLE presenta una herramienta desarrollada en Excel que facilita la generaci\u00f3n de los asientos de cierre contable para empresas que siguen el Plan Contable General Empresarial (PCGE). Este aplicativo [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17730,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,19,83],"tags":[],"yst_prominent_words":[161,208,187,185],"_links":{"self":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/1556"}],"collection":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/comments?post=1556"}],"version-history":[{"count":14,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/1556\/revisions"}],"predecessor-version":[{"id":19222,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/1556\/revisions\/19222"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media\/17730"}],"wp:attachment":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media?parent=1556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/categories?post=1556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/tags?post=1556"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/yst_prominent_words?post=1556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}