That is very interesting.  Did you also have a script to load the
groups / clients data or was that done manually?
Are the template available?

Thanks for sharing,
Gayl

On 09/07/2010, Sam Birney <[email protected]> wrote:
> Hi Natu,
>
> (sharing with the mifos-users list in case it helps others or anyone else
> has suggestions)
>
>>Did you do the open balances automatically  automatically ? If yes what was
> your approach.
>
>>
> We exported the principal remaining on the loan and the interest remaining
> on the loan as two separate values.  Then the script entered the remaining
> principal as the loan amount in mifos and used a formula to calculate the
> effective interest rate for the remaining loan.  The formula, for flat
> interest for monthly loans, was:
>
> (((remaining interest) / (remaining principal)) * 12 * 100) / (installments
> left)
>
> So, for example, let's say there was a 12 month loan of $1200 with 10% flat
> yearly interest.  So each payment should be $100 principal + $10 interest.
>  Let's say the client has already made 3 repayments.
>
> So the script would enter a 9-month loan in Mifos with an amount of $900 and
> use this formula to enter a calculated interest rate of 13.3333333333%.
>  This should result in a schedule that correctly has 9 payments left each
> with $100 principal and $10 interest.
>
> This is the basic idea.  We enhanced it to handle clients who were overdue
> by using the formula above on the scheduled amounts remaining, and then
> adding fees for any interest and principal that was already overdue.
>
> So, in the example above, let's say the client had only made 2 payments out
> of the 3 that were due.  We would still calculate the migrated loan as if 3
> payments had been made, so that the schedule matches the old schedule, then
> we would add a $100 "overdue principal" fee and a $10 "overdue interest" fee
> as the script enters the loan.
>
> Similarly, some clients were already ahead on their future payments.  We
> still calculated the migrated loan in the same way, based on scheduled
> amounts, but then the script applied a payment to the loan, after approving
> it and disbursing it, to reflect what had already been paid in advance.  So
> if the client above had made 4 payments even though only 3 were due, the
> loan was the same, but then the script applied a payment of $110.
>
> So, to do this approach you need to export these fields from the existing
> data:
>
> * scheduled principal remaining
> * scheduled interest remaining
> * total principal remaining
> * total interest remaining
> * number of installments remaining
>
> And if you have any clients with outstanding fee or penalty amounts, you can
> also export these fields and have your script apply them to the migrated
> loan.
>
> Sam
>
> On Thu, Jul 8, 2010 at 6:02 PM, Natu Lauchande <[email protected]> wrote:
>
>> Hi Sam,
>>
>> Thank you very much for your answers. I still have some questions on the
>> answers that you gave.
>>
>>
>> On Thu, Jul 8, 2010 at 10:01 AM, Sam Birney <[email protected]> wrote:
>>
>>>
>>> Hi Natu,
>>>
>>> it was successful using selenium for data migration.  For your questions-
>>>
>>> * backdate payments -- the approach we chose was to only migrate opening
>>> balances (no historical payments).  So, if the loan was $1000 and $300
>>> was
>>> already paid, then we created a migrated loan for $700, and we marked in
>>> the
>>> "historical data" page that the original loan was actually $1000.
>>>
>>> Did you do the open balances automatically  automatically ? If yes what
>> was your approach.
>>
>>> * meeting schedules -- we used "Loan Schedule Independent of Meeting
>>> Schedule" (LSIM) configuration
>>>
>>> * mandatory fields -- when we did not have data to migrate for some
>>> fields, we tried to make them non-mandatory for migration (and then set
>>> them
>>> back to mandatory for data entry of new loans where desired).  Where that
>>> was not possible, we just had the selenium script enter "N/A" or "X".
>>>
>>> hope this helps,
>>> Sam
>>>
>>> Regards,
>> Natu
>>
>


-- 
Regards
Gayl

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to