Reporting
Last updated
Was this helpful?
Last updated
Was this helpful?
Reports are grouped into three main categories—Standard, Purchased, and Custom—collectively called the Report Suite. There is also a separate category for Advanced Reports with specialized filters.
Most reports support CSV or Excel export, which is helpful for viewing results over 1,000 rows. To begin, simply select the relevant reporting suite.
The Home Page displays a table of reports that you can search to find the one that best fits your needs. Each report has a unique ID for easy reference.
The reporting table includes key columns that are helpful to understand, making it easier to navigate and get familiar with Mobiloan's standard report suite.
ID
Unique identifier for each standard report.
Name
Title or description of the report, often including purpose and grouping logic.
Category
Classification of the report based on its function (e.g., Age Analysis, Client).
Filter
Applied data filter criteria (e.g., time period, client status, loan status).
Grouping
The data dimensions used for grouping the report (e.g., Branch, Date, Loan).
Role Access
Specifies which user roles or entities (e.g., Branch, Company) can view report.
Last Updated
The last date the report definition or configuration was updated.
g
Icon to represent the sync status
of the corresponding report to "Google Sheets"
Each report is unique in the type of data it represents. Mobiloan provides users with a reporting filter dialog to tailor the report results based on specific criteria
As seen in the screenshot below, the Submit Report Dialog displays all the filters that are associated with most reports:
Filter Name
Description
Select Branches
Select Categories
Select Client Statuses
Select Loan Statuses
Select Loan Date Filter
Date Preselect
Quickly apply a predefined date range like "This Month" or "Last Month."
Start Date
Manually set the report's starting date if no preselect is used.
End Date
Manually set the report's ending date if no preselect is used.
A simple filter for bad debt loan status based on the loan account closure date (Written Off / Handed Over), where the installment receipts amounts are unrecognizable income.
All standard loan-based reports relying on the LOAN table can be filtered by Bad Debt Status, including "Written Off," "Handed Over," or "Account Closed."
You have the option to filter the displayed results based on your preference. The available choices include:
All Loans (Unfiltered): This option allows you to view all loan records in the database without any filters applied. It provides a comprehensive overview of both good and bad loans.
All Loans Excluding Bad Debt: By selecting this filter, you can view a list of loans that excludes those categorized as bad debt.
Bad Debt Loans Only: This filter option narrows down the results to exclusively display loans that are classified as bad debt.
If you want to filter your reports based on the bad debt status of a loan, follow these steps to enable the new reporting module:
Go to Setup: Log in to your account and navigate to the Setup section.
Access Configuration: From the Setup menu, select Configuration.
Select Reporting: Click on Reporting to access the reporting options.
Enable Bad Debt Module: Look for the option to enable the new reporting bad debt module and turn it on.
Once enabled, you can customize your reports to include or exclude loans based on their bad debt status, allowing for more targeted insights and better decision-making.
Additional tools which may be useful are found within the same "Submit Report" dialog .
Access a chronological list of all past report generations:
View, re-run, or export previous results.
Useful for auditing or trend analysis.
Report Queue
For large datasets:
Click the Queue Report (☁️) icon.
Continue working while the report is processed in the background.
A notification will alert you once the report is ready.
Completed reports appear in Report History.
Custom Edit (SQL Mode)
Advanced users can manually edit the SQL logic behind report filters:
Access this option through the filter modal.
Only proceed if you are confident working with SQL syntax.
Incorrect use may cause the report to fail.
After you submit your report, Mobiloan will execute them against its dedicated MySQL database. This database is updated hourly, but can also be manually synchronized if needed.
If the query returns results, we will automatically format and display them. The first 1,000 rows will be shown directly. If the result set exceeds 1,000 rows, you will be prompted with the option to download the full results in Excel or CSV format.
Working with the Results Table The results table is interactive and customizable, offering the following features:
Global Search: Quickly filter the table using keyword-based searches.
Column Filters: Apply individual filters on columns for a more refined view.
Clickable Cells: Some cells are interactive, linking to more detailed information or available actions.
Customizable Layout: Adjust the table’s display settings to match your preferences.
The Utility Bar enhances your reporting experience with several powerful tools:
Click the Settings icon (⚙️) to open the configuration popup. This allows users to:
Toggle column visibility
Reorder columns
Set default sorting
Save custom table views
These setting are directed towards configuring the results table. The screenshot below depicts the Settings Popup screen:
View Columns*
Here, you may modify which columns you wish to view in the results table
Freeze columns left up to*
Here, you can select which columns in the results table you wish to freeze; this simply means to keep the chosen columns visible while you're scrolling to other columns in the table.
On-cell click
Here, you may configure what happens when you click on a cell. Each result may have different options for different reports. This setting should be explored.
Print Orientation
Select between Portrait or Landscape printing orientation.
Print Scale
Set the print scale to adjust to your preference.
Clear viewed rows
All rows that have been viewed become highlighted in blue text. To rollback this action select this option.
Choose one or more branches to filter the report by.
Filter the report based on predefined client categories
Refine results by selecting one or multiple client statuses.
Filter results by the current loan account status
Choose the date field to base your report on - this filter will only be available for certain reports
electing the option will present the list of reports if the user wishes to view a different report.
Selecting the option will present the report filters modal discussed in the previous page screen if the user wishes to edit the filters.
Selecting the option will update the results of your report in real time.
The option presents the user with a summary of data defined by the total number of unique data per column, the average value per column and the sum of all values per column.
Selecting the option will convert the results table into a downloadable and printable pdf format .
Selecting the option will allow the user to export the table data in either CSV or EXCEL format.
The option will be apparent when the results oertain to individual clients and allows the user to send an based on the results.