Tax calculator.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1
2	माहिती भरा
3	सध्याचे मूळ वेतन(BASIC)		46200
4	घर भाडे सध्याचे(HRA)		9
5	प्रवास भत्ता (TA)		1350
6	Nps शासन हिस्सा(14%)		होय
7	गट विमा (GIS)		360
8	दरमहा GPF कपात		0
9
10	Statement For Income Tax
11	Salary As Pay Bill								Deduction
12	Month	Basic	DA	TA	HRA	NPS Gov.Cont.	Arries	Total	GIS	Prof. Tax	GPF	NPS Emp.cont
13	Mar-25	73300	27854	1350	6597	0		109101	360	200	0	0
14	Apr-25	73300	27854	1350	6597	14162		123263	360	200	0	0
15	May-25	73300	27854	44	6597	#REF!		#REF!	360	200	0	0
16	Jun-25	73300	27854	720	6597	14162		122633	360	200	0	0
17	Jul-25	73300	30786	1350	6597	14573	14064	140670	360	200	0	0
18	Aug-25	73300	30786	1350	6597	14573		126606	360	200	0	0
19	Sep-25	75500	31710	1350	6795	15010		130365	360	200	0	0
20	Oct-25	75500	31710	1350	6795	15010	51671	182036	360	200	59671	0
21	Nov-25	75500	31710	1350	6795	15010	0	130365	360	200	0	0
22	Dec-25	75500	31710	1350	6795	15010		130365	360	200	0	0
23	Jan-26	75500	31710	1350	6795	15010		130365	360	200	0	0
24	Feb-26	75500	31710	1350	6795	15010		130365	360	300	0	0
25	DA Diff.							0				0
26	Total	892800	363248	14264	80352	#REF!	65735	#REF!	4320	2500	59671	0
27
28	GROSS INCOME
30	other income
31	Total		0
32
33	LESS
34	Professional Tax		2500
35	Stand. Deduction		50000
36	Housing Loan Intrest
37	NPS (14%) 80CCD(2)		0
38	Donation/Nidhi		0
39	Total		52500
40
41	GROSS TOTAL INCOME
42	D.Less Investment U/s/80
43	G.P.F+NPS		59671	आवश्यक ती माहिती भरावी/ ही फक्त आपल्या महितीसाठी यात बदल होवु शकतो.
44	LIC		16500
45	GIS		4320
46	Housing Loan Repay		50000
47	P.P.F
48	Education fees
49	PLI/Mutual fund
50	N.S.C/N.S.C intrest
51	Other		0
52	TOTAL		130491
53
54	NPS 80CCD(1B)MAX 50000		0
55
56	Total Taxable Income		-182991
57	Income tax (on E.)		-21650
58	Less rebateU/S 87 A		-21650
59	Tax Payble (F-G)		0
60	Education Cess @4%		0
61	Net Tax payble (H+I)		0
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