HrformatsI 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
