Anexo 161 162 - Planilha de Custos e Apuração de Impostos

Prévia do material em texto

Custos
	Cálculo Preço Custo e de Venda
	Nfe	Data	Finalidade	Fornecedor	Total da merc	IPI	ICMS	PIS	COFINS	Total da NF	Custo	CSLL	IRPJ	Preço de compra	% lucro
	2021	20-Mar	Imobilizado	Roartpallet	R$ 1,900.00	R$ 95.00	R$ - 0	R$ - 0	R$ - 0	R$ 1,995.00	R$ - 0	R$ - 0	R$ - 0	R$ - 0
	2022	23-Mar	Compra	Roartpallet	R$ 35,240.00	R$ 1,762.00	R$ 2,466.80	R$ - 0	R$ - 0	R$ 37,002.00	R$ - 0	R$ - 0	R$ - 0	R$ - 0
	2589	21-Mar	Uso Consumo	Technoprint	R$ 1,104.00	R$ - 0	R$ - 0	R$ - 0	R$ - 0	R$ 1,104.00	R$ - 0	R$ - 0	R$ - 0	R$ - 0
	2589	21-Mar	Imobilizado	Technoprint	R$ 6,200.00	R$ - 0	R$ - 0	R$ - 0	R$ - 0	R$ 6,200.00	R$ - 0	R$ - 0	R$ - 0	R$ - 0
	12366	23-Mar	Uso Consumo	Centerplast	R$ 629.70	R$ - 0	R$ - 0	R$ - 0	R$ - 0	R$ 629.70	R$ - 0	R$ - 0	R$ - 0	R$ - 0
	1	23-Mar	Venda	Roartpallet	R$ 2,880.00	R$ - 0	R$ 489.60	R$ 18.72	R$ 86.40	R$ 2,880.00	R$ 2,285.28	R$ 31.10	R$ 34.56	R$ 1,680.00	58.33%
	2	24-Mar	Venda	Roartpallet	R$ 2,625.00	R$ - 0	R$ 446.25	R$ 17.06	R$ 78.75	R$ 2,625.00	R$ 2,082.94	R$ 28.35	R$ 31.50	R$ 1,795.50	68.40%
	3	29-Mar	Venda	Roartpallet	R$ 5,400.00	R$ - 0	R$ 918.00	R$ 35.10	R$ 162.00	R$ 5,400.00	R$ 4,284.90	R$ 58.32	R$ 64.80	R$ 3,255.00	60.28%
	4	2-Apr	Venda	Roartpallet	R$ 4,950.00	R$ - 0	R$ 841.50	R$ 32.18	R$ 148.50	R$ 4,950.00	R$ 3,927.83	R$ 53.46	R$ 59.40	R$ 2,992.50	60.45%
	5	5-Apr	Venda	Roartpallet	R$ 5,040.00	R$ - 0	R$ 856.80	R$ 32.76	R$ 151.20	R$ 5,040.00	R$ 3,999.24	R$ 54.43	R$ 60.48	R$ 3,780.00	75.00%
	6	10-Apr	Venda	Roartpallet	R$ 3,960.00	R$ - 0	R$ 673.20	R$ 25.74	R$ 118.80	R$ 3,960.00	R$ 3,142.26	R$ 42.77	R$ 47.52	R$ 2,394.00	60.45%
	7	11-Apr	Venda	Roartpallet	R$ 990.00	R$ - 0	R$ 168.30	R$ 6.44	R$ 29.70	R$ 990.00	R$ 785.57	R$ 10.69	R$ 11.88	R$ 598.50	60.45%
	8	19-Apr	Venda	Roartpallet	R$ 5,625.00	R$ - 0	R$ 956.25	R$ 36.56	R$ 168.75	R$ 5,625.00	R$ 4,463.44	R$ 60.75	R$ 67.50	R$ 2,677.50	47.60%
	9	21-Apr	Venda	Roartpallet	R$ 5,350.00	R$ - 0	R$ 909.50	R$ 34.78	R$ 160.50	R$ 5,350.00	R$ 4,245.23	R$ 57.78	R$ 64.20	R$ 3,071.25	57.41%
	10	28-Apr	Venda	Roartpallet	R$ 2,150.00	R$ - 0	R$ 365.50	R$ 13.98	R$ 64.50	R$ 2,150.00	R$ 1,706.03	R$ 23.22	R$ 25.80	R$ 1,076.50	50.07%
	11	3-May	Venda	Roartpallet	R$ 2,250.00	R$ - 0	R$ 382.50	R$ 14.63	R$ 67.50	R$ 2,250.00	R$ 1,785.38	R$ 24.30	R$ 27.00	R$ 997.50	44.33%
	12	7-May	Venda	Roartpallet	R$ 2,370.00	R$ - 0	R$ 402.90	R$ 15.41	R$ 71.10	R$ 2,370.00	R$ 1,880.59	R$ 25.60	R$ 28.44	R$ 1,291.50	54.49%
	13	9-May	Venda	Roartpallet	R$ 4,245.00	R$ - 0	R$ 721.65	R$ 27.59	R$ 127.35	R$ 4,245.00	R$ 3,368.41	R$ 45.85	R$ 50.94	R$ 2,971.50	70.00%
	14	17-May	Venda	Roartpallet	R$ 4,350.00	R$ - 0	R$ 739.50	R$ 28.28	R$ 130.50	R$ 4,350.00	R$ 3,451.73	R$ 46.98	R$ 52.20	R$ 2,562.00	58.90%
	15	21-May	Venda	Roartpallet	R$ 1,125.00	R$ - 0	R$ 191.25	R$ 7.31	R$ 33.75	R$ 1,125.00	R$ 892.69	R$ 12.15	R$ 13.50	R$ 498.75	44.33%
	16	24-May	Venda	Roartpallet	R$ 2,000.00	R$ - 0	R$ 340.00	R$ 13.00	R$ 60.00	R$ 2,000.00	R$ 1,587.00	R$ 21.60	R$ 24.00	R$ 997.50	49.88%
	17	26-May	Venda	Roartpallet	R$ 1,220.00	R$ - 0	R$ 207.40	R$ 7.93	R$ 36.60	R$ 1,220.00	R$ 968.07	R$ 13.18	R$ 14.64	R$ 630.00	51.64%
	18	26-May	Venda	Roartpallet	R$ 1,450.00	R$ - 0	R$ 246.50	R$ 9.42	R$ 43.50	R$ 1,450.00	R$ 1,150.58	R$ 15.66	R$ 17.40	R$ 761.25	52.50%
	19	28-May	Venda	Roartpallet	R$ 3,500.00	R$ - 0	R$ 595.00	R$ 22.75	R$ 105.00	R$ 3,500.00	R$ 2,777.25	R$ 37.80	R$ 42.00	R$ 2,394.00	68.40%
	20	29-May	Venda	Roartpallet	R$ 1,020.00	R$ - 0	R$ 173.40	R$ 6.63	R$ 30.60	R$ 1,020.00	R$ 809.37	R$ 11.02	R$ 12.24	R$ 577.50	56.62%
	Total				R$ 107,573.70		R$ 13,091.80	R$ 406.25	R$ 1,875.00	R$ 109,430.70	R$ 94,057.65	R$ 675.00	R$ 750.00	R$ 37,002.25	57.48%
Anexo 161
Ap. Impostos sobre faturamento
	Apuração Impostos
		Mar-18	Apr-18	May-18
	ICMS	R$ - 0
Usuário do Windows: Usuário do Windows:
Crédito R$ 1.853,85	R$ 4,158.10
Usuário do Windows: Usuário do Windows:
Crédito R$ 612,95	R$ 4,000.10
	PIS	R$ 70.88	R$ 182.42	R$ 152.95
	COFINS	R$ 327.15	R$ 841.95	R$ 705.90
	CSLL	R$ 117.77	R$ 303.10	R$ 254.12
	IRPJ	R$ 130.86	R$ 336.78	R$ 282.36
Anexo 162