Spreadsheet Calculator 46508 | Iit Tax Calculator 1617 1718 V1

Partial file snippet.

Sheet 1: Return

	
	
	
	
	
	
	
	
		IIT - Tax Calculator
		

		

		

		

		

		

		

		

	
	
		YEAR OF ASSESSMENT : 2016/2017 and 2017/2018
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Instructions: Please only fill in the box that is yellow
		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Part 1 – DECLARATION OF PROFITS AND INCOME
		

		

		

		

		

		

		

		

	
	
		   Income from Employment 
		

		

		(Schedule 1)
		100
		0.00
		

		

		

	
	
		   Profits from Trade, Business, Profession or Vocation
		

		

		(Schedule 2)
		110
		0.00
		

		

		

	
	
		   Net Annual Value and/or Rent
		

		

		(Schedule 3)
		120
		0.00
		

		

		

	
	
		   Dividend
		

		

		(Schedule 4)
		130
		0.00
		

		

		

	
	
		   Interest
		

		

		(Schedule 5)
		140
		0.00
		

		

		

	
	
		   Annuities and Royalties Etc.
		

		

		(Schedule 6)
		150
		0.00
		

		

		

	
	
		   Income from any other source
		

		

		(Schedule 7)
		160
		0.00
		

		

		

	
	
		   Child Income
		

		

		Cage 655
		170
		

		

		

		

	
	
		TOTAL STATUTORY INCOME (100+110+120+130+140+150+160+170)
		

		

		

		200
		0.00
		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Part 2 – DEDUCTIONS FROM TOTAL STATUTORY INCOME
		

		

		

		

		

		

		

		

	
	
		   Deductible losses from Trade, Business, Profession or Vocation
		

		

		(Schedule 8)
		210
		0.00
		

		

		

	
	
		   Interest, Annuities & Royalties, Ground Rent Paid
		

		

		(Schedule 9)
		220
		0.00
		

		

		

	
	
		Total Deductions from Total Statutory Income (210 + 220)
		

		

		

		240
		0.00
		

		

		

	
	
		Assessable Income (200 - 240)
		

		

		

		250
		0.00
		

		

		

	
	
		Tax Free Allowance (only applicable to citizens)
		

		

		

		260
		

		

		

		

	
	
		Qualifying Payment
		

		

		(Schedule 10)
		300
		0.00
		

		

		

	
	
		Total Deduction From Assessable Income (260 + 300)
		

		

		

		400
		0.00
		

		

		

	
	
		TAXABLE INCOME (250-400)
		

		

		

		410
		0.00
		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Part 3 – CALCULATION OF INCOME TAX PAYABLE
		

		

		

		

		

		

		

		

	
	
		   Tax on Once-and-for-all receipts from Employment
		

		

		(Schedule 12)
		500
		0.00
		

		

		

	
	
		   Tax on balance Taxable Income
		

		

		(Schedule 12)
		520
		0.00
		

		

		

	
	
		Gross Income Tax Payable (500+520)
		

		

		

		530
		0.00
		

		

		

	
	
		   Tax Credit
		

		

		(Schedule 11)
		540
		0.00
		

		

		

	
	
		Tax Payable (if 530 > 540, = 530 – 540)
		

		

		

		590
		0.00
		

		

		

	
	
		Refund Claimed (if 530 < 540, = 540 – 530)
		

		

		

		595
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	



Sheet 2: Schedule 1

	
	
	
	
	
	
		IIT - Tax Calculator
		

		

		

		

		

		

		

		

	
	
		YEAR OF ASSESSMENT : 2016/2017 and 2017/2018
		

		

		

		

		

		

		

		

	
	
		For Employment
		

		

		

		

		

		

		

		

	
	
		Employment Income
		

		

		

		

		103
		.1
		

		Rs.
	
	
		(Including director fees and employment income)
		

		

		

		

		

		.2
		

		Rs.
	
	
		

		

		

		

		

		

		.3
		

		Rs.
	
	
		

		

		

		

		

		

		.4
		

		Rs.
	
	
		

		

		

		

		

		

		.5
		

		Rs.
	
	
		

		

		

		

		

		

		.6
		

		Rs.
	
	
		Total Employment Income
		

		

		

		

		105
		

		0.00
		Rs.
	
	
		

		

		

		

		

		

		

		

		

	
	
		Once-and-for-all Receipts
		

		

		

		

		104
		.1
		

		Rs.
	
	
		(Including directorship and employment )
		

		

		

		

		

		.2
		

		Rs.
	
	
		

		

		

		

		

		

		.3
		

		Rs.
	
	
		

		

		

		

		

		

		.4
		

		Rs.
	
	
		

		

		

		

		

		

		.5
		

		Rs.
	
	
		

		

		

		

		

		

		.6
		

		Rs.
	
	
		Total Once-and-for-all Income
		

		

		

		

		106
		

		0.00
		Rs.
	
	
		

		

		

		

		

		

		

		

		

	
	
		Total Income from Employment (105 + 106)
		

		

		

		

		107
		

		0.00
		Rs.
	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Enter Amount in yellow cages only. The white cages will be automatically sum
		

		

		

		

		

		

		

		

	



Sheet 3: Schedule 2

	
	
	
	
	
	
	
		IIT - Tax Calculator
		

		

		

		

		

		

		

	
	
		YEAR OF ASSESSMENT : 2016/2017 and 2017/2018
		

		

		

		

		

		

		

	
	
		A. Profit from Sole Proprietorship
		

		

		

		

		

		

		

	
	
		Income
		

		

		

		114
		.1
		

		Rs.
	
	
		

		

		

		

		

		.2
		

		Rs.
	
	
		

		

		

		

		

		.3
		

		Rs.
	
	
		Total Income from Sole Proprietorship
		

		

		

		115
		

		0.00
		Rs.
	
	
		

		

		

		

		

		

		

		

	
	
		B. Profit from Partnership
		

		

		

		

		

		

		

	
	
		Income
		

		

		

		117
		.1
		

		Rs.
	
	
		

		

		

		

		

		.2
		

		Rs.
	
	
		

		

		

		

		

		.3
		

		Rs.
	
	
		Total Income from Partnership
		

		

		

		118
		

		0.00
		Rs.
	
	
		

		

		

		

		

		

		

		

	
	
		Total Income from Sole Proprietorship 
		

		

		

		

		

		

		

	
	
		and Partnership (115 + 118)
		

		

		

		119
		

		0.00
		Rs.
	
	
		

		

		

		

		

		

		

		

	
	
		Enter Amount in yellow cages only. The white cages will be automatically sum

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet return iit tax calculator year of assessment and instructions please only fill in the box that is yellow part ndash declaration profits income from employment schedule trade business profession or vocation net annual value andor rent dividend interest annuities royalties etc any other source child cage total statutory deductions deductible losses amp ground paid assessable free allowance applicable to citizens qualifying payment deduction taxable calculation payable on onceandforall receipts balance gross credit if gt refund claimed lt for rs including director fees directorship enter amount cages white will be automatically sum a profit sole proprietorship b partnership...

Related files

Share

Help

IIT - Tax Calculator
YEAR OF ASSESSMENT : 2016/2017 and 2017/2018

Instructions: Please only fill in the box that is yellow

Part 1 – DECLARATION OF PROFITS AND INCOME
Income from Employment	(Schedule 1)	100	0.00
Profits from Trade, Business, Profession or Vocation	(Schedule 2)	110	0.00
Net Annual Value and/or Rent	(Schedule 3)	120	0.00
Dividend	(Schedule 4)	130	0.00
Interest	(Schedule 5)	140	0.00
Annuities and Royalties Etc.	(Schedule 6)	150	0.00
Income from any other source	(Schedule 7)	160	0.00
Child Income	Cage 655	170
TOTAL STATUTORY INCOME (100+110+120+130+140+150+160+170)		200	0.00

Part 2 – DEDUCTIONS FROM TOTAL STATUTORY INCOME
Deductible losses from Trade, Business, Profession or Vocation	(Schedule 8)	210	0.00
Interest, Annuities & Royalties, Ground Rent Paid	(Schedule 9)	220	0.00
Total Deductions from Total Statutory Income (210 + 220)		240	0.00
Assessable Income (200 - 240)		250	0.00
Tax Free Allowance (only applicable to citizens)		260
Qualifying Payment	(Schedule 10)	300	0.00
Total Deduction From Assessable Income (260 + 300)		400	0.00
TAXABLE INCOME (250-400)		410	0.00

Part 3 – CALCULATION OF INCOME TAX PAYABLE
Tax on Once-and-for-all receipts from Employment	(Schedule 12)	500	0.00
Tax on balance Taxable Income	(Schedule 12)	520	0.00
Gross Income Tax Payable (500+520)		530	0.00
Tax Credit	(Schedule 11)	540	0.00
Tax Payable (if 530 > 540, = 530 – 540)		590	0.00
Refund Claimed (if 530 < 540, = 540 – 530)		595

IIT - Tax Calculator
YEAR OF ASSESSMENT : 2016/2017 and 2017/2018
For Employment
Employment Income	103	.1		Rs.
(Including director fees and employment income)		.2		Rs.
		.3		Rs.
		.4		Rs.
		.5		Rs.
		.6		Rs.
Total Employment Income	105		0.00	Rs.

Once-and-for-all Receipts	104	.1		Rs.
(Including directorship and employment )		.2		Rs.
		.3		Rs.
		.4		Rs.
		.5		Rs.
		.6		Rs.
Total Once-and-for-all Income	106		0.00	Rs.

Total Income from Employment (105 + 106)	107		0.00	Rs.


Enter Amount in yellow cages only. The white cages will be automatically sum

IIT - Tax Calculator
YEAR OF ASSESSMENT : 2016/2017 and 2017/2018
A. Profit from Sole Proprietorship
Income	114	.1		Rs.
		.2		Rs.
		.3		Rs.
Total Income from Sole Proprietorship	115		0.00	Rs.

B. Profit from Partnership
Income	117	.1		Rs.
		.2		Rs.
		.3		Rs.
Total Income from Partnership	118		0.00	Rs.

Total Income from Sole Proprietorship
and Partnership (115 + 118)	119		0.00	Rs.

Enter Amount in yellow cages only. The white cages will be automatically sum

Related files

Share

Share to social media

Help

Login Area