Daily Cash Up Management Report

Overview

The customer needs totals for the following:

  • Detailed Loan Report (Loans)

  • Receipt Detail Report (Payments)

  • Detailed Ledger filtered on Event Attribute: Change to Client (Refunds)

  • Change allocated on Clients (Overpayments)

  • Follow Up Report (Credits Due).

MaxMoney Setup

3.1.Resources

The users will need the following:

  • Daily Cashup Management Report 

 

4.How to Access the Report

There are 2 ways to generate the report:

  1. MaxMoney - Setups - Reporting - Scheduled Reports Setup

  2. MaxMoney->Reporting->Accounting->Daily Cash Up Management Report

 

4.1 Ask Window

  • Add a filter option to exclude cancelled receipts.

    • Note: when cancelled receipts are excluded the total receipt amount will be more.

4.2 Report Format

  • Csv

  • Xlsx

  • Html

  • pdf

4.3 Report Columns

4.3.1.LOANS

Reporting - Loan - Detailed Loan Report (Active, Paid, Written Off, Cancelled, Non-Performing)

  • Capital -> Loan amount
  • Interest on Capital -> Interest/Profit (plus In Default Interest)
  • Legacy Costs = Insurance:  CPI excluding VAT.  Noem dit CPI< /FONT >
  • Service Fee -> Service Fee (plus die In Default Service Fees in)
  • Initiation Fee -> Initiation Fee
  • VAT -> Initiation Fee VAT + Service Fee VAT + Default Service Fee VAT + CPI VAT
  • CPI VAT = CPI total Premium – CPI Premium< /FONT >
  • Service Fee VAT = Total Monthly Service Fees – Monthly Service Fees< /FONT >
  • Default Service Fee = Total In Default Monthly service Fees – In Default Monthly Service Fees< /FONT >
  • Initiation Fee VAT = Total Initiation Fee – Initiation Fee< /FONT >

4.3.2.PAYMENTS

Reporting - Loan - Receipt Detail Report (Active, Paid, Written Off, Cancelled, Non-Performing)

  • Capital -> Loan Receipt Capital
  • Interest on Capital -> Loan Receipt Interest
  • Legacy Costs = CPI: Loan Receipt Amount * ((Loan se CPI Premium excluding VAT) / (Loan Total + default charges)).< /FONT >
  • Service Fee -> Loan Receipt Amount * ((Loan se Service Fee and default service fee excluding VAT) / (Loan Total + default charges))
  • Initiation Fee -> Loan Receipt Amount * ((Loan se Initiation Fee excluding VAT) / (Loan Total + default charges))
  • VAT -> Loan Receipt Amount * ((Initiation Fee VAT + Service Fee VAT + Default Service Fee VAT + CPI VAT) / (Loan Total + default charges))
    • Total of Loan = Loan Total + Default charges< /FONT >
    • Default charges = Default fees and Interest< /FONT >

4.3.3.OVERPAYMENTS

Reporting - Loan - Receipt Detail Report (Active, Paid, Written Off, Cancelled, Non-Performing). Don’t count duplicates.

  • Column: Change (Amount NOT to Allocate Against Loan)

4.3.4.REFUNDS

Detailed Ledger filtered on Event Attribute: Change to Client

  • When the Overpayment is paid back to the borrower (Post Client Change).
  • An Overpayment causes a credit on the borrower’s account. The Post Client Change causes a debit on the borrower which cancels the overpayment.

4.3.5.CREDITS DUE

Same as REFUNDS

4.3.6.DEBTOR C

Debtor C is the “Delinquency” as in the below .

4.3.7. % BAD DEBT

"Bad Debt is worked out as whatever is outstanding on a pay date, divided by the turnover for the pay date, and the system generates the percentage on the branch performance report it’s called delinquency percentage"

  • Calculation as on the performance report:
    • Total Payable = instalment due amount vir die periode (statuses: Active, Paid, Written Off, Non-Performing)< /FONT >
    • Credits = paid instalment due amount minus instalment amount received
    • Arrears = Active and Non-Performing instalment due amount minus instalment amount received
    • Bad = Written Off instalment due amount minus instalment amount received
    • Delinquency = Arrears + Bad
    • Delinquency % = (Delinquency) / (Total Payable – Credits) x 100< /FONT >


 

MAXMONEY Developed by MYCOMAX MICROFINANCE SOLUTIONS. Novamesh 18/06/2026