The Loan Receipt Detail Report provides a comprehensive list of all payments received against loans.

MaxMoney Setup

Resources

To enable access to this report, go to Setups > Security > Roles and enable the Receipt Detail Report resource for the relevant role.

How to Access the Report

In MaxMoney, go to Reporting > Loan > Receipt Detail Report.

Report Filters

You can refine your report results using the following filters:

• Report Type: Choose between Lite or Detail.

• Branch: Generate the report for receipts associated with a specific branch.

• Branch Table: Select whether the branch filter should apply to the client’s home branch or the branch logged against the receipt (which is determined by the loan home branch).

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

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

• Filter salesperson: Select whether the salesperson filter should apply to the salesperson on the client or the salesperson on the loan.

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

• File Format: The report can be generated in XLS or XLSX format.

• Print Report: Select this option to generate a printable report.

• Print Chart: Select this option to generate a graph visualization of the data.

Client

• Client Number Start and End: Generate the report for receipts from clients within a specified client number range.

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

• Client Frequency: Generate the report for receipts from clients with a specific payment frequency.

• Bank: Generate the report for receipts from clients associated with a specific bank.

Loan

• Loan Number Start and End: Generate the report for receipts of loans within a specific loan number range.

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

• Loan status: Generate the report for receipts of loans with a specific loan status.

• Forced Settlement Only: Select this option to generate the report for Forced Settlement receipts only.

Receipt

• Date Start and Date End: Generate the report for receipts within a specific date range.

• Filter by: Select if the date period should filter on the transaction date, effective date, or creation date of the receipt.

• Receipt Type: Generate the report for receipts of a specific event attribute/type.

• Receipt Event: Generate the report for receipts of a specific event.

• Display cancelled receipts: Select this option if you want to include receipt reversals in the report.

Employer

• Employer Search: You can generate the report for receipts from clients with a specific employer.

• Employer Classification: Generate the report for receipts from clients based on a specific employer classification.

• Employer Economic Sector: Generate the report for receipts from clients belonging to a specific employer economic sector.

Report Type

The columns for the Detail Report and the Lite Report differs.

Report Type	Documentation
Lite	Lite Receipt Report
Detail	See below

Report Columns for the Detail Report:

The report displays the following information:

Client

• Client No.

• Client Home Branch

• Original Client Number: This column will only have a value if the data was imported and the value was supplied.

• Client ID Number

• Client Initials

• Client Name

• Client Surname

• Client Status

• Client Payment Frequency

• Client Salesperson

• Client Employer

Receipt

• Transaction Date

• Effective Date

• Receipt Type: Event Attribute.

• Client Transaction Description: Determined by the setup of the event.

• Client Receipt Amount (Amount Received)

• Change (Amount NOT to Allocate Against Loan)

• Receipt Reversal Reason

• Batch Code

Loan

• Loan No

• Loan Receipt Amount

• Loan Receipt Capital: (Conservatively calculated: for example, Receipt amount * Capital / loan total).

• Loan Receipt Fees: (Conservatively calculated).

• Loan Receipt Interest: (Conservatively calculated).

• Receipt Initiation Fee: (Conservatively calculated).

• Receipt Initiation Fee VAT: (Conservatively calculated).

• Receipt Service Fee: (Conservatively calculated).

• Receipt Service Fee VAT: (Conservatively calculated).

• Receipt CPI: (Conservatively calculated).

• Receipt GLP: (Conservatively calculated).

• Loan Salesperson

• Loan Transaction Description

• Loan Product

Receipt Creation Info

• Record User

• Record Date

• Record Time