630 likes | 637 Views
Learn about the available Direct Loan reports, how to access them, and how they can assist in issue identification and the recon/closeout process. Explore different types of reports such as 30-day warnings, inactive loans, funded and pending disbursements, school account statements, duplicate student borrowers, and more.
E N D
Session #41 Unlocking the Potential of Direct Loan Reports Julie Aloisio Barbara Davis Allison Richards
We Will Cover: • The Lineup – Available Direct Loan Reports • Just the Facts – Setting Report Options and Accessing Reports • Searching for Clues – On the Case with Direct Loan Reports • Mystery Solved – Locking Up the Case
We Will Learn: • What Direct Loan reports are available • Where to get them • When and how frequently reports are received • Why this information is useful to school processing • How the reports can assist in issue identification and the recon/closeout process
The Lineup Direct Loan Reports – The What, Where, When, Why, and How
1 30 Day Warning • What –Unbooked Loans/MPNs • When - Monthly • Where – SAIG or COD Web • Why – Identify and Resolve Unbooked Loans on COD
2 Inactive Loans • What –Inactive Loans • When - Monthly • Where – SAIG or COD Web • Why – Identify Inactive Loans that should be active or vice versa
3 Funded Disbursement Listing • What –Funded disbursements for that day • When – Daily, as needed • Where – SAIG or COD Web • Why – Identify disbursements used in funding calculation
4 Pending Disbursement Listing • What –Pending disbursements for that period • When – Weekly • Where – SAIG or COD Web • Why – Identify disbursements to be used in funding calculations
5 School Account Statement • What –Cash and Loan Summary and Detail • When – Monthly • Where – SAIG only • Why – Reconcile with school data
6 Duplicate Student Borrower • What –List of students at your school with awards at another school • When – Monthly • Where – SAIG and COD web • Why – Identify potential overawards
7 SSN/Name/DOB Change • What –List of individuals at your school with identifier changes • When – Weekly • Where – SAIG and COD web • Why – Monitor changes & prevent rejects
8 MPN Discharge Report • What –List of MPNs inactive due to discharge • When – Weekly • Where – SAIG and COD web • Why – Identify MPNs no longer available for linking
9 Expired MPN Report • What –List of MPNs that have expired • When – Weekly • Where – SAIG and COD web • Why – Identify MPNs no longer available for linking
10 MPN Due to Expire Report • What –List of MPNs about to expire • When – Monthly • Where – SAIG and COD web • Why – Identify MPNs that will be expiring in next 60 days
Direct Loan Rebuild • What –Detailed origination and disbursement data on COD • When – As Needed • Where – SAIG • Why – Rebuild lost DL data
School Monitoring Email Report • What – Information on: • Unbooked Loans (DL only) • Unsubstantiated Funds (DL and Pell) • POP (Pell only) • When – Weekly, as needed • Where – Email from COD Customer Service • Why – Alerts schools to potential processing issues
11 School Monitoring Email Report
11 School Monitoring Email Report
Direct Loan Servicing Reports • What – Reports covering: • Entrance Counseling • Exit Counseling • Delinquency • Portfolio • When – as needed • Where – DL Servicing Website • Why – To monitor borrower activity at DL Servicing
12 Detailed Exit Counseling by Date
The Lineup: More Information • COD Technical Reference Volume 6 Section 8 • COD Customer Service • COD Website • Direct Loan Servicing School Services • Direct Loan Servicing website
Just The Facts Setting DL Report Options and Accessing Reports
Setting Report Options in COD https://cod.ed.gov
Accessing Direct Loan Reports Online • Accessed through COD Website • Opens in new window • Pop up blockers must be turned off • Users can continue working in the COD web and in reports • Users must log out of both sites separately
Accessing DL Servicing Reports Online • FAA login through the COD website • Users can continue working in COD and the Servicing websites as needed
DL Servicing Report Choices • Choose by main campus or branch • Select date range/or predefined date range
Searching for Clues – On the Case with Direct Loan Reports
CASE FILE ? The Case of Mistaken Identity • How can I determine if a student identifier has been changed on COD?
Mistaken Identity • Change sent by my school: • Common Record Acknowledgment • Change sent by my school or another school: • SSN/Name/DOB Change Report
7 Mistaken Identity
CASE FILE Case Closed Mistaken Identity • How do I use this information? • Monitor identifier changes made by my school • Update my school records to prevent future rejects
CASE FILE ? The Case of the Unbooked Loan • How can I determine what piece is missing to book a loan? • How can I determine why an MPN is not linked to available loans?
Unbooked Loan/MPN Issues • Where should I look? • 30 Day Warning • School Account Statement • MPN Reports (Discharge, Expired, Due to Expire)
1 Unbooked Loan/MPN Issues Pieces Needed by COD to Book a Loan
1 Unbooked Loan/MPN Issues Unlinked MPNs
5f Unbooked Loan/MPN Issues: SAS Unbooked Amounts Missing MPNs
9 Unbooked Loan/MPN Issues: Expired MPN Report Expired MPNs Not Available for Linking
10 Unbooked Loan/MPN Issues: MPNs Due to Expire Report MPNs Available for Linking
CASE FILE Case Closed Unbooked Loan/MPN Issues • How do I use this information? • Look for: • Pieces missing to book the loan • MPNs without origination records • Unbooked Loan Amounts • MPNs still available for linking • Send in additional data or MPN to book the loan
CASE FILE ? The Case of the Cash Balance • Why does my school have an Ending Cash Balance (ECB) at the end of each month?
Ending Cash Balance (ECB) • Where should I look? • School Account Statement (SAS) • Pending Disbursement Listing • School Records
5 ECB:SAS Cash Summary Do the totals match school records? Can you explain the ECB?
5d ECB: SAS Cash Detail Match School Records? Timing Differences?