Mifos User Documentation Portal
  • Overview and Background
    • History and Background
    • Mifos Vision, Mission & Values
    • Who Mifos is For
    • How Mifos is Used
    • The Mifos Stack
      • Overview
    • Mifos v/s Fineract
    • Community app v/s Webapps
  • General Contributing Guidelines
    • Upstream Development Approach
      • Contribution Process
      • The Apache Way
    • Contributors Guide
    • Contribution Guidelines: Android Project
    • Contribution Guidelines: Web Project
  • Getting Started
    • Getting started with Git & Github
    • Postman integration with Gitbook for testing
    • Testing framework-Web
    • Testing framework-Android
    • Mifos CI/CD tools and instructions
  • External 3rd Apps
    • Pentaho Reporting Plugin
    • Payment Hub
  • MifosX
    • Overview
    • User Manual
      • How to Use This Manual
      • For All Users
        • General Navigation
          • Sign In Page
          • Welcome Page
          • Dashboard Page
          • List Page
          • Menu Page
          • Form Page
          • Clients-Groups-Centers Navigation
          • Navigation Tool
          • Global Search
          • Loan Product and Accounting with Mifos
        • Reports
          • Standard Reports Shipped in Mifos X
          • Standard Reports Field Descriptions
          • Custom Reports
            • Creating Simple Pentaho Report and Embedding it to Mifos X
          • XBRL Reporting
      • For Administrators (Mifos X Platform)
        • Initial System Set Up
        • Administration
          • Users
          • Organization
            • Manage Offices
            • Currency Configuration
            • Manage Holidays
            • Manage Funds
            • Manage Employees
            • Bulk Loan Reassignment
            • Standing Instructions History
            • Teller / Cashier Management
            • Fund Mapping
            • Working Days
            • Password preferences
            • Payment type
            • Loan Provisioning Criteria
            • SMS Campaigns
            • Message Gateway Configuration
            • Daily Teller Cash Management
            • Entity Data Table Checks
          • System
            • Manage Data Tables
            • Audit Trails
            • Manage Codes
            • Manage Reports
            • Manage Roles and Permissions
            • Manage Scheduler Jobs
            • Configure Maker-Checker Tasks
            • Global Configuration
            • Manage Hooks
              • Steps for creating sms bridge
            • Account Number Preferences
            • Entity To Entity Mapping
              • External Services
          • Products
            • Loan Products
              • Loan Product Fields
                • Accounting Loan Product Fields
                • Configuring and Disbursing of Top-Up Loan
                • Declining Balance Interest Calculation
                • Enabling Floating Rate
                • Enabling Variable Installments
                • Flat interest calculation
                • Loan Product Fields—Additional Fields for Loans with Variable Terms based on Loan Cycle
                • Recalculate Interest
                • Tranche Loan Fields
              • Setting up Minimum Days between Disbursal and First Repayment
              • Product Mix
            • Charges
            • Floating Rate
            • Savings Products
              • Saving Product Fields
                • Accounting Saving Product Fields
            • Fixed Deposit Products
              • Fixed Deposit Product Fields
                • Accounting Fixed and Recurring Deposit Product Fields
              • Interest rate chart with amount range
            • Recurring Deposit
              • Recurring Deposit Product Fields
            • Interest Calculations for Deposit Products
            • Overdraft Product
            • Share products
              • Dividends
            • Manage Tax configuration
          • Templates
          • mifos dropdown
        • Clients, Groups and Centers
          • Manage Clients
            • Client Life Cycle Statuses
            • Client Relationship Management
          • Manage Groups
          • Manage Centers
        • Accounting
          • Chart of Accounts - General Ledger Setup
            • Default COA sql script
          • Accounts linked to Financial Activities
          • Migrate opening balances (Office-wise)
          • Accounting Rules
          • Provisioning Entries
          • Print General Ledger Listing
          • How To Enter GL Opening Balance
        • Configure Notifications
      • For Operational Users (Mifos X Web App)
        • Accounting operations
          • Add Journal Entries
          • Searching Accounting Transactions
          • Frequent Postings
          • Advanced Accounting Rules
          • Closing Entries
          • Accruals
        • Accounts and Transactions
          • Cash Transaction Processing
          • Deposit Accounts
            • Mifos X Saving Accounts
              • How to Activate a Saving Account
              • How to Add a Charge to a Saving Account
              • How to Approve a Saving Account Application
              • How to Calculate Interest for a Saving Account
              • How to Close a Saving Account
              • How to Create a Saving Account Application
                • Saving Account Fields
              • How to create overdraft account (Draft)
              • How to Delete a Saving Account Application
              • How to Make a Deposit to a Saving Account
              • How to Make a Withdrawal from a Saving Account
              • How to Modify a Saving Account Application
              • How to Post Interest to a Saving Account
              • How to Reject a Saving Account Application
              • How to Transfer funds from a Saving Account
              • How to Withdraw a Saving Account Application
            • Standing Instructions
              • How to Set up a Standing Instruction
                • Standing Instruction Form Fields
            • Term Deposit Accounts (Fixed Deposit / Recurring Deposit)
              • How to Activate a Term Deposit Account
              • How to Add a Charge to a Term Deposit Account
              • How to Approve a Term Deposit Account Application
              • How to Calculate Interest for a Term Deposit Account
              • How to Create a Term Deposit Account Application
                • Term Deposit Account Fields
              • How to Delete a Term Deposit Account Application
              • How to Make a Deposit to a Recurring Term Deposit Account
              • How to Modify a Term Deposit Account Application
              • How to Post Interest to a Term Deposit Account
              • How to Reject a Term Deposit Account Application
              • How to Withdraw a Term Deposit Account Application
            • Creating Recurring Deposit Account:
          • Loan Accounts
            • How to Create a Loan Account Application
              • Loan Account Fields
            • How to Make Repayments on a Client Loan Account
            • Track Loan Performance History
            • How to Approve a Loan Account Application
            • How to Add a Charge to a Loan Account
            • How to Modify a Loan Account Application
            • How to Assign a Loan Officer
            • How to Reject a Loan Account Application
            • How to Withdraw a Loan Account Application
            • How to Delete a Loan Account Application
            • How to Add Collateral to a Loan Account
            • How to Add/Remove/Modify a Guarantor to a Loan Account
            • How to Manage Loan Account Disbursement
            • How to Make Repayments on a Group Loan Account
            • Using collection sheet or other payment types for making payments
            • How to Waive Interest for a Loan Account
            • How to Write-off a Loan Account
            • How to Close a Loan Account as Rescheduled
            • How to Close a Loan Account
            • Making Prepay of the loan
            • How to Prepay a Loan Account
            • How To Create Group Loan Account
            • How to Process Bulk JLG Loan Application
            • How to generate - Loan transactions report
            • How to reschedule loan
            • How to provide floating rates
            • How to provide variable installments
            • How to create new loan - Interest Recalculation
            • Tranche loan process
            • Loan with term vary based on loan cycle
            • How to Place Guarantee Funds On-Hold?
          • Overdraft account
          • Saving Accounts
            • How To Create Group Saving Account
          • Share Accounts
        • Checker Inbox & Tasks
      • Side Bar - Features
        • Checker inbox and tasks
        • Collection sheet
        • Help.
        • Individual collection sheet
        • Keyboard short-cuts
        • Navigation
      • Others - mifos dropdown
        • Help
        • Profile
        • Settings
          • Date format
          • Language
        • Signout
      • Data Import Tool
        • Getting started with - Data Import Tool
        • Installing Data Import Tool
      • Glossary of Terms
      • Index
      • Reporting Documentation
      • Mobile Money Tool
    • User Space
      • New Feature Request Content
      • Recommended System Requirement
      • MifosX Overview
      • Installation guide
        • Upgrading Mifosx
        • Install MifosX on Windows
        • Install MifosX on Linux
        • Install MifosX on AWS
      • Release Notes
        • Release 1 and Features List
        • Release 2 and Features List
      • User Manual
        • How to Use This Manual
        • For All Users
          • General Navigation
            • Sign In Page
        • For Administrators
          • Initial System Set Up
        • For Operationals
      • Roadmap
      • Frequently Asked Questions (FAQs)
      • Demo Server Details
    • Developer Space
      • Setting Up Dev Environment
        • Setting up Frontend - community-app
      • Setting up MifosX from latest builds
      • Contributors Guide
      • Customising MifosX
      • Additional features
        • Data import tool
        • SMS campaigns
        • Pentaho reports
      • How Mifosx works
      • Adding a new tenant to MifosX instance
      • Using REST client for testing
      • API documentation
      • Scaling MifosX
      • Upgrading MifosX
      • Troubleshooting guide
  • Core Banking & Embedded Finance
    • Core Banking
      • Overview
    • Embedded Finance
      • Overview
  • Application Framework
    • Payment Hub EE
  • Main Platforms
    • Fineract 1.x
      • Apache Fineract
      • Apache Fineract Client
    • Fineract CN
      • Overview
      • User Manual
  • Staff UI Platforms
    • Fineract 1.x
      • Community-App
      • Web-App
      • Web Self-Service App
        • Online Banking App 2.0 User Manual
          • Developer Environment Setup for Online Banking App 2.0
      • Mobile Field Officer Applications
        • Android Client
          • User Manual
    • Fineract CN
      • Digital Bank User Interface
      • Mobile Field Officer Applications
        • Fineract CN Mobile
  • Customer UI Platforms
    • Fineract 1.x
      • Mobile Banking
        • Mifos Mobile
      • Mobile Wallets
      • Online Banking
    • Fineract CN
      • Mobile Banking
        • Fineract CN Mobile
        • Mifos Mobile CN
      • Mobile Wallets
      • Online Banking
  • Ancillary Tools
    • Fineract 1.x
      • Message Gateway
      • Mifos Passcode
      • PPI Vision
      • DevOps Tooling
      • Fineract Android SDK
      • MifosX Admin
      • Mifos ChatBot
      • Data Import Tool
    • Fineract CN
      • Fineract CN Containers
      • Fineract CN Terraform
  • Payment and Process Orchestration
    • Fineract 1.x
      • Payment Hub
      • Fineract Pentaho
    • Fineract CN
      • Staff Interfaces
        • Digital Bank UI
      • Customer Interfaces
        • Fineract CN Mobile
        • Mifos Mobile CN
        • Fineract CN Mobile
      • Ancillary Tools
        • Fineract CN Terraform
        • Fineract CN Containers
    • Payment Hub EE
Powered by GitBook
On this page

Was this helpful?

  1. MifosX
  2. User Manual
  3. For All Users
  4. Reports

Standard Reports Field Descriptions

Report name

Category

Description

Format

Parameters

Loan

Listing of all active loans and details including principal, interest, and fees outstanding for each loan.

Pentaho (PDF, Excel, CSV)

HTML

Currency, Loan Purpose, Fund, Office, Product, Loan Officer

Loan

(based on each branch) A summary of the total clients, number of active loans, number of arrears, PAR calculation, as well as the total disbursed, principal, interest, fees, and penalties for each branch.

Pentaho (PDF, Excel, CSV)

HTML

Office, Currency, Fund, PAR Calculation, Loan Purpose, Loan Officer, Product

Loan

List of Loans by date of disbursal including loan principal, interest rate, date disbursed, total loan amount, and total repaid.

Pentaho (PDF, Excel, CSV)

HTML

Office, Currency, Fund, Loan Purpose, Loan Officer, Product, Start Date, End Date

Loan

List of active loans on their last installment (as of the day the report is been generated) listing original loan details, expected maturity date as well as principal, interest, fees, and outstanding penalties.

Pentaho (PDF, Excel, CSV)

HTML

Office, Currency, Fund, Loan Purpose, Loan Officer, Product

Loan

List of active loans on their installment (as of day of report being summarized) by branch including number of clients, number of active loans and in arrears, total principal, interest, fees, and penalties, and PAR calculation, or loans on their last installment.

Pentaho (PDF, Excel, CSV)

HTML (table)

Office, Currency, Fund, Loan Purpose, Loan Officer, Product, PAR Calculation

Loan

It shows a list of clients with their loan details, like Disbursed Date, Expected Maturity Date, for whom the loan has already passed the maturity date.

Pentaho (PDF, Excel, CSV)

HTML

Office, Currency, Fund, Loan Purpose, Loan Officer, Product

Loan

It shows the number of loans with arrears (if any) which have already passed maturity date with their details.

Pentaho (PDF, Excel, CSV)

HTML

Office, Currency, Fund, Loan Purpose, PAR calculation

Loan

Under a specific office, Aging Detail provides a list of clients having arrears in terms of number of 'Days', 'Weeks' and 'Days in Arrears Band'. Along with this, it provides Client's Original Principal, Original Interest, Principal Paid, Interest Paid, Principal Overdue and Interest Overdue.

Pentaho (PDF, Excel, CSV)

HTML

office

Loan

Under a specific office, Aging Summary provides number of loans which are arrears in days (or on Schedule) with the mentioned currency type.

Pentaho (PDF, Excel, CSV)

HTML (table)

Office, Currency

Loan

Under a specific office, Aging Summary provides number of loans which are arrears in weeks (or on Schedule) with the mentioned currency type.

Pentaho (PDF, Excel, CSV)

HTML

office,currency

Loan

At each date for the specific duration, this report provides 'Expected Cash In'(in terms of Principle, Interest, Fees Penalty) and 'Expected Cash Out' (Loan Disbursal) and 'Net Expected Cash Out'. (Expected Cash Out ~ Expected Cash In).

Pentaho (PDF, Excel, CSV)

HTML

Office, Start Date, End Date

Loan

For all clients under a specific office, it shows Principal/Interest/Fees/Penalties Due and Total Due for the given due date of the client.

Pentaho

(PDF, Excel, CSV)

HTML (table)

Office, Start Date, End Date

Loan

It shows a list of all the clients and summary of their loans which are approved but not yet disbursed.

PentahoPDF, Excel, CSV)

HTML

Office, Loan Purpose, Fund, Currency

Loan

It shows list of loan products which are awaiting for disbursal at each month. It also shows the Principal Amount yet to be disbursed.

Pentaho (PDF, Excel, CSV)

HTML (table)

Office, Loan Purpose, Fund, Currency

Loan

It shows a list of clients and details of their loan accounts which are not yet approved.

Pentaho (PDF, Excel, CSV)

HTML

Office, Loan Purpose, Fund, Currency

Loan

For the given duration, this report shows the list of loans (with details) that are paid by the customers without any dues before the maturity date.

Pentaho (PDF, Excel, CSV)

HTML

Office, Loan Purpose, Fund, Currency , Start Date , End Date

Loan

This report shows the number of loans along with their details (ex: total principal/interest/fees/penalties repaid) which are paid by the customers without any dues before the maturity date.

Pentaho (PDF, Excel, CSV)

HTML

Office, Loan Purpose, Fund, Currency , Start Date , End Date

Loan

This report shows portfolio at risk (in %) using the formula:

Portfolio at Risk = Unpaid Principal balance of all loans with payment past due (by age: 1, 30, 60, 90 days, etc.) / Outstanding Portfolio

It also shows Interest Due, Fees Due, Penalties, Fees Outstanding, etc.

Pentaho

(PDF, Excel, CSV)

HTML

Office, Loan Purpose, Fund, Currency, PAR calculation

Loan

This is similar to the previous one but lists portfolio at risk grouped by branch offices.

Pentaho

(PDF, Excel, CSV)

HTML

Office, Loan Purpose, Fund, Currency, PAR calculation

Loan

This report shows a branch-wise list of all rescheduled loans with their details (like Written-off Date, Disbursed Date, Rescheduled Principal/Interest/Fees).

Pentaho

(PDF, Excel, CSV)

HTML

Office, Currency, Start Date and End Date

Loan

This report shows a list of loan accounts and their transaction type (whether it's in disbursement state or repayment state). Along with this, it shows Principal, Interest, Outstanding Principal and Interest Income with specified currency and loan product.

Pentaho

(PDF, Excel, CSV)

HTML

Loan

It shows a list of all the loans which are written-off in a given duration.

Pentaho

(PDF, Excel, CSV)

HTML

Currency, Office, Start Date, End Date

Clients

It shows a list of clients and their respective loan accounts with their details like Client Status, Loan Status (Approved, Disbursed, Closed, Rejected, Written-off), Amortization, Loan Frequency, etc.

Pentaho

(PDF, Excel, CSV)

HTML

Office, Currency, Loan Purpose , Fund

Clients

It lists all the clients for a particular branch and the respective Account Number, Client Status, Activation Date and External Id associated with them.

Pentaho

(PDF, Excel, CSV)

HTML

office

Funds

It lists all the funds which are disbursed (with their currency type) during a given duration.

Pentaho

(PDF, Excel, CSV)

HTML

Currency, Fund, Start Date, End Date

Funds

It lists all the funds which are disbursed with their currency type during a given duration and by a specific branch office.

Pentaho

(PDF, Excel, CSV)

HTML

Currency, Fund,Office, Start Date, End Date

Accounting

For a given office and duration, this report shows 'Balance' in each income account (ex: Fees Account, Charges Account) and net balance.

Pentaho

(PDF, Excel, CSV)

HTML

Office, Start Date, End Date

Accounting

It provides list of GL accounts (Assets, Liabilities, Equities, etc.) and the remaining balance in each account at a given date under the specific office.

Pentaho (PDF, Excel, CSV)

HTML (table)

Office, End Date

Accounting

For a given office and duration, this report shows list of GL accounts with their debit and credit records.

Pentaho

(PDF, Excel, CSV)

HTML

Office, Start Date, End Date

Accounting

For a given office GL account, it lists all other GL accounts which made debits and credits transactions with that GL account for a specific duration.

Pentaho

(PDF, Excel, CSV)

HTML

Office , GL account number, Start Date, End Date

Client Savings Summary

Savings

For a given Savings Product and Office, it lists a client-wise summary of each savings account (Balance, Activation Date, etc.) for a specific duration.

Pentaho

(PDF, Excel, CSV)

HTML

Office, Savings product, Start Date, End Date

Savings

For a given office, it lists all the savings accounts which are in dormancy state.

CSV

Office, Savings Account Dormancy status

Organization

For the given teller and cashier, it displays Cash Allocated vs Cash Settled, Cash-ins (Ex: Repayment) and Cash-outs (Ex: Loan Disburse, Savings Withdrawal).

Pentaho

(PDF, Excel, CSV)

HTML

Office, Currency, Teller, Cashier, As on Date

PreviousStandard Reports Shipped in Mifos XNextCustom Reports

Last updated 5 years ago

Was this helpful?

l

Active Loans
-Details
Active Loans Summary
Active Loans By Disbursal Period
Active Loans in Last Installment
Active Loans in Last Installment (Summary)
Active Loans Passed Final Maturity
Active Loans Passed Final Maturity Summary
Aging Detail
Aging Summary (Arrears in Months)
Aging Summary (Arrears in Weeks)
Branch Expected Cash Flow
Expected Payments By Date - Basic
Loans Awaiting Disbursa
Loans Awaiting Disbursal Summary by Month
Loans Pending Approval
Obligation Met Loans Details
Obligation Met Loans Summary
Portfolio at Risk
Portfolio at Risk by Branch
Rescheduled Loans
Txn Running Balances
Written-Off Loans
Client Loans Listing
Client Listing
Funds Disbursed Between Dates Summary
Funds Disbursed Between Dates Summary by Office
Income Statement
Balance Sheet
Trial Balance
General Ledger Report
Savings Account Dormancy Report
Daily Teller Cash Report