{"id":23732,"date":"2017-02-04T06:22:21","date_gmt":"2017-02-04T12:22:21","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=23732"},"modified":"2025-02-14T10:49:30","modified_gmt":"2025-02-14T16:49:30","slug":"control-de-cuentas-por-cobrar","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar.html","title":{"rendered":"Control de Cuentas por Cobrar en Excel"},"content":{"rendered":"<h1 style=\"text-align: center;\" id=\"t-1698019911525\">Como crear tu Plantilla Control de Cuentas por Cobrar en Excel<\/h1>\n<p style=\"text-align: justify;\">\u00bfTe gustar\u00eda aprender a crear tu plantilla de Control de Cuentas por Cobrar en excel para tu negocio?<\/p>\n<p><span><img decoding=\"async\" loading=\"lazy\" alt=\"Control de Cuentas por Cobrar\" width=\"619\" height=\"293\" title=\"Control de Cuentas por Cobrar en Excel\" data-id=\"33599\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/02\/Control-de-Cuentas-por-Cobrar-en-Excel.png\" data-width=\"619\" data-height=\"293\" data-init-width=\"630\" data-init-height=\"298\" style=\"aspect-ratio: auto 630 \/ 298;\"><\/span><\/p>\n<p style=\"text-align: justify;\">Hola Soy <strong>Roger Perez<\/strong> y en este Curso B\u00e1sico vamos a crear la Plantilla que te ayudar\u00e1 a llevar el Control B\u00e1sico de las gestiones de las ventas o servicios a cr\u00e9dito.<\/p>\n<p style=\"text-align: justify;\">Dentro de este Curso vamos a crear:<\/p>\n<ul>\n<li style=\"\"><span>Una Hoja que contendr\u00e1 la lista de tus clientes<\/span><\/li>\n<li style=\"\"><span>La Hoja que contendr\u00e1 la lista de tus art\u00edculos<\/span><\/li>\n<li style=\"\"><span>Una Hoja de seguimiento de Facturas<\/span><\/li>\n<li style=\"\"><span>La Hoja Resumen para mostrar el saldo e historial de cada cliente<\/span><\/li>\n<li style=\"\"><span>La Hoja Men\u00fa o Principal<\/span><\/li>\n<li style=\"\"><span>Formulas a utilizar para cada Hoja<\/span><\/li>\n<li style=\"\"><span>Y las macros a utilizar dentro de esta peque\u00f1a Plantilla<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Est\u00e1s listo para comenzar?<\/p>\n<h2 style=\"text-align: center;\" id=\"t-1698019911526\">Insertando y nombrando hojas para la plantilla Control de Cuentas por cobrar<\/h2>\n<p style=\"text-align: justify;\">Est\u00e1s listo para comenzar?<\/p>\n<p style=\"text-align: justify;\">Muy bien, comencemos, vamos a empezar por insertar 3 Hojas, en total debemos de tener 4 Hojas disponibles.<\/p>\n<p style=\"text-align: justify;\">Ahora vamos a asignar nombres a cada Hoja y comenzamos con la Hoja1, pulsamos doble clic y escribimos MENU.<\/p>\n<p style=\"text-align: justify;\">A la Hoja2 vamos a nombrarlo CLIENTES, a la Hoja3 vamos a nombrarlo ART\u00cdCULOS.<\/p>\n<p style=\"text-align: justify;\">A la Hoja4 vamos a nombrarlo como SEGUIMIENTO.<\/p>\n<p style=\"text-align: justify;\">Te dejo la imagen de como debe quedar:<\/p>\n<p><span><img decoding=\"async\" loading=\"lazy\" alt=\"Control de Cuentas por Cobrar\" width=\"471\" height=\"61\" title=\"Hojas de Control de cuentas por cobrar\" data-id=\"33600\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/02\/Hojas-de-Control-de-cuentas-por-cobrar.png\"><\/span><\/p>\n<p style=\"text-align: justify;\">Muy bien, ahora vamos a comenzar con el dise\u00f1o de las Hojas y para eso comenzamos con el Dise\u00f1o de la Hoja Clientes.<\/p>\n<h2 id=\"t-1698019911515\" style=\"text-align: center;\">Dise\u00f1ando la Hoja Clientes de la Plantilla Control de Cuentas por Cobrar<\/h2>\n<p style=\"text-align: justify;\">Para comenzar vamos a escribir en la Celda A1 NUMERO DE CLIENTE, en la Celda B1 vamos a escribir NOMBRE DEL CLIENTE.<\/p>\n<p style=\"text-align: justify;\">Seleccionamos la Celda A1:B1 y le aplicamos Negrilla, seguidamente ampliamos la selecci\u00f3n a la B2 e insertamos Tabla, marcamos la casilla que dice: La Tabla tiene encabezado y pulsamos clic en aceptar.<\/p>\n<p><span><img decoding=\"async\" loading=\"lazy\" alt=\"Control de Cuentas por Cobrar\" width=\"419\" height=\"423\" title=\"Insertando Tabla clientes\" data-id=\"33602\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/02\/Insertando-Tabla-clientes.png\"><\/span><\/p>\n<p style=\"text-align: justify;\">Ahora vamos a definir el margen izquierdo de la p\u00e1gina, para eso nos ubicamos en la vista Dise\u00f1o de p\u00e1gina.<\/p>\n<p style=\"text-align: justify;\">Dentro de este le aplicamos un margen de 4.29 cent\u00edmetros, ahora dentro de la primera secci\u00f3n de encabezados escribimos LOGO DEL NEGOCIO, en tu caso puedes insertar tu logo.<\/p>\n<p style=\"text-align: justify;\">En la segunda secci\u00f3n escribimos NOMBRE DEL NEGOCIO, en tu caso debes de escribir el nombre de tu negocio.<\/p>\n<p style=\"text-align: justify;\">Regresamos a la vista normal de la Hoja y listo.<\/p>\n<p style=\"text-align: justify;\">Muy bien, con estos pasos hemos Dise\u00f1ado la Hoja Clientes, ahora continuamos dise\u00f1ando la Hoja Art\u00edculos.<\/p>\n<h2 style=\"text-align: center;\" id=\"t-1698019911527\">Dise\u00f1ando la Hoja Articulos de la Plantilla Control de Cuentas por Cobrar<\/h2>\n<p style=\"\">Para comenzar vamos a escribir en la celda A1 C\u00d3DIGO, en la celda B1 vamos a escribir NOMBRE DEL ART\u00cdCULO.<\/p>\n<p style=\"\">A continuaci\u00f3n, en la C1 vamos a escribir DESCRIPCI\u00d3N y en la celda D1 escribimos PRECIO UNIT.<\/p>\n<p style=\"\">Seleccionamos la Celda A1:D1 y le aplicamos negrilla, seguidamente ampliamos la selecci\u00f3n a la D2 y pulsamos clic en el comando tabla.<\/p>\n<p style=\"\">se presenta una ventanita, dentro de este marcamos con un check la casilla que dice: la tabla tiene encabezados y pulsamos aceptar. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-articulo\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Clic aqui para ver mas<\/a>.<\/p>\n<h2 id=\"t-1698019911529\" style=\"text-align: center;\">Dise\u00f1ando la Hoja Seguimiento de la Plantilla Control de Cuentas por cobrar<\/h2>\n<p style=\"\">Para comenzar vamos a escribir en la celda A1 FECHA, en la B1 escribimos N\u00ba DE FACT, en la celda C1 escribimos FECHA DE VENC.<\/p>\n<p style=\"\">En la Celda D1 escribimos DIAS DE MORA, en la celda E1 escribimos ESTADO, en la celda F1 escribimos N\u00ba CLIENTE.<\/p>\n<p style=\"\">A continuaci\u00f3n, en la celda G1 escribimos NOMBRE DE CLIENTE, en la celda H1 escribimos C\u00d3DIGO, en la celda I1 escribimos NOMBRE DEL ART\u00cdCULO.<\/p>\n<p style=\"\">En la Celda J1 escribimos DESCRIPCI\u00d3N, en la Celda K1 escribimos PRECIO UNIT., en la celda L1 escribimos CANTIDAD, en la Celda M1 IMPUESTOS y en la celda N1 total.<\/p>\n<p style=\"\">Bien, ahora seleccionamos de la A1:N3 y nos ubicamos en la Pesta\u00f1a INSERTAR, pulsamos clic en el comando tabla, se presenta una ventana.<\/p>\n<p style=\"\">Por lo tanto, dentro de este activamos con un check donde dice: La Tabla tiene encabezados. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-seguimiento\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Clic aqui para ver mas detalles<\/a>.<\/p>\n<h2 id=\"t-1698019911528\" style=\"text-align: center;\">Dise\u00f1ando la Hoja Resumende la Plantilla Control de Cuentas por cobrar<\/h2>\n<p style=\"\">Antes de comenzar a crear la hoja Resumen, vamos a Nombrar las tablas que hemos creado recientemente.<\/p>\n<p style=\"\">Para eso nos ubicamos en la hoja CLIENTES y seleccionamos la Celda A1, si notas ahora se activo una nueva pesta\u00f1a llamado DISE\u00d1O, nos ubicamos en esta pesta\u00f1a y cambiamos el nombre de la tabla, sustituimos tabla1 por CLIENTE. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-resumen\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Clic aqui para mas detalles<\/a>.<\/p>\n<h2 id=\"t-1698019911531\" style=\"text-align: center;\">Estructurando la Tabla dinamica de la Hoja Resumen &#8211; control de cuentas por cobrar<\/h2>\n<p style=\"\">Para estructurar la hoja Resumen vamos a seguir los siguientes pasos:Como primer paso vamos a seleccionar con un check la Lista de campos que queremos que nos aparezca en filtros, en este caso Nombre de Cliente y Estado.Autom\u00e1ticamente, estos se ubicaran dentro del area de filas, pero lo que vamos a hacer es arrastrarlo directamente a filtros:<\/p>\n<p><span><img decoding=\"async\" alt=\"\" width=\"318\" data-init-width=\"325\" height=\"457\" data-init-height=\"467\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/10\/Hoja-Resumen-2-2.png\" data-width=\"318\" data-height=\"457\" style=\"aspect-ratio: auto 325 \/ 467;\" data-><\/span><\/p>\n<h2 style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\" id=\"t-1698019911532\">Dise\u00f1ando la hoja Menu de la plantilla Control de Cuentas por cobrar<\/h2>\n<p style=\"\">Hemos avanzado en un 40% y hoy vamos a completar el dise\u00f1o, para eso sigamos los siguientes pasos:<\/p>\n<p style=\"\">Seleccionamos de la B4:B18 y le aplicamos el comando combinar y centrar, ajustamos el ancho de columna a 40 pixeles y le aplicamos color de relleno verde.<\/p>\n<p style=\"\">Continuamos con mas y seleccionamos de la C4:J5 y le aplicamos el comando combinar y centrar mas color de relleno verde.<\/p>\n<p style=\"\">Seguidamente,seleccionamos de la J6:J18 y le aplicamos el comando combinar y centrar, ajustamos el ancho de columna a 40 pixeles y le aplicamos color de relleno verde. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-menu\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Clic aqui para ver mas detalles<\/a>.<\/p>\n<h2 id=\"t-1698019911530\" style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\">Formulas para la plantilla Control de Cuentas por cobrar<\/h2>\n<p style=\"\">Para calcular los dias de mora para cada cliente vamos a escribir la siguiente f\u00f3rmula dentro de la celda D2:<\/p>\n<blockquote style=\"\"><p>=SI(C2=ESBLANCO(0);0;SI(C2&lt;HOY();DIAS360(HOY();C2;FALSO);SI(C2&gt;HOY();DIAS360(HOY();C2;FALSO);0)))<\/p><\/blockquote>\n<p style=\"\">Esta formula se encargara de calcular los dias pendientes a vencer el credito (valor en positivo).<\/p>\n<p style=\"\">Y de paso tambien calculara los dias vencidos comparando la fecha de vencimiento y la fecha actual (Valor en negativo).<\/p>\n<h2 style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\" id=\"t-1698019911534\">Activando los botones de la Hoja Menu Control de Cuentas por cobrar<\/h2>\n<p style=\"\">Para comenzar vamos a conectar con hipervinculos todos los botones correspondientes a las hojas.<\/p>\n<p style=\"\">Seleccionamos con un clic derecho el boton seguimiento y seleccionamos hipervinculo.<\/p>\n<p style=\"\">Se presenta una ventana, dentro de este seleccionamos Lugar de este documento y ubicamos la hoja seguimiento con un clic y pulsamos aceptar. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/activar-los-botones-de-la-hoja-menu\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">clic aqui para ver mas detalles<\/a>.<\/p>\n<h2 style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\" id=\"t-1698019911535\">Programando el Boton Guardar y salir de la Plantilla control de cuentas por cobrar<\/h2>\n<p style=\"\">Para activar la macro necesitamos ir a VBA e insertar un modulo.<\/p>\n<p style=\"\">Sabes Como ir a VBA?<\/p>\n<p style=\"\">Bien, te explico, Para ir a VBA, tan solo pulsamos alt + F11 o bien desde la Pesta\u00f1a Desarrollador tan solo pulsamos clic en Visual Basic y listo.<\/p>\n<p style=\"\">No tienes la Pesta\u00f1a Desarrollador, quieres aprender a activarlo? tan solo visita el siguiente enlace y sigue los pasos: <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/programar-en-excel-activando-la-pestana-desarrollador-programador.html\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">clic aqui para ver<\/a>.<\/p>\n<p style=\"\">Muy bien, ahora que estamos dentro de visual basic, tan solo insertamos un modulo desde la barra de herramientas. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-boton-guardar\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Clic aqui para ver mas detalles<\/a>.<\/p>\n<h2 style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\" id=\"t-1698019911536\">Aplicando formato a la Tabla dinamica &#8211; Control de cuentas por cobrar<\/h2>\n<p style=\"\">Para aplicar el formato correcto en la hoja Resumen, necesitamos tener datos en la hoja seguimiento, para eso vamos a utilizar los siguiente datos:<\/p>\n<p style=\"\">En fecha vamos a escribir la fecha de hoy 28-02-2017, en la siguiente celda escribimos 1 y en fecha de vencimiento 28-03-2017.<\/p>\n<p style=\"\">En la K2 vamos a sobre escribir la formula temporalmente por el valor 250 y en celda L2 escribimos 2. con esto nos mostrar el total.<\/p>\n<p style=\"\">Bien, ahora nos vamos a la Hoja Resumen y puedes notar que aun no se muestra nada en la tabla din\u00e1mica. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-formatos\" target=\"_blank\" rel=\"noopener\">Clic aqui para mas detalles<\/a>.<\/p>\n<h2 id=\"t-1698019911533\" style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\">Descargar la Plantilla control de cuentas por cobrar<\/h2>\n<p style=\"\">A continuacion, te voy a compartir el enlace, para que puedas descargar la Plantilla control de cuentas por cobrar en excel.<\/p>\n<p style=\"\">Tambien, en el enlace, podras ver el manual del usuario. pulsa clic en el boton para descargar la plantilla:<\/p>\n<h2 style=\"text-align: center;\" id=\"t-1698019911516\"><span style=\"--tcb-text-highlight-color: rgb(221, 236, 5) !important;\" data-text-highlight=\"double-line\" data-tcb-highlight-animation=\"loop\" data-svg-config=\"{&quot;animationCount&quot;:&quot;infinite&quot;,&quot;animationDuration&quot;:1,&quot;animationDelay&quot;:1,&quot;strokeWidth&quot;:&quot;4&quot;}\">Preguntas Frecuentes<\/span><\/h2>\n<h3 style=\"text-align: center;\" id=\"t-1698019911517\">\u00bfC\u00f3mo se realiza el control de las cuentas por cobrar?<\/h3>\n<p style=\"\">Tu puedes hacer un control de cuentas por cobrar en excel paso a paso.<\/p>\n<p style=\"\">En primer lugar, insertas las hojas, le asignas un nombre a cada hoja.<\/p>\n<p style=\"\">En seguida preparas el dise\u00f1o para cada hoja, le formulas y le programas para dejarlo funcional. Todos los detalles lo encuentras en este mismo articulo. <a href=\"#t-1698019911526\" style=\"outline: none;\">Clic aqui para empezar a realizar o crear la plantilla<\/a>.<\/p>\n<h3 style=\"text-align: center;\" id=\"t-1698019911518\">\u00bfQu\u00e9 es el control interno de cuentas por cobrar?<\/h3>\n<p>Es el proceso de aprobacion y autorizacion de los creditos, esto incluye controles de verificacion, control de inspeccion fisica, controles sobre informacion en archivos maestros.<\/p>\n<p>Las comparaciones y conciliaciones de datos derivados de dos o mas fuentes de inforamcion relacionado.<\/p>\n<h3 style=\"text-align: center;\" id=\"t-1698019911519\">\u00bfQu\u00e9 tipo de cuenta es el control de cuentas por cobrar?<\/h3>\n<p style=\"\">Para ser especifico, el control de cuentas por cobrar son cuentas auxiliares o de detalles.<\/p>\n<p style=\"\">El cual te permite llevar el detalle de movimientos de cada cliente.<\/p>\n<h3 style=\"text-align: center;\" id=\"t-1698019911520\">\u00bfCu\u00e1les son los controles de cobranza?<\/h3>\n<p style=\"\">A continuacion una lista de los controles:<\/p>\n<ul>\n<li style=\"\">Las politicas de cobranza<\/li>\n<li style=\"\">Procedimientos de cobranza<\/li>\n<li style=\"\">Sistemas de Cobranza<\/li>\n<\/ul>\n<h3 style=\"text-align: center;\" id=\"t-1698019911521\">\u00bfComo hacer un seguimiento de cuentas por cobrar?<\/h3>\n<p style=\"\">Para hacer un seguimiento de las cuentas por cobrar, debes de tener una hoja de calculo con la base de informcion, que te permita ordenar y resumir el estado de cuenta de cada cliente.<\/p>\n<h3 style=\"text-align: center;\" id=\"t-1698019911522\">\u00bfComo analizar los datos de las cuentas por cobrar en excel?<\/h3>\n<p style=\"\">El analisis de cuentas por cobrar en excel te lo va ha facilitar la tabla dinamica que hemos insertado en la plantilla.<\/p>\n<p style=\"\">El cual te permitira, crear los detalles de movimiento de cuentas por cadda cliete. Ya descargaste la plantilla ? <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/cuentas-por-cobrar-en-excel.html\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Clic aqui para descargarlo<\/a>.<\/p>\n<h3 style=\"text-align: center;\" id=\"t-1698019911523\">\u00bfComo crear una plantilla para tus cuentas por cobrar en excel?<\/h3>\n<p style=\"\">Tu puedes crear una plantilla para tus cuentas por cobrar en excel comenzando desde el siguiente enlace: <a href=\"#t-1698019911526\" style=\"outline: none;\">Clic aqui para empezar a crear tu plantilla<\/a>.<\/p>\n<h3 style=\"text-align: center;\" id=\"t-1698019911524\">\u00bfComo actualizar automaticamente la tabla de cuentas por cobrar en excel?<\/h3>\n<p style=\"\">Para actualizar automaticamente las tablas dinamicas de la plantilla cuentas por cobrar, tan solo seleccionamos la tabla.<\/p>\n<p style=\"\">En seguida, puedes notar que activa una nueva pesta\u00f1a llamado \u00abAnalizar Tabla Din\u00e1mica\u00bb y desplegamos el comando actualizar.<\/p>\n<p style=\"\">Pulsamos clic en actualizar todo y listo.<\/p>\n<p style=\"text-align: justify;\">Ya esta listo el segundo tema, <strong>Dise\u00f1ando la Hoja Art\u00edculos<\/strong>, tan solo haz clic en el siguiente Bot\u00f3n:<\/p>\n<p>Tambi\u00e9n puedes visitar nuestra pagina de Facebook, <span style=\"color: rgb(0, 23, 255);\"><a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\"><strong>pulsando clic aqui<\/strong><\/a><\/span>.<\/p>\n<p><span style=\"color: rgb(0, 0, 0);\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-en-excel.html\">T<\/a><\/span>e Saluda,<\/p>\n<p><strong>Roger Perez &#8211; Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como crear tu Plantilla Control de Cuentas por Cobrar en Excel \u00bfTe gustar\u00eda aprender a crear tu plantilla de Control de Cuentas por Cobrar en excel para tu negocio? Hola Soy Roger Perez y en este Curso B\u00e1sico vamos a crear la Plantilla que te ayudar\u00e1 a llevar el Control B\u00e1sico de las gestiones de [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33599,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\"><h1 data-css=\"tve-u-1609835db18\" style=\"text-align: center;\" class=\"\" id=\"t-1698019911525\">Como crear tu Plantilla Control de Cuentas por Cobrar en Excel<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161a8ff1c46\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161a8ff1c47\" style=\"text-align: justify;\">\u00bfTe gustar\u00eda aprender a crear tu plantilla de Control de Cuentas por Cobrar en excel para tu negocio?<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-161a9067dc2\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" loading=\"lazy\" class=\"tve_image wp-image-33599\" alt=\"Control de Cuentas por Cobrar\" width=\"619\" height=\"293\" title=\"Control de Cuentas por Cobrar en Excel\" data-id=\"33599\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/02\/Control-de-Cuentas-por-Cobrar-en-Excel.png\" data-width=\"619\" data-height=\"293\" data-init-width=\"630\" data-init-height=\"298\" style=\"aspect-ratio: auto 630 \/ 298;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-18b5a0fc0fc\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161a9076395\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-161a9076399\" style=\"text-align: justify;\">Hola Soy <strong>Roger Perez<\/strong> y en este Curso B\u00e1sico vamos a crear la Plantilla que te ayudar\u00e1 a llevar el Control B\u00e1sico de las gestiones de las ventas o servicios a cr\u00e9dito.<\/p><p data-css=\"tve-u-161a9076399\" style=\"text-align: justify;\">Dentro de este Curso vamos a crear:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check-circle-solid\" data-css=\"tve-u-161a908242d\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style tcb-local-vars-root tcb-icon-display\" data-css=\"tve-u-161a908125f\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-check-circle-solid\" data-name=\"\" style=\"\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-18b5a0f7125\">Una Hoja que contendr\u00e1 la lista de tus clientes<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-161a9081264\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-check-circle-solid\" data-name=\"\" style=\"\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-18b5a0f7125\">La Hoja que contendr\u00e1 la lista de tus art\u00edculos<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-161a9081265\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-check-circle-solid\" data-name=\"\" style=\"\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-18b5a0f7125\">Una Hoja de seguimiento de Facturas<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-161a90940cd\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-check-circle-solid\" data-name=\"\" style=\"\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-18b5a0f7125\">La Hoja Resumen para mostrar el saldo e historial de cada cliente<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-161a90bcbaf\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-check-circle-solid\" data-name=\"\" style=\"\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-18b5a0f7125\">La Hoja Men\u00fa o Principal<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-161a90ce7ec\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-check-circle-solid\" data-name=\"\" style=\"\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-18b5a0f7125\">Formulas a utilizar para cada Hoja<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-161a90d44d1\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-check-circle-solid\" data-name=\"\" style=\"\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-18b5a0f7125\">Y las macros a utilizar dentro de esta peque\u00f1a Plantilla<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve-toc tve-elem-scroll tve-toc-expandable tcb-local-vars-root\" data-columns=\"2\" data-ct=\"toc-60676\" data-transition=\"slide\" data-headers=\"h1,h2,h3\" data-numbering=\"bullet_advanced\" data-highlight=\"progressive\" data-ct-name=\"Table of Content 08\" data-heading-style=\"{&quot;0&quot;:&quot;tve-u-18b5a10cf7e&quot;,&quot;1&quot;:&quot;tve-u-18b5a10cf80&quot;,&quot;2&quot;:&quot;tve-u-18b5a10cf82&quot;}\" data-css=\"tve-u-18b5a10cf77\" style=\"\" data-distribute=\"true\" data-bullet-style=\"{&quot;0&quot;:&quot;tve-u-18b5a10cf7f&quot;,&quot;1&quot;:&quot;tve-u-18b5a10cf81&quot;,&quot;2&quot;:&quot;tve-u-18b5a10cf84&quot;}\" data-number-style=\"{&quot;0&quot;:&quot;tve-u-173dc808bfe&quot;,&quot;1&quot;:&quot;tve-u-17399ecbfc9&quot;,&quot;2&quot;:&quot;tve-u-173dc81164c&quot;}\" data-state-default=\"expanded\" data-columns-m=\"1\" data-animation=\"\" data-columns-d=\"2\" data-state-default-m=\"collapsed\" data-element-name=\"Table of Contents\" data-form-settings=\"__TCB_FORM__{&quot;form_identifier&quot;:&quot;control-de-cuentas-por-cobrar-en-excel-form-6pcu8c&quot;}__TCB_FORM__\" data-id=\"m7506txy\"><div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"6ba77\":{\"name\":\"Main Accent\",\"parent\":-1},\"19a93\":{\"name\":\"Main Accent Light\",\"parent\":\"6ba77\"}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default\",\"value\":{\"colors\":{\"6ba77\":{\"val\":\"var(--tcb-skin-color-0)\"},\"19a93\":{\"val\":\"rgb(59, 203, 247)\",\"hsl_parent_dependency\":{\"h\":194,\"l\":0.6,\"s\":0.92}}},\"gradients\":[]},\"original\":{\"colors\":{\"6ba77\":{\"val\":\"rgb(70, 105, 233)\",\"hsl\":{\"h\":227,\"s\":0.78,\"l\":0.59,\"a\":1}},\"19a93\":{\"val\":\"rgb(84, 161, 248)\",\"hsl_parent_dependency\":{\"h\":211,\"s\":0.92,\"l\":0.65,\"a\":1}}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div><svg class=\"toc-icons\" style=\"position: absolute; width: 0; height: 0; overflow: hidden;\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><symbol id=\"toc-bullet-0-m7506txy\" viewBox=\"0 0 320 512\" data-id=\"icon-chevron-right-solid\"><path d=\"M285.476 272.971L91.132 467.314c-9.373 9.373-24.569 9.373-33.941 0l-22.667-22.667c-9.357-9.357-9.375-24.522-.04-33.901L188.505 256 34.484 101.255c-9.335-9.379-9.317-24.544.04-33.901l22.667-22.667c9.373-9.373 24.569-9.373 33.941 0L285.475 239.03c9.373 9.372 9.373 24.568.001 33.941z\"><\/path><\/symbol><symbol id=\"toc-bullet-1-m7506txy\" viewBox=\"0 0 320 512\" data-id=\"icon-chevron-right-solid\"><path d=\"M285.476 272.971L91.132 467.314c-9.373 9.373-24.569 9.373-33.941 0l-22.667-22.667c-9.357-9.357-9.375-24.522-.04-33.901L188.505 256 34.484 101.255c-9.335-9.379-9.317-24.544.04-33.901l22.667-22.667c9.373-9.373 24.569-9.373 33.941 0L285.475 239.03c9.373 9.372 9.373 24.568.001 33.941z\"><\/path><\/symbol><symbol id=\"toc-bullet-2-m7506txy\" viewBox=\"0 0 320 512\" data-id=\"icon-chevron-right-solid\"><path d=\"M285.476 272.971L91.132 467.314c-9.373 9.373-24.569 9.373-33.941 0l-22.667-22.667c-9.357-9.357-9.375-24.522-.04-33.901L188.505 256 34.484 101.255c-9.335-9.379-9.317-24.544.04-33.901l22.667-22.667c9.373-9.373 24.569-9.373 33.941 0L285.475 239.03c9.373 9.372 9.373 24.568.001 33.941z\"><\/path><\/symbol><\/svg><div class=\"tve-toc-divider\" style=\"position: absolute; width: 0; height: 0; overflow: hidden;\"><div class=\"thrv_wrapper thrv-divider tve-vert-divider\" data-style=\"tve_sep-1\" data-color-d=\"rgba(217, 217, 217, 0)\" data-css=\"tve-u-18b5a10cf78\" data-thickness-d=\"1\"><hr class=\"tve_sep tve_sep-1\" style=\"\"><\/div><\/div>\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-18b5a10cf79\"><\/div>\n\t<div class=\"thrv_wrapper tve-toc-title show-icon reverse tcb-icon-display tve-no-dropzone tve-prevent-content-edit\" data-css=\"tve-u-18b5a10cf7a\" style=\"\" data-tcb_hover_state_parent=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\">\n\t\t<div class=\"tve-toc-title-icon\" data-icon-code=\"icon-arrow-alt-circle-up-outlined\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-arrow-alt-circle-up-outlined\" data-name=\"\"><path d=\"M256 504c137 0 248-111 248-248S393 8 256 8 8 119 8 256s111 248 248 248zm0-448c110.5 0 200 89.5 200 200s-89.5 200-200 200S56 366.5 56 256 145.5 56 256 56zm20 328h-40c-6.6 0-12-5.4-12-12V256h-67c-10.7 0-16-12.9-8.5-20.5l99-99c4.7-4.7 12.3-4.7 17 0l99 99c7.6 7.6 2.2 20.5-8.5 20.5h-67v116c0 6.6-5.4 12-12 12z\"><\/path><\/svg><\/div>\n\t\t<div class=\"thrv_wrapper thrv_text_element tve_no_icons\">\t\t\t<div class=\"tcb-plain-text\" style=\"\" data-css=\"tve-u-18b5a10cf7b\">Tabla de Contenidos<\/div>\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"tve-cb tve-toc-content tve-prevent-content-edit\" style=\"display: inline-block;\">\n\t\t\n\n\t\t<div class=\"thrv_wrapper tve-toc-list tcb-no-delete tcb-no-save tcb-no-clone tve-no-dropzone\" data-css=\"tve-u-18b5a10cf7c\" style=\"\">\n\t\t\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-18b5a10cf7d\"><\/div>\n\t\t\t<div class=\"tve-cb\">\n\t\t\t\t<div class=\"tve_ct_content tve_clearfix\"><div class=\"ct_column\"><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H1\" data-css=\"tve-u-18b5a10cf7e\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911525\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m7506txy\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-18b5a10cf7f\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911525\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Como crear tu Plantilla Control de Cuentas por Cobrar en Excel<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911526\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911526\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Insertando y nombrando hojas para la plantilla Control de Cuentas por cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911515\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911515\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Dise\u00f1ando la Hoja Clientes de la Plantilla Control de Cuentas por Cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911527\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911527\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Dise\u00f1ando la Hoja Art\u00edculos de la Plantilla Control de Cuentas por Cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911529\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911529\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Dise\u00f1ando la Hoja Seguimiento de la Plantilla Control de Cuentas por cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911528\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911528\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Dise\u00f1ando la Hoja Resumende la Plantilla Control de Cuentas por cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911531\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911531\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Estructurando la Tabla Din\u00e1mica de la Hoja Resumen - control de cuentas por cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911532\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911532\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Dise\u00f1ando la hoja Menu de la plantilla Control de Cuentas por cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911530\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911530\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Formulas para la plantilla Control de Cuentas por cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911534\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911534\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Activando los botones de la Hoja Menu Control de Cuentas por cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911535\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911535\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Programando el Boton Guardar y salir de la Plantilla control de cuentas por cobrar<\/a><\/div><\/div><div class=\"thrv_wrapper thrv-divider tve-vert-divider\" data-style=\"tve_sep-1\" data-color-d=\"rgba(217, 217, 217, 0)\" data-css=\"tve-u-18b5a10cf78\" data-thickness-d=\"1\"><hr class=\"tve_sep tve_sep-1\" style=\"\"><\/div><div class=\"ct_column\"><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911536\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911536\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Aplicando formato a la Tabla dinamica - Control de cuentas por cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911533\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911533\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Descargar la Plantilla control de cuentas por cobrar<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-18b5a10cf80\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911516\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m7506txy\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-18b5a10cf81\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911516\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Preguntas Frecuentes<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-18b5a10cf82\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911517\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m7506txy\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-18b5a10cf84\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911517\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfC\u00f3mo se realiza el control de las cuentas por cobrar?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-18b5a10cf82\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911518\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m7506txy\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-18b5a10cf84\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911518\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfQu\u00e9 es el control interno de cuentas por cobrar?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-18b5a10cf82\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911519\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m7506txy\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-18b5a10cf84\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911519\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfQu\u00e9 tipo de cuenta es el control de cuentas por cobrar?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-18b5a10cf82\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911520\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m7506txy\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-18b5a10cf84\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911520\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfCu\u00e1les son los controles de cobranza?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-18b5a10cf82\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911521\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m7506txy\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-18b5a10cf84\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911521\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfComo hacer un seguimiento de cuentas por cobrar?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-18b5a10cf82\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911522\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m7506txy\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-18b5a10cf84\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911522\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfComo analizar los datos de las cuentas por cobrar en excel?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-18b5a10cf82\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911523\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m7506txy\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-18b5a10cf84\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911523\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfComo crear una plantilla para tus cuentas por cobrar en excel?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-18b5a10cf82\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1698019911524\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m7506txy\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-18b5a10cf84\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m7506txy\"><\/use><\/svg><\/div><a href=\"#t-1698019911524\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfComo actualizar automaticamente la tabla de cuentas por cobrar en excel?<\/a><\/div><\/div><div class=\"thrv_wrapper thrv-divider tve-vert-divider\" data-style=\"tve_sep-1\" data-color-d=\"rgba(217, 217, 217, 0)\" data-css=\"tve-u-18b5a10cf78\" data-thickness-d=\"1\"><hr class=\"tve_sep tve_sep-1\" style=\"\"><\/div><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-18b5a171f71\" style=\"\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161a9130196\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161a9130198\" style=\"text-align: justify;\">Est\u00e1s listo para comenzar?<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h2 style=\"text-align: center;\" data-css=\"tve-u-18b5a190324\" id=\"t-1698019911526\" class=\"\">Insertando y nombrando hojas para la plantilla Control de Cuentas por cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-161a9188602\" style=\"\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161a9130196\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-161a9130198\" style=\"text-align: justify;\">Est\u00e1s listo para comenzar?<\/p><p data-css=\"tve-u-161a9130198\" style=\"text-align: justify;\">Muy bien, comencemos, vamos a empezar por insertar 3 Hojas, en total debemos de tener 4 Hojas disponibles.<\/p><p data-css=\"tve-u-161a9130198\" style=\"text-align: justify;\">Ahora vamos a asignar nombres a cada Hoja y comenzamos con la Hoja1, pulsamos doble clic y escribimos MENU.<\/p><p data-css=\"tve-u-161a9130198\" style=\"text-align: justify;\">A la Hoja2 vamos a nombrarlo CLIENTES, a la Hoja3 vamos a nombrarlo ART\u00cdCULOS.<\/p><p data-css=\"tve-u-161a9130198\" style=\"text-align: justify;\">A la Hoja4 vamos a nombrarlo como SEGUIMIENTO.<\/p><p data-css=\"tve-u-161a9130198\" style=\"text-align: justify;\">Te dejo la imagen de como debe quedar:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-161a91bb9e3\"><span class=\"tve_image_frame\"><img decoding=\"async\" loading=\"lazy\" class=\"tve_image wp-image-33600\" alt=\"Control de Cuentas por Cobrar\" width=\"471\" height=\"61\" title=\"Hojas de Control de cuentas por cobrar\" data-id=\"33600\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/02\/Hojas-de-Control-de-cuentas-por-cobrar.png\" data-width=\"471\" data-height=\"61\" data-init-width=\"471\" data-init-height=\"61\" style=\"aspect-ratio: auto 471 \/ 61;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-161a91c891b\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161a91c4cb5\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161a91c4cb7\" style=\"text-align: justify;\">Muy bien, ahora vamos a comenzar con el dise\u00f1o de las Hojas y para eso comenzamos con el Dise\u00f1o de la Hoja Clientes.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" style=\"\"><h2 class=\"\" data-css=\"tve-u-161a91df77d\" id=\"t-1698019911515\" style=\"text-align: center;\">Dise\u00f1ando la Hoja Clientes de la Plantilla Control de Cuentas por Cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161a91efe6f\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161a91efe72\" style=\"text-align: justify;\">Para comenzar vamos a escribir en la Celda A1 NUMERO DE CLIENTE, en la Celda B1 vamos a escribir NOMBRE DEL CLIENTE.<\/p><p data-css=\"tve-u-161a91efe72\" style=\"text-align: justify;\">Seleccionamos la Celda A1:B1 y le aplicamos Negrilla, seguidamente ampliamos la selecci\u00f3n a la B2 e insertamos Tabla, marcamos la casilla que dice: La Tabla tiene encabezado y pulsamos clic en aceptar.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-161a9238651\"><span class=\"tve_image_frame\"><img decoding=\"async\" loading=\"lazy\" class=\"tve_image wp-image-33602\" alt=\"Control de Cuentas por Cobrar\" width=\"419\" height=\"423\" title=\"Insertando Tabla clientes\" data-id=\"33602\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/02\/Insertando-Tabla-clientes.png\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-161a924a60d\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161a9244a3b\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161a9244a3d\" style=\"text-align: justify;\">Ahora vamos a definir el margen izquierdo de la p\u00e1gina, para eso nos ubicamos en la vista Dise\u00f1o de p\u00e1gina.<\/p><p data-css=\"tve-u-161a9244a3d\" style=\"text-align: justify;\">Dentro de este le aplicamos un margen de 4.29 cent\u00edmetros, ahora dentro de la primera secci\u00f3n de encabezados escribimos LOGO DEL NEGOCIO, en tu caso puedes insertar tu logo.<\/p><p data-css=\"tve-u-161a9244a3d\" style=\"text-align: justify;\">En la segunda secci\u00f3n escribimos NOMBRE DEL NEGOCIO, en tu caso debes de escribir el nombre de tu negocio.<\/p><p data-css=\"tve-u-161a9244a3d\" style=\"text-align: justify;\">Regresamos a la vista normal de la Hoja y listo.<\/p><p data-css=\"tve-u-161a9244a3d\" style=\"text-align: justify;\">Muy bien, con estos pasos hemos Dise\u00f1ado la Hoja Clientes, ahora continuamos dise\u00f1ando la Hoja Art\u00edculos.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" style=\"\"><h2 class=\"\" data-css=\"tve-u-161a91df77d\" style=\"text-align: center;\" id=\"t-1698019911527\">Dise\u00f1ando la Hoja Art\u00edculos de la Plantilla Control de Cuentas por Cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a443352\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a44334c\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Para comenzar vamos a escribir en la celda A1 C\u00d3DIGO, en la celda B1 vamos a escribir NOMBRE DEL ART\u00cdCULO.<\/p><p style=\"\">A continuaci\u00f3n, en la C1 vamos a escribir DESCRIPCI\u00d3N y en la celda D1 escribimos PRECIO UNIT.<\/p><p style=\"\">Seleccionamos la Celda A1:D1 y le aplicamos negrilla, seguidamente ampliamos la selecci\u00f3n a la D2 y pulsamos clic en el comando tabla.<\/p><p style=\"\">se presenta una ventanita, dentro de este marcamos con un check la casilla que dice: la tabla tiene encabezados y pulsamos aceptar. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-articulo\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver mas<\/a>.<\/p><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18b5a474d87\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-articulo\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqui para mas&nbsp;<\/span><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h2 class=\"\" id=\"t-1698019911529\" style=\"text-align: center;\" data-css=\"tve-u-18b5a59d90b\">Dise\u00f1ando la Hoja Seguimiento de la Plantilla Control de Cuentas por cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a443352\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a44334c\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Para comenzar vamos a escribir en la celda A1 FECHA, en la B1 escribimos N\u00ba DE FACT, en la celda C1 escribimos FECHA DE VENC.<\/p><p style=\"\">En la Celda D1 escribimos DIAS DE MORA, en la celda E1 escribimos ESTADO, en la celda F1 escribimos N\u00ba CLIENTE.<\/p><p style=\"\">A continuaci\u00f3n, en la celda G1 escribimos NOMBRE DE CLIENTE, en la celda H1 escribimos C\u00d3DIGO, en la celda I1 escribimos NOMBRE DEL ART\u00cdCULO.<\/p><p style=\"\">En la Celda J1 escribimos DESCRIPCI\u00d3N, en la Celda K1 escribimos PRECIO UNIT., en la celda L1 escribimos CANTIDAD, en la Celda M1 IMPUESTOS y en la celda N1 total.<\/p><p style=\"\">Bien, ahora seleccionamos de la A1:N3 y nos ubicamos en la Pesta\u00f1a INSERTAR, pulsamos clic en el comando tabla, se presenta una ventana.<\/p><p style=\"\">Por lo tanto, dentro de este activamos con un check donde dice: La Tabla tiene encabezados. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-seguimiento\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver mas detalles<\/a>.<\/p><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18b5a474d87\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-seguimiento\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqui para mas&nbsp;<\/span><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h2 id=\"t-1698019911528\" style=\"text-align: center;\" class=\"\" data-css=\"tve-u-18b5a5a4019\">Dise\u00f1ando la Hoja Resumende la Plantilla Control de Cuentas por cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a443352\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a44334c\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Antes de comenzar a crear la hoja Resumen, vamos a Nombrar las tablas que hemos creado recientemente.<\/p><p style=\"\">Para eso nos ubicamos en la hoja CLIENTES y seleccionamos la Celda A1, si notas ahora se activo una nueva pesta\u00f1a llamado DISE\u00d1O, nos ubicamos en esta pesta\u00f1a y cambiamos el nombre de la tabla, sustituimos tabla1 por CLIENTE. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-resumen\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para mas detalles<\/a>.<\/p><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18b5a474d87\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-resumen\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqui para mas&nbsp;<\/span><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h2 class=\"\" id=\"t-1698019911531\" style=\"text-align: center;\" data-css=\"tve-u-18b5a5a91e1\">Estructurando la Tabla Din\u00e1mica de la Hoja Resumen - control de cuentas por cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a443352\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a44334c\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Para estructurar la hoja Resumen vamos a seguir los siguientes pasos:<br><br>Como primer paso vamos a seleccionar con un check la Lista de campos que queremos que nos aparezca en filtros, en este caso Nombre de Cliente y Estado.<br><br>Autom\u00e1ticamente, estos se ubicaran dentro del area de filas, pero lo que vamos a hacer es arrastrarlo directamente a filtros:<\/p><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18b5a529a31\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image\" alt=\"\" width=\"318\" data-init-width=\"325\" height=\"457\" data-init-height=\"467\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/10\/Hoja-Resumen-2-2.png\" data-width=\"318\" data-height=\"457\" style=\"aspect-ratio: auto 325 \/ 467;\"><\/span><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18b5a474d87\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-resumen-2\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqui para mas&nbsp;<\/span><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h2 data-css=\"tve-u-18b5a5ad267\" style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\" class=\"\" id=\"t-1698019911532\">Dise\u00f1ando la hoja Menu de la plantilla Control de Cuentas por cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a443352\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a44334c\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Hemos avanzado en un 40% y hoy vamos a completar el dise\u00f1o, para eso sigamos los siguientes pasos:<\/p><p style=\"\">Seleccionamos de la B4:B18 y le aplicamos el comando combinar y centrar, ajustamos el ancho de columna a 40 pixeles y le aplicamos color de relleno verde.<\/p><p style=\"\">Continuamos con mas y seleccionamos de la C4:J5 y le aplicamos el comando combinar y centrar mas color de relleno verde.<\/p><p style=\"\">Seguidamente,seleccionamos de la J6:J18 y le aplicamos el comando combinar y centrar, ajustamos el ancho de columna a 40 pixeles y le aplicamos color de relleno verde. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-menu\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver mas detalles<\/a>.<\/p><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18b5a474d87\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-menu\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqui para mas&nbsp;<\/span><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h2 data-css=\"tve-u-18b5a5ad267\" id=\"t-1698019911530\" style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\" class=\"\">Formulas para la plantilla Control de Cuentas por cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a443352\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a44334c\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Para calcular los dias de mora para cada cliente vamos a escribir la siguiente f\u00f3rmula dentro de la celda D2:<\/p><blockquote class=\"\" style=\"\">=SI(C2=ESBLANCO(0);0;SI(C2&lt;HOY();DIAS360(HOY();C2;FALSO);SI(C2&gt;HOY();DIAS360(HOY();C2;FALSO);0)))<\/blockquote><p style=\"\">Esta formula se encargara de calcular los dias pendientes a vencer el credito (valor en positivo).<\/p><p style=\"\">Y de paso tambien calculara los dias vencidos comparando la fecha de vencimiento y la fecha actual (Valor en negativo).<\/p><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18b5a474d87\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-formulas\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqui para mas&nbsp;<\/span><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h2 data-css=\"tve-u-18b5a5ad267\" style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\" class=\"\" id=\"t-1698019911534\">Activando los botones de la Hoja Menu Control de Cuentas por cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a443352\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a44334c\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Para comenzar vamos a conectar con hipervinculos todos los botones correspondientes a las hojas.<\/p><p style=\"\">Seleccionamos con un clic derecho el boton seguimiento y seleccionamos hipervinculo.<\/p><p style=\"\">Se presenta una ventana, dentro de este seleccionamos Lugar de este documento y ubicamos la hoja seguimiento con un clic y pulsamos aceptar. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/activar-los-botones-de-la-hoja-menu\" target=\"_blank\" class=\"\" style=\"outline: none;\">clic aqui para ver mas detalles<\/a>.<\/p><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18b5a474d87\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/activar-los-botones-de-la-hoja-menu\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqui para mas&nbsp;<\/span><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h2 data-css=\"tve-u-18b5a5ad267\" style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\" class=\"\" id=\"t-1698019911535\">Programando el Boton Guardar y salir de la Plantilla control de cuentas por cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a443352\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a44334c\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Para activar la macro necesitamos ir a VBA e insertar un modulo.<\/p><p style=\"\">Sabes Como ir a VBA?<\/p><p style=\"\">Bien, te explico, Para ir a VBA, tan solo pulsamos alt + F11 o bien desde la Pesta\u00f1a Desarrollador tan solo pulsamos clic en Visual Basic y listo.<\/p><p style=\"\">No tienes la Pesta\u00f1a Desarrollador, quieres aprender a activarlo? tan solo visita el siguiente enlace y sigue los pasos: <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/programar-en-excel-activando-la-pestana-desarrollador-programador.html\" target=\"_blank\" class=\"\" style=\"outline: none;\">clic aqui para ver<\/a>.<\/p><p style=\"\">Muy bien, ahora que estamos dentro de visual basic, tan solo insertamos un modulo desde la barra de herramientas. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-boton-guardar\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver mas detalles<\/a>.<\/p><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18b5a474d87\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-boton-guardar\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqui para mas&nbsp;<\/span><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h2 data-css=\"tve-u-18b5a5ad267\" style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\" class=\"\" id=\"t-1698019911536\">Aplicando formato a la Tabla dinamica - Control de cuentas por cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a443352\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a44334c\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Para aplicar el formato correcto en la hoja Resumen, necesitamos tener datos en la hoja seguimiento, para eso vamos a utilizar los siguiente datos:<\/p><p style=\"\">En fecha vamos a escribir la fecha de hoy 28-02-2017, en la siguiente celda escribimos 1 y en fecha de vencimiento 28-03-2017.<\/p><p style=\"\">En la K2 vamos a sobre escribir la formula temporalmente por el valor 250 y en celda L2 escribimos 2. con esto nos mostrar el total.<\/p><p style=\"\">Bien, ahora nos vamos a la Hoja Resumen y puedes notar que aun no se muestra nada en la tabla din\u00e1mica. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-formatos\" target=\"_blank\">Clic aqui para mas detalles<\/a>.<\/p><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18b5a474d87\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-formatos\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqui para mas&nbsp;<\/span><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h2 data-css=\"tve-u-18b5a5ad267\" id=\"t-1698019911533\" style=\"text-align: center; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0, 5, 6) !important;\" class=\"\">Descargar la Plantilla control de cuentas por cobrar<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a443352\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a44334c\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">A continuacion, te voy a compartir el enlace, para que puedas descargar la Plantilla control de cuentas por cobrar en excel.<\/p><p style=\"\">Tambien, en el enlace, podras ver el manual del usuario. pulsa clic en el boton para descargar la plantilla:<\/p><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18b5a474d87\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/cuentas-por-cobrar-en-excel.html\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqui para descargar la planitlla&nbsp;<\/span><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\"><h2 data-css=\"tve-u-18b59ef6c45\" style=\"text-align: center;\" id=\"t-1698019911516\" class=\"\"><span style=\"--tcb-text-highlight-color: rgb(221, 236, 5) !important;\" data-text-highlight=\"double-line\" data-tcb-highlight-animation=\"loop\" class=\"\" data-svg-config=\"{&quot;animationCount&quot;:&quot;infinite&quot;,&quot;animationDuration&quot;:1,&quot;animationDelay&quot;:1,&quot;strokeWidth&quot;:&quot;4&quot;}\" data-css=\"tve-u-18b5a79e376\">Preguntas Frecuentes<\/span><\/h2><\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 data-css=\"tve-u-18b59f50b58\" style=\"text-align: center;\" id=\"t-1698019911517\" class=\"\">\u00bfC\u00f3mo se realiza el control de las cuentas por cobrar?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a65bb83\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a65bb7f\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\">\t<p style=\"\">Tu puedes hacer un control de cuentas por cobrar en excel paso a paso.<\/p><p style=\"\">En primer lugar, insertas las hojas, le asignas un nombre a cada hoja.<\/p><p style=\"\">En seguida preparas el dise\u00f1o para cada hoja, le formulas y le programas para dejarlo funcional. Todos los detalles lo encuentras en este mismo articulo. <a href=\"#t-1698019911526\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para empezar a realizar o crear la plantilla<\/a>.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 data-css=\"tve-u-18b59f50b58\" style=\"text-align: center;\" id=\"t-1698019911518\" class=\"\">\u00bfQu\u00e9 es el control interno de cuentas por cobrar?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a65bb83\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a65bb7f\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\">\t<p>Es el proceso de aprobacion y autorizacion de los creditos, esto incluye controles de verificacion, control de inspeccion fisica, controles sobre informacion en archivos maestros.<\/p><p>Las comparaciones y conciliaciones de datos derivados de dos o mas fuentes de inforamcion relacionado.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 data-css=\"tve-u-18b59f50b58\" style=\"text-align: center;\" id=\"t-1698019911519\" class=\"\">\u00bfQu\u00e9 tipo de cuenta es el control de cuentas por cobrar?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a65bb83\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a65bb7f\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><p style=\"\">Para ser especifico, el control de cuentas por cobrar son cuentas auxiliares o de detalles.<\/p><p style=\"\">El cual te permite llevar el detalle de movimientos de cada cliente.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 data-css=\"tve-u-18b59f50b58\" style=\"text-align: center;\" id=\"t-1698019911520\" class=\"\">\u00bfCu\u00e1les son los controles de cobranza?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a65bb83\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a65bb7f\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><p style=\"\">A continuacion una lista de los controles:<\/p><ul class=\"\"><li class=\"\" style=\"\">Las politicas de cobranza<\/li><li class=\"\" style=\"\">Procedimientos de cobranza<\/li><li class=\"\" style=\"\">Sistemas de Cobranza<\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 data-css=\"tve-u-18b59f50b58\" style=\"text-align: center;\" id=\"t-1698019911521\" class=\"\">\u00bfComo hacer un seguimiento de cuentas por cobrar?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a65bb83\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a65bb7f\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\">\t<p style=\"\">Para hacer un seguimiento de las cuentas por cobrar, debes de tener una hoja de calculo con la base de informcion, que te permita ordenar y resumir el estado de cuenta de cada cliente.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 data-css=\"tve-u-18b59f50b58\" style=\"text-align: center;\" id=\"t-1698019911522\" class=\"\">\u00bfComo analizar los datos de las cuentas por cobrar en excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a65bb83\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a65bb7f\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\">\t<p style=\"\">El analisis de cuentas por cobrar en excel te lo va ha facilitar la tabla dinamica que hemos insertado en la plantilla.<\/p><p style=\"\">El cual te permitira, crear los detalles de movimiento de cuentas por cadda cliete. Ya descargaste la plantilla ? <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/cuentas-por-cobrar-en-excel.html\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para descargarlo<\/a>.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 data-css=\"tve-u-18b59f50b58\" style=\"text-align: center;\" id=\"t-1698019911523\" class=\"\">\u00bfComo crear una plantilla para tus cuentas por cobrar en excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a65bb83\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a65bb7f\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\">\t<p style=\"\">Tu puedes crear una plantilla para tus cuentas por cobrar en excel comenzando desde el siguiente enlace: <a href=\"#t-1698019911526\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para empezar a crear tu plantilla<\/a>.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 data-css=\"tve-u-18b59f50b58\" style=\"text-align: center;\" id=\"t-1698019911524\" class=\"\">\u00bfComo actualizar automaticamente la tabla de cuentas por cobrar en excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18b5a65bb83\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18b5a65bb7f\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\">\t<p style=\"\">Para actualizar automaticamente las tablas dinamicas de la plantilla cuentas por cobrar, tan solo seleccionamos la tabla.<\/p><p style=\"\">En seguida, puedes notar que activa una nueva pesta\u00f1a llamado \"Analizar Tabla Din\u00e1mica\" y desplegamos el comando actualizar.<\/p><p style=\"\">Pulsamos clic en actualizar todo y listo.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-161a92b4fd1\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb\">\n<div class=\"tve_s_item tve_s_fb_share\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-en-excel.html\" data-label=\"Compartir\">\n<a href=\"javascript:void(0)\" class=\"tve_s_link\"><span class=\"tve_s_icon thrv-svg-icon\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"tcb-facebook\" viewBox=\"0 0 16 28\"><path d=\"M14.984 0.187v4.125h-2.453q-1.344 0-1.813 0.562t-0.469 1.687v2.953h4.578l-0.609 4.625h-3.969v11.859h-4.781v-11.859h-3.984v-4.625h3.984v-3.406q0-2.906 1.625-4.508t4.328-1.602q2.297 0 3.563 0.187z\"><\/path><\/svg><\/span><span class=\"tve_s_text\">Compartir<\/span><span class=\"tve_s_count\">0<\/span><\/a>\n<\/div>\n<\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161a92bc52e\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161a92bc531\" style=\"text-align: justify;\">Ya esta listo el segundo tema, <strong>Dise\u00f1ando la Hoja Art\u00edculos<\/strong>, tan solo haz clic en el siguiente Bot\u00f3n:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-button tve_ea_thrive_animation tve_anim_rotate\" data-css=\"tve-u-161a92cefc3\" data-tcb_hover_state_parent=\"\" style=\"\">\n<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/control-de-cuentas-por-cobrar-hoja-articulo\" class=\"tcb-button-link tve_evt_manager_listen tve_et_tve-viewport tve-viewport-triggered\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;rotate&quot;,&quot;loop&quot;:1},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\">\n<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\" data-css=\"tve-u-161a9309e59\"><strong>Haz clic aqu\u00ed para ver el Tema 2<\/strong><\/span><\/span>\n<\/a>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161a92e386f\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161a92f13ca\">Tambi\u00e9n puedes visitar nuestra pagina de Facebook, <span style=\"color: rgb(0, 23, 255);\" data-css=\"tve-u-161a92f7010\"><a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\"><strong>pulsando clic aqu\u00ed<\/strong><\/a><\/span>.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-195055c10fe\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-195055c10fd\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-195055c10ff\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-195055c1100\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-195055c1101\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-195055c1102\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-195055c1103\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-161a92f7010\"] { color: rgb(0, 23, 255) !important; }:not(#tve) [data-css=\"tve-u-161a92f13ca\"] { color: rgb(0, 0, 0) !important; }[data-css=\"tve-u-161a92b4fd1\"] { float: none; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-161a924a60d\"] { margin-top: 29px !important; }[data-css=\"tve-u-161a9238651\"] + div { clear: none; }[data-css=\"tve-u-161a9238651\"] { float: none; width: 419px; margin-left: auto !important; margin-right: auto !important; }:not(#tve) [data-css=\"tve-u-161a91df77d\"] { color: rgb(0, 23, 255) !important; font-size: 38px !important; }[data-css=\"tve-u-161a91c891b\"] { margin-top: 31px !important; }[data-css=\"tve-u-161a91bb9e3\"] + div { clear: none; }[data-css=\"tve-u-161a91bb9e3\"] { float: none; width: 471px; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-161a9188602\"] { margin-top: 10px !important; margin-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-161a908242d\"] p, :not(#tve) [data-css=\"tve-u-161a908242d\"] li, :not(#tve) [data-css=\"tve-u-161a908242d\"] blockquote, :not(#tve) [data-css=\"tve-u-161a908242d\"] address, :not(#tve) [data-css=\"tve-u-161a908242d\"] h1, :not(#tve) [data-css=\"tve-u-161a908242d\"] h2, :not(#tve) [data-css=\"tve-u-161a908242d\"] h3, :not(#tve) [data-css=\"tve-u-161a908242d\"] h4, :not(#tve) [data-css=\"tve-u-161a908242d\"] h5, :not(#tve) [data-css=\"tve-u-161a908242d\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-161a9081265\"] { color: rgb(0, 0, 0); --tcb-local-color-icon: rgb(10,230,31); --tcb-local-color-var: rgb(10,230,31); --tve-icon-size: 20px; }[data-css=\"tve-u-161a9081264\"] { color: rgb(0, 0, 0); --tcb-local-color-icon: rgb(10,230,31); --tcb-local-color-var: rgb(10,230,31); --tve-icon-size: 20px; }[data-css=\"tve-u-161a908125f\"] { color: rgb(0, 0, 0); --tcb-local-color-icon: rgb(10,230,31); --tcb-local-color-var: rgb(10,230,31); --tve-icon-size: 20px; }[data-css=\"tve-u-161a9067dc2\"] + div { clear: none; }[data-css=\"tve-u-161a9067dc2\"] { float: none; width: 630px; border: 6px dotted rgba(234, 10, 213, 0.85); --tve-applied-border: 6px dotted rgba(234,10,213,0.85); --tve-border-width: 6px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; margin-left: auto !important; margin-right: auto !important; }:not(#tve) [data-css=\"tve-u-1609835db18\"] { font-size: 42px !important; color: rgb(255, 0, 0) !important; }[data-css=\"tve-u-161a8ff1c46\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-161a8ff1c47\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-161a9076395\"] p { margin: 0px !important; padding: 0px 0px 11px !important; }:not(#tve) [data-css=\"tve-u-161a9076399\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-161a9130196\"] p { margin: 0px !important; padding: 0px 0px 11px !important; }:not(#tve) [data-css=\"tve-u-161a9130198\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-161a91c4cb5\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-161a91c4cb7\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-161a91efe6f\"] p { margin: 0px !important; padding: 0px 0px 11px !important; }:not(#tve) [data-css=\"tve-u-161a91efe72\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-161a9244a3b\"] p { margin: 0px !important; padding: 0px 0px 11px !important; }:not(#tve) [data-css=\"tve-u-161a9244a3d\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-161a92bc52e\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-161a92bc531\"] { color: rgb(10, 0, 0) !important; }:not(#tve) [data-css=\"tve-u-161a92cefc3\"]:hover .tcb-button-link { color: rgb(255, 255, 255) !important; background-color: rgb(0, 23, 255) !important; }[data-css=\"tve-u-161a92cefc3\"] .tcb-button-link { border: 3px solid rgb(0, 23, 255); border-radius: 12px; overflow: hidden; background-image: none !important; background-color: rgb(255, 255, 255) !important; }:not(#tve) [data-css=\"tve-u-161a92cefc3\"] .tcb-button-link { color: rgb(0, 23, 255) !important; }[data-css=\"tve-u-161a92e386f\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-18b59ef6c45\"] { font-size: 38px !important; color: rgb(0, 9, 11) !important; --tcb-applied-color: rgb(0,9,11) !important; --tve-applied-color: rgb(0,9,11) !important; }:not(#tve) [data-css=\"tve-u-18b59f50b58\"] { font-size: 32px !important; color: rgb(0, 7, 8) !important; --tcb-applied-color: rgb(0,7,8) !important; --tve-applied-color: rgb(0,7,8) !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-161a8ff1c46\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a8ff1c46\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a8ff1c46\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a8ff1c46\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a8ff1c46\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a8ff1c46\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-161a8ff1c46\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-161a9076395\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9076395\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9076395\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9076395\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9076395\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9076395\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-161a9076395\"] { --tve-font-size: 20px; }:not(#tve) [data-css=\"tve-u-161a908242d\"] li { font-size: var(--tve-font-size,20px) !important; }[data-css=\"tve-u-161a908242d\"] { --tve-font-size: 20px; margin-top: 0px !important; }[data-css=\"tve-u-161a90940cd\"] { --tcb-local-color-icon: rgb(10,230,31); --tcb-local-color-var: rgb(10,230,31); --tve-icon-size: 20px; }[data-css=\"tve-u-161a90bcbaf\"] { --tcb-local-color-icon: rgb(10,230,31); --tcb-local-color-var: rgb(10,230,31); --tve-icon-size: 20px; }[data-css=\"tve-u-161a90ce7ec\"] { --tcb-local-color-icon: rgb(10,230,31); --tcb-local-color-var: rgb(10,230,31); --tve-icon-size: 20px; }[data-css=\"tve-u-161a90d44d1\"] { --tcb-local-color-icon: rgb(10,230,31); --tcb-local-color-var: rgb(10,230,31); --tve-icon-size: 20px; }:not(#tve) [data-css=\"tve-u-161a908125f\"] > :first-child { color: rgb(10, 230, 31); --tve-applied-color: rgb(10,230,31); }:not(#tve) [data-css=\"tve-u-161a9081264\"] > :first-child { color: rgb(10, 230, 31); --tve-applied-color: rgb(10,230,31); }:not(#tve) [data-css=\"tve-u-161a9081265\"] > :first-child { color: rgb(10, 230, 31); --tve-applied-color: rgb(10,230,31); }:not(#tve) [data-css=\"tve-u-161a90940cd\"] > :first-child { color: rgb(10, 230, 31); --tve-applied-color: rgb(10,230,31); }:not(#tve) [data-css=\"tve-u-161a90bcbaf\"] > :first-child { color: rgb(10, 230, 31); --tve-applied-color: rgb(10,230,31); }:not(#tve) [data-css=\"tve-u-161a90ce7ec\"] > :first-child { color: rgb(10, 230, 31); --tve-applied-color: rgb(10,230,31); }:not(#tve) [data-css=\"tve-u-161a90d44d1\"] > :first-child { color: rgb(10, 230, 31); --tve-applied-color: rgb(10,230,31); }[data-css=\"tve-u-18b5a0fc0fc\"] { margin-bottom: 10px !important; }[data-css=\"tve-u-18b5a10cf79\"] { background-image: linear-gradient(168deg,var(--tcb-local-color-6ba77) 0%,rgba(23,35,78,0) 100%,#000000 100%) !important; background-color: var(--tcb-local-color-19a93) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; }[data-css=\"tve-u-18b5a10cf77\"] { --tve-toc-indent: 25px; float: none; padding: 30px !important; margin-left: auto !important; margin-right: auto !important; --tcb-local-color-6ba77: var(--tcb-skin-color-0) !important; --tcb-local-color-19a93: rgb(59,203,247) !important; }[data-css=\"tve-u-18b5a10cf7d\"] { overflow: hidden; box-shadow: none; border: none !important; border-radius: 10px !important; }[data-css=\"tve-u-18b5a10cf7c\"] { padding: 0px !important; margin-bottom: 0px !important; margin-top: 20px !important; }:not(#tve) [data-css=\"tve-u-18b5a10cf7d\"] { background-image: none !important; }[data-css=\"tve-u-18b5a10cf7e\"] { --tve-font-size: 17px; font-size: var(--tve-font-size,17px); color: var(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; line-height: var(--tve-line-height,1.4em); --tve-line-height: 1.4em; padding: 5px 10px !important; margin-bottom: 10px !important; background-image: linear-gradient(rgba(0, 0, 0, 0.1), rgba(0, 0, 0, 0.1)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; margin-top: 10px !important; }:not(#tve) [data-css=\"tve-u-18b5a10cf7e\"]:hover { font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; text-decoration: var(--tve-text-decoration,none) !important; --tve-text-decoration: none !important; background-image: linear-gradient(rgba(0, 0, 0, 0.2), rgba(0, 0, 0, 0.2)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; --tve-applied-background-image: linear-gradient(rgba(0,0,0,0.2),rgba(0,0,0,0.2)) !important; }[data-css=\"tve-u-18b5a10cf80\"] { --tve-font-size: 17px; font-size: var(--tve-font-size,17px); color: var(--tve-color,rgba(255,255,255,0.8)); --tve-color: rgba(255,255,255,0.8); --tcb-applied-color: rgba(255,255,255,0.8); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; font-style: var(--tve-font-style,normal); --tve-font-style: normal; line-height: var(--tve-line-height,1.5em); --tve-line-height: 1.5em; padding: 3px 10px 3px 0px !important; }:not(#tve) [data-css=\"tve-u-18b5a10cf80\"]:hover { font-style: var(--tve-font-style,normal) !important; --tve-font-style: normal !important; color: var(--tve-color,rgb(255,255,255)) !important; --tve-color: rgb(255,255,255) !important; --tcb-applied-color: rgb(255,255,255) !important; --tve-applied-color: var$(--tve-color,rgb(255,255,255)) !important; --tve-applied---tve-color: rgb(255,255,255) !important; }[data-css=\"tve-u-18b5a10cf82\"] { --tve-font-size: 17px; font-size: var(--tve-font-size,17px); color: var(--tve-color,rgba(255,255,255,0.8)); --tve-color: rgba(255,255,255,0.8); --tcb-applied-color: rgba(255,255,255,0.8); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; font-style: var(--tve-font-style,normal); --tve-font-style: normal; line-height: var(--tve-line-height,1.5em); --tve-line-height: 1.5em; padding: 3px 10px 3px 0px !important; }:not(#tve) [data-css=\"tve-u-18b5a10cf82\"]:hover { font-style: var(--tve-font-style,normal) !important; --tve-font-style: normal !important; color: var(--tve-color,rgb(255,255,255)) !important; --tve-color: rgb(255,255,255) !important; --tcb-applied-color: rgb(255,255,255) !important; }[data-css=\"tve-u-18b5a10cf7a\"] { --tve-color: rgb(255,255,255); --tve-applied---tve-color: rgb(255,255,255); margin-top: 0px !important; margin-bottom: 0px !important; padding: 0px !important; }[data-css=\"tve-u-18b5a10cf7a\"].tve-state-expanded { --animation-angle: 180deg; }[data-css=\"tve-u-18b5a10cf7b\"] { line-height: 1.5em !important; }[data-css=\"tve-u-18b5a10cf78\"] .tve_sep { background-image: linear-gradient(rgba(217, 217, 217, 0), rgba(217, 217, 217, 0)) !important; width: 1px !important; --tve-applied-background-image: linear-gradient(rgba(217,217,217,0),rgba(217,217,217,0)) !important; }:not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] p, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] li, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] blockquote, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] address, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] .tcb-plain-text, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] label, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] h1, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] h2, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] h3, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] h4, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] h5, :not(#tve) [data-css=\"tve-u-18b5a10cf7a\"] h6 { color: var(--tve-color,rgb(255,255,255)); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tcb-applied-color: rgb(255,255,255); }[data-css=\"tve-u-18b5a10cf7a\"] .tve-toc-title-icon { font-size: 22px !important; width: 22px !important; height: 22px !important; color: rgba(255, 255, 255, 0.8) !important; --tve-applied-color: rgba(255,255,255,0.8) !important; }[data-css=\"tve-u-18b5a10cf7a\"].tve-state-expanded .tve-toc-title-icon { color: rgb(255, 255, 255) !important; --tve-applied-color: rgb(255,255,255) !important; }:not(#tve) [data-css=\"tve-u-18b5a10cf7a\"]:hover:not(.tve-state-expanded) .tve-toc-title-icon { color: rgb(255, 255, 255) !important; --tve-applied-color: rgb(255,255,255) !important; }[data-css=\"tve-u-18b5a10cf7f\"] { font-size: 11px; width: 11px; height: 11px; --tve-icon-size: 11px; padding: 0px !important; }[data-css=\"tve-u-18b5a10cf81\"] { font-size: 11px; width: 11px; height: 11px; --tve-icon-size: 11px; padding: 0px !important; }[data-css=\"tve-u-18b5a10cf84\"] { font-size: 11px; width: 11px; height: 11px; --tve-icon-size: 11px; padding: 0px !important; }[data-css=\"tve-u-173dc808bfe\"] { padding: 0px !important; }[data-css=\"tve-u-17399ecbfc9\"] { padding: 0px !important; }[data-css=\"tve-u-173dc81164c\"] { padding: 0px !important; }[data-css=\"tve-u-18b5a10cf7e\"].tve-state-expanded { background-image: linear-gradient(rgba(0, 0, 0, 0.2), rgba(0, 0, 0, 0.2)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; --tve-applied-background-image: linear-gradient(rgba(0,0,0,0.2),rgba(0,0,0,0.2)) !important; }:not(#tve) [data-css=\"tve-u-18b5a10cf7b\"] { font-size: 32px !important; }[data-css=\"tve-u-18b5a10cf80\"].tve-state-expanded { color: var(--tve-color,rgb(255,255,255)); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tve-applied---tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); background-color: rgba(255, 255, 255, 0.05) !important; --tve-applied-background-color: rgba(255,255,255,0.05) !important; }[data-css=\"tve-u-18b5a10cf82\"].tve-state-expanded { color: var(--tve-color,rgb(255,255,255)); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tve-applied---tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); background-color: rgba(255, 255, 255, 0.05) !important; --tve-applied-background-color: rgba(255,255,255,0.05) !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-161a9130196\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9130196\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9130196\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9130196\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9130196\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9130196\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-161a9130196\"] { --tve-font-size: 20px; }[data-css=\"tve-u-18b5a171f71\"] { margin-top: 10px !important; margin-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-18b5a190324\"] { font-size: 38px !important; color: rgb(0, 7, 8) !important; --tcb-applied-color: rgb(0,7,8) !important; --tve-applied-color: rgb(0,7,8) !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-161a91efe6f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a91efe6f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a91efe6f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a91efe6f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a91efe6f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a91efe6f\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-161a91efe6f\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-161a9244a3b\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9244a3b\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9244a3b\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9244a3b\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9244a3b\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-161a9244a3b\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-161a9244a3b\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18b5a44334c\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a44334c\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18b5a44334c\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18b5a443352\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 0px !important; }[data-css=\"tve-u-18b5a474d87\"] .tcb-button-link { letter-spacing: 2px; background-image: linear-gradient(var(--tcb-local-color-62516,rgb(19,114,211)),var(--tcb-local-color-62516,rgb(19,114,211))); --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-62516,rgb(19,114,211)),var$(--tcb-local-color-62516,rgb(19,114,211))); background-size: auto; background-attachment: scroll; border-radius: 5px; padding: 18px; background-position: 50% 50%; background-repeat: no-repeat; background-color: transparent !important; }[data-css=\"tve-u-18b5a474d87\"] .tcb-button-link span { color: rgb(255, 255, 255); --tcb-applied-color: #fff; }[data-css=\"tve-u-18b5a474d87\"] { --tcb-local-color-62516: var(--tcb-skin-color-0) !important; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-18b5a529a31\"] { width: 325px; --tve-alignment: center; float: none; border: 4px dashed rgba(13, 5, 241, 0.85); --tve-applied-border: 4px dashed rgba(13,5,241,0.85); --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; --tve-border-width: 4px; margin: 0px auto 10px !important; }:not(#tve) [data-css=\"tve-u-18b5a59d90b\"] { font-size: 32px !important; color: rgb(0, 10, 12) !important; --tcb-applied-color: rgb(0,10,12) !important; --tve-applied-color: rgb(0,10,12) !important; }:not(#tve) [data-css=\"tve-u-18b5a5a4019\"] { font-size: 32px !important; color: rgb(0, 4, 5) !important; --tcb-applied-color: rgb(0,4,5) !important; --tve-applied-color: rgb(0,4,5) !important; }:not(#tve) [data-css=\"tve-u-18b5a5a91e1\"] { font-size: 32px !important; color: rgb(0, 8, 9) !important; --tcb-applied-color: rgb(0,8,9) !important; --tve-applied-color: rgb(0,8,9) !important; }:not(#tve) [data-css=\"tve-u-18b5a5ad267\"] { font-size: 32px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18b5a65bb7f\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18b5a65bb7f\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18b5a65bb7f\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18b5a65bb83\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 10px !important; padding-bottom: 10px !important; }[data-css=\"tve-u-18b5a79e376\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20id%3D'tcb-0.18500288971763812'%20viewBox%3D%220%200%20325%20108%22%20xmlns%3D'http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg'%20preserveAspectRatio%3D'none'%3E%0A%09%09%20%20%20%20%20%20%20%3Cstyle%3E%0A%09%09%09%09%2F*%20for%20an%20explanation%20of%20how%20the%20delay%20works%20%40see%20crossed-lines.js%20*%2F%0A%09%09%20%20%20%20%20%20%20%40keyframes%20draw-animation-first-line%20%7B%20%0A%09%09%09%09%090%25%20%7B%20stroke-dashoffset%3A%20286.13px%3B%20stroke-dasharray%3A%20286.13px%3B%20%7D%20%0A%09%09%09%09%0925%25%20%7B%20stroke-dashoffset%3A%200%3B%20stroke-dasharray%3A%20286.13px%3B%20%7D%20%0A%09%09%09%09%7D%0A%09%09%09%09%40keyframes%20draw-animation-second-line%20%7B%20%0A%09%09%09%09%090%25%20%7B%20stroke-dashoffset%3A%20287.59px%3B%20stroke-dasharray%3A%20287.59px%3B%20%7D%20%0A%09%09%09%09%0925%25%20%7B%20stroke-dashoffset%3A%20287.59px%3B%20stroke-dasharray%3A%20287.59px%3B%20%7D%20%0A%09%09%09%09%0950%25%20%7B%20stroke-dashoffset%3A%200%3B%20stroke-dasharray%3A%20287.59px%3B%20%7D%20%0A%09%09%09%09%7D%0A%09%09%20%20%20%20%20%20%20.first%20%7B%20%0A%09%09%20%20%20%20%20%20%20%09%09animation%3A%20draw-animation-first-line%20forwards%3B%20%0A%09%09%20%20%20%20%20%20%20%7D%0A%09%09%20%20%20%20%20%20%20.second%20%7B%0A%09%09%20%20%20%20%20%20%20%09%09animation%3A%20draw-animation-second-line%20forwards%3B%20%0A%09%09%20%20%20%20%20%20%20%7D%0A%09%09%09%09.first%2C%20.second%20%7B%20animation-duration%3A%202s%3B%20animation-iteration-count%3A%20infinite%20%7D%0A%09%09%20%20%20%20%20%20%20%3C%2Fstyle%3E%0A%09%09%09%09%3Cg%20fill%3D%22none%22%20stroke%3D%22red%22%20stroke-linecap%3D%22round%22%20stroke-linejoin%3D%22round%22%20stroke-width%3D%224%22%3E%0A%09%09%09%09%09%3Cpath%20class%3D%22first%22%20d%3D%22M31%2085c54.144-2.667%20100.777-4%20139.9-4%2039.125%200%2087.824%201.333%20146.1%204%22%2F%3E%0A%09%09%09%09%09%3Cpath%20class%3D%22second%22%20d%3D%22M9%2097c42.388-4.758%2087.512-7.403%20135.372-7.933C192.232%2088.536%20242.775%2091.18%20296%2097%22%2F%3E%0A%09%09%09%09%3C%2Fg%3E%0A%09%09%20%20%20%20%20%20%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: rgb(221,236,5) !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-195055c10fd\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-195055c10fd\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-195055c10fd\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-195055c10fe\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-195055c10ff\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-195055c1100\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-195055c1101\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-195055c1102\"] { --tcb-text-highlight-color: rgb(30, 184, 76) !important; }[data-css=\"tve-u-195055c1103\"] { --tcb-text-highlight-color: transparent !important; }}@media (max-width: 767px){:not(#tve) [data-css=\"tve-u-161a9309e59\"] { font-size: 17px !important; }:not(#tve) [data-css=\"tve-u-161a91df77d\"] { font-size: 22px !important; }:not(#tve) [data-css=\"tve-u-1609835db18\"] { font-size: 25px !important; }[data-css=\"tve-u-18b5a10cf77\"] { --tve-toc-indent: 8px; padding: 15px !important; }[data-css=\"tve-u-18b5a10cf7e\"] { line-height: var(--tve-line-height,1.4em); --tve-line-height: 1.4em; }[data-css=\"tve-u-18b5a10cf80\"] { line-height: var(--tve-line-height,1.4em); --tve-line-height: 1.4em; padding-top: 5px !important; padding-bottom: 5px !important; }[data-css=\"tve-u-18b5a10cf82\"] { line-height: var(--tve-line-height,14px); --tve-line-height: 14px; padding-top: 5px !important; padding-bottom: 5px !important; }[data-css=\"tve-u-18b5a10cf7a\"].tve-state-expanded .tve-toc-title-icon { font-size: 20px !important; width: 20px !important; height: 20px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[1],"tags":[321,253,66],"class_list":["post-23732","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-y-contabilidad","tag-control-de-cuentas-por-cobrar","tag-cuentas-por-cobrar","tag-excel","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/23732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=23732"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/23732\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/33599"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=23732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=23732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=23732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}