Margill Loan Manager – Ageing report – with refinanced loans

/in /by

Q: If a loan was refinanced and the payments revised based on the refinanced balance, can the loan account still be in arrears?  Doesn’t the refinancing and revised payments take into consideration any prior arrears? 

A: Arrears are always a little tricky with refinanced outstanding amounts since a human must take a decision as to whether the new payments to be added are simply extra payments or are to compensate for the unpaid payments in the past. The examples will help…

A most important column in the schedule is the “Expected Pmt” column. This column indicates how much was expected for this line and subtracts the actual payment amount from this amount to generate the Outstanding amount.

  • On 07-06-2018 I was expecting 439.58 and got a 439.58 payment so Outstanding = 0.00.
  • On 10-06-2018 I was expecting 439.58 and got 0.00 so Outstanding = 439.58 and so forth

If an extra payment (unexpected in the normal scheme of things) is made, then the Expected Pmt should be 0.00 and the Outstanding is thus reduced.

If a loan is refinanced, you must make sure that as of this moment, your Outstanding amount gets progressively reduced to 0.00 and you do this with the Expected Pmt column in which you would put the Expected Pmt to 0.00 for the new payments that are added or changed to give 0.

In the above example, the loan is refinanced with lower payment amounts since the 439 was too high for the borrower – 6 payments were added and these now become 175.20 to reach 0.00. One could argue that these payments are extra and thus the Expec. Pmt should be 0.00 for each, so we manually change the Expect. Pmt to 0.00.

NOTE: In order to be allowed, to change the Expected Pmt amount, this must be allowed by the Margill Administrator in Settings:

As these new payment become paid over time, the Outstanding amount gets reduced…

If on the other hand, a second amount (new Advance) was lent to the borrower and extra payments were added, then I would not change my Expected Pmts to 0.00 since these new payments become part of the normal payments, in the normal scheme of things. So Outstanding is quite subject to interpretation…

I actually cheated below by entering 3 of the 12 new payments with Expected Pmt of 0.00 to bring my Outstanding back to 0.00. Outstanding must be 0.00 or greater, never less than 0.00 even if one could argue the borrower overpaid.

Automatic Margill Loan Manager emails – Gmail managed emails (G Suite / formerly Google Apps) are blocked

/in /by

Q: I have set up automatic emails in Margill Loan Manager. We use G Suite for these but when I test the email connection if get a message saying the Google blocked the app since it is a less secure app. What can be done?

A: We see this once in a while when using GSuite.

Margill has no control over this since Margill simply sends a request to the Gmail (or other) SMTP server and this server checks your User name and Password and accepts to send the email or not. Pretty straightforward stuff, no big technology behind this…

However, GSuite or other mail providers may not accept the communication since it is sent by a software that they do not recognize and may give you a message such as:

You will thus have to allow your email account to communicate with Margill. Log into the G Suite Admin Console (https://gsuite.google.com). You must be the G Suite administrator. Go into security settings and click “Allow users to manage their own access to less secure apps”. Then go into your own Gmail settings and turn on the “Allow access to less secure apps (not recommended)”. Google will tell you a number of times that this is unsafe.

This should now allow the communication.