Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
EXERCÍCIO EXERCÍCIO 8 OS PAGAMENTOS E RECEBIMENTOS SÃO ALIMENTADOS NO EXTRATO GERENCIAL 8 MONTAR FLUXO DE CAIXA DIÁRIO / MENSAL 8 CÉLULA "D2" - DIÁRIO => ESCOLHA O MÊS => ALIMENTAR OS DEMAIS DIAS AUTOMATICAMENTE + DIA DA SEMANA 8 AS INFORMAÇÕES SERÃO ALIMENTADAS DE ACORDO COM A "CONTA" E "DIA" 8 AGRUPAR POR ENTRADA / SAÍDA DIÁRIO FLUXO DE CAIXA SALDO INICIAL SALÁRIO 0.0 13 SAL / FÉRIAS 0.0 JUROS 0.0 OUTROS 0.0 ENTRADAS 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 VISA 0.0 ALUGUEL APTO 0.0 CONDOMÍNIO APTO 0.0 DIARISTA 0.0 SKY 0.0 GVT - INTERNET 0.0 TIM 0.0 CELPE 0.0 ABA 0.0 GINÁSTICA 0.0 BALLET 0.0 ESCOLA 0.0 MATERIAL ESCOLAR 0.0 TRANSPORTE 0.0 TARIFA 0.0 IPTU 0.0 IPVA 0.0 SEGURO 0.0 IMOBILIZADO 0.0 SAÍDAS 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 MOVIMENTO 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 APLICAÇÃO 0.0 RETIRADA 0.0 MOV INVESTIMENTO 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 SALDO FINAL 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1-Dec-12 1-Jan-13 1-Feb-13 1-Mar-13 1-Apr-13 1-May-13 1-Jun-13 1-Jul-13 1-Aug-13 1-Sep-13 1-Oct-13 1-Nov-13 1-Dec-13 1-Jan-14 1-Feb-14 1-Mar-14 1-Apr-14 1-May-14 1-Jun-14 1-Jul-14 1-Aug-14 1-Sep-14 1-Oct-14 1-Nov-14 1-Dec-14 1-Jan-15 1-Feb-15 1-Mar-15 1-Apr-15 1-May-15 1-Jun-15 1-Jul-15 1-Aug-15 1-Sep-15 1-Oct-15 1-Nov-15 1-Dec-15 1-Jan-16 1-Feb-16 1-Mar-16 1-Apr-16 1-May-16 1-Jun-16 1-Jul-16 1-Aug-16 1-Sep-16 1-Oct-16 1-Nov-16 1-Dec-16 1-Jan-17 1-Feb-17 1-Mar-17 1-Apr-17 1-May-17 1-Jun-17 1-Jul-17 1-Aug-17 1-Sep-17 1-Oct-17 1-Nov-17 1-Dec-17 1-Jan-18 1-Feb-18 1-Mar-18 1-Apr-18 1-May-18 1-Jun-18 1-Jul-18 1-Aug-18 1-Sep-18 1-Oct-18 1-Nov-18 1-Dec-18 1-Jan-19 1-Feb-19 1-Mar-19 1-Apr-19 1-May-19 1-Jun-19 1-Jul-19 1-Aug-19 1-Sep-19 1-Oct-19 1-Nov-19 1-Dec-19 1-Jan-20 1-Feb-20 1-Mar-20 1-Apr-20 1-May-20 1-Jun-20 1-Jul-20 1-Aug-20 1-Sep-20 1-Oct-20 1-Nov-20 1-Dec-20 1-Jan-21 1-Feb-21 1-Mar-21 1-Apr-21 1-May-21 1-Jun-21 1-Jul-21 1-Aug-21 1-Sep-21 1-Oct-21 1-Nov-21 1-Dec-21 1-Jan-22 1-Feb-22 1-Mar-22 1-Apr-22 1-May-22 1-Jun-22 1-Jul-22 1-Aug-22 1-Sep-22 1-Oct-22 1-Nov-22 1-Dec-22 1-Jan-23 1-Feb-23 1-Mar-23 1-Apr-23 MENSAL FLUXO DE CAIXA December-13 SALDO INICIAL SALÁRIO 13 SAL / FÉRIAS JUROS OUTROS ENTRADAS 0.0 0.0 0.0 0.0 VISA ALUGUEL APTO CONDOMÍNIO APTO DIARISTA SKY GVT - INTERNET TIM CELPE ABA GINÁSTICA BALLET ESCOLA MATERIAL ESCOLAR TRANSPORTE TARIFA IPTU IPVA SEGURO IMOBILIZADO SAÍDAS 0.0 0.0 0.0 0.0 MOVIMENTO 0.0 0.0 0.0 0.0 APLICAÇÃO RETIRADA MOV INVESTIMENTO 0.0 0.0 0.0 0.0 SALDO FINAL 0.0 0.0 0.0 0.0 1-Dec-12 1-Jan-13 1-Feb-13 1-Mar-13 1-Apr-13 1-May-13 1-Jun-13 1-Jul-13 1-Aug-13 1-Sep-13 1-Oct-13 1-Nov-13 1-Dec-13 1-Jan-14 1-Feb-14 1-Mar-14 1-Apr-14 1-May-14 1-Jun-14 1-Jul-14 1-Aug-14 1-Sep-14 1-Oct-14 1-Nov-14 1-Dec-14 1-Jan-15 1-Feb-15 1-Mar-15 1-Apr-15 1-May-15 1-Jun-15 1-Jul-15 1-Aug-15 1-Sep-15 1-Oct-15 1-Nov-15 1-Dec-15 1-Jan-16 1-Feb-16 1-Mar-16 1-Apr-16 1-May-16 1-Jun-16 1-Jul-16 1-Aug-16 1-Sep-16 1-Oct-16 1-Nov-16 1-Dec-16 1-Jan-17 1-Feb-17 1-Mar-17 1-Apr-17 1-May-17 1-Jun-17 1-Jul-17 1-Aug-17 1-Sep-17 1-Oct-17 1-Nov-17 1-Dec-17 1-Jan-18 1-Feb-18 1-Mar-18 1-Apr-18 1-May-18 1-Jun-18 1-Jul-18 1-Aug-18 1-Sep-18 1-Oct-18 1-Nov-18 1-Dec-18 1-Jan-19 1-Feb-19 1-Mar-19 1-Apr-19 1-May-19 1-Jun-19 1-Jul-19 1-Aug-19 1-Sep-19 1-Oct-19 1-Nov-19 1-Dec-19 1-Jan-20 1-Feb-20 1-Mar-20 1-Apr-20 1-May-20 1-Jun-20 1-Jul-20 1-Aug-20 1-Sep-20 1-Oct-20 1-Nov-20 1-Dec-20 1-Jan-21 1-Feb-21 1-Mar-21 1-Apr-21 1-May-21 1-Jun-21 1-Jul-21 1-Aug-21 1-Sep-21 1-Oct-21 1-Nov-21 1-Dec-21 1-Jan-22 1-Feb-22 1-Mar-22 1-Apr-22 1-May-22 1-Jun-22 1-Jul-22 1-Aug-22 1-Sep-22 1-Oct-22 1-Nov-22 1-Dec-22 1-Jan-23 1-Feb-23 1-Mar-23 1-Apr-23 EXTRATO GERENCIAL Apoio 2 DATA PAGAMENTO DATA PREVISÃO CONTA DESCRIÇÃO VALOR SALDO ACUMULADO 1-Dec-13 1-Dec-13 SALDO INICIAL 2,500.00 2,500.00 1-Dec-13 3-Dec-13 SALÁRIO 5,000.00 7,500.00 1-Dec-13 3-Dec-13 13 SAL / FÉRIAS 2,343.00 9,843.00 1-Dec-13 4-Dec-13 JUROS 100.00 9,943.00 1-Dec-13 4-Dec-13 OUTROS 2,000.00 11,943.00 1-Dec-13 4-Dec-13 VISA ( 1,000.00 ) 10,943.00 1-Dec-13 4-Dec-13 ALUGUEL APTO ( 800.00 ) 10,143.00 1-Dec-13 5-Dec-13 CONDOMÍNIO APTO ( 40.00 ) 10,103.00 1-Dec-13 5-Dec-13 DIARISTA ( 568.15 ) 9,534.85 1-Dec-13 5-Dec-13 SKY ( 164.57 ) 9,370.28 1-Dec-13 5-Dec-13 GVT - INTERNET ( 120.00 ) 9,250.28 1-Dec-13 5-Dec-13 TIM ( 300.00 ) 8,950.28 1-Dec-13 6-Dec-13 CELPE ( 140.00 ) 8,810.28 1-Dec-13 10-Dec-13 ABA ( 200.00 ) 8,610.28 1-Dec-13 10-Dec-13 GINÁSTICA ( 232.00 ) 8,378.28 1-Dec-13 10-Dec-13 BALLET ( 208.67 ) 8,169.61 1-Dec-13 10-Dec-13 ESCOLA ( 60.00 ) 8,109.61 1-Dec-13 10-Dec-13 MATERIAL ESCOLAR ( 200.00 ) 7,909.61 1-Dec-13 10-Dec-13 TRANSPORTE ( 100.00 ) 7,809.61 1-Dec-13 13-Dec-13 TARIFA ( 150.00 ) 7,659.61 1-Dec-13 17-Dec-13 IPTU ( 60.00 ) 7,599.61 1-Dec-13 17-Dec-13 IPVA ( 50.00 ) 7,549.61 1-Dec-13 17-Dec-13 SEGURO ( 146.40 ) 7,403.21 1-Dec-13 17-Dec-13 APLICAÇÃO ( 3,000.00 ) 4,403.21 1-Dec-13 31-Dec-13 RETIRADA 4,403.21 1-Jan-14 1-Jan-14 SALDO INICIAL 4,403.21 4,403.21 1-Jan-14 3-Jan-14 SALÁRIO 5,000.00 9,403.21 1-Jan-14 5-Jan-14 13 SAL / FÉRIAS 9,403.21 1-Jan-14 7-Jan-14 JUROS 100.00 9,503.21 1-Jan-14 9-Jan-14 OUTROS 2,000.00 11,503.21 1-Jan-14 11-Jan-14 VISA ( 1,000.00 ) 10,503.21 1-Jan-14 13-Jan-14 ALUGUEL APTO ( 800.00 ) 9,703.21 1-Jan-14 15-Jan-14 CONDOMÍNIO APTO ( 40.00 ) 9,663.21 1-Jan-14 17-Jan-14 DIARISTA ( 568.15 ) 9,095.06 1-Jan-14 19-Jan-14 SKY ( 164.57 ) 8,930.49 1-Jan-14 21-Jan-14 GVT - INTERNET ( 120.00 ) 8,810.49 1-Jan-14 23-Jan-14 TIM ( 300.00 ) 8,510.49 1-Jan-14 25-Jan-14 CELPE ( 140.00 ) 8,370.49 1-Jan-14 14-Jan-14 ABA ( 200.00 ) 8,170.49 1-Jan-14 16-Jan-14 GINÁSTICA ( 232.00 ) 7,938.49 1-Jan-14 18-Jan-14 BALLET ( 208.67 ) 7,729.82 1-Jan-14 20-Jan-14 ESCOLA ( 60.00 ) 7,669.82 1-Jan-14 22-Jan-14 MATERIAL ESCOLAR ( 200.00 ) 7,469.82 1-Jan-14 24-Jan-14 TRANSPORTE ( 100.00 ) 7,369.82 1-Jan-14 16-Jan-14 TARIFA ( 150.00 ) 7,219.82 1-Jan-14 18-Jan-14 IPTU ( 60.00 ) 7,159.82 1-Jan-14 20-Jan-14 IPVA ( 50.00 ) 7,109.82 1-Jan-14 22-Jan-14 SEGURO ( 146.40 ) 6,963.42 1-Jan-14 24-Jan-14 APLICAÇÃO ( 3,000.00 ) 3,963.42 1-Jan-14 26-Jan-14 RETIRADA 3,963.42 1-Feb-14 1-Feb-14 SALDO INICIAL 3,963.42 3,963.42 1-Feb-14 3-Feb-14 SALÁRIO 5,000.00 8,963.42 1-Feb-14 5-Feb-14 13 SAL / FÉRIAS 8,963.42 1-Feb-14 7-Feb-14 JUROS 100.00 9,063.42 1-Feb-14 9-Feb-14 OUTROS 2,000.00 11,063.42 1-Feb-14 11-Feb-14 VISA ( 1,000.00 ) 10,063.42 1-Feb-14 13-Feb-14 ALUGUEL APTO ( 800.00 ) 9,263.42 1-Feb-14 15-Feb-14 CONDOMÍNIO APTO ( 40.00 ) 9,223.42 1-Feb-14 17-Feb-14 DIARISTA ( 568.15 ) 8,655.27 1-Feb-14 19-Feb-14 SKY ( 164.57 ) 8,490.70 1-Feb-14 21-Feb-14 GVT - INTERNET ( 120.00 ) 8,370.70 1-Feb-14 23-Feb-14 TIM ( 300.00 ) 8,070.70 1-Feb-14 25-Feb-14 CELPE ( 140.00 ) 7,930.70 1-Feb-14 27-Feb-14 ABA ( 200.00 ) 7,730.70 1-Mar-14 1-Mar-14 GINÁSTICA ( 232.00 ) 7,498.70 1-Mar-14 3-Mar-14 BALLET ( 208.67 ) 7,290.03 1-Mar-14 5-Mar-14 ESCOLA ( 60.00 ) 7,230.03 1-Mar-14 7-Mar-14 MATERIAL ESCOLAR ( 200.00 ) 7,030.03 1-Mar-14 9-Mar-14 TRANSPORTE ( 100.00 ) 6,930.03 1-Mar-14 11-Mar-14 TARIFA ( 150.00 ) 6,780.03 1-Mar-14 13-Mar-14 IPTU ( 60.00 ) 6,720.03 1-Mar-14 15-Mar-14 IPVA ( 50.00 ) 6,670.03 1-Mar-14 17-Mar-14 SEGURO ( 146.40 ) 6,523.63 1-Mar-14 19-Mar-14 APLICAÇÃO ( 500.00 ) 6,023.63 1-Mar-14 21-Mar-14 RETIRADA 6,023.63 1-Mar-14 1-Mar-14 SALDO INICIAL 6,023.63 6,023.63 1-Mar-14 3-Mar-14 SALÁRIO 5,000.00 11,023.63 1-Mar-14 5-Mar-14 13 SAL / FÉRIAS 11,023.63 1-Mar-14 7-Mar-14 JUROS 100.00 11,123.63 1-Mar-14 9-Mar-14 OUTROS 2,000.00 13,123.63 1-Mar-14 11-Mar-14 VISA ( 1,000.00 ) 12,123.63 1-Mar-14 13-Mar-14 ALUGUEL APTO ( 800.00 ) 11,323.63 1-Mar-14 15-Mar-14 CONDOMÍNIO APTO ( 40.00 ) 11,283.63 1-Mar-14 17-Mar-14 DIARISTA ( 568.15 ) 10,715.48 1-Mar-14 19-Mar-14 SKY ( 164.57 ) 10,550.91 1-Mar-14 21-Mar-14 GVT - INTERNET ( 120.00 ) 10,430.91 1-Mar-14 23-Mar-14 TIM ( 300.00 ) 10,130.91 1-Mar-14 25-Mar-14 CELPE ( 140.00 ) 9,990.91 1-Mar-14 27-Mar-14 ABA ( 200.00 ) 9,790.91 1-Mar-14 29-Mar-14 GINÁSTICA ( 232.00 ) 9,558.91 1-Mar-14 31-Mar-14 BALLET ( 208.67 ) 9,350.24 1-Apr-14 2-Apr-14 ESCOLA ( 60.00 ) 9,290.24 1-Apr-14 4-Apr-14 MATERIAL ESCOLAR ( 200.00 ) 9,090.24 1-Apr-14 6-Apr-14 TRANSPORTE ( 100.00 ) 8,990.24 1-Apr-14 8-Apr-14 TARIFA ( 150.00 ) 8,840.24 1-Apr-14 10-Apr-14 IPTU ( 60.00 ) 8,780.24 1-Apr-14 12-Apr-14 IPVA ( 50.00 ) 8,730.24 1-Apr-14 14-Apr-14 SEGURO ( 146.40 ) 8,583.84 1-Apr-14 16-Apr-14 APLICAÇÃO ( 500.00 ) 8,083.84 1-Apr-14 18-Apr-14 RETIRADA 8,083.84 1-Apr-14 1-Apr-14 SALDO INICIAL 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 1-May-13 1-May-13 SALDO INICIAL 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 8,083.84 1-Jun-13 1-Jun-13 SALDO INICIAL 8,083.84 8,083.84
Compartilhar