Overview

The Detailed Loan Per Employer Report allows you to quickly view a list of outstanding installments for clients associated with a specific employer.

Watch a video demonstration: https://youtu.be/g7ycNE0Vgyg

Security and Access

To access this report, your user role must have the Loan Detailed per Employer Report option enabled under the Report section in Role Setup.

To access the report, navigate to: Reporting > Employer > Detailed Loan per Employer Report.

Filters/Selections

The report offers comprehensive filtering options to help you pinpoint specific data:

General

• Branch: Generate the report for installments on loans created at a specific branch.

• Region: Generate the report for installments on loans created in a specific region.

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

• File Format: (Required) Choose your preferred output format: XLS or XLSX.

Employer

• Employer Search: Use an asterisk * to list all employers. You can also type a full or partial employer name and click the Search button to display results in the employer dropdown list.

• Employer: Generate the report for installments of clients associated with a specific employer.

• Status: Filter the report by Employer Status (All, Pending, Pre-Approved, Approved, Suspended, or Closed).

• Classification: Generate the report for installments of clients whose employer has a specific classification.

• Economic Sector: Generate the report for installments of clients whose employer falls within a specific economic sector.

Client

• Client Number Start: Define the beginning of a client number range.

• Client Number End: Define the end of a client number range.

• Status: Generate the report for clients with a specific status.

• Payback Frequency: Generate the report for installments of clients with a specific payback frequency.

• Bank: (Optional) Generate the report for installments of clients associated with a specific bank.

Loan

• Loan Number Start: Define the beginning of a loan number range.

• Loan Number End: Define the end of a loan number range.

• Instalment Due Date Start: (Required) Enter the start date in dd/mm/yyyy format. The report will include installments where the due date falls within this range.

• Instalment Due Date End: (Required) Enter the end date in dd/mm/yyyy format. The report will include installments where the due date falls within this range.

• Instalment Status: Generate the report for a specific Status (Active, Paid, Written Off, or Cancelled), or select all statuses.

• Loan Product: Generate the report for installments of loans with a specific loan product.

• Payback Type: Generate the report for installments of loans with a specific payback type.

• Salesperson: Generate the report for installments of loans linked to a specific salesperson.

Available Buttons

• Finish: Select this button to generate the report.

• Cancel: Select this button to cancel your request.

Sorting/Display Order

The report is primarily sorted by Employer Name, then by Employer Paypoint, Instalment Due Date, Client Number, and finally Loan Number.

If a loan has multiple outstanding installments, you can sort the generated report by client number and then loan number to group all installments for a specific loan together.

Output Format

You can print, view, or email the Detailed Loan Per Employer Report.

• View Online: You can view the report directly within the system.

• Print: Print a physical copy of the report.

• Email: Email the report to a specified user. To use this feature, ensure the necessary email address is set up on the user's profile under Setup > Security > Users. Additionally, the Cash Box Setup must be configured under Setup > Branches > Cash Box (select the specific user by E-mail).

• Spreadsheet (XLS): Click the "XLS: Detailed Loan Per Employer Report" hyperlink to open the report in a spreadsheet application (e.g., Microsoft Excel or Open Office). Once the information is in this format, you can easily sort it to meet your specific business needs.

Columns/Detail

The report displays the following detailed information:

Employer Detail

• Employer

• Employer Number

• Paypoint

Client Detail

• Client Number

• Client ID Number

• Client Initials

• Client Name

• Client Surname

• Employment Type

Loan Detail

• Loan Agreement Date

• Loan Agreement Number

• Loan Status

• Number of Payments

• Number of Interest Periods

• Frequency

• Payback Type

• Loan Amount

• Total

• Instalment Number

• Instalment Status

• Due Date

• Instalment Amount

• Instalment Amount Arrears

• Receipts

• Outstanding

• Arrears

• Loan Purpose

• Custom Reference

Fees and Interest Summary

• Initiation Fee

• Service Fee

• Admin Fee

• Preparation of Business Plan Fee

• CPI Fee

• In Default Service Fee

• In Default Interest

• Interest/Profit

• Interest/Profit Rate %

• Last Paid Date

Record Details

• Record User

• Record Date

• Record Time

Employer Subtotals

• No of Clients

• No of Loan Instalments

Totals

• No of Clients

• No of Loan Instalments

Available Buttons

• Back to Filter Option: Select this button to cancel your request and return to the previous page to adjust your report filters.

• Email Report: Select this button to receive this report via email.