340 likes | 494 Views
Session DL-3. Direct Loan Tools Hands-on Session Bob Tschinkel Chuck Hirman U.S. Department of Education. Agenda. Install General Functionality Setup Cash Management School Account Statement (SAS) Hands-on Exercises. Install.
E N D
Session DL-3 Direct Loan Tools Hands-on Session Bob Tschinkel Chuck Hirman U.S. Department of Education
Agenda • Install • General Functionality • Setup • Cash Management • School Account Statement (SAS) • Hands-on Exercises
Install Install Direct Loan Tools Release 8.0 software from FSAdownload.ed.gov If you need additional assistance call CPS/SAIG Help Desk at 800/330-5947
DL Tools GeneralFunctionality Multi-year application designed to provide the following functionality (these will be covered in today’s hands-on section): • Cash Management • SAS • import • print • compare against school cash, loans and disbursements
DL Tools GeneralFunctionality Multi-year application designed to provide the following functionality (these will not be covered in today’s hands-on section): • Rebuild an EDExpress database or individual loan and disbursement records • Print Disbursement Measurement Tools report
Setup YTD DSDF
Setup • Tools-Setup-System • Tools-Setup-Security Users • Enable 508 grid functionality? checkbox
Setup • Multi-cycle year software • Choose the year you will be working in
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
Cash Management • Track Direct Loan Cash Receipts and Direct Loan Refunds of Cash
Cash Management • Print Internal Ending Cash Balance Report • Print this report before importing the SAS
School Account Statement (SAS) • The SAS is a monthly statement listing the school’s DL processing activity as reported to (and accepted by) COD • Import the DSLF or DSDF • Each SAS import overwrites previous SAS information stored in the DL Tools database
Printing the SAS • Print import reports for the YTD Cash, Monthly Cash, YTD Disbursement and Monthly Disbursement Summaries and Import Edit Reports
Printing the SAS • Displays the cash transactions that appear at COD from the SAS file
Printing the SAS • Displays the loan and disbursement transactions that appear at COD from the SAS file
Printing the SAS - Loan Detail Match School Records? Timing? Missing Data?
SAS Compare – Non-EDExpress • 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
SAS Compare – Cash Detail • Compares SAS to Cash Management or imported external cash files
SAS Compare – Loan/Disbursement Detail • Compares loan detail from SAS with loan or disbursement detail records imported from an external system or disbursement detail data in EDExpress
SAS Compare – Disbursement Detail • Compares disbursement detail from SAS file with disbursement detail records imported from an external system or disbursement detail data in EDExpress
Rebuild • CODRBFOP • COD will only send accepted records • Web disbursements & any Endorser Amounts included in file
Rebuild • Rebuild options on import: • Compare Only • Update All • Update Selected records
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
DL Tools Technical Assistance CPS: • 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)
Contact Information We appreciate your feedback and comments. We can be reached at: • Bob Tschinkel: Robert.Tschinkel@ed.gov • Chuck Hirman: Chuck.Hirman@ed.gov