session 40 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Session 40 PowerPoint Presentation
Download Presentation
Session 40

Loading in 2 Seconds...

  share
play fullscreen
1 / 33
Download Presentation

Session 40 - PowerPoint PPT Presentation

hope
112 Views
Download Presentation

Session 40

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Session 40 A Hands-On Tour of the Direct Loan Tools Software Bob Tschinkel

  2. Agenda • Install • General Functionality • Setup • Cash Management • Student Account Statement (SAS) • Rebuild • Disbursement Measurement Tools Report • Hands-on Exercises

  3. Install • Install Direct Loan Tools Release 6.0 software from FSAdownload.ed.gov • Two DLLs for Grad PLUS enhancements

  4. General Functionality • Multi-year Windows-based application designed to provide the following functionality for: • Cash Management • Import, print and compare school cash, loans, and disbursements with the COD SAS • Rebuild an EDExpress database or individual loan and disbursement records • Print Disbursement Measurement Tools report

  5. Setup • www.cod.ed.gov

  6. Setup

  7. Setup

  8. Setup • Update options for SAS on COD web site • Report Activity Type • Disbursement Detail (DSDF) • Loan Level (DSLF)

  9. Setup • Tools-Setup-System

  10. Setup • Tools-Setup-Security Users • Enable 508 grid functionality? checkbox

  11. Setup • Multi-cycle year software • Choose the year within you wish to work

  12. Setup Non EDExpress schools will need to refer to the COD Technical Reference on the FSAdownload web site for all external record layouts for the appropriate cycle year. The record layouts are in Volume IV Section 3.

  13. Cash Management • Track Direct Loan cash draw downs received and Direct Loan cash returned

  14. Cash Management • Print Internal Ending Cash Balance Report • Print this report before importing the SAS

  15. Cash Management

  16. SAS • Direct Loan Reconciliation Session #47 • Import the DSLF or DSDF • Includes only COD accepted data • Each SAS import overwrites previous SAS information stored in the DL Tools database

  17. SAS • Print import reports for the YTD Cash, Monthly Cash, YTD Disbursement and Monthly Disbursement Summaries and Import Edit Reports

  18. SASSAS Cash Detail • Displays cash transactions that appear at COD from the SAS file

  19. SAS

  20. SASDSDF • Displays loan and disbursement transactions that appear at COD from the SAS file

  21. SAS

  22. SAS • Non EDExpress schools need to import their external Cash and Loan or Disbursement files to compare • Reminder: Record layouts on in Volume IV Section 3

  23. SASCash Detail Comparison • Compares SAS to Cash Management or imported external cash files

  24. SAS

  25. SASLoan Detail Comparison-Loan Level • Compares loan detail from SAS with loan or disbursement detail records imported from an external system or disbursement detail data in EDExpress

  26. SAS

  27. SASDisbursement Detail Comparison • Compares disbursement detail from SAS file with disbursement detail records imported from an external system or disbursement detail data in EDExpress

  28. Rebuild • CODRBFOP • COD will only send accepted records • Web disbursements & any Endorser Amounts included in file

  29. Rebuild • Rebuild options on import: • Compare Only • Update All • Update Selected records

  30. Disbursement Measurement Tools Report • Monitors disbursement process by calculating averaging actual process time from entry of actual disbursements, to sending the actual disbursements in a batch to COD, and to booking the loan • Compares average number of days elapsed to your tolerance settings in DL Tools System Setup

  31. Help Text: How do I?...

  32. Help Text: How do I?...

  33. Technical Slide We appreciate your feedback and comments. We can be reached at: • Phone: 800/330-5947 • TDD/TTY services: 800/511-5806 • Email: CPSSAIG@ed.gov • Representatives are available Monday through Friday, 7 a.m. to 7 p.m. (CT).