ZAHEERUDDIN MD Income Tax Calculation 2021-22.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	S	T	V
1	Always use a new copy for preparation of IT of the Employee. Enter the particulars in datasheet very carefully with one by one column
2		INCOME TAX CALCULATION ON SALARY OF THE GOVT. EMPLOYEE FOR THE FINANCIAL YEAR 2021-22
3		Emp ID No.	0300001		If you Family Pensioner, Please enter family Pension received during the year 2021-22										0.00
4		Name of the Employee	YOUR NAME				office TAN No :-		HYDC00000A			Employee PAN No :-			AMAPA1111P
5		Designation	Sr. Asst.				PP	0	SP	0	DDO Name			B.S. Rama Krishna			Calculating Income Tax with Lower Tax Slab under New Regim
6		Office Name and Address	office Name				FP	0	others	0	DDO Designation			Accounts Officer			Calculating Income Tax with Lower Tax Slab under New Regim
7
8		Pay as on 1st January - 2021					Select Increment Month			Select GPF Type				If Surrender Leave Taken			Gross Annual Income/Salary		1,124,168
9		Pay as on 1st February - 2021										AG GPF					Less: Deduction under Sec 80CCD(2) NPS (Employer Contribution) and 80JJAA		0
10																	Total Income		1,124,168
11		AAS(6/12/18/24) Availed					Taken Promotion					Fixation Option is given to					Tax Rebate of Rs. 12,500 (For Income of less than 5 lakhs) (Budget 2019)		0
12		H.R.A. Exemption as per eligibility U/s. 10(13-A)															Total Tax Payable		99,834
13		Living in				8300	Your Rent will be Rs. 13300-00 To get HRA Exemption							रु -			Add; Edn Cess + Health Cess @ 4%		3,994
14																	Net Tax Payable		रु 103,828
15		Select for HRA / AHRA / CCA / PHC Allowances					DA Arrears drawn in 2021-22				Select the DA % P.M
16		HRA Received		CCA Received		0	DA %	Total Arrears	Adjestment	Cash	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Calculating Income Tax with Old Tax Slab (after all Exemption & other Deductions)
17		If any Change from which Month		If any Change Select Month			27.248%			0	30.392	30.392	30.392	30.392	33.536	33.536
18		HRA Changed to		Enter Changed CCA		0	30.392%	14644	14644	0	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22
19		Select AHRA drawn or Not		Select PHC drawn or Not			33.536%	44940	44940	0	33.536	33.536	33.536	33.536	33.536	33.536	Net Taxable Income		792,610
20		PRC-PART-II & Other Arrears if any drawn and GPF/CSS/CPS/ZP PF recoveries during the year 2021-22															a)	Up to Rs. 250000	NIL
21		Arrears if any Drawn	Pay	DA	HRA	CCA/SL	PP/FP/SP	IR 27%	Total	GPF/CSS	Class-IV GPF	CPS 10%	PT	ZPPF	APGLI	GIS	b)	Rs.2,50,001 To 5,00,000. (@ 5%)	12,500
22		PRC-2015 -PART-II	12700	150	1530	905	0	3430	18715	0	0	0	0	0	0	0	c)	Rs.5,00,001 To 10,00,000 (@ 20%)	58,522
23		other Arrears if nay	14875	4525	1788	0	0	3852	25040	0	0	0	0	0	0	0	d)	above Rs.10,00,001 (@ 30%)	0
24		Savings U/s 80C (Limited to 1,50,000-00) Recoveries															Under section (87A) Tax Rebate of Rs. 12,500 (For Income of less than 5 lakhs)		0
25		MONTH	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	other Amounts		Total Tax Payable		71,022
26		GPF Subscription :-	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	20000	EWF	20	Health and Education Cess@ 4%		2,841
27		APGLI Subscription :-	1400	1400	1400	1400	1400	1400	1400	1400	1400	1400	1400	1400	Flage Day	100	Net Total Tax Payable		रु 73,863
28		GIS Subscription :-	60	60	60	60	60	60	60	60	60	60	60	60	EHS (p.m)	300
29		PT Deduction :-	200	200	200	200	200	200	200	200	200	200	200	200		0	Select for opting old Tax (or) new Tax
30																	Select for opting old Tax (or) new Tax
31		PMCF/CMRF/CJRF :-	0	0	0	0	0	0	0	0	0	0	0	0	Total :-	0
32		LIC Salary Savings Scheme P.M		Rs.	0		Other Sections Under Chapter VI A ( Under Sections 80E,80G,80DD etc )								Advance Tax Paid
33		Repayment of HBA --(Per Month)		Rs.	0		Interest on Educational Loan (80-E)					Rs.	0		Mar,21	4000
34		Children Fee for 2021-22		Rs.	75000		Interest on Housing Loan Advance (80EE) up to 2,00,000-00					Rs.	111292		Apr,21	4000
35		LIC Half/Quarterly/ Annual (Total)		Rs.	0							Rs.	0		May,21	4000
36		Total P.L.I ---- Paid (Total year)		Rs.	0							Rs.	0		June,21	4000
37		Other Recoveries if any		Rs.	0							Rs.	0		July,21	0
38		If any Leaves Availed during the month (No. of Days)										Rs.	0		Aug,21	4000
39		Mar-21		Sep-21			80TTA - Interest on deposits in savings Accounts					Rs.	0		Sept,21	4000
40		Apr-21		Oct-21								Rs.	0		Oct,21	14000
41		May-21		Nov-21			Investment in NPS up to Rs 50,000-00 under 80CCD(1B)					Rs.	0		Nov,21	4000
42		Jun-21		Dec-21			Prograrmmed by								Dec,21	0
43		Jul-21		Jan-22			Md. Jahiruddin, Sub-Treasury officer, Jaggampeta, EG Dist.,								Jan,22	0
44		Aug-21		Feb-22			Cell: 9951603786 - Email -- jahir0300084@gmail.com								Total	42000
49	.
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383