tax calculator 01

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Income Details Year							2025 - 26				OLD or NEW TAX			NEW	GPF or NPS :-		NPS
2	Emp Name:				Desig :			Institution Name :
3	Emp Code :			PRAN No.			Aadhaar:					PAN :					TAN:
4	Salary of the Month		Basic Pay	D.A	DA ARREAR	Per Pay	H.R.A	HILL Allowance	NPS Govt.	Total Sum	Deductions						Advance Tax	Cash in Hand
5	Salary of the Month		Basic Pay	D.A	DA ARREAR	Per Pay	H.R.A	HILL Allowance	NPS Govt.	Total Sum	NPS	NPS GOV	GIS	SGHS	80 G	Sum	Advance Tax	Cash in Hand
6	Mar-25		60400	32012	0		3600	1000	12938	109950	9241	12938	700	650	0	23529	4000	82421
7	Apr-25		60400	32012	0		3600	1000	12938	109950	9241	12938	700	650	0	23529	4000	82421
8	May-25		60400	33220	4688		3600	1000	13763	116671	9831	13763	700	650	0	24944	4000	87727
9	Jun-25		60400	33220	0		3600	1000	13107	111327	9362	13107	700	650	0	23819	4000	83508
10	Jul-25		60400	33220	0		3600	1000	13107	111327	9362	13107	700	650	0	23819	4000	83508
11	Aug-25		60400	33220	0		3600	1000	13107	111327	9362	13107	700	650	0	23819	4000	83508
12	Sep-25		60400	33220	0		3600	1000	13107	111327	9362	13107	700	650	0	23819	4000	83508
13	Oct-25		60400	33220	0		3600	1000	13107	111327	9362	13107	700	650	0	23819	4000	83508
14	Nov-25		60400	35032	7032		3600	1000	14344	121408	10246	14344	700	650	0	25940	4000	91468
15	Dec-25		60400	35032	0		3600	1000	13360	113392	9543	13360	700	650	0	24253	4000	85139
16	Jan-26		62000	35960	0		3600	1000	13714	116274	9796	13714	700	650		24860	4000	87414
17	Feb-26		62000	35960	0		3600	1000	13714	116274	9796	13714	700	650		24860		91414
18	BONUS									6908						0		6908
19	Other Arrear 1															0		0
20	Other Arrear 2															0		0
21	SUM Total		728000	405328	11720	0	43200	12000	160306	1367462	114504	160306	8400	7800	0	291010	44000	1032452
22	Computation of Tax										5% of 400000 - 800000						20000.00
23	Gross Pay :	1367462.00									10% of 800000 - 1200000						33216.00
24	Std Ded	75000.00									15% of 1200000-1600000						0.00
25											20% of 1600000-2000000						0.00
26											25% of Above Rs 2000000						0.00
27											30% of Above Rs 2500000						0.00
28											Total Tax Payable :						53216.00
29											Rebate on Tax 87A						53216.00
30	80CCD(2)	160306.00									Total Tax						0.00
31											Cess @ 4%						0.00
32											Tax Payable :						0.00
33											Advance Tax Paid :						44000.00
34											Balance Tax / Refund :						-44000.00
35
36	Taxable Inc:	1132156.00
37	NEW TAX REGIME
38	Total Income		0-400000	400000-800000	800000-1200000		1200000-1600000	1600000-2000000	2000000-2400000	> 2400000	REBATE 87A		TAX			Cess @ 4%	TOTAL TAX
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
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