Standard Reports Field Descriptions
| Report Name | Category | Description | Format | Parameters |
|---|---|---|---|---|
| Active Loans - Details(Pentaho) (1).pdf | 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 |
| screenshot-54.251.105.50-2017-01-02-13-41-19.png | Loan | Based on each branch a summary of the total clients, # of active loans, # in 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 |
| Active Loans by By Disbursal Period | 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 |
| Active Loans in Last Installment | Loan | List of active loans on their last installment as of day report is generated listing original loan details, expected maturity date as well as principal, interest, fees, and penalties outstanding | Pentaho (PDF, Excel, CSV) HTML | Office, Currency, Fund, Loan Purpose, Loan Officer, Product |
| Active Loans in Last Installment (Summary) | Loan | List of active loans on their installment as of day of report summarized by branch including # o clients, # 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 |
| Active Loans Passed Final Maturity | Loan | It shows list of clients with their loan details like Disbursed Date, Expected Maturity Date, which have already passed the maturity date. | Pentaho (PDF, Excel, CSV) HTML | Office, Currency, Fund, Loan Purpose, Loan Officer, Product |
| Active Loans Passed Final Maturity Summary | Loan | It shows number of loans with arrears(if any) with their details which have already passed maturity date. | Pentaho (PDF, Excel, CSV) HTML | Office, Currency, Fund, Loan Purpose, PAR calculation |
| Aging Detail | Loan | Under specific office, Aging Detail provides 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 Prinicipal, Original Interest, Principle Paid, Interest Paid, Principle Overdue and Interest Overdue | Pentaho (PDF, Excel, CSV) HTML | Office |
| Aging Summary (Arrears in Months) | Loan | Under specific office, Aging summary provides number of loans which are arrears in days(or on Schedule) with mentioned currency type. | Pentaho (PDF, Excel, CSV) HTML (table) | Office, Currency |
| Aging Summary (Arrears in Weeks) | Loan | Under specific office, Aging summary provides number of loans which are arrears in weeks(or on Schedule) with mentioned currency type. | Pentaho (PDF, Excel, CSV) HTML | Office, Currency |
| Branch Expected Cash Flow | 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 Disbursals) and 'Net Expected Cash Out'. (Expected Cash Out ~ Expected Cash In). | Pentaho (PDF, Excel, CSV) HTML | Office, Start Date, End Date |
| Expected Payments By Date - Basic | Loan | For the all the clients under specific office, it shows Principle/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 |
| Loans Awaiting Disbursal | Loan | It shows 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 |
| Loans Awaiting Disbursal Summary by Month | Loan | It shows list of loan products which are awaiting for disbursal at each month. It also shows Principle Amount which is to be disbursed. | Pentaho (PDF, Excel, CSV) HTML (table) | Office, Loan Purpose, Fund, Currency |
| Loans Pending Approval | Loan | It shows list of clients and details of their loan accounts which are not yet approved. | Pentaho (PDF, Excel, CSV) HTML | Office, Loan Purpose, Fund, Currency |
| Obligation Met Loans Details | Loan | For the given duration, this reports shows list of loans with the details 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 |
| Obligation Met Loans Summary | Loan | This report shows number of loans with their details (ex: total principle/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 |
| Portfolio at Risk | 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 |
| Portfolio at Risk by Branch | Loan | This is similar to previous one but lists portfolio at risk by branch offices. | Pentaho (PDF, Excel, CSV) HTML | Office, Loan Purpose, Fund, Currency, PAR calculation |
| Rescheduled Loans | Loan | This report shows list of all rescheduled loans with their details(like, written-off date, disbursed date, Rescheduled Principle/Interest/Fees, branch-wise. | Pentaho (PDF, Excel, CSV) HTML | Office, Currency, Start Date and End Date |
| TxnRunningBalances | Loan | This report shows 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 Principle and Interest Income with specified currency and loan product. | Pentaho (PDF, Excel, CSV) HTML | |
| Written-Off Loans | Loan | It shows list of all the loans which are written-off at a given duration. | Pentaho (PDF, Excel, CSV) HTML | Currency, Office, Start Date, End Date |
| Client Loans Listing | Clients | It shows list of the 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 |
| Client Listing | Clients | It lists all the clients for particular branch, Account Number, Client Status, Activation Date, External Id. | Pentaho (PDF, Excel, CSV) HTML | Office |
| Funds Disbursed Between Dates Summary | Funds | At a given duration, it lists all the funds which are disbursed with their currency type. | Pentaho (PDF, Excel, CSV) HTML | Currency, Fund, Start Date, End Date |
| Funds Disbursed Between Dates Summary by Office | Funds | At a given duration and branch office name, it lists all the funds which are disbursed with their currency type. | Pentaho (PDF, Excel, CSV) HTML | Currency, Fund,Office, Start Date, End Date |
| Income Statement | 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 |
| Balance Sheet | 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 |
| Trial Balance | 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 |
