1

Management

Loan Officer Details Report

Lists all details of a LO such as # of clients recruited, total loan portfolio outstanding, PAR, etc

Helps to assess performance of an LO and any changes that need to be made

Most likely Monthly

Primary - Branch Manager
Secondary - HO

Everyone

Loan Officer Reports

No

DW

Released

1.3

Yes

2

Management

MFI Progress Report

Gives various metrics and % change over periods of time to indicate progress

Determine progress at various office levels (HO down to BO)

Monthly to Yearly

Primary - HO
Secondary - Branch Manager if run at BO level

Everyone

Performance

No

DW

Released

1.3

Yes

3

Operations

Due vs. Collected Reports by LO

Lists what was collected for per day from the branch / LO versus what was expected

Helps Branch Manager to see what was expected versus actuals for each of his LO's, and HO to see what happened per LO

Weekly

Primary - Branch Manager, LO

Light, Digamber, Nirantara

Collection Sheets

No

DW

Released

1.3

Yes

4

Operations

Due vs. Collected Reports by Branch

Lists what was collected for per day from the branch / LO versus what was expected

Helps Branch Manager to see what was expected versus actuals for each of his LO's, and HO to see what happened per branch

Weekly

Primary - HO, or Branch Manager

Light, Digamber, Nirantara

Collection Sheets

No

DW

Released

1.3

Yes

5

Operations

Balance Outstanding by Source of Funds

Amount of loans per funder

Determine how much of loans go to each source of fund, and loan outstanding amounts

Monthly

Primary - HO

Adhikar

Funder

No

DW

Released

1.3

Yes

6

Management

Funds Movement Report

Loans per loan fund with category

Ad hoc, Monthly

Branch Manager

Africa

Funder

No

DW

Released

1.3

Yes

7

Operations

Loan Officer Performance Summary Report (cumulative)

Lists all LO's in a branch and their performance details

Branch Manager or HO can compare performance among LO's

Monthly

Primary - Branch Manager
Secondary - HO

RiSE

Loan Officer

No

DW

Released

1.3

Yes

8

Operations

Loan Officer Performance Summary Report (during period)

Lists all LO's in a branch and their performance details

Branch Manager or HO can compare performance among LO's

Monthly

Primary - Branch Manager
Secondary - HO

RiSE

Loan Officer

No

DW

Released

1.3

Yes

9

Operations

Loan Classification by Product

Information per loan product such as amount disbursed, # of loans disbursed, PAR, etc

Compare performance of each loan product

Monthly

Primary - HO

Loans and Savings

No

DW

Released

1.3

Yes

10 

Operations

Due vs. Collected Reports by Center

Lists what was collected for per day from the center versus what was expected

Helps Branch Manager to see what was expected versus actuals for each of his LO's, and HO to see what happened per center

Weekly

Primary - Branch Manager

Light

Collection Sheets

No

DW

Released

1.3

Yes

11 

Operations

Balance Outstanding

a list of all accounts showing balances- could be run either for loans or savings or by product.
Show summary by product and account type (ie loan/savings). Can also run by Loan officer to see portfolio per LO. Include filter for account status so could see inactive savings as well as active.

Monthly

Branch Manager

Africa

Loans and Savings

No

DW

Released

1.3

Yes

12

Management

PPI Data Dump

exports all clients with PPI data, their scores and likelihoods

HO

Everyone

PPI

No

DW

Released

1.3

No

13 

Operations

Mifos Transactions - Detailed

Report to show transactions posted for a certain period

Daily

Branch Manager, Cash Officer

Africa

Accounting

No

Prod Schema

Released

1.3

Yes

14

Operations

Mifos Transactions - Summary

Report to show transactions posted for a certain period

Daily

Branch Manager, Cash Officer

Africa

Accounting

No

Prod Schema

Released

1.3

Yes

15

Operations

Branch Expected Cash Flow Report

Lists expected cash for following period in and out

Helps determine where/when cash should go to branches, and also for long term investment of idle cash

Daily / Weekly / Monthly

Primary - HO, Regional Managers, Branch Manager

Nirantara

Accounting 

No

Prod Schema

Released 

1.3

Yes

16 

Operations

Center Collection Sheet

update collection sheet for India with centers

Weekly

Loan Officer

India

Collection Sheets 

No

Prod Schema 

Released

1.3

Yes

17 

Operations

Group Collection Sheet (MPESA) 

collection sheet used for the group meetings. To show amounts due and amounts paid

Weekly

Loan Officer

Africa, KEEF

Collection Sheets 

No

Prod Schema 

Released

1.3

Yes

18 

Management

Client Exit Report

list of group clients exited from group

Monthly , Ad Hoc

Branch Manager, LO

Africa

Clients, Groups, and Centers

No

Prod Schema

Released

1.3

Yes

19

Operations

Loans Pending Approval

a list of loans in the pending approval stage. could be used by credit committee to see all loans pending approval.

Daily / Not Same Day

Branch Manager, LO

Africa

Africa Standard Reports Folder

No

Prod Schema

Released

1.3

Yes

20 

Operations

Loans To Be Disbursed 

a list of loans in the approved and applied loans stages to monitor all loans pending disbursement

Daily / Not Same Day

Branch Manager, LO

Africa

Africa Standard Reports Folder

No

Prod Schema

Released

1.3

Yes

21

Operations 

Center Schedule by Loan Officer 

Lists each loan officer's schedule 

Helps for LO to plan the week