This report provides a detailed overview of loans with outstanding balances as of a selected date, separating the outstanding amount into capital and fees.

Accessing the Report

To access the Loan Outstanding Balances Report, navigate to Reporting > Loan > Loan Outstanding Balances Report.

Note: Access to this report is controlled by the Security option, which can be configured under Role Setup > Reporting > Loan Outstanding Balances Report.

Report Generation and Output

Once you initiate the report, it will display a Processing Status. Click the provided link to view its progress in the Processing Status screen.

Output Formats

The report is available in the following formats:

• XLS: Loan_Outstanding_Balances_Report (Spreadsheet): Click this hyperlink to open the report in spreadsheet applications like Microsoft Excel or OpenOffice. This format allows you to easily sort and filter the data to meet your specific business needs.

• Email: The report can be emailed to a specific user. Ensure the necessary email address setups are complete for this functionality.

Report Details

Sorting/Display Order

The report is primarily sorted by Loan Number.

Columns/Detail

The following information is displayed on the report:

CLIENT:

• Client Number

• Client Initials

• Client Name

• Client Surname

LOAN:

• Agreement Number

• Capital Outstanding

• Interest Outstanding

• Initiation Fee Outstanding

• Service Fee Outstanding

• Additional Interest and Fees Outstanding

• Insurance (CPI) Outstanding

• VAT Outstanding

• Loan Outstanding Balance

Filters / Selections

You can refine the report data using the following selection options:

General

• Loan Branch: Generate the report for a specific loan branch.

• Region: Generate the report for loans created within a specific region.

• User: Generate the report for loans created by a specific user.

Client

• Client Number Start: Enter the starting client number to report on a specific client or range of clients.

• Client Number End: Enter the ending client number to report on a specific client or range of clients.

• Status: Select a client status from the list to filter loans by clients with that specific status.

Loan

• Loan Number Start: Enter the starting loan number to report on a specific loan or range of loan numbers.

• Loan Number End: Enter the ending loan number to report on a specific loan or range of loan numbers.

• Loan Status: Select one or more loan statuses to generate the report for loans with those specific statuses.

• Transaction Date End: Select the date up to which the outstanding balances should be calculated.

Available Buttons

• Cancel: Click to cancel the report request and return to the previous screen.

• Finish: Click to confirm your selections and generate the report.