Sorry for the delay. This is what I sent to Gerard (as summarized by Charmaine, and my thanks again).
Portfolio Tools
Search Tools for Lending
Long-needed changes to the LEND page search and sorting capabilities should be implemented and propagated to My Portfolio and all other pages (See All Loans from This Field Partner, Journals,...) as appropriate. The changes made to improve searches for new loans would thus carry over into managing large portfolios and the journals. These changes would include the ability to …
--- Save and reuse sets of sorting, filtering, and search options. (mentioned several times)
--- Modify the options in effect and, if desired, save the new options under the same or a different name.
--- Establish default sets of options for each type of page to be in effect at login.
--- Search using multiple AND/OR/NOT criteria.
--- Sort on multiple fields, whether user fields, the current “Find loans” fields, or column headers.
--- Sort individual fields (entrepreneur, activity, country, partner, loan term, start date), even if they are displayed in the same column.
--- Filter the loans to be displayed by combinations of values including status, gender, sector, region, activity, country, partner, loan amount, loan term, group and individual loans, risk rating, currency exchange loss, and language. Check-box lists, ranges, etc. would be used as appropriate and would be stored as part of saved option sets.
Repeat lending: I would like to have a warning when an entrepreneur comes back again for a new loan.
Sort Tools for Portfolio
The ability to use hierarchical sorts -- that is, sort first by active status and then by date I loaned.
** (I believe this is scheduled to be fixed) the entire portfolio could be sorted, not just the page I was looking at. This was extremely useful, especially when I wanted to see all my loans sorted by country. Not just sorting the page you are on.
The ability to sort by date I lent to a borrower. If that isn't possible, I would like to be able to put the loans in order by date posted, date funded or business ID - something that would resemble the order I lent to them in.
A minimum of two searchable and sortable fields into which the lender can enter data for his loans should be provided. These could be used to establish personally meaningful categories and to make free-form notes.
--- Correctly sort numeric fields (loan term, start date).
Bookmark/Wishlist
Bookmark/Wishlist function on the loan/business pages, either to go into your shopping basket at 0$ thus not tying it up for someone else, or a separate listing.
Another idea would be to add a button to both the sorted listing pages and to the loan description; "Add to Wish List". Then a link to "My Wish List" would produce a list of loans in the usual format with the usual sorting options but containing only the loans in the wish list. The "Add to Wish List" button would show up as "Remove from Wish List." One could go from there to lend in the usual way. It might be a bit cleaner than having a mixture of $0 and $25 loans in the basket. It would also be a way to quickly produce a shortened list of possibilities that one might wish to investigate more deeply. For example, I might decide to fund 4 loans, but I may preselect 10 that look initially interesting, and then pare down the list.
Transaction/Loan stats
When a loan defaults, I would like to see a transaction posted showing the balance of my loan being written off.
Since it is “My Portfolio” I would like to see a totaling of the amount I have outstanding on each loan, which together with my available credits would constitute the actual total of My Portfolio.
Since I think the Transaction History is a necessary part of portfolio management, I think the loan ID (or business ID) should be a separate field there as well so you could sort by specific loan. (Right now it is only in the description of the transaction, so extracting it to be able to aggregate all transactions on the same loan is extremely difficult.)
The lender should be able to see a repayment schedule, similar to that for an individual loan, giving the expected payments by month for his portfolio, and the actual payments for the current month. If date ranges were supported, expected and actual payments for prior months could be shown. Perhaps this should be expandable to show the individual expected payments.
Portfolio Statistics
A chart/graph on one's lender page with the percentage of loans by country, sex, field, etc to show up on the Portfolio page as well, preferably with a way to display those statistics for each category of loan (fundraising, paying back, repaid, etc).
Ability to see a breakdown of what percentage of my active portfolio is subject to currency risk would like to see an actual count of loans to each country instead of only a percentage.
As Kiva accumulates historical data, it becomes less and less acceptable to report only totals since inception. Data should be reportable by periods. Lenders need, for example, to be able to display contributions made this year and to determine current values for field partner default rates and currency losses. Standardized periods (multiyear annual, last twelve months by month, year-to-date, past 30/90/365 days) are probably acceptable. Among the data that should be reportable by date range are …
--- My Portfolio (including My Loans, the Me and Average Kiva User values in My Impact, and the Me and Average Kiva User values in My Loan Statistics) and similar reports.
--- Statistics on the Field partner pages.
The lender needs to be able to see his own portfolio distribution in a more straightforward manner. His personal display should …
--- Reflect any date range limits in effect.
--- Allow reporting only on active loans and on outstanding balances. This is particularly important in that it would allow the lender to determine the dollar amount currently at risk for F/X losses.
--- Display dollar amounts, percentages by dollars lent, and percentages by number of loans.
--- Include additional breakdowns by region, partner, risk rating, currency risk, and any specified user-defined fields.
--- If provided on the Loans report, reflect only the loans displayed based on the date ranges in effect and the category (All, Fundraising, …) selected; otherwise, reflect the date ranges in effect and separately provide breakdowns for the active loans.
Misc
Exporting: The loan export file should include data on all fields at a level of detail comparable to that provided through the XML interface. Each field should be a separate column (although existing columns might be preserved so as not to break reports that lenders may have developed). Transaction exports should include data on losses and an indication of a loan’s termination and its final status. Changes to export formats should be announced in advance and sample data covering all cases should be provided in advance for download and testing.
Journals: I would also like it if there was a separate area where journal entries were listed. Right now there is the "Some News for You" area, but if you are in a few groups, the group messages drown out the journal entries you receive. I know this is not a priority, since we do get emails notifying us of journal entries, but it would be nice if there was a separate link, like for "My Messages," but where you can find a listing of all the loans you have made which have journal entries.
Ian's spreadsheet has numerous enhanced tools which should be incorporated into the website itself as much as is feasible.
The words are misleading. When I log in, what I really am getting to is [should be labeled] "My Profile". Then when I click on "Loans" I am finally getting to [what should be labeled] "My Portfolio."