Contabilidade tributária exercicios

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Planilha1
	Empresa prestadora de serviço de informática 
	Não - Cumulativo/ CUMULATIVO 
	NFS EMITIDAS 
	0.65%	3%	1%	1.50%
	DATA 	TIPO 	Faturamento 	PIS 	COFINS 	CSLL	IRRF	VLR LÍQUIDO 
	2-Jul	PJ	* 4,000.00	* 26.00	* 120.00	* 40.00	* 60.00	* 3,754.00
	5-Jul	PF	* 8,000.00	0.0	0.0	0.0	0.0	* 8,000.00
	8-Jul	PF	* 7,000.00	0.0	0.0	0.0	0.0	* 7,000.00
	10-Jul	PJ	* 100.00	* 0.65	* 3.00	* 1.00	* 1.50	* 100.00
	12-Jul	PJ	* 5,800.00	* 37.70	* 174.00	* 58.00	* 87.00	* 5,443.30
	15-Jul	PJ	* 1,000.00	* 6.50	* 30.00	* 10.00	* 15.00	* 938.50
	19-Jul	PJ	* 500.00	* 3.25	* 15.00	* 5.00	* 7.50	* 476.75
	22-Jul	PF	* 2,000.00	0.0	0.0	0.0	0.0	* 2,000.00
	26-Jul	PJ	* 5,000.00	* 32.50	* 150.00	* 50.00	* 75.00	* 4,692.50
	30-Jul	PJ	* 12,000.00	* 78.00	* 360.00	* 120.00	* 180.00	* 11,262.00
	TOTAL 	* 45,400.00	* 183.95	* 849.00	* 283.00	* 417.00	* 43,667.05
	Não - Cumulativo
	NFS RECEBIDAS 
	7.60%	1.65%	4.65%
	DATA 	TIPO 	Situação 	Vlr serviço Contr 	Vlr serviço líquido 	Créd. Cofins 	Créd. Pis	Ret. PCC	Ret. Irrf 
	4-Jul	PJ	OP	* 4,000.00	* 4,000.00	0.0	0.0	0.0	0.0
	4-Jul	PJ	NORMAL 	* 7,000.00	* 6,604.50	0.0	0.0	* 325.50	* 70.00
	5-Jul	PF	NORMAL 	* 6,000.00	* 6,000.00	0.0	0.0	0.0	0.0
	14-Jul	PJ	NORMAL 	* 6,000.00	* 5,631.00	0.0	0.0	* 279.00	* 90.00
	20-Jul	PJ	OP	* 3,000.00	* 3,000.00	0.0	0.0	0.0	0.0
	20-Jul	PJ	NORMAL 	* 4,000.00	* 3,774.00	0.0	0.0	* 186.00	* 40.00
	24-Jul	PJ	NORMAL 	* 6,200.00	* 5,849.70	0.0	0.0	* 288.30	* 62.00
	29-Jul	PJ	OP	* 3,630.00	* 4,000.00	* 304.00	* 66.00	0.0	0.0
	4-Jul	PJ	NORMAL 	* 9,982.50	* 10,323.50	* 836.00	* 181.50	* 511.50	* 165.00
	TOTAL 	* 49,812.50	* 49,182.70	* 1,140.00	* 247.50	* 1,590.30	* 427.00
	Cumulativo 
	NFS RECEBIDAS 
	3.00%	0.65%	4.65%
	DATA 	TIPO 	Situação 	Vlr serviço Contr 	Vlr serviço líquido 	Créd. Cofins 	Créd. Pis	Ret. PCC	Ret. Irrf 
	4-Jul	PJ	OP	* 4,000.00	* 4,000.00	0.0	0.0	0.0	0.0
	4-Jul	PJ	NORMAL 	* 7,000.00	* 6,604.50	0.0	0.0	* 325.50	* 70.00
	5-Jul	PF	NORMAL 	* 6,000.00	* 6,000.00	0.0	0.0	0.0	0.0
	14-Jul	PJ	NORMAL 	* 6,000.00	* 5,631.00	0.0	0.0	* 279.00	* 90.00
	20-Jul	PJ	OP	* 3,000.00	* 3,000.00	0.0	0.0	0.0	0.0
	20-Jul	PJ	NORMAL 	* 4,000.00	* 3,774.00	0.0	0.0	* 186.00	* 40.00
	24-Jul	PJ	NORMAL 	* 6,200.00	* 5,849.70	0.0	0.0	* 288.30	* 62.00
	29-Jul	PJ	OP	* 4,000.00	* 4,000.00	0.0	0.0	0.0	0.0
	4-Jul	PJ	NORMAL 	* 11,000.00	* 10,323.50	0.0	0.0	* 511.50	* 165.00
	TOTAL 	* 51,200.00	* 49,182.70	0.0	0.0	* 1,590.30	* 427.00
	Apuração 
	Cumulativo	Não Cumulativo
	Apuração PIS/COFINS 	Base de cálculo 	Cofins 3%	Pis 0,65%	Cofins 7,60%	Pis 1,65%
	Imposto 	* 45,400.00	* 1,362.00	* 295.10	* 3,450.40	* 749.10
	(-) retenção 	* 45,400.00	(849.00)	(183.95)	(849.00)	(183.95)
	(-)crédito 	* 45,400.00	0.0	0.0	(1,140.00)	(247.50)
	=DARF A RECOLHER	* 45,400.00	* 513.00	* 111.15	* 1,461.40	317.65