You are here: Reports > Master File Report

MASTER FILE REPORT
​Function 
To produce printable on-screen reports containing all information found within the Loan Master files, the Activity Report, both Loan Master files and Activity Report or Multiple Borrower List.


Operating Instructions

Cutoff Date
This date defaults to the current date but may be changed by selecting from the calendar.  The cutoff date will determine which activity will be included in the report.  Any recorded activity with an activity date beyond the cutoff date will not be included in the calculations. 

Loan Number           
The screen will automatically default to include all loans found within the database.  You may override the default to narrow the selection to only one loan by entering or selecting from the combo box the appropriate loan number in both the beginning field and the “to” field.

Sort Options              
Using the combo box, select the order in which the data is to appear.  Selections include: 

#Loan Number

A Alphabetical

$  Loan Amount 
You may also enter #, A, or $ if do not wish to utilize the combo box.  If the sort is to be by Loan Amount, it will be the amount in the Loan Master file, Loan Terms tab, Loan Amount field.  This does not always match the dollars disbursed.

Report Type              
Master File will include all information within the Loan Master file, including optional fields, for the specified loans.

Activity Report will list all activity posted to the loans specified.

Both Master File and Activity Report produces both the Master File report and Activity Report.

Multiple Borrower List exports Multiple Borrower information into an Excel spreadsheet.

Include FID/SSN      
This field is only available if selecting Master File or Both.  Placing a checkmark in this box will cause the Federal Identification Number or Social Security number to print on your report. 

Notes                         
This field is only available if Activity Report or Both is selected.  Placing a checkmark in this box will result in any Notes that were entered for the activity to appear with that transaction. 

Include All Activity Types
All activity types will automatically be included in your Loan Activity report unless you remove the checkmark and then select either Repayments, Disbursements, or Escrows.

Selection Criteria     
Options for narrowing selection criteria include: 

Fund 

County 

City 

Status 

Loan Officer 

Loan Type 

Borrower Type 
The following instructions relate to limiting the search to specific Fund(s), and the same instructions apply to each of the potential criteria above.

If you do not wish to include all loans, click on the “funds” tab.  All existing funds will be displayed for your selection.  To select a fund, move the cursor to the fund to be included and click – it will then be highlighted, indicating loans with that fund are to be included on the report.  If you wish to include more funds, hold down the Ctrl key and click on the additional fund to be included.  If you select a fund by mistake, hold down the Ctrl key and click on the fund again – the highlighting will disappear, indicating it no longer is to be included in the selection criteria.  Continue this process until you have narrowed the search to include only those loans you wish to review.

Things You Should Know
  • This report may be produced as often as desired with no consequence to the database. 
  • When the report is produced, it will include all pertinent data as of the date and time the report is produced.  
  • Master File Reports will not print for any loans whose Closing Date is after the cutoff date. 
  • If the selection criteria is narrowed for any option, it is important to select “Clear Selections” before beginning again.  Another option for clearing selection criteria is to  “Exit” the report screen and then select “Master File” once again from the Report Menu. 
  • Once the report is displayed on-screen, it may be sent to a printer or exported to a file by clicking on the appropriate icon on the top task bar.