# Standard SMR

The report provides detailed fee information across various categories to support in-depth profitability analysis. It delivers a streamlined view of the most critical data points, including new loan counts, receipt analysis, client segmentation, and age analysis.

## Getting Started&#x20;

Input the following report parametrs and Mobiloan will generate the new SMR Query results

1. **Company** : Look for a **Company** or **Entity** selection drop-down menu and choose depending on your reporting needs.
2. **Date Preselect :** In terms of New Loan Creations, Receipt analysis and Client analysis, from what date would you like to analyse from

<figure><img src="https://1899951008-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuSE8MLBiTTv5wYGJpkP%2Fuploads%2FbPiBGumoEtbYa4jLLObP%2Fimage.png?alt=media&#x26;token=db39813f-022e-4c4b-9bd4-97bed0c5d070" alt=""><figcaption><p>Before selecting Submit, select the company and date preselect attributes.</p></figcaption></figure>

***

## Overview of the data in the Summary Management Report

<figure><img src="https://1899951008-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuSE8MLBiTTv5wYGJpkP%2Fuploads%2FNHdOEDCuggaoJtXywEZu%2Fsmr.png?alt=media&#x26;token=3a328bc1-7562-4d73-8fb4-02f4a29b4620" alt=""><figcaption><p>Summary Management Report Data</p></figcaption></figure>

## New loan analysis

Shows the count of new loans made, sub-categorized into **loan term**, **loan category**, and the **branch that originated the loan**.

&#x20;It also includes some summary statistics, such as the average loan amount and the total amount of money loaned, as shown below

<figure><img src="https://1899951008-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuSE8MLBiTTv5wYGJpkP%2Fuploads%2FO7PLVvJhY5HN8yPeDInZ%2Fimage.png?alt=media&#x26;token=f23056ce-9eac-49d8-add4-b9bf0685a25c" alt=""><figcaption><p>New Loan Analysis sub-category</p></figcaption></figure>

### Interpretation of New Loan Analysis reports

* **Which loan terms are the most popular?** You can see this by looking at the "Count" column for each term.&#x20;
* **What are the average loan amounts for each category?** You can see this by looking at the "Average Capital" column for each category.
* **Which branches are originating the most loans?** You can see this by looking at the "Count" column for each branch.

## Receipt Analysis

Shows the **received income** based on **loan terms**, **categories**, **branches**, and **receipt types**.

All reports share  "Grand Total" rows, summarizing the overall number of receipts, average capital, and total capital for all branches and types, as seen below:&#x20;

<figure><img src="https://1899951008-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuSE8MLBiTTv5wYGJpkP%2Fuploads%2FZUoe8qw6ZEYWVvBcWSin%2Fimage.png?alt=media&#x26;token=d5336622-1bcf-47bd-b6d4-706cae3cf70c" alt=""><figcaption><p>Receipt analysis Report </p></figcaption></figure>

### Interpretation of Receipt Analysis Reports

* Evaluate the overall income generated by analyzing the total capital amount. Significant capital generation reflects financial stability and potential for investment.
* **Income Source:** Identify which loan terms contribute the most to income. Shorter terms typically generate higher volume, while longer terms may offer higher individual profits despite lower frequency.
* **Main Income Source:** Determine the category driving the most income.&#x20;
* Compare average capital across categories to understand potential differences in individual loan amounts. Higher average capital in a category suggests larger loans on average.
* Identify the branch generating the most receipts and capital. High volume and capital indicate a productive branch efficiently processing transactions.



## Client Analysis

Presents a summary analysis of loan frequency applications grouped by the client count per category and per branch as seen in the screenshot below:&#x20;

<figure><img src="https://1899951008-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuSE8MLBiTTv5wYGJpkP%2Fuploads%2FWrKQnqdm8N2Klmn2H8SD%2Fimage.png?alt=media&#x26;token=63f49b4d-0a80-4915-b467-384dd98f4825" alt=""><figcaption><p>Client Analysis Reports</p></figcaption></figure>

### Interpretation

* Make assessments per category or per branch based on the count and percentages of loan applications successfully originated per **loan frequency**
* Monitor Client Category or Branch Performance analysis using the Grand Total column

## Age analysis

This report presents the current outstanding balances for debts originally scheduled for collection in a specific month, categorized by their age (number of days past due).

This table shows the number of receipts, average amount, total amount, and breakdown of different fees and charges for each age group per **branch or category**

<figure><img src="https://1899951008-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuSE8MLBiTTv5wYGJpkP%2Fuploads%2FjA9vKIa8g8i46I81kjgs%2Fimage.png?alt=media&#x26;token=b210da68-39f8-47b1-8dae-8e30609e2f2f" alt=""><figcaption><p>Age analysis reports</p></figcaption></figure>

It allows for analysis of collection performance and identification of delinquent accounts for timely intervention.

{% hint style="info" %}
**Mobiloan Pages:** sql\_selection
{% endhint %}
