What is in the pipeline?
Count applications and requested principal by status and officer.
Review the application pipeline, decisions, letter of credit exposure, drawings, the loan book and arrears.
This quarter
How far records got this quarter
| Stage | Reached | Step | |
|---|---|---|---|
| Draft | 36 | ||
| Submitted | 18 | 50% | |
| Under review | 10 | 56% | |
| Approved | 7 | 70% |
Sample totals per stage
Count applications and requested principal by status and officer.
Count decisions by approver and outcome, with reasons.
Total letter of credit limits by applicant and status.
Compare drawings with each credit's limit.
Compare installments due with allocated repayments by loan.
List delinquent loans with principal disbursed.
Count loan applications and total requested principal USD by Status and Owner.
Count review decisions by Reviewer, then by Decision, with reasons.
Total limit USD on letters of credit by Applicant, then by Status.
For each letter of credit, total credit drawings amount USD against limit USD, then each drawing by bank decision.
List Issued and Amended letters of credit by expires at.
Total approved principal USD and principal disbursed USD on loan accounts by Status.
For each loan, compare repayment schedules principal, interest and fee due with repayment allocations, by due date.
List Delinquent loan accounts with principal disbursed and the oldest unpaid installment.
Count loan changes by change type and effective date month.
List operation receipts in Pending, Failed or needs review by Action with failure reason.
Start free, then use Proto to change fields, steps and approvals before your team goes live.