Investment Declaration Format

I am attaching a investment declaration format by drop downing the cursor you will get whole detail of all 80c,80 d…etc.

 

80 C Details
Sl.No. Sub section Amount Remarks
1 0.00
2 0.00
3 0.00
4 0.00
5 0.00
6 0.00
7 0.00
8 0.00
9 0.00
10 0.00
11 0.00
12 0.00
13 0.00
14 0.00
15 0.00
16 0.00
17 0.00
18 0.00
19 0.00
20 0.00

 

80 G Details
Sl.No. Sub section Amount
1 0.00
2 0.00
3 0.00
4 0.00
5 0.00
6 0.00
7 0.00
8 0.00
9 0.00
10 0.00
11 0.00
12 0.00
13 0.00
14 0.00
15 0.00
16 0.00
17 0.00
18 0.00
19 0.00
20 0.00

 

NSC Details
Interest Adjustment Amount
 1 to 5 year 0.00
 6 th year 0.00
Expenditure 0.00
Sl.No. Certificate No Date Face Value
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

 

Details of deductions under section 80C,80D,80G  in salary.

 

Optional Fields
Non Editable
Note 1: Avoid Cut options in any of the work Sheets
Note 2: To Enter Date Enter in DD/MMM/YYYY format (2/Jan/2008) Do no Cut or copy and Paste
Note 3: While Pasting data from other excel File,
use only Paste Special / Values Option
Note 4: Before any operation on excel file make sure
you are not in Excel Edit mode
Note 5: Avoid using enter character ( Alt + Enter)
in any cell 

 

Declaration Form
Name of the Employee Shweta Bhatt
Emp. ID.  / Ref. No. MTT139
PAN AXAPB6606L
Financial Year 2012-2013
Investment Details(Other than Salary Details)
Sl.No. Descriptions Amount Note: Avoid Cut and Paste options in any of the work Sheets
1 80C Details (Not deducted in salary) 0.00 80CCC 80CCD(1) 80DD 80E
2 80G Details (Not deducted in salary) 0.00 0.00 0.00 0.00 0.00
3 80D            (Not deducted in salary) 0.00 0.00 0.00 80CCG
4 How you want your HRA to be Calculated ? Yearly 0.00
5 Have you availed Interest Free Loan from Company? If yes, then how much amount to be considered for Perquisites Calculation? 0.00
6 House Property Details No
House Letout /Self occupied Self occupied
Loan borrowed after 31/3/1999 ? Yes
Address
Interest amount 0.00 0.00
Gross annual value 0.00
Muncipal tax paid 0.00
Enter Housing loan repayment in 80C Details
NSC Details
Description Apr May June July Aug Sep Oct Nov Dec Jan Feb Mar
1 Staying in Metro No No No No No No No No No No No No
2 Number of school Going Children 0 0 0 0 0 0 0 0 0 0 0 0
3 Number of Children Staying in Hostel 0 0 0 0 0 0 0 0 0 0 0 0
4 Details of Monthly House Rent Paid 0 0 0 0 0 0 0 0 0 0 0 0

 

Click Here To Download INVESTMENT Declaration