Tax Calculator 2025 26.xlsx

	A	C	D	E	G	K	L	M	N	O	P
1
2	Important Instructions to use This Workbook:
3	There are five sheets in whole workbook namely Profile, Salary Statement, Deductions, Tax Proforma and Form 16. You have to fill a few particulars only
4	in the sheets, and your Income Tax file will be ready within minutes.
5	https://intrahry.gov.in/Reports/frmReportViewer.aspx?PAYBILL.UniqueCode=0B22U9&PAYBILL.PayYear=2025-26&path=/PISReports/Annual&type=56
6	2. In Salary Statement, fill the YELLOW cells only. If needed, you can fill the relevant amounts in WHITE cells also.
7	3. In Deductions sheet, fill amounts (in YELLOW cells) of your savings, investments, payments for calculation of admissible deductions/ exemptions/ rebates.
8	4. In Tax Relief on Arrears (89) sheet, fill the arrears and taxable income of relevant years in GREEN cells.
9	5. In Tax Proforma, when almost work has been completed,you just have to fill a few YELLOW cells
10	6. Use Form 10E sheet for Print out, only if you need to avail the relief u/s 89 on arrears received for previous years..
11
12	Personal Details of the Official
13
14	Name		VEENA MADAN			<< Enter your name here
15	Designation		JBT			<< Enter the designation here
16	Type of employee		Regular (drawing DA/HRA etc)		1	<< Select Regular or Contracual
17	Office		GMSPS SECTOR 28 FARIDABAD			<< Enter the Office name
18	PAN No.		AYOPM1483F			<< Enter your PAN no.
19	Residential Status		Resident			<< Enter the residential status
20	Age as on 31/03/2026		Below 60 Years		0	<< Select range of age
21	Gender		Female		0	<< Select Gender				Male	Female
22	Medical Allowance		1000			**Enter the rate of Medical Allowance (Monthly)
23	GIS Contribution		30			**Enter the rate of deduction towards GIS (Monthly)
24	NPS/ GPF Deduction Status		NPS		1	**Enter 'GPF' or 'NPS' (as applicable) Contractual Emplyees should enter 'Not Applicable'
25	Handicapped Status (YES/ NO)		No		0	**Enter 'Yes' if you are availing Handicapped Allowance, otherwise Enter 'No'
26	Applicable rate (%) of HRA		16			0	8	16	24
27		NPS		Below 60 Years		Yes	No
28	Regular (drawing DA/HRA etc)	GPF		More than/equal to 60Yrs,less than 80Yrs						Resident
29	Contractual (Fixed Pay, No allowances)	Not Applicable		More than or equal to 80 Years						Non-Resident
30	Details of Employer									Resident but not ordinarily
31	Name of Employer	Amitabh Bachchan					To watch informative videos regarding Income tax and more, click the link below
32	Designation	Headmaster
33	Address (Office)	GMSPS SECTOR 28 FARIDABAD
34	PAN No.	AAAAA1235A					https://youtube.com/@harsamacharbynareshjangra?si=5zOyiDfrbZ4BtrI1
35	TAN No.	BSHAK4567S
36	The columns marked with are Mandatory
58
59
60
61
62
63
64
65
66
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121