Income Tax Software 2021-22.xlsx

	A	B	C	D	F	I	J	K	L	N	O	P	Q	S	T	U	V	W	AA	AB	AC
1	DATA SHEET FOR PREPARATION OF INCOME TAX CALCULATION																		Section	D E D U C T I O N S	MAXIMUM
2	1	DDO Name									2	Designation							80G	Donation to Charitable Institutions - 100%	3000000
3	3	Office Address									4	PAN No					TAN No		80G	Donation to Charitable Institutions - 50%	3000000
4																			80G	Donation to certain specified funds -100%	3000000
5	5	Employee Name									6	Desig							80GGA	Donations for scientific research or rural development	10000
6	7	Father									7	PAN							80DDB	Expenditure on Medical treatment (for specified diseases)	40000
7	8	Office Address																	80DDB	Expenditure on treatment for diseases (for Senior Citizens)	100000
8	9	Home Address																	80DDB	Expenditure on treatment for diseases (for Very Senior Citizens)	100000
9																			80EEB	Interest on Electric vehicle loan 2019-20	150000
10	10	Basic Pay as on Jan '21						11	Increment Month						12	Allowances			80E	Interest of Educational Loan	3000000
11	13	HRA %				If changed, from dt.									New HRA %				80TTA	Interest Exemption on FD & Savings	10000
12	14	CCA				If changed, from dt.									New CCA				80TTB	Interest Exemption on FD & Savings For Senior Citizen	50000
13	15	AHRA				If changed, from dt.									New AHRA				80CCD (2)	Investment in National Pension Scheme	50000
14	16	SCA				If changed, from dt.									New SCA				80D	Medical Insurance premium for Self, Spouse & Children	25000
15					Progrmme developed by www.prturambabu.in (Rambabu Guguloth 9959142514)														80D	Medical Insurance premium Senior citizen parents	50000
16	17	SL Month							No. of days										80DD	Medical treatment of dependent (above 40% disability)	75000
17	18	AAS Date (if any)							Scale of Pay										80DD	Medical treatment of dependent (above 80% disability)	125000
18	19	Promotion date							Scale of Pay							Option			80GGC	Payments made to electoral Trusts (Political Parties) 100%	3000000
19	20	PRC Arrears : Pay					DA				HRA			CCA				ZPPF	80D	Preventive Health Checkup	5000
20																			80QQB	Royalty income of authors of certain books	300000
21	21	Interest on N.S.C. bonds & Bank deposits								25									80DDB	Expenditure on Medical treatment (for specified diseases)	40000
22	22	Income from house property								26									80DDB	Expenditure on treatment for diseases (for Senior Citizens)	100000
23	23	Income form other sources								27									80DDB	Expenditure on treatment for diseases (for Very Senior Citizens)	100000
24	24	Spot valuation amount & others								28									80D	Medical Insurance premium for Self, Spouse & Children	25000
25																			80D	Medical Insurance premium Senior citizen parents	50000
26	29	ZPPF				If changed, from dt.									New ZPPF				80DD	Medical treatment of dependent (above 40% disability)	75000
27	30	APGLI				If changed, from dt.									New APGLI				80DD	Medical treatment of dependent (above 80% disability)	125000
28	31	GIS				If changed, from dt.									New GIS				80CCG	Rajiv Gandhi Equity Savings Scheme	25000
29	32	EHS				If changed, from dt.									New EHS				Sec. 24	Interest of House Loan	150000
30	33	LIC				If changed, from dt.									New LIC				80EE	Interest of House Loan after dt.1-4-2013	200000
31	34	Rent paid																	80EE & Sec.24	Interest of House Loan after dt.1-4-2016 Below 35 lakhs	250000
32																			80EEA	Interest of House Loan in 2019-20 Below 45 lakhs	350000
33	35	Interest on housing loan																	Section	Savings U/s 80C (Limited to 1.50,000)	MAXIMUM
34																			80C	LIC Policies Premium Yearly	150000
35	36	80 C	Employees Provident Fund (EPF)							51	80 D	Medical insurance premium							80C	Aviva Life Insurance	150000
36	37	80 C	Equity Linked Savings Scheme (ELSS)							52	80 DD	Reh. of disabled dependent							80C	Bajaj Allianz Life Insurance	150000
37	38	80 C	Home loan principle repayment							53	80 DDB	Medical expenditure on self							80C	Birla Sun Life Insurance	150000
38	39	80 C	Life Insurance Premiums (LIC)							54	80 E	Interest on loan for Higher studies							80CCC	Contribution to Pension Scheme	150000
39	40	80 C	Tuition fee paid towards Children Edn							55	80 EE		Intt. on residential house property						80C	Equity Linked Savings Schemes (ELSS)	150000
40	41	80 C	Postal Life Insurance (PLI)							56	80 G		Donations to Charities & Relief Funds (50%)						80C	Fixed deposit in banks more than 5-Years	150000
41	42	80 C	Public Provident Fund (PPF)							57	80 GG		House rent paid (If HRA not received)						80C	HDFC Life Insurance	150000
42	43	80 C	SBI Life Insurance							58	80 GGA		Donations to Sci. Research or Rural Dev.						80C	ICICI Life Insurance	150000
43	44	80 C	Sukanya Samriddi Yojana							59	80 GGC		Donations to political parties						80C	ICICI Prudential	150000
44	45	80 CCC		Premium for annuity plans						60	80 QQB		Royalty income on patents						80C	ING Life Insurance	150000
45	46	80 CCD 1		Assessee's contribution to pension a/c						61	80 RRB		Royalty income on books						80CCD	Investment in NPS	150000
46	47	80 CCD 2		Employer's contribution to pension a/c						62	80 TTA		Interest on Savings Accounts						80C	Kotak Life Insurance	150000
47	48	80 CCD 1(B)		National Pension Scheme (NPS)						63	80 U	Physical disability							80CCC	LIC / UTI etc. Pension funds	150000
48	49	80 CCF		Infrastructure bonds						64									80C	LIC Annuity Plan (Jeevan Dhara, Jeevan Akhsay etc.)	150000
49	50	80 CCG		Rajiv Gandhi Equity Saving Scheme						65									80C	Max NewYark Life Insurance	150000
50																			80C	National Savings Certificates (NSC)	150000
51																			80C	PLI (Postal Life Insurance)	150000
52																			80C	Principle Amount of House Loan	150000
53																			80C	Public Provident Fund	150000
54																			80C	Reliance Life Insurance	150000
55																			80C	RPLI (Rural Postal Life Insurance)	150000
56																			80C	SBI Life Insurance	150000
57																			80CCC	Sri Ram Life Insurance	150000
58																			80C	Stamp Duty and Registration Charges	150000
59																			80C	Subscription made to equity shares/debentures	150000
60																			80C	Subscription to deposit scheme of National Housing Bank	150000
61																			80CCD	Subscription to NSC VIII Issue	50000
62																			80C	Sukanya Samruddhi Yojana	150000
63																			80C	Tuition Fee for Children	150000
64																			80C	ULIP (Unit Linked Plan)	150000
65																			80C	UTI Retirement Benefit Pension Fund	150000
66																			80C	UTI Retirement Benefit Pension Fund	150000
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100