You are here: Reports > Analysis by Fund

ANALYSIS BY FUND
Function
To assist with reconciling loan portfolio records with accounting records.


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 selection by either entering the loan # or selecting from the combo box. To narrow the selection to only one loan, enter or select 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 based on the amount in the Loan Master file, Loan Terms tab, Loan Amount field. This does not always match the dollars disbursed.

Report Type 
Detail provides a report itemizing the activity recorded to each loan prior to the cutoff date, along with a Summary totaling each loan fund as the final page of the report.

Summary produces the activity totals by loan fund without the itemizing detail listing.

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.

Interpreting the Analysis by Fund Report

At the top of the report, you will find the selection criteria, including cutoff date, as entered. The date and time of the report is also included.

Loan Reflects the number associated with each loan.

Company/Borrower 
If the Loan Master file contains information found under “Company Loan Information” the company name as entered will appear. If the Loan Master file contains information under “Personal Loan Information” the first and last name of the borrower will appear.

Funding Source 
Reflects the funding sources assigned in the Loan Master file and

Code & % 
The ratio between the amount assigned to the fund code and the total Loan Amount.

Loan Amount 
This is the number listed under Loan Amount within the Loan Master file.

Disbursed 
Reflects the total amount disbursed to the loan as of the cutoff date.

Analysis of Principal, Interest, Service Fees, Penalties, Escrows, and Other Payments 
Miscellaneous Fees are separated and itemized by loan.

Loan Balance 
Reflects the loan balance as of the last recorded activity prior to the cutoff date.

Accrd Int 
Reflects any accrued interest recorded within the loan history as of the cutoff date.

Things You Should Know 
  • This report may be produced as often as desired with no consequence to the database. 
  • If the Funds/Amounts fields within the Loan Master file are edited after activity is posted, it is very important you follow the steps outlined in the help section titled “Editing Loan Funds”. If those steps are not followed, the information found within this report may not be accurate. 
  • 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 reports screen and then select “Analysis by Fund” 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.