A HandsOn Tour of the Direct Loan Tools Software

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 [phone]
• TDD/TTY services 800/511-5806
• Email CPSSAIG_at_ed.gov
• Representatives are available Monday through
  Friday, 7 a.m. to 7 p.m. (CT).