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
>
------------------------------------------------------------------------------
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