{"id":238,"date":"2017-04-05T18:09:10","date_gmt":"2017-04-05T18:09:10","guid":{"rendered":"http:\/\/jesquina.com.br\/site\/?p=238"},"modified":"2019-03-02T15:54:47","modified_gmt":"2019-03-02T15:54:47","slug":"controle-de-compras","status":"publish","type":"post","link":"https:\/\/jesquina.com.br\/site\/controle-de-compras\/","title":{"rendered":"CONTROLE DE COMPRAS"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-316\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/ABERTURA-BLOG-1024x200.jpg\" alt=\"\" width=\"605\" height=\"118\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/ABERTURA-BLOG-1024x200.jpg 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/ABERTURA-BLOG-300x59.jpg 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/ABERTURA-BLOG-768x150.jpg 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/ABERTURA-BLOG-100x20.jpg 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/ABERTURA-BLOG-150x29.jpg 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/ABERTURA-BLOG-200x39.jpg 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/ABERTURA-BLOG-450x88.jpg 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/ABERTURA-BLOG-600x117.jpg 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/ABERTURA-BLOG-900x176.jpg 900w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>Nesta p\u00e1gina voc\u00ea poder\u00e1 baixar a planilha modelo para fazer o controle de compras da sua empresa.<\/p>\n<h3 style=\"text-align: center;\"><\/h3>\n<p style=\"text-align: center;\"><a href=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/CONTROLE-DE-COMPRAS-MODELO.xlsx\">DOWNLOAD DA PLANILHA &#8211; MODELO<\/a><\/p>\n<p><iframe loading=\"lazy\" title=\"CONTROLE DE COMPRAS ABERTURA\" width=\"605\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/waJzFJq835I?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><br \/>\n<iframe loading=\"lazy\" title=\"CONTROLE DE COMPRAS - COMO FUNCIONA\" width=\"605\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/Tu8WpGr2koQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><br \/>\n<iframe loading=\"lazy\" title=\"CONTROLE DE COMPRAS - EXEMPLO DE USO\" width=\"605\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/XOC9AenBSsE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h4 style=\"text-align: center;\"><\/h4>\n<h4 style=\"text-align: center;\">APRESENTA\u00c7\u00c3O DA PLANILHA<\/h4>\n<p>Esta planilha \u00e9 um modelo simplificado de controle de compras desenvolvida com o prop\u00f3sito de ajudar voc\u00ea a ter, diariamente, uma vis\u00e3o geral da situa\u00e7\u00e3o financeira do seu neg\u00f3cio.<\/p>\n<p>&nbsp;<\/p>\n<h4 style=\"text-align: center;\">INSER\u00c7\u00c3O DA DATA INICIAL<img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-253 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-03.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/h4>\n<p>O primeiro passo \u00e9 inserir nesta coluna o primeiro dia do m\u00eas de apura\u00e7\u00e3o, a planilha vai completar automaticamente os dias seguintes, identificando os dias da semana com destaque nos s\u00e1bados e domingos.<\/p>\n<p>Neste modelo n\u00f3s estamos considerando o s\u00e1bado como meio dia trabalhado para contagem dos dias \u00fateis do m\u00eas.<\/p>\n<p>Tamb\u00e9m n\u00e3o consideramos os feriados neste exemplo.<\/p>\n<h4 style=\"text-align: center;\">ALIMENTA\u00c7\u00c3O DI\u00c1RIA<\/h4>\n<p>Para alimentar a planilha voc\u00ea tem que anotar diariamente os dados referentes ao movimento da sua empresa;<\/p>\n<p>Na coluna \u201cFATURAMENTO DO DIA\u201d, s\u00e3o lan\u00e7adas somente as vendas realizadas no dia, independente da forma de pagamento. Os recebimentos de parcelas do contas a receber n\u00e3o s\u00e3o lan\u00e7ados, porque recebimento n\u00e3o \u00e9 faturamento.<\/p>\n<p>Se eventualmente voc\u00ea n\u00e3o trabalhou em um dia espec\u00edfico, basta n\u00e3o lan\u00e7ar valores, a planilha vai considerar como dia n\u00e3o trabalhado.<img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-254 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-04.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>Na outra coluna \u201cCOMPRAS DO DIA\u201d\u00a0 lan\u00e7amos somente as compras de mercadorias para reposi\u00e7\u00e3o de vendas feitas no dia, independente se foram pagas a vista ou n\u00e3o.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-258 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-05.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>Na coluna \u201cGASTOS DO DIA\u201d s\u00e3o lan\u00e7adas todas as despesas que foram pagas no dia, chamamos de desembolso, nelas inclu\u00edmos todas as categorias; sal\u00e1rios, aluguel, luz, fornecedores, telefone, fretes, etc.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-259 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-06.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<h4 style=\"text-align: center;\">MOVIMENTO ACUMULADO<\/h4>\n<p>Enquanto voc\u00ea est\u00e1 lan\u00e7ando os dados do dia a dia, a planilha vai fazendo uma s\u00e9rie de c\u00e1lculos em tempo real lhe dando uma posi\u00e7\u00e3o em tempo real de como est\u00e1 o seu caixa.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-260 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-07.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>Come\u00e7amos pelo \u2018FATURAMENTO ACUMULADO\u201d neste campo a planilha soma todos os valores que aparecem na coluna \u201cFATURAMENTO DO DIA\u201d.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-261 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-08.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>Logo abaixo temos as \u201cCOMPRAS ACUMULADAS\u201d que \u00e9 a soma de todos os valores lan\u00e7ados na coluna \u2018COMPRAS DO DIA\u201d, ao lado aparece o percentual que as compras representam sobre o faturamento no momento.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-262 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-09.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>A mesma coisa acontece com os GASTOS ACUMULADOS, onde s\u00e3o somados os valores da coluna \u201cGASTOS DO DIA\u201d, ao lado tamb\u00e9m aparece o percentual que os gastos representam sobre o faturamento no momento.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-263 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-10.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>Logo abaixo aparece a margem de lucro ou preju\u00edzo que est\u00e1 acontecendo no momento. O percentual que aparece ao lado \u00e9 calculado sobre a varia\u00e7\u00e3o dos percentuais de compras e gastos levando-se em conta a regra 60-30-10.<\/p>\n<p>Vamos demonstrar;<\/p>\n<p>A soma dos percentuais sempre ser\u00e1 100%, portanto o lucro ou preju\u00edzo \u00e9 calculado da seguinte f\u00f3rmula;<\/p>\n<p>100% &#8211; 60%(compras)-30%(gastos)<\/p>\n<p>Como os valores das compras e dos gastos variam o durante o m\u00eas, o percentual de lucro ou preju\u00edzo tamb\u00e9m vai variar na mesma propor\u00e7\u00e3o.<\/p>\n<p>Lembre-se que a meta \u00e9 60-30-10<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-264 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-12.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<h4 style=\"text-align: center;\">DIAS CORRIDOS<\/h4>\n<p>Neste outro quadro a planilha mostra os dias decorridos do m\u00eas;<\/p>\n<p>Os dias \u00fateis s\u00e3o calculados com base nas datas geradas pela planilha para o per\u00edodo de apura\u00e7\u00e3o. Neste c\u00e1lculo consideramos os s\u00e1bados como meio dia de trabalho porque \u00e9 um padr\u00e3o do com\u00e9rcio, os domingos n\u00e3o s\u00e3o considerados dias \u00fateis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-265 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-13.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>J\u00e1 os dias decorridos s\u00e3o calculados atrav\u00e9s da contagem onde os valores da coluna \u201cFATURAMENTO DO DIA\u201d s\u00e3o maiores que zero. \u00a0Se por alguma raz\u00e3o n\u00e3o houver faturamento em um dia \u00fatil, voc\u00ea ter\u00e1 que compensar nos dias seguintes para n\u00e3o perder a paridade dos dados.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-267 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-14.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>Os DIAS RESTANTES mostram quantos dias \u00fateis voc\u00ea ainda tem para vender no m\u00eas, a planilha calcula fazendo uma subtra\u00e7\u00e3o dos dias decorridos dos dias \u00fateis calculados.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-268 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-15.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<h4 style=\"text-align: center;\">PROJE\u00c7\u00c3O PARA FINAL DO M\u00caS<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-269 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-16.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>Para complementar a an\u00e1lise, a planilha faz uma proje\u00e7\u00e3o dos resultados para o final do per\u00edodo, assim voc\u00ea pode o tempo todo saber qual ser\u00e1 a situa\u00e7\u00e3o do caixa no final do m\u00eas, isto com base nos dados acumulados at\u00e9 o momento.<\/p>\n<p>&nbsp;<\/p>\n<h4 style=\"text-align: center;\">C\u00c1LCULO DO FATURAMENTO<\/h4>\n<p>A proje\u00e7\u00e3o do faturamento \u00e9 feita com base no valor acumulado usando a seguinte f\u00f3rmula;<\/p>\n<p>FATURAMENTO ACUMULADO \/ DIAS DECORRIDOS\u00a0 * DIAS RESTANTES + FATURAMENTO ACUMULADO.<\/p>\n<p>Demonstrando a f\u00f3rmula, temos a m\u00e9dia de faturamento di\u00e1ria at\u00e9 hoje,\u00a0 multiplicada\u00a0 pelos dias restantes e somado com o montante j\u00e1 faturado at\u00e9 agora.<\/p>\n<p>O resultado ser\u00e1 uma previs\u00e3o do faturamento bruto da empresa no m\u00eas de apura\u00e7\u00e3o. Este valor vai variar o tempo todo em raz\u00e3o das vara\u00e7\u00f5es de faturamento, compras e gastos.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-270 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-17.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4 style=\"text-align: center;\">PREVIS\u00c3O DAS COMPRAS<\/h4>\n<p>A previs\u00e3o das compras para o m\u00eas segue a regra, ou seja, aplica-se o percentual alcan\u00e7ado nas compras sobre a previs\u00e3o de faturamento.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-272 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-18.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<h4 style=\"text-align: center;\">PREVIS\u00c3O DE GASTOS<\/h4>\n<p>Para a previs\u00e3o de gastos usamos a mesma f\u00f3rmula, ou seja, aplica-se o percentual alcan\u00e7ado dos gastos sobre a previs\u00e3o de faturamento.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-273 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-19.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<h4 style=\"text-align: center;\">LIMITE DE COMPRAS PARA O M\u00caS<\/h4>\n<p>A planilha ainda mostra o tempo todo qual o limite que voc\u00ea tem para comprar at\u00e9 o final do m\u00eas, este limite tamb\u00e9m varia em fun\u00e7\u00e3o do movimento di\u00e1rio, ele serve como refer\u00eancia para poder analisar poss\u00edveis compras fora do padr\u00e3o.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-274 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-20.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<h4 style=\"text-align: center;\">ALERTAS<\/h4>\n<p>Esta duas janelas mostram o tempo todo em que situa\u00e7\u00e3o voc\u00ea est\u00e1 trabalhando, toda vez que os percentuais de compras ou gastos forem superiores ao limite da regra, as janela mudam de cor e mostram os \u00edndices fora do padr\u00e3o, neste momento deve-se reavaliar as despesas e as compras para que os valores voltem ao n\u00edvel aceit\u00e1vel da regra.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-275 aligncenter\" src=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22-1024x576.png\" alt=\"\" width=\"605\" height=\"340\" srcset=\"https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22-1024x576.png 1024w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22-300x169.png 300w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22-768x432.png 768w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22-100x56.png 100w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22-150x84.png 150w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22-200x113.png 200w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22-450x253.png 450w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22-600x338.png 600w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22-900x506.png 900w, https:\/\/jesquina.com.br\/site\/wp-content\/uploads\/2017\/04\/GC-PLANILHA-22.png 1280w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nesta p\u00e1gina voc\u00ea poder\u00e1 baixar a planilha modelo para fazer o controle de compras da sua empresa. DOWNLOAD DA PLANILHA &#8211; MODELO APRESENTA\u00c7\u00c3O DA PLANILHA Esta planilha \u00e9 um modelo simplificado de controle de compras desenvolvida com o prop\u00f3sito de &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/jesquina.com.br\/site\/controle-de-compras\/\"> <span class=\"screen-reader-text\">CONTROLE DE COMPRAS<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-238","post","type-post","status-publish","format-standard","hentry","category-objetos"],"_links":{"self":[{"href":"https:\/\/jesquina.com.br\/site\/wp-json\/wp\/v2\/posts\/238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jesquina.com.br\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jesquina.com.br\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jesquina.com.br\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jesquina.com.br\/site\/wp-json\/wp\/v2\/comments?post=238"}],"version-history":[{"count":18,"href":"https:\/\/jesquina.com.br\/site\/wp-json\/wp\/v2\/posts\/238\/revisions"}],"predecessor-version":[{"id":404,"href":"https:\/\/jesquina.com.br\/site\/wp-json\/wp\/v2\/posts\/238\/revisions\/404"}],"wp:attachment":[{"href":"https:\/\/jesquina.com.br\/site\/wp-json\/wp\/v2\/media?parent=238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jesquina.com.br\/site\/wp-json\/wp\/v2\/categories?post=238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jesquina.com.br\/site\/wp-json\/wp\/v2\/tags?post=238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}