Name Designation Pan Number: Employee Code Mobile Number TOT LIC (Off) LIC (Out)

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 11

NAME DESIGNATION PAN NUMBER

SCHOOL / OFFICE EMPLOYEE CODE MOBILE NUMBER

Recovery
Office & Outside Recoveries

D.A for
Month

Office
Other
HRA

FMA
Pay

D.A

T.A
TA
TOT
UTGESI LIC LIC
GPF NPS PLI (Off) PLI (Out) NIC
S (off) (Out)
Mar-21 55200 9384 8832 1800 306 75 75597 6458 40 585 2531 5000
Apr-21 55200 9384 8832 1800 306 75 75597 0 6458 40 585 0 2531 5000 0
May-21 55200 9384 8832 1800 306 75 75597 0 6458 40 585 0 2531 5000 0
Jun-21 55200 9384 8832 1800 306 75 75597 0 6458 40 585 0 2531 5000 0
Jul-21 55200 15456 8832 1800 504 75 81867 0 7066 40 585 0 2531 5000 0
Aug-21 55200 15456 9936 1800 504 75 82971 0 7066 40 585 0 2531 5000 0
Sep-21 55200 15456 9936 1800 504 75 82971 0 7066 40 585 0 2531 5000 0
Oct-21 55200 15456 9936 1800 504 75 82971 0 7066 40 585 0 2531 5000 0
Nov-21 55200 17112 9936 1800 558 75 84681 0 7231 40 585 0 2531 5000 0
Dec-21 55200 17112 9936 1800 558 75 84681 0 7231 40 585 0 2531 5000 0
Jan-22 56900 17639 10242 1800 558 75 87214 0 7454 40 585 0 2531 5000 0
Feb-22 56900 17639 10242 1800 558 75 87214 0 7454 40 585 0 2531 5000 0
Total 665800 168862 114324 21600 5472 900 0 976958 0 84128 480 7020 0 30372 60000 0
HRA Arrears 1104
Arrears & Encashment

D.A. II Arrear 6624 7728 Sec 24 - HBA Interest Total Rent Paid
Bonus 6908 MACP Arrear 6908 Sec 80C - HBA Principal Sec 80CCC - Mutual Fund
T.Fee Reimbursement 36000 Other Arrears 36000 Sec 80C - Tuition fee paid for 2 Children Sec 80D - Med Ins (Self)
E.L Encashment Other Arrears 0 Sec 80C - FD (5 Yrs) Sec 80D - Med Ins (Senior)
LTC Encashment Other Arrears 0 Sec 80C - Sukanya Samrithi 24000 Sec 80U - PH (Self)
Gross Total Income for the Year 1027594 Sec 80C - Stamp Duty Sec 80DD - PH Dependent
Net Income for the Year 797942 Sec 80DDB - Medical Treatment Sec 80G - Donation
Income Tax Payable under Old Tax Income Tax Payable under New Tax Sec 80E - Edn. Interest 80EEB - Auto Loan (E-Vehicle)
Regime Regime Sec 80EEA - HBA (Affordable Housing) Other (Mention the Section)
Sec 80G - Donation (COVID 19 RELIEF FUND) Other (Mention the Section)
46314 Rs. 83,740 NAME
SELF DECLARATION PAN
Old Tax Regime is Beneficial for me, Hence I prefer Old
SIGNATURE :
Tax Regime
NPS YES or NO

YES
TAX Paid / To be paid HRA %
Prof.
Tax
18
1500
Increment Month
500 1500
1500
JANUARY
1500
500 1500 July DA
3000
28
3000
500 3000
7500 HRA Calculation
7500 Total HRA Received 115428
500 7500
Rent Paid in excess of ###
7314 10% of Basic Pay
2000 46314 40% of Basic Pay ###
Rent Paid 200000 HRA To be exempted ###
CCC - Mutual Fund
D - Med Ins (Self) 80C Total 155338
D - Med Ins (Senior) 80CCD (1b) Total 50000
U - PH (Self)
DD - PH Dependent
G - Donation
- Auto Loan (E-Vehicle)
Mention the Section)
Mention the Section)
Section-wise Deducations Amount Max Limit
80C (PF, LIC, PLI, SSY, T.Fee etc) 205338 150000
80CCC (Mutual Fund) 0 10000
80CCD(1B) - Tier 1 Investment Rs. 50,000 50000
80D (Medical Ins) 0 55000
80DD (PH Dependent) 0 75000 / 125000
80DDB (Med expense - Specified Disease) 0 40k / 60k / 80k
80E (Edn Interest) 0 No limits, Interest can be claimed up
80EEA (HBA - Affordable Housing) 0 150000 - Loan period 01.04.2019 to
80EEB (E-Vehicle Loan) 0 150000
80G (Donation - Outside + Covid19) 0 Upto 10% of Adjusted Gross Total In
Others 0

HRA Calculation
HRA Received 114324
Rent paid in excess of 10% of (BP+DA) 116534
40% of (BP + DA) 333865
HRA Eligible for Deducation 114324
s, Interest can be claimed up to 8 yrs
- Loan period 01.04.2019 to 31.03.2020)

% of Adjusted Gross Total Income


Directorate of School Education ###
Office of the Deputy Inspector of Schools, Zone II, Puducherry ###
Income Tax Statement Fin Year : 2021-22 ###
Name of the Employee: ###
Designation: ###
Name of the School / Office:
Employee Code (Refer Pay Slip): TAX
PAN Number (Enclose PAN Card xerox):
Gross Annual Income/Salary (with all allowances) Rs. 1,027,594
H.R.A. Exemption - Section 10 (13A) Rs. 115,428      Total Rent Paid (Total rent paid fo
Education Allowance for 2 children (Max Rs.2400)
Any Other Exempted Receipts/ allowances / Office Recovery Rs. 0      Total H.R.A received
Professional Tax - Section 16 Rs. 2,000 Rent paid in Excess of 10% of Bas
Standard Deduction @ Rs.50,000 as per Budget 2019 Rs. 50,000 40% of Basic Salary

Income from other sources (Mention the Bank Interest HRA to be exempted
Source of Income)

Transport allowance for Physically Challenged Rs. 0


Total Gross Rs. 860,166
Less: Section 24(b) Home Loan Interest Rs. 0 Home Interest
Less: Deduction under Sec  80C / 80 CCC (Max Rs.1,50,000/-) Rs. 150,000 NPS 80C
Total Gross Rs. 710,166
Less: Additional deduction u/s 80CCD(1B) NPS (Max 50,000) Rs. 50,000 ###
Less: Deduction under Sec 80 D Rs. 0 Sec 80D - Med Ins (Self)
Less: Deduction under Sec 80 DDB Rs. 0 Sec 80D - Med Ins (Senior)

Less: Deduction under Sec 80 E Rs. 0 Sec 80DDB - Medical Treatment

Less: Deduction under Sec 80 EEA Rs. 0 80 U percentage


Less: Deduction under Sec 80EEB Rs. 0 ###
Less: Deduction under Sec 80G Rs. 0 80 DD Percentage
Less: Deduction under Sec 80U Rs. 0 ###
Less: Deduction under Sec 80DD Rs. 0
Less: Deduction under Other (Mention the Section) Rs. 0
Less: Deduction under Other (Mention the Section) Rs. 0
Total Taxable Income Rs. 660,166
Total Tax Rs. 44,533
Tax rebate u/s 87A as per Budget 2019 Rs. 0
TAX after rebate Rs. 44,533
Add: Edn Cess @ 4% Rs. 1,781

Net Tax Payable = Rs. 46,314


Mar-21 Rs. 1,500 Jul-21 Rs. 1,500 Nov-21 Rs. 7,500

Advance Tax / Apr-21 Rs. 1,500 Aug-21 Rs. 3,000 Dec-21 Rs. 7,500
TDS May-21 Rs. 1,500 Sep-21 Rs. 3,000 Jan-22 Rs. 7,500
Jun-21 Rs. 1,500 Oct-21 Rs. 3,000 Feb-22 Rs. 7,314
Name of the Employee :

Employee Code :

School / Office :

Signature :
Directorate of School Education

Office of the Deputy Inspector of Schools, Zone II, Puducherry

Income Tax Statement Fin Year : 2021-22

Name of the Employee:

Designation:

Name of the School:

Employee Code (Refer Pay Slip):

PAN Number (Enclose PAN Card xerox): Mobile No:

Gross Annual Income/Salary Rs. 1,027,594

Other Source of Income

Less: Transport allowance to Physically Challenged Rs. 0


Less: Deduction u/s 80U (Physically Handicapped - SELF Only) Rs. 0
Total Taxable Income Rs. 1,027,594

Total Tax Rs. 80,519


Add: Edn Cess @ 4% Rs. 3,221
Net Tax Payable Rs. 83,740
Mar-21 Rs. 1,500 Sep-21 Rs. 3,000
Apr-21 Rs. 1,500 Oct-21 Rs. 3,000
May-21 Rs. 1,500 Nov-21 Rs. 7,500
Advance Tax / TDS
Advance Tax / TDS
Jun-21 Rs. 1,500 Dec-21 Rs. 7,500
Jul-21 Rs. 1,500 Jan-22 Rs. 7,500
Aug-21 Rs. 3,000 Feb-22 Rs. 44,740

SIGNATURE

You might also like