Kiva Loan Detail Lookup

This little lookup tool was proposed by a Kiva Microfinance Portfolio Manager (MPM) to help overcome an issue with the way that loan statuses were updated in Kiva's billing system. Taking in one parameter, the Kiva Loan Id, this form will return the date of the final scheduled payment. If this date is in the past, the date appears in green. This is to indicate that the borrower is eligible for another loan. If, however, the date is in the future, meaning that the borrower is still making payments, then this date is returned in red. In this case, two other bits of information are also included, the last payment amount and the loan amount in the local currency. To try it out click here.

Here is how to use this

All you have to do to use this is copy and paste this stuff into a web page or even a blog.

         <embed type="application/x-shockwave-flash" 
                src="http://adampreston.com/code/kiva/KivaLoanDetail.swf" 
                width="416" height="220" 
                pluginspage="http://www.macromedia.com/go/getflashplayer">
        </embed>

Oh, and by the way

Here is the original request:

Basically, it’s a tool that would allow a volunteer to enter in a Kiva Loan ID & then would return:

The date of the last repayment for the loan per the ENTREPRENEUR’s schedule, not the Kiva schedule. The last reported repayment for the loan What is happening now is that a loan often times will still be considered ‘Paying Back’ on Kiva’s site even though the borrower has finished paying off the loan to the MFI. This is a quirk of Kiva’s system because of our billing system. The issue that this creates is that sometimes our editors will flag a repeat loan as having an issue because they see that the borrower’s first loan is still ‘paying back’ (according to Kiva’s systems) when in actually the borrower has finished paying off their first loan. Currently, it is somewhat burdensome for our editors to verify this information as they have to dig into the borrower’s page. Plus, editors don’t have access to what an MFI reports for a loan so for loans that have been pre-paid by an entrepreneur they would still show up as “paying back” and looking at the last payment date of the loan would not help.

Figured a simple look like the one below I mocked out would really help the editors out as they wouldn’t have to go looking through the first loan for this information as well as give them access to what MFIs are reporting for their loan so they avoid accidentally marking a loan as an issue when it actually it’s not an issue. Anyways, let me know if you think this is possible.