Nothing Special   »   [go: up one dir, main page]

0% found this document useful (0 votes)
20 views15 pages

Totalizadores

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 15

Cod Descrição NCM CST CFOP UN.

Quant
8114000 ADAPTADOR 1/2 ECM 39174090 000 5,102 UN. 30.00
8115000 ADAPTADOR 3/8 ECM 39174090 000 5,102 UN. 60.00
1257 BICO LEQUE 11002 84186999 000 5,102 UN. 290.00
7700 BOMBA 84133090 000 5,102 UN. 20.00
4545 CILINDRO 87089300 000 5,102 UN. 50.00
36 CONEXÃO "T" 1/2 39174090 000 6,102 PC 20.00
34 CONEXÃO "T" 3/8 39174090 000 6,102 PC 260.00
585 CORRENTE 3 MM (27M) 73158200 000 6,102 UN. 20.00
6556 EMBOLO 84099929 000 6,102 UN. 50.00
56958 ESPIGÃO 73071920 000 6,102 PC 300.00
1256 FERRO 73251000 000 6,102 KG 3,000.00
4545 FERRO FUNDIDO 73259990 000 6,102 KG 2,000.00
F4566 FILTRO DE LINHA 85444200 000 6,102 UN. 40.00
BZ271 FLANGE 1/2 85159000 000 6,102 UN. 52.00
74 JOELHO C/ ROSCA 1/2 73079200 000 6,102 UN. 40.00
56845 KIT ROSETA E PINHÃO 73071920 000 6,102 KIT 50.00
L54545 LANÇA PULVERIZADOR 84243090 000 5,102 UN. 23.00
2623 LONA DE FREIO 68138190 000 6,102 JG 60.00
2525 MADEIRA BRUTA 44071900 000 6,102 MT³ 50.00
2625 MADEIRA DE PINHEIRO 44071100 000 6,102 MT³ 50.00
307004 MANGA 1/2 39173900 000 6,102 MT 40.00
45580 MANGA 3/8 39173900 000 6,102 MT 600.00
23565 MANGA CRISTAL 39173290 000 6,102 MT 400.00
45658 MANGA TRANCADA 39173229 000 6,102 MT 30.00
8112463 MANOMETRO 90262010 000 6,102 UN. 40.00
56008 MOLA GRANDE 73071920 000 6,102 PC 50.00
56007 MOLA DE FREIO 73071920 000 6,102 PC 50.00
56006 MOLA PEQUENA 73071920 000 6,102 PC 100.00
145 NIPEL C/ ROSCA 73071990 000 6,102 UN. 30.00
AE309 PARAFUSOS 87085099 000 6,102 UN. 4,000.00
78016 PERFIL DE AÇO 73259010 000 6,102 KG 4,000.00
1253 PNEUS RECAUCH. 750 X 16 401170.10 000 6,102 PC 100.00
35 PORCA C/ RESSALTO 73181600 000 5,102 PC 300.00
456 REGISTRO BORBOLETA 84818095 000 5,102 UN. 20.00
4331 REGISTRO ESFERA 1/2 84818095 000 5,102 UN. 200.00
FR4586 REGULADOR DE PRESSÃO 84811000 000 5,102 UN. 37.00
02-021 Roda Aro 16" 87169090 000 5,102 PC 150.00
24 ROLAMENTO 84821010 000 5,102 PC 150.00
24 ROLAMENTOS 6.205 84821010 000 5,102 PC 80.00
24 ROLAMENTOS 6.206 84821010 000 5,102 PC 80.00
26 ROLAMENTOS 30207 8482.2090 000 5,102 PC 80.00
26 ROLAMENTOS 30208 8482.2090 000 5,102 PC 80.00
PV005 TANQUE PULVERIZADOR 200L 39231090 000 5,102 UN. 30.00
213 TEE C/ ROSCA 1/2 84248221 000 5,102 UN. 30.00
1256 TELA BICO NSP M/100 84186999 000 5,102 UN. 290.00
188 TORNEIRA 84818029 000 5,102 UN. 40.00
265 TUBO DE PRESSÃO 39269090 000 5,102 UN. 100.00
8114170 VALVULA 84811000 000 5,102 UN. 80.00
Valor Um Valor T Ali ICMS IPI CPF/CNPJ UF Data NF
0.86 25.80 17% 0% 79.245.296/0001-60 SC 2/4/2020 104040
0.75 45.00 17% 0% 79.245.296/0001-60 SC 2/4/2020 104040
1.42 411.80 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
329.50 6,590.00 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
10.99 549.50 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
1.05 21.00 12% 0% 76.068.311/0001-54 PR 2/5/2020 45639
0.85 221.00 12% 0% 76.068.311/0001-54 PR 2/5/2020 45639
104.90 2,098.00 12% 0% 76.068.311/0001-54 PR 2/5/2020 45639
1.56 78.00 12% 0% 23.267.521/0001-05 RS 2/4/2020 7456321
1.60 480.00 12% 0% 23.267.521/0001-05 RS 2/4/2020 7456321
3.10 9,300.00 12% 0% 23.267.521/0001-05 RS 2/4/2020 7456321
2.20 4,400.00 12% 0% 23.267.521/0001-05 RS 2/4/2020 7456321
9.19 367.60 12% 0% 23.267.521/0001-05 RS 2/4/2020 7456321
3.35 174.20 12% 0% 23.267.521/0001-05 RS 2/4/2020 7456321
0.47 18.80 12% 0% 23.267.521/0001-05 RS 2/4/2020 7456321
7.00 350.00 12% 0% 23.267.521/0001-05 RS 2/4/2020 7456321
27.10 623.30 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
10.05 603.00 12% 0% 23.267.521/0001-05 RS 2/4/2020 7456321
840.00 42,000.00 12% 0% 66.535.113/0001-08 SP 2/5/2020 21456
860.00 43,000.00 12% 0% 66.535.113/0001-08 SP 2/5/2020 21456
0.88 35.20 12% 0% 02.950.565/0001-65 PR 2/3/2020 1251252
0.55 330.00 12% 0% 02.950.565/0001-65 PR 2/3/2020 1251252
0.65 260.00 12% 0% 02.950.565/0001-65 PR 2/3/2020 1251252
0.75 22.50 12% 0% 02.950.565/0001-65 PR 2/3/2020 1251252
24.50 980.00 12% 0% 02.950.565/0001-65 PR 2/3/2020 1251252
10.50 525.00 12% 0% 02.950.565/0001-65 PR 2/3/2020 1251252
10.50 525.00 12% 0% 02.950.565/0001-65 PR 2/3/2020 1251252
8.10 810.00 12% 0% 02.950.565/0001-65 PR 2/3/2020 1251252
0.60 18.00 12% 0% 02.950.565/0001-65 PR 2/3/2020 1251252
0.85 3,400.00 12% 0% 61.099.974/0001-69 SP 2/5/2020 109687
2.45 9,800.00 12% 0% 61.099.974/0001-69 SP 2/5/2020 109687
81.00 8,100.00 12% 0% 61.099.974/0001-69 SP 2/5/2020 109687
0.56 168.00 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
4.23 84.60 17% 0% 79.245.296/0001-60 SC 2/4/2020 104040
3.90 780.00 17% 0% 79.245.296/0001-60 SC 2/4/2020 104040
59.50 2,201.50 17% 0% 79.245.296/0001-60 SC 2/4/2020 104040
66.10 9,915.00 17% 0% 79.245.296/0001-60 SC 2/4/2020 104040
1.55 232.50 17% 0% 79.245.296/0001-60 SC 2/2/2020 102020
1.65 132.00 17% 0% 79.245.296/0001-60 SC 2/2/2020 102020
2.56 204.80 17% 0% 79.245.296/0001-60 SC 2/2/2020 102020
7.05 564.00 17% 0% 79.245.296/0001-60 SC 2/2/2020 102020
7.89 631.20 17% 0% 79.245.296/0001-60 SC 2/2/2020 102020
85.20 2,556.00 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
0.72 21.60 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
0.38 110.20 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
2.05 82.00 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
22.30 2,230.00 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
0.42 33.60 17% 0% 04.389.643/0001-20 SC 2/4/2020 9687
156,109.70
Prazo ICMS Pis Cofins
15 D 4.39 0.43 1.96 19.03
15 D 7.65 0.74 3.42 33.19
15/30/45/60 70.01 6.79 31.30 303.70
15/30/45/60 1,120.30 108.74 500.84 4,860.13
15/30/45/60 93.42 9.07 41.76 405.26
20 2.52 0.35 1.60 16.54
20 26.52 3.65 16.80 174.04
20 251.76 34.62 159.45 1,652.18
30/60 9.36 1.29 5.93 61.43
30/60 57.60 7.92 36.48 378.00
30/60 1,116.00 153.45 706.80 7,323.75
30/60 528.00 72.60 334.40 3,465.00
30/60 44.11 6.07 27.94 289.48
30/60 20.90 2.87 13.24 137.18
30/60 2.26 0.31 1.43 14.81
30/60 42.00 5.78 26.60 275.63
15/30/45/60 105.96 10.28 47.37 459.68
30/60 72.36 9.95 45.83 474.86
10/20/30 5,040.00 693.00 3,192.00 33,075.00
10/20/30 5,160.00 709.50 3,268.00 33,862.50
15/30 4.22 0.58 2.68 27.72
15/30 39.60 5.45 25.08 259.88
15/30 31.20 4.29 19.76 204.75
15/30 2.70 0.37 1.71 17.72
15/30 117.60 16.17 74.48 771.75
15/30 63.00 8.66 39.90 413.44
15/30 63.00 8.66 39.90 413.44
15/30 97.20 13.37 61.56 637.88
15/30 2.16 0.30 1.37 14.17
15/45 408.00 56.10 258.40 2,677.50
15/45 1,176.00 161.70 744.80 7,717.50
15/45 972.00 133.65 615.60 6,378.75
15/30/45/60 28.56 2.77 12.77 123.90
15 D 14.38 1.40 6.43 62.39
15 D 132.60 12.87 59.28 575.25
15 D 374.26 36.32 167.31 1,623.61
15 D 1,685.55 163.60 753.54 7,312.31
15 D 39.53 3.84 17.67 171.47
15 D 22.44 2.18 10.03 97.35
15 D 34.82 3.38 15.56 151.04
15 D 95.88 9.31 42.86 415.95
15 D 107.30 10.41 47.97 465.51
15/30/45/60 434.52 42.17 194.26 1,885.05
15/30/45/60 3.67 0.36 1.64 15.93
15/30/45/60 18.73 1.82 8.38 81.27
15/30/45/60 13.94 1.35 6.23 60.48
15/30/45/60 379.10 36.80 169.48 1,644.63
15/30/45/60 5.71 0.55 2.55 24.78
20,142.78 2,575.81 11,864.34 121,526.77
Total IPI ICMS Pis Cofins icms ciap
Compra Imobilizado 126,005.35 - - 1,654.71 7,621.69 20,464.91
Compra de MP 156,109.70 - 20,142.78 2,575.81 11,864.34
Energia 1,428.45 278.75 23.57 108.56
Telefone 748.09
Uso e consumo 789.00
Total 285,080.59 - 20,421.53 4,254.09 19,594.59 20,464.91

Vendas 481,826.24 22,944.11 66,959.68 7,571.56 34,875.04


Total 481,826.24 22,944.11 66,959.68 7,571.56 34,875.04

Contabilidade 950.00
Total 950.00
Relatorio total ICMS - Entradas

Relatorio total ICMS - Saídas

Relatorio total ISS


Area Descrição Quant Valor uni Total
Prod FURADEIRA 1126.178 - 1/2" - 2 VEL. 1.00 1,300.00 1,300.00
Prod FURADEIRA DE BANCADA C/ MOTOR ELETRI 1.00 1,510.00 1,510.00
Prod MAQ P/SOLDA MIG/MAG C/ ALIM DV - 25 TRIF 1.00 7,400.00 7,400.00
Prod MAQ P/SOLDA MIG/MAG SMASHWELD 350A S/ 1.00 5,782.62 5,782.62
Prod MOLDE TANQUE 200 LT 1.00 2,500.00 2,500.00
Prod MOLDE TANQUE 300 LT 1.00 2,700.00 2,700.00
Prod PLAINA BENEFICIADEIRA DSL P/ MADEIRA 1.00 3,000.00 3,000.00
Prod PRENSA EXCENTRICA 20T - MARCA LANGEMAN 1.00 12,050.00 12,050.00
Prod PRENSA EXCENTRICA 60 T - MARCA LANGEMA 1.00 25,000.00 25,000.00
Prod ROSQUEADEIRA C/ MOTOR 2 CV 2.00 4,500.00 9,000.00
Prod SERRA FITA HORIZONTAL MR - 200E 380V R 1.00 6,500.00 6,500.00
Prod SERRA POLICORTE SOMAR COM MOTOR 4 CV 1.00 1,600.00 1,600.00
Prod TOCHA MIG-MAG SBME 235 SM OXIMIG 1.00 1,350.00 1,350.00
Prod TORNO MECANICO NARDINI MODELO ND 176 1.00 19,000.00 19,000.00

Adm Micro computador Dell 3 6,187.68 18,563.04


Adm IMPRESSORA 1 1,500.00 1,500.00
Adm Mesa Semi Oval 1 1500.00 1,500.00
Adm Mesa em L Completa 2 800.00 1,600.00
Adm Armario Escritorio 2 1000.00 2,000.00
ICMS IPI Estado N° NF IPI BC ICMS ICMS BC dif Diferencial
12% 8.00 MG 1020 104.00 1,404.00 168.48 1,404.00 70.20
12% 8.00 MG 1020 120.80 1,630.80 195.70 1,630.80 81.54
17% - SC 525459 - 7,400.00 1,258.00 -
17% - SC 525459 - 5,782.62 983.05 -
17% SC 123456 - 2,500.00 425.00 -
17% SC 123456 - 2,700.00 459.00 -
17% SC 129 - 3,000.00 510.00 -
12% - SP 985 - 12,050.00 1,446.00 12,050.00 602.50
12% - SP 985 - 25,000.00 3,000.00 25,000.00 1,250.00
12% 8.00 MG 1085 720.00 9,720.00 1,166.40 9,720.00 486.00
12% 8.00 MG 1085 520.00 7,020.00 842.40 7,020.00 351.00
12% 8.00 MG 1085 128.00 1,728.00 207.36 1,728.00 86.40
17% SC 123456 - 1,350.00 229.50 -
17% - SC 123456 - 19,000.00 3,230.00 -

12% 3.00 SP 985632 556.89 19,119.93 2,294.39 19,119.93 956.00


17% - SC 526 - 1,500.00 255.00 -
17% SC 20 - 1,500.00 255.00 -
17% SC 20 - 1,600.00 272.00 -
17% SC 20 - 2,000.00 340.00 -
126,005.35 77,672.73 3,883.64
CIAP BC Pis/Cofins Pis/Cofins Pis Cofins Valor Bem Vida util Fiscal
238.68 1,404.00 129.87 23.17 106.70 1,105.65 10 anos
277.24 1,630.80 150.85 26.91 123.94 1,284.26 10 anos
1,258.00 7,400.00 684.50 122.10 562.40 5,457.50 10 anos
983.05 5,782.62 534.89 95.41 439.48 4,264.68 10 anos
425.00 2,500.00 231.25 41.25 190.00 1,843.75 10 anos
459.00 2,700.00 249.75 44.55 205.20 1,991.25 10 anos
510.00 3,000.00 277.50 49.50 228.00 2,212.50 10 anos
2,048.50 12,050.00 1,114.63 198.83 915.80 9,489.38 10 anos
4,250.00 25,000.00 2,312.50 412.50 1,900.00 19,687.50 10 anos
1,652.40 9,720.00 899.10 160.38 738.72 7,654.50 10 anos
1,193.40 7,020.00 649.35 115.83 533.52 5,528.25 10 anos
293.76 1,728.00 159.84 28.51 131.33 1,360.80 10 anos
229.50 1,350.00 124.88 22.28 102.60 995.63 10 anos
3,230.00 19,000.00 1,757.50 313.50 1,444.00 14,012.50 10 anos

2,294.39 não se aplica 16,825.54 5 anos


255.00 não se aplica 1,245.00 10 anos
255.00 não se aplica 1,245.00 10 anos
272.00 não se aplica 1,328.00 10 anos
340.00 não se aplica 1,660.00 10 anos
20,464.91 1,654.71 7,621.69 99,191.68
Descrição Quant Valor uni Total ICMS IPI Estado
50001 Folha A4 20.00 25.00 500.00 0.00 SC
5002 Caneta Bic 100.00 1.50 150.00 0.00 SC
5003 Marca Texto 2.00 3.50 7.00 0.00 SC
5004 Post It 10 6 60.00 17 SC
5005 Corretivo Fita 10 4.9 49.00 17 SC
5006 Clips 1 23 23.00 17 SC
789.00
Cod Descrição NCM CST CFOP UN. Quant
1 CARRETÃO 3 TONELADAS 8436.99.00 020 5,101 UN. 1.00
2 PULVERIZADOR DE POMAR 8436.99.00 020 5,101 UN. 1.00
3 PULVERIZADOR 200 LTS 8436.99.00 020 5,101 UN. 1.00
1 CARRETÃO 3 TONELADAS 8436.99.00 020 5,101 UN. 2.00
2 PULVERIZADOR DE POMAR 8436.99.00 020 5,101 UN. 2.00
3 PULVERIZADOR 200 LTS 8436.99.00 020 6,101 UN. 2.00
1 CARRETÃO 3 TONELADAS 8436.99.00 020 6,101 UN. 3.00
2 PULVERIZADOR DE POMAR 8436.99.00 020 5,101 UN. 1.00
3 PULVERIZADOR 200 LTS 8436.99.00 020 5,101 UN. 1.00
1 CARRETÃO 3 TONELADAS 8436.99.00 020 5,101 UN. 1.00
2 PULVERIZADOR DE POMAR 8436.99.00 020 5,101 UN. 2.00
3 PULVERIZADOR 200 LTS 8436.99.00 020 5,101 UN. 1.00
1 CARRETÃO 3 TONELADAS 8436.99.00 020 5,101 UN. 2.00
2 PULVERIZADOR DE POMAR 8436.99.00 020 5,101 UN. 1.00
3 PULVERIZADOR 200 LTS 8436.99.00 020 5,101 UN. 1.00
1 CARRETÃO 3 TONELADAS 8436.99.00 020 5,101 UN. 1.00
2 PULVERIZADOR DE POMAR 8436.99.00 020 6,101 UN. 3.00
3 PULVERIZADOR 200 LTS 8436.99.00 020 6,101 UN. 3.00
1 CARRETÃO 3 TONELADAS 8436.99.00 020 6,101 UN. 2.00
2 PULVERIZADOR DE POMAR 8436.99.00 020 5,101 UN. 1.00
3 PULVERIZADOR 200 LTS 8436.99.00 020 5,101 UN. 2.00
2 PULVERIZADOR DE POMAR 8436.99.00 020 6,101 UN. 2.00
3 PULVERIZADOR 200 LTS 8436.99.00 020 6,101 UN. 2.00
1 CARRETÃO 3 TONELADAS 8436.99.00 020 6,101 UN. 3.00
2 PULVERIZADOR DE POMAR 8436.99.00 020 5,101 UN. 1.00
3 PULVERIZADOR 200 LTS 8436.99.00 020 5,101 UN. 1.00
Valor Um Valor T ICMS IPI CPF/CNPJ UF Data NF Prazo
10,122.40 10,122.40 17% 5% CPF COLEGA 1 SC 2/20/2020 1 5
6,748.27 6,748.27 17% 5% CPF COLEGA 1 SC 2/20/2020 1 5
15,183.60 15,183.60 17% 5% CPF COLEGA 1 SC 2/20/2020 1 5
10,122.40 20,244.80 17% 5% CPF COLEGA 2 SC 2/20/2020 2 8
6,748.27 13,496.53 17% 5% CPF COLEGA 2 SC 2/20/2020 2 8
15,183.60 30,367.20 12% 5% 74.072.513/0001-44 RS 2/21/2020 3 10
10,122.40 30,367.20 12% 5% 74.072.513/0001-44 RS 2/21/2020 3 10
6,748.27 6,748.27 17% 5% CPF COLEGA 3 SC 2/21/2020 4 15
15,183.60 15,183.60 17% 5% CPF COLEGA 3 SC 2/21/2020 4 15
10,122.40 10,122.40 17% 5% CPF COLEGA 3 SC 2/21/2020 4 15
6,748.27 13,496.53 17% 5% 18.633.292/0001-65 SC 2/24/2020 5 4
15,183.60 15,183.60 17% 5% 18.633.292/0001-65 SC 2/24/2020 5 4
10,122.40 20,244.80 17% 5% 18.633.292/0001-65 SC 2/24/2020 5 4
6,748.27 6,748.27 17% 5% CPF COLEGA 1 SC 2/24/2020 6 10
15,183.60 15,183.60 17% 5% CPF COLEGA 1 SC 2/24/2020 6 10
10,122.40 10,122.40 17% 5% CPF COLEGA 1 SC 2/24/2020 6 10
6,748.27 20,244.80 12% 5% 74.072.513/0001-44 RS 2/25/2020 7 10
15,183.60 45,550.80 12% 5% 74.072.513/0001-44 RS 2/25/2020 7 10
10,122.40 20,244.80 12% 5% 74.072.513/0001-44 RS 2/25/2020 7 10
6,748.27 6,748.27 17% 5% CPF COLE2A 2 SC 2/26/2020 8 15
15,183.60 30,367.20 17% 5% CPF COLEGA 2 SC 2/26/2020 8 15
6,748.27 13,496.53 12% 5% 74.072.513/0001-44 RS 2/25/2020 9 10
15,183.60 30,367.20 12% 5% 74.072.513/0001-44 RS 2/25/2020 9 10
10,122.40 30,367.20 12% 5% 74.072.513/0001-44 RS 2/25/2020 9 10
6,748.27 6,748.27 17% 5% 18.633.292/0001-65 SC 2/26/2020 10 15
15,183.60 15,183.60 17% 5% 18.633.292/0001-65 SC 2/26/2020 10 15
458,882.13
IPI ICMS Pis Cofins
506.12 1,720.81 167.02 769.30
337.41 1,147.21 111.35 512.87
759.18 2,581.21 250.53 1,153.95
1,012.24 3,441.62 334.04 1,538.60
674.83 2,294.41 222.69 1,025.74
1,518.36 3,644.06 501.06 2,307.91
1,518.36 3,644.06 501.06 2,307.91
337.41 1,147.21 111.35 512.87
759.18 2,581.21 250.53 1,153.95
506.12 1,720.81 167.02 769.30
674.83 2,294.41 222.69 1,025.74
759.18 2,581.21 250.53 1,153.95
1,012.24 3,441.62 334.04 1,538.60
337.41 1,147.21 111.35 512.87
759.18 2,581.21 250.53 1,153.95
506.12 1,720.81 167.02 769.30
1,012.24 2,429.38 334.04 1,538.60
2,277.54 5,466.10 751.59 3,461.86
1,012.24 2,429.38 334.04 1,538.60
337.41 1,147.21 111.35 512.87
1,518.36 5,162.42 501.06 2,307.91
674.83 1,619.58 222.69 1,025.74
1,518.36 3,644.06 501.06 2,307.91
1,518.36 3,644.06 501.06 2,307.91
337.41 1,147.21 111.35 512.87
759.18 2,581.21 250.53 1,153.95
22,944.11 66,959.68 7,571.56 34,875.04

You might also like