How do I Import the NPSIS ID# for each student? How do I check if the NPSIS website has the correct info on my students?

+1 vote
asked Mar 4, 2015 in How To by Admin
reopened Jul 21 by yczehn
How do I Import the NPSIS ID# for each student? How do I check if the NPSIS website has the correct info on my students?
commented Jul 21 by mering
You need to leave the Column Student id and a empty column Studentnum

1 Answer

answered Jul 21 by yczehn
Best answer

This feature requires a release date later than 8/16/13. Click  How do I see my release date? for info on how to check your release date.


1. First login to NPSIS and download the School Roster. To Download Click on School Roster from the sidebar. And then Click on the Export to Excel button.



2. Add A column header for StudentNum.


3. Now Click on File menu and Select Save As and choose to save as Excel 97-2003 Workbook. Save it in a location where you will be able to find it.


4. Open the Tuition software to the report screen and got to the Additional Info tab. Then go to the Direct Cert/NPSIS tab. Click in the NPSIS School Roster option. Click on the "Load Excel File" button. Choose the excel file that you saved above in step 3.




 5. Click on the process in the bottom left corner. The program will now add an additional info with the NPSIS ID to each student detected.


You can now open the excel sheet and go thru the list of all unmatched records (rows that do not have a student number in the last column) and check why it wasn't detected. Please note the system matches by Last Name, Address, DOB. The last Name must be similar spelled, the address must be similar and the DOB must be within 1 day of what NPSIS has. If any of these 3 things don't match the system will not detect the record and the record must be updated by NPSIS.


PLEASE NOTE: There currently is a limitation with twins not being detected correctly because the system currently doesn't match on first name.

Let's Welcome our New Members

  • srfiddle of Bais Yaakov High School Of Spring Valley - Sep 14, 2021

  • RBerger of Bnos Binah - Sep 14, 2021

  • mberger of NS Chevra Kadisha - Sep 14, 2021

  • Yspangelet of Hamaspik School - Sep 09, 2021

  • R Katz of Rachmistrivka Lakewood - Sep 02, 2021

  • psteiner of Ateret Torah - Sep 02, 2021

  • Aron8699 of Cheder Beer Yeshaya - Sep 01, 2021

  • es of Hiddensparks pec - Sep 01, 2021

  • of Yeshiva Ketana satmar - Aug 31, 2021

  • eckstein01 of belz Lakewood - Aug 31, 2021