# Presentation: 378144

## Slide 1

## Session 63	

**Direct Loan Reconciliation****Hands-On**

## Bob Martin, Direct Loan CAM, Dallas

***At Your Assistance***

*** ******Ashley and her GrandDad***

## And....

- Morgan Hamil, Reconciliation Accountant, LOC, Montgomery, AL

**Morgan, husband Chris and niece Kaitlyn**

## Agenda....

- LO-Online
- DL ToolsCashRebuild lost databaseCompare LOC database (732 Report) with school database
- Reports

## Bob’s 8 Steps to Reconciliation Heaven!!

- 1.  Create LOR; Send to LOC
- 2.  Import Acknowledgement (Status =A)
- 3.  Print MPN; Manifest to LOC/eMPN
- 4.  Import Acknowledgement (Status = A)
- 5.  Draw down cash.
- 6.  Cash Management (Business Office)
- 7.  Disburse; Send Disb. Record to LOC
- 8.  Import Acknowledgement (Status = A)

## How long should it take you to “Book” a loan?

- Schools must submit the loan origination record, promissory note, and disbursement record to ED within 30 days of the initial disbursement.  All subsequent disbursement (and adjustment) records must also be submitted within 30 days of the disbursement.

- Session 63-

## Lets’ see how we can achieve reconciliation using these tools...

## LO-Online Web Enhancements......

## DLB 01-05

**Announced  enhancements to the Loan Origination Web site:**

*** ******Navigation***
*** ******Security***
*** ******Change Record******   Processing***
*** ******Audit History***

*** ******MPN Review ***
***Batch Report Options***
*** ******Loan File Rebuild***
*** ******Entrance Counseling******   Results****** ***

## Http://lo-online.ed.gov

**5**

## User Registration

** ****More roles to choose from**
** ****SFAO**
** ****AFAO view or update**
** ****CAFAO view or update**
** ****Credit Check**
** ****Entrance Counseling**
** ****Entrance/Servicing School Servicing**

## Slide 15

- Session 63-

## Change Record Processing

** ****Loans**
** ****Academic Year**
** ****Loan Period**
** ****Loan Amount Approved**
** ****Dependency Status**
** ****HEAL Indicator**
** ****College Year**
** ****Disclosure Print ****   Indicator**
** ****P-Note Print Indicator**

**Anticipated Disbursements**
** ****Date**
** ****Gross **
** ****Changes made via the web are****   not acknowledged back to****   schools**
** ****Changes are edited same as****   through batch**
** ****Change is displayed****   immediately**
** ****Only change one field at a time**

- Session 63-

## People and Loan Information

** ****People and Loan searches separated**
** ****Person Detail:**
** ****demographic information**
** ****local address**
** ****Loan Detail:**
**  ****change loan information **
**  ****change and add new anticipated****    disbursements**

- Session 63-

## Slide 18

- Session 63-

## Slide 19

- Session 63-

## Slide 20

- Session 63-

## Anticipated Disbursements

** ****Change Anticipated Disbursements**
** ****does not change any actual****   disbursement information**
** ****if actual disbursements need to be****   changed, send through batch**

- Session 63-

## MPN Review

**Check to see if student has an MPN on file**
** ****Displays:**
** ****Loan Year**
** ****Status**
** ****Date of MPN**
** ****Expiration Date**
**  ****Indicator for electronic versus paper note**

- Session 63-

## Slide 23

- Session 63-

## How School WillKnow There is a Note

**P-Note Acknowledgement Record**
**LO Acknowledgement Record**
**LO Web Site**
**If you want to know note was electronic:**
**On LO Web Site**
**On LO Acknowledgement Record        (in FILLER)**

**64**

## Batch Report Options

-  Anticipated Disbursement   Listing
-  Actual Disbursement Roster
-  30-Day Warning
-  Inactive Loans
-  SSN/Name/DOB
-  Duplicate Borrower

-  Pending Change over    45 Days
-   Disbursement Activity Not    Yet Booked in Servicing
-  DLSAS (disable only if   program year is closed)
-  732 (disable only if program    year is closed)

* ***SFAO specifies:**
* ***Which reports are received (disable receipt)**
** ****What format (formatted or flat file)**

- Session 63-

## Loan File Rebuild

**SFAO can choose to have data restore ****  sent by:**
** ****Loan ID**
** ****Program Year (for 2000/2001 and forward)**
** ****Date Range**
** ****SSN**
** ****When pending:**
** ****Can change information**
** ****Delete from processing**

- Session 63-

## DL Tools

- Cash Management is Back!!
- Rebuild lost database
- Compare your database and the LOC database

## A Bold New Step for ED!!!

- Session 63-

## DL ToolsFor 2000/2001

**Cash Management**
**Rebuild**
**No ability to run 732 Compare****(Gary’s Compare)   **

##  DL Tools For 2001/2002

**Cash Management****	**
**Rebuild and Compare**
**732 Compare**

## Download From IFAP

*Download From IFAP*

**      ****Same Look and Feel as EDExpress**

## Let’s Look at Setup

***Let’s Look at Setup***

## Setup--Security Users

*Setup--Security Users*

## Compare Process in DL Tools

- Process
- Import Data
- 732 Cash Detail and Loan Detail
- External Cash Detail and Loan Detail
- Print Reports
- 732 Cash Detail
- 732 Loan Detail
- Cash Detail Comparison
- Loan Detail Comparison

- Session 63-

## DL Tools - Compare Lists and Reports

- 732 Cash Detail List
- 732 Loan Detail List
- Cash Detail Comparison Report
- Loan Detail Comparison Report

- Session 63-

## Let’s Look at Each Function

_**Cash Management**__** **_** Available for 00/01 and****  01/02**

## DL Tools -Cash Management

- Tool to track Cash Receipts and Returns of Excess Cash
- Available for 2000-2001 and 2001-2002
- Records entered manually or through external add import

- Session 63-

## DL Tools- Cash Management

- Session 63-

## LOC Drawdown Report

**The date schools should use to compare against internal records.**

**Program Year funds are applied**

- Session 63-

## LOC Excess Cash Reports

**The date funds were deposited by the Department**

**Program Year funds are applied**

- Session 63-

## Or, Click the green $ Icon

*Or, Click the green** $ **Icon*

## Make an Entry, Then Save

*Make an Entry, Then Save*

**Note:**  You can enter positive OR           	negative number for Excess 		Cash!!

**You Can Also Populate the Cash Database by Importing a Cash Detail File From a Mainframe System  (DLEXCASH.xxx)(see the Tech Ref for layouts or print them from DL Tools)**

## Adding Cash Entries en masse

- Session 63-

## “I just lost my database, what do I do?”Request a Rebuild File!!

**Online, via ****       ****http://lo-online.ed.gov**
**Or, By calling your CSR at LOC**

## Slide 47

- Session 63-

## Slide 48

- Session 63-

## Slide 49

- Session 63-

## Date Range Not Supported This Year!

**Date Range **_**Not**_** Supported This Year!**

- Session 63-

## Slide 51

- Session 63-

## Slide 52

- Session 63-

## Do a Rebuild Compare First!!!!

*Do a Rebuild Compare First!!!!*

**You Can Import the File again to update your .mdb file**

## You’ll See Unmatched Origination Records First

***You’ll See Unmatched Origination Records First***

## And Unmatched Disbursement Records next.....

## Once the school is satisfied that they will not overwrite any work they have already done, do the Rebuild Import again--this time for Real!!

- Session 63-

## Voila!!  Instant Database!

- Session 63-

## Finally.....

**Last, but not least:   ****       ****THE 732 COMPARE**
**In 01/02 and subsequent years, ****but not functional for 00/01**

## First, Bring In the 732 Detail File (ED1202OP)

***First, Bring In the 732 Detail File (ED1202OP)***

**Clears any previous 732 in temporary DL Tools database**

## Then, Run Your CompareVia the Print Function

*Then, Run Your Compare**Via the *_*Print*_* Function*

## View the Results...

*View the Results...*

## Reside on School Side Only; Need to be Sent 

*Reside on School Side Only; Need to be Sent *

## Cash Detail Comparison

*Cash Detail Comparison*

## Compare Program

- The Compare Program is a Microsoft Access 97/2000 database that was developed by the Direct Loan School Relations Office CAM’s to assist you in electronically comparing your school data with the 732-LOS Detail Report.

- Session 63-

## Compare Program

- You can contact your Account Manager to get a copy of the program
- There are two versions of the program
- EDExpress
- Mainframe/Custom schools
- There are programs for
- 1997/98
- 1998/99
- 1999/00
- 2000/01

- Session 63-

## Additional Tools/Reports for Making Reconciliation/Closeout a Success

- Session 63-

## What is the BEST tool for Reconciliation?

**Daily, Weekly, Monthly detailed processing.**

- Session 63-

## More Tools.....

***More Tools.....***

- 30 Day Warning
- School/LOC Totals List
- Status Measurement Tools Report
- Disbursement Measurement Report

- Session 63-

## The 2001/02 - DLSAS

- You can receive the DLSAS in one of the following format:
- Text format (current format) - DSAS02OP
- Comma Delimited (new format) - DSAC02OP
- both will be Batch Type “AS”
- both will be transmitted via Student Aid Internet Gateway (SAIG)

- Session 63-

## 2001-02 DLSAS YTD Cash Summary

**Report Time: 08:39:05 2001-2002 Federal Direct Loan Program**
**                      ****Direct Loan School Account Statement                      **
**                                 ****(ALL RECORDS)                                  **
**   ****THIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACT    **
************************************************************************************
**BATCH ID: AS2G0122420011112085816**
**LOC Process Date:  11/12/2001**
**School Code:  G01224**
**Month End:    10/31/2001**
**YEAR-TO-DATE CASH SUMMARY**
**Beginning Balance:                                    $             0**
**    ****Cash Receipts:                  $        50,000**
**    ****Excess Cash Returned:           $        -5,000**
**Total Net Cash Receipts:                              $        45,000**
**    ****Net Booked Disb. Actual:        $       -30,000**
**    ****Net Booked Disb. Adjustments:   $         5,000**
**Total Net Booked Loan Detail:                         $       -25,000**
**Ending Cash Balance:                                  $        20,000**
**------------------------------------------------------------------------------**
**    ****Net Unbooked Disb. Actual:      $        -2,000**
**    ****Net Unbooked Disb. Adjustments: $             0**
**Total Net Unbooked Loan Detail:                       $        -2,000**
**Adjusted Ending Cash Balance:                         $        18,000**

***2001-02 DLSAS YTD Cash Summary***

- Session 63-

## Changes to the DLSAS from prior years

- Year-to-Date Disbursement Summary by Loan Type
- Subsidized Loans (YS)
- Unsubsidized Loans (YU)
- PLUS Loans (YP)
- Total for Subsidized/Unsubsidized/PLUS Loans (YT)

- Session 63-

## 2001-02 DLSAS YTD Disbursement Summary

**Report Time: 08:39:05 2001-2002 Federal Direct Loan Program**
**                      ****Direct Loan School Account Statement                      **
**                                 ****(ALL RECORDS)                                  **
**   ****THIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACT    **
************************************************************************************
**BATCH ID : AS2G0122420011202085816**
**LOC Process Date:  11/12/2001**
**School Code:  G01224**
**Month End:    10/31/2001**
**YEAR-TO-DATE DISBURSEMENT SUMMARY**
**Disbursement Loan Totals:           **
**                                    ****BOOKED LOANS            UNBOOKED LOANS**
**                                    ****-----------------       -----------------**
**      ****Subsidized Gross :            $        10,152         $         2,028 **
**      ****Subsidized Fee :              $           304         $            60 **
**      ****Subsidized Rebate :           $           152         $            32 **
**      ****Subsidized Net :              $        10,000         $         2,000 **
**                                                                            **
**      ****Unsubsidized Gross :          $        15,228         $             0 **
**      ****Unsubsidized Fee :            $           456         $             0 **
**      ****Unsubsidized Rebate :         $           228         $             0 **
**      ****Unsubsidized Net :            $        15,000         $             0 **
**                                                                            **
**      ****PLUS Gross :                  $             0         $             0 **
**      ****PLUS Fee :                    $             0         $             0 **
**      ****PLUS Rebate :                 $             0         $             0 **
**      ****PLUS Net :                    $             0         $             0 **
**                                                                            **
**Total for all Loan Types:                                                   **
**                                                                            **
**      ****Sub/Unsub/PLUS Gross :        $        25,380         $         2,028 **
**      ****Sub/Unsub/PLUS Fee :          $           760         $            60 **
**      ****Sub/Unsub/PLUS Rebate :       $           380         $            32 **
**      ****Sub/Unsub/PLUS Net :          $        25,000         $         2,000 **
**                                                                            **
**                                                                            **

***2001-02 DLSAS YTD Disbursement Summary***

- Session 63-

## 2001-02 DLSAS Monthly Cash Summary

**Report Time: 08:39:05 2001-2002 Federal Direct Loan Program**
**                      ****Direct Loan School Account Statement                      **
**                                 ****(ALL RECORDS)                                  **
**   ****THIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACT    **
************************************************************************************
**LOC Process Date:  11/12/2001**
**School Code:  G01224**
**Month End:    10/31/2001**
**MONTHLY CASH SUMMARY**
**Beginning Balance:                                    $             0**
**    ****Cash Receipts:                  $        35,000**
**    ****Excess Cash Returned:           $        -5,000**
**Total Net Cash Receipts:                              $        30,000**
**    ****Net Booked Disb. Actual:        $       -15,000**
**    ****Net Booked Disb. Adjustments:   $         5,000**
**Total Net Booked Loan Detail:                         $       -10,000**
**Ending Cash Balance:                                  $        20,000**
**------------------------------------------------------------------------------**
**    ****Net Unbooked Disb. Actual:      $        -2,000**
**    ****Net Unbooked Disb. Adjustments: $             0**
**Total Net Unbooked Loan Detail:                       $        -2,000**
**Adjusted Ending Cash Balance:                         $        18,000**

***2001-02 DLSAS Monthly Cash Summary***

- Session 63-

## Changes to the DLSAS from prior years

- Monthly Disbursement Summary by Loan Type
- Subsidized Loans (MS)
- Unsubsidized Loans (MU)
- PLUS Loans (MP)
- Total for Subsidized/Unsubsidized/PLUS Loans (MT)

- Session 63-

## 2001-02 DLSAS Monthly Disburse. Summary

**Report Time: 08:39:05 2001-2002 Federal Direct Loan Program**
**                      ****Direct Loan School Account Statement                      **
**                                 ****(ALL RECORDS)                                  **
**   ****THIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACT    **
************************************************************************************
**BATCH ID : AS2G0122420011112085816**
**LOC Process Date:  11/12/2001**
**School Code:  G01224**
**Month End:    10/31/2001**
**MONTHLY DISBURSEMENT SUMMARY**
**Disbursement Loan Totals:           **
**                                    ****BOOKED LOANS            UNBOOKED LOANS**
**                                    ****-----------------       -----------------**
**      ****Subsidized Gross :            $         5,076         $         2,028 **
**      ****Subsidized Fee :              $           152         $            60 **
**      ****Subsidized Rebate :           $            76         $            32**
**      ****Subsidized Net :              $         5,000         $         2,000 **
**                                                                            **
**      ****Unsubsidized Gross :          $        10,152         $             0 **
**      ****Unsubsidized Fee :            $           304         $             0 **
**      ****Unsubsidized Rebate :         $           152         $             0 **
**      ****Unsubsidized Net :            $        10,000         $             0 **
**                                                                            **
**      ****PLUS Gross :                  $             0         $             0 **
**      ****PLUS Fee :                    $             0         $             0 **
**      ****PLUS Rebate :                 $             0         $             0 **
**      ****PLUS Net :                    $             0         $             0 **
**                                                                            **
**Total for all Loan Types:                                                   **
**                                                                            **
**      ****Sub/Unsub/PLUS Gross :        $        15,228         $         2,028 **
**      ****Sub/Unsub/PLUS Fee :          $           456         $            60 **
**      ****Sub/Unsub/PLUS Rebate :       $           228         $            32 **
**      ****Sub/Unsub/PLUS Net :          $        15,000         $         2,000 **

***2001-02 DLSAS Monthly Disburse. Summary***

- Session 63-

## DLSAS Cash Detail

**Report Date: 11/15/2001   U.S. DEPARTMENT OF EDUCATION                PAGE:  5**
**Report Time: 08:39:05 2001-2002 Federal Direct Loan Program**
**                      ****Direct Loan School Account Statement                      **
**                                 ****(ALL RECORDS)                                  **
**   ****THIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACT    **
************************************************************************************
**LOC Process Date:  11/12/2001**
**School Code:  G01224**
**Month End:    10/31/2001**
**CASH DETAIL RECORDS FOR THIS MONTH**
**TRANS TYPE     DATE         AMOUNT             GAPS CONTROL #      CHECK #**
**----------     ----------   ---------------    --------------      -------**
**Cash Receipt   10/02/2001   $        15,000    1234567890123                   **
**Excess Cash    10/05/2001   $         5,000   ****	****	****    5939**
**Cash Receipt   10/30/2001   $        20,000    2154567890123**

- Session 63-

## 732 Report

- The 732 Report is a report generated by the Loan Origination Center (LOC) to assist schools with their reconciliation and  Program Year Close Out (PYCO). It contains the following segments:
- Year-to-Date Cash Summary
- Cash Detail
- Loan-level Detail

- Session 63-

## 732 Cash Summary

- Session 63-

## 732 Cash Detail

- Session 63-

## 732 Loan Detail

- Session 63-

## The 2001/02 -732 Report

**You can receive the 732 in one of the following options:**
- Current 732 Loan Detail Report with Year-to-Date loan level totals
- New 732 Disbursement Activity Report which contains:
- disbursement summary by loan type
- cash receipt
- excess cash
- disbursement activity detail information
- cash summary

- Session 63-

## The 2001/02 -732 Report

-  **732 Loan Detail Report**:
- Message Class ED1202OP/ED0902OP includes
- Disbursement Summary Records
- YS - summary for Subsidized (Sub) Loans
- YU - summary for Unsubsidized (Unsub) Loans
- YP - summary for Plus Loans
- YT - summary for Sub, Unsub and Plus
- Cash Receipts (“R”)
- Excess Cash (“X”)
- Loan Detail (“B” or “U”)

- Session 63-

## 732 Disbursement Totals

- Session 63-

## 732 Disbursement Detail

- Session 63-

##  	For More Information on    Reconciliation and Closeout, attend:

- Session 12: Direct Loan Database Management- Avoiding Common Mistakes
- Session 17: Direct Loan Tools- More Uses than Duct Tape
- Computer Lab Reconciliation Help Area
- Spring Reconciliation Training offered by the regional CAMS (look for upcoming training at http://www.ed.gov/offices/OPE/announce/trng/)

***More Information***

- Session 63-

## Reconciliation Assistance

- Contact:
- Your regional Client Account Management Staff (see list on following slide)
- Your Customer Service Representative or Reconciliation Accountant at the LOC, (800) 848-0978 or loan_origination@mail.eds.com
- Direct Loan Operations  (202) 205-6466

- Session 63-

## CAM Contact Information

_**Region**_**	****	****	**_**States**__**	**_**	****	**_**Number**_
- I-Boston	CT, MA, ME, NH, RI, VT		(617) 565-6911
- II-New York	NJ, NY, PR, VI			(212) 264-8012
- III-Philadelphia	DC, DE, MD, PA, VA, WV		(215) 656-5929
- IV-Atlanta	AL, FL, GA, KY, MS, NC, SC, TN	(404) 562-6259
- V-Chicago	IL, IN, OH, MI, WI			(312) 886-8766
- VI-Dallas	AR, LA, NM, OK, TX		(214) 880-2405
- VII-Kansas City	IA, KS, MO, NE			(816) 880-4090
- VIII-Denver	CO, MN, MT, ND, SD, UT, WY	(303) 844-3677
- IX-San Francisco	AZ, CA, HI, NV			(415) 556-4201
- X-Seattle	AK, ID, OR, WA			(206) 287-9840

- Session 63-

## 

Questions ?

**Questions ?**

- Session 63-

## Let’s Get Busy.....

- Instructor Demo/Participant Hands-On....