Direct Loan Tools Release 21.0 Reports VOLUME IV SECTION 4
Direct Loan Tools Release21.0 ReportsVOLUME IVSECTION4This section provides an overview and examples of the many reports that Direct Loan (DL)Tools Release 21.0 can generate to assist with your loan processing and reconciliationactivities.Table of ContentsREPORTS . 2Internal Ending Cash Balance Report . 2SAS Cash Summary . 5SAS Disbursement Summary . 8Cash Detail Comparison .11Loan Detail Comparison – Loan Level .14Disbursement Detail Comparison.17SAS Cash Detail .22SAS Loan and Disbursement Detail .23Disbursement Measurement Tool Report (EDExpress Schools Only) .26June 20212021-2022 COD Technical ReferenceVolume IV – DL ToolsPage IV - 4 - 1
Direct Loan Tools Release 21.0 ReportsReportsImportant Printing Note: Somereport samples in this section aredisplayed in landscape format. Youmay need to adjust your printerconfiguration and print these pagesseparately.See Volume VI, Section 8 (CODReports), of the 2021-2022 CODTechnical Reference for more detailedinformation on Direct Loan SchoolAccount Statement (SAS) files.All comparison reports are run fromthe Compare dialog box, which isaccessible from the software toolbaror the Tools menu. SAS summaryreports are printed from the Printdialog box.Using DL Tools, Release 21.0, you can print a variety of reports to assistyour Direct Loan processing and reconciliation performance. Thissection provides a description and an example for each of the followingreports:Located within the Print function: Internal Ending Cash Balance Report Direct Loan School Account Statement (SAS) Cash Summary SAS Disbursement Summary SAS Cash Detail SAS Loan and Disbursement Detail Disbursement Measurement Tool Report (EDExpress schools only)Located within the Compare function: Cash Detail Comparison Loan Detail Comparison – Loan Detail Disbursement Detail ComparisonEach report example represents the 2021-2022 Award Year. Keep inmind that you can also run 2019-2020 and 2020-2021 reports in Release21.0.Internal Ending Cash Balance ReportNew for Release 21.0! Weredesigned all DL Tools reports toconvey information in a moreaccessible, readable format.For the Internal Ending Cash BalanceReport to provide an accurate schoolending cash balance, both cashrecords and loan/disbursementrecords must be available to thesoftware. Schools that do not usethe Cash Management function in DLTools, do not import loan anddisbursement records from anexternal file, or do not have aconnection to EDExpress will notobtain helpful results from this report.Page IV - 4 - 2The Internal Ending Cash Balance Report calculates and displays theschool internal ending cash balance based on Cash Receipts and Refundsof Cash entered or imported in Cash Management in DL Tools, anddisbursement amounts from your school’s EDExpress database orloan/disbursement amounts imported into DL Tools from an external filesource (non-EDExpress schools). The cash detail can be imported usingthe Cash Detail External Add file (DLEXCASH), and the disbursementdetail can be imported using the Disbursement Detail External Add file(DLEXDISB). External record layouts are provided in Volume IV,Section 3, of the 2021-2022 COD Technical Reference.This report is available for the 2019-2020, 2020-2021, and 2021-2022program years in Release 21.0. An EDExpress database connection isoptional.When printing an Internal Ending Cash Balance Report, if you have notidentified a school code in System setup, then you can identify aparticular school code in the DL Tools Print dialog box. If you leave theschool code blank in the Print dialog box, then an Internal Ending CashBalance Report is printed for all school codes in your school’s databasefor the designated program year.2021-2022 COD Technical ReferenceVolume IV – DL ToolsJune 2021
ReportsExample 1Below is an example of an Internal Ending Cash Balance Report –Summary with Disbursement Data Source EDExpress:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONPage: 1Report Time: 17:21:07Direct Loan Tools – 2021-2022Internal Ending Cash Balance – Summary – Print ReportTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code:G99999Transaction Date Range:Cash Receipts:Refunds of Cash:Total Cash (Receipts – Refunds of Cash):Total School Disbursement Net Amount from External Data:Ending Cash Balance (Total Cash - Total Net Disbursements):01/01/2022 to 01/31/2022 189,025 30,124 158,901 53,721 105,180Example 2Below is an example of an Internal Ending Cash Balance Report –Summary with Disbursement Data Source External Source:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONPage: 1Report Time: 14:03:06Direct Loan Tools – 2021-2022Internal Ending Cash Balance – Summary – Print ReportTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code:G99999Transaction Date Range:Cash Receipts:Refunds of Cash:Total Cash (Receipts – Refunds of Cash):Total School Disbursement Net Amount from External Data:Ending Cash Balance (Total Cash - Total Net Disbursements):June 20212021-2022 COD Technical ReferenceVolume IV – DL Tools01/01/2022 to 01/31/2022 189,025 30,124 158,901 0 158,901Page IV - 4 - 3
Direct Loan Tools Release 21.0 ReportsExample 3Below is an example of an Internal Ending Cash Balance Report – DetailSorted by Transaction Type:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONReport Time: 14:03:06Direct Loan Tools – 2021-2022Internal Ending Cash Balance Report – Detail – Print ReportPage: 1Sort: TypeTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool action Date Range:Date01/01/2022 to 9/20221/20/20221/23/20221/24/20221/26/2022 3,650 3,780 4,084 5,881 9,217 9,540 40 147,483 3,350 2,000 125 3,588 3,408 3,335 3,312 3,179 3,124 3,095 3,037 3,921Grand TotalsTypeCash ReceiptsRefunds of CashPage IV - 4 - 4Count1010Amount 189,025 30,1242021-2022 COD Technical ReferenceVolume IV – DL ToolsJune 2021
ReportsSAS Cash SummaryThe SAS Cash Summary contains both a monthly and a year-to-datesummary of cash and loan data processed by the Common Originationand Disbursement (COD) System. This report can be compared tosummary information on the school’s internal systems. You can print amonthly cash summary, year-to-date cash summary, or both.The SAS Cash Summary is availablefrom the Print dialog box. You canprint the report at any time followingthe import of a SAS file.Note: The SAS cash summary information stored in your databasecorresponds to the most recent SAS file you imported. The summarydata is overwritten with each SAS import.An EDExpress database connection is optional, as this report prints cashsummary data from the SAS, which is stored in the DL Tools database.June 20212021-2022 COD Technical ReferenceVolume IV – DL ToolsPage IV - 4 - 5
Direct Loan Tools Release 21.0 ReportsExample 1Below is an example of a SAS Cash Summary – Type is Monthly:Report Date: 02/01/2022Report Time: 13:27:01U.S. DEPARTMENT OF EDUCATIONPage: 1Direct Loan Tools – 2021-2022SAS Monthly Cash Summary – Print ReportTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code:Region Code:G999999End Date:1/31/2022State Code:CANet Drawdowns/PaymentsTypeCash ReceiptsRefunds of CashAmount 0.00 0.00Net Booked (Accepted) DisbursementsTypeAmountDisbursementsAdjustments 22,222.00 0.00Net Unbooked (Pending) DisbursementsTypeDisbursementsAdjustmentsAmount 0.00 0.00Statement TotalBeginning Cash Balance:Net Drawdowns/Payments:Net Booked (Accepted) DisbursementsEnding Cash Balance:Net Unbooked (Pending) Disbursements:Cash Accepted and Posted Disbursements:Page IV - 4 - 6 0.00 33,333.00 22,222.00 11,111.00 0.00 11,111.002021-2022 COD Technical ReferenceVolume IV – DL ToolsJune 2021
ReportsExample 2Below is an example of a SAS Cash Summary – Type is Year-to-Date:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONPage: 1Report Time: 13:27:01Direct Loan Tools – 2021-2022SAS Year-to-Date Cash Summary – Print ReportTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code:Region Code:G999999End Date:1/31/2022State Code:CANet Drawdowns/PaymentsTypeCash ReceiptsRefunds of CashAmount 0.00 0.00Net Booked (Accepted) DisbursementsTypeAmountDisbursementsAdjustments 22,222.00 0.00Net Unbooked (Pending) DisbursementsTypeDisbursementsAdjustmentsAmount 0.00 0.00Statement TotalBeginning Cash Balance:Net Drawdowns/Payments:Net Booked (Accepted) DisbursementsEnding Cash Balance:Net Unbooked (Pending) Disbursements:Cash Accepted and Posted Disbursements:June 2021 0.00 33,333.00 22,222.00 11,111.00 0.00 11,111.002021-2022 COD Technical ReferenceVolume IV – DL ToolsPage IV - 4 - 7
Direct Loan Tools Release 21.0 ReportsSAS Disbursement SummaryThe SAS Disbursement Summaryreport is available from the Printdialog box. You can print the reportat any time following the import of aSAS file.This section of the SAS provides monthly and year-to-date summarydisbursement information for the reported period. It can be used tomonitor loan volumes at the summary level (both booked and unbooked)for all loan types processed by the COD System. You can print amonthly disbursement summary, year-to-date disbursement summary, orboth.Note: The SAS disbursement summary information stored in yourdatabase corresponds to the most recent SAS file you imported. Thesummary data is overwritten with each SAS import.An EDExpress database connection is optional.Page IV - 4 - 82021-2022 COD Technical ReferenceVolume IV – DL ToolsJune 2021
ReportsExample 1Below is an example of a SAS Disbursement Summary – Type isMonthly:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONPage: 1Report Time: 10:05:48Direct Loan Tools – 2021-2022SAS Monthly Disbursement Summary – Print ReportTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code:Region Code:G999999Account TypeBooked GrossBooked FeeBooked RebateBooked NetUnbooked GrossUnbooked FeeUnbooked RebateUnbooked NetJune 2021End Date:1/31/2022State Code:CASubsidizedUnsubsidized 6,750 63 0 6,687 0 0 0 0 10,000 102 0 10,398 0 0 0 02021-2022 COD Technical ReferenceVolume IV – DL ToolsPLUSTotal 24,306 972 0 23,334 0 0 0 0 41,556 1,137 0 40,419 0 0 0 0Page IV - 4 - 9
Direct Loan Tools Release 21.0 ReportsExample 2Below is an example of a SAS Disbursement Summary – Type is Yearto-Date:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONPage: 1Report Time: 10:06:54Direct Loan Tools – 2021-2022SAS Year-to-Date Disbursement Summary – Print ReportTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code:Region Code:G999999Account TypeBooked GrossBooked FeeBooked RebateBooked NetUnbooked GrossUnbooked FeeUnbooked RebateUnbooked NetPage IV - 4 - 10End Date:1/31/2022State Code:CASubsidized 6,750 63 0 6,687 0 0 0 0Unsubsidized 10,000 102 0 10,398 0 0 0 02021-2022 COD Technical ReferenceVolume IV – DL ToolsPLUSTotal 24,306 972 0 23,334 0 0 0 0 41,556 1,137 0 40,419 0 0 0 0June 2021
ReportsCash Detail ComparisonThe Cash Detail Comparison report compares cash detail records in theSAS file received from the COD System to the cash detail records in DLTools Cash Management. Cash Management records are enteredmanually or through the Cash Detail External Add (DLEXCASH) importoption. Since only Cash entries (Drawdowns and Refunds of Cash) areused for the Cash Detail Comparison report, no disbursement detailinformation is printed on this report. External record layouts are foundin Volume IV, Section 3, of the 2021-2022 COD Technical Reference.An EDExpress database connection is optional, as this report comparescash data, which is not currently stored in the EDExpress database.The Cash Detail Comparison reportuses the tolerance setting in DLTools’ System Setup (Tools, Setup,System) to account for timingdifferences between the entry dateson your school system and the datesrecorded for cash transactions by theprocessors. The System Setup fieldlabeled Maximum number of daysdifference between SAS Cashrecords and cash records enteredby the school which will beconsidered a match allows you toenter the number of days betweenSAS cash records and cash recordsentered by your school that areconsidered a match when running theCash Detail Comparison report. Adrawdown or refund of cashtransaction is considered a mismatchif the number of days between thedate reported by the school and thedate reported on the SAS exceedsthis tolerance.When printing a Cash DetailComparison Report, if you have notidentified a school code in Systemsetup, you can identify a particularschool code in the DL Tools Comparedialog box. If you leave the schoolcode blank in the Compare dialogbox, then a Cash Detail Comparisonreport is printed for all school codesin your school’s database for thedesignated program year.June 20212021-2022 COD Technical ReferenceVolume IV – DL ToolsPage IV - 4 - 11
Direct Loan Tools Release 21.0 ReportsExample 1Below is an example of a Cash Detail Comparison – Sorted by Type:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONReport Time: 13:07:58 Direct Loan Tools for Windows – 2021-2022Cash Detail Comparison – Compare ReportPage: 1Sort: TypeTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code:G99999Match Status:AllTolerance (# of dRefundRefundRefundRefundRefundRefundDate Range: All DatesTransaction Type: 6/2022 112 3,126 3,350 5,881 9,217 3,780 378 4,084 1,247 4,084 5,881 3,350 9,217 1,797 9,540 954 40 147,483 2,000 3,650 3,921 698 751 874 1,234 3,588 254 333 632 3,408 988 3,335 3,312 555 4,321 3,179 3,124 3,095 3,037 125Match StatusRecord SchoolCODCODSchoolSchoolSchoolSchoolSchoolGrand TotalsRecord TypeMatchedUnmatchedCODSchoolPage IV - 4 - 12Count23820202021-2022 COD Technical ReferenceVolume IV – DL ToolsJune 2021
ReportsExample 2Below is an example of a Cash Detail Comparison –Sorted by Date:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONReport Time: 13:10:12 Direct Loan Tools for Windows – 2021-2022Cash Detail Comparison – Compare ReportPage: 1Sort: DateTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code:G99999Match Status:AllTolerance (# of 23/20221/24/20221/25/20221/26/2022Date Range: All DatesTransaction Type: AllAmount 112 3,126 3,350 5,881 9,217 3,921 698 751 874 3,780 378 4,084 1,234 3,588 1,247 4,084 5,881 254 333 3,350 9,217 632 3,408 1,797 9,540 988 954 3,335 40 3,312 555 4,321 3,179 147,483 3,124 2,000 3,095 3,037 3,650 125Match StatusRecord SchoolSchoolSchoolSchoolSchoolSchoolSchoolGrand TotalsRecord TypeMatchedUnmatchedCODSchoolJune 2021Count23820202021-2022 COD Technical ReferenceVolume IV – DL ToolsPage IV - 4 - 13
Direct Loan Tools Release 21.0 ReportsLoan Detail Comparison – Loan LevelThis report compares the loan detail records from the SAS file receivedfrom the COD System with loan or disbursement detail records importedfrom an external system or loan detail data in EDExpress. The LoanDetail External Add (DLEXLOAN) record layout is provided in VolumeIV, Section 3, of the 2021-2022 COD Technical Reference.Note: DL Tools Loan and Disbursement Comparison Reports aredesigned to be run using the SAS with year-to-date detail, not monthlydetail. You can change your SAS options by accessing the COD Web siteat cod.ed.gov.If your school has not imported abooking notification for the loan butthe SAS shows that the loan isbooked, the loan appears in the“Booked Records That AreUnmatched” section. The bookingstatus is set according to the CODSystem, not according to yourschool’s database. If your schoolreceives a DSDF with monthly detail,then no loans appear in this sectionwhen the Loan Level Compare is run(unless the SAS shows the loan asunbooked and your school datashows that the loan total is 0). Thisomission is due to the fact that loantotals in the monthly detail section ofthe SAS are always 0.Records are grouped into four sections on the report, based on selectedmatch status (Matched, Unmatched, or All) and booked status (Booked,Unbooked, or Both Booked and Unbooked). The four sections are:Booked Records That Are Matched - Loan records appear in thissection of the Compare report if the SAS shows a booked date and theloan data in the SAS matches the data in your school’s database. If youreceive a DSDF with monthly detail, then loans never appear in this sectionwhen the Loan Level Compare is run, since the loan totals in the monthlydetail section of the SAS are always 0.Booked Records That Are Unmatched - Loan records appear in thissection of the Compare report if the loan appears on the SAS as booked,but the data does not appear in your school’s database; otherwise, there isa discrepancy between the COD System data and the school data. If yourschool receives a DSDF with monthly detail, all loans that appear in theSAS as booked are included in this section when the Loan Level Compareis run, unless the loan was reduced to 0 at the school.Unbooked Records That Are Matched - Loan records appear in thissection of the Compare report if the loan appears on the SAS as unbookedand the amounts match between the COD System and the school.A Loan Detail Comparison – LoanLevel Report runs regardless of thetype of SAS (DSLF or DSDF) that hasbeen imported into DL Tools, as longas the SAS contains either loan detailor disbursement detail. AnEDExpress database connection isoptional. When printing a Loan DetailComparison, if you have notidentified a school code in Systemsetup, then you can identify aparticular school code in the DL ToolsCompare dialog box. If you leave theschool code blank in the Comparedialog box, the Loan DetailComparison report prints for allschool codes in your school’sdatabase for the designated programyear.Page IV - 4 - 14Unbooked Records That Are Unmatched - Loan records will appear inthis section of the Compare report if the loan exists in your school’sdatabase but does not appear on the SAS; if the loan appears as unbookedon the SAS, but the record does not appear in your school’s database; or ifthere is a discrepancy between the COD System data and the school datafor an unbooked loan. If your school receives a DSDF with monthly detail,then any disbursements that were accepted in a previous month would notbe on the monthly SAS and would, therefore, appear in this section.2021-2022 COD Technical ReferenceVolume IV – DL ToolsJune 2021
ReportsExample 1Below is an example of a Loan Detail Comparison – Loan Level, Sortedby Loan ID, Page 1:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONPage: 1Report Time: 13:21:21 Direct Loan Tools for Windows – 2021-2022Loan Detail Comparison – Matched Booked Records – Compare ReportSort: Loan IDTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code: G99999Match Status:AllLoan ID999999999S22G99999001Date Range:Student NameRED, ROBERTANetSchoolAmountCOD 249 2491/31/2022# SchoolDisbursementsExample 2Below is an example of a Loan Detail Comparison – Loan Level, Sortedby Loan ID, Page 2:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONPage: 2Report Time: 13:21:21 Direct Loan Tools for Windows – 2021-2022Loan Detail Comparison – Unmatched Booked Records – Compare ReportSort: Loan IDTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code: G99999Match Status:AllLoan une 2021Date Range:Student NameNetSchoolPINK, JACK 498BLUE, JOHN 732BLACK, BUD 9751/31/2022AmountCOD# SchoolDisbursements 1,244 2,228 1,244 852 1,244 488 1,24401010102021-2022 COD Technical ReferenceVolume IV – DL ToolsPage IV - 4 - 15
Direct Loan Tools Release 21.0 ReportsExample 3Below is an example of a Loan Detail Comparison – Loan Level, Sortedby Loan ID, Page 3:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONPage: 3Report Time: 13:21:21 Direct Loan Tools for Windows – 2021-2022Loan Detail Comparison – Matched Unbooked Records – Compare ReportSort: Loan IDTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code: G99999Match Status:AllDate Range:Loan IDStudent Name999999999S22G99999001GREEN, GLENDA1/31/2022NetSchoolAmountCOD# SchoolDisbursements 249 2491Example 4Below is an example of a Loan Detail Comparison – Loan Level, Sortedby Loan ID, Page 4:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONPage: 4Report Time: 13:21:21 Direct Loan Tools for Windows – 2021-2022Loan Detail Comparison – Unmatched Unbooked Records – Compare ReportSort: Loan IDTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code: G99999Match Status:AllDate Range:Loan IDNetSchoolStudent , WILLIAMBROWN, BARRYTAN, TERESAGREEN, GREGBLUE, BELINDABROWN, BILLWHITE, WENDELLBLACK, BARBARA 249 249 498 498 732 732 975 975PURPLE, PAUL 498RED, RICHARD 732TAN, THOMAS 975ORANGE, OSCARGRAY, GINAPINK, PAULA 100 100 100 100AmountCOD1/31/2022# SchoolDisbursements111111110101001002222 955 2,228 2,228 488 1,244 852 3,657 1,244 3,657Grand TotalsBooked otal82230*** School Records Outside Of SAS Date Range Will Appear In This Section ***Page IV - 4 - 162021-2022 COD Technical ReferenceVolume IV – DL ToolsJune 2021
ReportsDisbursement Detail ComparisonThis report, which you can print from the Compare dialog box, comparesdisbursement detail records from the SAS file received from the CODSystem with disbursement detail records imported from an externalsystem or disbursement detail data in EDExpress. The DisbursementDetail External Add (DLEXDISB) record layout is provided in VolumeIV, Section 3, of the 2021-2022 COD Technical Reference.Note: DL Tools Loan and Disbursement Comparison Reports aredesigned to be run using the SAS with year-to-date detail, not monthlydetail. You can change your SAS options by accessing the COD Web siteat cod.ed.gov.Records are grouped into four sections on the report based on selectedmatch status (Matched, Unmatched, or All) and booked status (Booked,Unbooked, or Both Booked and Unbooked). The four sections are:Matched Booked Records - Disbursement records appear in this sectionof the Compare report if the SAS shows a booked date and thedisbursement data in the SAS matches the data in your school’s database.Unmatched Booked Records - Disbursement records appear in thissection of the Compare report if the disbursement appears on the SAS asbooked, but the data does not appear in your school’s database; or there isa discrepancy between the COD System data and the school data.Matched Unbooked Records - Disbursement records appear in thissection of the Compare report if the disbursement appears on the SAS asunbooked, and the dates and amounts match between the COD Systemand the school.Unmatched Unbooked Records - Disbursement records appear in thissection of the Compare report if the disbursement exists in your school’sdatabase but does not appear on the SAS; the disbursement appears asunbooked on the SAS, but the record does not appear in your school’sdatabase; or there is a discrepancy between the COD System data and theschool data for an unbooked loan. If your school receives a DSDF withmonthly detail, then any disbursements that were accepted in a previousmonth would not be on the monthly SAS and would therefore appear inthis section.DL Tools compares the disbursements recorded in EDExpress to thecorresponding disbursements in the SAS by doing a one-to-onecomparison of each disbursement using the disbursement number,sequence number, disbursement date, and disbursement amounts.June 20212021-2022 COD Technical ReferenceVolume IV – DL ToolsIf your school has not imported abooking notification for the loan butthe SAS shows that the disbursementhas booked, then the disbursementappears in the “Booked Records ThatAre Unmatched” section. Thebooking status is according to theCOD System, not according to yourschool’s database.The SAS end date always supersedesthe date range specified if that datefalls beyond the SAS end date.A Disbursement Detail ComparisonReport runs only if a disbursementlevel report (DSDF) withdisbursement detail has beenimported into DL Tools. If yourschool imports a loan-level report(DSLF) rather than a DSDF, then youcannot run this report. An EDExpressdatabase connection is optional.When printing a Disbursement DetailComparison, if you have notidentified a school code in Systemsetup, you can identify a particularschool code in the DL Tools Comparedialog box. If you leave the schoolcode blank in the Compare dialogbox, a Disbursement DetailComparison report is printed for allschool codes in your school’sdatabase for the designated programyear.Page IV - 4 - 17
Direct Loan Tools Release 21.0 ReportsExample 1Below is an example of a Disbursement Detail Comparison – Sorted byLoan ID, Page 1:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONPage: 1Report Time: 09:48:40 Direct Loan Tools for Windows – 2021-2022Disbursement Detail Comparison – Matched Booked Records – Compare ReportSort: Loan IDTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code: G99999Match Status:AllLoan 999P22G99999001999999999P22G99999001Page IV - 4 - 18Date Range:End Date:Student NameRED, ROBERTABROWN, BARRYTAN, TERESAGREEN, GREG2021-2022 COD Technical ReferenceVolume IV – DL ToolsDisb # Seq11111111NetSchool 249 498 732 975All dates1/31/2022AmountCOD 249 498 732 975June 2021
ReportsExample 2Below is an example of a Disbursement Detail Comparison – Sorted by Loan ID, Page 2:Report Date: 02/01/2022U.S. DEPARTMENT OF EDUCATIONReport Time: 09:48:40Direct Loan Tools for Windows – 2021-2022Disbursement Detail Comparison – Unmatched Booked Records – Compare ReportPage: 2Sort: Loan IDTHIS DOCUMENT CONTAINS SENSITIVE INFORMATION PROTECTED BY THE PRIVACY ACTSchool Code: G99999Match Status:AllLoan ID:Date Range:End Date:999999999S22G99999001Exists?Disb #Seq11Loan ID:DateSchoolCODSchoolYesNo1/3/2022Disb #Seq11CODSchoolRebateCOD 2SchoolCOD 1Seq11CODSchoolYesNo1/4/2022GrossCODSchoolFeeCOD 500SchoolRebateSeq11NetNet AdjSchoolCODSchoolCOD 5SchoolCOD 3SchoolBLUE, BELINDANet AdjCODSchool D 750SchoolRebateCOD 30SchoolNetCOD 12DateSchoolCODSchoolYesNo1/7/2022GrossCODSchool 1,000FeeCODSchoolRebateCOD 402021-2022 COD Technical ReferenceVolume IV
Direct Loan Tools Release 21.0 Reports Page IV - 4 - 2 2021-2022 COD Technical Reference June 2021 Volume IV – DL Tools Reports Using DL Tools, Release 21.0, you can print a variety of reports to assist your Direct Loan processing and reconciliation performance. This section provid
6. Loan geography 8. 7. Contractual cash flows for each loan or pool of loans Risk System Data: 1. Loan classes and grades 2. Modification history by loan class 3. Loan renewal and funding history by loan class 4. Loan prepayments history by loan class 5. Loan cash flows not collected 6. Loan grade LGD and PD rates 7. Loan grade charge-off history
loan is serviced (payment and interest calculations, payment spread, G/L accounts, etc.). A Loan Product is a template for how a specific type of loan is sold to your members. Multiple loan products can be tied to individual loan categories. Examples of loan products include your credit union's used car loan offering, new car
last loan of a loan sequence. For more than 80% of the loan sequences that last for more than one loan, the last loan is the same size as or larger than the first loan in the sequence. Loan size is more likely to go up in longer loan sequences, and prin
Loan product - select the type of loan. Basic Home Loan - Get back to basics with our no-frills, variable rate home loan - low interest rate, fees and stress. Flexible Home Loan - Customise to your heart's content. With options to fix, split or offset, you can create a loan to fit your lifestyle. Loan purpose. Primary purpose.
Loan Estimate and Closing Disclosure Time Chart 1 TILA RESPA Time Chart 3 Loan Estimate Rounding Chart 5 Closing Disclosure Rounding Chart 9. LOAN ESTIMATE . CFR Reference Loan Estimate Disclosure Annotated 15 H-24(A) Mortgage Loan Transaction Loan Estimate 19 H-24(B) Fixed Rate Loan 31 H-24(C) Interest Only Adjustable Rate Loan 35 H-24(D .
Community Banks( 3B) vs. Regionals( 20B- 100B) Loan Yields vs. Market Rates Attendee Submitted Loan Pricing Case Studies Community Bank ROE and Loan ROE Trends Loan Pricing in a Rising Rate Environment . 5 TRENDS 6.44 5.09 5.11 4.75 5.25 5.75 6.25 6.75 Loan Yields Community Bank Loan Yields Regional Bank Loan Yields
Keywords: Loan System, Loan Automation, Loan Application, Design Loan System, Design Loan Application. 1.0. Introduction A loan is an amount of money given to an individual or institution on the condition that it will be paid back over a . Non-functional Specification Non-functional requirements are good to haves. The non-functional .
An Introduction to Effective Field Theory Thinking Effectively About Hierarchies of Scale C.P. BURGESSc. i Preface It is an everyday fact of life that Nature comes to us with a variety of scales: from quarks, nuclei and atoms through planets, stars and galaxies up to the overall Universal large-scale structure. Science progresses because we can understand each of these on its own terms, and .
