Performance by Sales Person Report Print

Performance by Sales Person Report Print

Report Columns

1. General Loan / Debtors Book Information

Sales Person: Group values per salesperson.
Number of Active Clients for reporting period: The number of clients with a transaction in the selected date range. See also the Active Client Report (same date range).
New Clients: Clients created within the selected date range. See also the Client Report (same date range).
- Note on variations in "New Clients" across performance reports:
  - Performance by Payback Type: May vary if the client has not selected a preferred Payback Type.
  - Performance by Bank: May vary if the client has not selected a Preferred Enabled Bank Account.
  - Performance by Product: If a new client (created within the reporting period) has multiple loans on different Loan Products, this client will be reflected in the "New Clients" column for each relevant Loan Product. This may result in the total of "New Clients" on this report not matching the "Total No Of Clients" on the Client Detail Report for the same period.
Scheduled Fees and Interest for the Next Month (*A): This represents the interest and fee portion of installments where the installment due date falls within the period of the "Next Month" (the period starting one day after the selected end date, continuing to the last day of the next month). See also the Instalment Detail Daily Analysis Report (Interest and all other Fees - Date Range Start Date 1st day of next month, End Date a day far in the future).
Interest Bearing Capital (*B): The capital amount as of (end date + 1) of the report, payable in the future. See also the Instalment Detail Daily Analysis Report (Capital Amount - Date Range Start Date 1st day of next month, End Date a day far in the future).
Effective Monthly TCOC Rate (%): Calculated as: (Scheduled fees & interest for the Next Month) / (Interest Bearing Capital ) x 100.
$Effective monthly TCOC Rate (%) = (A / B) \times 100$
Total Cost of Credit: Interest and fees for loans created in the selected date range. See also the Loans Between Dates Report (Interest and Fees for Loans created in the same period).
Credit Income Earned (as per Income Statement): Income earned from interest and fees for the selected date range. See also the Detailed Ledger Report (Income/Revenue Ledgers of the same period).
Actual Written Off in Period: Loans that were written off in the selected date range. See also the Detailed Ledger Report (Bad Debts, Debit Amount(s) for the same period).
Debtors book Value (Loans Only): The client control balance, which is the sum of transactions on loans up to the end date of the selected date range.
- For a specific salesperson, this is the sum of transactions on loans where the salesperson on the loan is this specific salesperson, up to the end date of the selected date range. See also the Statement of Financial Position (Balance Sheet) Report (Client Control Account minus (Change minus Non Loan Debt on Client Detail report), with Start Date = Beginning of time, End Date Report = End Date).

2. Loan Agreements Disbursed During This Period

Loans with an agreement date falling within the selected date range (Active Agreements Only). See also the Loan Detail report.

Loan Capital Amount: The loan capital amount of the loans disbursed during this period.
Total Rates, excluding VAT: The rates (other than capital, fees, and interest) of the loans disbursed during this period.
Total Fees, excluding VAT: The fee amount of the loans disbursed during this period. Example: (Initiation Fee + Service Fee + Administration Fee + Preparation of Business Plan Fee + CPI Fee) / 1.15.
Total Interest: The interest amount of the loans disbursed during this period.
VAT: The VAT amount of the loans disbursed during this period.
Total: The total amount of the loans disbursed during this period.

3. Performance of Payments Scheduled for this Period

This period refers to the selected date range. See also the Loan Instalment Detail Report.

Total Payable (*C): Calculated as: Received + (arrears + delinquency) + credits
Credits (*D): The discount during this period; the amount not received due to (Forced) settlement receipt during this period.
Received: Payments due for this period that were actually received (installments due and the amount due has been received).
Arrears: Payments receivable in this period that are still outstanding (installments due and the amount due has not yet been received).
Delinquency (Bad + Arrears) (*E): Payments receivable during this period that have been written off to bad debt or are in arrears (the installment is due, but the status is Bad or still Active, instead of Paid).
Delinquency (%): Calculated as: $Delinquency / (Total Payable - Credits) \times 100$ $Delinquency (%) = (E / (C - D)) \times 100$

4. Actual Receipt Details

This period refers to the selected date range. See also the Receipt Detail report and Detailed Ledger report for event attributes = receipt types.

Loan Receipt Total: The physical amount of cash allocated against the loan.

Loan Receipt Capital: The portion of the transaction on the loan allocated to capital.

Loan Receipt Fees: The portion of the transaction on the loan allocated to fees.

Loan Receipt Interest: The portion of the transaction on the loan allocated to interest.

Change: The amount of cash not allocated against a loan (Actual Received - Loan Receipt Total).

Actual Received: The physical amount of cash in hand/received.

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