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
