Income Tax Calculation Chart

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 29

CHIRAGH PRIMARY SCHOOL ,MALEGAON

Name of the Employee:- SHAKERA BADRUDDOJA PAN NO:-

Income Tax Assesment for the Year 2020-2021

Enter data in Yellow Fields Working


Annual Gross Salary (Rs) 930,465 Old Rates New Rates Slab Amount (Old) Tax (Old) Slab Amount (New) Tax (New)
Standard Deduction 50,000 0% 0% 250,000 - 250,000 -
HRA - 5% 5% 250,000 12,500 250,000 12,500
PT and Entertainment Allowance 2,500 20% 10% 216,474 43,295 250,000 25,000
NPS - 20% 15% - - 180,465 27,070
Leave Travel Allowance - 30% 20% - - - -
Home Loan Interest Payment - 30% 25% - - - -
Deduction u/s 80C 159,324 30% 30% - - - -
Health Insurance U/s 80D 2,155 - - Total 55,795 - 64,570
Saving Bank Interest u/s 80TTA 12 - - Cess 2,232 - 2,583
Total Exemption & Deductions 213,991
Total Taxes 58,027 - 67,153
-
Taxable Income (Old) 716,474
Decision New Tax Slab result in Higher Taxes

Results / Summary
Tax Savings 9,126

Better Option Old Tax Slabs

OLD Rates 79559 NEW 71551


36000 36000
43559 35551
INCOME TAX ASSESMENT FOR THE F.Y. 2022-2023
CHIRAGH PRIMARY SCHOOL MALEGAON
Statement Showing Salary & Income Tax Assesment
Name : REHANA PARVEEN MOHAMMAD IBRAHIM Design : ASSIT TEACHER
Month Salary P.F I.T. L.I.C. CM FUND P.Tax STAMP
Mar-22 91212 7000 7000 0 0 200 1
Apr-22 93078 7000 7000 0 0 200 1
May-22 133734 7000 7000 0 0 200 1
Jun-22 93488 7000 7000 0 0 200 1
Jul-22 96859 7000 7000 0 0 200 1
Aug-22 96859 7000 7000 0 0 200 1
Sep-22 113824 7000 7000 0 0 200 1
Oct-22 98782 7000 7000 0 0 200 1
Nov-22 98782 7000 7000 0 0 200 1
Dec-22 98782 7000 0 0 0 200 1
Jan-23 98782 7000 0 0 0 200 1
Feb-23 98782 7000 0 0 0 300 1
7th Pay Diff 0 0 0 0 0 0 0
1ST INSTALMEN 0 0 0 0 0 0 0
0 0 0 0 0 0 0
1212964 84000 63000 0 0 2500 12

INCOME TAX ASSESMENT FOR THE F.Y. 2022-2023

Name of the Employee REHANA PARVEEN MOHAMMAD IBRAHIM

Destination ASSIT TEACHER Pan No.

1 Gross Salary Rs. 1212964


2 Standard Deduction(Rs 50000) Rs. 50000
3 Professional Tax Rs. 2500
4 Housing Loan Intrest Rs. 0
Deduction u/s 80c Net Salary
i) L.I.C. Rs. 0
ii) Provident Fund/DCPS Fund Rs. 84000
iii) Tution Fees Rs. 0
iv) Housing Loan Repayment Rs.
v) Group Insurance Rs. 12
84012 (B) Rs.

(A-B) Rs.

5) INCOME TAX ON TAXBLE INCOME


(Gents Rs. 250000, Ladies Rs. 250000)
Gents Ladies
250001 to 500000 250001 to 500000 Tax on Total Income
500001 to 1000000 500000 to 1000000
Rebate under section 87A
Tax
Education Cess 4%
Total Tax
6) INCOME TAX MONTHLY DEDUCTION

From : Mar-19 To: Jan-20 Rs.

Income Tax Deduction in the Month of February 2020 Rs.

Total Income Tax Deduction Rs.

Place :- Malegaon Tax Pay/ Refund


Date:-

CHIRAGH PRIMARY SCHOOL MALEGAON


Statement Showing Salary & Income Tax Assesment
Name : SHAHEENA AKHTAR MOHAMMAD HANEEF Design : ASSIT TEACHER
Month Salary P.F I.T. L.I.C. CM FUND P.Tax STAMP
Mar-22 91212 7000 7000 0 0 200 1
Apr-22 93078 7000 7000 0 0 200 1
May-22 133734 7000 7000 0 0 200 1
Jun-22 93488 7000 7000 0 0 200 1
Jul-22 96859 7000 7000 0 0 200 1
Aug-22 96859 7000 7000 0 0 200 1
Sep-22 113824 7000 7000 0 0 200 1
Oct-22 98782 7000 7000 0 0 200 1
Nov-22 98782 7000 7000 0 0 200 1
Dec-22 98782 7000 0 0 0 200 1
Jan-23 98782 7000 0 0 0 200 1
Feb-23 98782 7000 0 0 0 300 1
7th Pay Dif 0 0 0 0 0 0 0
1ST INSTA 0 0 0 0 0 0 0
0 0 0 0 0 0 0
1212964 84000 63000 0 0 2500 12
INCOME TAX ASSESMENT FOR THE F.Y. 2022-2023

Name of the Employee SHAHEENA AKHTAR MOHAMMAD HANEEF

Destination ASSIT TEACHER Pan No.

1 Gross Salary Rs. 1212964


2 Standard Deduction(Rs 50000) Rs. 50000
3 Professional Tax Rs. 2500
4 Housing Loan Intrest Rs. 0
Deduction u/s 80c Net Salary
i) L.I.C. Rs. 0
ii) Provident Fund/DCPS Fund Rs. 84000
iii) Tution Fees Rs. 0
iv) Housing Loan Repayment Rs.
v) Group Insurance Rs. 12
84012 (B) Rs.

(A-B) Rs.

5) INCOME TAX ON TAXBLE INCOME

(Gents Rs. 250000, Ladies Rs. 250000)


Gents Ladies
250001 to 500000 250001 to 500000 Tax on Total Income
500001 to 1000000 500000 to 1000000
Rebate under section 87A
Tax
Education Cess 4%
Total Tax
6) INCOME TAX MONTHLY DEDUCTION

From : Mar-19 To: Jan-20 Rs.

Income Tax Deduction in the Month of February 2020 Rs.

Total Income Tax Deduction Rs.

Place :- Malegaon Tax Pay/ Refund


Date:-
CHIRAGH PRIMARY SCHOOL MALEGAON
Statement Showing Salary & Income Tax Assesment
Name : SHAKERA BADRUDDOJA Design : ASSIT TEACHER
Month Salary P.F I.T. L.I.C. CM FUND P.Tax STAMP
Mar-22 88584 7000 7000 6277 0 200 1
Apr-22 90396 7000 7000 6277 0 200 1
May-22 129904 7000 7000 6277 0 200 1
Jun-22 90806 7000 7000 6277 0 200 1
Jul-22 94028 7000 7000 6277 0 200 1
Aug-22 94028 7000 7000 6277 0 200 1
Sep-22 110498 7000 7000 6277 0 200 1
Oct-22 95894 7000 7000 6277 0 200 1
Nov-22 95894 7000 7000 6277 0 200 1
Dec-22 95894 7000 0 6277 0 200 1
Jan-23 95894 7000 0 6277 0 200 1
Feb-23 95894 7000 0 6277 0 300 1
7th Pay Dif 0 0 0 0 0 0 0
1ST INSTA 0 0 0 0 0 0 0
0 0 0 0 0 0 0
1177714 84000 63000 75324 0 2500 12

INCOME TAX ASSESMENT FOR THE F.Y. 2022-2023

Name of the Employee SHAKERA BADRUDDOJA

Destination ASSIT TEACHER Pan No.

1 Gross Salary Rs. 1177714


2 Standard Deduction(Rs 50000) Rs. 50000
3 Professional Tax Rs. 2500
4 Housing Loan Intrest Rs. 0
Deduction u/s 80c Net Salary
i) L.I.C. Rs. 75324
ii) Provident Fund/DCPS Fund Rs. 84000
iii) Tution Fees Rs. 0
iv) Housing Loan Repayment Rs.
v) Group Insurance Rs. 12
159336 (B) Rs.

(A-B) Rs.
5) INCOME TAX ON TAXBLE INCOME

(Gents Rs. 250000, Ladies Rs. 250000)


Gents Ladies
250001 to 500000 250001 to 500000 Tax on Total Income
500001 to 1000000 500000 to 1000000
Rebate under section 87A
Tax
Education Cess 4%
Total Tax
6) INCOME TAX MONTHLY DEDUCTION

From : Mar-19 To: Jan-20 Rs.

Income Tax Deduction in the Month of February 2020 Rs.

Total Income Tax Deduction Rs.

Place :- Malegaon Tax Pay/ Refund


Date:-

CHIRAGH PRIMARY SCHOOL MALEGAON


Statement Showing Salary & Income Tax Assesment
Name : MUSARRAT PARVEEN SHABBIRAHMAD Design : ASSIT TEACHER
Month Salary P.F I.T. L.I.C. CM FUND P.Tax STAMP
Mar-22 88584 7000 7000 0 0 200 1
Apr-22 90396 7000 7000 0 0 200 1
May-22 129904 7000 7000 0 0 200 1
Jun-22 90806 7000 7000 0 0 200 1
Jul-22 94028 7000 7000 0 0 200 1
Aug-22 94028 7000 7000 0 0 200 1
Sep-22 110498 7000 7000 0 0 200 1
Oct-22 95894 7000 7000 0 0 200 1
Nov-22 95894 7000 7000 0 0 200 1
Dec-22 95894 7000 0 0 0 200 1
Jan-23 95894 7000 0 0 0 200 1
Feb-23 95894 7000 0 0 0 300 1
7th Pay Dif 0 0 0 0 0 0 0
1ST INSTA 0 0 0 0 0 0 0
0 0 0 0 0 0 0
1177714 84000 63000 0 0 2500 12

INCOME TAX ASSESMENT FOR THE F.Y. 2022-2023

Name of the Employee MUSARRAT PARVEEN SHABBIRAHMAD

Destination ASSIT TEACHER Pan No.

1 Gross Salary Rs. 1177714


2 Standard Deduction(Rs 50000) Rs. 50000
3 Professional Tax Rs. 2500
4 Housing Loan Intrest Rs. 0
Deduction u/s 80c Net Salary
i) L.I.C. Rs. 0
ii) Provident Fund/DCPS Fund Rs. 84000
iii) Tution Fees Rs. 0
iv) Housing Loan Repayment Rs.
v) Group Insurance Rs. 12
84012 (B) Rs.

(A-B) Rs.

5) INCOME TAX ON TAXBLE INCOME

(Gents Rs. 250000, Ladies Rs. 250000)


Gents Ladies
250001 to 500000 250001 to 500000 Tax on Total Income
500001 to 1000000 500000 to 1000000
Rebate under section 87A
Tax
Education Cess 4%
Total Tax
6) INCOME TAX MONTHLY DEDUCTION

From : Mar-19 To: Jan-20 Rs.

Income Tax Deduction in the Month of February 2020 Rs.

Total Income Tax Deduction Rs.

Place :- Malegaon Tax Pay/ Refund


Date:-
CHIRAGH PRIMARY SCHOOL MALEGAON
Statement Showing Salary & Income Tax Assesment
Name : SABEEHA IQBAL AHMAD Design : ASSIT TEACHER
Month Salary NPS I.T. L.I.C. CM FUND P.Tax STAMP
Mar-22 93671 7284 7000 0 0 200 1
Apr-22 95617 7454 7000 0 0 200 1
May-22 175832 37880 7000 0 0 200 1
Jun-22 96027 7454 7000 0 0 200 1
Jul-22 99412 7676 7000 0 0 200 1
Aug-22 99412 7676 7000 0 0 200 1
Sep-22 115174 7676 7000 0 0 200 1
Oct-22 101416 7852 7000 0 0 200 1
Nov-22 101416 7852 7000 0 0 200 1
Dec-22 101416 7852 0 0 0 200 1
Jan-23 101416 7852 0 0 0 200 1
Feb-23 101416 7852 0 0 0 300 1
7th Pay Dif 0 0 0 0 0 0 0
1ST INSTA 0 0 0 0 0 0 0
0 0 0 0 0 0 0
1282225 122360 63000 0 0 2500 12

INCOME TAX ASSESMENT FOR THE F.Y. 2020-2021

Name of the Employee SABEEHA IQBAL AHMAD

Destination ASSIT TEACHER Pan No.

1 Gross Salary Rs. 1282225


2 Standard Deduction(Rs 50000) Rs. 50000
3 Professional Tax Rs. 2500
4 Housing Loan Intrest Rs. 0
Deduction u/s 80c Net Salary
i) L.I.C. Rs. 0
ii) Provident Fund/DCPS Fund Rs. 122360
iii) Tution Fees Rs. 0
iv) Housing Loan Repayment Rs.
v) Group Insurance Rs. 12
122372 (B) Rs.

(A-B) Rs.
5) INCOME TAX ON TAXBLE INCOME

(Gents Rs. 250000, Ladies Rs. 250000)


Gents Ladies
250001 to 500000 250001 to 500000 Tax on Total Income
500001 to 1000000 500000 to 1000000
Rebate under section 87A
Tax
Education Cess 4%
Total Tax
6) INCOME TAX MONTHLY DEDUCTION

From : Mar-19 To: Jan-20 Rs.

Income Tax Deduction in the Month of February 2020 Rs.

Total Income Tax Deduction Rs.

Place :- Malegaon Tax Pay/ Refund


Date:-

CHIRAGH PRIMARY SCHOOL MALEGAON


Statement Showing Salary & Income Tax Assesment
Name : SHAHEENA PARVEEN IQBAL AHMAD Design : ASSIT TEACHER
Month Salary P.F I.T. L.I.C. CM FUND P.Tax STAMP
Mar-22 93671 7284 7000 0 0 200 1
Apr-22 95617 7454 7000 0 0 200 1
May-22 175832 37880 7000 0 1820 200 1
Jun-22 96027 7454 7000 0 0 200 1
Jul-22 99412 7676 7000 0 0 200 1
Aug-22 99412 7676 7000 0 0 200 1
Sep-22 115174 7676 7000 0 0 200 1
Oct-22 101416 7852 7000 0 0 200 1
Nov-22 101416 7852 7000 0 0 200 1
Dec-22 101416 7852 0 0 0 200 1
Jan-23 101416 7852 0 0 0 200 1
Feb-23 101416 7852 0 0 0 300 1
7th Pay Dif 0 0 0 0 0 0 0
1ST INSTA 0 0 0 0 0 0 0
0 0 0 0 0 0 0
1282225 122360 63000 0 1820 2500 12

INCOME TAX ASSESMENT FOR THE F.Y. 2022-2023

Name of the Employee SHAHEENA PARVEEN IQBAL AHMAD

Destination ASSIT TEACHER Pan No.

1 Gross Salary Rs. 1282225


2 Standard Deduction(Rs 50000) Rs. 50000
3 Professional Tax Rs. 2500
4 Housing Loan Intrest Rs. 0
Deduction u/s 80c Net Salary
i) L.I.C. Rs. 0
ii) Provident Fund/DCPS Fund Rs. 122360
iii) Tution Fees Rs. 1820
iv) Housing Loan Repayment Rs.
v) Group Insurance Rs. 12
124192 (B) Rs.

(A-B) Rs.

5) INCOME TAX ON TAXBLE INCOME

(Gents Rs. 250000, Ladies Rs. 250000)


Gents Ladies
250001 to 500000 250001 to 500000 Tax on Total Income
500001 to 1000000 500000 to 1000000
Rebate under section 87A
Tax
Education Cess 4%
Total Tax
6) INCOME TAX MONTHLY DEDUCTION

From : Mar-19 To: Jan-20 Rs.

Income Tax Deduction in the Month of February 2020 Rs.

Total Income Tax Deduction Rs.

Place :- Malegaon Tax Pay/ Refund


Date:-
CHIRAGH PRIMARY SCHOOL MALEGAON
Statement Showing Salary & Income Tax Assesment
Name : AQUEELA MAHMOODUL HASAN Design : ASSIT TEACHER
Month Salary P.F I.T. L.I.C. CM FUND P.Tax STAMP
Mar-22 93671 7284 7000 0 0 200 1
Apr-22 95617 7454 7000 0 0 200 1
May-22 175832 37880 7000 0 1820 200 1
Jun-22 96027 7454 7000 0 0 200 1
Jul-22 99412 7676 7000 0 0 200 1
Aug-22 99412 7676 7000 0 0 200 1
Sep-22 115174 7676 7000 0 0 200 1
Oct-22 101416 7852 7000 0 0 200 1
Nov-22 101416 7852 7000 0 0 200 1
Dec-22 101416 7852 0 0 0 200 1
Jan-23 101416 7852 0 0 0 200 1
Feb-23 101416 7852 0 0 0 300 1
7th Pay Dif 0 0 0 0 0 0 0
1ST INSTA 0 0 0 0 0 0 0
0 0 0 0 0 0 0
1282225 122360 63000 0 1820 2500 12

INCOME TAX ASSESMENT FOR THE F.Y. 2022-2023

Name of the Employee AQUEELA MAHMOODUL HASAN

Destination ASSIT TEACHER Pan No.

1 Gross Salary Rs. 1282225


2 Standard Deduction(Rs 50000) Rs. 50000
3 Professional Tax Rs. 2500
4 Housing Loan Intrest Rs. 0
Deduction u/s 80c Net Salary
i) L.I.C. Rs. 0
ii) Provident Fund/DCPS Fund Rs. 122360
iii) Tution Fees Rs. 1820
iv) Housing Loan Repayment Rs.
v) Group Insurance Rs. 12
124192 (B) Rs.
(A-B) Rs.

5) INCOME TAX ON TAXBLE INCOME

(Gents Rs. 250000, Ladies Rs. 250000)


Gents Ladies
250001 to 500000 250001 to 500000 Tax on Total Income
500001 to 1000000 500000 to 1000000
Rebate under section 87A
Tax
Education Cess 4%
Total Tax
6) INCOME TAX MONTHLY DEDUCTION

From : Mar-19 To: Jan-20 Rs.

Income Tax Deduction in the Month of February 2020 Rs.

Total Income Tax Deduction Rs.

Place :- Malegaon Tax Pay/ Refund


Date:-

CHIRAGH PRIMARY SCHOOL MALEGAON


Statement Showing Salary & Income Tax Assesment
Name : MUZAMMIL HUSAIN MOHAMMAD MUSTAFA Design : CLERK
Month Salary P.F I.T. L.I.C. CM FUND P.Tax STAMP
Mar-22 47558 2000 0 0 0 200 1
Apr-22 48527 2000 0 0 0 200 1
May-22 70795 2000 0 0 0 200 1
Jun-22 49477 2000 0 0 0 200 1
Jul-22 50967 2000 0 0 0 200 1
Aug-22 50967 2000 0 0 0 200 1
Sep-22 59778 2000 0 0 0 200 1
Oct-22 51966 2000 0 0 0 200 1
Nov-22 51966 2000 0 0 0 200 1
Dec-22 51966 2000 0 0 0 200 1
Jan-23 51966 2000 0 0 0 200 1
Feb-23 51966 2000 0 0 0 300 1
7th Pay Dif 0 0 0 0 0 0 0
1ST INSTA 0 0 0 0 0 0 0
0 0 0 0 0 0 0
637899 24000 0 0 0 2500 12

INCOME TAX ASSESMENT FOR THE F.Y. 2022-2023

Name of the Employee MUZAMMIL HUSAIN MOHAMMAD MUSTAFA

Destination CLERK Pan No.

1 Gross Salary Rs. 637899


2 Standard Deduction(Rs 50000) Rs. 50000
3 Professional Tax Rs. 2500
4 Housing Loan Intrest Rs. 0
Deduction u/s 80c Net Salary
i) L.I.C. Rs. 0
ii) Provident Fund/DCPS Fund Rs. 24000
iii) Tution Fees Rs. 0
iv) Housing Loan Repayment Rs.
v) Group Insurance Rs. 12
24012 (B) Rs.

(A-B) Rs.

5) INCOME TAX ON TAXBLE INCOME

(Gents Rs. 250000, Ladies Rs. 250000)


Gents Ladies
250001 to 500000 250001 to 500000 Tax on Total Income
500001 to 1000000 500000 to 1000000
Rebate under section 87A
Tax
Education Cess 4%
Total Tax
6) INCOME TAX MONTHLY DEDUCTION

From : Mar-19 To: Jan-20 Rs.

Income Tax Deduction in the Month of February 2020 Rs.

Total Income Tax Deduction Rs.

Place :- Malegaon Tax Pay/ Refund


Date:-

CHIRAGH PRIMARY SCHOOL MALEGAON


Statement Showing Salary & Income Tax Assesment
Name : ASHFAQUE AHMAD MOHAMMAD HAROON Design : PEON
Month Salary P.F I.T. L.I.C. CM FUND P.Tax STAMP
Mar-22 34856 2000 0 0 0 200 1
Apr-22 35564 2000 0 0 0 200 1
May-22 51715 2000 0 0 0 200 1
Jun-22 35839 2000 0 0 0 200 1
Jul-22 37557 2000 0 0 0 200 1
Aug-22 37557 2000 0 0 0 200 1
Sep-22 43992 2000 0 0 0 200 1
Oct-22 38286 2000 0 0 0 200 1
Nov-22 38286 2000 0 0 0 200 1
Dec-22 38286 2000 0 0 0 200 1
Jan-23 38286 2000 0 0 0 200 1
Feb-23 38286 2000 0 0 0 300 1
7th Pay Dif 0 0 0 0 0 0 0
1ST INSTA 0 0 0 0 0 0 0
0 0 0 0 0 0 0
468510 24000 0 0 0 2500 12

INCOME TAX ASSESMENT FOR THE F.Y. 2020-2021

Name of the Employee ASHFAQUE AHMAD MOHAMMAD HAROON

Destination PEON Pan No.

1 Gross Salary Rs. 468510


2 Standard Deduction(Rs 50000) Rs. 50000
3 Professional Tax Rs. 2500
4 Housing Loan Intrest Rs. 0
Deduction u/s 80c Net Salary
i) L.I.C. Rs. 0
ii) Provident Fund/DCPS Fund Rs. 24000
iii) Tution Fees Rs. 0
iv) Housing Loan Repayment Rs.
v) Group Insurance Rs. 12
24012 (B) Rs.
(A-B) Rs.

5) INCOME TAX ON TAXBLE INCOME

(Gents Rs. 250000, Ladies Rs. 250000)


Gents Ladies
250001 to 500000 250001 to 500000 Tax on Total Income
500001 to 1000000 500000 to 1000000
Rebate under section 87A
Tax
Education Cess 4%
Total Tax
6) INCOME TAX MONTHLY DEDUCTION

From : Mar-19 To: Jan-20 Rs.

Income Tax Deduction in the Month of February 2020 Rs.

Total Income Tax Deduction Rs.

Place :- Malegaon Tax Pay/ Refund


Date:-
1160464

84012

1076452
135436

135436
5417
140853

63000

77853

140853

140853
1160464

84012

1076452

135436

135436
5417
140853

63000

77853

140853

140853
1125214

150000

975214
107543

107543
4302
111845

63000

48845

111845

111845
1125214

84012

1041202

124861

124861
4994
129855

63000

66855

129855

129855
1229725

122372

1107353
144706

144706
5788
150494

63000

87494

150494

150494
1229725

124192

1105533

144160

144160
5766
149926

63000

86926

149926

149926
1229725

124192
1105533

144160

144160
5766
149926

63000

86926

149926

149926
585399

24012

561387

24777

24777
991
25768

25768

25768

25768
416010

24012
391998

0
0
0

You might also like