Last month we published a post "Report of Deposit in MIS/TD/SCSS" more than Income Tax Ceiling Amount. We can easily generate the report for these product. But in case of NSC/KVP we have denomination issue. Each certificate has own account no. and the maximum denomination of KVP/NSC is Rs50000/-. Now the process of generating report is just different from prior. Follow the below step to generate the report in case of NSC/KVP.
Menu Shortcut - HACDET
GO
  • The following screen will be displayed.
Set ID -
Report to - INCOME TAX DEPT
From Open Date - 01-04-2014
To Open Date - 31-03-2015
From Scheme Code - KVN3
To Scheme Code - KVN6
Amt From - 10000
To Amt - 999999999
Order By
CIF ID - Check Box
Submit
  • The following screen will be displayed.
  • Now go to HPR Menu
  • The following report will be available
  • Now you see the report contains all account of particular CIF. We should total the balance amount. If it exceeds the ceiling limit, include it in IT Report.
  • This is for KVP. 
  • The same work will be done for generation the report for NSC.
  • Now we have to select from scheme code NSC85 and to scheme code for NSC85 
  • The rest process is same and click the submit button.
  • Now you can see the report is ready in HPR.