Designed to streamline multi-branch operations, the Periodic Financial Summary Report: Cancelled Receipts provides a comprehensive summary of Loan Receipts Cancelled within a selected date range.

Use in MaxMoney

Configuration & Generation Steps

• Navigation: Go to Reporting > Management.
• Report Selection: Select Periodic Financial Summary Report: Cancelled Receipts.
• Resource Allocation: Ensure the resource Periodic Financial Summary Report: Cancelled Receipts is allocated.

Filters/Parameters (AskWindow):

• Branch Selection: Select target branch(es).
• Receipt Cancelled Start Date: Enter start date. Filter on Receipt reversal Date.
• Receipt Cancelled End Date: Enter end date.

Loan Status: Set to All loan statuses.

Grouping & Sorting: Group by the Description column (Receipt Events).

Report Sheet: Cancelled Receipts

Column Heading	Formula / Population Rule	Notes
Description	List of all Receipt Events where cancellations occurred	Sorted alphabetically; grouped and summed by event
Count	Total number of receipt reversals per event	—
Avg Capital	Sum(Total Capital of Receipts) / Receipt Count	Calculated per event
Total	Sum(Receipt Totals)	Calculated per event
Capital	Sum(Total Capital per Receipt)	Conservative Calculation
Interest	Sum(Total Interest Amount per Receipt)	Conservative Calculation
VAS	Hardcoded to 0.00	—
Insurance	Sum(GLP Amount per Receipt)	Conservative Calculation
In Default Interest	Sum(Total InDefaultInterestAmount per Receipt)	Conservative Calculation
In Default Service Fee	Sum(Total InDefaultPeriodServiceFees per Receipt)	Conservative Calculation
Initiation Fee	Sum(Total Initiation Fee per Receipt)	Conservative Calculation
Service Fee	Sum(Total Service Fee per Receipt)	Conservative Calculation
VAT	Sum(VAT from Initiation Fee + Service Fee + In Default Service Fee)	Combined tax total
Change	Hardcoded to 0.00	—

Grand Totals: Include a summary total row at the bottom for each column.