Database Detective: South Africa Edition

15 March 2011 at 05:36 9 comments

By Alexis Ditkowsky, KF14, South Africa

Taking a break from repayment reporting at Kruger National Park over the weekend

I realize your interest may be waning based on the title alone but I encourage you to keep reading because not everything a Kiva Fellow does is as wild and crazy and emotionally rewarding as a borrower visit. But, as a Kiva Fellow, I aim to please so I’ve also included pictures from a recent trip to the field at the end of this post. Now there’s something for everyone – for those of you who want to geek out a little, I’ve got you covered, and for everyone else who just wants to be transported to South Africa for a minute in the middle of the workday, you’re taken care of, too.

So, let’s talk briefly about repayment reporting. It’s an essential part of Kiva’s relationship with its microfinance partners. Each month, the partner MFI reports all the cumulative principal repaid* for its outstanding Kiva loans. Then Kiva reviews the report and accounts are balanced by the end of the month. Getting this right and setting up systems so that it’s as pain-free as possible in the future is particularly important for pilot partners like Women’s Development Businesses (WDB). Until an MFI gets a handle on the process, they are unable to transition into an active partnership with Kiva, which typically involves a dramatic increase to their monthly fundraising limit.

You’d think (and hope) that you could just tell the database that tracks your clients and their loan repayments (or Management Information System – MIS – in microfinance speak) that you want a report for all the cumulative principal repaid for all Kiva loans during a specific time-frame. That sounds pretty easy, right? Well, there are a number of reasons why it can take a little time for the MIS to be well-oiled Kiva reporting machine.

That’s where the database detective work comes in. With the generous help of Nomsa, a WDB staff member in Nelspruit, we methodologically cross-checked the MIS, the MIS repayment report, a second MIS Kiva report in a different format, Kiva’s system, and the expected repayment report from Kiva for the previous month. I’m happy to report that after two full days, I think we finally have a handle on the issues. Some of discrepancies are due to “quirks” in the system that require additional follow-up with the database consultant, others have to do with the challenge of adding a new loan product (“Kiva loans”) and how the MIS recognizes it, and another one or two will require additional investigation. That said, we have a pretty solid understanding of where the pain points are and a plan for addressing them in time for next month’s repayment report.

While I’m confident that WDB is on the right track with repayment reporting, I might just need to come up to Nelspruit again in April. My husband and I only spent an afternoon at Kruger National Park and while the hyena cubs were awesome, I have yet to see lions in the wild….

*Loans from Kiva lenders are “interest-free” which means that MFIs only need to report on the principal repaid. There is generally an “effective interest rate” of 1-2% for the MFI which reflects the time, resources, and expense of maintaining the Kiva partnership but Kiva loans are typically a cheaper source of capital than commercial loans and a more sustainable source of capital than grants.

Alexis Ditkowsky (KF14) works with Women’s Development Businesses in KwaZulu-Natal, South Africa. Check out WDB’s lending team and stay tuned for new loans on their lending page.

Previous posts by Alexis Ditkowsky:
Update from the Field: Carnival, Collaboration + Cheese-Making
Update from the Field: Man’s Day, Singing Fellows + Learning How to Count
The Meaning of “Now” in South Africa
Update from the Field: Videos, Epic Commutes + Going Beyond Microfinance
Last Week in the Field: “Christmas”, Trekking, Adversity + Good Company
Next Steps for Kiva’s Partner in South Africa
First Borrower Visit (Take 350+)
A Hand-Delivered Kiva Fellow
Drawings from Training and Greetings from Boston

Part 2: Visit to the Field
As promised, photos from my recent visit with Gugu Lungile Khanyile in Mtubatuba, KwaZulu-Natal. During our interview, she impressed me with how seriously she approached her businesses of renting event supplies and raising chickens. Both are profitable but she sees a lot of room for future investment provided she can raise enough capital to purchase the supplies she needs. For example, she bought a package of 1 tent, 4 tables, and 200 chairs for ZAR 22,000 after receiving funds from a previous employer. She can rent these for ZAR 750 for local events and ZAR 800 for outside events but is unable to buy an additional tent at the moment due to the expense. She spent her Kiva loan to buy more chicks and to buy supplies to decorate the tents when she lends them out. If you have any questions about her businesses, let me know in the comments and I’ll try to answer them!

Gugu calls to another member of her solidarity group to join us for the interview

Gugu's home and event supply storage room

Feed for the chickens

Gugu holds the print-out of her Kiva loan in front of her home

Another view of Gugu's home. The chicken coop is just out of sight on the far left.

Laundry drying in the afternoon sun

Entry filed under: Africa, blogsherpa, KF14 (Kiva Fellows 14th Class), South Africa, Womens Development Businesses (WDB). Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , .

Death By Fire Get into the groove


  • […] from the Field: Beaches, Safaris + Cambodian Glamour Shots Photos from KwaZulu-Natal, South Africa Database Detective: South Africa Edition The Meaning of “Now” in South Africa Next Steps for Kiva’s Partner in South Africa First […]

  • […] + Tuck Shops: Corner Stores in South Africa Photos from KwaZulu-Natal, South Africa Database Detective: South Africa Edition The Meaning of “Now” in South Africa Next Steps for Kiva’s Partner in South Africa First […]

  • […] + Tuck Shops: Corner Stores in South Africa Photos from KwaZulu-Natal, South Africa Database Detective: South Africa Edition The Meaning of “Now” in South Africa Next Steps for Kiva’s Partner in South Africa First […]

  • […] when we’re not trekking for miles we’re doing elaborate calculations or dealing with databases and reporting. In truth, it’s all a front for an extended holiday from our regular lives. You thought our […]

  • […] of previous posts by Alexis Ditkowsky: Database Detective: South Africa Edition The Meaning of “Now” in South Africa Next Steps for Kiva’s Partner in South Africa First […]

  • […] Database Detective: South Africa Edition Country: South Africa / Fellow: Alexis Ditkowsky (KF14) For those of you who like reading about databases and reporting, Alexis has you covered. For everyone else who wants to visit a borrower, learn about her business, and look at lots of pictures, you’re taken care of, too. […]

  • 7. EB  |  16 March 2011 at 05:34

    Great post, and love the photos!!

  • […] from a database. You can read all about it in my current post on the Kiva Fellows blog – Database Detective: South Africa Edition – and you can also check out my weekly round-up of what all the other Fellows have been up to […]

  • 9. Li-Anne  |  15 March 2011 at 08:24

    Hi there

    My name is Li-Anne, and I find your blog rather entertaining and insightful.

    Accordingly, I was wondering if you would like to make a mention of a competition we are running – which I think your readers, and you might find very intriguing: A free holiday into Africa – who wouldn’t want? I sure could do with a little getaway – all expenses paid – know what I’m saying?

    The details are all in the link below:

    Should you have any other queries – please don’t hesitate to ask me.

    thanks for your time – have an awesome day further!

    Safe travels!

Get Involved!

Learn more about this blog and about Kiva Fellows


Apply to be a Kiva Fellow

Enter your email address to receive notifications of new posts by email.

Join 1,348 other followers


Drawing from the Field

Kiva Blog Policy

%d bloggers like this: