Overview

The MaxCollect Declined Payback History Report provides a detailed record of all declined payback instructions. Designed specifically for microlenders, the tool tracks failed payment instructions and provides granular details regarding why specific transactions were rejected. The report serves as a comprehensive guide for managing and analysing unsuccessful collection attempts within a financial service environment.

Security and Access

To access this report, your user role must have the Declined Payback History Report option enabled under the Report section in Role Setup. Additionally, the MaxCollect module must be enabled for your legal entity, or this option will not be available.

To access the report, navigate to: Reporting > MaxCollect > Declined Payback History Report.

Report Filters

The report offers comprehensive filtering options, allowing you to narrow down the data to your specific needs:

General

• Branch: (Optional) Generate the report for declined paybacks created at a specific branch.

• Region: (Optional) Generate the report for declined paybacks created in a particular region.

• User: (Optional) Generate the report for declined paybacks created by a specific user.

Client

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

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

• Status: (Optional) Filter the report for clients with a specific status.

• Payment Frequency: (Optional) Filter the report for clients with a specific payment frequency.

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

Loan

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

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

• Instalment Date Start: (Required) Enter the start date in dd/mm/yyyy format to include instalments within this date range.

• Instalment Date End: (Required) Enter the end date in dd/mm/yyyy format to complete the instalment date range.

• Status: (Optional) Filter the report by a specific loan status.

• Payback Type: (Optional) Filter the report by a specific payback type.

• Salesperson: (Optional) Generate the report for paybacks linked to a specific salesperson.

Employer

• Employer Search: Use an asterisk * to list all available employers.

• Employer: (Optional) Select a specific employer to filter the report.

• Classification: (Optional) Filter the report by employers with a specific classification.

• Economic Sector: (Optional) Filter the report by employers within a specific economic sector.

Available Buttons

• Cancel: Select this button to cancel your request and return to the previous page.

• Finish: Select this button to generate the report based on your chosen filters.

Sorting and Display Order

The report is primarily sorted by Client number, then by Loan number, and finally by Declined date.

Output Format

You have several options for viewing and exporting the 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. Ensure the necessary email address setups are complete for this functionality.

• Spreadsheet (XLS): Click the "XLS: Declined Payback History Report" hyperlink to open the report in a spreadsheet format (e.g., Microsoft Excel or OpenOffice Calc). This format allows for easy sorting and manipulation of the data to suit your specific business needs.

Columns/Details

The report displays the following detailed information:

• Client:

  • Sales Person: The salesperson associated with this customer.

  • Client number: The customer's unique number in the system.

  • Surname: The customer's surname.

  • Initials: The customer's initial(s).

  • Bank Account Number: The customer's bank account number.

  • CSP: The name of the CSP (Client Service Provider).

  • EDO Contract Reference: The EDO (Electronic Debit Order) Contract Reference number.

  • Declined Amount: The amount that was declined for the payback.

  • Declined Date: The date when the payback instruction was declined.

  • Description: A description of the payback instruction.

  • Response: The reason provided for why the payback instruction was declined.

  • Transaction Status: The status of this specific transaction.

  • Instalment Status: The status of this specific instalment.

  • Merchant Statement Reference: The reference number on the merchant statement.

  • Tracking Date: The date of the first tracking attempt.

  • No. of Declined Paybacks: The total number of declined paybacks for the specific date range.