Transaction Entry consists of

• Loan Issue

• Automatic Calculation of EMI

• Loan Recovery

Portfolio Tracking System Transaction Entry

Loan Issue

• It includes the loan issue details such as loan Issue Date, Loan Amount, Number of     Installments, Interest Rate, Subsidy, Service Charge, Installment Start Date, Group     name.

• Journal entry is automatically passed to the financial accounting system. Automatic    Calculation of EMI

• EMI stands for Equated Monthly Installment.

• EMI includes Principal and Interest amount to be    paid by the loan receiver for each     installment.

• Loan Recovery Details

• It includes the loan recovery details such as Installment Number, Principal and Interest    amount collected, Date of amount received.

• System also allows for Interim payments.

• Journal entry is automatically passed to the financial
     accounting system.

Reports consists of

• Loan Utilization Statement

• Loan Master Report

• Repayment Schedule

• Loan Distribution Statement

• Loan Distribution Summary Report

• Loan Status Report

• Monthly Demand Statement

Reports (continued)

• Monthly Demand and Recovery Statement

• Interim Payment Statement

• Bank Statement

• New Groups

• Closed Groups

• Completed Loan Details

Portfolio Tracking System Reports

Purpose of Loan Utilization Statement

• This statement is prepared by the branch and issued to the head office for sanctioning the total loan amount.

Purpose of Loan Master Report

• Provides full details of the Loan issued to a group.

Portfolio Tracking System Reports

Purpose of Repayment Schedule

• It includes Installment Number, Installment Due Date, Installment Amount (Principal & Interest Amount)
• It is given to the group member who has taken the loan.

Purpose of Loan Distribution Statement

• It includes Loan Amount, Interest Rate, Number of Installments, Purpose of loan, etc.
• Lists individual loans issued to the groups.

Purpose of Loan Distribution Summary Report

• It includes Loan Amount, Group type, Purpose of loan, etc.
• Lists number of loans issued to the groups.

Purpose of Loan Status Report

• It includes loan amount, collected principal and interest amount and outstanding principal and interest amount.
• Describes loan recovery so far and total outstanding loan amount.

Purpose of Monthly Demand Statement

• It includes Principal and interest amount due, bank account number, bank name etc.
• Lists loan installment due for the month.

Purpose of Monthly Demand and Recovery Statement

• It includes Principal and interest amount due and recovered, bank account number, bank name, etc.
• Lists loan installment due along with recovery for the month.

Purpose of Interim Payment Statement

• It includes loan amount, repaid amount etc.
• Lists any interim payment made by the member.

Purpose of Bank Statement

• It includes group name, account number and Installment amount.
• Lists monthly installment to be collected by the bank.

Purpose of New Groups

• Lists the new groups, along with village, Number of members, bank details etc.

Purpose of Closed Groups

• Lists the closed groups, along with village,closed date etc.

Purpose of Completed Loan Details

• It includes Loan amount, loan issue date, date of last installment, Total Repaid amount including Interest etc.
• Lists the loan with 100% recovery.

Reports can be taken group wise, Date wise, village wise, etc.